{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,6,10]],"date-time":"2026-06-10T16:30:22Z","timestamp":1781109022460,"version":"3.54.1"},"reference-count":37,"publisher":"IGI Global Scientific Publishing","issue":"2","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2013,4,1]]},"abstract":"<p>A central promise of cloud services is elastic, on-demand provisioning. The provisioning of data on temporarily available nodes is what makes elastic database services a hard problem. The essential task that enables elastic data services is bringing a node and its data up-to-date. Strategies for high availability do not satisfy the need in this context because they bring nodes online and up-to-date by repeating history, e.g., by log shipping. Nodes must become up-to-date and useful for query processing incrementally by key range. What is wanted is a technique such that in a newly added node, during each short period of time, an additional small key range becomes up-to-date, until eventually the entire dataset becomes up-to-date and useful for query processing, with overall update performance comparable to a traditional high-availability strategy that carries the entire dataset forward without regard to key ranges. Even without the entire dataset being available, the node is productive and participates in query processing tasks. The authors\u2019 proposed solution relies on techniques from partitioned B-trees, adaptive merging, deferred maintenance of secondary indexes and of materialized views, and query optimization using materialized views. The paper introduces a family of maintenance strategies for temporarily available copies, the space of possible query execution plans and their cost functions, as well as appropriate query optimization techniques.<\/p>","DOI":"10.4018\/jdwm.2013040101","type":"journal-article","created":{"date-parts":[[2013,7,1]],"date-time":"2013-07-01T12:22:28Z","timestamp":1372681348000},"page":"1-20","source":"Crossref","is-referenced-by-count":1,"title":["Elasticity in Cloud Databases and Their Query Processing"],"prefix":"10.4018","volume":"9","author":[{"given":"Goetz","family":"Graefe","sequence":"first","affiliation":[{"name":"Research in Business Intelligence, Hewlett-Packard Laboratories, Palo Alto, CA, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Anisoara","family":"Nica","sequence":"additional","affiliation":[{"name":"SQL Anywhere Research and Development, Sybase (An SAP Company), Waterloo, ON, Canada"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Knut","family":"Stolze","sequence":"additional","affiliation":[{"name":"Information Management Department, IBM Germany Research & Development, B\u00f6blingen, Germany"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Thomas","family":"Neumann","sequence":"additional","affiliation":[{"name":"Technische Universit\u00e4t M\u00fcnchen, Garching, Germany"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Todd","family":"Eavis","sequence":"additional","affiliation":[{"name":"Department of Computer Science and Software Engineering, Concordia University, Montreal, QC, Canada"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Ilia","family":"Petrov","sequence":"additional","affiliation":[{"name":"Data Management Lab, School of Informatics, Reutlingen University, Germany"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Elaheh","family":"Pourabbas","sequence":"additional","affiliation":[{"name":"Institute of Systems Analysis and Computer Science \u201cAntonio Ruberti\u201d, National Research Council, Rome, Italy"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"David","family":"Fekete","sequence":"additional","affiliation":[{"name":"Department of Information Systems, Universit\u00e4t M\u00fcnster, M\u00fcnster, Germany"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"2432","reference":[{"key":"jdwm.2013040101-0","unstructured":"Abderrazag, A. (2008). HACMP high-availability cluster multiprocessing: Best practices. IBM White Paper. Retrieved from http:\/\/www-01.ibm.com\/common\/ssi\/cgi-bin\/ssialias?infotype=SA&subtype=WH&htmlfid=PSW03025USEN"},{"key":"jdwm.2013040101-1","doi-asserted-by":"crossref","first-page":"922","DOI":"10.14778\/1687627.1687731","article-title":"HadoopDB: an architectural hybrid of MapReduce and DBMS technologies for analytical workloads.","volume":"2","author":"A.Abouzeid","year":"2009","journal-title":"Proceedings of the VLDB Endowment"},{"key":"jdwm.2013040101-2","doi-asserted-by":"crossref","unstructured":"Akal, F., B\u00f6hm, K., & Schek, H. J. (2002). OLAP query evaluation in a database cluster: A performance study on intra-query parallelism. In: Manolopoulos, Y., & N\u00e1vrat, P. (Eds.), ADBIS 2002. LNCS 2435, 218\u2013231.","DOI":"10.1007\/3-540-45710-0_18"},{"key":"jdwm.2013040101-3","first-page":"684","article-title":"Relational storage component for the cloud.","volume":"2011","author":"D.Arnaut","year":"2011","journal-title":"IEEE CLOUD"},{"key":"jdwm.2013040101-4","doi-asserted-by":"crossref","unstructured":"Ballinger, C. (1994). Evolving teradata decision support for massively parallel processing with UNIX. SIGMOD Conference 1994, 490","DOI":"10.1145\/191839.191944"},{"key":"jdwm.2013040101-5","doi-asserted-by":"crossref","unstructured":"Barber, R., Bendel, P., Czech, M., Draese, O., Ho, F., Hrle, N., \u2026 Stolze, K. (2011). Blink: Not your father\u2019s database! BIRTE 2011.","DOI":"10.1007\/978-3-642-33500-6_1"},{"key":"jdwm.2013040101-6","doi-asserted-by":"publisher","DOI":"10.1145\/1272998.1273036"},{"key":"jdwm.2013040101-7","doi-asserted-by":"crossref","unstructured":"Campbell, G., Kakivaya, G., & Ellis, N. (2010). Extreme scale with full SQL language support in Microsoft SQL Azure. In Proceedings of the 2010 International Conference on Management of Data (SIGMOD 2010) (pp. 1021\u20141024).","DOI":"10.1145\/1807167.1807280"},{"key":"jdwm.2013040101-8","unstructured":"Cassier, P., Defendi, A., Fischer, D., Hutchinson, J., Maneville, A., Membrini, G., \u2026 Rowley, A. (2008). System programmer\u2019s guide. Workload Manager, IBM Redbook."},{"key":"jdwm.2013040101-9","doi-asserted-by":"crossref","unstructured":"Chang, F., Dean, J., Ghemawat, S., Hsieh, W. C., Wallach, D. A., Burrows, M., \u2026 Gruber, R. E. (2008). A distributed storage system for structured data. ACM Transactions on Computer Systems, 26(2), 4:1-4:26.","DOI":"10.1145\/1365815.1365816"},{"issue":"2","key":"jdwm.2013040101-10","first-page":"1277","article-title":"PNUTS: Yahoo!'s hosted data serving platform.","volume":"1","author":"B.Cooper","year":"2008","journal-title":"PVLDB"},{"key":"jdwm.2013040101-11","doi-asserted-by":"publisher","DOI":"10.1145\/1629175.1629198"},{"key":"jdwm.2013040101-12","unstructured":"Graefe, G. (2003). Sorting and indexing with partitioned B-trees. CIDR 2003."},{"key":"jdwm.2013040101-13","doi-asserted-by":"publisher","DOI":"10.1007\/s00450-007-0022-4"},{"key":"jdwm.2013040101-14","doi-asserted-by":"crossref","first-page":"371","DOI":"10.1145\/1739041.1739087","article-title":"Self-selecting, self-tuning, incrementally optimized indexes.","volume":"2010","author":"G.Graefe","year":"2010","journal-title":"EDBT"},{"key":"jdwm.2013040101-15","first-page":"314","article-title":"Oracle parallel warehouse server.","volume":"1997","author":"G.Hallmark","year":"1997","journal-title":"ICDE"},{"key":"jdwm.2013040101-16","doi-asserted-by":"crossref","unstructured":"Hill, Z., Li, J., Mao, M., Ruiz-Alvarez, A., & Humphrey, M. (2010). Early observations on the performance of Windows Azure. In Proceedings of the 19th ACM International Symposium on High Performance Distributed Computing HPDC (pp. 367-376).","DOI":"10.1145\/1851476.1851532"},{"key":"jdwm.2013040101-17","unstructured":"IBM. (2009). IBM DB2 9.7 for Linux, UNIX, and Windows \u2013 Partitioning and clustering guide."},{"key":"jdwm.2013040101-18","first-page":"312","article-title":"Deferred maintenance of indexes and of materialized views.","volume":"2011","author":"H. A.Kuno","year":"2011","journal-title":"DNIS"},{"key":"jdwm.2013040101-19","doi-asserted-by":"publisher","DOI":"10.1109\/TKDE.2002.1033766"},{"key":"jdwm.2013040101-20","first-page":"710","article-title":"Efficient search of multi-dimensional b-trees.","volume":"1995","author":"H.Leslie","year":"1995","journal-title":"VLDB"},{"key":"jdwm.2013040101-21","doi-asserted-by":"crossref","unstructured":"MacNicol, R., & French, B. (2004). Sybase IQ multiplex: Designed For analytics. VLDB, 2004.","DOI":"10.1016\/B978-012088469-8.50111-X"},{"key":"jdwm.2013040101-22","author":"P.Mell","year":"2011","journal-title":"The NIST definition of cloud computing"},{"key":"jdwm.2013040101-23","doi-asserted-by":"crossref","unstructured":"Minhas, U. F., Rajagopalan, S., Cully, B., Aboulnaga, A., Salem, K., & Warfield, A. (2011). RemusDB: Transparent high availability for database systems. In Proceedings VLDB, 4(11), 738-748.","DOI":"10.14778\/3402707.3402714"},{"key":"jdwm.2013040101-24","doi-asserted-by":"crossref","unstructured":"Nica, A. (2011). A call for order in search space generation process of query optimization. In Proceedings of the IEEE International Conference on Data Engineering (IEEE ICDE) Workshops (pp. 4-10).","DOI":"10.1109\/ICDEW.2011.5767651"},{"key":"jdwm.2013040101-25","doi-asserted-by":"publisher","DOI":"10.1016\/j.is.2011.06.001"},{"key":"jdwm.2013040101-26","doi-asserted-by":"publisher","DOI":"10.1145\/16856.16886"},{"key":"jdwm.2013040101-27","doi-asserted-by":"crossref","unstructured":"Pavlo, A., Paulson, E., Rasin, A., Abadi, D., DeWitt, D., Madden, S., & Stonebraker, M. (2009). A comparison of approaches to large-scale data analysis. In Proceedings of the 35th SIGMOD International Conference on Management of Data, series (SIGMOD 2009) (pp. 165-178).","DOI":"10.1145\/1559845.1559865"},{"key":"jdwm.2013040101-28","doi-asserted-by":"crossref","unstructured":"Plattner, C., Alonso, G., & Ozsu, T. (2008). Extending DBMSs with satellite databases. VLDB Journal, 17(4).657\u2013682, 2008","DOI":"10.1007\/s00778-006-0026-x"},{"key":"jdwm.2013040101-29","doi-asserted-by":"crossref","unstructured":"Rahm, E. (1993). Parallel query processing in shared disk database systems. HPTS 1993.","DOI":"10.1145\/166635.166649"},{"key":"jdwm.2013040101-30","first-page":"263","article-title":"Integrating the UB-tree into a database system kernel.","volume":"2000","author":"F.Ramsak","year":"2000","journal-title":"VLDB"},{"issue":"9","key":"jdwm.2013040101-31","first-page":"1","article-title":"Data warehousing: From occasional OLAP to real-time business intelligence (Dagstuhl Seminar 11361).","volume":"1","author":"M.Schneider","year":"2011","journal-title":"Dagstuhl Reports"},{"key":"jdwm.2013040101-32","doi-asserted-by":"crossref","unstructured":"Silberstein, A., Cooper, B., Srivastava, U., Vee, E., Yerneni, R., & Ramakrishnan, R. (2008). Efficient bulk insertion into a distributed ordered table. In Proceedings of the 2008 ACM SIGMOD International Conference on Management of Data, (SIGMOD 2008) (pp. 765-778).","DOI":"10.1145\/1376616.1376693"},{"key":"jdwm.2013040101-33","author":"B.Steegmans","year":"2002","journal-title":"Squeezing the most out of dynamic SQL with DB2 for z\/OS and OS\/390"},{"issue":"2","key":"jdwm.2013040101-34","first-page":"101","article-title":"Integrating cluster-based main-memory accelerators in relational data warehouse systems.","volume":"11","author":"K.Stolze","year":"2011","journal-title":"Datenbankspektrum"},{"key":"jdwm.2013040101-35","first-page":"628","article-title":"Architecture of a highly scalable data warehouse appliance integrated to mainframe database systems.","volume":"2011","author":"K.Stolze","year":"2011","journal-title":"BTW"},{"key":"jdwm.2013040101-36","unstructured":"Stolze, K., Hrle, N., & Sch\u00fctzner, J. (2011). Partially deferred index maintenance. US Patent 20120016851."}],"container-title":["International Journal of Data Warehousing and Mining"],"original-title":[],"language":"ng","link":[{"URL":"https:\/\/www.igi-global.com\/viewtitle.aspx?TitleId=78284","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,6,1]],"date-time":"2022-06-01T17:32:10Z","timestamp":1654104730000},"score":1,"resource":{"primary":{"URL":"https:\/\/services.igi-global.com\/resolvedoi\/resolve.aspx?doi=10.4018\/jdwm.2013040101"}},"subtitle":[""],"short-title":[],"issued":{"date-parts":[[2013,4,1]]},"references-count":37,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2013,4]]}},"URL":"https:\/\/doi.org\/10.4018\/jdwm.2013040101","relation":{},"ISSN":["1548-3924","1548-3932"],"issn-type":[{"value":"1548-3924","type":"print"},{"value":"1548-3932","type":"electronic"}],"subject":[],"published":{"date-parts":[[2013,4,1]]}}}