Online reorganization in read optimized MMDBS

Proceedings of the ACM SIGMOD International Conference on Management of Data

Volumn , Issue , 2011, Pages 1125-1136

  Beier, Felix ^a   Stolze, Knut ^b   Sattler, Kai Uwe ^a  

^a ILMENAU UNIVERSITY OF TECHNOLOGY   (Germany)

^b IBM   (Germany)

Author keywords

main memory database; MMDBS; online reorganization

Indexed keywords

DATA WAREHOUSES; ONLINE SYSTEMS; QUERY PROCESSING;

BUSINESS DATA; BUSINESS-INTELLIGENCE; CRITICAL FACTORS; DATA WAREHOUSE SYSTEMS; MAIN MEMORY DATABASE; MAIN MEMORY DATABASE SYSTEMS; MANAGEMENT DECISIONS; ON-LINE REORGANIZATION; QUERY PERFORMANCE; REORGANISATION;

DATA STRUCTURES;

EID: 79959981148     PISSN: 07308078     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1989323.1989443     Document Type: Conference Paper

References (25)

1. K. J. Achyutuni, E. Omiecinski, and S. B. Navathe. Two techniques for on-line index modification in shared nothing parallel databases. In SIGMOD, 1996.
2. I. Ahn and R. Snodgrass. Performance evaluation of a temporal database management system. SIGMOD Rec., 15(2):96-107, 1986.
3. A. Ailamaki, D. J. DeWitt, M. D. Hill, and M. Skounakis. Weaving Relations for Cache Performance. In VLDB, pages 169-180, 2001.
4. P. A. Boncz, M. Zukowski, and N. Nes. MonetDB/X100: Hyper-Pipelining Query Execution. In CIDR, pages 225-237, 2005.
5. Z. Chen, J. Gehrke, and F. Korn. Query optimization in compressed database systems. In SIGMOD, 2001.
6. G. Copeland, W. Alexander, E. Boughter, and T. Keller. Data placement in bubba. In SIGMOD, 1988.
7. CURSOR Software AG. DB2 Newsletter. Technical report, CURSOR Software AG, August 2008.
8. P. Ganesan, M. Bawa, and H. Garcia-Molina. Online balancing of range-partitioned data with applications to peer-to-peer systems. In VLDB, 2004.
9. T.-l. Hu, G. Chen, X.-y. Li, and J.-x. Dong. Automatic relational database compression scheme design based on swarm evolution. Journal of Zhejiang University - Science A, 7(10):1642-1651, 2006.
10. IBM Corp. DB2 Version 9.5 for Linux, UNIX and Windows English manuals. IBM Corp., April 2009.
11. S. Idreos, R. Kaushik, V. R. Narasayya, and R. Ramamurthy. Estimating the compression fraction of an index using sampling. In ICDE, 2010.
12. C. S. Jensen. Vacuuming in TSQL2. commentary, TSQL2 Design Committee, Sept. 1994.
13. R. Johnson, V. Raman, R. Sidle, and G. Swart. Row-wise parallel predicate evaluation. VLDB, 2008.
14. A. Koeller and E. A. Rundensteiner. Incremental Maintenance of Schema-Restructuring Views in SchemaSQL. IEEE Trans. on Knowl. and Data Eng., 16(9):1096-1111, 2004.
15. V. M. Markowitz and J. A. Makowsky. Incremental reorganization of relational databases. In VLDB, 1987.
16. V. Raman, G. Swart, L. Qiao, F. Reiss, V. Dialani, D. Kossmann, I. Narang, and R. Sidle. Constant-Time Query Processing. In ICDE, 2008.
17. D. W. Randall Davis. IBM BladeCenter HS22 Technical Introduction. Redpaper, IBM Corp, 2009.
18. G. H. Sockut and R. P. Goldberg. Database reorganization - principles and practice. ACM Comput. Surv., 11(4):371-395, 1979.
19. G. H. Sockut and B. R. Iyer. Online reorganization of databases. ACM Comput. Surv., 41(3):1-136, 2009.
20. K. Stolze, F. Beier, K.-U. Sattler, S. Sprenger, C. C. Grolimund, and M. Czech. Architecture of a Highly Scalable Data Warehouse Appliance Integrated to Mainframe Database Systems. In BTW, 2011.
21. K. Stolze, V. Raman, R. Sidle, and O. Draese. Bringing BLINK Closer to the Full Power of SQL. In BTW, 2009.
22. M. Stonebraker, D. J. Abadi, A. Batkin, X. Chen, M. Cherniack, M. Ferreira, E. Lau, A. Lin, S. Madden, E. O'Neil, P. O'Neil, A. Rasin, N. Tran, and S. Zdonik. C-store: a column-oriented DBMS. In VLDB, 2005.
23. TPC. TPC BENCHMARK DS. Standard, Transaction Processing Performance Council, 2007.
24. S. B. Yao, K. S. Das, and T. J. Teorey. A dynamic database reorganization algorithm. ACM Trans. Database Syst., 1(2):159-174, 1976.
25. 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.