データ統合

データベース設計

Lis Sulmont

Curriculum Manager

データ統合とは？

データ統合は、異なるソース、フォーマット、技術のデータを組み合わせ、ユーザーに統一された一元的なビューを提供する

Database icon representing a unified data model

Three data sources with no connection to the unified data model

Three data sources with no connections to the unified data model and with different formats

Three data sources with different formats unconnected to the unified data model which is a Redshift data warehouse

Three data sources with different formats and from different departments unconnected to the unified data model which is a Redshift data warehouse

The three data sources updating daily

The three data sources updating in real-time

The three data sources updating at different times

The three data sources connect to the unified data model

The three data sources updating daily with a big X over it

The three data sources being transformed to fit the unified data model

Processing the three data sources via ETL to the unified data model

ETL diagram with testing icons at each phase

ETL diagram showing portions of data that should be restricted from its source to destination

ETL diagram with anonymization of credit card data

ETL diagram with a line representing the flow of data from its source to destination

データベース設計