{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,2,21]],"date-time":"2025-02-21T03:40:17Z","timestamp":1740109217345,"version":"3.37.3"},"reference-count":41,"publisher":"Springer Science and Business Media LLC","issue":"1","license":[{"start":{"date-parts":[[2024,12,21]],"date-time":"2024-12-21T00:00:00Z","timestamp":1734739200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"},{"start":{"date-parts":[[2024,12,21]],"date-time":"2024-12-21T00:00:00Z","timestamp":1734739200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":["The VLDB Journal"],"published-print":{"date-parts":[[2025,1]]},"DOI":"10.1007\/s00778-024-00889-2","type":"journal-article","created":{"date-parts":[[2024,12,21]],"date-time":"2024-12-21T15:08:41Z","timestamp":1734793721000},"update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":0,"title":["Reconciling tuple and attribute timestamping for temporal data warehouses"],"prefix":"10.1007","volume":"34","author":[{"given":"Waqas","family":"Ahmed","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Leticia","family":"G\u00f3mez","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-3945-4187","authenticated-orcid":false,"given":"Alejandro","family":"Vaisman","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Esteban","family":"Zim\u00e1nyi","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2024,12,21]]},"reference":[{"issue":"4","key":"889_CR1","doi-asserted-by":"publisher","first-page":"112","DOI":"10.4018\/IJDWM.2020100107","volume":"16","author":"W Ahmed","year":"2020","unstructured":"Ahmed, W., Zim\u00e1nyi, E., Vaisman, A.A., Wrembel, R.: A temporal multidimensional model and OLAP operators. Int. J. Data Warehous. Min. 16(4), 112\u2013143 (2020)","journal-title":"Int. J. Data Warehous. Min."},{"key":"889_CR2","doi-asserted-by":"crossref","unstructured":"Bakli, M., Sakr, M., Zim\u00e1nyi, E.: Distributed mobility data management in MobilityDB. In: Proceedings of the 21st IEEE international conference on mobile data management, MDM 2020, pp. 238\u2013239. IEEE Computer Society Press (2020)","DOI":"10.1109\/MDM48529.2020.00052"},{"key":"889_CR3","doi-asserted-by":"crossref","unstructured":"Bakli, M., Sakr, M., Zim\u00e1nyi, E.: Distributed spatiotemporal trajectory query processing in SQL. In: Proceedings of the 28th international conference on advances in geographic information systems, SIGSPATIAL\u201920. ACM (2020)","DOI":"10.1145\/3397536.3422262"},{"key":"889_CR4","unstructured":"Bliujute, R., Saltenis, S., Slivinskas, G., Jensen, C.S.: Systematic change management in dimensional data warehousing. Technical Report TR-23, Time Center (1998)"},{"key":"889_CR5","doi-asserted-by":"crossref","unstructured":"B\u00f6hlen, M.H., Dign\u00f6s, A., Gamper, J., Jensen, C.S.: Temporal data management: an overview. In: Proceedings of the 7th european summer school on business intelligence and big data, eBISS 2017, 324, 51\u201383 (2017)","DOI":"10.1007\/978-3-319-96655-7_3"},{"key":"889_CR6","unstructured":"B\u00f6hlen, M.H., Dign\u00f6s, A., Gamper, J., Jensen, C.S.: Database technology for processing temporal data. In: Proceedings of the 25th Int. Symp. on Temporal Representation and Reasoning, TIME 2018 (2018)"},{"key":"889_CR7","doi-asserted-by":"crossref","unstructured":"B\u00f6hlen, M., Gamper, J., Jensen, C.S.: Towards general temporal aggregation. In: Proceedings of the 25th british national conference on databases, BNCOD08, pp. 257\u2013269 (2008)","DOI":"10.1007\/978-3-540-70504-8_27"},{"key":"889_CR8","unstructured":"B\u00f6hlen, M.H., Snodgrass, R.T., Soo, M.D.: Coalescing in temporal databases. In: Proceedings of 22th international conference on very large data bases, VLDB\u201996, pp. 180\u2013191. Morgan Kaufmann (1996)"},{"key":"889_CR9","doi-asserted-by":"crossref","unstructured":"Chen, C.X., Kong, J., Zaniolo, C.: Design and implementation of a temporal extension of SQL. In: Proceedings of the 19th international conference on data engineering, 2003, pp. 689\u2013691. IEEE Computer Society (2003)","DOI":"10.1109\/ICDE.2003.1260836"},{"key":"889_CR10","doi-asserted-by":"crossref","unstructured":"Clifford, J., Tansel, A.U.: On an algebra for historical relational databases: two views. In: Proceedings of the 1985 ACM SIGMOD international conference on management of data, pp. 247\u2013265. ACM Press (1985)","DOI":"10.1145\/318898.318922"},{"issue":"4","key":"889_CR11","doi-asserted-by":"publisher","first-page":"26:1","DOI":"10.1145\/2967608","volume":"41","author":"A Dign\u00f6s","year":"2016","unstructured":"Dign\u00f6s, A., B\u00f6hlen, M.H., Gamper, J., Jensen, C.S.: Extending the kernel of a relational DBMS with comprehensive support for sequenced temporal queries. ACM Trans. Database Syst. 41(4), 26:1-26:46 (2016)","journal-title":"ACM Trans. Database Syst."},{"issue":"4","key":"889_CR12","doi-asserted-by":"publisher","first-page":"418","DOI":"10.1145\/49346.50065","volume":"13","author":"SK Gadia","year":"1988","unstructured":"Gadia, S.K.: A homogeneous relational model and query languages for temporal databases. ACM Trans. Database Syst. 13(4), 418\u2013448 (1988)","journal-title":"ACM Trans. Database Syst."},{"key":"889_CR13","doi-asserted-by":"crossref","unstructured":"Gamper, J., Ceccarello, M., Dign\u00f6s, A.: What\u2019s new in temporal databases? In: Proceedings of the 26th European Conference on Advances in Databases and Information Systems, ADBIS 2022, LNCS 13389, pp. 45\u201358. Springer (2022)","DOI":"10.1007\/978-3-031-15740-0_5"},{"issue":"2","key":"889_CR14","first-page":"144","volume":"8","author":"G Garani","year":"2016","unstructured":"Garani, G., Adam, G.K., Ventzas, D.: Temporal data warehouse logical modelling. Int. J. Data Min. Model. Manag. 8(2), 144\u2013159 (2016)","journal-title":"Int. J. Data Min. Model. Manag."},{"issue":"4","key":"889_CR15","doi-asserted-by":"publisher","first-page":"22","DOI":"10.4018\/jdwm.2012100102","volume":"8","author":"G Garani","year":"2012","unstructured":"Garani, G., Helmer, S.: Integrating star and snowflake schemas in data warehouses. Int. J. Data Warehous. Min. 8(4), 22\u201340 (2012)","journal-title":"Int. J. Data Warehous. Min."},{"issue":"1","key":"889_CR16","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1145\/352958.352963","volume":"25","author":"RH G\u00fcting","year":"2000","unstructured":"G\u00fcting, R.H., B\u00f6hlen, M.H., Erwig, M., Jensen, C.S., Lorentzos, N.A., Schneider, M., Vazirgiannis, M.: A foundation for representing and quering moving objects. ACM Trans. Database Syst. 25(1), 1\u201342 (2000)","journal-title":"ACM Trans. Database Syst."},{"key":"889_CR17","doi-asserted-by":"crossref","unstructured":"H\u00fcmmer, W., Lehner, W., Bauer, A., Schlesinger, L.: A decathlon in multidimensional modeling: Open issues and some solutions. In: Proceedings of the 4th international conference on data warehousing and knowledge discovery, DaWaK, LNCS 2454, pp. 275\u2013285. Springer (2002)","DOI":"10.1007\/3-540-46145-0_27"},{"key":"889_CR18","doi-asserted-by":"crossref","unstructured":"Hurtado, C.A., Mendelzon, A., Vaisman, A.A.: Maintaining data cubes under dimension updates. In: Proceedings of the 15th international conference on data engineering, ICDE\u201999, pp. 346\u2013355 (1999)","DOI":"10.1109\/ICDE.1999.754950"},{"issue":"7","key":"889_CR19","doi-asserted-by":"publisher","first-page":"513","DOI":"10.1016\/0306-4379(94)90013-2","volume":"19","author":"CS Jensen","year":"1994","unstructured":"Jensen, C.S., Soo, M.D., Snodgrass, R.T.: Unifying temporal data models via a conceptual model. Inf. Syst. 19(7), 513\u2013547 (1994)","journal-title":"Inf. Syst."},{"issue":"3","key":"889_CR20","doi-asserted-by":"publisher","first-page":"528","DOI":"10.1109\/TKDE.2012.74","volume":"26","author":"V Khatri","year":"2014","unstructured":"Khatri, V., Ram, S., Snodgrass, R.T., Terenziani, P.: Capturing telic\/atelic temporal data semantics: generalizing conventional conceptual models. IEEE Trans. Knowl. Data Eng. 26(3), 528\u2013548 (2014)","journal-title":"IEEE Trans. Knowl. Data Eng."},{"key":"889_CR21","volume-title":"The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling","author":"R Kimball","year":"2013","unstructured":"Kimball, R., Ross, M.: The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd edn. John Wiley & Sons (2013)","edition":"3"},{"issue":"3","key":"889_CR22","doi-asserted-by":"publisher","first-page":"34","DOI":"10.1145\/2380776.2380786","volume":"41","author":"K Kulkarni","year":"2012","unstructured":"Kulkarni, K., Michels, J.-E.: Temporal features in SQL:2011. SIGMOD Record 41(3), 34\u201343 (2012)","journal-title":"SIGMOD Record"},{"issue":"12","key":"889_CR23","doi-asserted-by":"publisher","first-page":"2035","DOI":"10.14778\/3352063.3352122","volume":"12","author":"W Lu","year":"2019","unstructured":"Lu, W., Zhao, Z., Wang, X., Li, H., Zhang, Z., Shui, Z., Ye, S., Pan, A., Du, X.: A lightweight and efficient temporal database management system in TDSQL. Proc. VLDB Endow. 12(12), 2035\u20132046 (2019)","journal-title":"Proc. VLDB Endow."},{"issue":"1","key":"889_CR24","doi-asserted-by":"publisher","first-page":"31","DOI":"10.2478\/amcs-2019-0003","volume":"29","author":"G Mahlknecht","year":"2019","unstructured":"Mahlknecht, G., Dign\u00f6s, A., Kozmina, N.: Modeling and querying facts with period timestamps in data warehouses. Int. J. Appl. Math. Comput. Sci. 29(1), 31\u201349 (2019)","journal-title":"Int. J. Appl. Math. Comput. Sci."},{"issue":"1","key":"889_CR25","doi-asserted-by":"publisher","first-page":"101","DOI":"10.1016\/j.datak.2007.06.020","volume":"64","author":"E Malinowski","year":"2008","unstructured":"Malinowski, E., Zim\u00e1nyi, E.: A conceptual model for temporal data warehouses and its transformation to the ER and the object-relational models. Data & Knowl. Eng. 64(1), 101\u2013133 (2008)","journal-title":"Data & Knowl. Eng."},{"key":"889_CR26","unstructured":"Nambiar, R.O., Poess, M.: The making of TPC-DS. In: Proceedings of the 32nd international conference on very large data bases, VLDB, pp. 1049\u20131058. ACM (2006)"},{"key":"889_CR27","doi-asserted-by":"crossref","unstructured":"Paredaens, J., De\u00a0Bra, P., Gyssens, M., Van\u00a0Gucht, D.: The nested relational database model. In: The structure of the relational database model, pp. 177\u2013201. Springer (1989)","DOI":"10.1007\/978-3-642-69956-6_7"},{"key":"889_CR28","doi-asserted-by":"crossref","unstructured":"Snodgrass, R.T. (ed): The TSQL2 Temporal Query Language. Kluwer Academic (1995)","DOI":"10.1007\/978-1-4615-2289-8"},{"key":"889_CR29","volume-title":"Developing Time-Oriented Database Applications in SQL","author":"RT Snodgrass","year":"2000","unstructured":"Snodgrass, R.T.: Developing Time-Oriented Database Applications in SQL. Morgan Kaufmann (2000)"},{"key":"889_CR30","doi-asserted-by":"publisher","first-page":"236","DOI":"10.1145\/971699.318921","volume":"14","author":"RT Snodgrass","year":"1985","unstructured":"Snodgrass, R.T., Ahn, I.: A taxonomy of time databases. ACM SIGMOD Rec. 14, 236\u2013246 (1985)","journal-title":"ACM SIGMOD Rec."},{"key":"889_CR31","volume-title":"Temporal Databases: Theory, Design, and Implementation","author":"AU Tansel","year":"1993","unstructured":"Tansel, A.U., Clifford, J., Gadia, S., Jajodia, S., Segev, A., Snodgrass, R.T.: Temporal Databases: Theory, Design, and Implementation. Benjamin Cummings (1993)"},{"key":"889_CR32","doi-asserted-by":"crossref","unstructured":"Toman, D.: Point vs. interval-based query languages for temporal databases. In: Proceedings of ACM PODS, pp. 58\u201367. ACM Press (1996)","DOI":"10.1145\/237661.237676"},{"key":"889_CR33","doi-asserted-by":"crossref","unstructured":"Toman, D.: Point-based temporal extension of temporal SQL. In: Proceedings of the 5th international conference on deductive and object-oriented databases, DOOD\u201997, LNCS 1341, pp. 103\u2013121. Springer (1997)","DOI":"10.1007\/3-540-63792-3_11"},{"key":"889_CR34","doi-asserted-by":"crossref","unstructured":"Tsikoudis, N., Shrira, L.: RID: deduplicating snapshot computations. In: Proc. of the 2020 Int. Conference on Management of Data, SIGMOD 2020, pp. 2087\u20132101. ACM (2020)","DOI":"10.1145\/3318464.3380580"},{"key":"889_CR35","unstructured":"Tsikoudis, N., Shrira, L., Cohen, S.: RQL: retrospective computations over snapshot sets. In: Proceedings of the 21st international conference on extending database technology, EDBT 2018, pp. 600\u2013611 (2018)"},{"issue":"4","key":"889_CR36","doi-asserted-by":"publisher","first-page":"170","DOI":"10.3390\/ijgi8040170","volume":"8","author":"AA Vaisman","year":"2019","unstructured":"Vaisman, A.A., Zim\u00e1nyi, E.: Mobility data warehouses. ISPRS Int. J. Geo-Inf. 8(4), 170 (2019)","journal-title":"ISPRS Int. J. Geo-Inf."},{"key":"889_CR37","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-662-65167-4","volume-title":"Data Warehouse Systems: Design and Implementation","author":"AA Vaisman","year":"2022","unstructured":"Vaisman, A.A., Zim\u00e1nyi, E.: Data Warehouse Systems: Design and Implementation, 2nd edn. Springer (2022)","edition":"2"},{"key":"889_CR38","doi-asserted-by":"crossref","unstructured":"Zhou, X., Wang, F., Zaniolo, C.: Efficient temporal coalescing query support in relational database systems. In: Proceedings of the 17th conference on database and expert systems applications, DEXA, pp. 676\u2013686 (2006)","DOI":"10.1007\/11827405_66"},{"issue":"1\u20132","key":"889_CR39","doi-asserted-by":"publisher","first-page":"179","DOI":"10.1016\/S0304-3975(96)00129-6","volume":"171","author":"E Zim\u00e1nyi","year":"1997","unstructured":"Zim\u00e1nyi, E.: Query evaluation in probabilistic relational databases. Theoret. Comput. Sci. 171(1\u20132), 179\u2013219 (1997)","journal-title":"Theoret. Comput. Sci."},{"issue":"2","key":"889_CR40","doi-asserted-by":"publisher","first-page":"16","DOI":"10.1145\/1147376.1147379","volume":"32","author":"E Zim\u00e1nyi","year":"2006","unstructured":"Zim\u00e1nyi, E.: Temporal aggregates and temporal universal quantifiers in standard SQL. SIGMOD Record 32(2), 16\u201321 (2006)","journal-title":"SIGMOD Record"},{"issue":"4","key":"889_CR41","doi-asserted-by":"publisher","first-page":"19:1","DOI":"10.1145\/3406534","volume":"45","author":"E Zim\u00e1nyi","year":"2020","unstructured":"Zim\u00e1nyi, E., Sakr, M., Lesuisse, A.: MobilityDB: a mobility database based on PostgreSQL and PostGIS. ACM Trans. Database Syst. 45(4), 19:1-19:42 (2020)","journal-title":"ACM Trans. Database Syst."}],"container-title":["The VLDB Journal"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s00778-024-00889-2.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/article\/10.1007\/s00778-024-00889-2\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/s00778-024-00889-2.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,1,27]],"date-time":"2025-01-27T05:52:36Z","timestamp":1737957156000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/s00778-024-00889-2"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2024,12,21]]},"references-count":41,"journal-issue":{"issue":"1","published-print":{"date-parts":[[2025,1]]}},"alternative-id":["889"],"URL":"https:\/\/doi.org\/10.1007\/s00778-024-00889-2","relation":{},"ISSN":["1066-8888","0949-877X"],"issn-type":[{"type":"print","value":"1066-8888"},{"type":"electronic","value":"0949-877X"}],"subject":[],"published":{"date-parts":[[2024,12,21]]},"assertion":[{"value":"22 February 2024","order":1,"name":"received","label":"Received","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"12 December 2024","order":2,"name":"accepted","label":"Accepted","group":{"name":"ArticleHistory","label":"Article History"}},{"value":"21 December 2024","order":3,"name":"first_online","label":"First Online","group":{"name":"ArticleHistory","label":"Article History"}},{"order":1,"name":"Ethics","group":{"name":"EthicsHeading","label":"Declarations"}},{"value":"The authors declare no Conflict of interest.","order":2,"name":"Ethics","group":{"name":"EthicsHeading","label":"Conflict of interest"}}],"article-number":"11"}}