logo for information-management-architect.com
Home
Strategy
Framework
Business Case Analysis
Project Planning
Requirements Analysis
Architecture & Design
Build Phase
Quality Assurance
Transition to Production
Management Information
Business Intelligence
Data Warehouse
Tools
Jobs
leftimage for information-management-architect.com

What is Data Governance

Need to establish data governance and want a quick overview of what is required to implement a successful information management discipline?

Data management is a sub-set of information managementData Governance that governs organization and control of the structure and design, storage, movement, security and quality of information.

What comprises a data governance?

  • Structure and design focuses primarily on data modeling and artifacts that flow from data modeling activities.  The goal is to provide direction on modeling practices, the use of conceptual, logical, and physical models, naming standards, and modeling tools;
  • Data storage focuses on the management of persistent data stores throughout the organization. It covers such topics as database selection guidelines, backup & recovery procedures, data retention/archiving policies, and disaster recovery planning.
  • Data movement focuses on the movement of data between systems.  In this context, “systems” include external data sources, operational systems, and analytic data stores.  
  • Data movement encompasses the extract-transform-load (ETL) facilities used for bulk data movement.  It also includes mechanisms to support continuous movement of discrete records, rows, or messages between systems.
  • Metadata is a key enabler for realizing the goals of information management. It has touch points throughout the vertical disciplines e.g.
  • The structure and design discipline will populate the metadata repository with entity and attribute definitions
  • The technical metadata will include information about where (in which databases) specific tables are stored
  • Analytic data access tools (OLAP tools) will make use of the business metadata to provide entity and attribute definitions to the end user; and
  • Data movement processes will access business metadata to retrieve validation and transformation rules to be applied during the ETL processes.
  • Data Quality is not a stand-alone discipline. It is a result of adherence to a sound data management methodology. Data quality is concerned with: 
    • Data validations in operational (OLTP) systems;
    • Validation of purchased data sets;
    • Quality checks on data extracts;
    • Audit controls to verify integrity of bulk data movements;
    • Use of common field validations (both technical and business) across systems including the ETL environment.
  • Data management practice is a roadmap of tasks, artifacts, standards, guidelines, and best practices. It provides a structured framework for delivery of data-related projects.
Data governance checklist

The following topics should be addressed as part of data governance:
Data model standards and best practices should be established for structure and design.
They should include naming standards and best practices for:
  • Conceptual data model;
  • Enterprise data model;
  • Logical data model;
  • Entity relationship diagrams;
  • Physical data model; and
  • Class list names.
A database management policy should be available to address data storage.
The database management policy should specify how database operations will function within the organization and should also address:
  • The frequency of frequently data back-up;
  • Use of off-site storage; and
  • Off-site storage location.
Data warehouse best practices should be established.
Data movement best practices should be documented and communicated to project teams.
Master data management best practices should be documented.
A data security policy should address electronic and physical security concerns?.
The information security policy should specify how data and information will be protected from authorized access.
A meta data management policy should specify internal requirements for gathering, maintaining and providing metadata.
A data quality standards document should be available.
IT best practices should include data management best practices.
A change management strategy should be defined.
Data governance should be included in corporate governance.
Corporate information should be considered a data asset.
A data management plan should be established.
Data governance should address data management strategy and data warehouse strategy.
Enterprise architecture framework and enterprise architecture strategy should be defined.
Information governance should specify an enterprise information management governance framework.
Information management architecture should be defined.
Information governance should address project management fundamentals
An information management steering committee should be established comprised of IT and business data guardians.
Information governance should be included in the enterprise strategic planning process.
Summary...

Information management is a discipline that governs accountability for the structure and design, storage, movement, security, quality, delivery and usage of information required for management and business intelligence purposes.

The data management strategy is comprised of disciplines involved with specific segments of data management and these segments are governed by standards and best practices.