InterBase-KB: Integrating a knowledge base system with a multidatabase system for data warehousing

Nick Bassiliades, Ioannis Vlahavas, Ahmed Elmagarmid, Elias N. Houstis

Research output: Contribution to journalArticle

6 Citations (Scopus)

Abstract

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. In addition, the knowledge base system offers 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.

Original languageEnglish
Pages (from-to)1188-1205
Number of pages18
JournalIEEE Transactions on Knowledge and Data Engineering
Volume15
Issue number5
DOIs
Publication statusPublished - 1 Sep 2003
Externally publishedYes

Fingerprint

Data warehouses
Data integration
Query languages
Warehouses
Cleaning
Semantics

Keywords

  • Active rule
  • Data warehouse
  • Deductive rule
  • Knowledge base system
  • Materialized view
  • Multidabase
  • Schema integration

ASJC Scopus subject areas

  • Control and Systems Engineering
  • Electrical and Electronic Engineering
  • Artificial Intelligence
  • Information Systems

Cite this

InterBase-KB : Integrating a knowledge base system with a multidatabase system for data warehousing. / Bassiliades, Nick; Vlahavas, Ioannis; Elmagarmid, Ahmed; Houstis, Elias N.

In: IEEE Transactions on Knowledge and Data Engineering, Vol. 15, No. 5, 01.09.2003, p. 1188-1205.

Research output: Contribution to journalArticle

@article{b2fc3d502eef42aa92fc598c34e8e927,
title = "InterBase-KB: Integrating a knowledge base system with a multidatabase system for data warehousing",
abstract = "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. In addition, the knowledge base system offers 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.",
keywords = "Active rule, Data warehouse, Deductive rule, Knowledge base system, Materialized view, Multidabase, Schema integration",
author = "Nick Bassiliades and Ioannis Vlahavas and Ahmed Elmagarmid and Houstis, {Elias N.}",
year = "2003",
month = "9",
day = "1",
doi = "10.1109/TKDE.2003.1232272",
language = "English",
volume = "15",
pages = "1188--1205",
journal = "IEEE Transactions on Knowledge and Data Engineering",
issn = "1041-4347",
publisher = "IEEE Computer Society",
number = "5",

}

TY - JOUR

T1 - InterBase-KB

T2 - Integrating a knowledge base system with a multidatabase system for data warehousing

AU - Bassiliades, Nick

AU - Vlahavas, Ioannis

AU - Elmagarmid, Ahmed

AU - Houstis, Elias N.

PY - 2003/9/1

Y1 - 2003/9/1

N2 - 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. In addition, the knowledge base system offers 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.

AB - 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. In addition, the knowledge base system offers 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.

KW - Active rule

KW - Data warehouse

KW - Deductive rule

KW - Knowledge base system

KW - Materialized view

KW - Multidabase

KW - Schema integration

UR - http://www.scopus.com/inward/record.url?scp=0141613764&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=0141613764&partnerID=8YFLogxK

U2 - 10.1109/TKDE.2003.1232272

DO - 10.1109/TKDE.2003.1232272

M3 - Article

AN - SCOPUS:0141613764

VL - 15

SP - 1188

EP - 1205

JO - IEEE Transactions on Knowledge and Data Engineering

JF - IEEE Transactions on Knowledge and Data Engineering

SN - 1041-4347

IS - 5

ER -