{"title":"The Comparison of Anchor and Star Schema from a Query Performance Perspective","authors":"Radek N\u011bmec","volume":71,"journal":"International Journal of Computer and Information Engineering","pagesStart":1421,"pagesEnd":1426,"ISSN":"1307-6892","URL":"https:\/\/publications.waset.org\/pdf\/4000","abstract":"Today's business environment requires that companies have access to highly relevant information in a matter of seconds.\r\nModern Business Intelligence tools rely on data structured mostly in traditional dimensional database schemas, typically represented by\r\nstar schemas. Dimensional modeling is already recognized as a\r\nleading industry standard in the field of data warehousing although\r\nseveral drawbacks and pitfalls were reported. This paper focuses on\r\nthe analysis of another data warehouse modeling technique - the\r\nanchor modeling, and its characteristics in context with the standardized dimensional modeling technique from a query performance perspective. The results of the analysis show\r\ninformation about performance of queries executed on database\r\nschemas structured according to principles of each database modeling\r\ntechnique.","references":"[1] S. Ambler, Agile Database Techniques: Effective Strategies for the Agile\r\nSoftware Developer,New Jersey: Wiley, 2003.\r\n[2] O. Regardt, L. R\u00f6nnb\u251c\u00f1ck, M. Bergholtz, P. Johannesson, P. Wohed,\r\n\"Anchor Modeling: An Agile Modeling Technique Using the Sixth\r\nNormal Form for Structurally and Temporally Evolving Data\", 2009, ER\r\n2009 [Lecture Notes in Computer Science, vol. 5829,no.1, pp. 234-250].\r\n[3] H. J. Watson, T. Ariyachandra. Data Warehouse Architectures: Factors in the Selection Decision and the Success of the Architectures, Technical\r\nReport, Terry College of Business, University of Georgia, Athens, GA,\r\nJuly 2005\r\n[4] C. J. Date, The Relational Database Dictionary: A Comprehensive\r\nGlossary of Relational Terms and Concepts, with Illustrative\r\nExamples,2006, O'Reilly Series Pocket References. O'Reilly Media, Inc.\r\n[5] R. Rob, C. Coronel, K. Crockett, Database Systems: Design, Implementation & Management, 2008, London: Cengage Learning EMEA.\r\n[6] A. Askarunisa, P. Prameela, N. Ramraj, \"DBGEN- Database (Test)\r\nGENerator - An Automated Framework for Database Application Testing\". 2009, International Journal of Database Theory and Application, vol. 2, no. 3, pp. 27-54.\r\n[7] G. Di Vitantonio, J. Legh-Smith, W. Millar, M. Wilkinson, \"Meeting business objectives through adaptive information and communications\r\ntechnology\", 2006, BT Technology Journal, vol. 24, no. 4, pp. 113-120.","publisher":"World Academy of Science, Engineering and Technology","index":"Open Science Index 71, 2012"}