A Rule-Based Data Warehouse Model
A data warehouse is built by collecting data from external sources. Changes that occur have to be reflected in the data warehouse thanks to schema updating or versioning. However a data warehouse has also to evolve according to users’ analysis needs. This evolution is rather driven by knowledge than by data. To take into account these changes, we propose a new Rule-based Data Warehouse (R-DW) model in which rules integrate users’ knowledge to dynamically create dimension hierarchies. The R-DW model is composed of a fixed part which is a fact table related to its first level dimensions, and an evolving part which contains the rules. Our model allows analysis context evolution and increases interactions between users and the decision support system.
KeywordsData Warehouse Level Dimension Granularity Level Fact Table Student Agency
Unable to display preview. Download preview PDF.
- 1.Blaschka, M., Sapia, C., Höfling, G.: On Schema Evolution in Multidimensional Databases. In: Mohania, M., Tjoa, A.M. (eds.) DaWaK 1999. LNCS, vol. 1676, pp. 153–164. Springer, Heidelberg (1999)Google Scholar
- 3.Kim, H.J., Lee, T.H., Lee, S.G., Chun, J.: Automated Data Warehousing for Rule-Based CRM Systems. In: 14th Australasian Database Conference on Database Technologies, pp. 67–73 (2003)Google Scholar
- 4.Peralta, V., Illarze, A., Ruggia, R.: On the Applicability of Rules to Automate Data Warehouse Logical Design. In: CAiSE Workshops (2003)Google Scholar
- 5.Carpani, F., Ruggia, R.: An Integrity Constraints Language for a Conceptual Multidimensional Data Model. In: SEKE 2001: XIII International Conference on Software Engineering & Knowledge Engineering (2001)Google Scholar
- 6.Espil, M.M., Vaisman, A.A.: Efficient Intensional Redefinition of Aggregation Hierarchies in Multidimensional Databases. In: DOLAP 2001: 4th ACM International Workshop on Data Warehousing and OLAP (2001)Google Scholar