Abstract
Real-time database research has reached a point when a practical approach need to be found to combine academic research fruits with real world problems. It is generally believed that the transaction scheduling principles of the traditional database management is too stringent to meet real-time constraints. In this paper, we look at the real world problem and argue that the future will see the proliferation of federated database consisting of distributed heterogeneous subdatabases. We propose the similarity predicate to unify real-time constraints on applications of the federated database system. We then design a real-time SQL engine that sits between the distributed database and the applications that separates the database design from individual user application. The real-time part of the engine benefits from SQL standard and can be scaled from empty to very sophisticated.
This work is supported by a grant from the Office of Naval Research under grantnumber N00014-94-1-0582.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Functionally Integrated Resource Manger (FIRM) Program, 1993.
James H. Anderson, Srikanth Ramamurthy, and Kevin Jeffay. Real-time computing with lock-free shared objects. In IEEE Real-Time Systems Symposium, pages 28–37, December 1995.
S. F. Andler, J. Hansson, J. Eriksson, J. Mellin, M. Berndtsson, and B. Eftring. Deeds towards a distributed and active real-time database systems. SIGMOD RECORD, 25(l):38–40, 1996.
Azer Bestavros and Sue Nagy. Value-cognizant admission control for rtdb systems. In IEEE Real-Time Systems Symposium, pages 230–239, December 1996.
R. G. G. Cattell. Object Data Management. Addison-Wesley Publishing Company, 1994.
Jen-Yao Chung, J. W. S. Liu, and Kwei-Jay Lin. Scheduling periodic jobs that allow imprecise results. IEEE Transactions on Computer, 39(9), 1990.
Paul J. Fortier, Victor Fay Wolfe, and J.J. Prichard. Flexible real-time sql transactions. In IEEE Real-Time Systems Symposium, pages 276–280, December 1994.
Ramesh Gupta, Jayant Haritsa, Krithi Ramamritham, and S. Seshadri. Commit processing in distributed real-time database systems. In IEEE Real-Time Systems Symposium, pages 220–229, December 1996.
Tei-Wei Kuo and Aloysius Real-time database-similarity semantics and resource scheduling. SIGMOND RECORD, 25(l):18–22, 1996.
Mathew R. Lehr, Young-Kuk Kim, and Sang H. Son. Managing contention and timing constraints in a real-time database system. In IEEE Real-Time Systems Symposium, pages 332–341, December 1995.
Sang H. Son. Advances in Real-time Systems. Prentice Hall, 1995.
Space and Naval Warfare Systems Command. Next Generation Computer Resources, 1994.
Michael Stonebraker. Readings in database Systems. Morgan Kaufmann Publishers, 1994.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1998 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Chen, D., Mok, A.K. (1998). Design of a Real-Time SQL Engine in the Distributed Environment. In: Andler, S.F., Hansson, J. (eds) Active, Real-Time, and Temporal Database Systems. ARTDB 1997. Lecture Notes in Computer Science, vol 1553. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-49151-1_2
Download citation
DOI: https://doi.org/10.1007/3-540-49151-1_2
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-65649-4
Online ISBN: 978-3-540-49151-4
eBook Packages: Springer Book Archive