Predicting in-memory database performance for automating cluster management tasks

Proceedings - International Conference on Data Engineering

Volumn , Issue , 2011, Pages 1264-1275

  Schaffner, Jan ^a   Eckart, Benjamin ^a   Jacobs, Dean ^b   Schwarz, Christian ^a   Plattner, Hasso ^a   Zeier, Alexander ^a  

^a UNIVERSITY OF POTSDAM   (Germany)

^b SAP RESEARCH   (Germany)

Author keywords

[No Author keywords available]

Indexed keywords

CLUSTER MANAGEMENT; DATABASE CLUSTERS; DATABASE PERFORMANCE; MULTI TENANTS; OPERATIONAL TASKS; RESPONSE TIME; SOFTWARE-AS-A-SERVICE;

SERVERS;

DATABASE SYSTEMS;

EID: 79957815244     PISSN: 10844627     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/ICDE.2011.5767936     Document Type: Conference Paper

References (34)

1. A. Thusoo, Z. Shao, S. Anthony, D. Borthakur, N. Jain, J. S. Sarma, R. Murthy, and H. Liu, "Data warehousing and analytics infrastructure at facebook," in Proceedings of the ACM SIGMOD International Conference on Management of Data, SIGMOD 2010, Indianapolis, Indiana, USA, June 6-10, 2010, 2010, pp. 1013-1020.
2. S. Aulbach, T. Grust, D. Jacobs, A. Kemper, and J. Rittinger, "Multitenant databases for software as a service: schema-mapping techniques," in Proceedings of the ACM SIGMOD International Conference on Management of Data, SIGMOD 2008, Vancouver, BC, Canada, June 10-12, 2008, 2008, pp. 1195-1206.
3. M. Myer, "Rightnow architecture," in HPTS, 2007.
4. "SAP BusinessObjects: Business Intelligence OnDemand," http://www. ondemand.com/businessintelligence/default.asp.
5. S. Manegold, P. A. Boncz, and M. L. Kersten, "Generic Database Cost Models for Hierarchical Memory Systems," in VLDB 2002, Proceedings of 28th International Conference on Very Large Data Bases, August 20-23, 2002, Hong Kong, China, 2002, pp. 191-202.
6. S. Listgarten and M.-A. Neimat, "Modelling Costs for a MM-DBMS," in RTDB, 1996, pp. 72-78.
7. H. Plattner, "A common database approach for OLTP and OLAP using an in-memory column database," in Proceedings of the ACM SIGMOD International Conference on Management of Data, SIGMOD 2009, Providence, Rhode Island, USA, June 29-July 2, 2009, 2009, pp. 1-2.
8. J. Schaffner, A. Bog, J. Krüger, and A. Zeier, "A Hybrid Row-Column OLTP Database Architecture for Operational Reporting," in Informal Proceedings of the Second International Workshop on Business Intelligence for the Real-Time Enterprise, BIRTE 2008, in conjunction with VLDB'08, August 24, 2008, Auckland, New Zealand, 2008.
9. B. Jaecksch, W. Lehner, and F. Faerber, "A plan for OLAP," in EDBT 2010, 13th International Conference on Extending Database Technology, Lausanne, Switzerland, March 22-26, 2010, Proceedings, 2010, pp. 681-686.
10. L. Lamport, "The Part-Time Parliament," ACM Trans. Comput. Syst., vol. 16, no. 2, pp. 133-169, 1998. (Pubitemid 128482394)
11. H. Berenson, P. A. Bernstein, J. Gray, J. Melton, E. J. O'Neil, and P. E. O'Neil, "A Critique of ANSI SQL Isolation Levels," in Proceedings of the 1995 ACM SIGMOD International Conference on Management of Data, San Jose, California, May 22-25, 1995, 1995, pp. 1-10.
12. J. Krüger, M. Grund, C. Tinnefeld, H. Plattner, A. Zeier, and F. Faerber, "Optimizing Write Performance for Read Optimized Databases," in Database Systems for Advanced Applications, 15th International Conference, DASFAA 2010, Tsukuba, Japan, April 1-4, 2010, Proceedings, Part II, 2010, pp. 291-305.
13. D. Jacobs and S. Aulbach, "Ruminations on Multi-Tenant Databases," in Datenbanksysteme in Business, Technologie und Web (BTW 2007), 12. Fachtagung des GI-Fachbereichs "Datenbanken und Informationssysteme" (DBIS), Proceedings, 7.-9. März 2007, Aachen, Germany, 2007, pp. 514-521.
14. P. E. O'Neil, E. J. O'Neil, X. Chen, and S. Revilak, "The Star Schema Benchmark and Augmented Fact Table Indexing," in Performance Evaluation and Benchmarking, First TPC Technology Conference, TPCTC 2009, Lyon, France, August 24-28, 2009, Revised Selected Papers, 2009, pp. 237-252.
15. "TPC-H," http://www.tpc.org/tpch/.
16. S. Sivasubramanian, G. Pierre, M. van Steen, and G. Alonso, "Analysis of Caching and Replication Strategies for Web Applications," IEEE Internet Computing, vol. 11, no. 1, pp. 60-66, 2007. (Pubitemid 46332144)
17. G. DeCandia, D. Hastorun, M. Jampani, G. Kakulapati, A. Lakshman, A. Pilchin, S. Sivasubramanian, P. Vosshall, and W. Vogels, "Dynamo: amazon's highly available key-value store," in SOSP, 2007, pp. 205-220. (Pubitemid 351429377)
18. D. S. Johnson, "Approximation Algorithms for Combinatorial Problems," J. Comput. Syst. Sci., vol. 9, no. 3, pp. 256-278, 1974.
19. S. Krompass, U. Dayal, H. A. Kuno, and A. Kemper, "Dynamic Workload Management for Very Large Data Warehouses: Juggling Feathers and Bowling Balls," in Proceedings of the 33rd International Conference on Very Large Data Bases, University of Vienna, Austria, September 23-27, 2007, 2007, pp. 1105-1115.
20. S. Tozer, T. Brecht, and A. Aboulnaga, "Q-Cop: Avoiding bad query mixes to minimize client timeouts under heavy loads," in Proceedings of the 26th International Conference on Data Engineering, ICDE 2010, March 1-6, 2010, Long Beach, California, USA, 2010, pp. 397-408.
21. A. Ganapathi, H. A. Kuno, U. Dayal, J. L. Wiener, A. Fox, M. I. Jordan, and D. A. Patterson, "Predicting Multiple Metrics for Queries: Better Decisions Enabled by Machine Learning," in Proceedings of the 25th International Conference on Data Engineering, ICDE 2009, March 29 2009-April 2 2009, Shanghai, China, 2009, pp. 592-603.
22. M. R. Hines, U. Deshpande, and K. Gopalan, "Post-copy live migration of virtual machines," Operating Systems Review, vol. 43, no. 3, pp. 14-26, 2009.
23. S. Hacking and B. Hudzia, "Improving the live migration process of large enterprise applications," in VTDC '09: Proceedings of the 3rd international workshop on Virtualization technologies in distributed computing. New York, NY, USA: ACM, 2009, pp. 51-58.
24. M. Richmond and M. Hitchens, "A New Process Migration Algorithm," Operating Systems Review, vol. 31, no. 1, pp. 31-42, 1997. (Pubitemid 127466146)
25. J. Shanmugasundaram, and R. Yerneni, "A Scalable Data Platform for a Large Number of Small Applications," in CIDR 2009, Fourth Biennial Conference on Innovative Data Systems Research, Asilomar, CA, USA, January 4-7, 2009, Online Proceedings, 2009.
26. E. G. Coffman, Jr., M. R. Garey, and D. S. Johnson, Approximation algorithms for bin packing: a survey. Boston, MA, USA: PWS Publishing Co., 1997.
27. "DBC/1012 Database Computer System Manual Release 2," Teradata Corporation Document No. C10-0001-02, 1985.
28. D. J. Dewitt, S. Ghandeharizadeh, D. A. Schneider, A. Bricker, H. I. Hsiao, and R. Rasmussen, "The Gamma Database Machine Project," IEEE Transactions on Knowledge and Data Engineering, vol. 2, no. 1, pp. 44-62, 1990.
29. G. Copeland, W. Alexander, E. Boughter, and T. Keller, "Data Placement in Bubba," in SIGMOD '88: Proceedings of the 1988 ACM SIGMOD International Conference on Management of Data. New York, NY, USA: ACM, 1988, pp. 99-108.
30. D. Sacca and G. Wiederhold, "Database Partitioning in a Cluster of Processors," ACM Transactions on Database Systems (TODS), Jan 1985. [Online]. Available: http://portal.acm.org/citation.cfm?id= 3161&dl=GUIDE
31. U. C. Jennie Rogers, Olga Papaemmanouil, "A generic auto-provisioning framework for cloud databases," 5th International Workshop on Self-Managing Database Systems (SMDB 2010), 2010.
32. B. D. Abrahao, V. Almeida, J. M. Almeida, A. Zhang, and F. Safai, "Self-Adaptive SLA-Driven Capacity Management for Internet Services," in Management of Integrated End-to-End Communications and Services, 10th IEEE/IFIP Network Operations and Management Symposium, NOMS 2006, Vancouver, Canada, April 3-7, 2006. Proceedings, 2006, pp. 557-568. (Pubitemid 46948713)
33. J. O. Kephart and R. Das, "Achieving Self-Management via Utility Functions," IEEE Internet Computing, vol. 11, no. 1, pp. 40-48, 2007. (Pubitemid 46332142)
34. N. W. Paton, M. A. T. Aragão, K. Lee, A. A. A. Fernandes, and R. Sakellariou, "Optimizing Utility in Cloud Computing through Autonomic Workload Execution," IEEE Data Eng. Bull., vol. 32, no. 1, pp. 51-58, 2009.