{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,5,16]],"date-time":"2026-05-16T05:47:10Z","timestamp":1778910430027,"version":"3.51.4"},"publisher-location":"Cham","reference-count":37,"publisher":"Springer International Publishing","isbn-type":[{"value":"9783319659299","type":"print"},{"value":"9783319659305","type":"electronic"}],"license":[{"start":{"date-parts":[[2017,1,1]],"date-time":"2017-01-01T00:00:00Z","timestamp":1483228800000},"content-version":"unspecified","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2017]]},"DOI":"10.1007\/978-3-319-65930-5_1","type":"book-chapter","created":{"date-parts":[[2017,8,14]],"date-time":"2017-08-14T14:18:51Z","timestamp":1502720331000},"page":"3-16","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":16,"title":["Efficient Big Data Modelling and Organization for Hadoop Hive-Based Data Warehouses"],"prefix":"10.1007","author":[{"ORCID":"https:\/\/orcid.org\/0000-0003-3459-0195","authenticated-orcid":false,"given":"Eduarda","family":"Costa","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-0011-6030","authenticated-orcid":false,"given":"Carlos","family":"Costa","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-3249-6229","authenticated-orcid":false,"given":"Maribel Yasmina","family":"Santos","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2017,8,15]]},"reference":[{"key":"1_CR1","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1089\/big.2012.1503","volume":"1","author":"E Dumbill","year":"2013","unstructured":"Dumbill, E.: Making sense of big data. Big Data 1, 1\u20132 (2013). doi:10.1089\/big.2012.1503","journal-title":"Big Data"},{"key":"1_CR2","doi-asserted-by":"publisher","first-page":"171","DOI":"10.1007\/s11036-013-0489-0","volume":"19","author":"M Chen","year":"2014","unstructured":"Chen, M., Mao, S., Liu, Y.: Big data: a survey. Mob. Netw. Appl. 19, 171\u2013209 (2014). doi:10.1007\/s11036-013-0489-0","journal-title":"Mob. Netw. Appl."},{"key":"1_CR3","unstructured":"Ward, J.S., Barker, A.: Undefined by data: a survey of big data definitions. arXiv:1309.5821 [cs. DB] (2013)"},{"key":"1_CR4","unstructured":"NBD-PWG: NIST Big Data Interoperability Framework: Volume 6, Reference Architecture. National Institute of Standards and Technology (2015)"},{"key":"1_CR5","doi-asserted-by":"publisher","first-page":"314","DOI":"10.1016\/j.ins.2014.01.015","volume":"275","author":"CL Philip Chen","year":"2014","unstructured":"Philip Chen, C.L., Zhang, C.-Y.: Data-intensive applications, challenges, techniques and technologies: a survey on Big Data. Inf. Sci. 275, 314\u2013347 (2014). doi:10.1016\/j.ins.2014.01.015","journal-title":"Inf. Sci."},{"key":"1_CR6","volume-title":"Data Warehousing in the Age of Big Data","author":"K Krishnan","year":"2013","unstructured":"Krishnan, K.: Data Warehousing in the Age of Big Data. Morgan Kaufmann Publishers Inc., San Francisco (2013)"},{"key":"1_CR7","doi-asserted-by":"crossref","unstructured":"Shvachko, K., Kuang, H., Radia, S., Chansler, R.: The hadoop distributed file system. In: 2010 IEEE 26th Symposium on Mass Storage Systems and Technologies (MSST), pp. 1\u201310 (2010)","DOI":"10.1109\/MSST.2010.5496972"},{"key":"1_CR8","doi-asserted-by":"crossref","unstructured":"Thusoo, A., Shao, Z., Anthony, S., Borthakur, D., Jain, N., Sen Sarma, J., Murthy, R., Liu, H.: Data warehousing and analytics infrastructure at Facebook. In: Proceedings of the 2010 ACM SIGMOD International Conference on Management of Data, pp. 1013\u20131020. ACM, New York (2010)","DOI":"10.1145\/1807167.1807278"},{"key":"1_CR9","unstructured":"Apache Hadoop: Welcome to Apache Hadoop. https:\/\/hadoop.apache.org\/"},{"key":"1_CR10","doi-asserted-by":"crossref","unstructured":"Vavilapalli, V.K., Murthy, A.C., Douglas, C., Agarwal, S., Konar, M., Evans, R., Graves, T., Lowe, J., Shah, H., Seth, S., Saha, B., Curino, C., O\u2019Malley, O., Radia, S., Reed, B., Baldeschwieler, E.: Apache hadoop YARN: yet another resource negotiator. In: Proceedings of the 4th Annual Symposium on Cloud Computing, pp. 5:1\u20135:16. ACM, New York (2013)","DOI":"10.1145\/2523616.2523633"},{"key":"1_CR11","volume-title":"The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling","author":"R Kimball","year":"2013","unstructured":"Kimball, R., Ross, M.: The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling. Wiley, Hoboken (2013)"},{"key":"1_CR12","unstructured":"Russom, P.: Evolving data warehouse architectures in the age of big data. The Data Warehouse Institute (2014)"},{"key":"1_CR13","unstructured":"Russom, P.: Data warehouse modernization in the age of big data analytics. The Data Warehouse Institute (2016)"},{"key":"1_CR14","doi-asserted-by":"crossref","unstructured":"Thusoo, A., Sarma, J.S., Jain, N., Shao, Z., Chakka, P., Zhang, N., Antony, S., Liu, H., Murthy, R.: Hive-a petabyte scale data warehouse using hadoop. In: IEEE 26th International Conference on Data Engineering (ICDE), pp. 996\u20131005. IEEE (2010)","DOI":"10.1109\/ICDE.2010.5447738"},{"key":"1_CR15","doi-asserted-by":"crossref","unstructured":"Huai, Y., Chauhan, A., Gates, A., Hagleitner, G., Hanson, E.N., O\u2019Malley, O., Pandey, J., Yuan, Y., Lee, R., Zhang, X.: Major technical advancements in apache Hive. In: Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data, pp. 1235\u20131246. ACM, New York (2014)","DOI":"10.1145\/2588555.2595630"},{"key":"1_CR16","unstructured":"O\u2019Neil, P.E., O\u2019Neil, E.J., Chen, X.: The star schema benchmark (SSB) (2009)"},{"key":"1_CR17","doi-asserted-by":"publisher","first-page":"1295","DOI":"10.14778\/2732977.2733002","volume":"7","author":"A Floratou","year":"2014","unstructured":"Floratou, A., Minhas, U.F., \u00d6zcan, F.: SQL-on-hadoop: full circle back to shared-nothing database architectures. Proc. VLDB Endow. 7, 1295\u20131306 (2014). doi:10.14778\/2732977.2733002","journal-title":"Proc. VLDB Endow."},{"key":"1_CR18","doi-asserted-by":"crossref","unstructured":"Tria, F.D., Lefons, E., Tangorra, F.: Design process for big data warehouses. In: 2014 International Conference on Data Science and Advanced Analytics (DSAA), pp. 512\u2013518 (2014)","DOI":"10.1109\/DSAA.2014.7058120"},{"key":"1_CR19","doi-asserted-by":"crossref","unstructured":"Goss, R.G., Veeramuthu, K.: Heading towards big data building a better data warehouse for more data, more speed, and more users. In: 2013 24th Annual SEMI Advanced Semiconductor Manufacturing Conference (ASMC), pp. 220\u2013225. IEEE (2013)","DOI":"10.1109\/ASMC.2013.6552808"},{"key":"1_CR20","volume-title":"Big Data Imperatives: Enterprise: Big Data Warehouse, BI Implementations and Analytics","author":"S Mohanty","year":"2013","unstructured":"Mohanty, S., Jagadeesh, M., Srivatsa, H.: Big Data Imperatives: Enterprise: Big Data Warehouse, BI Implementations and Analytics. Apress, New York City (2013)"},{"key":"1_CR21","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1007\/978-3-319-40973-3_48","volume-title":"Data Mining and Big Data (DMBD)","author":"MY Santos","year":"2016","unstructured":"Santos, M.Y., Costa, C.: Data models in NoSQL databases for big data contexts. In: Tan, Y., Shi, Y. (eds.) DMBD 2016. LNCS, vol. 9714, pp. 1\u201311. Springer, Cham (2016). doi:10.1007\/978-3-319-40973-3_48"},{"key":"1_CR22","doi-asserted-by":"crossref","unstructured":"Santos, M.Y., Costa, C.: Data warehousing in big data: from multidimensional to tabular data models. In: Ninth International C* Conference on Computer Science & Software Engineering (C3S2E), pp. 51\u201360. ICPS (ACM) (2016)","DOI":"10.1145\/2948992.2949024"},{"key":"1_CR23","doi-asserted-by":"publisher","first-page":"61","DOI":"10.1016\/j.dss.2016.12.002","volume":"95","author":"N Jukic","year":"2017","unstructured":"Jukic, N., Jukic, B., Sharma, A., Nestorov, S., Korallus Arnold, B.: Expediting analytical databases with columnar approach. Decis. Support Syst. 95, 61\u201381 (2017). doi:10.1016\/j.dss.2016.12.002","journal-title":"Decis. Support Syst."},{"key":"1_CR24","unstructured":"Apache Hive: Apache Hive Documentation - Apache Software Foundation. https:\/\/cwiki.apache.org\/confluence\/display\/Hive\/Home"},{"key":"1_CR25","doi-asserted-by":"publisher","first-page":"12","DOI":"10.1145\/1978915.1978919","volume":"39","author":"R Cattell","year":"2011","unstructured":"Cattell, R.: Scalable SQL and NoSQL data stores. ACM SIGMOD Rec. 39, 12\u201327 (2011). doi:10.1145\/1978915.1978919","journal-title":"ACM SIGMOD Rec."},{"key":"1_CR26","doi-asserted-by":"crossref","unstructured":"Chevalier, M., Malki, M.E., Kopliku, A., Teste, O., Tournier, R.: Document-oriented models for data warehouses - NoSQL document-oriented for data warehouses. Presented at the 18th International Conference on Enterprise Information Systems 2 March (2017)","DOI":"10.5220\/0005830801420149"},{"key":"1_CR27","doi-asserted-by":"publisher","first-page":"255","DOI":"10.1016\/j.procs.2016.08.138","volume":"96","author":"R Yangui","year":"2016","unstructured":"Yangui, R., Nabli, A., Gargouri, F.: Automatic transformation of data warehouse schema to NoSQL data base. Procedia Comput Sci. 96, 255\u2013264 (2016). doi:10.1016\/j.procs.2016.08.138","journal-title":"Procedia Comput Sci."},{"key":"1_CR28","unstructured":"Presto: Presto | Distributed SQL Query Engine for Big Data. https:\/\/prestodb.io\/"},{"key":"1_CR29","doi-asserted-by":"crossref","unstructured":"Kornacker, M., Behm, A., Bittorf, V., Bobrovytsky, T., Choi, A., Erickson, J., Grund, M., Hecht, D., Jacobs, M., Joshi, I., Kuff, L., Kumar, D., Leblang, A., Li, N., Robinson, H., Rorke, D., Rus, S., Russell, J., Tsirogiannis, D., Wanderman-milne, S., Yoder, M.: Impala: a modern, open-source SQL engine for hadoop. In: Proceedings of the CIDR 2015, California, USA (2015)","DOI":"10.1007\/978-3-658-11589-0_8"},{"key":"1_CR30","doi-asserted-by":"crossref","unstructured":"Armbrust, M., Xin, R.S., Lian, C., Huai, Y., Liu, D., Bradley, J.K., Meng, X., Kaftan, T., Franklin, M.J., Ghodsi, A., et al.: Spark SQL: relational data processing in spark. In: Proceedings of the 2015 ACM SIGMOD International Conference on Management of Data, pp. 1383\u20131394. ACM (2015)","DOI":"10.1145\/2723372.2742797"},{"key":"1_CR31","doi-asserted-by":"publisher","first-page":"100","DOI":"10.1089\/big.2013.0011","volume":"1","author":"M Hausenblas","year":"2013","unstructured":"Hausenblas, M., Nadeau, J.: Apache Drill: interactive ad-hoc analysis at scale. Big Data 1, 100\u2013104 (2013)","journal-title":"Big Data"},{"key":"1_CR32","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"154","DOI":"10.1007\/978-3-319-13021-7_12","volume-title":"Big Data Benchmarks, Performance Optimization, and Emerging Hardware","author":"Y Chen","year":"2014","unstructured":"Chen, Y., Qin, X., Bian, H., Chen, J., Dong, Z., Du, X., Gao, Y., Liu, D., Lu, J., Zhang, H.: A study of SQL-on-hadoop systems. In: Zhan, J., Han, R., Weng, C. (eds.) BPOE 2014. LNCS, vol. 8807, pp. 154\u2013166. Springer, Cham (2014). doi:10.1007\/978-3-319-13021-7_12"},{"key":"1_CR33","doi-asserted-by":"crossref","unstructured":"Kornacker, M., Behm, A., Bittorf, V., Bobrovytsky, T., Choi, A., Erickson, J., Grund, M., Hecht, D., Jacobs, M., Joshi, I., Kuff, L., Kumar, D., Leblang, A., Li, N., Robinson, H., Rorke, D., Rus, S., Russell, J., Tsirogiannis, D., Wanderman-milne, S., Yoder, M.: Impala: a modern, open-source SQL engine for hadoop. In: Proceedings of the CIDR 2015, California, USA (2015)","DOI":"10.1007\/978-3-658-11589-0_8"},{"key":"1_CR34","doi-asserted-by":"crossref","unstructured":"Santos, M.Y., Costa, C., Galv\u00e3o, J., Andrade, C., Martinho, B., Lima, F.V., Costa, E.: Evaluating SQL-on-hadoop for big data warehousing on not-so-good hardware. In: Proceedings of International Database Engineering & Applications Symposium (IDEAS 2017), Bristol, United Kingdom (2017)","DOI":"10.1145\/3105831.3105842"},{"key":"1_CR35","first-page":"111","volume":"4","author":"EY Santos","year":"2017","unstructured":"Santos, M.Y., Martinho, B., Costa, C.: Modelling and implementing big data warehouses for decision support. J. Manag. Anal. 4, 111\u2013129 (2017)","journal-title":"J. Manag. Anal."},{"key":"1_CR36","volume-title":"Programming Hive","author":"E Capriolo","year":"2012","unstructured":"Capriolo, E., Wampler, D., Rutherglen, J.: Programming Hive. O\u2019Reilly Media Inc., Sebastopol (2012)"},{"key":"1_CR37","volume-title":"Building the Data Warehouse","author":"WH Inmon","year":"2005","unstructured":"Inmon, W.H.: Building the Data Warehouse. Wiley, Hoboken (2005)"}],"container-title":["Lecture Notes in Business Information Processing","Information Systems"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-319-65930-5_1","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,24]],"date-time":"2025-06-24T22:45:55Z","timestamp":1750805155000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/978-3-319-65930-5_1"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2017]]},"ISBN":["9783319659299","9783319659305"],"references-count":37,"URL":"https:\/\/doi.org\/10.1007\/978-3-319-65930-5_1","relation":{},"ISSN":["1865-1348","1865-1356"],"issn-type":[{"value":"1865-1348","type":"print"},{"value":"1865-1356","type":"electronic"}],"subject":[],"published":{"date-parts":[[2017]]},"assertion":[{"value":"15 August 2017","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"EMCIS","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"European, Mediterranean, and Middle Eastern Conference on Information Systems","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Coimbra","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Portugal","order":4,"name":"conference_country","label":"Conference Country","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2017","order":5,"name":"conference_year","label":"Conference Year","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"7 September 2017","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"8 September 2017","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"14","order":9,"name":"conference_number","label":"Conference Number","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"emcis2017","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"http:\/\/emcis.eu\/","order":11,"name":"conference_url","label":"Conference URL","group":{"name":"ConferenceInfo","label":"Conference Information"}}]}}