{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,10,17]],"date-time":"2026-10-17T19:30:48Z","timestamp":1792265448321,"version":"4.4.0"},"reference-count":20,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2013,8,28]]},"abstract":"<jats:p>Both scientific data and business data have analytical needs. Analysis takes place after a scientific data warehouse is eagerly filled with all data from external data sources (repositories). This is similar to the initial loading stage of Extract, Transform, and Load (ETL) processes that drive business intelligence. ETL can also help scientific data analysis. However, the initial loading is a time and resource consuming operation. It might not be entirely necessary, e.g. if the user is interested in only a subset of the data.<\/jats:p>\n          <jats:p>We propose to demonstrate Lazy ETL, a technique to lower costs for initial loading. With it, ETL is integrated into the query processing of the scientific data warehouse. For a query, only the required data items are extracted, transformed, and loaded transparently on-the-fly.<\/jats:p>\n          <jats:p>The demo is built around concrete implementations of Lazy ETL for seismic data analysis. The seismic data warehouse is ready for query processing, without waiting for long initial loading. The audience fires analytical queries to observe the internal mechanisms and modifications that realize each of the steps; lazy extraction, transformation, and loading.<\/jats:p>","DOI":"10.14778\/2536274.2536297","type":"journal-article","created":{"date-parts":[[2014,6,24]],"date-time":"2014-06-24T12:17:57Z","timestamp":1403612277000},"page":"1286-1289","source":"Crossref","is-referenced-by-count":8,"title":["Lazy ETL in action"],"prefix":"10.14778","volume":"6","author":[{"given":"Ya\u011f\u00edz","family":"Karg\u00edn","sequence":"first","affiliation":[{"name":"CWI Amsterdam"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Milena","family":"Ivanova","sequence":"additional","affiliation":[{"name":"Netherlands eScience Center"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Ying","family":"Zhang","sequence":"additional","affiliation":[{"name":"CWI Amsterdam"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Stefan","family":"Manegold","sequence":"additional","affiliation":[{"name":"CWI Amsterdam"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Martin","family":"Kersten","sequence":"additional","affiliation":[{"name":"CWI Amsterdam"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"320","published-online":{"date-parts":[[2013,8]]},"reference":[{"key":"e_1_2_1_1_1","unstructured":"Standard for the Exchange of Earthquake Data. Incorporated Research Institutions for Seismology February 1988. Standard for the Exchange of Earthquake Data . Incorporated Research Institutions for Seismology February 1988."},{"key":"e_1_2_1_2_1","unstructured":"MonetDB Column-store Pioneers. www.monetdb.org 2013.  MonetDB Column-store Pioneers. www.monetdb.org 2013."},{"key":"e_1_2_1_3_1","volume-title":"SIGMOD","author":"Alagiannis I.","year":"2012"},{"issue":"1","key":"e_1_2_1_4_1","doi-asserted-by":"crossref","first-page":"65","DOI":"10.1145\/248603.248616","article-title":"An overview of data warehousing and OLAP technology","volume":"26","author":"Chaudhuri S.","year":"1997","journal-title":"ACM Sigmod record"},{"key":"e_1_2_1_5_1","first-page":"1","volume-title":"EDBT","author":"Dayal U.","year":"2009"},{"key":"e_1_2_1_6_1","doi-asserted-by":"crossref","unstructured":"J. Gray etal Scientific Data Management in the Coming Decade. SIGMOD Record 34(4) 2005.   J. Gray et al. Scientific Data Management in the Coming Decade. SIGMOD Record 34(4) 2005.","DOI":"10.1145\/1107499.1107503"},{"key":"e_1_2_1_7_1","volume-title":"CIDR","author":"Idreos S.","year":"2011"},{"key":"e_1_2_1_8_1","first-page":"309","volume-title":"SIGMOD Conference","author":"Ivanova M.","year":"2009"},{"key":"e_1_2_1_9_1","volume-title":"Springer Verlag","author":"Jarke M.","year":"2003"},{"key":"e_1_2_1_10_1","first-page":"101","volume-title":"IDEAS","author":"J\u00f6rg T.","year":"2008"},{"key":"e_1_2_1_11_1","doi-asserted-by":"crossref","first-page":"100","DOI":"10.1007\/978-3-642-14559-9_7","volume-title":"Enabling Real-Time Business Intelligence","author":"J\u00f6rg T.","year":"2010"},{"key":"e_1_2_1_12_1","volume-title":"BIRTE","author":"Kargin Y.","year":"2012"},{"key":"e_1_2_1_13_1","doi-asserted-by":"crossref","unstructured":"J. Kiviniemi A. Wolski A. Pesonen and J. Arminen. Lazy aggregates for real-time OLAP. Lecture notes in computer science pages 165-172 1999.   J. Kiviniemi A. Wolski A. Pesonen and J. Arminen. Lazy aggregates for real-time OLAP. Lecture notes in computer science pages 165-172 1999.","DOI":"10.1007\/3-540-48298-9_18"},{"key":"e_1_2_1_14_1","first-page":"383","volume-title":"Proceedings of SIGMOD","author":"Labio W.","year":"1998"},{"key":"e_1_2_1_15_1","unstructured":"ORFEUS. Seismology Event Data (1988 - now). ftp:\/\/www.orfeus-eu.org\/pub\/data\/pond\/ 2013.  ORFEUS. Seismology Event Data (1988 - now). ftp:\/\/www.orfeus-eu.org\/pub\/data\/pond\/ 2013."},{"key":"e_1_2_1_16_1","unstructured":"SQL\/MED. ISO\/IEC 9075-9:2008 Information technology - Database languages - SQL - Part 9: Management of External Data (SQL\/MED).  SQL\/MED. ISO\/IEC 9075-9:2008 Information technology - Database languages - SQL - Part 9: Management of External Data (SQL\/MED)."},{"key":"e_1_2_1_17_1","volume-title":"CIDR","author":"Stonebraker M.","year":"2009"},{"key":"e_1_2_1_18_1","volume-title":"International Journal of Data Warehousing and Mining (IJDWM), 5(3):1-27","author":"Vassiliadis P.","year":"2009"},{"key":"e_1_2_1_19_1","doi-asserted-by":"crossref","first-page":"1095","DOI":"10.1007\/978-0-387-39940-9_158","volume-title":"Encyclopedia of Database Systems","author":"Vassiliadis P.","year":"2009"},{"key":"e_1_2_1_20_1","first-page":"124","volume-title":"IDEAS'11","author":"Zhang Y."}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/2536274.2536297","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T10:50:08Z","timestamp":1672224608000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/2536274.2536297"}},"subtitle":["ETL technology dates scientific data"],"short-title":[],"issued":{"date-parts":[[2013,8]]},"references-count":20,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2013,8,28]]}},"alternative-id":["10.14778\/2536274.2536297"],"URL":"https:\/\/doi.org\/10.14778\/2536274.2536297","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2013,8]]}}}