Skip to main content
Erschienen in: Journal of Intelligent Information Systems 2/2013

01.10.2013

Querying now-relative data

verfasst von: Luca Anselma, Bela Stantic, Paolo Terenziani, Abdul Sattar

Erschienen in: Journal of Intelligent Information Systems | Ausgabe 2/2013

Einloggen

Aktivieren Sie unsere intelligente Suche, um passende Fachinhalte oder Patente zu finden.

search-config
loading …

Abstract

Now-relative temporal data play an important role in most temporal applications, and their management has been proved to impact in a crucial way the efficiency of temporal databases. Though several temporal relational approaches have been developed to deal with now-relative data, none of them has provided a whole temporal algebra to query them. In this paper we overcome such a limitation, by proposing a general algebra which is parametrically adapted to cope with the relational approaches to now-relative data in the literature, i.e., MIN, MAX, NULL and POINT approaches. Besides being general enough to provide a query language for several approaches in the literature, our algebra has been designed in such a way to satisfy several theoretical and practical desiderata: closure with respect to representation languages, correctness with respect to the “consensus” BCDM semantics, reducibility to the standard non-temporal algebra (which involves interoperability with non-temporal relational databases), implementability and efficiency. Indeed, the experimental evaluation we have drawn on our implementation has shown that only a slight overhead is added by our treatment of now-relative data (with respect to an approach in which such data are not present).

