{"id":"https://openalex.org/W2158643472","doi":"https://doi.org/10.1145/1559845.1559954","title":"QoX-driven ETL design","display_name":"QoX-driven ETL design","publication_year":2009,"publication_date":"2009-06-29","ids":{"openalex":"https://openalex.org/W2158643472","doi":"https://doi.org/10.1145/1559845.1559954","mag":"2158643472"},"language":"en","primary_location":{"id":"doi:10.1145/1559845.1559954","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1559845.1559954","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2009 ACM SIGMOD International Conference on Management of data","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"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/A5072082268","display_name":"Alkis Simitsis","orcid":"https://orcid.org/0009-0006-6078-5323"},"institutions":[{"id":"https://openalex.org/I1324840837","display_name":"Hewlett-Packard (United States)","ror":"https://ror.org/059rn9488","country_code":"US","type":"company","lineage":["https://openalex.org/I1324840837"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Alkis Simitsis","raw_affiliation_strings":["HP Labs, Palo Alto, CA, USA"],"affiliations":[{"raw_affiliation_string":"HP Labs, Palo Alto, CA, USA","institution_ids":["https://openalex.org/I1324840837"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5086875579","display_name":"Kevin Wilkinson","orcid":null},"institutions":[{"id":"https://openalex.org/I1324840837","display_name":"Hewlett-Packard (United States)","ror":"https://ror.org/059rn9488","country_code":"US","type":"company","lineage":["https://openalex.org/I1324840837"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Kevin Wilkinson","raw_affiliation_strings":["HP Labs, Palo Alto, CA, USA"],"affiliations":[{"raw_affiliation_string":"HP Labs, Palo Alto, CA, USA","institution_ids":["https://openalex.org/I1324840837"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5110218927","display_name":"Mal\u00fa Castellanos","orcid":null},"institutions":[{"id":"https://openalex.org/I1324840837","display_name":"Hewlett-Packard (United States)","ror":"https://ror.org/059rn9488","country_code":"US","type":"company","lineage":["https://openalex.org/I1324840837"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Malu Castellanos","raw_affiliation_strings":["HP Labs, Palo Alto, CA, USA"],"affiliations":[{"raw_affiliation_string":"HP Labs, Palo Alto, CA, USA","institution_ids":["https://openalex.org/I1324840837"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5045738980","display_name":"Umeshwar Dayal","orcid":null},"institutions":[{"id":"https://openalex.org/I1324840837","display_name":"Hewlett-Packard (United States)","ror":"https://ror.org/059rn9488","country_code":"US","type":"company","lineage":["https://openalex.org/I1324840837"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Umeshwar Dayal","raw_affiliation_strings":["HP Labs, Palo Alto, CA, USA"],"affiliations":[{"raw_affiliation_string":"HP Labs, Palo Alto, CA, USA","institution_ids":["https://openalex.org/I1324840837"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5072082268"],"corresponding_institution_ids":["https://openalex.org/I1324840837"],"apc_list":null,"apc_paid":null,"fwci":7.5427,"has_fulltext":false,"cited_by_count":69,"citation_normalized_percentile":{"value":0.97557207,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"953","last_page":"960"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994000196456909,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994000196456909,"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"}},{"id":"https://openalex.org/T10703","display_name":"Business Process Modeling and Analysis","score":0.9937000274658203,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9919999837875366,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/computer-science","display_name":"Computer science","score":0.7751201391220093},{"id":"https://openalex.org/keywords/quality","display_name":"Quality (philosophy)","score":0.5741497278213501},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.5333321690559387},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.5198205709457397},{"id":"https://openalex.org/keywords/suite","display_name":"Suite","score":0.4948083758354187},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.4583032429218292},{"id":"https://openalex.org/keywords/reliability","display_name":"Reliability (semiconductor)","score":0.4434537887573242},{"id":"https://openalex.org/keywords/automation","display_name":"Automation","score":0.41678228974342346},{"id":"https://openalex.org/keywords/task","display_name":"Task (project management)","score":0.41299962997436523},{"id":"https://openalex.org/keywords/systems-engineering","display_name":"Systems engineering","score":0.329529732465744},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3117500841617584},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.1420629322528839},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.115990549325943}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7751201391220093},{"id":"https://openalex.org/C2779530757","wikidata":"https://www.wikidata.org/wiki/Q1207505","display_name":"Quality (philosophy)","level":2,"score":0.5741497278213501},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.5333321690559387},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.5198205709457397},{"id":"https://openalex.org/C79581498","wikidata":"https://www.wikidata.org/wiki/Q1367530","display_name":"Suite","level":2,"score":0.4948083758354187},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.4583032429218292},{"id":"https://openalex.org/C43214815","wikidata":"https://www.wikidata.org/wiki/Q7310987","display_name":"Reliability (semiconductor)","level":3,"score":0.4434537887573242},{"id":"https://openalex.org/C115901376","wikidata":"https://www.wikidata.org/wiki/Q184199","display_name":"Automation","level":2,"score":0.41678228974342346},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.41299962997436523},{"id":"https://openalex.org/C201995342","wikidata":"https://www.wikidata.org/wiki/Q682496","display_name":"Systems engineering","level":1,"score":0.329529732465744},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3117500841617584},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.1420629322528839},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.115990549325943},{"id":"https://openalex.org/C163258240","wikidata":"https://www.wikidata.org/wiki/Q25342","display_name":"Power (physics)","level":2,"score":0.0},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0},{"id":"https://openalex.org/C78519656","wikidata":"https://www.wikidata.org/wiki/Q101333","display_name":"Mechanical engineering","level":1,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"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/C166957645","wikidata":"https://www.wikidata.org/wiki/Q23498","display_name":"Archaeology","level":1,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C95457728","wikidata":"https://www.wikidata.org/wiki/Q309","display_name":"History","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1559845.1559954","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1559845.1559954","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2009 ACM SIGMOD International Conference on Management of data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Decent work and economic growth","score":0.4699999988079071,"id":"https://metadata.un.org/sdg/8"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":23,"referenced_works":["https://openalex.org/W129057286","https://openalex.org/W197630086","https://openalex.org/W1510220247","https://openalex.org/W1558140929","https://openalex.org/W1969937393","https://openalex.org/W2020829916","https://openalex.org/W2058978608","https://openalex.org/W2071058905","https://openalex.org/W2098416578","https://openalex.org/W2105539612","https://openalex.org/W2107760270","https://openalex.org/W2108971776","https://openalex.org/W2119584748","https://openalex.org/W2120828587","https://openalex.org/W2149877754","https://openalex.org/W2153019089","https://openalex.org/W2163857507","https://openalex.org/W2645036108","https://openalex.org/W2951321531","https://openalex.org/W4242182825","https://openalex.org/W4285719527","https://openalex.org/W6608082300","https://openalex.org/W6676313902"],"related_works":["https://openalex.org/W4231704780","https://openalex.org/W1511772879","https://openalex.org/W352609212","https://openalex.org/W2083794993","https://openalex.org/W4200340037","https://openalex.org/W4379115841","https://openalex.org/W608917066","https://openalex.org/W4283652261","https://openalex.org/W585424826","https://openalex.org/W564602992"],"abstract_inverted_index":{"As":[0],"business":[1],"intelligence":[2],"becomes":[3],"increasingly":[4],"essential":[5],"for":[6,96],"organizations":[7],"and":[8,34,44,76,194,199],"as":[9],"it":[10],"evolves":[11],"from":[12],"strategic":[13],"to":[14,47,62,87,134,152,171],"operational,":[15],"the":[16,37,51,58,124,144,149,154,187,192],"complexity":[17],"of":[18,53,69,156,178,186],"Extract-Transform-Load":[19],"(ETL)":[20],"processes":[21],"grows.":[22],"In":[23,56],"consequence,":[24],"ETL":[25,54,89,145,172],"engagements":[26,129,158],"have":[27],"become":[28],"very":[29],"time":[30],"consuming,":[31],"labor":[32],"intensive,":[33],"costly.":[35],"At":[36],"same":[38],"time,":[39],"additional":[40],"requirements":[41],"besides":[42],"functionality":[43],"performance":[45],"need":[46],"be":[48,63],"considered":[49],"in":[50,91,116,143],"design":[52,59,90,146,173,188],"processes.":[55],"particular,":[57],"quality":[60,99,125,179],"needs":[61],"determined":[64],"by":[65],"an":[66],"intricate":[67],"combination":[68],"different":[70],"metrics":[71,198],"like":[72],"reliability,":[73],"maintenance,":[74],"scalability,":[75],"others.":[77],"Unfortunately,":[78],"there":[79],"are":[80],"no":[81],"methodologies,":[82],"modeling":[83],"languages":[84],"or":[85,127],"tools":[86],"support":[88],"a":[92,168,176],"systematic,":[93],"formal":[94],"way":[95,151],"achieving":[97],"these":[98,157],"requirements.":[100],"The":[101],"current":[102],"practice":[103],"handles":[104],"them":[105],"with":[106],"ad-hoc":[107],"approaches":[108],"only":[109,150],"based":[110],"on":[111,203],"designers'":[112],"experience.":[113],"This":[114],"results":[115],"either":[117],"poor":[118],"designs":[119],"that":[120,130,140,174],"do":[121],"not":[122],"meet":[123,135],"objectives":[126],"costly":[128],"require":[131],"several":[132],"iterations":[133],"them.":[136],"A":[137],"fundamental":[138],"shift":[139],"uses":[141],"automation":[142],"task":[147],"is":[148],"reduce":[153],"cost":[155],"while":[159],"obtaining":[160],"optimal":[161],"designs.":[162,205],"Towards":[163],"this":[164],"goal,":[165],"we":[166],"present":[167],"novel":[169],"approach":[170],"incorporates":[175],"suite":[177],"metrics,":[180],"termed":[181],"QoX,":[182],"at":[183],"all":[184],"stages":[185],"process.":[189],"We":[190],"discuss":[191],"challenges":[193],"tradeoffs":[195],"among":[196],"QoX":[197],"illustrate":[200],"their":[201],"impact":[202],"alternative":[204]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":7},{"year":2016,"cited_by_count":7},{"year":2015,"cited_by_count":5},{"year":2014,"cited_by_count":10},{"year":2013,"cited_by_count":8},{"year":2012,"cited_by_count":6}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}