A9.3 Data Development
Activities |
Deliverables |
Responsible Roles |
Approving Roles |
Contributing Roles |
3.1.1 Analyze Information Requirements (D) |
Information Requirement Specification Statements |
Data Architects, Data Analysts |
Data Stewards |
Data Stewards, Other SMEs |
3.1.2 Develop and Maintain Conceptual Data Models (D) |
Conceptual Data Model Diagrams and Reports |
Data Architects, Data Analysts |
Data Stewards, Data Architects |
Data Stewards, Other SMEs |
3.1.3 Develop and Maintain Logical Data Models (D) |
Logical Data Model Diagrams and Reports |
Data Architects, Data Analysts, Data Modelers |
Data Stewards, Data Architects |
Data Stewards, Other SMEs |
3.1.4 Develop and Maintain Physical Data Models (D) |
Physical Data Model Diagrams and Reports |
Data Architects, Data Modelers, DBAs |
DBAs, Data Architects |
Software Developers |
3.2.1 Design Physical Databases (D) |
DDL Specifications, OLAP Cube Specs, XML schemas |
DBAs, Application Architects, Software Developers |
Data Architects, DBAs, Application Architects |
Data Analysts, Data Modelers, Software Developers |
3.2.2 Design Information Products (D) |
Application Screens, Reports |
Software Developers |
Application Architects |
Data Analysts, DBAs |
3.2.3 Design Data Access Services (D) |
Data Access Service Design Specifications |
Software Developers, DBAs |
Application Architects, Data Architects |
Data Analysts, DBAs |
3.2.4 Design Data Integration Services (D) |
Source-to-Target Maps, ETL Design Specs, Conversion Designs |
Data Integration Specialists, DBAs, Data Analysts |
DBAs, Data Architects, Application Architects |
Data Analysts, Data Stewards, DBAs |
3.3.1 Develop Data Modeling and Database Design Standards (P) |
Data Modeling Standards Documents, Database Design Standards Documents |
Data Architects, Data Analysts, Data Modelers, DBAs |
DM Executive, Data Governance Council |
Data Stewards, Application Architects, Software Developers |
3.3.2 Review Data Model and Database Design Quality (C) |
Design Review Findings |
Data Architects, Data Analysts, Data Modelers, DBAs |
DM Executive, Project Manager |
Application Architects, Software Developers |
3.3.3 Manage Data Model Versioning and Integration (C) |
Model Management Libraries and Contents |
Data Model Administrators, Data Modelers |
Data Architects, DM Executive |
Data Analysts, DBAs |
3.4.1 Implement Development and Test Database Changes (D) |
Dev and Test DB Environments, Database Tables, Other DB Objects |
DBAs |
DM Executive |
Data Architects, Data Analysts, Software Developers |
3.4.2 Create and Maintain Test Data (D) |
Test Databases, Test Data |
DBAs, Data Analysts, Software Developers, Test Analysts |
Data Architects, Application Architects, Data Stewards |
Data Stewards, Software Developers, Data Analysts |
3.4.3 Migrate and Convert Data (D) |
Migrated and Converted Data |
DBAs, Software Developers |
Data Stewards, Data Architects |
Data Analysts |
3.4.4 Build and Test Information Products (D) |
Information Products: Screens, Reports |
Software Developers |
Data Stewards, Application Architects, Data Architects |
DBAs, Data Analysts |
3.4.5 Build and Test Data Access Services (D) |
Data Access Services (interfaces) |
Software Developers |
Data Architects, Application Architects |
DBAs |
3.4.6 Build and Test Data Integration Services (D) |
Data Integration Services (ETL, etc.) |
Data Integration Specialists |
Data Stewards, Data Architects |
DBAs, Data Analysts |
3.4.7 Validate Information Requirements (D) |
Validated Requirements, User Acceptance Signoff |
Data Stewards, Testing Specialists |
Data Stewards |
Data Analysts, Data Architects, DBAs |
3.4.8 Prepare for Data Deployment (D) |
User Training, User Documentation |
Data Stewards, Business SMEs, Training Specialists, Data Analysts |
Data Stewards, Data Architects |
Data Stewards, Data Architects, DBAs |