Business Rules for Data Warehouse

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.

Authors:

• Rajeev Kaula

Keywords:

• Business Rules
• Data warehouse
• PL/SQL ServerPages
• Relational model
• Web Application.

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.