{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2024,1,10]],"date-time":"2024-01-10T06:05:58Z","timestamp":1704866758219},"reference-count":9,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2013,8,28]]},"abstract":"<jats:p>In this demo, we present a prototype of a main memory database system which provides a wide range of temporal operators featuring predictable and interactive response times. Much of real-life data is temporal in nature, and there is an increasing application demand for temporal models and operations in databases. Nevertheless, SQL:2011 has only recently overcome a decade-long standstill on standardizing temporal features. As a result, few database systems provide any temporal support, and even those only have limited expressiveness and poor performance. Our prototype combines an in-memory column store and a novel, generic temporal index structure named Timeline Index. As we will show on a workload based on real customer use cases, it achieves predictable and interactive query performance for a wide range of temporal query types and data sizes.<\/jats:p>","DOI":"10.14778\/2536274.2536278","type":"journal-article","created":{"date-parts":[[2014,6,24]],"date-time":"2014-06-24T12:17:57Z","timestamp":1403612277000},"page":"1210-1213","source":"Crossref","is-referenced-by-count":11,"title":["Comprehensive and interactive temporal query processing with SAP HANA"],"prefix":"10.14778","volume":"6","author":[{"given":"Martin","family":"Kaufmann","sequence":"first","affiliation":[{"name":"Systems Group, ETH Z\u00fcrich, Switzerland and SAP AG, Walldorf, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Panagiotis","family":"Vagenas","sequence":"additional","affiliation":[{"name":"Systems Group, ETH Z\u00fcrich, Switzerland and SAP AG, Walldorf, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Peter M.","family":"Fischer","sequence":"additional","affiliation":[{"name":"Albert-Ludwigs-Universit\u00e4t, Freiburg, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Donald","family":"Kossmann","sequence":"additional","affiliation":[{"name":"Systems Group, ETH Z\u00fcrich, Switzerland"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Franz","family":"F\u00e4rber","sequence":"additional","affiliation":[{"name":"SAP AG, Walldorf, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2013,8]]},"reference":[{"key":"e_1_2_1_1_1","volume-title":"EDBT","author":"B\u00f6hlen M. H.","year":"2006","unstructured":"M. H. B\u00f6hlen Multi-dimensional Aggregation for Temporal Data . In EDBT , 2006 . M. H. B\u00f6hlen et al. Multi-dimensional Aggregation for Temporal Data. In EDBT, 2006."},{"key":"e_1_2_1_2_1","doi-asserted-by":"crossref","DOI":"10.1007\/978-1-4471-3033-8","volume-title":"Temporal Databases","author":"Clifford J.","year":"1995","unstructured":"J. Clifford On temporal grouping . In Temporal Databases , 1995 . J. Clifford et al. On temporal grouping. In Temporal Databases, 1995."},{"key":"e_1_2_1_3_1","volume-title":"EDBT","author":"Golab L.","year":"2004","unstructured":"L. Golab On Indexing Sliding Windows over Online Data Streams . In EDBT , 2004 . L. Golab et al. On Indexing Sliding Windows over Online Data Streams. In EDBT, 2004."},{"key":"e_1_2_1_4_1","volume-title":"SIGMOD","author":"Kaufmann M.","year":"2013","unstructured":"M. Kaufmann : A Unified Data Structure for Processing Queries on Temporal Data in SAP HANA . In SIGMOD , 2013 . M. Kaufmann et al. Timeline Index: A Unified Data Structure for Processing Queries on Temporal Data in SAP HANA. In SIGMOD, 2013."},{"issue":"3","key":"e_1_2_1_5_1","first-page":"2012","volume":"41","author":"Kulkarni K. G.","year":"2011","unstructured":"K. G. Kulkarni and J.-E. Michels . Temporal Features in SQL : 2011 . SIGMOD Record , 41 ( 3 ), 2012 . K. G. Kulkarni and J.-E. Michels. Temporal Features in SQL: 2011. SIGMOD Record, 41(3), 2012.","journal-title":"SIGMOD Record"},{"key":"e_1_2_1_6_1","doi-asserted-by":"crossref","DOI":"10.1007\/978-3-642-19363-7","volume-title":"In-Memory Data Management: An Inflection Point for Enterprise Applications. IT Pro","author":"Plattner H.","year":"2011","unstructured":"H. Plattner and A. Zeier . In-Memory Data Management: An Inflection Point for Enterprise Applications. IT Pro . 2011 . H. Plattner and A. Zeier. In-Memory Data Management: An Inflection Point for Enterprise Applications. IT Pro. 2011."},{"key":"e_1_2_1_7_1","volume-title":"IBM","author":"Saracco C. M.","year":"2012","unstructured":"C. M. Saracco A Matter of Time: Temporal Data Management in DB2 10. Technical report , IBM , 2012 . C. M. Saracco et al. A Matter of Time: Temporal Data Management in DB2 10. Technical report, IBM, 2012."},{"key":"e_1_2_1_8_1","volume-title":"TSQL2 Language Specification. SIGMOD Record, 23(1)","author":"Snodgrass R. T.","year":"1994","unstructured":"R. T. Snodgrass TSQL2 Language Specification. SIGMOD Record, 23(1) , 1994 . R. T. Snodgrass et al. TSQL2 Language Specification. SIGMOD Record, 23(1), 1994."},{"key":"e_1_2_1_9_1","volume-title":"On Computing Temporal Aggregates with Range Predicates. ACM Trans. Database Syst., 33(2)","author":"Zhang D.","year":"2008","unstructured":"D. Zhang On Computing Temporal Aggregates with Range Predicates. ACM Trans. Database Syst., 33(2) , 2008 . D. Zhang et al. On Computing Temporal Aggregates with Range Predicates. ACM Trans. Database Syst., 33(2), 2008."}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/2536274.2536278","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T10:53:08Z","timestamp":1672224788000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/2536274.2536278"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2013,8]]},"references-count":9,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2013,8,28]]}},"alternative-id":["10.14778\/2536274.2536278"],"URL":"https:\/\/doi.org\/10.14778\/2536274.2536278","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2013,8]]}}}