{"id":"https://openalex.org/W6672874","doi":null,"title":"Designing the Data Warehouse: Key Steps and Crucial Issues","display_name":"Designing the Data Warehouse: Key Steps and Crucial Issues","alternate_titles":[],"publication_year":1999,"publication_date":"1999-01-01","ids":{"openalex":"https://openalex.org/W6672874","mag":"6672874"},"language":"en","primary_location":{"id":"mag:6672874","doi":null,"is_oa":false,"landing_page_url":"https://www.researchgate.net/profile/Matteo_Golfarelli/publication/2292793_Designing_the_Data_Warehouse_Key_Steps_and_Crucial_Issues/links/0912f50893d44310fe000000.pdf","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W6672874"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":[],"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":[],"countries":[],"is_corresponding":false,"raw_author_name":"Matteo Golfarelli","raw_affiliation_strings":[],"raw_orcid":"https://orcid.org/0000-0002-0437-0725","affiliations":[]},{"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":[],"countries":[],"is_corresponding":false,"raw_author_name":"Stefano Rizzi","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":9.321,"has_fulltext":false,"cited_by_count":112,"citation_normalized_percentile":{"value":0.97852179,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":88,"max":98},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.8062000274658203,"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.8062000274658203,"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.18870000541210175,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.00019999999494757503,"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-design","display_name":"data warehouse design","score":0.996999979019165},{"id":"https://openalex.org/keywords/design-methodology","display_name":"design methodology","score":0.7870000004768372},{"id":"https://openalex.org/keywords/conceptual-design","display_name":"conceptual design","score":0.9020000100135803},{"id":"https://openalex.org/keywords/logical-design","display_name":"logical design","score":0.9929999709129333},{"id":"https://openalex.org/keywords/cost-function","display_name":"cost function","score":0.7570000290870667},{"id":"https://openalex.org/keywords/workload-analysis","display_name":"workload characterization","score":0.5979999899864197},{"id":"https://openalex.org/keywords/physical-design","display_name":"physical design","score":0.878000020980835},{"id":"https://openalex.org/keywords/query-efficiency","display_name":"query efficiency","score":0.3840000033378601}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.637606143951416},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.624194860458374},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5376667976379395},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.39877861738204956},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.22499528527259827},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.17778509855270386}],"mesh":[],"locations_count":2,"locations":[{"id":"mag:6672874","doi":null,"is_oa":false,"landing_page_url":"https://www.researchgate.net/profile/Matteo_Golfarelli/publication/2292793_Designing_the_Data_Warehouse_Key_Steps_and_Crucial_Issues/links/0912f50893d44310fe000000.pdf","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.45.1817","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.45.1817","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/jcsim99.ps.gz","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":28,"referenced_works":["https://openalex.org/W80950756","https://openalex.org/W116445393","https://openalex.org/W129057286","https://openalex.org/W1483342375","https://openalex.org/W1488870204","https://openalex.org/W1489790909","https://openalex.org/W1501548698","https://openalex.org/W1502629466","https://openalex.org/W1530537858","https://openalex.org/W1538267625","https://openalex.org/W1551548222","https://openalex.org/W1581894185","https://openalex.org/W1592607370","https://openalex.org/W1606507025","https://openalex.org/W1995999642","https://openalex.org/W2008120802","https://openalex.org/W2010413210","https://openalex.org/W2030285894","https://openalex.org/W2093588231","https://openalex.org/W2113888164","https://openalex.org/W2114712170","https://openalex.org/W2118305801","https://openalex.org/W2134217480","https://openalex.org/W2140646908","https://openalex.org/W2147399501","https://openalex.org/W2155166680","https://openalex.org/W2160677885","https://openalex.org/W2170235279"],"related_works":["https://openalex.org/W2052884373","https://openalex.org/W2359526738","https://openalex.org/W7099484363","https://openalex.org/W15687427","https://openalex.org/W7098252660","https://openalex.org/W2776948310","https://openalex.org/W2316501591","https://openalex.org/W7096095978","https://openalex.org/W7095887025","https://openalex.org/W4376528502"],"abstract_inverted_index":{"Though":[0],"designing":[1],"a":[2,25,39],"data":[3,32,103,129],"warehouse":[4],"requires":[5],"techniques":[6],"completely":[7],"different":[8,51],"from":[9],"those":[10],"adopted":[11],"for":[12,31,43,127],"operational":[13],"systems,":[14],"no":[15],"significant":[16],"effort":[17],"has":[18],"been":[19],"made":[20],"so":[21],"far":[22],"to":[23,86,108],"develop":[24],"complete":[26],"and":[27,53,91,105,117],"consistent":[28],"design":[29,45,64,74,119,142,147],"methodology":[30],"warehouses.":[33],"In":[34,131],"this":[35,61],"paper":[36],"we":[37],"outline":[38],"general":[40],"methodological":[41],"framework":[42],"DW":[44],"discussing":[46],"the":[47,50,54,68,89,94,112,115,124,128,141],"relationships":[48],"between":[49],"steps":[52],"difficulties":[55],"in":[56,84,100],"carrying":[57],"them":[58],"out.":[59],"Within":[60],"framework,":[62],"conceptual":[63],"is":[65,98,123],"based":[66],"on":[67],"Dimensional":[69],"Fact":[70],"Model,":[71],"while":[72],"logical":[73,116],"exploits":[75],"multiple":[76],"cost":[77],"functions":[78],"at":[79],"increasing":[80],"levels":[81],"of":[82,93,102,114],"detail":[83],"order":[85],"improve":[87],"both":[88],"efficiency":[90],"efficacy":[92],"algorithms.":[95],"A":[96],"workload":[97],"characterized":[99],"terms":[101],"volumes":[104],"expected":[106],"queries,":[107],"be":[109],"used":[110],"as":[111],"input":[113],"physical":[118],"phases":[120],"whose":[121],"output":[122],"final":[125],"scheme":[126],"warehouse.":[130],"particular,":[132],"drill-across":[133],"queries":[134],"are":[135],"explicitly":[136],"taken":[137],"into":[138],"account":[139],"throughout":[140],"steps.":[143],"Keywords":[144],"Data":[145],"warehouse,":[146],"methodology,":[148],"conce...":[149]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W6672874","counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":4},{"year":2018,"cited_by_count":2},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":4},{"year":2014,"cited_by_count":8},{"year":2013,"cited_by_count":3},{"year":2012,"cited_by_count":6}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2016-06-24T00:00:00"}
