Data Model

Enterprise Data Inventory

In order to accurately understand what data the Commonwealth of Kentucky possesses, an enterprise inventory will be completed on all major IT systems. Performing this organizational assessment will enable us to take a holistic view of current data practices and determine the current state of our enterprise capabilities. This inventory of data elements will be used as a baseline metric. It will show potential data integration points within disparate systems, and where systems can possibly be combined, with minimal effort and cost, to eliminate redundancy and support costs. This inventory will also support other component parts of KEDA including: Meta data, Data Quality and Date Warehousing/Business Intelligence.

Enterprise Data Model

The development of an Enterprise Data Model has already begun with the creation of the Enterprise Common Data Framework (ECDF). This framework currently includes a data model for information related to individuals, organizations, and contact information (address, phone, email, etc.). Developed in cooperation with other Cabinets, this model will be the standard for any executive branch state agency database development efforts for Party and Contact information. Updates to the model will be monitored via the approved Governance methodology.

As additional business areas are reviewed and assessed from the Enterprise Inventory, they may be considered as potential enterprise common data standards. If approved, logical data models with standardized definitions and attributes will be created, reviewed and included within the ECDF.

Implementation of the ECDF database designs throughout state agencies during new system development will allow a mechanism by which to cross reference underlying relational data elements. Major IT system Request For Proposals (RFPs) will include standard verbiage requiring vendors to cross-reference their data elements to the common framework models as part of the project deliverables for any Commercial Off the Shelf (COTS) or custom developed software solutions.

Data Modeling

Within COT’s Office of Application Development (OAD), Logical and Physical data models are being created for all new projects undertaken. The Data Services Branch (DSB) is working diligently to reverse engineer data models and assimilate definitions for every system OAD supports, into the ERwin® data modeling tool. The DSB utilizes a model driven deployment process that documents change requests, versions model changes and tracks deployment of model versions to the various database environments (Dev, Test, Production etc.).

The Data Services Branch will be available to provide data modeling services or training in the use of the modeling tool to any agency on request. Agencies will be encouraged to develop internal data modeler resources as well, and begin building their own repository of data model versions. COT’s OAD Data Modeling Process Definition Document / Process Model document can be found at:

Any significant development effort in the Commonwealth should include the creation of a logical data model during the project‘s Requirements Phase. This assures that the data structure is viewed as an enterprise asset that meets approved standards, rather than as a mere grouping of individual system fields.

This page was last modified 3/23/2010 12:05 PM