Interbase-KB: A Knowledge-based Multidatabase System for Data Warehousing

N. Bassiliades, I. Vlahavas, A. Elmagarmid, E. Houstis, “Interbase-KB: A Knowledge-based Multidatabase System for Data Warehousing”, IEEE Transactions on Knowledge and Data Engineering, Vol. 15, No. 5, pp. 1188-1205, 2003.

Multidatabase, Schema Integration, Data Warehouse, Materialized View, Knowledge Base System, Deductive Rule, Active Rule.

This paper describes the integration of a multidatabase system and a knowledge-base system to support the data-integration component of a Data Warehouse. The multidatabase system integrates various component databases with a common query language, however it does not provide capability for schema integration and other utilities necessary for Data Warehousing. The knowledge base system offers in addition a declarative logic language with second-order syntax but first-order semantics for integrating the schemes of the data sources into the warehouse and for defining complex, recursively defined materialized views. Furthermore, deductive rules are also used for cleaning, checking the integrity and summarizing the data imported into the Data Warehouse. The Knowledge Base System features an efficient incremental view maintenance mechanism that is used for refreshing the Data Warehouse, without querying the data sources.