Architectural Principles

Contents 1 PPDM 3.8 Architectural Principles 1.1 Architectural Principles Overview 1.2 Architectural Principles Change Summary 1.3 Architectural Principles PPDM DDL Components 1.4 Architectural Principles Naming and Design Conventions 1.5 Architectural Principles Constraints in PPDM 1.6 Architectural Principles Design Issues 1.7 Architectural Principles Reference Tables 1.8 Architectural Principles Domains 1.9 Architectural Principles Units of Measure 1.10 Architectural Principles Coordinates 1.11 Architectural Principles Extensibility and Subsetting 1.12 Architectural Principles Meta Tables and Meta Data 1.13 Architectural Principles Discussion 1.14 Architectural Principles Target Deliverables 1.15 Additional Architectural Guidelines and Conventions

PPDM 3.8 Architectural Principles

Architectural Principles Overview

Architectural Principles Change Summary

Architectural Principles PPDM DDL Components

Architectural Principles Naming and Design Conventions

Architectural Principles Objectives

Architectural Principles Tables

Architectural Principles Columns

Architectural Principles Constraints in PPDM

Architectural Principles Primary Key Constraints

Architectural Principles Foreign Key Constraints

Architectural Principles Check Constraints

Architectural Principles Indexes

Architectural Principles Arcs

Architectural Principles Recursive Relationships

Architectural Principles Naming Conventions

Architectural Principles Design Issues

Architectural Principles NULL Data

Architectural Principles Dates

Architectural Principles Versioning

Architectural Principles Vertical Tables

Architectural Principles Sequence Control

Architectural Principles Economics and Financial

Architectural Principles Column Precision

Architectural Principles Column Field Type

Architectural Principles Standardized Columns

Architectural Principles SQL View Definitions

Architectural Principles Other SQL Definitions

Architectural Principles Super / Sub Types

Architectural Principles Reference Tables

Architectural Principles Domains

Architectural Principles Units of Measure

Architectural Principles Coordinates

Architectural Principles Extensibility and Subsetting

Architectural Principles Meta Tables and Meta Data

Architectural Principles Discussion

Architectural Principles Target Deliverables

Additional Architectural Guidelines and Conventions