{"id":"https://openalex.org/W2170235279","doi":"https://doi.org/10.1109/hicss.1998.649228","title":"Conceptual design of data warehouses from E/R schemes","display_name":"Conceptual design of data warehouses from E/R schemes","publication_year":2002,"publication_date":"2002-11-27","ids":{"openalex":"https://openalex.org/W2170235279","doi":"https://doi.org/10.1109/hicss.1998.649228","mag":"2170235279"},"language":"en","primary_location":{"id":"doi:10.1109/hicss.1998.649228","doi":"https://doi.org/10.1109/hicss.1998.649228","is_oa":false,"landing_page_url":"https://doi.org/10.1109/hicss.1998.649228","pdf_url":null,"source":{"id":"https://openalex.org/S4210195248","display_name":"Hawaii International Conference on System Sciences (HICSS)","issn_l":"1530-1605","issn":["1530-1605","2572-6862"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["jufo-1","norway-1"],"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":"Proceedings of the Thirty-First Hawaii International Conference on System Sciences","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/A5029448963","display_name":"Matteo Golfarelli","orcid":"https://orcid.org/0000-0002-0437-0725","observed_orcids":["https://orcid.org/0000-0002-0437-0725"]},"institutions":[{"id":"https://openalex.org/I9360294","display_name":"University of Bologna","ror":"https://ror.org/01111rn36","country_code":"IT","type":"education","lineage":["https://openalex.org/I9360294"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"M. Golfarelli","raw_affiliation_strings":["DEIS, University of Bologna, Italy"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"DEIS, University of Bologna, Italy","institution_ids":["https://openalex.org/I9360294"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5056262479","display_name":"Dario Maio","orcid":"https://orcid.org/0000-0002-0094-0022","observed_orcids":["https://orcid.org/0000-0002-0094-0022"]},"institutions":[{"id":"https://openalex.org/I9360294","display_name":"University of Bologna","ror":"https://ror.org/01111rn36","country_code":"IT","type":"education","lineage":["https://openalex.org/I9360294"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"D. Maio","raw_affiliation_strings":["DEIS, CSITE, University of Bologna, Italy"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"DEIS, CSITE, University of Bologna, Italy","institution_ids":["https://openalex.org/I9360294"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5009924329","display_name":"Stefano Rizzi","orcid":"https://orcid.org/0000-0002-4617-217X","observed_orcids":["https://orcid.org/0000-0002-4617-217X"]},"institutions":[{"id":"https://openalex.org/I9360294","display_name":"University of Bologna","ror":"https://ror.org/01111rn36","country_code":"IT","type":"education","lineage":["https://openalex.org/I9360294"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"S. Rizzi","raw_affiliation_strings":["DEIS, University of Bologna, Italy"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"DEIS, University of Bologna, Italy","institution_ids":["https://openalex.org/I9360294"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I9360294"],"apc_list":null,"apc_paid":null,"fwci":33.9904,"has_fulltext":false,"cited_by_count":282,"citation_normalized_percentile":{"value":0.99965132,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":88,"max":100},"biblio":{"volume":"7","issue":null,"first_page":"334","last_page":"343"},"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.9520999789237976,"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.9520999789237976,"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.04580000042915344,"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":9.999999747378752e-05,"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/data-warehouse-design","display_name":"data warehouse design","score":0.9070000052452087},{"id":"https://openalex.org/keywords/conceptual-data-modeling","display_name":"conceptual data modeling","score":0.5879999995231628},{"id":"https://openalex.org/keywords/entity-relationship-model","display_name":"entity-relationship model","score":0.6660000085830688},{"id":"https://openalex.org/keywords/semi-automated-design","display_name":"semi-automated design","score":0.6209999918937683},{"id":"https://openalex.org/keywords/query-workload","display_name":"query workload","score":0.6290000081062317},{"id":"https://openalex.org/keywords/heterogeneous-database-integration","display_name":"heterogeneous database integration","score":0.48500001430511475}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.7187286019325256},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7038527131080627},{"id":"https://openalex.org/C120208923","wikidata":"https://www.wikidata.org/wiki/Q5158435","display_name":"Conceptual design","level":2,"score":0.4137466251850128},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3163589537143707},{"id":"https://openalex.org/C107457646","wikidata":"https://www.wikidata.org/wiki/Q207434","display_name":"Human\u2013computer interaction","level":1,"score":0.21152305603027344}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1109/hicss.1998.649228","doi":"https://doi.org/10.1109/hicss.1998.649228","is_oa":false,"landing_page_url":"https://doi.org/10.1109/hicss.1998.649228","pdf_url":null,"source":{"id":"https://openalex.org/S4210195248","display_name":"Hawaii International Conference on System Sciences (HICSS)","issn_l":"1530-1605","issn":["1530-1605","2572-6862"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["jufo-1","norway-1"],"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":"Proceedings of the Thirty-First Hawaii International Conference on System Sciences","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.48.5342","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.48.5342","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"ftp://ftp-db.deis.unibo.it/pub/stefano/hicss98.ps.gz","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.63.1599","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.63.1599","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www-db.deis.unibo.it/~srizzi/PDF/hicss98.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":17,"referenced_works":["https://openalex.org/W188023883","https://openalex.org/W1488870204","https://openalex.org/W1528281972","https://openalex.org/W1538786304","https://openalex.org/W1935156299","https://openalex.org/W1995999642","https://openalex.org/W2010499454","https://openalex.org/W2035703056","https://openalex.org/W2072764742","https://openalex.org/W2108908993","https://openalex.org/W2126093747","https://openalex.org/W2140646908","https://openalex.org/W2147399501","https://openalex.org/W2152389926","https://openalex.org/W2160677885","https://openalex.org/W4289258943","https://openalex.org/W6607600649"],"related_works":["https://openalex.org/W2008120802","https://openalex.org/W2052884373","https://openalex.org/W3040125083","https://openalex.org/W1546914789","https://openalex.org/W4301517402","https://openalex.org/W7100356186","https://openalex.org/W7036575656","https://openalex.org/W2157815332","https://openalex.org/W355151252","https://openalex.org/W2995394817"],"abstract_inverted_index":{"Data":[0],"warehousing":[1],"systems":[2],"enable":[3],"enterprise":[4],"managers":[5],"to":[6,15,56,120,142],"acquire":[7],"and":[8,14,28,51,82,106,122,157],"integrate":[9],"information":[10,36,131],"from":[11,33,59],"heterogeneous":[12],"sources":[13],"query":[16,140],"very":[17],"large":[18],"databases":[19],"efficiently.":[20],"Building":[21],"a":[22,40,53,65,149],"data":[23,45,162],"warehouse":[24],"requires":[25],"adopting":[26],"design":[27,150],"implementation":[29],"techniques":[30],"completely":[31],"different":[32],"those":[34],"underlying":[35],"systems.":[37],"We":[38],"present":[39],"graphical":[41],"conceptual":[42,68],"model":[43,69],"for":[44],"warehouses,":[46],"called":[47],"Dimensional":[48],"Fact":[49,125],"model,":[50],"propose":[52],"semi-automated":[54],"methodology":[55],"build":[57],"it":[58],"the":[60,94,101,107,133,146,155,161],"pre-existing":[61],"entity/relationship":[62],"schemes":[63,74,92,114,126,159],"describing":[64],"database.":[66],"Our":[67],"consists":[70],"of":[71,96,103,109,132,139,148,160],"tree-structured":[72],"fact":[73,91,97,113],"whose":[75,152],"basic":[76],"elements":[77],"are":[78,93,154],"facts,":[79],"attributes,":[80],"dimensions":[81],"hierarchies;":[83],"other":[84],"features":[85],"which":[86],"may":[87,115,127],"be":[88,116,128,143],"represented":[89],"on":[90],"additivity":[95],"attributes":[98,105],"along":[99],"dimensions,":[100],"optionality":[102],"dimension":[104],"existence":[108],"non-dimension":[110],"attributes.":[111],"Compatible":[112],"overlapped":[117],"in":[118,137],"order":[119],"relate":[121],"compare":[123],"data.":[124],"integrated":[129],"with":[130],"conjectured":[134],"workload,":[135],"expressed":[136],"terms":[138],"patterns,":[141],"used":[144],"as":[145],"input":[147],"phase":[151],"output":[153],"logical":[156],"physical":[158],"warehouse.":[163]},"counts_by_year":[{"year":2025,"cited_by_count":3},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":12},{"year":2017,"cited_by_count":4},{"year":2016,"cited_by_count":6},{"year":2015,"cited_by_count":13},{"year":2014,"cited_by_count":15},{"year":2013,"cited_by_count":11},{"year":2012,"cited_by_count":9}],"updated_date":"2026-11-03T10:50:19.383937","created_date":"2016-06-24T00:00:00"}