{"id":"https://openalex.org/W4251413458","doi":"https://doi.org/10.1002/9780470050118.ecse567","title":"Data Warehouse","display_name":"Data Warehouse","publication_year":2008,"publication_date":"2008-01-15","ids":{"openalex":"https://openalex.org/W4251413458","doi":"https://doi.org/10.1002/9780470050118.ecse567"},"language":"en","primary_location":{"id":"doi:10.1002/9780470050118.ecse567","is_oa":false,"landing_page_url":"https://doi.org/10.1002/9780470050118.ecse567","pdf_url":null,"source":{"id":"https://openalex.org/S4306534807","display_name":"Wiley Encyclopedia of Computer Science and Engineering","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Wiley Encyclopedia of Computer Science and Engineering","raw_type":"other"},"type":"other","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/A5009924329","display_name":"Stefano Rizzi","orcid":"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":true,"raw_author_name":"Stefano Rizzi","raw_affiliation_strings":["University of Bologna, Bologna, Italy","University of Bologna Bologna Italy"],"affiliations":[{"raw_affiliation_string":"University of Bologna, Bologna, Italy","institution_ids":["https://openalex.org/I9360294"]},{"raw_affiliation_string":"University of Bologna Bologna Italy","institution_ids":["https://openalex.org/I9360294"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5009924329"],"corresponding_institution_ids":["https://openalex.org/I9360294"],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"9"},"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.9990000128746033,"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.9990000128746033,"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/T11719","display_name":"Data Quality and Management","score":0.9955999851226807,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9941999912261963,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.9221368432044983},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.9074989557266235},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7591612339019775},{"id":"https://openalex.org/keywords/online-transaction-processing","display_name":"Online transaction processing","score":0.7303956151008606},{"id":"https://openalex.org/keywords/dimensional-modeling","display_name":"Dimensional modeling","score":0.6688005924224854},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5920964479446411},{"id":"https://openalex.org/keywords/business-intelligence","display_name":"Business intelligence","score":0.5142149925231934},{"id":"https://openalex.org/keywords/implementation","display_name":"Implementation","score":0.5089414119720459},{"id":"https://openalex.org/keywords/field","display_name":"Field (mathematics)","score":0.42305436730384827},{"id":"https://openalex.org/keywords/star-schema","display_name":"Star schema","score":0.4143525958061218},{"id":"https://openalex.org/keywords/transaction-data","display_name":"Transaction data","score":0.4068840742111206},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.401227205991745},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.27234798669815063},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.2025943100452423},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.16494908928871155}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.9221368432044983},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.9074989557266235},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7591612339019775},{"id":"https://openalex.org/C191087605","wikidata":"https://www.wikidata.org/wiki/Q1501395","display_name":"Online transaction processing","level":4,"score":0.7303956151008606},{"id":"https://openalex.org/C143008350","wikidata":"https://www.wikidata.org/wiki/Q3432172","display_name":"Dimensional modeling","level":2,"score":0.6688005924224854},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5920964479446411},{"id":"https://openalex.org/C2767350","wikidata":"https://www.wikidata.org/wiki/Q6662173","display_name":"Business intelligence","level":2,"score":0.5142149925231934},{"id":"https://openalex.org/C26713055","wikidata":"https://www.wikidata.org/wiki/Q245962","display_name":"Implementation","level":2,"score":0.5089414119720459},{"id":"https://openalex.org/C9652623","wikidata":"https://www.wikidata.org/wiki/Q190109","display_name":"Field (mathematics)","level":2,"score":0.42305436730384827},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.4143525958061218},{"id":"https://openalex.org/C127722929","wikidata":"https://www.wikidata.org/wiki/Q7833714","display_name":"Transaction data","level":3,"score":0.4068840742111206},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.401227205991745},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.27234798669815063},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.2025943100452423},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.16494908928871155},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"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/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1002/9780470050118.ecse567","is_oa":false,"landing_page_url":"https://doi.org/10.1002/9780470050118.ecse567","pdf_url":null,"source":{"id":"https://openalex.org/S4306534807","display_name":"Wiley Encyclopedia of Computer Science and Engineering","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Wiley Encyclopedia of Computer Science and Engineering","raw_type":"other"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/16","score":0.6000000238418579,"display_name":"Peace, Justice and strong institutions"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":22,"referenced_works":["https://openalex.org/W336975910","https://openalex.org/W1510220247","https://openalex.org/W1936689714","https://openalex.org/W1971323001","https://openalex.org/W1971518725","https://openalex.org/W1974153000","https://openalex.org/W1975968096","https://openalex.org/W2008120802","https://openalex.org/W2008440502","https://openalex.org/W2037460328","https://openalex.org/W2052884373","https://openalex.org/W2106039833","https://openalex.org/W2113888164","https://openalex.org/W2114887408","https://openalex.org/W2135203905","https://openalex.org/W2146581901","https://openalex.org/W2149877754","https://openalex.org/W2167340337","https://openalex.org/W2350573227","https://openalex.org/W3002580249","https://openalex.org/W4245642253","https://openalex.org/W4301136025"],"related_works":["https://openalex.org/W2188975716","https://openalex.org/W2084383859","https://openalex.org/W1555950237","https://openalex.org/W1525815534","https://openalex.org/W2980304303","https://openalex.org/W313120457","https://openalex.org/W1490893790","https://openalex.org/W2357522326","https://openalex.org/W963130346","https://openalex.org/W2115627979"],"abstract_inverted_index":{"Abstract":[0],"A":[1],"data":[2,47,85,91,126,135,148,166],"warehousing":[3,48,136],"system":[4],"is":[5,49],"a":[6,80,125],"collection":[7],"of":[8,46,124,134,174],"methods,":[9],"techniques,":[10],"and":[11,41,102,108,113,150,169],"tools":[12],"that":[13,35,55,87],"support":[14],"the":[15,52,69,89,121,131,139,147,154,161,171],"knowledge":[16],"worker":[17],"(manager,":[18],"administrator,":[19],"analyst)":[20],"in":[21,29,146,176],"decision":[22,114],"making":[23],"by":[24,78],"transforming":[25],"operational":[26,70],"data,":[27],"stored":[28],"corporate":[30],"databases,":[31],"into":[32,98],"strategic":[33,57],"information":[34,82,145],"can":[36],"be":[37],"accessed":[38],"quickly,":[39],"reliably,":[40],"flexibly.":[42],"The":[43],"core":[44],"idea":[45],"to":[50,143,165],"separate":[51],"analytical":[53],"queries":[54],"extract":[56],"information,":[58,159],"which":[59],"are":[60],"commonly":[61],"called":[62,72],"OLAP":[63],"(On\u2010Line":[64,74],"Analytical":[65],"Processing)":[66,76],"queries,":[67,77],"from":[68,93],"ones,":[71],"OLTP":[73],"Transactional":[75],"building":[79],"new":[81],"repository":[83],"(the":[84],"warehouse)":[86],"integrates":[88],"elemental":[90],"coming":[92],"different":[94],"sources,":[95],"organizes":[96],"them":[97,104],"an":[99],"appropriate":[100],"structure,":[101],"makes":[103],"available":[105],"for":[106,157],"analyses":[107],"evaluations":[109],"aimed":[110],"at":[111],"planning":[112],"making.":[115],"In":[116],"this":[117,177],"article,":[118],"after":[119],"providing":[120],"basic":[122],"definition":[123],"warehouse,":[127],"we":[128],"will":[129],"describe":[130],"main":[132,155,162,172],"architectures":[133],"systems,":[137],"define":[138],"multidimensional":[140],"model":[141],"used":[142],"store":[144],"warehouse":[149,167],"its":[151],"implementations,":[152],"explain":[153],"techniques":[156],"accessing":[158],"survey":[160],"issues":[163],"related":[164],"design,":[168],"mention":[170],"topics":[173],"research":[175],"field.":[178]},"counts_by_year":[{"year":2015,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2022-05-12T00:00:00"}