{"id":"https://openalex.org/W1987244489","doi":"https://doi.org/10.1145/1167350.1167424","title":"A methodological framework for conceptual data warehouse design","display_name":"A methodological framework for conceptual data warehouse design","publication_year":2005,"publication_date":"2005-03-18","ids":{"openalex":"https://openalex.org/W1987244489","doi":"https://doi.org/10.1145/1167350.1167424","mag":"1987244489"},"language":"en","primary_location":{"id":"doi:10.1145/1167350.1167424","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1167350.1167424","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 43rd annual Southeast regional conference - Volume 1","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/A5011818541","display_name":"Leopoldo Zepeda","orcid":null},"institutions":[{"id":"https://openalex.org/I4210085960","display_name":"Instituto Tecnol\u00f3gico de Culiac\u00e1n","ror":"https://ror.org/0087m7494","country_code":"MX","type":"education","lineage":["https://openalex.org/I4210085960"]}],"countries":["MX"],"is_corresponding":false,"raw_author_name":"Leopoldo Zepeda","raw_affiliation_strings":["Inst. Tecnol\u00f3gico de Culiac\u00e1n, Cln. Sin., M\u00e9xico"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Inst. Tecnol\u00f3gico de Culiac\u00e1n, Cln. Sin., M\u00e9xico","institution_ids":["https://openalex.org/I4210085960"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5033876374","display_name":"Matilde Celma","orcid":null},"institutions":[{"id":"https://openalex.org/I60053951","display_name":"Universitat Polit\u00e8cnica de Val\u00e8ncia","ror":"https://ror.org/01460j859","country_code":"ES","type":"education","lineage":["https://openalex.org/I60053951"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Matilde Celma","raw_affiliation_strings":["Universidad Polit\u00e9cnica de Valenc\u00eda, Val. Espa\u00f1a"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universidad Polit\u00e9cnica de Valenc\u00eda, Val. Espa\u00f1a","institution_ids":["https://openalex.org/I60053951"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5066352568","display_name":"Ram\u00f3n Zatara\u00edn Cabada","orcid":"https://orcid.org/0000-0002-4524-3511"},"institutions":[{"id":"https://openalex.org/I4210085960","display_name":"Instituto Tecnol\u00f3gico de Culiac\u00e1n","ror":"https://ror.org/0087m7494","country_code":"MX","type":"education","lineage":["https://openalex.org/I4210085960"]}],"countries":["MX"],"is_corresponding":false,"raw_author_name":"Ram\u00f3n Zatarain","raw_affiliation_strings":["Inst. Tecnol\u00f3gico de Culiac\u00e1n, Cln. Sin., M\u00e9xico"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Inst. Tecnol\u00f3gico de Culiac\u00e1n, Cln. Sin., M\u00e9xico","institution_ids":["https://openalex.org/I4210085960"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.5477,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.7311134,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"256","last_page":"259"},"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.9988999962806702,"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.9988999962806702,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.996399998664856,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9889000058174133,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.8425759673118591},{"id":"https://openalex.org/keywords/conceptual-schema","display_name":"Conceptual schema","score":0.826511025428772},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7508823871612549},{"id":"https://openalex.org/keywords/dimensional-modeling","display_name":"Dimensional modeling","score":0.6879678964614868},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.6491721272468567},{"id":"https://openalex.org/keywords/unified-modeling-language","display_name":"Unified Modeling Language","score":0.5328952074050903},{"id":"https://openalex.org/keywords/schema-evolution","display_name":"Schema evolution","score":0.48947370052337646},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.47782468795776367},{"id":"https://openalex.org/keywords/star-schema","display_name":"Star schema","score":0.42247578501701355},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.4142891764640808},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.381877601146698},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3502297103404999},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3180982172489166},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.17400583624839783},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.1351599097251892},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.1166037917137146}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8425759673118591},{"id":"https://openalex.org/C29275276","wikidata":"https://www.wikidata.org/wiki/Q2268965","display_name":"Conceptual schema","level":3,"score":0.826511025428772},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7508823871612549},{"id":"https://openalex.org/C143008350","wikidata":"https://www.wikidata.org/wiki/Q3432172","display_name":"Dimensional modeling","level":2,"score":0.6879678964614868},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.6491721272468567},{"id":"https://openalex.org/C145644426","wikidata":"https://www.wikidata.org/wiki/Q169411","display_name":"Unified Modeling Language","level":3,"score":0.5328952074050903},{"id":"https://openalex.org/C2780660560","wikidata":"https://www.wikidata.org/wiki/Q3951893","display_name":"Schema evolution","level":4,"score":0.48947370052337646},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.47782468795776367},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.42247578501701355},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.4142891764640808},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.381877601146698},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3502297103404999},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3180982172489166},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.17400583624839783},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1351599097251892},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.1166037917137146},{"id":"https://openalex.org/C138496976","wikidata":"https://www.wikidata.org/wiki/Q175002","display_name":"Developmental psychology","level":1,"score":0.0},{"id":"https://openalex.org/C165611974","wikidata":"https://www.wikidata.org/wiki/Q5531015","display_name":"Gender schema theory","level":2,"score":0.0},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1167350.1167424","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1167350.1167424","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 43rd annual Southeast regional conference - Volume 1","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure","score":0.46000000834465027}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":4,"referenced_works":["https://openalex.org/W1508412218","https://openalex.org/W1530537858","https://openalex.org/W1578185793","https://openalex.org/W2170235279"],"related_works":["https://openalex.org/W2103472145","https://openalex.org/W2153512431","https://openalex.org/W1513459549","https://openalex.org/W166845585","https://openalex.org/W1591654213","https://openalex.org/W2031254074","https://openalex.org/W2037512230","https://openalex.org/W49842380","https://openalex.org/W2105315220","https://openalex.org/W1596416272"],"abstract_inverted_index":{"A":[0],"Data":[1],"Warehouse":[2],"(DW)":[3],"has":[4],"been":[5],"an":[6,19,45,55,86],"approach":[7],"adopted":[8],"for":[9,47,65,89],"giving":[10],"support":[11],"to":[12,103,113],"the":[13,26,34,93,105,108],"process":[14],"of":[15,76,96,107],"taking":[16],"decisions":[17],"in":[18],"organization.":[20],"This":[21],"paper":[22],"is":[23],"concerned":[24],"with":[25,59],"data":[27,68,90],"warehouse":[28,69],"conceptual":[29,35,49],"schema":[30,50,57,70],"design":[31,71],"starting":[32,63],"from":[33],"operational":[36],"schemas":[37,82,98,110],"and":[38,43,72],"user":[39,101],"requirements.":[40],"We":[41],"propose":[42],"illustrate":[44],"algorithm":[46,53],"automatic":[48,94],"development.":[51],"Our":[52],"uses":[54],"enterprise":[56],"represented":[58],"UML":[60,87],"as":[61],"a":[62,74],"point":[64],"source":[66],"driven":[67],"produces":[73],"set":[75],"multidimensional":[77,97],"candidates":[78,81,109],"schemas.":[79],"The":[80],"are":[83],"created":[84],"using":[85],"profile":[88],"warehouse.":[91],"Next":[92],"generation":[95],"we":[99],"use":[100],"requirements":[102],"guide":[104],"selection":[106],"most":[111],"likely":[112],"meet":[114],"users":[115],"needs.":[116]},"counts_by_year":[{"year":2016,"cited_by_count":1},{"year":2013,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}