The Design And Implementation Of Real-Time SQL

Real-Time SQL (RTSQL) is a standard interface for the users to manipulate and manage the real-time database systems. RTSQL plays an important role in the real-time database systems (RTDB), just as SQL has done in traditional database systems.Compared to the relational database systems, the RTDBs have three distinguishing features: the requirement of temporal constraints on data, the requirement of timing constraints on transactions, and the requirement that certain executions exhibit predictable timing behavior. Query languages support the definition, manipulation, and control of data in a database system. For a real-time database, the query language must be extended to support the expression of timing constraints on both data and actions.This thesis extends SQL92 to support the requirements of the real-time database systems to create RTSQL. The RTSQL includes extensions that specify: temporal constraints on data, timing constraints on execution, bounds on use of system resources for predictability, and flexible transaction structure that relaxes traditional ACID transaction properties to better support real-time requirements.A framework for the implementation of RTSQL is provided in this paper. And a prototype of RTSQL, named Agilor RTSQL, is designed and implemented based on ODBC standard.