Holistic Data Management

Holistic Data Management (HDM) framework is AHISDATA indigenous standard for implementing software implementations within an organization network. This framework extends the existing data management solutions such as data quality, data governance, data integration, data processing, Master Data Management and data validation solutions.

The HDM framework specifies that:
*All data objects must exist as a child data object or a parent data object.
*Only one unique parent data object must exist within a data network scope (DNS).
*All child data objects must have a Data Mapping link defined within a data network scope.
*A data object relationship must exist at least in one of the following four data management modules:Data Mapping, Data Validation, Data Integration,Data Processing

Exploring the HDM Framework

The following entities are specified in the HDM framework.

*Data Network Scope (DNS)The data network scope (DNS) is the logical boundary that a software application database system of record (SOR) exists within an enterprise network. There can be multiple DNS within an enterprise network.

*Data Network Domain (DND)The data network domain (DND) is the logical boundary representing a collection of multiple data network scope (DNS). There can be multiple DND within an enterprise network.

*System of Record (SOR)A system of record applies to the master or principal database system that a parent data objects resides on.There can only be one SOR within a data network scope.

*Parent Data Object (PDO)A parent data object (PDO) is the system of record schema object name. Only one unique parent data object must exist within a data network scope.

*Child Data Object (CDO)A child data object (CDO) is a schema object name that derives its data from one or more parent data object(s).

*Data Mapping Link (DML)A Data Mapping link (DML) is the data requirement specification applied to the relationship between multiple database schema objects where one data object derives its data from one or more data objects. DML is only applicable for a Data Mapping data management module.

*Data Object Relationship (DOR)The data object relationship (DOR) is the data requirement, business rule, program function that applies to one or multiple data objects. DOR can be applied on Data Mapping links for each data management modules. Only one DOR can exist on a DML within a data management module.

*Data Management Modules (DMM)Data Management modules are the common user interface (UI) programs that defines and manage the data object relationship(s) within a data network scope.

There are four data management modules:

Data Mapping – This is the base data management user interface module. The Data Mapping module provide the functionalities for managing Data Mapping links and data object relationships for all database schemas within a data network scope. A data network scope must have at least one Data Mapping design defined.

Data Validation – This user interface module provides the functionalities for defining and managing validation events on data object relationships. Validation events include auditing, reporting, scheduler, logger, triggers and DNS Health Check. Data Validation events requires a Data Mapping design defined within a data network scope.

Data Integration - This user interface module provides the functionalities for defining and managing interface configurations on data object relationships. The interface configurations include scheduler, transmission mode, listener, interface API and reporting. The interface APIs would allow third-party systems to transfer data using the data object relationship defined within a data network scope. Data Integration interface configuration requires a Data Mapping design defined within a data network scope.

Data Processing - This user interface module provides the functionalities for defining and managing interface configurations and batch runtime engines on data object relationships. The interface configurations include scheduler, transmission mode, multi-batch transmission, user-defined DOR API and reporting. Data Processing interface configuration requires a Data Mapping design defined within a data network scope.

Implementing the HDM Framework

The HDM framework presents a standard for software implementations within an organization. The objective is to shed visibility, increase efficiency and centralized management of all other software implementations within an organization.

The HDM framework should be implemented as a major organization project that is supervised by the project management office. This would require a project charter developed and a project manager assigned for managing the implementation process. There are several phases involve in implementing the HDM framework:

*Choose a Data Management Module (DMM) – This exercise requires the acquisition of a data management module software application to be used for implementing the rest of the HDM framework. AHISDATA iNTEGRITY software is an integrated solution that provides DMM functionalities.
*Scrub (Inventory of Existing Applications and Data sources) – This exercise indentifies all applications within an organization and the data sources that they are connected to.
*Formation (Applications and Data Schema Relation) - This exercise is to align all applications in relation to the data schemas within the data sources. The applications are grouped in the order of the data schemas that they access.
*First Axe (Applications eligible for decommission) - This exercise is to identify all applications that are rogue, obsolete and completely redundant. These applications are eligible for removal.
*Second Axe (Application eligible for consolidation) – This exercise is to identify all applications that have some functional similarities and some uniqueness in the data requirement. These applications are eligible for consolidation. The functionalities that are similar are left intact on one application and turned off or disabled on the other(s).
*Define Data Network Domain (DND) – This exercise is to define the data network domain for all the approved applications within the enterprise network.
*Define Data Network Scope (DNS) – This exercise is to define the data network scope(s) required for each DND.
*Define System of Records (SOR) – This exercise is to define the SOR for each DNS.
*Define Parent Data Objects (PDO) – This exercise is to define all PDOs in each DNS.
*Define Child Data Objects (CDO) – This exercise is to define all CDOs in each DNS.
*Define Data Mapping links (DML) – This exercise is to define all Data Mapping links and object relationship in all DNS.
*Define Data Object Relationships (DOR) – This exercise is to define the DOR requirement for each Data Management Module implemented.

ee also

*Reference Data
*Master Data
*Customer Data Integration
*Product Information Management
*Identity resolution

External links

* [http://www.ahisdata.com/eHDMS/AHISDATA_HDM_WhitePaper_v35.pdf AHISDATA HDM WhitePaper]
* [http://msdn2.microsoft.com/en-us/library/bb190163.aspx#mdm04_topic4 The What, Why, and How of Master Data Management]