Relax and let the database do the partitioning online

Lecture Notes in Business Information Processing

Volumn 126 LNBIP, Issue , 2012, Pages 65-80

  Jindal, Alekh ^a   Dittrich, Jens ^a  

^a SAARLAND UNIVERSITY   (Germany)

Author keywords

changing workload; online partitioning; self tuning

Indexed keywords

DATA WAREHOUSES;

BEST FIT; BUSINESS INTELLIGENCE APPLICATIONS; CHANGING WORKLOAD; DATA SET SIZE; DATA SETS; DATA STORE; DATABASE ADMINISTRATORS; DESIGN DECISIONS; HUMAN INTERVENTION; ONE-DIMENSIONAL PARTITIONING; ONLINE PARTITIONING; ORDERS OF MAGNITUDE; PHYSICAL DESIGN; QUERY EXECUTION PLAN; SELFTUNING; TIME INTERVAL; VERTICAL PARTITIONING;

ALGORITHMS;

EID: 84866674549     PISSN: 18651348     EISSN: None     Source Type: Book Series    
DOI: 10.1007/978-3-642-33500-6_5     Document Type: Conference Paper

References (32)

1. Agarwal, S., et al.: Database Tuning Advisor for Microsoft SQL Server 2005. In: VLDB (2004)
2. Agrawal, S., Chu, E., Narasayya, V.: Automatic Physical Design Tuning:Workload as a Sequence. In: SIGMOD (2006)
3. Agrawal, S., et al.: Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design. In: SIGMOD (2004)
4. Alagiannis, I., et al.: An Automated, Yet Interactive and Portable DB Designer. In: SIGMOD (2010)
5. Bruno, N., Chaudhuri, S.: Physical Design Refinement: The "Merge-Reduce" Approach. In: Ioannidis, Y., Scholl, M.H., Schmidt, J.W., Matthes, F., Hatzopoulos, M., Böhm, K., Kemper, A., Grust, T., Böhm, C. (eds.) EDBT 2006. LNCS, vol. 3896, pp. 386-404. Springer, Heidelberg (2006)
6. Bruno, N., et al.: An Online Approach to Physical Design Tuning. In: ICDE (2007)
7. Bruno, N., Chaudhuri, S.: Constrained Physical Design Tuning. In: PVLDB (2008)
8. Chaudhuri, S., Narasayya, V.: An Efficient Cost-driven Index Selection Tool for Microsoft SQL Server. In: VLDB (1997)
9. Chu, W.W., Ieong, I.T.: A Transaction-Based Approach to Vertical Partitioning for Relational Database Systems. IEEE TSE 19(8), 804-812 (1993)
10. Cornell, D.W., Yu, P.S.: A Vertical Partitioning Algorithm for Relational Databases. In: ICDE (1987)
11. Cornell, D.W., Yu, P.S.: An Effective Approach to Vertical Partitioning for Physical Design of Relational Databases. IEEE TSE 16(2), 248-258 (1990)
12. Curino, C., et al.: Schism: a Workload-Driven Approach to Database Replication and Partitioning. In: PVLDB (2010)
13. Dittrich, J., Jindal, A.: Towards a One Size Fits All Database Architecture. In: CIDR (2011)
14. Dittrich, J.-P., Fischer, P.M., Kossmann, D.: AGILE: Adaptive Indexing for Context-aware Information Filters. In: SIGMOD (2005)
15. Grund, M., et al.: HYRISE - A Main Memory Hybrid Storage Engine. In: PVLDB (2010)
16. Hammer, M., et al.: A Heuristic Approach to Attribute Partitioning. ACM TODS (1979)
17. Hankins, R.A., Patel, J.M.: Data Morphing: An Adaptive, Cache-Conscious Storage Technique. In: VLDB (2003)
18. Hoffer, J.A., Severance, D.G.: The Use of Cluster Analysis in Physical Data Base Design. In: VLDB (1975)
19. Idreos, S., et al.: Database Cracking. In: CIDR (2007)
20. Jermaine, C., Omiecinski, E., Yee, W.G.: The partitioned exponential file for database storage management. The VLDB Journal 16, 417-437 (2007)
21. Jindal, A.: The Mimicking Octopus: Towards a one-size-fits-all Database Architecture. In: VLDB PhD Workshop (2010)
22. Kimura, H., et al.: CORADD: Correlation Aware Database Designer for Materialized Views and Indexes. In: VLDB (2010)
23. Navathe, S., et al.: Vertical Partitioning Algorithms for Database Design. ACM TODS (1984)
24. Navathe, S., Ra, M.: Vertical Partitioning for Database Design: A Graphical Algorithm. In: SIGMOD (1989)
25. O'Neil, P.E., et al.: The Log-Structured Merge-Tree (LSM-Tree). Acta Inf. (1996)
26. Ozmen, O., Salem, K., Schindler, J., Daniel, S.: Workload-Aware Storage Layout for Database Systems. In: SIGMOD (2010)
27. Papadomanolakis, S., Ailamaki, A.: AutoPart: Automating Schema Design for Large Scientific Databases Using Data Partitioning. In: SSDBM (2004)
28. Raman, V., et al.: Constant-Time Query Processing. In: ICDE (2008)
29. Sacca, D., Wiederhold, G.: Database Partitioning in a Cluster of Processors. ACM TODS 10(1), 29-56 (1985)
30. Schnaitter, K., et al.: COLT: Continuous On-Line Database Tuning. In: SIGMOD (2006)
31. Zhou, J., et al.: Dynamic Materialized Views. In: ICDE (2007)
32. Zilio, D.C., et al.: DB2 Design Advisor: Integrated Automatic Physical Database Design. In: VLDB (2004)