{"id":"https://openalex.org/W2148945291","doi":"https://doi.org/10.1109/hicss.2004.1265515","title":"Best practices in data warehousing to support business initiatives and needs","display_name":"Best practices in data warehousing to support business initiatives and needs","publication_year":2004,"publication_date":"2004-01-01","ids":{"openalex":"https://openalex.org/W2148945291","doi":"https://doi.org/10.1109/hicss.2004.1265515","mag":"2148945291"},"language":"en","primary_location":{"id":"doi:10.1109/hicss.2004.1265515","is_oa":false,"landing_page_url":"https://doi.org/10.1109/hicss.2004.1265515","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"37th Annual Hawaii International Conference on System Sciences, 2004. Proceedings of the","raw_type":"proceedings-article"},"type":"article","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/A5042405918","display_name":"J. Lawyer","orcid":null},"institutions":[{"id":"https://openalex.org/I102101047","display_name":"Roosevelt University","ror":"https://ror.org/020vmqv16","country_code":"US","type":"education","lineage":["https://openalex.org/I102101047"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"J. Lawyer","raw_affiliation_strings":["Walter E. Heller College of BusinessAdministration, Roosevelt University, Schaumburg, IL, USA"],"affiliations":[{"raw_affiliation_string":"Walter E. Heller College of BusinessAdministration, Roosevelt University, Schaumburg, IL, USA","institution_ids":["https://openalex.org/I102101047"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5067276149","display_name":"Sumit Singha Chowdhury","orcid":"https://orcid.org/0000-0001-9195-9409"},"institutions":[{"id":"https://openalex.org/I102101047","display_name":"Roosevelt University","ror":"https://ror.org/020vmqv16","country_code":"US","type":"education","lineage":["https://openalex.org/I102101047"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"S. Chowdhury","raw_affiliation_strings":["Walter E. Heller College of BusinessAdministration, Roosevelt University, Schaumburg, IL, USA"],"affiliations":[{"raw_affiliation_string":"Walter E. Heller College of BusinessAdministration, Roosevelt University, Schaumburg, IL, USA","institution_ids":["https://openalex.org/I102101047"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5042405918"],"corresponding_institution_ids":["https://openalex.org/I102101047"],"apc_list":null,"apc_paid":null,"fwci":0.2318,"has_fulltext":false,"cited_by_count":31,"citation_normalized_percentile":{"value":0.65387601,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"9 pp.","last_page":"9 pp."},"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.9995999932289124,"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.9995999932289124,"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.9926000237464905,"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.991100013256073,"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.8359233736991882},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6034026741981506},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.5893937349319458},{"id":"https://openalex.org/keywords/leverage","display_name":"Leverage (statistics)","score":0.5400183796882629},{"id":"https://openalex.org/keywords/architecture","display_name":"Architecture","score":0.5148219466209412},{"id":"https://openalex.org/keywords/master-data","display_name":"Master data","score":0.4994955062866211},{"id":"https://openalex.org/keywords/business-intelligence","display_name":"Business intelligence","score":0.49772027134895325},{"id":"https://openalex.org/keywords/plan","display_name":"Plan (archaeology)","score":0.4393702745437622},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4345203638076782},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.36902326345443726},{"id":"https://openalex.org/keywords/process-management","display_name":"Process management","score":0.3541055917739868},{"id":"https://openalex.org/keywords/business","display_name":"Business","score":0.24897778034210205}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8359233736991882},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6034026741981506},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.5893937349319458},{"id":"https://openalex.org/C153083717","wikidata":"https://www.wikidata.org/wiki/Q6535263","display_name":"Leverage (statistics)","level":2,"score":0.5400183796882629},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.5148219466209412},{"id":"https://openalex.org/C61871575","wikidata":"https://www.wikidata.org/wiki/Q384093","display_name":"Master data","level":2,"score":0.4994955062866211},{"id":"https://openalex.org/C2767350","wikidata":"https://www.wikidata.org/wiki/Q6662173","display_name":"Business intelligence","level":2,"score":0.49772027134895325},{"id":"https://openalex.org/C2776505523","wikidata":"https://www.wikidata.org/wiki/Q4785468","display_name":"Plan (archaeology)","level":2,"score":0.4393702745437622},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4345203638076782},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.36902326345443726},{"id":"https://openalex.org/C195094911","wikidata":"https://www.wikidata.org/wiki/Q14167904","display_name":"Process management","level":1,"score":0.3541055917739868},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.24897778034210205},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"score":0.0},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.0},{"id":"https://openalex.org/C153349607","wikidata":"https://www.wikidata.org/wiki/Q36649","display_name":"Visual arts","level":1,"score":0.0},{"id":"https://openalex.org/C166957645","wikidata":"https://www.wikidata.org/wiki/Q23498","display_name":"Archaeology","level":1,"score":0.0},{"id":"https://openalex.org/C95457728","wikidata":"https://www.wikidata.org/wiki/Q309","display_name":"History","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/hicss.2004.1265515","is_oa":false,"landing_page_url":"https://doi.org/10.1109/hicss.2004.1265515","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"37th Annual Hawaii International Conference on System Sciences, 2004. Proceedings of the","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Partnerships for the goals","score":0.5799999833106995,"id":"https://metadata.un.org/sdg/17"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":12,"referenced_works":["https://openalex.org/W568172912","https://openalex.org/W1481313366","https://openalex.org/W1508412218","https://openalex.org/W1604323310","https://openalex.org/W1605383703","https://openalex.org/W1928015230","https://openalex.org/W1945121096","https://openalex.org/W2144192824","https://openalex.org/W2462845112","https://openalex.org/W2945526390","https://openalex.org/W3150227232","https://openalex.org/W6616196130"],"related_works":["https://openalex.org/W208715492","https://openalex.org/W2581040172","https://openalex.org/W2383696629","https://openalex.org/W2506063602","https://openalex.org/W23190051","https://openalex.org/W2362581214","https://openalex.org/W3165010183","https://openalex.org/W2953652248","https://openalex.org/W2901498424","https://openalex.org/W4248501364"],"abstract_inverted_index":{"The":[0,29,57,116,174,214,230,257],"paper":[1,30,89],"presents":[2],"the":[3,32,40,45,49,54,60,84,93,97,103,128,141,165,171,178,204,210,262,296,319,332,335],"data":[4,24,37,99,113,161,194,197,216,232,234,252,258,286,297,308,330],"warehousing":[5,25,162],"architecture":[6,26,117],"and":[7,48,73,122,145,148,196,208,212,226,248,250,272,283,306,326],"practices":[8],"used":[9,237],"at":[10,127,157],"a":[11,65,131,184,301,312],"major":[12],"U.":[13,108],"S.":[14,109],"retailing":[15,110],"company.":[16,337],"Many":[17],"considerations":[18],"were":[19,188],"assessed":[20],"when":[21],"deciding":[22],"which":[23,76,106],"to":[27,64,102,137,200,244,264,324,331],"adopt.":[28],"discusses":[31],"two":[33],"pre-dominant":[34],"styles":[35],"in":[36,70,80,87,219,253,309],"warehousing,":[38],"namely":[39],"\"Bill":[41],"Inmon":[42,61],"Style\"":[43],"or":[44,181],"top-down":[46],"approach":[47],"\"Ralph":[50],"Kimball":[51],"Style":[52],"\"or":[53],"bottom-up":[55],"approach.":[56],"company":[58,129,159,263,320],"chose":[59],"style":[62],"due":[63],"unique":[66],"combination":[67],"of":[68,83,96,304,311,315,334],"circumstances":[69],"their":[71],"business":[72,273],"technical":[74],"environments,":[75],"are":[77,235,277],"being":[78,236],"discussed":[79],"detail.":[81],"Much":[82],"information":[85],"presented":[86],"this":[88,107,158],"is":[90,135,163],"based":[91],"upon":[92],"direct":[94],"experiences":[95],"lead":[98],"architect":[100],"assigned":[101],"projects":[104],"under":[105],"company's":[111],"customer":[112,246,266,307,329],"warehouse":[114,233,259,287,298],"evolved.":[115],"has":[118,124,260,299,321],"evolved":[119],"over":[120,239],"time":[121],"currently":[123],"been":[125,300,322],"accepted":[126],"as":[130,167],"best":[132,179],"practice.":[133],"It":[134],"interesting":[136],"mention":[138],"that":[139,177],"both":[140],"hardware":[142],"platform":[143],"(CPU":[144],"disk":[146],"drives)":[147],"relational":[149],"database":[150],"management":[151,268],"system":[152],"(RDBMS)":[153],"software":[154],"employed":[155],"today":[156],"for":[160,170,228,285],"not":[164,294],"same":[166],"was":[168,176,183,221],"selected":[169],"first":[172],"instantiation.":[173],"implication":[175],"plan":[180],"practice":[182],"flexible":[185],"one.":[186],"There":[187],"many":[189,278,289],"challenges,":[190],"like":[191],"organizational,":[192],"technical,":[193],"sourcing":[195],"naming,":[198],"needed":[199],"be":[201],"solved":[202],"during":[203],"pre-project,":[205],"initial":[206,215],"stages,":[207],"throughout":[209],"project":[211],"beyond.":[213],"warehouse,":[217],"implemented":[218],"1996,":[220],"termed":[222],"an":[223,254],"overall":[224],"success":[225],"approved":[227],"expansion.":[229],"current":[231],"by":[238],"six":[240],"hundred":[241],"registered":[242],"users":[243],"fine-tune":[245],"marketing":[247],"leverage":[249,325],"share":[251,327],"enterprise":[255,328],"manner.":[256],"allowed":[261],"strengthen":[265],"relationship":[267],"(CRM)":[269],"core":[270],"capabilities":[271],"partnerships.":[274],"Today,":[275],"there":[276],"departments":[279],"benefiting":[280],"from":[281],"queries":[282],"requests":[284],"data,":[288],"anticipated,":[290],"some":[291],"not.":[292],"Although":[293],"planned,":[295],"valuable":[302],"source":[303],"purchase":[305],"case":[310],"manufacturer":[313],"recall":[314],"merchandise.":[316],"Above":[317],"all,":[318],"able":[323],"benefit":[333],"entire":[336]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":13},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2012,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}