Application Development Framework

Business Vocabulary Requirements

Conceptual Data Analysis

Logical Data Model Design

Database Specification

Database Implementation

Contact Us

 

 

Logical Data Model Design

 

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

 

Copyright 2024 The Data Organization