​Data Domain

The Data Domain assists in the development of consistent, efficient, and easily maintained database environments. The standards and policies serve to identify the design steps and constructs that surround database objects to ensure singularity, consistency, and flexibility within DHS-supported systems.

The standards and policies include, but are not limited to, logical and physical data modeling, naming conventions, database design guidelines that are independent of a particular relational database management system. Additionally, the document includes database-specific guidelines for Oracle, RDMS, and SQL Server regarding database architectures.
This section consists of standards, forms, and templates in the following areas:

• Data Modeling — An inventory of "business" data and the relationships between this data. The logical data model is developed from the analysis of business requirements in formulating a high-level view of data and their relationships using graphical symbols.

Policy Standards Guidelines Forms and Procedures

• Commonwealth Information Technology Policy: ITP-INF003 Data Modeling Standards establishes enterprise-wide standards for data modeling and supporting software, and promote effective use for application development.
• Class Words
• Data Modeling
  
• Data Dictionary (available on intranet) 
• Doing Business with Database 
• Instructions for Completing a Database Request
  
• Data Administration Submissions Best Practices
  
• Enterprise Mainframe Standards
• DMS RDMS Coding Standards 
• DMS 2200 Physical Implementation 
• RDMS Physical Implementation 
• Information Life Cycle and Records Management 
• Agency Records Retention and Disposition Schedule 
• Department of Aging (PDA) Records Retention and Disposition Schedule 
• Department of Drug and Alcohol Program (DDAP) Records Retention and Disposition Schedule 
• Department of Human Services (DHS) Records Retention and Disposition Schedule 
• Department of Health (DOH) Retention and Disposition Schedule 
• Department of Military and Veterans Affairs (DMVA) Retention and Disposition Schedule 

• Commonwealth Records Management 
• Commonwealth The Life Cycle of Records: General Policy Statement ITP-INFRM001 
• Commonwealth of PA General Records Retention and Disposition Schedule M210_9 
• Electronic Records Management in Database Management Systems
  
• Information Life Cycle Management  
  
• Enterprise Oracle Standards 
• User Creation
• Oracle Tools 
• Oracle PL/SQL Naming and Coding 
• Enterprise Microsoft SQL Coding 
• MS SQL Server 2012 / 2014 Naming and Coding Standard 

Standards 

• Commonwealth Database Management Systems ITP-INF001 
• Database Backups 

Guidelines 

• Oracle Database 11g Baseline Products
  
• Oracle PL/SQL Coding