Business Rules for Data Warehouse

Authors: Rajeev Kaula

Abstract:

Business rules and data warehouse are concepts and technologies that impact a wide variety of organizational tasks. In general, each area has evolved independently, impacting application development and decision-making. Generating knowledge from data warehouse is a complex process. This paper outlines an approach to ease import of information and knowledge from a data warehouse star schema through an inference class of business rules. The paper utilizes the Oracle database for illustrating the working of the concepts. The star schema structure and the business rules are stored within a relational database. The approach is explained through a prototype in Oracle-s PL/SQL Server Pages.

Keywords: Business Rules, Data warehouse, PL/SQL ServerPages, Relational model, Web Application.

Digital Object Identifier (DOI): doi.org/10.5281/zenodo.1059611

References:

[1] Y. Amghar, M. Meziane, and A. Flory, "Modeling of Business Rules For Active Database Application Specification," in Advanced Topics in Database Research, K. Siau, Ed., Hershey, PA: Idea Group Publishing, 2002, pp. 135-156.
[2] S. Boardman, M. Caffrey, S. Morse, and B. Rosenzweig, Oracle Web Application Programming for PL/SQL Developers, Upper Saddle River, NJ: Prentice-Hall, 2003.
[3] C.J. Date, What Not How: The Business Rules Approach to Application Development, Reading, MA: Addison-Wesley, 2000.
[4] C. J. Date and H. Darwen,, Foundation for Future Database Systems: The Third Manifesto, 2nd ed., Reading, MA: Addison-Wesley, 2000.
[5] J. Dyche, e-Data, Reading, MA: Addison-Wesley, 2000.
[6] B.V. Halle, Business Rules Applied, New York, NY: John Wiley & Sons, 2002.
[7] D.C. Hay, "A Repository Model - Business Rules - Part I (Structural assertions and derivations)," The Data Administration Newsletter, Issue 19, January 2002. Available: http://www.tdan.com
[8] D.C. Hay, "A Repository Model - Business Rules - Part II (Action Assertions)," The Data Administration Newsletter, Issue 20, April 2002. Available: http://www.tdan.com
[9] D.C. Hay, "Modeling Busines Rules: What Data Models Do," The Data Administration Newsletter, Issue 27, January 2004. Available: http://www.tdan.com
[10] R. Kaula, Oracle 10g: Developing Web Applications with PL/SQL Server Pages, New York, NY: Mc-Graw-Hill, 2006.
[11] R. Kimball, The Data Warehouse Toolkit, New York, NY: John Wiley & Sons, 2002.
[12] S. Ram and V. Khatri, "A comprehensive framework for modeling setbased business rules during conceptual database design," Information Systems, Vol. 30, pp. 89-118, 2005.
[13] R.G. Ross, The Business Rule Book: Classifying, Defining, and Modeling Rules, 2nd ed., Boston, MA: Database Research Group, 1997.