{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,6,19]],"date-time":"2025-06-19T04:57:29Z","timestamp":1750309049532,"version":"3.41.0"},"publisher-location":"New York, New York, USA","reference-count":29,"publisher":"ACM Press","license":[{"start":{"date-parts":[[2018,1,1]],"date-time":"2018-01-01T00:00:00Z","timestamp":1514764800000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2018]]},"DOI":"10.1145\/3216122.3216149","type":"proceedings-article","created":{"date-parts":[[2018,7,10]],"date-time":"2018-07-10T16:26:42Z","timestamp":1531240002000},"page":"236-245","source":"Crossref","is-referenced-by-count":6,"title":["An Approach for Testing the Extract-Transform-Load Process in Data Warehouse Systems"],"prefix":"10.1145","author":[{"given":"Hajar","family":"Homayouni","sequence":"first","affiliation":[{"name":"Department of Computer Science, Colorado State University"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Sudipto","family":"Ghosh","sequence":"additional","affiliation":[{"name":"Department of Computer Science, Colorado State University"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Indrakshi","family":"Ray","sequence":"additional","affiliation":[{"name":"Department of Computer Science, Colorado State University"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","reference":[{"key":"key-10.1145\/3216122.3216149-1","unstructured":"Alfred V. Aho and Jeffrey D. Ullman. 1994. Foundations of Computer Science (3rd ed.). W. H. Freeman."},{"key":"key-10.1145\/3216122.3216149-2","unstructured":"James F. Allen. 2003. Natural Language Processing. In Encyclopedia of Computer Science. John Wiley and Sons Ltd., Chichester, UK, 1218--1222."},{"key":"key-10.1145\/3216122.3216149-3","unstructured":"AnyDBTest 2011. Retrieved 2018-01-15 from https:\/\/anydbtest.codeplex.com\/"},{"key":"key-10.1145\/3216122.3216149-4","doi-asserted-by":"crossref","unstructured":"Earl T. Barr, Mark Harman, Phil McMinn, Muzammil Shahbaz, and Shin Yoo. 2015. The Oracle Problem in Software Testing: A Survey. IEEE Trans. on Software Engr. 41, 5 (2015), 507--525.","DOI":"10.1109\/TSE.2014.2372785"},{"key":"key-10.1145\/3216122.3216149-5","unstructured":"Big Data Testing, ETL Testing & Data Warehouse Testing | QuerySurge 2014. Retrieved 2018-01-01 from http:\/\/www.querysurge.com\/"},{"key":"key-10.1145\/3216122.3216149-6","unstructured":"Caboodle Data Model 2014. Retrieved 2018-02-03 from http:\/\/www.med.upenn.edu\/dac\/epic-clarity-data-warehousing.html"},{"key":"key-10.1145\/3216122.3216149-7","unstructured":"Sara Dakrory, Tarek Mahmoud, and Abdelmgeid Ali. 2015. Automated ETL Testing on the Data Quality of a Data Warehouse. Intl. Journal of Computer Applications 131, 16 (2015), 0975--8887."},{"key":"key-10.1145\/3216122.3216149-8","unstructured":"Databene Benerator 2016. Retrieved 2018-01-20 from http:\/\/databene.org\/databene-benerator"},{"key":"key-10.1145\/3216122.3216149-9","unstructured":"DbFit 2013. Retrieved 2018-01-17 from http:\/\/dbfit.github.io\/dbfit\/index.html"},{"key":"key-10.1145\/3216122.3216149-10","doi-asserted-by":"crossref","unstructured":"Stefan Dessloch, Mauricio A. Hernandez, Ryan Wisnesky, Ahmed Radwan, and Jindan Zhou. 2008. Orchid: Integrating Schema Mapping and ETL. In IEEE 24th Intl. Conf. on Data Engineering. 1307--1316.","DOI":"10.1109\/ICDE.2008.4497540"},{"key":"key-10.1145\/3216122.3216149-11","doi-asserted-by":"crossref","unstructured":"Neveen ElGamal, Ali El Bastawissy, and Galal Galal-Edeen. 2012. Towards a Data Warehouse Testing Framework. In 9th Intl. Conf. on ICT and Knowledge Engineering. 65--71.","DOI":"10.1109\/ICTKE.2012.6152416"},{"key":"key-10.1145\/3216122.3216149-12","doi-asserted-by":"crossref","unstructured":"Neveen ElGamal, Ali ElBastawissy, and Galal Galal-Edeen. 2013. Data Warehouse Testing. In the Joint EDBT\/ICDT Workshops. New York, USA, 1--8.","DOI":"10.1145\/2457317.2457319"},{"key":"key-10.1145\/3216122.3216149-13","doi-asserted-by":"crossref","unstructured":"Ronald Fagin, Phokion G. Kolaitis, Renée J. Miller, and Lucian Popa. 2005. Data exchange: semantics and query answering. Theoretical Compututer Science 336, 1 (2005), 89--124.","DOI":"10.1016\/j.tcs.2004.10.033"},{"key":"key-10.1145\/3216122.3216149-14","doi-asserted-by":"crossref","unstructured":"Ronald Fagin, Phokion G. Kolaitis, and Lucian Popa. 2005. Data exchange: getting to the core. ACM Trans. Database Systems 30, 1 (2005), 174--210.","DOI":"10.1145\/1061318.1061323"},{"key":"key-10.1145\/3216122.3216149-15","unstructured":"Pedro Nuno San-Banto Furtado. 2009. Evolving Application Domains of Data Warehousing and Mining: Trends and Solutions (1st ed.). Information Science Reference - Imprint of: IGI Publishing, Hershey, PA."},{"key":"key-10.1145\/3216122.3216149-16","unstructured":"Jerry Gao, Chunli Xie, and Chuanqi Tao. 2016. Big Data Validation and Quality Assurance -- Issues, Challenges, and Needs. In IEEE Symposium on Service-Oriented System Engineering. 433--441."},{"key":"key-10.1145\/3216122.3216149-17","doi-asserted-by":"crossref","unstructured":"Matteo Golfarelli and Stefano Rizzi. 2009. A Comprehensive Approach to Data Warehouse Testing. In 12th ACM Intl. Workshop on Data Warehousing and OLAP. New York, USA, 17--24.","DOI":"10.1145\/1651291.1651295"},{"key":"key-10.1145\/3216122.3216149-18","doi-asserted-by":"crossref","unstructured":"Matteo Golfarelli and Stefano Rizzi. 2011. Data Warehouse Testing: A Prototype-based Methodology. Information and Software Technology 53, 11 (2011), 1183--1198.","DOI":"10.1016\/j.infsof.2011.04.002"},{"key":"key-10.1145\/3216122.3216149-19","unstructured":"Google BigQuery Enterprise Data Warehouse 2010. Retrieved 2018-01-20 from https:\/\/cloud.google.com\/bigquery\/"},{"key":"key-10.1145\/3216122.3216149-20","doi-asserted-by":"crossref","unstructured":"Jing Han, E Haihong, Guan Le, and Jian Du. 2011. Survey on NoSQL Database. In 6th Intl. Conf. on Pervasive Computing and Applications. 363--366.","DOI":"10.1109\/ICPCA.2011.6106531"},{"key":"key-10.1145\/3216122.3216149-21","unstructured":"Informatica Powercenter Data Validation 1993. Retrieved 2018-02-05 from https:\/\/www.informatica.com\/products\/data-quality"},{"key":"key-10.1145\/3216122.3216149-22","doi-asserted-by":"crossref","unstructured":"Gregory M. Kapfhammer, Phil McMinn, and Chris J. Wright. 2013. Search-Based Testing of Relational Schema Integrity Constraints Across Multiple Database Management Systems. In IEEE 6th Intl. Conf. on Software Testing, Verification and Validation. 31--40.","DOI":"10.1109\/ICST.2013.47"},{"key":"key-10.1145\/3216122.3216149-23","unstructured":"Ralph Kimball and Joe Caserta. 2004. The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data (1st ed.). Wiley."},{"key":"key-10.1145\/3216122.3216149-24","unstructured":"Manoj Philip Mathen. 2010. Data warehouse testing. Infosys DeveloperIQ Magazine (2010), 1--8."},{"key":"key-10.1145\/3216122.3216149-25","unstructured":"Observational Medical Outcomes Partnership Common Data Model (OMOP CDM) 2018. Retrieved 2018-02-01 from https:\/\/www.ohdsi.org\/data-standardization\/the-common-data-model"},{"key":"key-10.1145\/3216122.3216149-26","doi-asserted-by":"crossref","unstructured":"Dimitrios Skoutas, Alkis Simitsis, and Timos Sellis. 2009. Ontology-Driven Conceptual Design of ETL Processes Using Graph Transformations. Springer, Berlin, Heidelberg, 120--146.","DOI":"10.1007\/978-3-642-03098-7_5"},{"key":"key-10.1145\/3216122.3216149-27","unstructured":"SqlRender2014. Retrieved2018-02-02 fromhttps:\/\/github.com\/OHDSI\/SqlRender"},{"key":"key-10.1145\/3216122.3216149-28","unstructured":"SqlRender With BigQuery Supports 2016. Retrieved 2018-02-01 from https:\/\/github.com\/hajarhomayouni\/SqlRender"},{"key":"key-10.1145\/3216122.3216149-29","unstructured":"Doug Vucevic and Wayne Yaddow. 2012. Testing the Data Warehouse Practicum: Assuring Data Content, Data Structures and Quality. Trafford Publishing."}],"event":{"number":"22","sponsor":["Concordia University"],"acronym":"IDEAS 2018","name":"the 22nd International Database Engineering & Applications Symposium","start":{"date-parts":[[2018,6,18]]},"location":"Villa San Giovanni, Italy","end":{"date-parts":[[2018,6,20]]}},"container-title":["Proceedings of the 22nd International Database Engineering & Applications Symposium on - IDEAS 2018"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3216122.3216149","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/dl.acm.org\/ft_gateway.cfm?id=3216149&ftid=1986377&dwn=1","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T22:29:34Z","timestamp":1750285774000},"score":1,"resource":{"primary":{"URL":"http:\/\/dl.acm.org\/citation.cfm?doid=3216122.3216149"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2018]]},"references-count":29,"URL":"https:\/\/doi.org\/10.1145\/3216122.3216149","relation":{},"subject":[],"published":{"date-parts":[[2018]]}}}