A temporal object relational SQL language with attribute timestamping in a temporal transparency environment
In this paper, a temporal object relational SQL language is proposed. It is intended to facilitate the non-procedural data definitions, queries, and modifications of temporal databases with attribute timestamping in a temporal transparency environment. With attribute timestamping, temporal data of a...
Saved in:
| Published in: | Data & knowledge engineering Vol. 67; no. 3; pp. 331 - 361 |
|---|---|
| Main Authors: | , |
| Format: | Journal Article |
| Language: | English |
| Published: |
Elsevier B.V
01.12.2008
|
| Subjects: | |
| ISSN: | 0169-023X, 1872-6933 |
| Online Access: | Get full text |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| Abstract | In this paper, a temporal object relational SQL language is proposed. It is intended to facilitate the non-procedural data definitions, queries, and modifications of temporal databases with attribute timestamping in a temporal transparency environment. With attribute timestamping, temporal data of any type is naturally handled. With temporal logic, users can issue temporal queries in an intuitively expressive manner. The language provides valid time support for upward compatibility, temporal upward compatibility, sequenced and non-sequenced variants to serve both non-temporal and temporal users. Using object relational technology, the implementation is made for embedded and interactive SQL modes. All existing interfaces of an ORDBMS are inherited with temporal transparency. |
|---|---|
| AbstractList | In this paper, a temporal object relational SQL language is proposed. It is intended to facilitate the non-procedural data definitions, queries, and modifications of temporal databases with attribute timestamping in a temporal transparency environment. With attribute timestamping, temporal data of any type is naturally handled. With temporal logic, users can issue temporal queries in an intuitively expressive manner. The language provides valid time support for upward compatibility, temporal upward compatibility, sequenced and non-sequenced variants to serve both non-temporal and temporal users. Using object relational technology, the implementation is made for embedded and interactive SQL modes. All existing interfaces of an ORDBMS are inherited with temporal transparency. |
| Author | Chau, Vo Thi Ngoc Chittayasothorn, Suphamit |
| Author_xml | – sequence: 1 givenname: Vo Thi Ngoc surname: Chau fullname: Chau, Vo Thi Ngoc – sequence: 2 givenname: Suphamit surname: Chittayasothorn fullname: Chittayasothorn, Suphamit email: suphamit@kmitl.ac.th |
| BookMark | eNqFkM1Kw0AUhQepYFt9AjfzAol3Mm2aLFyU4h8URFRwN9xMbuvEZBIm00rf3mkrCC50deByvwPnG7GBbS0xdikgFiDSqyou0eNHnABkMaRxiBM2FNksidJcygEbhq88gkS-nbFR31cAkExgOmT1nHtqutZhzduiIu25oxq9aW24PD8teY12vcE18U_j3zl670yx8cS9aaj32HTGrrmxHH-KvEPbd-jI6h0nuzWutQ1Zf85OV1j3dPGdY_Z6e_OyuI-Wj3cPi_ky0hKkj6ZJroWY6bzMc60nKAkTUU7SdDLDKQAVWSYLJLkinZaCIC0yCTmBQFmuUIMcM3ns1a7te0cr1TnToNspAWovTFXqIEzthSlIVYhA5b8obfzBRNhj6n_Y6yNLYdbWkFO9NmE-lcYFp6pszZ_8F7ktjW0 |
| CitedBy_id | crossref_primary_10_1016_j_eswa_2016_04_028 crossref_primary_10_1007_s10115_009_0235_x crossref_primary_10_1145_2340416_2340417 crossref_primary_10_1016_j_jksuci_2019_08_012 |
| Cites_doi | 10.1142/9789812819536_0039 10.1145/335191.336578 10.1145/181550.181562 10.1007/s11280-005-1317-7 10.1145/182.358434 10.1145/1321440.1321470 10.1109/69.599935 10.1145/377674.377665 10.1016/B978-0-444-88074-1.50021-4 10.1109/69.599934 10.1016/j.datak.2005.03.012 10.1016/S0169-023X(02)00132-5 10.1007/s007780050022 10.1016/j.datak.2007.06.020 10.1145/362384.362685 10.1109/TKDE.2003.1262189 10.1145/1147376.1147379 10.1016/j.datak.2004.07.001 10.1007/s00778-005-0161-9 10.1016/j.datak.2003.08.003 10.1145/49346.49347 10.1145/181550.181557 10.1145/22952.22956 10.1145/219713.219758 10.1007/0-387-34456-X_2 10.1145/49346.50065 10.1109/TKDE.2004.1277816 |
| ContentType | Journal Article |
| Copyright | 2008 Elsevier B.V. |
| Copyright_xml | – notice: 2008 Elsevier B.V. |
| DBID | AAYXX CITATION |
| DOI | 10.1016/j.datak.2008.06.008 |
| DatabaseName | CrossRef |
| DatabaseTitle | CrossRef |
| DatabaseTitleList | |
| DeliveryMethod | fulltext_linktorsrc |
| Discipline | Computer Science |
| EISSN | 1872-6933 |
| EndPage | 361 |
| ExternalDocumentID | 10_1016_j_datak_2008_06_008 S0169023X0800089X |
| GroupedDBID | --K --M -~X .DC .~1 0R~ 1B1 1RT 1~. 1~5 29F 4.4 457 4G. 5GY 5VS 7-5 71M 8P~ 9JN AAAKG AABNK AACTN AAEDT AAEDW AAIAV AAIKJ AAKOC AALRI AAOAW AAQFI AAQXK AARIN AAXUO AAYFN ABBOA ABFNM ABMAC ABTAH ABUCO ABXDB ABYKQ ACDAQ ACGFS ACNNM ACRLP ACZNC ADBBV ADEZE ADJOM ADMUD ADTZH AEBSH AECPX AEKER AENEX AFFNX AFKWA AFTJW AGHFR AGUBO AGYEJ AHHHB AHJVU AHZHX AIALX AIEXJ AIKHN AITUG AJBFU AJOXV ALMA_UNASSIGNED_HOLDINGS AMFUW AMRAJ AOUOD APLSM ASPBG AVWKF AXJTR AZFZN BJAXD BKOJK BLXMC CS3 EBS EFJIC EFLBG EJD EO8 EO9 EP2 EP3 FDB FEDTE FGOYB FIRID FNPLU FYGXN G-2 G-Q G8K GBLVA GBOLZ HAMUX HLZ HVGLF HZ~ IHE J1W JJJVA KOM LG9 LY1 LY7 M41 MO0 N9A O-L O9- OAUVE OZT P-8 P-9 P2P PC. Q38 R2- RIG ROL RPZ SBC SDF SDG SDP SDS SES SET SEW SPC SPCBC SSB SSD SST SSV SSZ T5K WUQ XPP ZMT ZY4 ~G- 77I 9DU AATTM AAXKI AAYWO AAYXX ABDPE ABJNI ABWVN ACLOT ACRPL ACVFH ADCNI ADNMO AEIPS AEUPX AFJKZ AFPUW AGQPQ AIGII AIIUN AKBMS AKRWK AKYEP ANKPU APXCP CITATION EFKBS ~HD |
| ID | FETCH-LOGICAL-c303t-529c117c9d99cc4a3ea21d46647a500eb883bae3fec6d1e06b8309e01a3dfac03 |
| ISICitedReferencesCount | 3 |
| ISICitedReferencesURI | http://www.webofscience.com/api/gateway?GWVersion=2&SrcApp=Summon&SrcAuth=ProQuest&DestLinkType=CitingArticles&DestApp=WOS_CPL&KeyUT=000261259000001&url=https%3A%2F%2Fcvtisr.summon.serialssolutions.com%2F%23%21%2Fsearch%3Fho%3Df%26include.ft.matches%3Dt%26l%3Dnull%26q%3D |
| ISSN | 0169-023X |
| IngestDate | Tue Nov 18 21:48:56 EST 2025 Sat Nov 29 03:03:19 EST 2025 Fri Feb 23 02:35:13 EST 2024 |
| IsPeerReviewed | true |
| IsScholarly | true |
| Issue | 3 |
| Keywords | Attribute timestamping Temporal database Object relational database SQL Temporal transparency |
| Language | English |
| License | https://www.elsevier.com/tdm/userlicense/1.0 |
| LinkModel | OpenURL |
| MergedId | FETCHMERGED-LOGICAL-c303t-529c117c9d99cc4a3ea21d46647a500eb883bae3fec6d1e06b8309e01a3dfac03 |
| PageCount | 31 |
| ParticipantIDs | crossref_primary_10_1016_j_datak_2008_06_008 crossref_citationtrail_10_1016_j_datak_2008_06_008 elsevier_sciencedirect_doi_10_1016_j_datak_2008_06_008 |
| PublicationCentury | 2000 |
| PublicationDate | 2008-12-01 |
| PublicationDateYYYYMMDD | 2008-12-01 |
| PublicationDate_xml | – month: 12 year: 2008 text: 2008-12-01 day: 01 |
| PublicationDecade | 2000 |
| PublicationTitle | Data & knowledge engineering |
| PublicationYear | 2008 |
| Publisher | Elsevier B.V |
| Publisher_xml | – name: Elsevier B.V |
| References | Böhlen (bib7) 1995; 24 Kleiner, Lipeck (bib28) 2002 Lomet, Barga, Mokbel, Shegalov, Wang, Zhu (bib29) 2006 Gadia (bib20) 1988; 13 A. Sotiropoulou, M. Souillard, C. Vassilakis, Temporal extension to ODMG, in: Proceedings of the IADT’98 – Issues and Applications of Database Technology, vol. 2, 1998, pp. 304–311. Wang, Zaniolo (bib53) 2005; 8 Viqueira, Lorentzos (bib52) 2007; 16 Nørvåg, Limstrand, Myklebust (bib35) 2003 Tansel, Atay (bib48) 2006 ISO/IEC JTC 1/SC 32 N 0436, Rationale for the Withdrawal of Projects, 2000. R.T. Snodgrass, Managing temporal data: a five-part series, Technical Report TR-28, Department of Computer Science, University of Arizona, 1998. Moro, Edelweiss, Zaupa, dos Santos (bib34) 2002 ANSI/ISO/IEC International Standard (IS) 9075 – Database Language SQL:2003 – WD 9075-2 (SQL/Foundation), September 2003. Edelweiss, Hübler, Moro, Demartini (bib17) 2000 Galante, dos Santos, Edelweiss, Moreira (bib21) 2005; 53 Vassilakis, Georgiadis, Sotiropoulou (bib51) 1996 Jensen (bib26) 1998 Lorentzos, Mitsopoulos (bib30) 1997; 9 N. Pissinou, R.T. Snodgrass, R. Elmasri, et al., Towards an infrastructure for temporal databases: report of an invitational ARPA/NSF workshop, Technical Report, University of Arizona, 1994. M. Stonebraker, P. Brown, D. Moore, Object-Relational DBMS’s – Tracking the Next Great Wave, Morgan Kaufmann, 1999. Böhlen, Gamper, Jensen (bib8) 2006 E.A. Emerson, Temporal and modal logic, in: J. van Leeuwen (ed.), Handbook of Theoretical Computer Science, vol. 2, 1990. Merlo, Bertino, Ferrari, Gadia, Guerrini (bib33) 2000 Allen (bib1) 1983; 26 C.S. Jensen, J. Clifford, S.K. Gadia, F. Grandi, et al., The TSQL benchmark, in: Proceedings of the International Workshop on an Infrastructure for Temporal Databases, 1993, pp. QQ-1-QQ-28. Tansel (bib47) 2004 . Bettini, Montanari (bib5) 2003; 44 Fegaras, Elmasri (bib19) 1998 Böhlen, Jensen, Snodgrass (bib9) 2000; 25 Dey, Barron, Storey (bib15) 1996; 5 M. Böhlen, R. Snodgrass, M. Soo, Coalescing in temporal databases, Technical Report, TimeCenter TR-9, 1997; also in: Proceedings of the 22nd VLDB Conference, 1996, pp. 180–191. K. Torp, C.S. Jensen, M. Böhlen, Layered temporal DBMS’s – concepts and techniques, in: Proceedings of the DASFAA’97, 1997, pp. 371–380. A. Carvalho, C. Ribeiro, A.A. Sousa, A spatio-temporal database system based on TimeDB and Oracle Spatial, in: Proceedings of the IFIP International Federation for Information Processing, vol. 205, 2006, pp. 11–20. M.H. Böhlen, Valid time integrity constraints, Technical Report, TimeCenter TR 94-30, Department of Computer Science, University of Arizona, 1994. Roth (bib40) 1988; 13 C. Combi, A. Montanari, G. Pozzi, The T4SQL temporal query language, in: Proceedings of the CIKM’07, 2007, pp. 193–202. J. Yang, H. Ying, J. Widom, TIP: a temporal extension to Informix, in: Proceedings of the SIGMOD, 2000, pp. 596–671. Oracle 10g Garani (bib22) 2006; 57 Malinowski, Zimányi (bib31) 2008; 64 Oracle Valid Time Support, Application developer’s guide – workspace manager, 10g release 1(10.1), No. B10824-01. Tansel (bib46) 1997; 9 Snodgrass (bib41) 1987; 12 Zimányi (bib55) 2006; 35 C. Kleiner et al., Natural and efficient modeling of temporal information with object-relational databases, Technical Report, University of Hannover, 2002. Terenziani, Snodgrass (bib49) 2004; 16 Bartel (bib3) 1996 Snodgrass, Ahn, Ariav, Batory, Clifford, Dyreson, Elmasri, Grandi, Jensen, Kä (bib42) 1994; 23 Oracle Flashback Query, Application developer’s guide – fundamentals, 10g release 1(10.1), No. B10795-01. Griffiths (bib23) 2004; 49 Mata-Toledo, Monger (bib32) 2008; 23 Bassiouni (bib4) 1988 Codd (bib13) 1970; 13 Chen, Kong, Zaniolo (bib12) 2003 Dumas, Fauvet, Scholl (bib16) 2004; 16 10.1016/j.datak.2008.06.008_bib27 Tansel (10.1016/j.datak.2008.06.008_bib46) 1997; 9 Dumas (10.1016/j.datak.2008.06.008_bib16) 2004; 16 10.1016/j.datak.2008.06.008_bib24 10.1016/j.datak.2008.06.008_bib25 Bettini (10.1016/j.datak.2008.06.008_bib5) 2003; 44 Moro (10.1016/j.datak.2008.06.008_bib34) 2002 Fegaras (10.1016/j.datak.2008.06.008_bib19) 1998 Garani (10.1016/j.datak.2008.06.008_bib22) 2006; 57 Allen (10.1016/j.datak.2008.06.008_bib1) 1983; 26 Bartel (10.1016/j.datak.2008.06.008_bib3) 1996 10.1016/j.datak.2008.06.008_bib18 10.1016/j.datak.2008.06.008_bib14 Snodgrass (10.1016/j.datak.2008.06.008_bib41) 1987; 12 Wang (10.1016/j.datak.2008.06.008_bib53) 2005; 8 10.1016/j.datak.2008.06.008_bib10 10.1016/j.datak.2008.06.008_bib54 10.1016/j.datak.2008.06.008_bib11 10.1016/j.datak.2008.06.008_bib50 Griffiths (10.1016/j.datak.2008.06.008_bib23) 2004; 49 Snodgrass (10.1016/j.datak.2008.06.008_bib42) 1994; 23 Böhlen (10.1016/j.datak.2008.06.008_bib8) 2006 Roth (10.1016/j.datak.2008.06.008_bib40) 1988; 13 Vassilakis (10.1016/j.datak.2008.06.008_bib51) 1996 Bassiouni (10.1016/j.datak.2008.06.008_bib4) 1988 Chen (10.1016/j.datak.2008.06.008_bib12) 2003 Viqueira (10.1016/j.datak.2008.06.008_bib52) 2007; 16 Malinowski (10.1016/j.datak.2008.06.008_bib31) 2008; 64 10.1016/j.datak.2008.06.008_bib45 Nørvåg (10.1016/j.datak.2008.06.008_bib35) 2003 10.1016/j.datak.2008.06.008_bib43 10.1016/j.datak.2008.06.008_bib44 Jensen (10.1016/j.datak.2008.06.008_bib26) 1998 Tansel (10.1016/j.datak.2008.06.008_bib48) 2006 Kleiner (10.1016/j.datak.2008.06.008_bib28) 2002 Zimányi (10.1016/j.datak.2008.06.008_bib55) 2006; 35 10.1016/j.datak.2008.06.008_bib38 Böhlen (10.1016/j.datak.2008.06.008_bib7) 1995; 24 10.1016/j.datak.2008.06.008_bib39 Edelweiss (10.1016/j.datak.2008.06.008_bib17) 2000 Codd (10.1016/j.datak.2008.06.008_bib13) 1970; 13 Terenziani (10.1016/j.datak.2008.06.008_bib49) 2004; 16 10.1016/j.datak.2008.06.008_bib36 10.1016/j.datak.2008.06.008_bib37 Mata-Toledo (10.1016/j.datak.2008.06.008_bib32) 2008; 23 Galante (10.1016/j.datak.2008.06.008_bib21) 2005; 53 Tansel (10.1016/j.datak.2008.06.008_bib47) 2004 Gadia (10.1016/j.datak.2008.06.008_bib20) 1988; 13 Böhlen (10.1016/j.datak.2008.06.008_bib9) 2000; 25 Merlo (10.1016/j.datak.2008.06.008_bib33) 2000 10.1016/j.datak.2008.06.008_bib6 Dey (10.1016/j.datak.2008.06.008_bib15) 1996; 5 10.1016/j.datak.2008.06.008_bib2 Lomet (10.1016/j.datak.2008.06.008_bib29) 2006 Lorentzos (10.1016/j.datak.2008.06.008_bib30) 1997; 9 |
| References_xml | – volume: 25 start-page: 407 year: 2000 end-page: 456 ident: bib9 article-title: Temporal statement modifiers publication-title: ACM Transactions on Database Systems – volume: 9 start-page: 480 year: 1997 end-page: 499 ident: bib30 article-title: SQL extension for interval data publication-title: IEEE Transactions on Knowledge and Data Engineering – reference: A. Sotiropoulou, M. Souillard, C. Vassilakis, Temporal extension to ODMG, in: Proceedings of the IADT’98 – Issues and Applications of Database Technology, vol. 2, 1998, pp. 304–311. – reference: K. Torp, C.S. Jensen, M. Böhlen, Layered temporal DBMS’s – concepts and techniques, in: Proceedings of the DASFAA’97, 1997, pp. 371–380. – reference: C. Kleiner et al., Natural and efficient modeling of temporal information with object-relational databases, Technical Report, University of Hannover, 2002. – volume: 35 start-page: 16 year: 2006 end-page: 21 ident: bib55 article-title: Temporal aggregates and temporal universal quantification in standard SQL publication-title: SIGMOD Record – reference: ISO/IEC JTC 1/SC 32 N 0436, Rationale for the Withdrawal of Projects, 2000. – year: 2000 ident: bib17 article-title: A temporal database management system implemented on top of a conventional database publication-title: Proceedings of the The XX International Conference of the Chilean Computer Science Society (SCCC’00) – start-page: 674 year: 1996 end-page: 676 ident: bib3 article-title: ODMG 93-the emerging object database standard publication-title: Proceedings of the ICDE – volume: 12 start-page: 247 year: 1987 end-page: 298 ident: bib41 article-title: The temporal query language TQuel publication-title: ACM Transactions on Database Systems – volume: 13 start-page: 377 year: 1970 end-page: 387 ident: bib13 article-title: A relational model for large shared data banks publication-title: Communications of the ACM – volume: 13 start-page: 418 year: 1988 end-page: 448 ident: bib20 article-title: A homogeneous relational model and query languages for temporal databases publication-title: ACM Transactions on Database Systems – volume: 24 start-page: 53 year: 1995 end-page: 60 ident: bib7 article-title: Temporal database system implementations publication-title: SIGMOD Record – volume: 64 start-page: 101 year: 2008 end-page: 133 ident: bib31 article-title: A conceptual model for temporal data warehouses and its transformation to the ER and the object-relational models publication-title: Data and Knowledge Engineering – volume: 23 start-page: 65 year: 1994 end-page: 86 ident: bib42 article-title: TSQL2 language specification publication-title: SIGMOD Record – volume: 44 start-page: 139 year: 2003 end-page: 141 ident: bib5 article-title: Temporal representation and reasoning publication-title: Data and Knowledge Engineering – reference: A. Carvalho, C. Ribeiro, A.A. Sousa, A spatio-temporal database system based on TimeDB and Oracle Spatial, in: Proceedings of the IFIP International Federation for Information Processing, vol. 205, 2006, pp. 11–20. – reference: C. Combi, A. Montanari, G. Pozzi, The T4SQL temporal query language, in: Proceedings of the CIKM’07, 2007, pp. 193–202. – start-page: 345 year: 1988 end-page: 352 ident: bib4 article-title: A logic for handling time in temporal databases publication-title: Proceedings of the COMPSAC – volume: 53 start-page: 99 year: 2005 end-page: 128 ident: bib21 article-title: Temporal and versioning model for schema evolution in object-oriented databases publication-title: Data and Knowledge Engineering – volume: 23 start-page: 76 year: 2008 end-page: 81 ident: bib32 article-title: Implementing a temporal data management system within Oracle publication-title: Journal of Computing Sciences in Colleges – start-page: 520 year: 2003 end-page: 530 ident: bib35 article-title: TeXOR: temporal XML database on an object relational database system publication-title: Proceedings of the Perspectives of System Informatics – reference: R.T. Snodgrass, Managing temporal data: a five-part series, Technical Report TR-28, Department of Computer Science, University of Arizona, 1998. – reference: E.A. Emerson, Temporal and modal logic, in: J. van Leeuwen (ed.), Handbook of Theoretical Computer Science, vol. 2, 1990. – reference: N. Pissinou, R.T. Snodgrass, R. Elmasri, et al., Towards an infrastructure for temporal databases: report of an invitational ARPA/NSF workshop, Technical Report, University of Arizona, 1994. – reference: M.H. Böhlen, Valid time integrity constraints, Technical Report, TimeCenter TR 94-30, Department of Computer Science, University of Arizona, 1994. – volume: 16 start-page: 179 year: 2007 end-page: 200 ident: bib52 article-title: SQL extension for spatio-temporal data publication-title: The VLDBJ – start-page: 367 year: 1998 end-page: 405 ident: bib26 article-title: The consensus glossary of temporal database concepts publication-title: Temporal Databases: Research and Practice – reference: . – volume: 5 start-page: 167 year: 1996 end-page: 180 ident: bib15 article-title: A complete temporal relational algebra publication-title: The VLDBJ – reference: M. Böhlen, R. Snodgrass, M. Soo, Coalescing in temporal databases, Technical Report, TimeCenter TR-9, 1997; also in: Proceedings of the 22nd VLDB Conference, 1996, pp. 180–191. – volume: 13 start-page: 389 year: 1988 end-page: 417 ident: bib40 article-title: Extended algebra and calculus for nested relational databases publication-title: ACM Transactions on Database Systems – volume: 8 start-page: 233 year: 2005 end-page: 259 ident: bib53 article-title: An XML-based approach to publishing and querying the history of databases publication-title: World Wide Web: Internet and Web Information Systems – start-page: 121 year: 2006 end-page: 136 ident: bib8 article-title: How would you like to aggregate your temporal data? publication-title: Proceedings of the TIME’06 – start-page: 153 year: 1996 end-page: 164 ident: bib51 article-title: A comparative study of temporal DBMS architectures publication-title: Proceedings of the DEXA’96 – reference: C.S. Jensen, J. Clifford, S.K. Gadia, F. Grandi, et al., The TSQL benchmark, in: Proceedings of the International Workshop on an Infrastructure for Temporal Databases, 1993, pp. QQ-1-QQ-28. – reference: Oracle Valid Time Support, Application developer’s guide – workspace manager, 10g release 1(10.1), No. B10824-01. – start-page: 459 year: 2004 end-page: 469 ident: bib47 article-title: Temporal data modeling and integrity constraints in relational databases publication-title: Proceedings of the Symposium on Computer and Information Sciences – volume: 9 start-page: 464 year: 1997 end-page: 479 ident: bib46 article-title: Temporal relational data model publication-title: IEEE Transactions on Knowledge and Data Engineering – start-page: 689 year: 2003 end-page: 691 ident: bib12 article-title: Design and implementation of a temporal extension of SQL publication-title: Proceedings of the ICDE – start-page: 618 year: 2002 end-page: 627 ident: bib34 article-title: TVQL – temporal versioned query language publication-title: Proceedings of the DEXA 2002 – volume: 16 start-page: 354 year: 2004 end-page: 374 ident: bib16 article-title: TEMPOS: a platform for developing temporal applications on top of object DBMS publication-title: IEEE Transactions on Knowledge and Data Engineering – start-page: 622 year: 2006 end-page: 633 ident: bib48 article-title: Nested bitemporal relational algebra publication-title: Proceedings of the ISCIS 2006 – volume: 26 start-page: 832 year: 1983 end-page: 843 ident: bib1 article-title: Maintaining knowledge about temporal intervals publication-title: Communications of the ACM – start-page: 58 year: 2002 end-page: 60 ident: bib28 article-title: Performance of querying temporal attributes in object-relational databases publication-title: Proceedings of the TIME’02 – reference: Oracle Flashback Query, Application developer’s guide – fundamentals, 10g release 1(10.1), No. B10795-01. – start-page: 103 year: 2000 end-page: 114 ident: bib33 article-title: Querying multiple temporal granularity data publication-title: Proceedings of the TIME’00 – reference: M. Stonebraker, P. Brown, D. Moore, Object-Relational DBMS’s – Tracking the Next Great Wave, Morgan Kaufmann, 1999. – reference: Oracle 10g, – reference: ANSI/ISO/IEC International Standard (IS) 9075 – Database Language SQL:2003 – WD 9075-2 (SQL/Foundation), September 2003. – reference: J. Yang, H. Ying, J. Widom, TIP: a temporal extension to Informix, in: Proceedings of the SIGMOD, 2000, pp. 596–671. – volume: 49 start-page: 23 year: 2004 end-page: 65 ident: bib23 article-title: The Tripod spatio-historical data model publication-title: Data and Knowledge Engineering – start-page: 35 year: 2006 end-page: 46 ident: bib29 article-title: Transaction time support inside a database engine publication-title: Proceedings of the ICDE Conference – volume: 16 start-page: 540 year: 2004 end-page: 551 ident: bib49 article-title: Reconcilling point-based and interval-based semantics in temporal relational databases: a treatment of the telic/atelic distinction publication-title: IEEE Transactions on Knowledge and Data Engineering – start-page: 51 year: 1998 end-page: 57 ident: bib19 article-title: A temporal object query language publication-title: Proceedings of the TIME – volume: 57 start-page: 283 year: 2006 end-page: 310 ident: bib22 article-title: A generalized temporal algebra publication-title: Data and Knowledge Engineering – ident: 10.1016/j.datak.2008.06.008_bib50 doi: 10.1142/9789812819536_0039 – ident: 10.1016/j.datak.2008.06.008_bib54 doi: 10.1145/335191.336578 – start-page: 153 year: 1996 ident: 10.1016/j.datak.2008.06.008_bib51 article-title: A comparative study of temporal DBMS architectures – start-page: 367 year: 1998 ident: 10.1016/j.datak.2008.06.008_bib26 article-title: The consensus glossary of temporal database concepts – volume: 23 start-page: 76 year: 2008 ident: 10.1016/j.datak.2008.06.008_bib32 article-title: Implementing a temporal data management system within Oracle publication-title: Journal of Computing Sciences in Colleges – start-page: 121 year: 2006 ident: 10.1016/j.datak.2008.06.008_bib8 article-title: How would you like to aggregate your temporal data? – volume: 23 start-page: 65 issue: 1 year: 1994 ident: 10.1016/j.datak.2008.06.008_bib42 article-title: TSQL2 language specification publication-title: SIGMOD Record doi: 10.1145/181550.181562 – volume: 8 start-page: 233 issue: 3 year: 2005 ident: 10.1016/j.datak.2008.06.008_bib53 article-title: An XML-based approach to publishing and querying the history of databases publication-title: World Wide Web: Internet and Web Information Systems doi: 10.1007/s11280-005-1317-7 – year: 2000 ident: 10.1016/j.datak.2008.06.008_bib17 article-title: A temporal database management system implemented on top of a conventional database – volume: 26 start-page: 832 year: 1983 ident: 10.1016/j.datak.2008.06.008_bib1 article-title: Maintaining knowledge about temporal intervals publication-title: Communications of the ACM doi: 10.1145/182.358434 – ident: 10.1016/j.datak.2008.06.008_bib14 doi: 10.1145/1321440.1321470 – volume: 9 start-page: 480 issue: 3 year: 1997 ident: 10.1016/j.datak.2008.06.008_bib30 article-title: SQL extension for interval data publication-title: IEEE Transactions on Knowledge and Data Engineering doi: 10.1109/69.599935 – start-page: 51 year: 1998 ident: 10.1016/j.datak.2008.06.008_bib19 article-title: A temporal object query language – ident: 10.1016/j.datak.2008.06.008_bib36 – volume: 25 start-page: 407 issue: 4 year: 2000 ident: 10.1016/j.datak.2008.06.008_bib9 article-title: Temporal statement modifiers publication-title: ACM Transactions on Database Systems doi: 10.1145/377674.377665 – start-page: 622 year: 2006 ident: 10.1016/j.datak.2008.06.008_bib48 article-title: Nested bitemporal relational algebra – ident: 10.1016/j.datak.2008.06.008_bib18 doi: 10.1016/B978-0-444-88074-1.50021-4 – ident: 10.1016/j.datak.2008.06.008_bib27 – start-page: 103 year: 2000 ident: 10.1016/j.datak.2008.06.008_bib33 article-title: Querying multiple temporal granularity data – volume: 9 start-page: 464 issue: 3 year: 1997 ident: 10.1016/j.datak.2008.06.008_bib46 article-title: Temporal relational data model publication-title: IEEE Transactions on Knowledge and Data Engineering doi: 10.1109/69.599934 – volume: 57 start-page: 283 year: 2006 ident: 10.1016/j.datak.2008.06.008_bib22 article-title: A generalized temporal algebra publication-title: Data and Knowledge Engineering doi: 10.1016/j.datak.2005.03.012 – volume: 44 start-page: 139 year: 2003 ident: 10.1016/j.datak.2008.06.008_bib5 article-title: Temporal representation and reasoning publication-title: Data and Knowledge Engineering doi: 10.1016/S0169-023X(02)00132-5 – ident: 10.1016/j.datak.2008.06.008_bib43 – start-page: 345 year: 1988 ident: 10.1016/j.datak.2008.06.008_bib4 article-title: A logic for handling time in temporal databases – start-page: 58 year: 2002 ident: 10.1016/j.datak.2008.06.008_bib28 article-title: Performance of querying temporal attributes in object-relational databases – volume: 5 start-page: 167 year: 1996 ident: 10.1016/j.datak.2008.06.008_bib15 article-title: A complete temporal relational algebra publication-title: The VLDBJ doi: 10.1007/s007780050022 – volume: 64 start-page: 101 year: 2008 ident: 10.1016/j.datak.2008.06.008_bib31 article-title: A conceptual model for temporal data warehouses and its transformation to the ER and the object-relational models publication-title: Data and Knowledge Engineering doi: 10.1016/j.datak.2007.06.020 – ident: 10.1016/j.datak.2008.06.008_bib37 – volume: 13 start-page: 377 issue: 6 year: 1970 ident: 10.1016/j.datak.2008.06.008_bib13 article-title: A relational model for large shared data banks publication-title: Communications of the ACM doi: 10.1145/362384.362685 – volume: 16 start-page: 354 issue: 3 year: 2004 ident: 10.1016/j.datak.2008.06.008_bib16 article-title: TEMPOS: a platform for developing temporal applications on top of object DBMS publication-title: IEEE Transactions on Knowledge and Data Engineering doi: 10.1109/TKDE.2003.1262189 – start-page: 689 year: 2003 ident: 10.1016/j.datak.2008.06.008_bib12 article-title: Design and implementation of a temporal extension of SQL – volume: 35 start-page: 16 issue: 2 year: 2006 ident: 10.1016/j.datak.2008.06.008_bib55 article-title: Temporal aggregates and temporal universal quantification in standard SQL publication-title: SIGMOD Record doi: 10.1145/1147376.1147379 – volume: 53 start-page: 99 year: 2005 ident: 10.1016/j.datak.2008.06.008_bib21 article-title: Temporal and versioning model for schema evolution in object-oriented databases publication-title: Data and Knowledge Engineering doi: 10.1016/j.datak.2004.07.001 – start-page: 618 year: 2002 ident: 10.1016/j.datak.2008.06.008_bib34 article-title: TVQL – temporal versioned query language – start-page: 520 year: 2003 ident: 10.1016/j.datak.2008.06.008_bib35 article-title: TeXOR: temporal XML database on an object relational database system – ident: 10.1016/j.datak.2008.06.008_bib24 – volume: 16 start-page: 179 issue: 2 year: 2007 ident: 10.1016/j.datak.2008.06.008_bib52 article-title: SQL extension for spatio-temporal data publication-title: The VLDBJ doi: 10.1007/s00778-005-0161-9 – ident: 10.1016/j.datak.2008.06.008_bib6 – ident: 10.1016/j.datak.2008.06.008_bib44 – volume: 49 start-page: 23 year: 2004 ident: 10.1016/j.datak.2008.06.008_bib23 article-title: The Tripod spatio-historical data model publication-title: Data and Knowledge Engineering doi: 10.1016/j.datak.2003.08.003 – volume: 13 start-page: 389 issue: 4 year: 1988 ident: 10.1016/j.datak.2008.06.008_bib40 article-title: Extended algebra and calculus for nested relational databases publication-title: ACM Transactions on Database Systems doi: 10.1145/49346.49347 – ident: 10.1016/j.datak.2008.06.008_bib38 – ident: 10.1016/j.datak.2008.06.008_bib39 doi: 10.1145/181550.181557 – volume: 12 start-page: 247 issue: 2 year: 1987 ident: 10.1016/j.datak.2008.06.008_bib41 article-title: The temporal query language TQuel publication-title: ACM Transactions on Database Systems doi: 10.1145/22952.22956 – volume: 24 start-page: 53 year: 1995 ident: 10.1016/j.datak.2008.06.008_bib7 article-title: Temporal database system implementations publication-title: SIGMOD Record doi: 10.1145/219713.219758 – ident: 10.1016/j.datak.2008.06.008_bib25 – ident: 10.1016/j.datak.2008.06.008_bib2 – ident: 10.1016/j.datak.2008.06.008_bib11 doi: 10.1007/0-387-34456-X_2 – volume: 13 start-page: 418 issue: 4 year: 1988 ident: 10.1016/j.datak.2008.06.008_bib20 article-title: A homogeneous relational model and query languages for temporal databases publication-title: ACM Transactions on Database Systems doi: 10.1145/49346.50065 – start-page: 35 year: 2006 ident: 10.1016/j.datak.2008.06.008_bib29 article-title: Transaction time support inside a database engine – start-page: 674 year: 1996 ident: 10.1016/j.datak.2008.06.008_bib3 article-title: ODMG 93-the emerging object database standard – ident: 10.1016/j.datak.2008.06.008_bib45 – volume: 16 start-page: 540 issue: 5 year: 2004 ident: 10.1016/j.datak.2008.06.008_bib49 article-title: Reconcilling point-based and interval-based semantics in temporal relational databases: a treatment of the telic/atelic distinction publication-title: IEEE Transactions on Knowledge and Data Engineering doi: 10.1109/TKDE.2004.1277816 – ident: 10.1016/j.datak.2008.06.008_bib10 – start-page: 459 year: 2004 ident: 10.1016/j.datak.2008.06.008_bib47 article-title: Temporal data modeling and integrity constraints in relational databases |
| SSID | ssj0002405 |
| Score | 1.8715351 |
| Snippet | In this paper, a temporal object relational SQL language is proposed. It is intended to facilitate the non-procedural data definitions, queries, and... |
| SourceID | crossref elsevier |
| SourceType | Enrichment Source Index Database Publisher |
| StartPage | 331 |
| SubjectTerms | Attribute timestamping Object relational database SQL Temporal database Temporal transparency |
| Title | A temporal object relational SQL language with attribute timestamping in a temporal transparency environment |
| URI | https://dx.doi.org/10.1016/j.datak.2008.06.008 |
| Volume | 67 |
| WOSCitedRecordID | wos000261259000001&url=https%3A%2F%2Fcvtisr.summon.serialssolutions.com%2F%23%21%2Fsearch%3Fho%3Df%26include.ft.matches%3Dt%26l%3Dnull%26q%3D |
| hasFullText | 1 |
| inHoldings | 1 |
| isFullTextHit | |
| isPrint | |
| journalDatabaseRights | – providerCode: PRVESC databaseName: ScienceDirect customDbUrl: eissn: 1872-6933 dateEnd: 99991231 omitProxy: false ssIdentifier: ssj0002405 issn: 0169-023X databaseCode: AIEXJ dateStart: 19950201 isFulltext: true titleUrlDefault: https://www.sciencedirect.com providerName: Elsevier |
| link | http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwtV3Pb9MwFLZKx4ELjF9isCEfuI1Ijp029rHahgChCrQh9RY5jgPdurTa3Gn7D_iz9xzbiWGoYgcuUZTGTpP3xX55_t77EHoHwK2zbKQSxUr4QKFZnpSK6iTXaS0Iqe3aVSs2kU-nfDYTXweDXyEX5mqRNw2_vhar_2pqOAbGtqmz9zB31ykcgH0wOmzB7LD9J8NP9n25KfAySxtl8fkqbcjv-NuXLkTp89qM07zSTmbeyPOVT3ORfUemLYFu88bUTZwbF7u2h9LIFkhdmA7O7IodRjSCdcutXVrJ0P3pj6Xqf5obI2_kJYBn6TjGx-vVT3k-N7_FJnjE8_DhyrFIwCuYxeOtk9_wuGLR4Blyt9w8zFyR9jtDvIs2nNqLyjNPhrULSryf0cIq_h8TXUc_DMy206LtxEtxWn4ff4C2aD4SfIi2Jp-OZp-7WR08H0eH9XcUKli1XME7_-XvXk7kuZxso8f-kwNPHFSeooFunqEnQc4D-9H9OVpMcDA4dsjBPXIwIAcH5GCLHNwhB8fIwfMGy76jGDk4Qs4L9P3D0cnBx8SLccBbTJhJRlSoNM2VqIRQKpNMS5pWVpwgt6IauuSclVKzWqtxlWoyLjkjQpNUsqqWirCXaNgsG_0KYcFpVtWElBnsUE0ktOFVTmgpaEqqdAfR8PAK5SvVW8GURbHBcDvofddo5Qq1bD59HKxSeF_T-ZAF4GxTw9f3u84b9Kh_MXbR0Fys9R56qK7M_PLirQfZLe8qpn8 |
| linkProvider | Elsevier |
| openUrl | ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=article&rft.atitle=A+temporal+object+relational+SQL+language+with+attribute+timestamping+in+a+temporal+transparency+environment&rft.jtitle=Data+%26+knowledge+engineering&rft.au=Chau%2C+Vo+Thi+Ngoc&rft.au=Chittayasothorn%2C+Suphamit&rft.date=2008-12-01&rft.issn=0169-023X&rft.volume=67&rft.issue=3&rft.spage=331&rft.epage=361&rft_id=info:doi/10.1016%2Fj.datak.2008.06.008&rft.externalDBID=n%2Fa&rft.externalDocID=10_1016_j_datak_2008_06_008 |
| thumbnail_l | http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/lc.gif&issn=0169-023X&client=summon |
| thumbnail_m | http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/mc.gif&issn=0169-023X&client=summon |
| thumbnail_s | http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/sc.gif&issn=0169-023X&client=summon |