Conference Paper

Performance Evaluation of a Temporal Database Management System.

DOI: 10.1145/16856.16864 Conference: Proceedings of the 1986 ACM SIGMOD International Conference on Management of Data, Washington, D.C., May 28-30, 1986.
Source: DBLP

ABSTRACT A prototype of a temporal database management system was built by extending Ingres. It supports the temporal query language TQuel, a superset of Quel, handling four types of database static, rollback, historical and temporal. A benchmark set of queries was run to study the performance of the prototype on the four types of databases. We analyze the results of the benchmark, and identify major factors that have the greatest impact on the performance of the system. We also discuss several mechanisms to address the performance bottlenecks we encountered.


Available from: Richard Snodgrass, Jun 03, 2015
  • Source
    [Show abstract] [Hide abstract]
    ABSTRACT: We propose a strategy to manage temporal data which are occurred on scientific applications. Firstly, We define LB and RB to separate temporal data, and entity versions to be stored in past, current, future segments. Also, We describe an algorithm to migrate temporal data with hotspot distribution among segments. The performance evaluation of average response time and space utilization is conducted. Average response time between two methods is similar, and space is saved in proposed method.
    01/2005; 9(4).
  • [Show abstract] [Hide abstract]
    ABSTRACT: Temporal geographic information system (t-GIS) is a kind of computer information system that can display, process and analyze the micro-format distribution of temporalspatial information of real world. It includes both spatial geographic information and temporal information, and can analyze both the static geographic information and the dynamic geographic information. Three models based on t-GIS for environment dynamics, namely, the mechanism method, the experience method and the mixed method are given. t-GIS based on the environment dynamic model has more new functions than traditional GIS, such as fast I/O, inquiry, static/dynamic display and visible analysis of spatial and temporal sequence information, especially it can display the image of the evolution in the past, current and future environment through the extrapolation method within its defining region. The velocity for analogue display can be accelerated by setting up time-varying-area-function for position and attribute. Dynamic environmental information analysis systems based on t-GIS are applicable to almost all the fields related to management, display and analysis of local environmental dynamic information. For this reason, some considerations to construct distinct information systems have been enumerated in this paper, such as, the analysis information system for terrain evolution, the analysis information system for the condition of water and fertilizer of farmland, analysis and the evaluation information system for ecological environment, and the analysis information system for distribution changes of population of China, etc.
    Geo-spatial Information Science 09/2000; 3(3). DOI:10.1007/BF02826607
  • [Show abstract] [Hide abstract]
    ABSTRACT: The importance of temporal data management is evident by the temporal features recently released in major commercial database systems. In Teradata, the temporal feature is based on the TSQL2 specification. In this paper, we present Teradata's implementation approach for temporal query processing. There are two common approaches to support temporal query processing in a database engine. One is through functional query rewrites to convert a temporal query to a semantically-equivalent non-temporal counterpart, mostly by adding time-based constraints. The other is a native support that implements temporal database operations such as scans and joins directly in the DBMS internals. These approaches have competing pros and cons. The rewrite approach is generally simpler to implement. But it adds a structural complexity to original query, which can pose a potential challenge to query optimizer and cause it to generate sub-optimal plans. A native support is expected to perform better. But it usually involves a higher cost of implementation, maintenance, and extension. We discuss why and describe how Teradata adopted the rewrite approach. In addition, we present an evaluation of our approach through a performance study conducted on a variation of the TPC-H benchmark with temporal tables and queries.
    Proceedings of the 16th International Conference on Extending Database Technology; 03/2013