{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,10,16]],"date-time":"2026-10-16T06:46:51Z","timestamp":1792133211312,"version":"4.4.0"},"publisher-location":"New York, NY","reference-count":30,"publisher":"Springer New York","isbn-type":[{"value":"9781461482666","type":"print"},{"value":"9781461482659","type":"electronic"}],"license":[{"start":{"date-parts":[[2018,1,1]],"date-time":"2018-01-01T00:00:00Z","timestamp":1514764800000},"content-version":"tdm","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"},{"start":{"date-parts":[[2018,1,1]],"date-time":"2018-01-01T00:00:00Z","timestamp":1514764800000},"content-version":"vor","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":[[2018]]},"DOI":"10.1007\/978-1-4614-8265-9_158","type":"book-chapter","created":{"date-parts":[[2018,12,6]],"date-time":"2018-12-06T08:01:18Z","timestamp":1544083278000},"page":"1432-1440","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":2,"title":["Extraction, Transformation, and Loading"],"prefix":"10.1007","author":[{"given":"Alkis","family":"Simitsis","sequence":"first","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Panos","family":"Vassiliadis","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"297","published-online":{"date-parts":[[2018,12,7]]},"reference":[{"issue":"3","key":"158_CR5448","doi-asserted-by":"publisher","first-page":"46","DOI":"10.4018\/jdwm.2013070103","volume":"9","author":"ZE Akkaoui","year":"2013","unstructured":"Akkaoui ZE, Zim\u00e1nyi E, Maz\u00f3n J, Trujillo J. A BPMN-based design and maintenance framework for ETL processes. Int J Data Warehouse Min. 2013;9(3):46\u201372.","journal-title":"Int J Data Warehouse Min"},{"key":"158_CR5449","doi-asserted-by":"crossref","unstructured":"Dayal U, Castellanos M, Simitsis A, Wilkinson K. Data integration flows for business intelligence. In: Advances in Database Technology, Proceedings of the 12th International Conference on Extending Database Technology; 2009. p. 1\u201311.","DOI":"10.1145\/1516360.1516362"},{"issue":"1","key":"158_CR5450","doi-asserted-by":"publisher","first-page":"174","DOI":"10.1145\/1061318.1061323","volume":"30","author":"R Fagin","year":"2005","unstructured":"Fagin R, Kolaitis PG, Popa L. Data exchange: getting to the core. ACM Trans Database Syst. 2005;30(1):174\u2013210.","journal-title":"ACM Trans Database Syst"},{"issue":"2","key":"158_CR5451","doi-asserted-by":"publisher","first-page":"105","DOI":"10.14778\/1921071.1921077","volume":"4","author":"M Grund","year":"2010","unstructured":"Grund M, Kr\u00fcger J, Plattner H, Zeier A, Cudr\u00e9-Mauroux P, Madden S. HYRISE \u2013 a main memory hybrid storage engine. Proc. VLDB Endowment. 2010;4(2):105\u201316.","journal-title":"Proc. VLDB Endowment."},{"key":"158_CR5452","doi-asserted-by":"crossref","unstructured":"Haas LM, Hern\u00e1ndez MA, Ho H, Popa L, Roth M. Clio grows up: from research prototype to industrial tool. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 2005. p. 805\u201310.","DOI":"10.1145\/1066157.1066252"},{"key":"158_CR5453","unstructured":"Halasipuram R, Deshpande PM, Padmanabhan S. Determining essential statistics for cost based optimization of an ETL workflow. In: Proceedings of the 17th International Conference on Extending Database Technology; 2014. p. 307\u201318."},{"key":"158_CR5454","volume-title":"Building the data warehouse","author":"W Inmon","year":"1996","unstructured":"Inmon W. Building the data warehouse. 2nd ed. New York: John Wiley & Sons; 1996.","edition":"2"},{"key":"158_CR5455","doi-asserted-by":"crossref","unstructured":"Kemper A, Neumann T. Hyper: a hybrid OLTP&OLAP main memory database system based on virtual memory snapshots. In: Proceedings of the 27th International Conference on Data Engineering; 2011. p. 195\u2013206.","DOI":"10.1109\/ICDE.2011.5767867"},{"key":"158_CR5456","volume-title":"The data warehouse lifecycle toolkit: expert methods for designing, developing, and deploying data warehouses","author":"R Kimbal","year":"1998","unstructured":"Kimbal R, Reeves L, Ross M, Thornthwaite W. The data warehouse lifecycle toolkit: expert methods for designing, developing, and deploying data warehouses. New York: Wiley; 1998."},{"key":"158_CR5457","unstructured":"Labio W, Garcia-Molina H. Efficient snapshot differential algorithms for data warehousing. In: Proceedings of the 22th International Conference on Very Large Data Bases; 1996. p. 63\u201374."},{"key":"158_CR5458","doi-asserted-by":"crossref","unstructured":"Labio W, Wiener JL, Garcia-Molina H, Gorelik V. Efficient resumption of interrupted warehouse loads. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 2000. p. 46\u201357.","DOI":"10.1145\/342009.335379"},{"key":"158_CR5459","doi-asserted-by":"crossref","unstructured":"Lenzerini M. Data integration: a theoretical perspective. In: Proceedings of the 21st ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems; 2002. p. 233\u201346.","DOI":"10.1145\/543613.543644"},{"key":"158_CR5460","first-page":"1","volume":"8","author":"X Liu","year":"2013","unstructured":"Liu X, Thomsen C, Pedersen TB. ETLMR: a highly scalable dimensional ETL framework based on mapreduce. Trans Large-Scale Data- Knowl-Cent Syst. 2013;8:1\u201331.","journal-title":"Trans Large-Scale Data- Knowl-Cent Syst."},{"key":"158_CR5461","first-page":"191","volume-title":"Lecture Notes in Computer Science","author":"Sergio Luj\u00e1n-Mora","year":"2004","unstructured":"Luj\u00e1n-Mora S, Vassiliadis P, Trujillo J. Data mapping diagrams for data warehouse design with UML. In: Proceedings of the 23rd International Conference on Conceptual Modeling; 2004. p. 191\u2013204."},{"key":"158_CR5462","unstructured":"Oracle. Oracle9i SQL Reference. Release 9.2; 2002."},{"issue":"4","key":"158_CR5463","doi-asserted-by":"publisher","first-page":"334","DOI":"10.1007\/s007780100057","volume":"10","author":"E Rahm","year":"2001","unstructured":"Rahm E, Bernstein PA. A survey of approaches to automatic schema matching. VLDB J. 2001;10(4): 334\u201350.","journal-title":"VLDB J"},{"key":"158_CR5464","doi-asserted-by":"crossref","unstructured":"Rizzi S, Abell\u00f3 A, Lechtenb\u00f6rger J, Trujillo J. Research in data warehouse modeling and design: dead or alive? In: Proceedings of the ACM 9th International Workshop on Data Warehousing and OLAP; 2006. p. 3\u201310.","DOI":"10.1145\/1183512.1183515"},{"key":"158_CR5465","doi-asserted-by":"publisher","first-page":"80","DOI":"10.1007\/978-3-642-23544-3_7","volume-title":"Data Warehousing and Knowledge Discovery","author":"Oscar Romero","year":"2011","unstructured":"Romero O, Simitsis A, Abell\u00f3 A. GEM: requirement-driven generation of ETL and multidimensional conceptual designs. In: Proceedings of the 13th International Conference on Data Warehousing and Knowledge Discovery; 2011. p. 80\u201395."},{"key":"158_CR5466","unstructured":"Roth MT, Schwarz PM. Don\u2019t scrap it, wrap it! a wrapper architecture for legacy data sources. In: Proceedings of the 23th International Conference on Very Large Data Bases; 1997. p. 266\u201375."},{"issue":"2","key":"158_CR5467","doi-asserted-by":"publisher","first-page":"134","DOI":"10.1145\/320544.320549","volume":"2","author":"NC Shu","year":"1977","unstructured":"Shu NC, Housel BC, Taylor RW, Ghosh SP, Lum VY. Express: a data extraction, processing, amd restructuring system. ACM Trans Database Syst. 1977;2(2):134\u201374.","journal-title":"ACM Trans Database Syst"},{"key":"158_CR5468","doi-asserted-by":"crossref","unstructured":"Simitsis A, Vassiliadis P, Sellis TK. Optimizing ETL processes in data warehouses. In: Proceedings of the 21st International Conference on Data Engineering; 2005. p. 564\u201375.","DOI":"10.1109\/ICDE.2005.103"},{"issue":"10","key":"158_CR5469","doi-asserted-by":"publisher","first-page":"1404","DOI":"10.1109\/TKDE.2005.169","volume":"17","author":"A Simitsis","year":"2005","unstructured":"Simitsis A, Vassiliadis P, Sellis TK. State-space optimization of ETL workflows. IEEE Trans Knowl Data Eng. 2005;17(10):1404\u201319.","journal-title":"IEEE Trans Knowl Data Eng"},{"key":"158_CR5470","doi-asserted-by":"crossref","unstructured":"Simitsis A, Wilkinson K, Castellanos M, Dayal U. Qox-driven ETL design: reducing the cost of ETL consulting engagements. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; p. 953\u201360.","DOI":"10.1145\/1559845.1559954"},{"key":"158_CR5471","doi-asserted-by":"crossref","unstructured":"Simitsis A, Wilkinson K, Castellanos M, Dayal U. Optimizing analytic data flows for multiple execution engines. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 2012. p. 829\u201340.","DOI":"10.1145\/2213836.2213963"},{"key":"158_CR5472","doi-asserted-by":"crossref","unstructured":"Skoutas D, Simitsis A. Designing ETL processes using semantic web technologies. In: Proceedings of the ACM 9th International Workshop on Data Warehousing and OLAP; 2006. p. 67\u201374.","DOI":"10.1145\/1183512.1183526"},{"key":"158_CR5473","doi-asserted-by":"crossref","unstructured":"Thomsen C, Pedersen TB. Easy and effective parallel programmable ETL. In: Proceedings of the ACM 14th International Workshop on Data Warehousing and OLAP; 2011. p. 37\u201344.","DOI":"10.1145\/2064676.2064684"},{"key":"158_CR5474","unstructured":"TPC. TPC-DS (Decision Support) specification, draft version 52; Feb 2007."},{"key":"158_CR5475","doi-asserted-by":"publisher","first-page":"307","DOI":"10.1007\/978-3-540-39648-2_25","volume-title":"Conceptual Modeling - ER 2003","author":"Juan Trujillo","year":"2003","unstructured":"Trujillo J, Luj\u00e1n-Mora S. A UML based approach for modeling ETL processes in data warehouses. In: Proceedings of the 22nd International Conference on Conceptual Modeling; 2003. p. 307\u201320."},{"key":"158_CR5476","unstructured":"Vassiliadis P, Karagiannis A, Tziovara V, Vassiliadis P, Simitsis A. Towards a benchmark for ETL workflows. In: Proceedings of the 5th International Workshop on Quality in Databases at VLDB; 2007."},{"key":"158_CR5477","doi-asserted-by":"crossref","unstructured":"Vassiliadis P, Simitsis A, Skiadopoulos S. Conceptual modeling for ETL processes. In: Proceedings of the ACM 5th International Workshop on Data Warehousing and OLAP; 2002. p. 14\u201321.","DOI":"10.1145\/583890.583893"}],"container-title":["Encyclopedia of Database Systems"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/978-1-4614-8265-9_158","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2026,10,16]],"date-time":"2026-10-16T06:09:51Z","timestamp":1792130991000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/chapter\/10.1007\/978-1-4614-8265-9_158"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2018]]},"ISBN":["9781461482666","9781461482659"],"references-count":30,"URL":"https:\/\/doi.org\/10.1007\/978-1-4614-8265-9_158","relation":{},"subject":[],"published":{"date-parts":[[2018]]},"assertion":[{"value":"7 December 2018","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}}]}}