Title

Business rules for data warehouse

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.

Department(s)

Information Technology and Cybersecurity

Document Type

Article

Keywords

Business rules, Data warehouse, PL/SQL Server pages, Relational model, Web application

Publication Date

11-1-2009

Journal Title

World Academy of Science, Engineering and Technology

Citation-only

Share

COinS