HyPer: A hybrid OLTP&OLAP main memory database system based on virtual memory snapshots

Proceedings - International Conference on Data Engineering

Volumn , Issue , 2011, Pages 195-206

  Kemper, Alfons ^a   Neumann, Thomas ^a  

^a TECHNICAL UNIVERSITY OF MUNICH   (Germany)

Author keywords

[No Author keywords available]

Indexed keywords

ACID PROPERTIES; ADDRESS TRANSLATION; DATABASE ARCHITECTURE; HARDWARE-ASSISTED; HIGH RATE; MAIN MEMORY DATABASE SYSTEMS; MAIN-MEMORY DATABASE; MULTIPLE QUERIES; OLAP QUERIES; ON-LINE ANALYTICAL PROCESSING; ONLINE TRANSACTION PROCESSING; PERFORMANCE ANALYSIS; REPLICATION MECHANISM; RESOURCE CONSUMPTION; TPC-H BENCHMARKS; TRANSACTION RATES; TRANSACTIONAL DATA; VIRTUAL MEMORY; VIRTUAL MEMORY MANAGEMENT;

DATA WAREHOUSES; HYBRID SYSTEMS; METADATA;

QUERY LANGUAGES;

EID: 79957859672     PISSN: 10844627     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/ICDE.2011.5767867     Document Type: Conference Paper

References (38)

