{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,2,25]],"date-time":"2026-02-25T22:48:09Z","timestamp":1772059689918,"version":"3.50.1"},"reference-count":30,"publisher":"Elsevier BV","issue":"3","license":[{"start":{"date-parts":[[2003,5,1]],"date-time":"2003-05-01T00:00:00Z","timestamp":1051747200000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.elsevier.com\/tdm\/userlicense\/1.0\/"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Information Systems"],"published-print":{"date-parts":[[2003,5]]},"DOI":"10.1016\/s0306-4379(02)00021-2","type":"journal-article","created":{"date-parts":[[2003,1,30]],"date-time":"2003-01-30T11:48:43Z","timestamp":1043927323000},"page":"225-240","source":"Crossref","is-referenced-by-count":91,"title":["Why is the snowflake schema a good data warehouse design?"],"prefix":"10.1016","volume":"28","author":[{"given":"Mark","family":"Levene","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"George","family":"Loizou","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"78","reference":[{"key":"10.1016\/S0306-4379(02)00021-2_BIB1","series-title":"Building the Data Warehouse","author":"Inmon","year":"1996"},{"key":"10.1016\/S0306-4379(02)00021-2_BIB2","doi-asserted-by":"crossref","first-page":"65","DOI":"10.1145\/248603.248616","article-title":"An overview of data warehousing and OLAP technology","volume":"26","author":"Chaudhuri","year":"1997","journal-title":"ACM SIGMOD Record"},{"key":"10.1016\/S0306-4379(02)00021-2_BIB3","series-title":"The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses","author":"Kimball","year":"1998"},{"key":"10.1016\/S0306-4379(02)00021-2_BIB4","series-title":"The Design of Relational Databases","author":"Mannila","year":"1992"},{"key":"10.1016\/S0306-4379(02)00021-2_BIB5","series-title":"A Guided Tour of Relational Databases and Beyond","author":"Levene","year":"1999"},{"key":"10.1016\/S0306-4379(02)00021-2_BIB6","doi-asserted-by":"crossref","unstructured":"M. Golfarelli, D. Maio, S. Rizzi, Conceptual design of data warehouses from E\/R schemes, in: Proceedings of the Hawaii International Conference on System Sciences, Hawaii, 1998, pp. 334\u2013343.","DOI":"10.1109\/HICSS.1998.649228"},{"key":"10.1016\/S0306-4379(02)00021-2_BIB7","doi-asserted-by":"crossref","unstructured":"W. Lehner, J. Albrecht, H. Wedekind, Normal forms for multidimensional databases, in: Proceedings of International Conference on Scientific and Statistical Data Management, Capri, 1998, pp. 63\u201372.","DOI":"10.1109\/SSDM.1998.688112"},{"key":"10.1016\/S0306-4379(02)00021-2_BIB8","unstructured":"B. H\u00fcsemann, J. Lechtenb\u00f6rger, G. Vossen, Conceptual data warehouse design, in: Proceedings of International Workshop on Design and Management of Data Warehouses, Stockholm, 2000."},{"key":"10.1016\/S0306-4379(02)00021-2_BIB9","series-title":"The Data Webhouse Toolkit: Building the Web-enabled Data Warehouse","author":"Kimball","year":"2000"},{"key":"10.1016\/S0306-4379(02)00021-2_BIB10","doi-asserted-by":"crossref","first-page":"479","DOI":"10.1145\/2402.322389","article-title":"On the desirability of acyclic database schemes","volume":"30","author":"Beeri","year":"1983","journal-title":"J. ACM"},{"key":"10.1016\/S0306-4379(02)00021-2_BIB11","doi-asserted-by":"crossref","first-page":"514","DOI":"10.1145\/2402.322390","article-title":"Degrees of acyclicity for hypergraphs and relational database schemes","volume":"30","author":"Fagin","year":"1983","journal-title":"J. ACM"},{"key":"10.1016\/S0306-4379(02)00021-2_BIB12","doi-asserted-by":"crossref","first-page":"266","DOI":"10.1145\/319983.319988","article-title":"A characterization of globally consistent databases and their access paths","volume":"8","author":"Sagiv","year":"1983","journal-title":"ACM Trans. Database Systems"},{"key":"10.1016\/S0306-4379(02)00021-2_BIB13","doi-asserted-by":"crossref","first-page":"777","DOI":"10.1007\/BF01261656","article-title":"Independent database schemes under functional and inclusion dependencies","volume":"28","author":"Atzeni","year":"1991","journal-title":"Acta Inform."},{"key":"10.1016\/S0306-4379(02)00021-2_BIB14","doi-asserted-by":"crossref","first-page":"120","DOI":"10.1145\/102782.102787","article-title":"Evaluation of queries in independent database schemes","volume":"38","author":"Sagiv","year":"1991","journal-title":"J. ACM"},{"key":"10.1016\/S0306-4379(02)00021-2_BIB15","doi-asserted-by":"crossref","first-page":"841","DOI":"10.1137\/0216055","article-title":"Independent and separable database schemes","volume":"16","author":"Chan","year":"1987","journal-title":"SIAM J. Comput."},{"key":"10.1016\/S0306-4379(02)00021-2_BIB16","doi-asserted-by":"crossref","first-page":"8","DOI":"10.1145\/211990.212001","article-title":"Multi-table joins through bitmapped join indices","volume":"24","author":"O'Neil","year":"1995","journal-title":"ACM SIGMOD Record"},{"key":"10.1016\/S0306-4379(02)00021-2_BIB17","doi-asserted-by":"crossref","first-page":"211","DOI":"10.1016\/0306-4379(86)90029-3","article-title":"Statistical treatment of the information content of a database","volume":"11","author":"Malvestuto","year":"1986","journal-title":"Inform. Systems"},{"key":"10.1016\/S0306-4379(02)00021-2_BIB18","unstructured":"R. Cavallo, M. Pittarelli, The theory of probabilistic databases, in: Proceedings of International Conference on Very Large Data Bases, Brighton, 1987, pp. 71\u201381."},{"key":"10.1016\/S0306-4379(02)00021-2_BIB19","doi-asserted-by":"crossref","first-page":"1049","DOI":"10.1109\/TSE.1987.232847","article-title":"An information-theoretic analysis of relational databases\u2014Part I: data dependencies and information metric","volume":"13","author":"Lee","year":"1987","journal-title":"IEEE Trans. Software Eng."},{"key":"10.1016\/S0306-4379(02)00021-2_BIB20","doi-asserted-by":"crossref","first-page":"61","DOI":"10.1016\/0012-365X(88)90178-1","article-title":"Existence of extensions and product extensions for discrete probability distributions","volume":"69","author":"Malvestuto","year":"1988","journal-title":"Discrete Math."},{"key":"10.1016\/S0306-4379(02)00021-2_BIB21","series-title":"Making Decisions","author":"Lindley","year":"1985"},{"key":"10.1016\/S0306-4379(02)00021-2_BIB22","doi-asserted-by":"crossref","first-page":"668","DOI":"10.1145\/322326.322330","article-title":"Testing satisfaction of functional dependencies","volume":"29","author":"Honeyman","year":"1982","journal-title":"J. ACM"},{"key":"10.1016\/S0306-4379(02)00021-2_BIB23","series-title":"Distance in Graphs","author":"Buckley","year":"1990"},{"key":"10.1016\/S0306-4379(02)00021-2_BIB24","doi-asserted-by":"crossref","first-page":"683","DOI":"10.1016\/S0304-3975(00)00394-7","article-title":"Guaranteeing no interaction between functional dependencies and tree-like inclusion dependencies","volume":"254","author":"Levene","year":"2001","journal-title":"Theoret. Comput. Sci."},{"key":"10.1016\/S0306-4379(02)00021-2_BIB25","doi-asserted-by":"crossref","first-page":"30","DOI":"10.1145\/320064.320066","article-title":"Computational problems related to the design of normal form relational schemas","volume":"4","author":"Beeri","year":"1979","journal-title":"ACM Trans. Database Systems"},{"key":"10.1016\/S0306-4379(02)00021-2_BIB26","doi-asserted-by":"crossref","unstructured":"M.A. Casanova, V.M.P. Vidal, Towards a sound view integration methodology, in: Proceedings of ACM Symposium on Principles of Database Systems, Atlanta, 1983, pp. 36\u201347.","DOI":"10.1145\/588058.588065"},{"key":"10.1016\/S0306-4379(02)00021-2_BIB27","unstructured":"S.S. Cosmadakis, P.C. Kanellakis, Functional and inclusion dependencies: a graph theoretic approach, in: P.C. Kanellakis, F. Preparata (Eds.), Advances in Computing Research, Vol. 3, JAI Press, Greenwich, 1986, pp. 163\u2013184."},{"key":"10.1016\/S0306-4379(02)00021-2_BIB28","doi-asserted-by":"crossref","first-page":"115","DOI":"10.1016\/S0020-0190(99)00095-2","article-title":"How to prevent interaction of functional and inclusion dependencies","volume":"71","author":"Levene","year":"1999","journal-title":"Inform. Process. Lett."},{"key":"10.1016\/S0306-4379(02)00021-2_BIB29","unstructured":"J.R. Hill, Relational databases: a tutorial for statisticians, in: Proceedings of Symposium on the Interface between Computer Science and Statistics, Seattle, WA, 1991, pp. 86\u201393."},{"key":"10.1016\/S0306-4379(02)00021-2_BIB30","doi-asserted-by":"crossref","first-page":"281","DOI":"10.1109\/69.842267","article-title":"Justification for inclusion dependency normal form","volume":"12","author":"Levene","year":"2000","journal-title":"IEEE Trans. Knowledge and Data Eng."}],"container-title":["Information Systems"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:S0306437902000212?httpAccept=text\/xml","content-type":"text\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:S0306437902000212?httpAccept=text\/plain","content-type":"text\/plain","content-version":"vor","intended-application":"text-mining"}],"deposited":{"date-parts":[[2019,4,13]],"date-time":"2019-04-13T14:22:21Z","timestamp":1555165341000},"score":1,"resource":{"primary":{"URL":"https:\/\/linkinghub.elsevier.com\/retrieve\/pii\/S0306437902000212"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2003,5]]},"references-count":30,"journal-issue":{"issue":"3","published-print":{"date-parts":[[2003,5]]}},"alternative-id":["S0306437902000212"],"URL":"https:\/\/doi.org\/10.1016\/s0306-4379(02)00021-2","relation":{},"ISSN":["0306-4379"],"issn-type":[{"value":"0306-4379","type":"print"}],"subject":[],"published":{"date-parts":[[2003,5]]}}}