{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2022,6,1]],"date-time":"2022-06-01T21:13:26Z","timestamp":1654118006941},"reference-count":33,"publisher":"IGI Global","issue":"4","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2014,10,1]]},"abstract":"
Data warehouse performance is usually achieved through physical data structures such as indexes or materialized views. In this context, cost models can help select a relevant set of such performance optimization structures. Nevertheless, selection becomes more complex in the cloud. The criterion to optimize is indeed at least two-dimensional, with monetary cost balancing overall query response time. This paper introduces new cost models that fit into the pay-as-you-go paradigm of cloud computing. Based on these cost models, an optimization problem is defined to discover, among candidate views, those to be materialized to minimize both the overall cost of using and maintaining the database in a public cloud and the total response time of a given query workload. It experimentally shows that maintaining materialized views is always advantageous, both in terms of performance and cost.<\/p>","DOI":"10.4018\/ijdwm.2014100101","type":"journal-article","created":{"date-parts":[[2014,10,20]],"date-time":"2014-10-20T16:05:21Z","timestamp":1413821121000},"page":"1-25","source":"Crossref","is-referenced-by-count":5,"title":["Cost Models for Selecting Materialized Views in Public Clouds"],"prefix":"10.4018","volume":"10","author":[{"given":"Romain","family":"Perriot","sequence":"first","affiliation":[{"name":"Clermont Universit\u00e9, Universit\u00e9 Blaise Pascal, Aubi\u00e8re Cedex, France"}]},{"given":"J\u00e9r\u00e9my","family":"Pfeifer","sequence":"additional","affiliation":[{"name":"Clermont Universit\u00e9, Universit\u00e9 Blaise Pascal, Aubi\u00e8re Cedex, France"}]},{"given":"Laurent","family":"d'Orazio","sequence":"additional","affiliation":[{"name":"Clermont Universit\u00e9, Universit\u00e9 Blaise Pascal, Aubi\u00e8re Cedex, France"}]},{"given":"Bruno","family":"Bachelet","sequence":"additional","affiliation":[{"name":"Clermont Universit\u00e9, Universit\u00e9 Blaise Pascal, Aubi\u00e8re Cedex, France"}]},{"given":"Sandro","family":"Bimonte","sequence":"additional","affiliation":[{"name":"IRSTEA, Clermont-Ferrand, France"}]},{"given":"J\u00e9r\u00f4me","family":"Darmont","sequence":"additional","affiliation":[{"name":"Laboratoire ERIC, Universit\u00e9 de Lyon, Lyon, France"}]}],"member":"2432","reference":[{"key":"ijdwm.2014100101-0","doi-asserted-by":"crossref","unstructured":"Agrawal, P., Silberstein, A., Cooper, B. F., Srivastava, U., & Ramakrishnan, R. (2009). Asynchronous view maintenance for VLSD databases. In Proceedings of theInternational Conference on Management of Data (SIGMOD 2009), Providence, RI (pp. 179\u2013192).","DOI":"10.1145\/1559845.1559866"},{"key":"ijdwm.2014100101-1","unstructured":"Amazon. (2013). Amazon EC2. Retrieved from http:\/\/aws.amazon.com\/ec2\/"},{"key":"ijdwm.2014100101-2","unstructured":"Amazon. (2013). Amazon relational database service (Amazon RDS). Retrieved December 2013, from http:\/\/aws.amazon.com\/rds\/"},{"key":"ijdwm.2014100101-3","doi-asserted-by":"publisher","DOI":"10.1007\/s10844-009-0080-0"},{"key":"ijdwm.2014100101-4","doi-asserted-by":"publisher","DOI":"10.1007\/3-540-45017-3_44"},{"key":"ijdwm.2014100101-5","doi-asserted-by":"publisher","DOI":"10.1007\/11788911_18"},{"key":"ijdwm.2014100101-6","doi-asserted-by":"publisher","DOI":"10.1109\/eScienceW.2010.10"},{"key":"ijdwm.2014100101-7","doi-asserted-by":"publisher","DOI":"10.1145\/1807167.1807280"},{"key":"ijdwm.2014100101-8","unstructured":"Ceri, S., & Widom, J. (1991). Deriving production rules for incremental view maintenance. In Proceedings of the17th International Conference on Very Large Data Bases (VLDB 1991), Barcelona, Spain (pp. 577\u2013589)."},{"key":"ijdwm.2014100101-9","author":"D.-S.Chen","year":"2010","journal-title":"Applied integer programming: Modeling and solution"},{"key":"ijdwm.2014100101-10","author":"C. A. C.Coello","year":"2007","journal-title":"Evolutionary algorithms for solving multi-objective problems"},{"key":"ijdwm.2014100101-11","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2009.143"},{"key":"ijdwm.2014100101-12","doi-asserted-by":"publisher","DOI":"10.1109\/4235.996017"},{"key":"ijdwm.2014100101-13","doi-asserted-by":"crossref","unstructured":"DeCandia, G., Hastorun, D., Jampani, M., Kakulapati, G., Lakshman, A., Pilchin, A., et al. (2007). Dynamo: Amazon's highly available key-value store. In Proceedings of theSymposium on Operating Systems Principles (SOSP 2007), Stevenson, WA (pp. 205\u2013220).","DOI":"10.1145\/1323293.1294281"},{"key":"ijdwm.2014100101-14","doi-asserted-by":"publisher","DOI":"10.1109\/SC.2008.5217932"},{"key":"ijdwm.2014100101-15","author":"M.Ehrgott","year":"2005","journal-title":"Multicriteria optimization"},{"key":"ijdwm.2014100101-16","doi-asserted-by":"publisher","DOI":"10.1007\/BF01096763"},{"issue":"2","key":"ijdwm.2014100101-17","first-page":"1414","article-title":"Building a high level dataflow system on top of MapReduce: The pig experience.","volume":"2","author":"A.Gates","year":"2009","journal-title":"PVLDB"},{"key":"ijdwm.2014100101-18","doi-asserted-by":"publisher","DOI":"10.1145\/1989323.1989358"},{"key":"ijdwm.2014100101-19","doi-asserted-by":"publisher","DOI":"10.1145\/1989323.1989355"},{"key":"ijdwm.2014100101-20","doi-asserted-by":"publisher","DOI":"10.1145\/1773912.1773922"},{"key":"ijdwm.2014100101-21","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2003.1260791"},{"key":"ijdwm.2014100101-22","doi-asserted-by":"publisher","DOI":"10.1145\/2206869.2206874"},{"key":"ijdwm.2014100101-23","unstructured":"Microsoft. (2013). Microsoft Azure. Retrieved from www.windowsazure.com\/"},{"key":"ijdwm.2014100101-24","doi-asserted-by":"publisher","DOI":"10.1145\/2320765.2320788"},{"key":"ijdwm.2014100101-25","doi-asserted-by":"crossref","unstructured":"O\u2019Neil, P. E., O\u2019Neil, E. J., Chen, X., & Revilak, S. (2009). The star schema benchmark and augmented fact table indexing. In Proceedings of theTPC Technology Conference (TPCTC 2009), Lyon, France (pp. 237\u2013252).","DOI":"10.1007\/978-3-642-10424-4_17"},{"key":"ijdwm.2014100101-26","unstructured":"Oracle. (2013). Your oracle database in the cloud. Retrieved December 30, 2013, from https:\/\/cloud.oracle.com\/database"},{"key":"ijdwm.2014100101-27","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2010.5447738"},{"issue":"6","key":"ijdwm.2014100101-28","first-page":"562","article-title":"How to price shared optimizations in the cloud.","volume":"5","author":"P.Upadhyaya","year":"2012","journal-title":"PVLDB"},{"issue":"1","key":"ijdwm.2014100101-29","first-page":"156","article-title":"Greedy selection of materialized views.","volume":"1","author":"T. V.Vijay Kumar","year":"2009","journal-title":"International Journal of Computer and Communication Technology"},{"key":"ijdwm.2014100101-30","doi-asserted-by":"publisher","DOI":"10.1023\/A:1008258310679"},{"key":"ijdwm.2014100101-31","unstructured":"Yang, J., Karpalem, K., & Li, Q. (1997). Algorithms for materialized view design in data warehousing environment. In Proceedings of theInternational Conference on Very Large Data Bases (VLDB 1997), Athens, Greece (pp. 136\u2013145)."},{"key":"ijdwm.2014100101-32","unstructured":"Zhou, J., Larson, P., & Elmongui, H. G. (2007). Lazy maintenance of materialized views. In Proceedings of theInternational Conference on Very Large Data Bases (VLDB 2007), Vienna, Austria (pp. 231\u2013242)."}],"container-title":["International Journal of Data Warehousing and Mining"],"original-title":[],"language":"ng","link":[{"URL":"https:\/\/www.igi-global.com\/viewtitle.aspx?TitleId=117156","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,6,1]],"date-time":"2022-06-01T20:47:57Z","timestamp":1654116477000},"score":1,"resource":{"primary":{"URL":"https:\/\/services.igi-global.com\/resolvedoi\/resolve.aspx?doi=10.4018\/ijdwm.2014100101"}},"subtitle":[""],"short-title":[],"issued":{"date-parts":[[2014,10,1]]},"references-count":33,"journal-issue":{"issue":"4","published-print":{"date-parts":[[2014,10]]}},"URL":"http:\/\/dx.doi.org\/10.4018\/ijdwm.2014100101","relation":{},"ISSN":["1548-3924","1548-3932"],"issn-type":[{"value":"1548-3924","type":"print"},{"value":"1548-3932","type":"electronic"}],"subject":["Hardware and Architecture","Software"],"published":{"date-parts":[[2014,10,1]]}}}