A storage advisor for hybrid-store databases

Proceedings of the VLDB Endowment

Volumn 5, Issue 12, 2012, Pages 1748-1758

  Rösch, Philipp ^a   Dannecker, Lars ^a   Hackenbroich, Gregor ^a   Färber, Franz ^a  

^a SAP RESEARCH   (Germany)

Author keywords

[No Author keywords available]

Indexed keywords

DATABASE SYSTEMS; INFORMATION MANAGEMENT; QUERY PROCESSING;

COLUMN-ORIENTED; COST MODELING; DATABASE ADMINISTRATORS; PERFORMANCE CAPABILITY; QUERY EXECUTION; QUERY PERFORMANCE;

DIGITAL STORAGE;

EID: 84873191170     PISSN: None     EISSN: 21508097     Source Type: Conference Proceeding    
DOI: 10.14778/2367502.2367514     Document Type: Article

References (17)

1. S. Agrawal, S. Chaudhuri, L. Kollar, A. Marathe, V. Narasayya, and M. Syamala. Database Tuning Advisor for Microsoft SQL Server 2005: Demo. In Proceedings of the 2005 ACM SIGMOD International Conference on Management of Data, pages 930-932, 2005.
2. S. Agrawal, S. Chaudhuri, and V. R. Narasayya. Automated Selection of Materialized Views and Indexes in SQL Databases. In Proceedings of the 26th International Conference on Very Large Data Bases, pages 496-505, 2000.
3. S. Agrawal, V. Narasayya, and B. Yang. Integrating Vertical and Horizontal Partitioning Into Automated Physical Database Design. In Proceedings of the 2004 ACM SIGMOD International Conference on Management of Data, pages 359-370, 2004.
4. A. Ailamaki, D. J. DeWitt, M. D. Hill, and M. Skounakis. Weaving Relations for Cache Performance. In Proceedings of the 27th International Conference on Very Large Data Bases, pages 169-180, 2001.
5. P. A. Boncz, S. Manegold, and M. L. Kersten. Database Architecture Optimized for the new Bottleneck: Memory Access. In Proceedings of the 25th International Confernce on Very Large Data Bases, pages 54-65, 1999.
6. P. A. Boncz, M. Zukowski, and N. Nes. MonetDB/X100: Hyper-Pipelining Query Execution. In Proceedings of the 2nd Biennial Conference on Innovative Data Systems Research, pages 225-237, 2005.
7. S. Chaudhuri and V. R. Narasayya. An Efficient Cost-Driven Index Selection Tool for Microsoft SQL Server. In Proceedings of the 23rd International Conference on Very Large Data Bases, pages 146-155, 1997.
8. F. Faerber, S. K. Cha, J. Primsch, C. Bornhoevd, S. Sigg, and W. Lehner. SAP HANA Database - Data Management for Modern Business Applications. ACM Sigmod Record, 40(4):45-51, 2011.
9. M. Grund, J. Krüger, H. Plattner, A. Zeier, P. Cudre-Mauroux, and S. Madden. HYRISE: A Main Memory Hybrid Storage Engine. Proceedings of the 37th International Conference on Very Large Data Bases, pages 105-116, 2010.
10. H. Gupta and I. Mumick. Selection of Views to Materialize in a Data Warehouse. Proceedings of the 6th International Conference on Database Theory, pages 98-112, 1997.
11. Y. He, R. Lee, Y. Huai, Z. Shao, N. Jain, X. Zhang, and Z. Xu. RCFile: A Fast and Space-efficient Data Placement Structure in MapReduce-based Warehouse Systems. In In Proceedings of the 27th International Conference on Data Engineering, pages 1199-1208, 2011.
12. C. Lemke, K.-U. Sattler, F. Faerber, and A. Zeier. Speeding Up Queries in Column Stores: A Case for Compression. In Proceedings of the 12th International Conference on Data Warehousing and Knowledge Discovery, pages 117-129, 2010.
13. H. Plattner. A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database. In Proceedings of the 35th SIGMOD international conference on Management of data, pages 1-2, 2009.
14. R. Ramamurthy, D. J. DeWitt, and Q. Su. A Case for Fractured Mirrors. In Proceedings of the 28th International Conference on Very Large Databases, pages 89-101, 2002.
15. V. Raman, G. Swart, L. Qiao, F. Reiss, V. Dialani, D. Kossmann, I. Narang, and R. Sidle. Constant-Time Query Processing. In Proceedings of the 24th International Conference on Data Engineering, pages 60-69, 2008.
16. R. Winter. Scaling The Data Warehouse. Information Week: Research & Reports, http://www.informationweek.com/news/211100262, 2008.
17. D. C. Zilio, J. Rao, S. Lightstone, G. Lohman, A. Storm, C. Garcia-Arellano, and S. Fadden. DB2 Design Advisor: Integrated Automatic Physical Database Design. In Proceedings of the 30th International Conference on Very Large Data Bases, pages 1087-1097, 2004.