Challenges in workload analyses for column and row stores

CEUR Workshop Proceedings

Volumn 581, Issue , 2010, Pages

  Lübcke, Andreas ^a  

^a OTTO VON GUERICKE UNIVERSITY   (Germany)

Author keywords

[No Author keywords available]

Indexed keywords

APPLICATION FIELDS; COLUMN-STORE; TPC-H BENCHMARKS; WORKLOAD ANALYSIS;

ARCHITECTURE; DATA WAREHOUSES;

BENCHMARKING;

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

References (18)

1. D. J. Abadi. Query execution in column-oriented database systems. PhD thesis, Cambridge, MA, USA, 2008. Adviser: Madden, Samuel.
2. D. J. Abadi, P. A. Boncz, and S. Harizopoulos. Column oriented database systems. PVLDB '09, 2(2):1664-1665, 2009.
3. D. J. Abadi, S. R. Madden, and N. Hachem. Column-stores vs. row-stores: How different are they really? In SIGMOD '08, pages 967-980, New York, NY, USA, 2008. ACM.
4. D. J. Abadi, D. S. Myers, D. J. DeWitt, and S. Madden. Materialization strategies in a column-oriented DBMS. In ICDE, pages 466-475, 2007.
5. S. Chaudhuri and V. Narasayya. Self-tuning database systems: A decade of progress. In VLDB '07, pages 3-14. VLDB Endowment, 2007.
6. C. Favre, F. Bentayeb, and O. Boussaid. Evolution of data warehouses' optimization: A workload perspective. In DaWaK '07, pages 13-22, 2007.
7. M. Holze, C. Gaidies, and N. Ritter. Consistent on-line classification of DBS workload events. In CIKM '09, pages 1641-1644, 2009.
8. T. Legler, W. Lehner, and A. Ross. Data mining with the SAP NetWeaver BI Accelerator. In VLDB '06, pages 1059-1068. VLDB Endowment, 2006.
9. H. Plattner. A common database approach for OLTP and OLAP using an in-memory column database. In SIGMOD '09, pages 1-2, New York, NY, USA, 2009. ACM.
10. K. E. E. Raatikainen. Cluster analysis and workload classification. SIGMETRICS Performance Evaluation Review, 20(4):24-30, 1993.
11. R. J. Santos and J. Bernardino. Real-time data warehouse loading methodology. In IDEAS '08, pages 49-58, New York, NY, USA, 2008. ACM.
12. J. Schaffner, A. Bog, J. Krüger, and A. Zeier. A hybrid row-column OLTP database architecture for operational reporting. In BIRTE '08, 2008.
13. D. Ślȩzak, J. Wróblewski, V. Eastwood, and P. Synak. Brighthouse: an analytic data warehouse for ad-hoc queries. PVLDB '08, 1(2):1337-1345, 2008.
14. M. Stonebraker, D. J. Abadi, A. Batkin, X. Chen, M. Cherniack, 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 VLDB '05, pages 553-564, 2005.
15. C. Turbyfill. Disk performance and access patterns for mixed database workloads. IEEE Data Engineering Bulletin, 11(1):48-54, 1988.
16. A. A. Vaisman, A. O. Mendelzon, W. Ruaro, and S. G. Cymerman. Supporting dimension updates in an OLAP server. Information Systems, 29(2):165-185, 2004.
17. Y. Zhu, L. An, and S. Liu. Data updating and query in real-time data warehouse system. In CSSE '08, pages 1295-1297, 2008.
18. M. Zukowski, P. A. Boncz, N. Nes, and S. Heman. MonetDB/X100 - a DBMS in the CPU cache. IEEE Data Engineering Bulletin, 28(2):17-22, June 2005.