{"id":"https://openalex.org/W2575976797","doi":"https://doi.org/10.1109/icsrs.2016.7815845","title":"Comparative study of data warehouses modeling approaches: Inmon, Kimball and Data Vault","display_name":"Comparative study of data warehouses modeling approaches: Inmon, Kimball and Data Vault","publication_year":2016,"publication_date":"2016-11-01","ids":{"openalex":"https://openalex.org/W2575976797","doi":"https://doi.org/10.1109/icsrs.2016.7815845","mag":"2575976797"},"language":"en","primary_location":{"id":"doi:10.1109/icsrs.2016.7815845","doi":"https://doi.org/10.1109/icsrs.2016.7815845","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icsrs.2016.7815845","pdf_url":null,"source":{"id":"https://openalex.org/S7407086073","display_name":"International Conference on System Reliability and Safety (ICSRS)","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":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2016 International Conference on System Reliability and Science (ICSRS)","raw_type":"proceedings-article"},"volume":null,"type":"conference-paper","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/A5018203166","display_name":"Lamia Yessad","orcid":"https://orcid.org/0000-0001-5457-6425","observed_orcids":["https://orcid.org/0000-0001-5457-6425"]},"institutions":[{"id":"https://openalex.org/I4210149016","display_name":"\u00c9cole Nationale Sup\u00e9rieure d'Informatique","ror":"https://ror.org/04dj1dn66","country_code":"DZ","type":"education","lineage":["https://openalex.org/I4210149016"]}],"countries":["DZ"],"is_corresponding":false,"raw_author_name":"Lamia Yessad","raw_affiliation_strings":["LCSI laboratory, ESI, Algiers, Algeria"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"LCSI laboratory, ESI, Algiers, Algeria","institution_ids":["https://openalex.org/I4210149016"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5069498585","display_name":"Aissa Labiod","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4210149016","display_name":"\u00c9cole Nationale Sup\u00e9rieure d'Informatique","ror":"https://ror.org/04dj1dn66","country_code":"DZ","type":"education","lineage":["https://openalex.org/I4210149016"]}],"countries":["DZ"],"is_corresponding":false,"raw_author_name":"Aissa Labiod","raw_affiliation_strings":["LCSI laboratory, ESI, Algiers, Algeria"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"LCSI laboratory, ESI, Algiers, Algeria","institution_ids":["https://openalex.org/I4210149016"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I4210149016"],"apc_list":null,"apc_paid":null,"fwci":2.8718,"has_fulltext":false,"cited_by_count":34,"citation_normalized_percentile":{"value":0.90711645,"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":"95","last_page":"99"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":1.0,"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":1.0,"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.0,"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/T14222","display_name":"Knowledge Management and Technology","score":0.0,"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/data-warehouse-design","display_name":"data warehouse design","score":0.9750000238418579},{"id":"https://openalex.org/keywords/data-vault","display_name":"data vault","score":0.8259999752044678},{"id":"https://openalex.org/keywords/business-intelligence","display_name":"business intelligence","score":0.906000018119812},{"id":"https://openalex.org/keywords/data-integration","display_name":"data integration","score":0.460999995470047},{"id":"https://openalex.org/keywords/heterogeneous-data-sources","display_name":"heterogeneous data sources","score":0.8659999966621399}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.9003918170928955},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7147095203399658},{"id":"https://openalex.org/C132964779","wikidata":"https://www.wikidata.org/wiki/Q2110223","display_name":"Raw data","level":2,"score":0.6389760971069336},{"id":"https://openalex.org/C2767350","wikidata":"https://www.wikidata.org/wiki/Q6662173","display_name":"Business intelligence","level":2,"score":0.5904734134674072},{"id":"https://openalex.org/C2780344732","wikidata":"https://www.wikidata.org/wiki/Q189771","display_name":"Vault (architecture)","level":2,"score":0.5678998827934265},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.5615513324737549},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.551459550857544},{"id":"https://openalex.org/C143008350","wikidata":"https://www.wikidata.org/wiki/Q3432172","display_name":"Dimensional modeling","level":2,"score":0.5329312682151794},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.48709535598754883},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.4864794909954071},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.4275129437446594},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.38170042634010315},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.15616947412490845},{"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/C66938386","wikidata":"https://www.wikidata.org/wiki/Q633538","display_name":"Structural engineering","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icsrs.2016.7815845","doi":"https://doi.org/10.1109/icsrs.2016.7815845","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icsrs.2016.7815845","pdf_url":null,"source":{"id":"https://openalex.org/S7407086073","display_name":"International Conference on System Reliability and Safety (ICSRS)","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":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2016 International Conference on System Reliability and Science (ICSRS)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":4,"referenced_works":["https://openalex.org/W96686019","https://openalex.org/W2108971776","https://openalex.org/W2350573227","https://openalex.org/W2460071091"],"related_works":["https://openalex.org/W7215254819","https://openalex.org/W7099197145","https://openalex.org/W7048953660","https://openalex.org/W7113378579","https://openalex.org/W123455013","https://openalex.org/W7166693266","https://openalex.org/W1612832955","https://openalex.org/W4385413835","https://openalex.org/W7096109559","https://openalex.org/W7025015288"],"abstract_inverted_index":{"BI":[0,20,57],"(Business":[1],"Intelligence)":[2],"is":[3,21,26,71,96],"an":[4],"important":[5],"discipline":[6],"for":[7,125],"companies":[8],"and":[9,46,113],"the":[10,22,41,44,50,56,103,127],"challenges":[11],"it":[12],"faces":[13],"are":[14,49],"strategic.":[15],"A":[16],"central":[17],"concept":[18],"in":[19,37],"data":[23,31,42,82,87],"warehouse,":[24,43],"which":[25],"a":[27,60,81,99,117],"set":[28],"of":[29,67,84,93,102],"consolidated":[30],"from":[32,74,88],"heterogeneous":[33,89],"sources":[34],"(usually":[35],"databases":[36],"3NF).":[38],"To":[39],"model":[40],"Inmon":[45],"Kimball":[47],"approaches":[48],"most":[51],"used.":[52],"Both":[53],"solutions":[54],"monopolize":[55],"market":[58],"However,":[59],"third":[61],"modeling":[62],"approach":[63,111,129],"called":[64],"\u201cData":[65],"Vault\u201d":[66],"its":[68],"creator":[69],"Linstedt,":[70],"gaining":[72],"ground":[73],"year":[75],"to":[76,97],"year.":[77],"It":[78],"allows":[79],"building":[80],"warehouse":[83],"raw":[85],"(unprocessed)":[86],"sources.":[90],"The":[91],"purpose":[92],"this":[94,132],"paper":[95],"present":[98],"comparative":[100],"study":[101,109],"three":[104],"precedent":[105],"approaches.":[106],"First,":[107],"we":[108,115,122],"each":[110],"separately":[112],"then":[114],"draw":[116],"comparison":[118],"between":[119],"them.":[120],"Finally,":[121],"include":[123],"recommendations":[124],"selecting":[126],"best":[128],"before":[130],"concluding":[131],"paper.":[133]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":5},{"year":2023,"cited_by_count":8},{"year":2022,"cited_by_count":5},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":4},{"year":2019,"cited_by_count":4},{"year":2018,"cited_by_count":1}],"updated_date":"2026-10-28T10:33:24.094632","created_date":"2017-01-26T00:00:00"}