Data Extraction & Integration

Getting heterogenous data into the Warehouse:
Data from different DBMSs (Data base management system), external information providers, various standard applications,...

Tasks:

• Extraction (accessing different databases)
• Cleaning (resolving inconsistencies)
• Transformation (different formats, languages)
• Replication (importing a whole DB)
• Analyzing (detecting invalid values)
• Checking for data quality (correctness, completeness)
• Update metadata, if necessary

Index: Contents