{"id":"https://openalex.org/W2016144631","doi":"https://doi.org/10.4018/jdwm.2012100102","title":"Integrating Star and Snowflake Schemas in Data Warehouses","display_name":"Integrating Star and Snowflake Schemas in Data Warehouses","alternate_titles":[],"publication_year":2012,"publication_date":"2012-10-01","ids":{"openalex":"https://openalex.org/W2016144631","doi":"https://doi.org/10.4018/jdwm.2012100102","mag":"2016144631"},"language":"en","primary_location":{"id":"doi:10.4018/jdwm.2012100102","doi":"https://doi.org/10.4018/jdwm.2012100102","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jdwm.2012100102","pdf_url":null,"source":{"id":"https://openalex.org/S53932126","display_name":"International Journal of Data Warehousing and Mining","issn_l":"1548-3924","issn":["1548-3924","1548-3932"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["abdc-c","anvur-scientific","cwts-core","dongbi-c","jufo-1","norway-1","poland-40","russia-white-list-3"],"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Data Warehousing and Mining","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W2016144631"],"child_works_count":0,"type":"article","is_traditional":true,"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/A5063528471","display_name":"Georgia Garani","orcid":"https://orcid.org/0000-0003-1892-4183","observed_orcids":["https://orcid.org/0000-0003-1892-4183"]},"institutions":[{"id":"https://openalex.org/I51955386","display_name":"Technological Educational Institute of Thessaly","ror":"https://ror.org/04056ja87","country_code":"GR","type":"education","lineage":["https://openalex.org/I51955386"]}],"countries":["GR"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Georgia Garani","raw_affiliation_strings":["Department of Computer Science and Telecommunications, Technological Educational Institute of Larisa, Greece"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Telecommunications, Technological Educational Institute of Larisa, Greece","institution_ids":["https://openalex.org/I51955386"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5080721885","display_name":"Sven Helmer","orcid":"https://orcid.org/0000-0002-9666-1932","observed_orcids":["https://orcid.org/0000-0002-9666-1932"]},"institutions":[{"id":"https://openalex.org/I171543936","display_name":"Free University of Bozen-Bolzano","ror":"https://ror.org/012ajp527","country_code":"IT","type":"education","lineage":["https://openalex.org/I171543936"]}],"countries":["IT"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Sven Helmer","raw_affiliation_strings":["Faculty of Computer Science, Free University of Bozen-Bolzano, Bolzano, Italy"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty of Computer Science, Free University of Bozen-Bolzano, Bolzano, Italy","institution_ids":["https://openalex.org/I171543936"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":{"value":4000,"currency":"USD","value_usd":4000},"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":25,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":87,"max":97},"biblio":{"volume":"8","issue":"4","first_page":"22","last_page":"40"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.5044000148773193,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.5044000148773193,"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/T11891","display_name":"Big Data and Business Intelligence","score":0.49239999055862427,"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.0003000000142492354,"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-schema-design","display_name":"data warehouse schema design","score":0.7710000276565552},{"id":"https://openalex.org/keywords/star-schema","display_name":"star schema","score":0.8700000047683716},{"id":"https://openalex.org/keywords/snowflake-schema","display_name":"snowflake schema","score":1.0},{"id":"https://openalex.org/keywords/dimensional-modeling","display_name":"dimensional modeling","score":0.5479999780654907},{"id":"https://openalex.org/keywords/data-semantics","display_name":"data semantics","score":0.6079999804496765},{"id":"https://openalex.org/keywords/schema-translation","display_name":"schema translation","score":0.7080000042915344},{"id":"https://openalex.org/keywords/query-execution-efficiency","display_name":"query execution efficiency","score":0.7369999885559082}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8551767468452454},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.785224199295044},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.6236439347267151},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.6019779443740845},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.5949220061302185},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.4424779415130615},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4296555817127228},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.40960246324539185},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.4019915461540222},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3992842733860016},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3268672823905945},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.22755920886993408},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.4018/jdwm.2012100102","doi":"https://doi.org/10.4018/jdwm.2012100102","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jdwm.2012100102","pdf_url":null,"source":{"id":"https://openalex.org/S53932126","display_name":"International Journal of Data Warehousing and Mining","issn_l":"1548-3924","issn":["1548-3924","1548-3932"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["abdc-c","anvur-scientific","cwts-core","dongbi-c","jufo-1","norway-1","poland-40","russia-white-list-3"],"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Data Warehousing and Mining","raw_type":"journal-article"},{"id":"pmh:oai:RePEc:igg:jdwm00:v:8:y:2012:i:4:p:22-40","doi":null,"is_oa":false,"landing_page_url":"https://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/jdwm.2012100102","pdf_url":null,"source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"},{"id":"pmh:oai:eprints.bbk.ac.uk.oai2:6995","doi":null,"is_oa":false,"landing_page_url":"https://eprints.bbk.ac.uk/id/eprint/6995/","pdf_url":null,"source":{"id":"https://openalex.org/S4306400465","display_name":"BIROn (Birkbeck, University of London)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I98259816","host_organization_name":"Birkbeck, University of London","host_organization_lineage":["https://openalex.org/I98259816"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Article"},{"id":"pmh:oai:unibz.it:11293112580001241","doi":null,"is_oa":false,"landing_page_url":"https://www.igi-global.com/gateway/article/74754","pdf_url":null,"source":{"id":"https://openalex.org/S7407050986","display_name":"Libera Universit\u00e0 di Bolzano","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":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":26,"referenced_works":["https://openalex.org/W56165858","https://openalex.org/W57116089","https://openalex.org/W107790475","https://openalex.org/W147424557","https://openalex.org/W1495859460","https://openalex.org/W1499144780","https://openalex.org/W1544008239","https://openalex.org/W1581554944","https://openalex.org/W1766020475","https://openalex.org/W1835980735","https://openalex.org/W1952220400","https://openalex.org/W1979636842","https://openalex.org/W1982958427","https://openalex.org/W2013571244","https://openalex.org/W2020958835","https://openalex.org/W2035492401","https://openalex.org/W2044215335","https://openalex.org/W2044399674","https://openalex.org/W2056119708","https://openalex.org/W2058488906","https://openalex.org/W2074999403","https://openalex.org/W2139534868","https://openalex.org/W2140069596","https://openalex.org/W2338245571","https://openalex.org/W4206234897","https://openalex.org/W4230428085"],"related_works":["https://openalex.org/W7099993302","https://openalex.org/W3023442443","https://openalex.org/W2056860783","https://openalex.org/W155432670","https://openalex.org/W1565208963","https://openalex.org/W2020958835","https://openalex.org/W3015928785","https://openalex.org/W3180669399","https://openalex.org/W1766020475","https://openalex.org/W4285124172"],"abstract_inverted_index":{"A":[0],"fundamental":[1],"issue":[2],"encountered":[3],"by":[4,70,97],"the":[5,13,26,30,46,54,72,83,92,99,115,122,125,134],"research":[6],"community":[7],"of":[8,15,33,45,82,94,101,124],"data":[9,38],"warehouses":[10],"(DWs)":[11],"is":[12,23,68],"modeling":[14,32],"data.":[16],"In":[17,118],"this":[18,66],"paper,":[19],"a":[20,50,58,76],"new":[21],"design":[22,47],"proposed,":[24],"named":[25],"starnest":[27,135],"schema,":[28],"for":[29,104],"logical":[31],"DWs.":[34],"Using":[35],"nested":[36,59,88],"methodology,":[37],"semantics":[39],"can":[40,110],"be":[41,111],"explicitly":[42],"represented.":[43],"Part":[44],"involves":[48],"providing":[49],"translation":[51],"mechanism":[52],"from":[53],"star/snowflake":[55],"schemas":[56],"to":[57,75,87,120],"representation.":[60],"The":[61,80],"novel":[62],"schema":[63,74],"proposed":[64,126],"in":[65,114],"paper":[67],"accomplished":[69],"converting":[71],"fact-dimension":[73],"fact-nested":[77],"dimension":[78,85,89],"schema.":[79,136],"transformation":[81],"denormalized":[84],"tables":[86,90],"increases":[91],"efficiency":[93],"query":[95,105],"execution":[96],"reducing":[98],"number":[100],"tuples":[102],"accessed":[103],"retrieval":[106],"since":[107],"dimensional":[108],"attributes":[109],"used":[112],"directly":[113],"Group-by":[116],"clause.":[117],"order":[119],"facilitate":[121],"implementation":[123],"approach,":[127],"specific":[128],"algorithms":[129],"are":[130],"built":[131],"based":[132],"on":[133]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2016144631","counts_by_year":[{"year":2026,"cited_by_count":3},{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":5},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":1}],"updated_date":"2026-11-19T14:11:59.513116","created_date":"2016-06-24T00:00:00"}
