Abstract
We propose a generalized relational model for a temporal database which allows time stamping with respect to a Boolean algebra of multidimensional time stamps. The interplay between the various temporal dimensions is symmetric. As an application, a two dimensional model which allows objects with real world and transaction oriented time stamps is discussed. The two dimensional model can be used to query the past states of the database. It can also be used to give a precise classification of the errors and updates in a database, and is a promising approach for querying these errors and updates.
- Bo Bolour, A, Anderson, T L, Dekeyser, L j and Wong, H K T The Role of Tame m lnformatwn Processing, A survey SIGART Newsletter, 80, Apnl 1982, pp 28-48 1987, pp 528-~7]] Google ScholarDigital Library
- CC Chfford, J and Croker, A The Hsstomcal Data Model ,(HRDM) an Algebra Based os Lzfespans Proceedings of the third IEEE internatlonal Conference on Data Enganeenng, 1987]] Google ScholarDigital Library
- Ga1 Gadla, Shashl K A Homogeneous Relational Model and Qu.ery Languages for Temporal Databases To appear m ACM-TODS]] Google ScholarDigital Library
- Ga2 Ca&a, Shashl K Toward a Mult~homogeneous Model for a Temporal Database Proceedings of the I~EI~ International Conference on Data Engineenng, 1986, pp 390--,397]] Google ScholarDigital Library
- Ga3 Gadta, Shashl K Weak Temporal Relattons Pro(: Fifth Annum ACM SIGACT-SIGMOD Syrup on Pnnclples of Database Systems, 1986 pp 70-77]] Google ScholarDigital Library
- GV Cadre, ShasM K and Valshnav, Jay A.Quely Language for a Homogeneous Temporal Database Proc Fourth Annum ACM SIGACT-SIGMOD Syrup on Pnnoples of Database Systems,1985 pp ,51--56]] Google ScholarDigital Library
- GY Cadre, Shashl K and Yeung, Chuen-Smg A triple calculus for temporal databases and :ts comparison with TQUEL To appear m informatmn Scmnces]]Google Scholar
- JM Jones, S and Mason, P llandhng the Ttme Dtmenston sn Databases Proc of the International Conference on Databases, Bnhsh Computer Society Umversgy of Aberdeen, july 1980, pp 66--83]]Google Scholar
- Mc McKenme, E Btbhographv Temporal Databases ACM-SIGMOD Record, December 1.~.86, pp 40-52]]Google Scholar
- MS1 McKenzle, E and Snodgrass R. Extending the Relatwnal Algebra to Support Tran~actton Time Proc ACM-SIGMOD Internatxonal Conference on Management of Data, 1987, pp 467--'t78]] Google ScholarDigital Library
- MS2 Tzmc 4rt Jt~toTt, ul ,llqvb, u 'i'cchn~c,d {txport TR87-008, Aug 1c)t~{ ('omputor gc~<ncv 1),,pt lJnlver,uty of North Carohna at Chapel Hilt]]Google Scholar
- MS3 McKen/ae, g and Suodgxass, 1% Scheme Evohttwa aad the Relattonal Alqebra Tech 1%eport, TR87 00t May 1987 Computer Science Dept Umv of North Carolina at Chapel Hdl]]Google Scholar
- NA Navathe, S B and Ahmed, Raft A Temporal Relatwnal Model and Query Language Technlcal Report, 1986, Database System R & D Centci, Un,vetsity of Florida]]Google Scholar
- RS Rotem, Doron and Segev, Ane Physual Organtzatwn o} Temporal Data. Proceedlngs of the third IEEE Internatmnal Conference on Data Engmeermg, 1987, pp 547-553]] Google ScholarDigital Library
- SK Shosham, A and Kawagoe, K Temporal Data Management, VLDB, Japan, 1986]] Google ScholarDigital Library
- Sn1 Snodgrass, Rlchaxd The Temporal Query Languag, TQUEL Proc Third ACM SIGACT---SIGMOD Syrup on Prmoples of Database Systems, Waterloo, Apzil 1984, pp 204-212]] Google ScholarDigital Library
- Sn2 Snodgrass, Rtchard The Temporal Query Language TQuel. ACM TJ:ansactlons on Database Systems, Vol 12, 1987, pp 247-298]] Google ScholarDigital Library
- Sn3 Snodgtass, R ED Research concerning ttme ~r~ databases" Project summartes ACM SIGMOD P~c Vol 15, Dec 1986, pp 19--39]]Google ScholarDigital Library
- SA Snodgrass, Rlchaxd and Ahn~ I A Taxonomy of Ttme tn Databases Proc ACM--SIGMOD Int Conf on Management of Data, May 1985, pp 246]] Google ScholarDigital Library
- SGM Snodgrass, R, Gomez, S and McKenzle, Ed Aggregates m Temporal Que'ry Language T(~UEL TEMPIS Document 16 Computer Science Dept University of North Carolina at Chapel Hill]]Google Scholar
- Ta Tassel, A U. Adding Time Dtmenswn to Relatwnal Model and Eztendmg Relatwnal Algebra Information Systems, 1986]]Google Scholar
- TA1 Tansel, A U A Stahstwal Interface for Htstort~al Relattonai Databases Proc third IBi~E Int Con{ on Data Enganeerlng, 1987, pp 538-546]] Google ScholarDigital Library
- TA2 Tansel, A U and Arkun M E Hsstorwal Query Languages, 1985 (Submitted for publication )]]Google Scholar
- TA3 Tassel, A U and Arkun M E A Query Language for Htstorwal Relational Databases, 1986 Tech Report, Bernard M Baruch College]]Google Scholar
- TAO Tansel, A U., ME. Arkun and G Ozsoyoglu Time-By-Example Query Language For H=stor=cal Databases To appear in IEt~li) Transactions on Software Engtneenng]] Google ScholarDigital Library
- Ye Yeung, Chuen-Smg Qut~y Languages for a Heterogeneous Temporal Database M S Thesis, Texas Tech Univermty, August } 986]]Google Scholar
Index Terms
- A generalized model for a relational temporal database
Recommendations
A generalized model for a relational temporal database
SIGMOD '88: Proceedings of the 1988 ACM SIGMOD international conference on Management of dataWe propose a generalized relational model for a temporal database which allows time stamping with respect to a Boolean algebra of multidimensional time stamps. The interplay between the various temporal dimensions is symmetric. As an application, a two ...
Model Transformation From Object Relational Database to NoSQL Document Database
NISS '19: Proceedings of the 2nd International Conference on Networking, Information Systems & SecurityWith the high increase of data growing, NoSQL databases play a key role in storing large amount of data, to gain flexibility and scalability many industries are now replacing their relational and object relational databases by adopting NoSQL database ...
Model Transformation From Object Relational Database to NoSQL Column Based Database
NISS '20: Proceedings of the 3rd International Conference on Networking, Information Systems & SecurityNoSQL databases play an important role in saving a huge amount of data. To benefit from the advantages of horizontal scalability and flexibility and with the fast data growing many companies are now replacing their traditional database management ...
Comments