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
Information Life Cycle and Records Management
- Electronic Records Management in Database Management Systems
- 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
- Department of Aging (PDA) Records 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