Using object deputy model to prepare data for data warehousing

Z. Peng, Qing Li, L. Feng, X. Li, J. Liu

Research output: Journal article publicationJournal articleAcademic researchpeer-review

12 Citations (Scopus)

Abstract

Providing integrated access to multiple, distributed, heterogeneous databases and other information sources has become one of the leading issues in database research and the industry. One of the most effective approaches is to extract and integrate information of interest from each source in advance and store them in a centralized repository (known as a data warehouse). When a query is posed, it is evaluated directly at the warehouse without accessing the original information sources. One of the techniques that this approach uses to improve the efficiency of query processing is materialized view(s). Essentially, materialized views are used for data warehouses, and various methods for relational databases have been developed. In this paper, we will first discuss an object deputy approach to realize materialized object views for data warehouses which can also incorporate object-oriented databases. A framework has been developed using Smalltalk to prepare data for data warehousing, in which an object deputy model and database connecting tools have been implemented. The object deputy model can provide an easy-to-use way to resolve inconsistency and conflicts while preparing data for data warehousing, as evidenced by our empirical study. © 2005 IEEE.
Original languageEnglish
Pages (from-to)1274-1288
Number of pages15
JournalIEEE Transactions on Knowledge and Data Engineering
Volume17
Issue number9
DOIs
Publication statusPublished - 1 Sep 2005
Externally publishedYes

Keywords

  • Conflict resolution
  • Data fusion/integration
  • Data preparation
  • Data warehousing
  • Duplicate handling
  • Object deputy model

ASJC Scopus subject areas

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

Cite this