{"id":"https://openalex.org/W1484132276","doi":"https://doi.org/10.1007/978-3-642-15251-1_8","title":"Schema Design Alternatives for Multi-granular Data Warehousing","display_name":"Schema Design Alternatives for Multi-granular Data Warehousing","publication_year":2010,"publication_date":"2010-01-01","ids":{"openalex":"https://openalex.org/W1484132276","doi":"https://doi.org/10.1007/978-3-642-15251-1_8","mag":"1484132276"},"language":"en","primary_location":{"id":"doi:10.1007/978-3-642-15251-1_8","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-3-642-15251-1_8","pdf_url":null,"source":{"id":"https://openalex.org/S106296714","display_name":"Lecture notes in computer science","issn_l":"0302-9743","issn":["0302-9743","1611-3349"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Computer Science","raw_type":"book-chapter"},"type":"book-chapter","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/A5080204571","display_name":"Nadeem Iftikhar","orcid":"https://orcid.org/0000-0003-4872-8546"},"institutions":[{"id":"https://openalex.org/I891191580","display_name":"Aalborg University","ror":"https://ror.org/04m5j1k67","country_code":"DK","type":"education","lineage":["https://openalex.org/I891191580"]}],"countries":["DK"],"is_corresponding":false,"raw_author_name":"Nadeem Iftikhar","raw_affiliation_strings":["Department of Computer Science, Aalborg University, Selma Lagerl\u00f8fs Vej 300, 9220, Aalborg \u00d8, Denmark"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science, Aalborg University, Selma Lagerl\u00f8fs Vej 300, 9220, Aalborg \u00d8, Denmark","institution_ids":["https://openalex.org/I891191580"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5061064237","display_name":"Torben Bach Pedersen","orcid":"https://orcid.org/0000-0002-1615-777X"},"institutions":[{"id":"https://openalex.org/I891191580","display_name":"Aalborg University","ror":"https://ror.org/04m5j1k67","country_code":"DK","type":"education","lineage":["https://openalex.org/I891191580"]}],"countries":["DK"],"is_corresponding":false,"raw_author_name":"Torben Bach Pedersen","raw_affiliation_strings":["Department of Computer Science, Aalborg University, Selma Lagerl\u00f8fs Vej 300, 9220, Aalborg \u00d8, Denmark"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science, Aalborg University, Selma Lagerl\u00f8fs Vej 300, 9220, Aalborg \u00d8, Denmark","institution_ids":["https://openalex.org/I891191580"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I891191580"],"apc_list":{"value":5000,"currency":"EUR","value_usd":5392},"apc_paid":null,"fwci":2.7512,"has_fulltext":false,"cited_by_count":14,"citation_normalized_percentile":{"value":0.88756456,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"111","last_page":"125"},"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.9987000226974487,"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.9987000226974487,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9979000091552734,"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/T11106","display_name":"Data Management and Algorithms","score":0.9945999979972839,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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.8723493814468384},{"id":"https://openalex.org/keywords/granularity","display_name":"Granularity","score":0.8474903702735901},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.815151572227478},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.749506950378418},{"id":"https://openalex.org/keywords/star-schema","display_name":"Star schema","score":0.6770443916320801},{"id":"https://openalex.org/keywords/dimensional-modeling","display_name":"Dimensional modeling","score":0.6741724014282227},{"id":"https://openalex.org/keywords/schema-evolution","display_name":"Schema evolution","score":0.5519530177116394},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.5308678150177002},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4988255500793457},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4894522726535797},{"id":"https://openalex.org/keywords/dimension","display_name":"Dimension (graph theory)","score":0.4383397400379181},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.3601835072040558},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.3359190821647644},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.32637250423431396},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.18576985597610474},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.10649886727333069}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8723493814468384},{"id":"https://openalex.org/C177774035","wikidata":"https://www.wikidata.org/wiki/Q1246948","display_name":"Granularity","level":2,"score":0.8474903702735901},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.815151572227478},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.749506950378418},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.6770443916320801},{"id":"https://openalex.org/C143008350","wikidata":"https://www.wikidata.org/wiki/Q3432172","display_name":"Dimensional modeling","level":2,"score":0.6741724014282227},{"id":"https://openalex.org/C2780660560","wikidata":"https://www.wikidata.org/wiki/Q3951893","display_name":"Schema evolution","level":4,"score":0.5519530177116394},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.5308678150177002},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4988255500793457},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4894522726535797},{"id":"https://openalex.org/C33676613","wikidata":"https://www.wikidata.org/wiki/Q13415176","display_name":"Dimension (graph theory)","level":2,"score":0.4383397400379181},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.3601835072040558},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.3359190821647644},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.32637250423431396},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.18576985597610474},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.10649886727333069},{"id":"https://openalex.org/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1007/978-3-642-15251-1_8","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-3-642-15251-1_8","pdf_url":null,"source":{"id":"https://openalex.org/S106296714","display_name":"Lecture notes in computer science","issn_l":"0302-9743","issn":["0302-9743","1611-3349"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Computer Science","raw_type":"book-chapter"},{"id":"pmh:oai:pure.atira.dk:publications/628ce042-72eb-494d-a5cf-1a7b3fe9910b","is_oa":false,"landing_page_url":"https://vbn.aau.dk/da/publications/628ce042-72eb-494d-a5cf-1a7b3fe9910b","pdf_url":null,"source":{"id":"https://openalex.org/S4306401731","display_name":"VBN Forskningsportal (Aalborg Universitet)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I891191580","host_organization_name":"Aalborg University","host_organization_lineage":["https://openalex.org/I891191580"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Iftikhar , N & Pedersen , T B 2010 , ' Schema Design Alternatives for Multi-Granular Data Warehousing ' , Lecture Notes in Computer Science , vol. 6262 , pp. 111-125 . https://doi.org/10.1007/978-3-642-15251-1_8","raw_type":"contributionToPeriodical"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":13,"referenced_works":["https://openalex.org/W1510220247","https://openalex.org/W1529956645","https://openalex.org/W1536826708","https://openalex.org/W1564115980","https://openalex.org/W1748990669","https://openalex.org/W2016768375","https://openalex.org/W2034497960","https://openalex.org/W2037460328","https://openalex.org/W2055700739","https://openalex.org/W2123452736","https://openalex.org/W2136626596","https://openalex.org/W2490591675","https://openalex.org/W4245692265"],"related_works":["https://openalex.org/W1525815534","https://openalex.org/W2103472145","https://openalex.org/W1591654213","https://openalex.org/W49842380","https://openalex.org/W2164326160","https://openalex.org/W2153512431","https://openalex.org/W166845585","https://openalex.org/W2031254074","https://openalex.org/W2807794151","https://openalex.org/W2561775104"],"abstract_inverted_index":null,"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":2},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":2}],"updated_date":"2026-06-26T08:34:08.712188","created_date":"2025-10-10T00:00:00"}