Name
Abstract | ||
|---|---|---|
Managing and accessing temporal data is of increasing importance in industry. So far, most companies model the time dimension on the application layer rather than pushing down the operators to the database, which leads to a significant performance overhead. The goal of this PhD thesis is to develop a native support of temporal features for SAP HANA, which is a commercial in-memory column store database system. We investigate different alternatives to store temporal data physically and analyze the trade-offs arising from different memory layouts which cluster the data either by time or by space dimension. Taking into account the underlying physical representation, different temporal operators such as temporal aggregation, time travel and temporal join have to be executed efficiently. We present a novel data structure called Timeline Index and algorithms based on this index, which have a very competitive performance for all temporal operators beating existing best-of-breed approaches by factors, sometimes even by orders of magnitude. The results of this thesis are currently being integrated into HANA, with the goal of being shipped to the customers as a productive release within the next few months. |
Year | DOI | Venue |
|---|---|---|
2013 | 10.14778/2536274.2536333 | PVLDB |
Keywords | DocType | Volume |
time travel,different temporal operator,novel data structure,temporal feature,temporal operator,different alternative,temporal data,time dimension,main memory column store,temporal aggregation,different memory layout | Journal | 6 |
Issue | ISSN | Citations |
12 | 2150-8097 | 3 |
PageRank | References | Authors |
0.40 | 35 | 2 |
Name | Order | Citations | PageRank |
|---|---|---|---|
| Martin Kaufmann | 1 | 71 | 5.47 |
| Donald Kossmann | 2 | 6220 | 603.55 |