{"id":"https://openalex.org/W1893018","doi":null,"title":"The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data","display_name":"The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data","publication_year":2004,"publication_date":"2004-01-01","ids":{"openalex":"https://openalex.org/W1893018","mag":"1893018"},"language":"en","primary_location":{"id":"pmh:oai:aleph.bib-bvb.de:BVB01-014853064","doi":null,"is_oa":false,"landing_page_url":"http://www.loc.gov/catdir/toc/ecip0420/2004016909.html","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"volume":null,"type":"article","indexed_in":[],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5002159193","display_name":"Ralph Kimball","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ralph Kimball","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5040298015","display_name":"Joe Caserta","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Joe Caserta","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":13.7236,"has_fulltext":false,"cited_by_count":487,"citation_normalized_percentile":{"value":0.98907789,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":97,"max":100},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.6215999722480774,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.6215999722480774,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.36329999566078186,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.004100000020116568,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/data-warehouse","display_name":"data warehouse","score":0.9269999861717224},{"id":"https://openalex.org/keywords/etl","display_name":"ETL","score":0.7279999852180481},{"id":"https://openalex.org/keywords/english-language-teaching","display_name":"English language teaching","score":0.8870000243186951},{"id":"https://openalex.org/keywords/data-extraction","display_name":"data extraction","score":0.8920000195503235},{"id":"https://openalex.org/keywords/data-cleaning","display_name":"data cleaning","score":0.9710000157356262},{"id":"https://openalex.org/keywords/data-delivery","display_name":"data delivery","score":0.722000002861023},{"id":"https://openalex.org/keywords/data-integration-architecture","display_name":"data integration architecture","score":0.6539999842643738},{"id":"https://openalex.org/keywords/performance-tuning","display_name":"performance tuning","score":0.4880000054836273}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.9108807444572449},{"id":"https://openalex.org/C24756922","wikidata":"https://www.wikidata.org/wiki/Q1757694","display_name":"Data quality","level":3,"score":0.5997312664985657},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5838228464126587},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5717899203300476},{"id":"https://openalex.org/C2779530757","wikidata":"https://www.wikidata.org/wiki/Q1207505","display_name":"Quality (philosophy)","level":2,"score":0.5214597582817078},{"id":"https://openalex.org/C90673727","wikidata":"https://www.wikidata.org/wiki/Q901718","display_name":"Product (mathematics)","level":2,"score":0.5188130736351013},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4628863036632538},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3557727336883545},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.3495134115219116},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.26083749532699585},{"id":"https://openalex.org/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.09285807609558105},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.06794345378875732},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C176217482","wikidata":"https://www.wikidata.org/wiki/Q860554","display_name":"Metric (unit)","level":2,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"pmh:oai:aleph.bib-bvb.de:BVB01-014853064","doi":null,"is_oa":false,"landing_page_url":"http://www.loc.gov/catdir/toc/ecip0420/2004016909.html","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},{"id":"pmh:oai:cds.cern.ch:1520960","doi":null,"is_oa":false,"landing_page_url":"http://cds.cern.ch/record/1520960","pdf_url":null,"source":{"id":"https://openalex.org/S4306400735","display_name":"International Linear Collider","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":null},{"id":"mag:1893018","doi":null,"is_oa":false,"landing_page_url":"https://openlibrary.org/books/OL23123443M/The_data_warehouse_ETL_toolkit","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"sustainable_development_goals_aurora":[{"score":0.5099999904632568,"display_name":"Decent work and economic growth","id":"https://metadata.un.org/sdg/8"}],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2365345637","https://openalex.org/W1750113778","https://openalex.org/W7096564446","https://openalex.org/W144747761","https://openalex.org/W3093547726","https://openalex.org/W129833210","https://openalex.org/W7046657333","https://openalex.org/W2388810311","https://openalex.org/W2387662534","https://openalex.org/W125576683"],"abstract_inverted_index":{"Discusses":[0],"how":[1],"to":[2],"use":[3],"an":[4,12],"ELT":[5,22],"system,":[6],"covering":[7],"such":[8],"topics":[9],"as":[10],"choosing":[11],"architecture,":[13],"building":[14],"a":[15],"data":[16],"cleaning":[17],"subsystem,":[18],"and":[19],"finetuning":[20],"the":[21],"process":[23],"for":[24],"optimum":[25],"performance.":[26]},"counts_by_year":[{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":11},{"year":2023,"cited_by_count":19},{"year":2022,"cited_by_count":13},{"year":2021,"cited_by_count":24},{"year":2020,"cited_by_count":23},{"year":2019,"cited_by_count":31},{"year":2018,"cited_by_count":19},{"year":2017,"cited_by_count":29},{"year":2016,"cited_by_count":33},{"year":2015,"cited_by_count":26},{"year":2014,"cited_by_count":36},{"year":2013,"cited_by_count":35},{"year":2012,"cited_by_count":37}],"updated_date":"2026-10-16T09:59:22.235173","created_date":"2016-06-24T00:00:00"}