{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,2,21]],"date-time":"2025-02-21T00:51:28Z","timestamp":1740099088921,"version":"3.37.3"},"publisher-location":"Cham","reference-count":28,"publisher":"Springer International Publishing","isbn-type":[{"type":"print","value":"9783319966540"},{"type":"electronic","value":"9783319966557"}],"license":[{"start":{"date-parts":[[2018,1,1]],"date-time":"2018-01-01T00:00:00Z","timestamp":1514764800000},"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":[[2018]]},"DOI":"10.1007\/978-3-319-96655-7_2","type":"book-chapter","created":{"date-parts":[[2018,7,14]],"date-time":"2018-07-14T01:51:06Z","timestamp":1531533066000},"page":"21-50","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":2,"title":["Programmatic ETL"],"prefix":"10.1007","author":[{"given":"Christian","family":"Thomsen","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Ove","family":"Andersen","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"S\u00f8ren Kejser","family":"Jensen","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Torben Bach","family":"Pedersen","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2018,7,15]]},"reference":[{"key":"2_CR1","unstructured":"Beyer, M.A., Thoo, E., Selvage, M.Y., Zaidi, E.: Gartner Magic Quadrant for Data Integration Tools (2017)"},{"key":"2_CR2","doi-asserted-by":"publisher","unstructured":"Dean, J., Ghemawat, S.: MapReduce: simplified data processing on large clusters. In: Proceedings of the OSDI, pp. 137\u2013150 (2004). \nhttps:\/\/doi.org\/10.1145\/1327452.1327492","DOI":"10.1145\/1327452.1327492"},{"key":"2_CR3","unstructured":"Django. \ndjangoproject.com\/\n\n. Accessed 13 Oct 2017"},{"key":"2_CR4","unstructured":"Gr\u00f6nniger, H., Krahn, H., Rumpe, B., Schindler, M., V\u00f6lkel, S.: Text-based modeling. In: Proceedings of ATEM (2007)"},{"key":"2_CR5","unstructured":"IBM InfoSphere DataStage. \nhttps:\/\/www.ibm.com\/ms-en\/marketplace\/datastage\n\n. Accessed 13 Oct 2017"},{"key":"2_CR6","unstructured":"Informatica. \ninformatica.com\n\n. Accessed 13 Oct 2017"},{"key":"2_CR7","doi-asserted-by":"publisher","DOI":"10.2200\/S00299ED1V01Y201009DTM009","volume-title":"Multidimensional Databases and Data Warehousing","author":"CS Jensen","year":"2010","unstructured":"Jensen, C.S., Pedersen, T.B., Thomsen, C.: Multidimensional Databases and Data Warehousing. Morgan and Claypool, San Rafael (2010). \nhttps:\/\/doi.org\/10.2200\/S00299ED1V01Y201009DTM009"},{"key":"2_CR8","volume-title":"The Data Warehouse Toolkit","author":"R Kimball","year":"2002","unstructured":"Kimball, R., Ross, M.: The Data Warehouse Toolkit, 2nd edn. Wiley, New York (2002)","edition":"2"},{"key":"2_CR9","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"96","DOI":"10.1007\/978-3-642-23544-3_8","volume-title":"Data Warehousing and Knowledge Discovery","author":"X Liu","year":"2011","unstructured":"Liu, X., Thomsen, C., Pedersen, T.B.: ETLMR: a highly scalable dimensional ETL framework based on MapReduce. In: Cuzzocrea, A., Dayal, U. (eds.) DaWaK 2011. LNCS, vol. 6862, pp. 96\u2013111. Springer, Heidelberg (2011). \nhttps:\/\/doi.org\/10.1007\/978-3-642-23544-3_8"},{"key":"2_CR10","unstructured":"Microsoft SQL Server Integration Services. \nhttps:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/sql-server-integration-services\n\n. Accessed 13 Oct 2017"},{"key":"2_CR11","unstructured":"Oracle Data Integrator. \nhttp:\/\/www.oracle.com\/technetwork\/middleware\/data-integrator\/overview\/index.html\n\n. Accessed 13 Oct 2017"},{"key":"2_CR12","unstructured":"Pentaho Data Integration - Kettle. \nhttp:\/\/kettle.pentaho.org\n\n. Accessed 13 Oct 2017"},{"issue":"6","key":"2_CR13","doi-asserted-by":"publisher","first-page":"33","DOI":"10.1145\/203241.203251","volume":"38","author":"M Petre","year":"1995","unstructured":"Petre, M.: Why looking isn\u2019t always seeing: readership skills and graphical programming. Commun. ACM 38(6), 33\u201344 (1995). \nhttps:\/\/doi.org\/10.1145\/203241.203251","journal-title":"Commun. ACM"},{"key":"2_CR14","unstructured":"PostgreSQL. postgresql.org. Accessed 13 Oct 2017"},{"key":"2_CR15","unstructured":"Psycopg. \nhttp:\/\/initd.org\/psycopg\/\n\n. Accessed 13 Oct 2017"},{"key":"2_CR16","unstructured":"Python. python.org. Accessed 13 Oct 2017"},{"key":"2_CR17","unstructured":"Ruby on Rails. rubyonrails.org\/. Accessed 13 Oct 2017"},{"key":"2_CR18","unstructured":"SAP Data Services. \nhttps:\/\/www.sap.com\/products\/data-services.html\n\n. Accessed 13 Oct 2017"},{"key":"2_CR19","unstructured":"Scriptella. scriptella.org. Accessed 13 Oct 2017"},{"key":"2_CR20","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"43","DOI":"10.1007\/11546849_5","volume-title":"Data Warehousing and Knowledge Discovery","author":"A Simitsis","year":"2005","unstructured":"Simitsis, A., Vassiliadis, P., Terrovitis, M., Skiadopoulos, S.: Graph-based modeling of ETL activities with multi-level transformations and updates. In: Tjoa, A.M., Trujillo, J. (eds.) DaWaK 2005. LNCS, vol. 3589, pp. 43\u201352. Springer, Heidelberg (2005). \nhttps:\/\/doi.org\/10.1007\/11546849_5"},{"key":"2_CR21","doi-asserted-by":"publisher","unstructured":"Thomsen, C., Pedersen, T.B.: Building a web warehouse for accessibility data. In: Proceedings of DOLAP (2006). \nhttps:\/\/doi.org\/10.1145\/1183512.1183522","DOI":"10.1145\/1183512.1183522"},{"issue":"3","key":"2_CR22","doi-asserted-by":"publisher","first-page":"56","DOI":"10.4018\/jdwm.2009070103","volume":"5","author":"C Thomsen","year":"2009","unstructured":"Thomsen, C., Pedersen, T.B.: A survey of open source tools for business intelligence. IJDWM 5(3), 56\u201375 (2009). \nhttps:\/\/doi.org\/10.4018\/jdwm.2009070103","journal-title":"IJDWM"},{"key":"2_CR23","doi-asserted-by":"publisher","unstructured":"Thomsen, C., Pedersen, T.B.: pygrametl: a powerful programming framework for extract-transform-load programmers. In: Proceedings of DOLAP, pp. 49\u201356 (2009). \nhttps:\/\/doi.org\/10.1145\/2064676.2064684","DOI":"10.1145\/2064676.2064684"},{"key":"2_CR24","unstructured":"Thomsen, C., Pedersen, T.B.: pygrametl: a powerful programming framework for extract-transform-load programmers. DBTR-25, Aalborg University (2009). \nwww.cs.aau.dk\/DBTR"},{"key":"2_CR25","doi-asserted-by":"crossref","unstructured":"Thomsen, C., Pedersen, T.B.: Easy and effective parallel programmable ETL. In: Proceedings of DOLAP, pp. 37\u201344 (2011)","DOI":"10.1145\/2064676.2064684"},{"key":"2_CR26","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"307","DOI":"10.1007\/978-3-540-39648-2_25","volume-title":"Conceptual Modeling - ER 2003","author":"J Trujillo","year":"2003","unstructured":"Trujillo, J., Luj\u00e1n-Mora, S.: A UML based approach for modeling ETL processes in data warehouses. In: Song, I.-Y., Liddle, S.W., Ling, T.-W., Scheuermann, P. (eds.) ER 2003. LNCS, vol. 2813, pp. 307\u2013320. Springer, Heidelberg (2003). \nhttps:\/\/doi.org\/10.1007\/978-3-540-39648-2_25"},{"key":"2_CR27","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-54655-6","volume-title":"Data Warehouse Systems: Design and Implementation","author":"A Vaisman","year":"2014","unstructured":"Vaisman, A., Zimanyi, E.: Data Warehouse Systems: Design and Implementation. Springer, Heidelberg (2014). \nhttps:\/\/doi.org\/10.1007\/978-3-642-54655-6"},{"issue":"3","key":"2_CR28","doi-asserted-by":"publisher","first-page":"1","DOI":"10.4018\/jdwm.2009070101","volume":"5","author":"P Vassiliadis","year":"2009","unstructured":"Vassiliadis, P.: A survey of extract-transform-load technology. IJDWM 5(3), 1\u201327 (2009). \nhttps:\/\/doi.org\/10.4018\/jdwm.2009070101","journal-title":"IJDWM"}],"container-title":["Lecture Notes in Business Information Processing","Business Intelligence and Big Data"],"original-title":[],"link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-319-96655-7_2","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2018,7,14]],"date-time":"2018-07-14T01:51:49Z","timestamp":1531533109000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/978-3-319-96655-7_2"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2018]]},"ISBN":["9783319966540","9783319966557"],"references-count":28,"URL":"https:\/\/doi.org\/10.1007\/978-3-319-96655-7_2","relation":{},"ISSN":["1865-1348","1865-1356"],"issn-type":[{"type":"print","value":"1865-1348"},{"type":"electronic","value":"1865-1356"}],"subject":[],"published":{"date-parts":[[2018]]}}}