{"id":"https://openalex.org/W1528281972","doi":null,"title":"Planning and Designing the Data Warehouse","display_name":"Planning and Designing the Data Warehouse","publication_year":1996,"publication_date":"1996-07-01","ids":{"openalex":"https://openalex.org/W1528281972","mag":"1528281972"},"language":"en","primary_location":{"id":"mag:1528281972","doi":null,"is_oa":false,"landing_page_url":"https://ci.nii.ac.jp/ncid/BA31616811","pdf_url":null,"source":{"id":"https://openalex.org/S4306479719","display_name":"Simon and Schuster eBooks","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":"ebook platform"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Simon & Schuster eBooks","raw_type":null},"volume":null,"type":"book","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/A5024039265","display_name":"Herb Edelstein","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Herb Edelstein","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5103723983","display_name":"Ram\u00f3n C. Barqu\u00edn","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ram\u00f3n C. Barqu\u00edn","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":5.0875,"has_fulltext":false,"cited_by_count":63,"citation_normalized_percentile":{"value":0.95208333,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":88,"max":97},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"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.9994999766349792,"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.9994999766349792,"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/T14222","display_name":"Knowledge Management and Technology","score":9.999999747378752e-05,"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/T10317","display_name":"Advanced Database Systems and Queries","score":9.999999747378752e-05,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/data-warehouse-design","display_name":"data warehouse design","score":0.7350000143051147},{"id":"https://openalex.org/keywords/metadata-repository","display_name":"metadata repository","score":0.8899999856948853},{"id":"https://openalex.org/keywords/data-warehouse-implementation","display_name":"data warehouse implementation","score":0.5770000219345093},{"id":"https://openalex.org/keywords/management-support","display_name":"management support","score":0.7080000042915344},{"id":"https://openalex.org/keywords/data-management","display_name":"data management","score":0.3190000057220459}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8887174129486084},{"id":"https://openalex.org/C93518851","wikidata":"https://www.wikidata.org/wiki/Q180160","display_name":"Metadata","level":2,"score":0.7150722146034241},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5789552927017212},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.5756334066390991},{"id":"https://openalex.org/C50416739","wikidata":"https://www.wikidata.org/wiki/Q181623","display_name":"Warehouse","level":2,"score":0.5428649187088013},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.5128612518310547},{"id":"https://openalex.org/C143008350","wikidata":"https://www.wikidata.org/wiki/Q3432172","display_name":"Dimensional modeling","level":2,"score":0.4844782054424286},{"id":"https://openalex.org/C2779489174","wikidata":"https://www.wikidata.org/wiki/Q6822246","display_name":"Metadata management","level":3,"score":0.4635666310787201},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4521586298942566},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.3421221375465393},{"id":"https://openalex.org/C195094911","wikidata":"https://www.wikidata.org/wiki/Q14167904","display_name":"Process management","level":1,"score":0.3302612900733948},{"id":"https://openalex.org/C56739046","wikidata":"https://www.wikidata.org/wiki/Q192060","display_name":"Knowledge management","level":1,"score":0.3300248682498932},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.318861186504364},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.20837819576263428},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.1499582827091217},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.06976941227912903},{"id":"https://openalex.org/C162853370","wikidata":"https://www.wikidata.org/wiki/Q39809","display_name":"Marketing","level":1,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:1528281972","doi":null,"is_oa":false,"landing_page_url":"https://ci.nii.ac.jp/ncid/BA31616811","pdf_url":null,"source":{"id":"https://openalex.org/S4306479719","display_name":"Simon and Schuster eBooks","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":"ebook platform"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Simon & Schuster eBooks","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"sustainable_development_goals_aurora":[{"score":0.5199999809265137,"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure"}],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W1495788210","https://openalex.org/W574355879","https://openalex.org/W2037892218","https://openalex.org/W1592607370","https://openalex.org/W1481313366","https://openalex.org/W2067302471","https://openalex.org/W336975910","https://openalex.org/W3168138115","https://openalex.org/W568172912","https://openalex.org/W1977746237"],"abstract_inverted_index":{"From":[0],"the":[1,18,63,70,85],"Publisher:\r\nThis":[2],"is":[3,53,73],"a":[4,22,28,66],"comprehensive":[5],"survey":[6],"of":[7,20,65,87],"key":[8],"issues":[9],"associated":[10],"with":[11],"planning":[12,27],"and":[13,98,104],"designing":[14],"enterprise":[15],"data":[16,23,29,67,71],"warehouses.Covers":[17],"process":[19],"implementing":[21,36],"warehouse":[24,72],"end-to-end,":[25],"from":[26],"warehouse,":[30],"to":[31,35,43,55],"achieving":[32],"management":[33],"support,":[34],"metadata":[37],"repositories":[38],"that":[39,60],"make":[40,84],"it":[41],"easier":[42],"access":[44],"real":[45],"information,":[46],"rather":[47],"than":[48],"mere":[49],"data.":[50],"One":[51],"chapter":[52],"dedicated":[54],"helping":[56,81],"managers":[57],"avoid":[58],"mistakes":[59],"can":[61],"limit":[62],"effectiveness":[64],"warehouse.":[68],"Once":[69],"in":[74],"place,":[75],"this":[76],"book":[77],"provides":[78],"guidance":[79],"on":[80],"end":[82],"users":[83],"most":[86],"it.":[88],"Two":[89],"detailed":[90],"case":[91],"studies":[92],"are":[93],"also":[94],"included.Information":[95],"technology":[96],"managers,":[97],"database":[99],"professionals,":[100],"including":[101],"administrators,":[102],"programmers":[103],"designers.":[105]},"counts_by_year":[{"year":2020,"cited_by_count":1},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2012,"cited_by_count":3}],"updated_date":"2026-10-31T12:09:11.096373","created_date":"2016-06-24T00:00:00"}