AutoPart: Automating schema design for large scientific databases using data partitioning

Proceedings of the International Conference on Scientific and Statistical Database Management, SSDBM

Volumn 16, Issue , 2004, Pages 383-392

  Papadomanolakis, Stratos ^a   Ailamaki, Anastassia ^a  

^a CARNEGIE MELLON UNIVERSITY   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

DATA PARTITIONING; DECOMPOSITION STORAGE MODEL (DSM); SCHEMA DESIGN; SCIENTIFIC DATABASES;

AUTOMATION; COMPUTATIONAL COMPLEXITY; DATA REDUCTION; INDEXING (OF INFORMATION); INTERFACES (COMPUTER); LARGE SCALE SYSTEMS; SERVERS;

DATABASE SYSTEMS;

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

References (21)

1. Agrawal S., Chaudhuri S. and Narasayya V., "Automated Selection of Materialized Views and Indexes for SQL Databases". VLDB 2000.
2. Boncz.P., Wilschut.A., Kersten.M. "Flattening an Object Algebra to Provide Performance", Proceedings of ICDE, February 1998, Orlando, Florida.
3. Ceri S., Negri M., PeIagatti G. "Horizontal Data Partitioning in Database Design", SIGMOD 1982.
4. Chatziantoniou D., Ross K.A."Groupwise Processing of Relational Queries", Proceedings of the 1997 VLDB Conference.
5. Chaudhuri S., Narasayya V., "An Efficient Cost-Driven Index Selection Tool for Microsoft SQL Server". Proceedings of VLDB 1997.
6. Copeland G.P and Khoshafian S.F. "A Decomposition Storage Model". SIGMOD 1985.
7. Cornell D.W., Yu P.S., "A Vertical Partitioning Algorithm for Relational Databases", ICDE 1987.
8. Finkelstein S et al. "Physical Database Design for Relational Databases". TODS 13(1) (1988).
9. Gray J., Slutz D., Szalay A., Thakar A., Kuntz P., Stoughton C., "Data Mining the SDSS SkyServer Database,"MSR TR 2002-1, pp1-40 2002.
10. Hammer M., Niamir B. "A Heuristic Approach to Attribute Partitioning". SIGMOD 1979.
11. Hoffer J.A., Severance D.G., "The Use of Cluster Analysis in Physical Database Design". VLDB 1975.
12. Ioannidis Y., Kang Y.C., "Randomized Algorithms for Optimizing Large Join Queries", in Proc. SIGMOD 1990.
13. Lohman G., Valentin G., Zilio D., Zuliami M., Skelly A., "DB2 Advisor: An Optimizer Smart Enough to Recommend its Own Indexes". ICDE 2000.
14. Navathe S., Ceri G., Wiederhold G., Don. J, "Vertical Partitioning Algorithms for Database Systems. ACM TODS, 9(4), 680-710, 1984.
15. Navathe S., Ra M., "Vertical Partitioning for Database Design: A Graphical Algorithm", SIGMOD 1989.
16. Ravishankar Ramamurthy, David J. DeWitt, Qi Su. "A Case for Fractured Mirrors", VLDB 2002.
17. Rao J., Zhang C., Lohman G., Megiddo N., "Automating Physical Database Design in a Parallel Database System". SIGMOD 2002.
18. Szalay A., Gray J., Thakar A., Kuntz P., Malik T., Raddick.J, Stoughton C., Vaadenberg J., "The SDSS SkyServer - Public Access to the Sloan Digital Sky Server Data", SIGMOD 2002.
19. Teorey T, Fry P.J., "The Logical Access Record Approach to Database Design", ACM Computing Surv. 12(2):179-211 (1980).
20. Tsatalos D.,Solomon M.,Ioannidis Y., "The GMAP: A Versatile Tool for Physical Data Independence", VLDB 1994
21. Zhou J., Ross K.A, "A Multi-Resolution Block Storage Model for Database Design", Proceedings of the 2003 IDEAS Conference, July 2003.