{"id":"https://openalex.org/W2578066507","doi":"https://doi.org/10.3233/978-1-61499-720-7-215","title":"Automating Transformations in Data Vault Data Warehouse Loads","display_name":"Automating Transformations in Data Vault Data Warehouse Loads","publication_year":2017,"publication_date":"2017-01-01","ids":{"openalex":"https://openalex.org/W2578066507","doi":"https://doi.org/10.3233/978-1-61499-720-7-215","mag":"2578066507"},"language":"en","primary_location":{"id":"doi:10.3233/978-1-61499-720-7-215","is_oa":false,"landing_page_url":"https://doi.org/10.3233/978-1-61499-720-7-215","pdf_url":null,"source":{"id":"https://openalex.org/S4210201731","display_name":"Frontiers in artificial intelligence and applications","issn_l":"0922-6389","issn":["0922-6389","1879-8314"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Frontiers in Artificial Intelligence and Applications","raw_type":"book-chapter"},"type":"book-chapter","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/A5064119407","display_name":"Mikko Puonti","orcid":"https://orcid.org/0000-0001-6579-0224"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Puonti Mikko","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5010756452","display_name":"Timo Raitalaakso","orcid":"https://orcid.org/0000-0002-7094-7203"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Raitalaakso Timo","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5116338162","display_name":"Timo Aho","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Aho Timo","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5080647312","display_name":"Mikkonen Tommi","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Mikkonen Tommi","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":2.2875,"has_fulltext":false,"cited_by_count":9,"citation_normalized_percentile":{"value":0.87923598,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9995999932289124,"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.9995999932289124,"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9962000250816345,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T11719","display_name":"Data Quality and Management","score":0.9958999752998352,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/vault","display_name":"Vault (architecture)","score":0.7447154521942139},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.736717939376831},{"id":"https://openalex.org/keywords/warehouse","display_name":"Warehouse","score":0.5758540630340576},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.5612702369689941},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.5180628299713135},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.442187637090683},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.2968936860561371},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.15742430090904236},{"id":"https://openalex.org/keywords/geography","display_name":"Geography","score":0.140855610370636},{"id":"https://openalex.org/keywords/structural-engineering","display_name":"Structural engineering","score":0.13556072115898132}],"concepts":[{"id":"https://openalex.org/C2780344732","wikidata":"https://www.wikidata.org/wiki/Q189771","display_name":"Vault (architecture)","level":2,"score":0.7447154521942139},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.736717939376831},{"id":"https://openalex.org/C50416739","wikidata":"https://www.wikidata.org/wiki/Q181623","display_name":"Warehouse","level":2,"score":0.5758540630340576},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.5612702369689941},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.5180628299713135},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.442187637090683},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.2968936860561371},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.15742430090904236},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.140855610370636},{"id":"https://openalex.org/C66938386","wikidata":"https://www.wikidata.org/wiki/Q633538","display_name":"Structural engineering","level":1,"score":0.13556072115898132},{"id":"https://openalex.org/C166957645","wikidata":"https://www.wikidata.org/wiki/Q23498","display_name":"Archaeology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.3233/978-1-61499-720-7-215","is_oa":false,"landing_page_url":"https://doi.org/10.3233/978-1-61499-720-7-215","pdf_url":null,"source":{"id":"https://openalex.org/S4210201731","display_name":"Frontiers in artificial intelligence and applications","issn_l":"0922-6389","issn":["0922-6389","1879-8314"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Frontiers in Artificial Intelligence and Applications","raw_type":"book-chapter"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":4,"referenced_works":["https://openalex.org/W87057539","https://openalex.org/W756609968","https://openalex.org/W1993582687","https://openalex.org/W2782538446"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W1873335674","https://openalex.org/W3040871996","https://openalex.org/W2283571154","https://openalex.org/W3038909169","https://openalex.org/W2557319790","https://openalex.org/W2949115720","https://openalex.org/W2087081988","https://openalex.org/W2737362503","https://openalex.org/W2389559488"],"abstract_inverted_index":{"Data":[0,64],"warehousing":[1],"is":[2,22,61],"a":[3],"process":[4],"of":[5,29,43,53,126,164,179,185],"integrating":[6],"multiple":[7],"data":[8,24,30,36,71,78,98,127],"sources":[9],"into":[10],"one":[11],"for,":[12],"e.g.,":[13],"reporting":[14],"purposes.":[15],"An":[16],"emerging":[17],"modeling":[18,66],"technique":[19],"for":[20,115],"this":[21,157],"the":[23,40,51,59,92,124,137,143,146,151,162,169,183,195],"vault":[25,31,65,79],"method.":[26],"The":[27],"use":[28,125],"creates":[32,67],"many":[33],"structurally":[34],"similar":[35,188],"processing":[37],"modifications":[38],"in":[39,142,194],"transform":[41],"phase":[42],"ETL":[44],"work.":[45],"Is":[46],"it":[47],"possible":[48],"to":[49,70,86,111,121],"automate":[50],"creation":[52,163],"transformations?":[54],"Based":[55,90],"on":[56,91,173,176],"our":[57,174,186],"study,":[58],"answer":[60],"mostly":[62],"affirmative.":[63],"certain":[68],"constraints":[69,76],"warehouse":[72],"entities.":[73],"These":[74,106],"model":[75,96],"and":[77,97,135,167],"table":[80],"populating":[81,104],"principles":[82],"can":[83,102,107,130,149],"be":[84,109,131],"used":[85,110],"generate":[87,150],"transformation":[88,153],"code.":[89],"original":[93],"relational":[94],"database":[95],"flow":[99,128],"metadata":[100,129],"we":[101,119,148,159],"gather":[103],"principles.":[105],"then":[108],"create":[112],"general":[113],"templates":[114],"each":[116],"entity.":[117],"Nevertheless,":[118],"need":[120],"note":[122],"that":[123],"only":[132,138],"partially":[133],"automated":[134],"includes":[136],"manual":[139],"work":[140],"phases":[141],"process.":[144],"In":[145,156],"end":[147],"actual":[152],"code":[154],"automatically.":[155],"paper,":[158],"carefully":[160],"describe":[161],"automation":[165],"procedure":[166],"analyze":[168],"practical":[170],"problems":[171],"based":[172],"experiences":[175],"PL/SQL":[177],"proof":[178],"concept":[180],"implementation.":[181],"To":[182],"best":[184],"knowledge,":[187],"has":[189],"not":[190],"yet":[191],"been":[192],"described":[193],"scientific":[196],"literature.":[197]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2023,"cited_by_count":2},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":1},{"year":2016,"cited_by_count":1}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}