{"id":"https://openalex.org/W2089132140","doi":"https://doi.org/10.1145/506760.506767","title":"The ten commandments of data warehousing","display_name":"The ten commandments of data warehousing","publication_year":2000,"publication_date":"2000-09-01","ids":{"openalex":"https://openalex.org/W2089132140","doi":"https://doi.org/10.1145/506760.506767","mag":"2089132140"},"language":"en","primary_location":{"id":"doi:10.1145/506760.506767","doi":"https://doi.org/10.1145/506760.506767","is_oa":false,"landing_page_url":"https://doi.org/10.1145/506760.506767","pdf_url":null,"source":{"id":"https://openalex.org/S4210234096","display_name":"ACM SIGMIS Database the DATABASE for Advances in Information Systems","issn_l":"0095-0033","issn":["0095-0033","1532-0936","2331-1584","2331-1622"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["abdc-a","anvur-scientific","fnege-3","jufo-1","norway-1","poland-40","russia-white-list-1"],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM SIGMIS Database: the DATABASE for Advances in Information Systems","raw_type":"journal-article"},"volume":null,"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/A5070487769","display_name":"David Sammon","orcid":"https://orcid.org/0000-0001-6138-0105","observed_orcids":["https://orcid.org/0000-0001-6138-0105"]},"institutions":[{"id":"https://openalex.org/I27577105","display_name":"University College Cork","ror":"https://ror.org/03265fv13","country_code":"IE","type":"education","lineage":["https://openalex.org/I27577105"]}],"countries":["IE"],"is_corresponding":false,"raw_author_name":"David Sammon","raw_affiliation_strings":["University College Cork","#N# University College Cork"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University College Cork","institution_ids":["https://openalex.org/I27577105"]},{"raw_affiliation_string":"#N# University College Cork","institution_ids":["https://openalex.org/I27577105"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5069296857","display_name":"Pat Finnegan","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I27577105","display_name":"University College Cork","ror":"https://ror.org/03265fv13","country_code":"IE","type":"education","lineage":["https://openalex.org/I27577105"]}],"countries":["IE"],"is_corresponding":false,"raw_author_name":"Pat Finnegan","raw_affiliation_strings":["University College Cork","#N# University College Cork"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University College Cork","institution_ids":["https://openalex.org/I27577105"]},{"raw_affiliation_string":"#N# University College Cork","institution_ids":["https://openalex.org/I27577105"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I27577105"],"apc_list":null,"apc_paid":null,"fwci":5.7448,"has_fulltext":false,"cited_by_count":66,"citation_normalized_percentile":{"value":0.95611702,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":95,"max":98},"biblio":{"volume":"31","issue":"4","first_page":"82","last_page":"91"},"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/T11572","display_name":"Information Technology Governance and Strategy","score":0.00019999999494757503,"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/T11938","display_name":"ERP Systems Implementation and Impact","score":9.999999747378752e-05,"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-warehousing","display_name":"data warehousing","score":0.9900000095367432},{"id":"https://openalex.org/keywords/data-warehouse-implementation","display_name":"data warehouse implementation","score":0.9900000095367432},{"id":"https://openalex.org/keywords/organizational-prerequisites","display_name":"organizational prerequisites","score":0.8410000205039978},{"id":"https://openalex.org/keywords/implementation-success","display_name":"implementation success","score":0.5899999737739563},{"id":"https://openalex.org/keywords/project-success-assessment","display_name":"project success assessment","score":0.6330000162124634},{"id":"https://openalex.org/keywords/organizational-maturity","display_name":"organizational maturity","score":0.3409999907016754}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.9091179370880127},{"id":"https://openalex.org/C25343380","wikidata":"https://www.wikidata.org/wiki/Q277521","display_name":"Relation (database)","level":2,"score":0.5926803946495056},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5411301255226135},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.42258912324905396},{"id":"https://openalex.org/C56739046","wikidata":"https://www.wikidata.org/wiki/Q192060","display_name":"Knowledge management","level":1,"score":0.3594590127468109},{"id":"https://openalex.org/C195094911","wikidata":"https://www.wikidata.org/wiki/Q14167904","display_name":"Process management","level":1,"score":0.3348608613014221},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.2706078290939331},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.24442923069000244}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/506760.506767","doi":"https://doi.org/10.1145/506760.506767","is_oa":false,"landing_page_url":"https://doi.org/10.1145/506760.506767","pdf_url":null,"source":{"id":"https://openalex.org/S4210234096","display_name":"ACM SIGMIS Database the DATABASE for Advances in Information Systems","issn_l":"0095-0033","issn":["0095-0033","1532-0936","2331-1584","2331-1622"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":["abdc-a","anvur-scientific","fnege-3","jufo-1","norway-1","poland-40","russia-white-list-1"],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM SIGMIS Database: the DATABASE for Advances in Information Systems","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"sustainable_development_goals_aurora":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":6,"referenced_works":["https://openalex.org/W1592607370","https://openalex.org/W1602817200","https://openalex.org/W1995999642","https://openalex.org/W2015673674","https://openalex.org/W2467784794","https://openalex.org/W2994314692"],"related_works":["https://openalex.org/W2338177395","https://openalex.org/W1516261653","https://openalex.org/W92409695","https://openalex.org/W2406761517","https://openalex.org/W235959091","https://openalex.org/W2604621764","https://openalex.org/W2958240952","https://openalex.org/W2267011402","https://openalex.org/W2158201592","https://openalex.org/W1539837880"],"abstract_inverted_index":{"Data":[0],"warehousing":[1,37,88],"can":[2],"offer":[3],"great":[4],"potential":[5],"for":[6,21,65],"organizations.":[7,22],"Nevertheless,":[8],"implementing":[9,51,66],"a":[10,14,29],"data":[11,36,52,67,87],"warehouse":[12],"is":[13],"complex":[15],"project":[16,89],"that":[17,72,96],"has":[18],"caused":[19],"difficulty":[20],"This":[23],"paper":[24],"presents":[25],"the":[26,59,84,94],"results":[27],"of":[28,31,35,61,86],"study":[30],"four":[32],"mature":[33],"users":[34],"technology.":[38],"Collectively,":[39],"these":[40],"organizations":[41,80],"have":[42],"experienced":[43],"many":[44],"problems":[45],"and":[46,91],"solutions":[47],"in":[48,58],"relation":[49],"to":[50,81,92,100],"warehousing.":[53,68],"These":[54],"experience":[55],"are":[56],"captured":[57],"form":[60],"ten":[62],"organizational":[63],"prerequisites":[64],"The":[69],"authors":[70],"believe":[71],"this":[73],"model":[74],"could":[75],"potentially":[76],"be":[77],"used":[78],"by":[79],"internally":[82],"assess":[83],"likelihood":[85],"success,":[90],"identify":[93],"areas":[95],"require":[97],"attention":[98],"prior":[99],"commencing":[101],"implementation.":[102]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":4},{"year":2018,"cited_by_count":4},{"year":2017,"cited_by_count":3},{"year":2016,"cited_by_count":4},{"year":2015,"cited_by_count":4},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":4},{"year":2012,"cited_by_count":4}],"updated_date":"2026-10-14T16:39:01.820549","created_date":"2016-06-24T00:00:00"}