1. J. Doppelhammer, T. Ḧoppler, A. Kemper, and D. Kossmann, "Database performance in the real world -TPC-D and SAP R/3," in SIGMOD, 1997.
2. H. Plattner, "A common database approach for OLTP and OLAP using an in-memory column database," in SIGMOD, 2009.
3. J. K. Ousterhout, P. Agrawal, D. Erickson, C. Kozyrakis, J. Leverich, D. Mazìeres, S. Mitra, A. Narayanan, G. M. Parulkar, M. Rosenblum, S. M. Rumble, E. Stratmann, and R. Stutsman, "The case for RAMClouds: scalable high-performance storage entirely in DRAM," Operating Systems Review, vol. 43, no. 4, 2009.
4. Intel, "Tera-scale computing research program," 2010, http://techresearch.intel.com/articles/Tera-Scale/1421.htm.
5. S. Harizopoulos, D. J. Abadi, S. Madden, and M. Stonebraker, "OLTP through the looking glass, and what we found there," in SIGMOD, 2008.
6. R. Kallman, H. Kimura, J. Natkins, A. Pavlo, A. Rasin, S. B. Zdonik, E. P. C. Jones, S. Madden, M. Stonebraker, Y. Zhang, J. Hugg, and D. J. Abadi, "H-store: a high-performance, distributed main memory transaction processing system," PVLDB, vol. 1, no. 2, 2008.
7. S. Chaudhuri and G. Weikum, "Rethinking database system architecture: Towards a self-tuning risc-style database system," in VLDB, 2000.
8. T. Neumann and G. Weikum, "The RDF-3X engine for scalable management of RDF data," VLDB J., vol. 19, no. 1, 2010.
9. Oracle, Extreme Performance Using Oracle TimesTen In-Memory Database, http://www.oracle.com/technology/products/timesten/pdf/wp/wp timesten tech.pdf, July 2009.
10. S. K. Cha and C. Song, "P*TIME: Highly scalable OLTP DBMS for managing update-intensive stream workload," in VLDB, 2004.
11. A.-P. Liedes and A. Wolski, "Siren: A memory-conserving, snapshotconsistent checkpoint algorithm for in-memory databases," in ICDE, 2006.
12. R. A. Lorie, "Physical integrity in a large segmented database," TODS, vol. 2, no. 1, 1977.
13. P. A. Boncz, S. Manegold, and M. L. Kersten, "Database architecture evolution: Mammals flourished long before dinosaurs became extinct," PVLDB, vol. 2, no. 2, 2009.
14. C. Binnig, S. Hildenbrand, and F. F̈arber, "Dictionary-based orderpreserving string compression for main memory column stores," in SIGMOD, 2009.
15. J. Kr̈uger, M. Grund, C. Tinnefeld, H. Plattner, A. Zeier, and F. Faerber, "Optimizing write performance for read optimized databases," in DASFAA, 2010.
16. A. Whitney, D. Shasha, and S. Apter, "High volume transaction processing without concurrency control, two phase commit, SQL or C," Intl. Workshop on High Performance Transaction Systems, 1997.
17. M. Stonebraker, S. Madden, D. J. Abadi, S. Harizopoulos, N. Hachem, and P. Helland, "The end of an architectural era (it's time for a complete rewrite)," in VDLB, 2007.
18. VoltDB, "Overview," http://www.voltdb.com/pdf/VoltDBOverview. pdf, March 2010.
19. C. Curino, Y. Zhang, E. P. C. Jones, and S. Madden, "Schism: a workload-driven approach to database replication and partitioning," in VLDB, 2010.
20. Ö. Ulusoy and A. P. Buchmann, "A real-time concurrency control protocol for main-memory database systems," Inf. Syst., vol. 23, no. 2, 1998
21. E. P. C. Jones, D. J. Abadi, and S. Madden, "Low overhead concurrency control for partitioned main memory databases," in SIGMOD, 2010.
22. S. Aulbach, D. Jacobs, A. Kemper, and M. Seibold, "A comparison of flexible schemas for software as a service," in SIGMOD, 2009.
23. P. Unterbrunner, G. Giannikis, G. Alonso, D. Fauser, and D. Kossmann, "Predictable performance for unpredictable workloads," PVLDB, vol. 2, no. 1, 2009.
24. I. Pandis, R. Johnson, N. Hardavellas, and A. Ailamaki, "Data-oriented transaction execution," in VLDB, 2010.
25. R. Johnson, I. Pandis, R. Stoica, M. Athanassoulis, and A. Ailamaki, "Aether: A scalable approach to logging," in VLDB, 2010.
26. V. Raman, G. Swart, L. Qiao, F. Reiss, V. Dialani, D. Kossmann, I. Narang, and R. Sidle, "Constant-time query processing," in ICDE, 2008.
27. L. Qiao, V. Raman, F. Reiss, P. J. Haas, and G. M. Lohman, "Mainmemory scan sharing for multi-core cpus," PVLDB, vol. 1, no. 1, 2008.
28. A. Kemper, D. Kossmann, and F. Matthes, "SAP R/3: A database application system (tutorial)," in SIGMOD, 1998.
29. S. Finkelstein, D. Jacobs, and R. Brendle, "Principles for inconsistency," in CIDR, 2009.
30. S. Bailey, "Us patent 7389308b2: Shadow paging," 17. Juni 2008, filed: 30. Mai 2004, granted to Microsoft.
31. P. A. Bernstein, V. Hadzilacos, and N. Goodman, Concurrency Control and Recovery in Database Systems. Addison-Wesley, 1987.
32. H. Berenson, P. A. Bernstein, J. Gray, J. Melton, E. J. O'Neil, and P. E. O'Neil, "A critique of ANSI SQL isolation levels," in SIGMOD, 1995.
33. M. J. Cahill, U. R̈ohm, and A. D. Fekete, "Serializable isolation for snapshot databases," TODS, vol. 34, no. 4, 2009.
34. T. Neumann and G. Weikum, "x-RDF-3X: fast querying, high update rates, and consistency for RDF databases," in VLDB, 2010.
35. J. Gray and A. Reuter, Transaction Processing: Concepts and Techniques. Morgan Kaufmann, 1993.
36. D. J. DeWitt, R. H. Katz, F. Olken, L. D. Shapiro, M. Stonebraker, and D. A. Wood, "Implementation techniques for main memory database systems," in SIGMOD, 1984.
37. VoltDB, VoltDB TPC-C-like Benchmark Comparison-Benchmark Description, https://community.voltdb.com/node/134, May 2010.
38. D. McCracken, "Sharing page tables in the Linux kernel," in Proceedings of the Linux Symposium. Ottawa, CA: IBM Linux Technology Center, July 23rd, 2003, http://www.kernel.org/doc/ols/2003/ols2003-pages-315-320.pdf.