Logical Data Modeling

The third step in the DDLC is creating a logical (semantic) data model that is the enterprise logical data model (ELDM) and the foundation of the Enterprise Data Warehouse. Subsets of the ELDM are the basis of the databases used in the data capture (OLTP) and data reporting (OLAP) applications.

The ELDM lists all of the logical tables in the database and describes the table attributes as logical data types. Depending on the CASE tool used to create the ELDM, you can output a DDL script that is the beginning of the physical database specification.

1	Data Model Design Patterns
1.1	Database Definition
1.2	Common Data Modeling Mistakes
1.3	Data Attribute Patterns
1.4	Logical Data Type Definitions
1.5	Organizing Master Data
1.6	Hierarchy Data Model Deliverables
2	DDLC Background
2.1	Data Model Design Requirements
2.2	Data Model Requirements Diagram
3	DDLC Process
3.1	Data Modeling Process
4	DDLC Deliverables
4.1	Data Model Document
4.2	Data Model Diagram
4.3	Data Model Dictionary
4.4	Data Model DDL Script
4.5	Reference Table List
4.6	Reference Table DDL Script
5	SDLC Deliverables
5.1	Application Architecture Document
6	DDLC/SDLC Interface Deliverables
6.1	Business Object to Logical Table Mapping