elenco architetture etl

Here is a list of Architecture Patterns, Design Patterns, and Solution Patterns in the Application and Information Architecture Domains.

Sub-Domain Area	Architecture Pattern Name	Design Patterns	Solution Patterns	Related Patterns
Data Integration/SOA	ETL (Data Extraction Transformation & Loading)	Change Data Capture Near Real-Time ETL Batch ETL Data Discovery	Error handling Job scheduling Data validation Slowly Changing Dimensions Load	EAI Master Data Hub Operational Data Store (ODS) Datamart Datawarehouse
	FTP
	EAI/ESB	Publish/subscribe Request/reply Message Exchange Patterns	One-Way Synchronous Request/Response Basic Callback Claim Check	SOA
Data Architecture	Transaction Data Stores (TDS/OLTP) Master Data Store Operational Data Store Data Mart Data Warehouse	Custom Applications Databases Packaged Application Databases	ETL EAI SOA
Business Intelligence	Transactional Reporting Operational Reporting Analytical Reporting	Transactional Reporting Data Access Operational Reporting Data Access Analytical Reporting Data Access Analytical Dashboard Data Access Operational Dashboard Data Access Data Mining	Real-Time Dashboards In-Memory Analytics Statistical Analysis Predictive analytics	ETL EAI TDS Operational Data Store Datamart
Master data management	Master Data Hub	Master Data Replication Master Data Services Master Data Synchronization	Change Data Capture EAI SOA
Data Modeling	Dimensional Data Modeling E-R Data Modeling	Modeling Standards Naming Conventions