Optimizing write performance for read optimized databases

Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

Volumn 5982 LNCS, Issue PART 2, 2010, Pages 291-305

  Krueger, Jens ^a   Grund, Martin ^a   Tinnefeld, Christian ^a   Plattner, Hasso ^a   Zeier, Alexander ^a   Faerber, Franz ^b  

^a UNIVERSITY OF POTSDAM   (Germany)

^b SAP RESEARCH   (Germany)

Author keywords

[No Author keywords available]

Indexed keywords

COLUMN-ORIENTED DATABASE; COLUMN-STORE; COMPLEXITY ANALYSIS; COMPRESSION ALGORITHMS; INTERMEDIATE STORAGE; MEMORY CONSUMPTION; MERGE OPERATIONS; PERFORMANCE ENHANCEMENTS; RESOURCE CONSUMPTION; RESPONSE TIME;

BUFFER STORAGE; DATA STRUCTURES; DATABASE SYSTEMS; LOCKS (FASTENERS); OPTIMIZATION;

DATA COMPRESSION;

EID: 78650493569     PISSN: 03029743     EISSN: 16113349     Source Type: Book Series    
DOI: 10.1007/978-3-642-12098-5_23     Document Type: Conference Paper

References (21)

1. Abadi, D., Madden, S., Ferreira, M.: Integrating compression and execution in column-oriented database systems. In: SIGMOD 2006, pp. 671-682. ACM, New York (2006).
2. Abadi, D.J.: Query Execution in Column-Oriented Database Systems. PhD thesis.
3. Boncz, P.A., Manegold, S., Kersten, M.L.: Database architecture optimized for the new bottleneck: Memory access. In: VLDB, pp. 54-65 (1999).
4. Boncz, P.A., Zukowski, M., Nes, N.: Monetdb/x100: Hyper-pipelining query execution. In: CIDR, pp. 225-237 (2005).
5. Brown, K.P., Mehta, M., Carey, M.J., Livny, M.: Towards automated performance tuning for complex workloads. In: VLDB, pp. 72-84 (1994).
6. Chen, Z., Gehrke, J., Korn, F.: Query optimization in compressed database systems. In: SIGMOD 2001, pp. 271-282. ACM, New York (2001).
7. Copeland, G.P., Khoshafian, S.: A decomposition storage model. In: SIGMOD Conference, pp. 268-279 (1985).
8. French, C.D.: "one size fits all" database architectures do not work for DDS. In: SIGMOD Conference, pp. 449-450 (1995).
9. French, C.D.: Teaching an OLTP database kernel advanced data warehousing techniques. In: ICDE, pp. 194-198 (1997).
10. Harizopoulos, S., Liang, V., Abadi, D.J., Madden, S.: Performance tradeoffs in read-optimized databases. In: VLDB, pp. 487-498 (2006).
11. Holloway, A.L., DeWitt, D.J.: Read-optimized databases, in depth. PVLDB 1(1), 502-513 (2008).
12. Legler, T., Lehner, W., Ross, A.: Data mining with the SAP NetWeaver BI accelerator. In: VLDB 2006, pp. 1059-1068. VLDB Endowment (2006).
13. Pang, H., Carey, M.J., Livny, M.: Multiclass query scheduling in real-time database systems. IEEE Trans. Knowl. Data Eng. 7(4), 533-551 (1995).
14. Plattner, H.: A common database approach for OLTP and OLAP using an inmemory column database. In: SIGMOD Conference, pp. 1-2 (2009).
15. Ramamurthy, R., DeWitt, D.J., Su, Q.: A case for fractured mirrors. In: VLDB, pp. 430-441 (2002).
16. Rao, J., Ross, K.A.: Making b+-trees cache conscious in main memory. In: SIGMOD Conference, pp. 475-486 (2000).
17. Rappaport, R.L.: File structure design to facilitate on-line instantaneous updating. In: SIGMOD 1975, pp. 1-14. ACM, New York (1975).
18. Severance, D.G., Lohman, G.M.: Differential files: their application to the maintenance of large databases. ACM Trans. Database Syst. 1(3), 256-267 (1976).
19. Stonebraker, M., Abadi, D.J., Batkin, A., Chen, X., Cherniack, M., Ferreira, M., Lau, E., Lin, A., Madden, S., O'Neil, E.J., O'Neil, P.E., Rasin, A., Tran, N., Zdonik, S.B.: C-store: A column-oriented dbms. In: VLDB, pp. 553-564 (2005).
20. Westmann, T., Kossmann, D., Helmer, S., Moerkotte, G.: The implementation and performance of compressed databases. SIGMOD Rec. 29(3), 55-67 (2000).
21. Willhalm, T., Popovici, N., Boshmaf, Y., Plattner, H., Zeier, A., Schaffner, J.: Simd-scan: Ultra fast in-memory table scan using on-chip vector processing units. PVLDB 2(1), 385-394 (2009).