A Data Model for Approximate Query Processing of Real-Time Databases

Abstract A real-time system has specific time constraints for the processing of a transaction as well as temporal consistency constraints for its temporal data. If it is not possible to produce an exact answer to a database query within the specified time constraints, for many applications it may be better to produce an approximate answer than to produce no answer at all or to wait for an exact answer and miss a deadline. Approximate query processing can be used to provide approximate answers to database queries for such applications. However, approximate query processing does not address the time dimension of the data. In this paper we extend the theoretical basis of approximate query processing to include the temporal dimension of real-time databases and present a temporal data model for approximate query processing. We describe an approximation that is designed to include the temporal data and address the temporal consistency constraints of a real-time database. We present monotone approximate relational algebra operations that are redefined to include the temporal dimension of the data. We also describe the semantic support of an implementation of an approximate query processor for temporal data that is based on this data model.

[1]  Aaron Watters,et al.  A semantics for complex objects and approximate queries , 1988, PODS '88.

[2]  Albert Croker,et al.  The Historical Relational Data Model (HRDM) Revisited , 1993, Temporal Databases.

[3]  Amihai Motro,et al.  VAGUE: a user interface to relational databases that permits vague queries , 1988, TOIS.

[4]  Richard T. Snodgrass,et al.  Evaluation of relational algebras incorporating the time dimension in databases , 1991, CSUR.

[5]  Arie Segev,et al.  A consensus glossary of temporal database concepts , 1994, SIGMOD 1994.

[6]  Albert Croker,et al.  On the Completeness of Query Languages for Grouped and Ungrouped Historical Data Models , 1993, Temporal Databases.

[7]  Edmund H. Durfee,et al.  Approximate Processing in Real-Time Problem Solving , 1988, AI Mag..

[8]  Joan Peckham,et al.  Semantic data models , 1988, CSUR.

[9]  Ramez Elmasri,et al.  A consensus glossary of temporal database concepts , 1994, SGMD.

[10]  Roger King,et al.  Semantic database modeling: survey, applications, and research issues , 1987, CSUR.

[11]  Jane W.-S. Liu,et al.  APPROXIMATE - A Query Processor that Produces Monotonically Improving Approximate Answers , 1993, IEEE Trans. Knowl. Data Eng..

[12]  Amihai Motro.  Using Integrity Constraints to Provide Intensional Answers to Relational Queries , 1989, VLDB.

[13]  Surajit Chaudhuri.  Generalization and a framework for query modification , 1990, [1990] Proceedings. Sixth International Conference on Data Engineering.

[14]  Wen-Chi Hou,et al.  Processing aggregate relational queries with hard time constraints , 1989, SIGMOD '89.

[15]  Stanley B. Zdonik,et al.  Knowledge-Based Query Processing , 1980, VLDB.

[16]  Z. M. Ozsoyoglu,et al.  Research in time-and error-constrained database query processing , 1990 .

[17]  David Maier,et al.  Readings in Object-Oriented Database Systems , 1989 .

[18]  Dennis McLeod,et al.  Database description with SDM: a semantic database model , 1981, TODS.

[19]  Qiming Chen,et al.  Using type inference and induced rules to provide intensional answers , 1991, [1991] Proceedings. Seventh International Conference on Data Engineering.

[20]  Shashi K. Gadia,et al.  A homogeneous relational model and query languages for temporal databases , 1988, TODS.

[21]  Mark S. Boddy,et al.  An Analysis of Time-Dependent Planning , 1988, AAAI.

[22]  Rajshekhar Sunderraman,et al.  On representing indefinite and maybe information in relational databases , 1988, Proceedings. Fourth International Conference on Data Engineering.

[23]  Shlomo Zilberstein,et al.  Composing Real-Time Systems , 1991, IJCAI.

[24]  llsoo Ahn,et al.  Temporal Databases , 1986, Computer.

[25]  Xiaohui Song,et al.  Performance of multiversion concurrency control algorithms in maintaining temporal consistency , 1990, Proceedings., Fourteenth Annual International Computer Software and Applications Conference.

[26]  Wen-Chi Hou,et al.  Processing real-time, non-aggregate queries with time-constraints in CASE-DB , 1992, [1992] Eighth International Conference on Data Engineering.

[27]  Jane W.-S. Liu,et al.  Scheduling Periodic Jobs That Allow Imprecise Results , 1990, IEEE Trans. Computers.

[28]  J. W. S. Liu,et al.  Monotonically improving approximate answers to relational algebra queries , 1989, [1989] Proceedings of the Thirteenth Annual International Computer Software & Applications Conference.