Sie haben noch keine Lizenz? Dann Informieren Sie sich jetzt über unsere Produkte:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Anhänge
Nur mit Berechtigung zugänglich
Literatur
Zurück zum Zitat Agesen, M., Bohlen, M., Poulsen, L., Torp, K. (2001). A split operator for now-relative bitemporal databases. In Proceedings of the 17th international conference on data engineering, 2001 (pp. 41–50). Agesen, M., Bohlen, M., Poulsen, L., Torp, K. (2001). A split operator for now-relative bitemporal databases. In Proceedings of the 17th international conference on data engineering, 2001 (pp. 41–50).
Zurück zum Zitat Bohlen, M.H., Snodgrass, R.T., Soo, M.D. (1996). Coalescing in Temporal Databases. In Proceedings of the 22nd VLDB conf (pp. 180–190). Bohlen, M.H., Snodgrass, R.T., Soo, M.D. (1996). Coalescing in Temporal Databases. In Proceedings of the 22nd VLDB conf (pp. 180–190).
Zurück zum Zitat Clifford, J., Dyreson, C., Isakowitz, T., Jensen, C.S., Snodgrass, R.T. (1997). On the semantics of “Now” in databases. ACM Transactions on Database Systems (TODS), 22(2), 171–214.CrossRef Clifford, J., Dyreson, C., Isakowitz, T., Jensen, C.S., Snodgrass, R.T. (1997). On the semantics of “Now” in databases. ACM Transactions on Database Systems (TODS), 22(2), 171–214.CrossRef
Zurück zum Zitat Codd, E.F. (1972). Relational completeness of data base sublanguages. In R. Rustin (Ed.), Database systems (pp. 65–98). San Jose: Prentice Hall and IBM Research Report RJ 987. Codd, E.F. (1972). Relational completeness of data base sublanguages. In R. Rustin (Ed.), Database systems (pp. 65–98). San Jose: Prentice Hall and IBM Research Report RJ 987.
Zurück zum Zitat Creem, K.N. (2005). A comparison of approaches to modeling now in bitemporal databases. In Proceedings of the 21st computer science seminar. Hartford, USA. Creem, K.N. (2005). A comparison of approaches to modeling now in bitemporal databases. In Proceedings of the 21st computer science seminar. Hartford, USA.
Zurück zum Zitat Dyreson, C.E. (2003). Temporal coalescing with now granularity, and incomplete information. In Proceedings of the 2003 ACM SIGMOD international conference on management of data, SIGMOD ’03 (pp. 169–180). New York: ACM.CrossRef Dyreson, C.E. (2003). Temporal coalescing with now granularity, and incomplete information. In Proceedings of the 2003 ACM SIGMOD international conference on management of data, SIGMOD ’03 (pp. 169–180). New York: ACM.CrossRef
Zurück zum Zitat Dyreson, C.E., Jensen, C.S., Snodgrass, R.T. (2009). Now in temporal databases. In L. Liu, & M. Özsu (Eds.), Encyclopedia of database systems (pp. 1920–1924). USA: Springer. Dyreson, C.E., Jensen, C.S., Snodgrass, R.T. (2009). Now in temporal databases. In L. Liu, & M. Özsu (Eds.), Encyclopedia of database systems (pp. 1920–1924). USA: Springer.
Zurück zum Zitat Fenk, R., Markl, V., Bayer, R. (2002). Interval processing with the UB-tree. In Proceedings of the 2002 international symposium on database engineering and applications (pp. 12–22). Fenk, R., Markl, V., Bayer, R. (2002). Interval processing with the UB-tree. In Proceedings of the 2002 international symposium on database engineering and applications (pp. 12–22).
Zurück zum Zitat Franzblau, D.S., & Xenakis, G. (2008). An algorithm for the difference between set covers. Discrete Applied Mathematics, 156(10), 1623–1632.MathSciNetCrossRefMATH Franzblau, D.S., & Xenakis, G. (2008). An algorithm for the difference between set covers. Discrete Applied Mathematics, 156(10), 1623–1632.MathSciNetCrossRefMATH
Zurück zum Zitat Hellerstein, J., Koutsupias, E., Papadimitriou, C. (1997). On the analysis of indexing schemes. In Proceedings of the 16th ACM SIGACT-SIGMOD-SIGART symposium on principles of database systems. Hellerstein, J., Koutsupias, E., Papadimitriou, C. (1997). On the analysis of indexing schemes. In Proceedings of the 16th ACM SIGACT-SIGMOD-SIGART symposium on principles of database systems.
Zurück zum Zitat Jensen, C.S., & Lomet, D.B. (2001). Transaction timestamping in (temporal) databases. In Proceedings of the international conference on very large data bases (pp. 441–450). Jensen, C.S., & Lomet, D.B. (2001). Transaction timestamping in (temporal) databases. In Proceedings of the international conference on very large data bases (pp. 441–450).
Zurück zum Zitat Jensen, C.S., & Snodgrass, R.T. (1996). Semantics of time-varying information. Information Systems, 21(4):311–352.CrossRef Jensen, C.S., & Snodgrass, R.T. (1996). Semantics of time-varying information. Information Systems, 21(4):311–352.CrossRef
Zurück zum Zitat Jensen, C.S., & Snodgrass, R. (1999). Temporal data management. IEEE Transactions on Knowledge and Data Engineering, 11(1), 36–44.CrossRef Jensen, C.S., & Snodgrass, R. (1999). Temporal data management. IEEE Transactions on Knowledge and Data Engineering, 11(1), 36–44.CrossRef
Zurück zum Zitat Kriegel, H., Pötke, M., Seidl, T. (2000). Managing intervals efficiently in object-relational databases. In Proceedings of the 26th international conference on very large databases (pp. 407–418). Kriegel, H., Pötke, M., Seidl, T. (2000). Managing intervals efficiently in object-relational databases. In Proceedings of the 26th international conference on very large databases (pp. 407–418).
Zurück zum Zitat Lomet, D., Hong, M., Nehme, R., Zhang, R. (2008). Transaction time indexing with version compression. Proceedings of the VLDB Endowment, 1(1), 870–881. Lomet, D., Hong, M., Nehme, R., Zhang, R. (2008). Transaction time indexing with version compression. Proceedings of the VLDB Endowment, 1(1), 870–881.
Zurück zum Zitat Mao, C., Ma, H., Tang, Y., Yao, L. (2011). Temporal data model and temporal database systems. In Y. Tang, X. Ye, N. Tang (Eds.), Temporal information processing technology and its application (pp. 69–89). Berlin, Heidelberg: Springer. Mao, C., Ma, H., Tang, Y., Yao, L. (2011). Temporal data model and temporal database systems. In Y. Tang, X. Ye, N. Tang (Eds.), Temporal information processing technology and its application (pp. 69–89). Berlin, Heidelberg: Springer.
Zurück zum Zitat Melton, J., & Simon, A.R. (2002). SQL:1999—Understanding relational language components. San Mateo: Morgan Kaufmann. Melton, J., & Simon, A.R. (2002). SQL:1999—Understanding relational language components. San Mateo: Morgan Kaufmann.
Zurück zum Zitat McKenzie, J.L.E., & Snodgrass, R.T. (1991). Evaluation of relational algebras incorporating the time dimension in databases. ACM Computing Surveys (CSUR), 23(4), 501–543.CrossRef McKenzie, J.L.E., & Snodgrass, R.T. (1991). Evaluation of relational algebras incorporating the time dimension in databases. ACM Computing Surveys (CSUR), 23(4), 501–543.CrossRef
Zurück zum Zitat Nguyen-Dinh, L.-V., Aref, W.G., Mokbel, M.F. (2010). Spatio-temporal access methods: part 2 (2003—2010). IEEE Data Engineering Bulletin, 33(2), 46–55. Nguyen-Dinh, L.-V., Aref, W.G., Mokbel, M.F. (2010). Spatio-temporal access methods: part 2 (2003—2010). IEEE Data Engineering Bulletin, 33(2), 46–55.
Zurück zum Zitat Ozsoyoglu, G., & Snodgrass, R. (1995). Temporal and real-time databases: a survey. IEEE Transations on Knowlege and Data Engineering, 7(4), 513–532.CrossRef Ozsoyoglu, G., & Snodgrass, R. (1995). Temporal and real-time databases: a survey. IEEE Transations on Knowlege and Data Engineering, 7(4), 513–532.CrossRef
Zurück zum Zitat Šaltenis, S., & Jensen, C.S. (2002). Indexing of now-relative spatio-bitemporal data. VLDB Journal, 11(1), 1–16.CrossRef Šaltenis, S., & Jensen, C.S. (2002). Indexing of now-relative spatio-bitemporal data. VLDB Journal, 11(1), 1–16.CrossRef
Zurück zum Zitat Shichao Zhang, C.Z., & Qin, Z. (2003). Modeling temporal semantics of data. Asian Journal of Information Technology, 2(1), 25–35.CrossRef Shichao Zhang, C.Z., & Qin, Z. (2003). Modeling temporal semantics of data. Asian Journal of Information Technology, 2(1), 25–35.CrossRef
Zurück zum Zitat Snodgrass, R.T. (1995). The TSQL2 temporal query language. Kluwer Academic. Snodgrass, R.T. (1995). The TSQL2 temporal query language. Kluwer Academic.
Zurück zum Zitat Stantic, B., Sattar, A., Terenziani, P. (2009). The point approach to represent it now in bitemporal databases. Journal of Intelligent Information Systems, 32(3), 297–323.CrossRef Stantic, B., Sattar, A., Terenziani, P. (2009). The point approach to represent it now in bitemporal databases. Journal of Intelligent Information Systems, 32(3), 297–323.CrossRef
Zurück zum Zitat Stantic, B., Terry, J., Topor, R.W., Sattar, A. (2010). Indexing temporal data with virtual structure. In Advances in databases and information systems—ADBIS (pp. 591–594). Stantic, B., Terry, J., Topor, R.W., Sattar, A. (2010). Indexing temporal data with virtual structure. In Advances in databases and information systems—ADBIS (pp. 591–594).
Zurück zum Zitat Stantic, B., Thornton, J., Sattar, A. (2003). A novel approach to model NOW in temporal databases. In Proceeding of the 10th international symposium on temporal representation and reasoning (TIME-ICTL 2003) (pp. 174–181). Cairns. Stantic, B., Thornton, J., Sattar, A. (2003). A novel approach to model NOW in temporal databases. In Proceeding of the 10th international symposium on temporal representation and reasoning (TIME-ICTL 2003) (pp. 174–181). Cairns.
Zurück zum Zitat Stantic, B., Topor, R.W., Terry, J., Sattar, A. (2010). Advanced indexing technique for temporal data. Computer Science and Information Systems, 7(4), 679–703.CrossRef Stantic, B., Topor, R.W., Terry, J., Sattar, A. (2010). Advanced indexing technique for temporal data. Computer Science and Information Systems, 7(4), 679–703.CrossRef
Zurück zum Zitat Tansel, A.U., Clifford, J., Gadia, S., Jajodia, S., Segev, A., Snodgrass, R. (Eds.) (1993). Temporal databases: theory, design, and implementation. Redwood City: Benjamin-Cummings. Tansel, A.U., Clifford, J., Gadia, S., Jajodia, S., Segev, A., Snodgrass, R. (Eds.) (1993). Temporal databases: theory, design, and implementation. Redwood City: Benjamin-Cummings.
Zurück zum Zitat Torp, K., Jensen, C.S., Bohlen, M. (1999). Layered implementation of temporal DBMS concepts and techniques. A TimeCenter Technical Report TR-2. Torp, K., Jensen, C.S., Bohlen, M. (1999). Layered implementation of temporal DBMS concepts and techniques. A TimeCenter Technical Report TR-2.
Zurück zum Zitat Torp, K., Jensen, C.S., Böhlen, M.H. (1997). Layered temporal dbms: concepts and techniques. In Proceedings of the 5th international conference on database systems for advanced applications (DASFAA) (pp. 371–380). Singapore: World Scientific. Torp, K., Jensen, C.S., Böhlen, M.H. (1997). Layered temporal dbms: concepts and techniques. In Proceedings of the 5th international conference on database systems for advanced applications (DASFAA) (pp. 371–380). Singapore: World Scientific.
Zurück zum Zitat Torp, K., Jensen, C.S., Snodgrass, R.T. (2000). Effective timestamping in databases. VLDB Journal: Very Large Data Bases, 8(3–4), 267–288.CrossRef Torp, K., Jensen, C.S., Snodgrass, R.T. (2000). Effective timestamping in databases. VLDB Journal: Very Large Data Bases, 8(3–4), 267–288.CrossRef
Zurück zum Zitat Torp, K., Jensen, C.S., Snodgrass, R.T. (2004). Modification semantics in now-relative databases. Information Systems, 29(8), 653–683.CrossRef Torp, K., Jensen, C.S., Snodgrass, R.T. (2004). Modification semantics in now-relative databases. Information Systems, 29(8), 653–683.CrossRef
Zurück zum Zitat Tsotras, V., & Kumar, A. (1996). Temporal database bibliography update. ACM Sigmod Record, 25(1), 41–51. Tsotras, V., & Kumar, A. (1996). Temporal database bibliography update. ACM Sigmod Record, 25(1), 41–51.
Metadaten
Titel
Querying now-relative data
verfasst von
Luca Anselma
Bela Stantic
Paolo Terenziani
Abdul Sattar
Publikationsdatum
01.10.2013
Verlag
Springer US
Erschienen in
Journal of Intelligent Information Systems / Ausgabe 2/2013
Print ISSN: 0925-9902
Elektronische ISSN: 1573-7675
DOI
https://doi.org/10.1007/s10844-013-0245-8

Weitere Artikel der Ausgabe 2/2013

Journal of Intelligent Information Systems 2/2013 Zur Ausgabe