Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

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

    Data Modeling

    Subscriber Reviews • Browse Similar Topics

    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