{"id":"https://openalex.org/W2153753087","doi":"https://doi.org/10.1109/tsmcc.2006.886966","title":"Toward Developing Data Warehousing Process Standards: An Ontology-Based Review of Existing Methodologies","display_name":"Toward Developing Data Warehousing Process Standards: An Ontology-Based Review of Existing Methodologies","publication_year":2006,"publication_date":"2006-12-19","ids":{"openalex":"https://openalex.org/W2153753087","doi":"https://doi.org/10.1109/tsmcc.2006.886966","mag":"2153753087"},"language":"en","primary_location":{"id":"doi:10.1109/tsmcc.2006.886966","doi":"https://doi.org/10.1109/tsmcc.2006.886966","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tsmcc.2006.886966","pdf_url":null,"source":{"id":"https://openalex.org/S4210227557","display_name":"IEEE Transactions on Systems Man and Cybernetics Part C (Applications and Reviews)","issn_l":"1094-6977","issn":["1094-6977","1558-2442"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["anvur-scientific","cwts-core"],"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Systems, Man and Cybernetics, Part C (Applications and Reviews)","raw_type":"journal-article"},"volume":null,"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/A5111781564","display_name":"Arun Sen","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I91045830","display_name":"Texas A&M University","ror":"https://ror.org/01f5ytq51","country_code":"US","type":"education","lineage":["https://openalex.org/I91045830"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Arun Sen","raw_affiliation_strings":["Department of Information and Operations Management, Mays Business School, Texas A and M University, College Station, TX, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Information and Operations Management, Mays Business School, Texas A and M University, College Station, TX, USA","institution_ids":["https://openalex.org/I91045830"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5110260079","display_name":"Atish P. Sinha","orcid":"https://orcid.org/0000-0001-8125-7403","observed_orcids":["https://orcid.org/0000-0001-8125-7403"]},"institutions":[{"id":"https://openalex.org/I43579087","display_name":"University of Wisconsin\u2013Milwaukee","ror":"https://ror.org/031q21x57","country_code":"US","type":"education","lineage":["https://openalex.org/I43579087"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Atish P. Sinha","raw_affiliation_strings":["Sheldon B. Lubar School of Business, University of Wisconsin, Milwaukee, Milwaukee, WI, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Sheldon B. Lubar School of Business, University of Wisconsin, Milwaukee, Milwaukee, WI, USA","institution_ids":["https://openalex.org/I43579087"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.9971,"has_fulltext":false,"cited_by_count":17,"citation_normalized_percentile":{"value":0.88857082,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":"37","issue":"1","first_page":"17","last_page":"31"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9951000213623047,"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"}},"topics":[{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9951000213623047,"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.0013000000035390258,"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"}},{"id":"https://openalex.org/T14222","display_name":"Knowledge Management and Technology","score":0.0008999999845400453,"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/process-standardization","display_name":"process standardization","score":0.6980000138282776},{"id":"https://openalex.org/keywords/ontology-information-science","display_name":"ontology (information science)","score":0.4339999854564667},{"id":"https://openalex.org/keywords/ontology-model","display_name":"ontological model","score":0.7210000157356262},{"id":"https://openalex.org/keywords/data-modeling","display_name":"data modeling","score":0.8650000095367432},{"id":"https://openalex.org/keywords/data-extraction","display_name":"data extraction","score":0.5040000081062317},{"id":"https://openalex.org/keywords/requirements-analysis","display_name":"requirements analysis","score":0.7229999899864197},{"id":"https://openalex.org/keywords/architectural-design","display_name":"architectural design","score":0.8569999933242798}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.7574905157089233},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7099825143814087},{"id":"https://openalex.org/C188087704","wikidata":"https://www.wikidata.org/wiki/Q369577","display_name":"Standardization","level":2,"score":0.6995868682861328},{"id":"https://openalex.org/C25810664","wikidata":"https://www.wikidata.org/wiki/Q44325","display_name":"Ontology","level":2,"score":0.5582554936408997},{"id":"https://openalex.org/C31170391","wikidata":"https://www.wikidata.org/wiki/Q188619","display_name":"Hierarchy","level":2,"score":0.5545687079429626},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.49903416633605957},{"id":"https://openalex.org/C87345402","wikidata":"https://www.wikidata.org/wiki/Q485202","display_name":"Analytic hierarchy process","level":2,"score":0.45883435010910034},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.45016297698020935},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.44767698645591736},{"id":"https://openalex.org/C2777466982","wikidata":"https://www.wikidata.org/wiki/Q5227287","display_name":"Data extraction","level":3,"score":0.4174739420413971},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.35761553049087524},{"id":"https://openalex.org/C195094911","wikidata":"https://www.wikidata.org/wiki/Q14167904","display_name":"Process management","level":1,"score":0.3239218592643738},{"id":"https://openalex.org/C42475967","wikidata":"https://www.wikidata.org/wiki/Q194292","display_name":"Operations research","level":1,"score":0.14785978198051453},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.13843289017677307},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C34447519","wikidata":"https://www.wikidata.org/wiki/Q179522","display_name":"Market economy","level":1,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C2779473830","wikidata":"https://www.wikidata.org/wiki/Q1540899","display_name":"MEDLINE","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/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/tsmcc.2006.886966","doi":"https://doi.org/10.1109/tsmcc.2006.886966","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tsmcc.2006.886966","pdf_url":null,"source":{"id":"https://openalex.org/S4210227557","display_name":"IEEE Transactions on Systems Man and Cybernetics Part C (Applications and Reviews)","issn_l":"1094-6977","issn":["1094-6977","1558-2442"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["anvur-scientific","cwts-core"],"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Systems, Man and Cybernetics, Part C (Applications and Reviews)","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"sustainable_development_goals_aurora":[{"display_name":"Industry, innovation and infrastructure","score":0.6000000238418579,"id":"https://metadata.un.org/sdg/9"}],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":37,"referenced_works":["https://openalex.org/W60791092","https://openalex.org/W64819943","https://openalex.org/W84515857","https://openalex.org/W125528362","https://openalex.org/W159726073","https://openalex.org/W175128425","https://openalex.org/W332208005","https://openalex.org/W574355879","https://openalex.org/W1488716069","https://openalex.org/W1494598016","https://openalex.org/W1508412218","https://openalex.org/W1510220247","https://openalex.org/W1516346799","https://openalex.org/W1540445047","https://openalex.org/W1593181307","https://openalex.org/W1791587663","https://openalex.org/W1980243955","https://openalex.org/W1991183254","https://openalex.org/W1997383729","https://openalex.org/W2012170877","https://openalex.org/W2021184893","https://openalex.org/W2042037135","https://openalex.org/W2054846263","https://openalex.org/W2086321906","https://openalex.org/W2090154982","https://openalex.org/W2093823648","https://openalex.org/W2103103282","https://openalex.org/W2109730248","https://openalex.org/W2112440119","https://openalex.org/W2115121100","https://openalex.org/W2116139015","https://openalex.org/W2122646429","https://openalex.org/W2123065213","https://openalex.org/W2258614675","https://openalex.org/W2261180036","https://openalex.org/W3143985493","https://openalex.org/W6629496183"],"related_works":["https://openalex.org/W2592229159","https://openalex.org/W7042892142","https://openalex.org/W1681447125","https://openalex.org/W7042898700","https://openalex.org/W2106713970","https://openalex.org/W2504328485","https://openalex.org/W125528362","https://openalex.org/W2013823950","https://openalex.org/W1801103547","https://openalex.org/W3175685515"],"abstract_inverted_index":{"A":[0],"data":[1,7,23,63,73,114,199,202],"warehouse":[2],"is":[3,30,49],"developed":[4],"using":[5],"a":[6,15,102,124,148,175],"warehousing":[8,24,64,74,115],"process":[9],"(DWP)":[10],"methodology.":[11],"Currently,":[12],"there":[13],"are":[14],"large":[16],"number":[17],"of":[18,33,45,98,105,121,131,178],"methodologies":[19,75,172],"available":[20,158],"in":[21,112],"the":[22,31,43,56,62,78,90,106,113,129,153,161,171,186],"market.":[25],"The":[26,117],"reason":[27],"for":[28,159,190,211],"this":[29,67],"lack":[32],"any":[34],"centralized":[35],"attempts":[36],"at":[37],"creating":[38],"platform-independent":[39],"DWP":[40,99,132,192,215],"standards.":[41,179],"For":[42],"development":[44],"such":[46,134],"standards,":[47],"it":[48],"very":[50],"important":[51,209],"that":[52,173],"we":[53,69,92],"first":[54,93],"examine":[55],"current":[57],"practices":[58,80,189],"being":[59],"followed":[60],"by":[61],"industry.":[65],"In":[66],"study,":[68],"review":[70,104],"30":[71],"commercial":[72],"and":[76,108,140,143,147,204],"analyze":[77],"standard":[79,188],"they":[81],"have":[82],"adopted":[83],"with":[84],"respect":[85],"to":[86,169],"DWP.":[87],"To":[88],"perform":[89],"analysis,":[91,196],"develop":[94],"an":[95],"ontological":[96,118],"model":[97,119],"based":[100],"on":[101,214],"thorough":[103],"literature":[107],"inputs":[109],"from":[110],"experts":[111],"field.":[116],"consists":[120],"two":[122],"hierarchies:":[123],"composition":[125],"hierarchy":[126,150],"which":[127,151],"shows":[128],"decomposition":[130],"tasks":[133],"as":[135],"system":[136],"development,":[137,194],"extract,":[138],"transform,":[139],"load":[141],"(ETL),":[142],"end-user":[144,205],"application":[145,206],"design;":[146],"classification":[149],"specifies":[152],"alternative":[154],"methods":[155],"or":[156],"techniques":[157],"performing":[160],"tasks.":[162],"We":[163],"next":[164],"apply":[165],"hierarchical":[166],"cluster":[167],"analysis":[168],"group":[170],"share":[174],"common":[176],"set":[177],"Our":[180],"study":[181],"provides":[182],"valuable":[183],"insights":[184],"into":[185],"prevailing":[187],"different":[191],"tasks-system":[193],"requirements":[195],"architecture":[197],"design,":[198],"modeling,":[200],"ETL,":[201],"extraction,":[203],"design-and":[207],"identifies":[208],"directions":[210],"future":[212],"research":[213],"standardization":[216]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":2}],"updated_date":"2026-10-16T09:59:22.235173","created_date":"2016-06-24T00:00:00"}