DocumentCode :
2253358
Title :
Verification of Data in Staging Schema, Mapping Between Source Tables and Materialized Views
Author :
Ahmed, Ejaz ; Revett, Kenneth
Author_Institution :
Departmentof Inf. & Comput. Sci., King Fahd Univ. of Pet. & Minerals, Dhahran
fYear :
2005
fDate :
5-8 Dec. 2005
Firstpage :
200
Lastpage :
204
Abstract :
With the proliferation of international standards for biomedical databases, the need for integration of small heterogeneous databases into large data warehouses highlights issues of consistency and integrity. In this paper, we discuss methods for providing semi-autonomous data integration by focusing on efficient design and effective mapping strategies. In order to upload and integrates data from various small to medium sized data repositories, an intermediate staging facility is employed to temporarily store data before it is validated to ensure accurate and useful integration into the data warehouse. We propose a mechanism that semi-automates the integration process that includes not only new data, but legacy data as well. We expand the notation of a DBMS to include the management of the data transfer process. The DBMS now must perform the task of data mapping in the form of value correspondences by using a staging schema mapping procedure
Keywords :
data handling; data warehouses; DBMS; biomedical databases; data repositories; data transfer management; data verification; data warehouses; semiautonomous data integration; staging schema; Biomedical computing; Biomedical engineering; Computer science; Data warehouses; Databases; Educational institutions; Engines; Filters; Minerals; Petroleum; Data Integration; Global Schema; Relational Schema; Staging Schema; Staging Tables;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Artificial intelligence, 2005. epia 2005. portuguese conference on
Conference_Location :
Covilha
Print_ISBN :
0-7803-9366-X
Electronic_ISBN :
0-7803-9366-X
Type :
conf
DOI :
10.1109/EPIA.2005.341295
Filename :
4145954
Link To Document :
بازگشت