Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Overview

Data modeling is the act of exploring data-oriented structures. When building a database, data modeling implies the creation of a model for data within that database. Data models can be used for a variety of purposes, from high-level conceptual models to physical data models. VTC author, Gavin Powell, covers topics such as normalization and denormalization for relational data modeling, fact dimensional structures for data warehouse data modeling, and basic object data modeling for object databases. Powell also examines useful web sites and vendor software, such as Oracle database, for finding data modeling information. To being learning today, simply click on one of the Data Modeling lessons.

Subscriber Reviews

Average Rating: 4.666666666666667 out of 5 rating Based on 3 Ratings

No Subscribers have provided a review for this video.

Table of Contents

Chapter/Selection

Time

Welcome

Welcome

Preview

00:02:27

Prerequisites for this Course

Preview

00:01:23

About this Course

Preview

00:02:58

Where to Find Documentation

Preview

00:01:30

Samples and Example Data Models Part pt. 1

Preview

00:03:04

Samples and Example Data Models Part pt. 2

Preview

00:02:22

A Relational Database Modeling Tool

Preview

00:04:25

ERWin: Changing Physical Structure

Preview

00:02:29

ERWin: Generating Scripts

Preview

00:01:01

The History of Data Modeling

What is a Data Model?

Preview

00:02:28

Types of Data Models

Preview

00:02:32

The Evolution of Data Modeling

Preview

00:01:39

File Systems

Preview

00:00:54

Hierarchical Databases

Preview

00:01:33

Network Databases

Preview

00:01:04

Relational Databases

Preview

00:02:46

Object Databases

Preview

00:01:55

Object-Relational Databases

Preview

00:01:37

The History of the Relational Database

Preview

00:04:15

Tools for Data Modeling

Entity Relationship Diagrams

Preview

00:03:39

Using ERWin Part pt. 1

Preview

00:03:19

Using ERWin Part pt. 2

Preview

00:01:27

Using ERWin Part pt. 3

Preview

00:02:19

Modeling in Microsoft Access

Preview

00:05:23

The Parts of an Object Data Model

Preview

00:05:18

Basic UML for Object Databases

Preview

00:02:19

Building Class Structures

Preview

00:04:12

Other UML Diagrams

Preview

00:04:15

Introducing Data Modeling

The Relational Data Model

Preview

00:03:08

The Object Data Model

Preview

00:03:03

The Object-Relational Data Model

Preview

00:02:15

Data Warehouse Data Modeling

Preview

00:04:17

Client-Server Versus OLTP Databases

Preview

00:02:23

Available Database Engines

Preview

00:02:43

Relational Data Modeling

What is Normalization?

Preview

00:01:24

Normalization Made Simple

Preview

00:01:54

Relational Terms and Jargon

Preview

00:05:47

1st Normal Form

Preview

00:00:28

Demonstrating 1st Normal Form

Preview

00:04:23

2nd Normal Form

Preview

00:01:24

Demonstrating 2nd Normal Form

Preview

00:03:19

3rd Normal Form

Preview

00:01:43

Demonstrating 3rd Normal Form

Preview

00:04:32

4th and 5th Normal Forms

Preview

00:06:01

Primary/Foreign Keys/Referential Integrity

Preview

00:03:19

The Traditional Relational Database Model

Preview

00:04:20

Surrogate Keys and the Relational Model

Preview

00:05:38

Denormalization pt. 1

Preview

00:02:26

Denormalization pt. 2

Preview

00:03:53

Object Data Modeling

The Object-Relational Database Model

Preview

00:05:13

Relational Versus Object Models

Preview

00:02:16

What is the Object Data Model?

Preview

00:00:38

What is a Class?

Preview

00:02:35

Again - a Class and an Object

Preview

00:05:26

What is an Attribute?

Preview

00:02:23

What is a Method?

Preview

00:03:17

The Simplicity of Objects

Preview

00:05:10

What is Inheritance?

Preview

00:02:23

What is Multiple Inheritance?

Preview

00:02:45

Some Specifics of the Object Data Model

Preview

00:05:33

Data Warehouse Data Modeling

The Origin of Data Warehouses

Preview

00:04:50

Why the Relational Model Fails

Preview

00:02:35

The Dimensional Data Model Part pt. 1

Preview

00:04:30

The Dimensional Data Model Part pt. 2

Preview

00:02:05

Star Schemas and Snowflake Schemas

Preview

00:02:32

Getting Data from a Database

What is Structured Query Language (SQL)?

Preview

00:03:00

The Roots of SQL

Preview

00:01:15

Queries

Preview

00:01:44

Changing Data

Preview

00:01:57

Changing Metadata

Preview

00:02:06

What is ODQL?

Preview

00:02:12

Tuning a Relational Data Model

Normalization Versus Denormalizatrion

Preview

00:05:05

Referential Integrity Part pt. 1

Preview

00:04:44

Referential Integrity Part pt. 2

Preview

00:05:00

Alternate Keys

Preview

00:05:04

What is an Index?

Preview

00:01:57

Indexing Considerations

Preview

00:01:07

Too Many Indexes

Preview

00:04:20

Composite Indexing

Preview

00:02:53

Which Columns to Index?

Preview

00:02:17

Index Types

Preview

00:04:11

Match Indexes to SQL Code

Preview

00:04:52

Types of Indexing in Detail pt. 1

Preview

00:03:28

Types of Indexing in Detail pt. 2

Preview

00:04:20

Where Index Types Apply

Preview

00:01:33

Undoing Normalization

Preview

00:01:08

What to Look For?

Preview

00:05:35

Undoing Normal Forms

Preview

00:06:18

Some Good and Bad Tricks Part pt. 1

Preview

00:03:35

Some Good and Bad Tricks Part pt. 2

Preview

00:04:06

Tuning a Data Warehouse Data Model

Denormalization

Preview

00:05:04

Star Versus Snowflake Schemas

Preview

00:01:32

Dimensional Hierarchies

Preview

00:01:33

Specialized Data Warehouse Toys

Preview

00:03:10

Other Tricks

RAID Arrays and Striping

Preview

00:02:30

Standby Databases

Preview

00:02:48

Replication

Preview

00:01:47

Clustering

Preview

00:01:00

Wrapping it Up

Some Available Database Engines

Preview

00:04:53

The Future: Relational or Object?

Preview

00:04:19

What You Have Learned

Preview

00:00:48

Credits

About the Author

Preview

00:02:20