NDLI: Verification of Data in Staging Schema, Mapping Between Source Tables and Materialized Views

Content Provider	IEEE Xplore Digital Library
Author	Ahmed, E. Revett, K.
Copyright Year	2006
Description	Author affiliation: Departmentof Inf. & Comput. Sci., King Fahd Univ. of Pet. & Minerals, Dhahran (Ahmed, E.)
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
Starting Page	200
Ending Page	204
File Size	4434292
Page Count	5
File Format	PDF
ISBN	0780393651
DOI	10.1109/EPIA.2005.341295
Language	English
Publisher	Institute of Electrical and Electronics Engineers, Inc. (IEEE)
Publisher Date	2005-12-05
Publisher Place	Portugal
Access Restriction	Subscribed
Rights Holder	Institute of Electrical and Electronics Engineers, Inc. (IEEE)
Subject Keyword	Relational Schema Data warehouses Educational institutions Biomedical computing Minerals Engines Petroleum Staging Schema Data Integration Computer science Filters Databases Staging Tables Global Schema Biomedical engineering
Content Type	Text
Resource Type	Article

Sl.	Authority	Responsibilities	Communication Details
1	Ministry of Education (GoI), Department of Higher Education	Sanctioning Authority	https://www.education.gov.in/ict-initiatives
2	Indian Institute of Technology Kharagpur	Host Institute of the Project: The host institute of the project is responsible for providing infrastructure support and hosting the project	https://www.iitkgp.ac.in
3	National Digital Library of India Office, Indian Institute of Technology Kharagpur	The administrative and infrastructural headquarters of the project	Dr. B. Sutradhar bsutra@ndl.gov.in
4	Project PI / Joint PI	Principal Investigator and Joint Principal Investigators of the project	Dr. B. Sutradhar bsutra@ndl.gov.in Prof. Saswat Chakrabarti will be added soon
5	Website/Portal (Helpdesk)	Queries regarding NDLI and its services	support@ndl.gov.in
6	Contents and Copyright Issues	Queries related to content curation and copyright issues	content@ndl.gov.in
7	National Digital Library of India Club (NDLI Club)	Queries related to NDLI Club formation, support, user awareness program, seminar/symposium, collaboration, social media, promotion, and outreach	clubsupport@ndl.gov.in
8	Digital Preservation Centre (DPC)	Assistance with digitizing and archiving copyright-free printed books	dpc@ndl.gov.in
9	IDR Setup or Support	Queries related to establishment and support of Institutional Digital Repository (IDR) and IDR workshops	idr@ndl.gov.in

Data loading and mapping using staging DBMS in the grid

Strategy of Selecting Materialized Views Based on Cache-updating

Research on Materialized Views Technology in Data Warehouse

Discovering Complex Semantic Matches between Database Schemas

Integration of relational databases and record-based legacy systems for populating data warehouses

A Hybrid Approach of Mapping Relational Database Schema to Ontology

How schema mapping can help in data integration? – integrating the relational databases with ontologies.

Merging relational views: a minimization approach.

Data warehouse enhancement manipulating materialized view hierarchy

Verification of Data in Staging Schema, Mapping Between Source Tables and Materialized Views

Similar Documents

Data loading and mapping using staging DBMS in the grid

Strategy of Selecting Materialized Views Based on Cache-updating

Research on Materialized Views Technology in Data Warehouse

Discovering Complex Semantic Matches between Database Schemas

Integration of relational databases and record-based legacy systems for populating data warehouses

A Hybrid Approach of Mapping Relational Database Schema to Ontology

How schema mapping can help in data integration? – integrating the relational databases with ontologies.

Merging relational views: a minimization approach.

Data warehouse enhancement manipulating materialized view hierarchy

Verification of Data in Staging Schema, Mapping Between Source Tables and Materialized Views