Performance tradeoffs in read-optimized databases

VLDB 2006 - Proceedings of the 32nd International Conference on Very Large Data Bases

Volumn , Issue , 2006, Pages 487-498

  Harizopoulos, Stavros ^a   Liang, Velen ^a   Abadi, Daniel J ^a   Madden, Samuel ^a  

^a MASSACHUSETTS INSTITUTE OF TECHNOLOGY   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

DATABASE SYSTEMS; QUERY PROCESSING; SEARCH ENGINES;

COLUMN-ORIENTED; COLUMN-ORIENTED DATABASE; CONDITION; DATA REPRESENTATIONS; LIGHT WEIGHT; OPTIMIZED PERFORMANCE; PERFORMANCE; PERFORMANCE TRADEOFF; READ PERFORMANCE; WRITE-INTENSIVE WORKLOADS;

COMMERCE;

EID: 34547435783     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: None     Document Type: Conference Paper

References (24)

1. D. J. Abadi, S. Madden, and M. Ferreira. "Integrating Compression and Execution in Column-Oriented Database Systems.," in Proc. SIGMOD, 2006.
2. S. Agrawal, V. R. Narasayya, B. Yang. "Integrating Vertical and Horizontal Partitioning Into Automated Physical Database Design.," in Proc. SIGMOD, 2004.
3. A. Ailamaki. "Database Architecture for New Hardware.," Tutorial. In Proc. VLDB, 2004.
4. A. Ailamaki, D. J. DeWitt, et al "Weaving Relations for Cache Performance.," in Proc. VLDB, 2001.
5. A. Ailamaki, D. J. DeWitt, at al "DBMSs on a modern processor: Where does time go?," in Proc. VLDB, 1999.
6. P. A. Boncz, S. Manegold, and M. L. Kersten. "Database Architecture Optimized for the New Bottleneck: Memory Access.," in Proc. VLDB, 1999.
7. P. Boncz, M. Zukowski, and N. Nes. "MonetDB/XlOO: Hyper-Pipelining Query Execution.," in Proc. CIDR, 2005.
8. A. Copeland and S. Khoshafian. "A Decomposition Storage Model.," in Proc. SIGMOD, 1985.
9. D. W. Cornell and P. S. Yu. "An Effective Approach to Vertical Partitioning for Physical Design of Relational Databases.," in IEEE Transactions on Software Engineering 16(2): 248-258, 1990.
10. J. Goldstein, R. Ramakrishnan, and U. Shaft. "Compressing Relations and Indexes.," in Proc. ICDE, 1998.
11. G Graefe and L. D. Shapiro. "Data compression and database performance.," in Proc. ACM/IEEE-CS Symposium on Applied Computing, Kansas City, MO, 1991.
12. A. Halverson, J. L. Beckmann, J. F. Naughton, and D. J. De Witt. "A Comparison of C-Store and Row-Store in a Common Framework.," Technical Report, University of Wisconsin-Madison, Department of Computer Sciences, TRI566, 2006.
13. S. Harizopoulos, V. Shkapenyuk, and A. Ailamaki. "QPipe: A Simultaneously Pipelined Relational Query Engine.," in Proc. SIGMOD, 2005.
14. J. L. Hennessy, D. A. Patterson. "Computer Architecture: A Quantitative Approach.," 2nd ed, Morgan-Kaufmann, 1996.
15. K. Keeton, D. A. Patterson, Y. Q. He, R. C. Raphael, and W. E. Baker. "Performance Characterization of a Quad Pentium Pro SMP Using OLTP Workloads.," in Proc. ISCA-25, 1998.
16. P. J. Mucci, S. Browne, C. Deane, and G Ho. "PAPI: A Portable Interface to Hardware Performance Counters.," in Proc. Department of Defense HPCMP Users Group Conference, Monterey, CA, June 1999.
17. S. Padmanabhan, T. Malkemus, R. Agarwal, and A. Jhingran. "Block Oriented Processing of Relational Database Operations in Modern Computer Architectures.," in Proc. ICDE, 2001.
18. M. Poss and D. Potapov. "Data Compression in Oracle.," in Proc. VLDB, 2003.
19. R. Ramamurthy, D. J. De Witt, and Q. Su. "A Case for Fractured Mirrors.," in Proc. VLDB, 2002.
20. M. Shao, J. Schindler, S. W. Schlosser, A. Ailamaki, and G R. Ganger. "Clotho: Decoupling memory page layout from storage organization.," in Proc. VLDB, 2004.
21. M. Stonebraker, D. J. Abadi, A. Batkin, X. Chen, M. Cherni-ack, M. Ferreira, E. Lau, A. Lin, S. Madden, E. J. O'Neil, P. E. O'Neil, A. Rasin, N. Tran, and S. B. Zdonik. "C-Store: A Column-oriented DBMS.," in Proc. VLDB, 2005.
22. T. Westmann, D. Kossmann, S. Helmer, and G Moerkotte. "The Implementation and Performance of Compressed Databases.," in SIGMOD Rec, 29(3):55-67, Sept. 2000.
23. J. Zhou and K. A. Ross. "Buffering Database Operations for Enhanced Instruction Cache Performance.," in Proc. SIGMOD, 2004.
24. M. Zukowski, S. Heman, N. Nes, and P. Boncz. "Super-Scalar RAM-CPU Cache Compression.," in Proc. ICDE, 2006.