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 promotes their effective use for application development. See http://www.oa.pa.gov/policies/documents/itp_inf003.pdf
- Enterprise Mainframe Standards
- Information Life Cycle and Records Management
- Enterprise Oracle Standards
- Enterprise Microsoft SQL Coding