O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Data Modeling

Video Description

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.

Table of Contents

  1. Welcome
    1. Welcome 00:02:27
    2. Prerequisites for this Course 00:01:23
    3. About this Course 00:02:58
    4. Where to Find Documentation 00:01:30
    5. Samples and Example Data Models Part pt. 1 00:03:04
    6. Samples and Example Data Models Part pt. 2 00:02:22
    7. A Relational Database Modeling Tool 00:04:25
    8. ERWin: Changing Physical Structure 00:02:29
    9. ERWin: Generating Scripts 00:01:01
  2. The History of Data Modeling
    1. What is a Data Model? 00:02:28
    2. Types of Data Models 00:02:32
    3. The Evolution of Data Modeling 00:01:39
    4. File Systems 00:00:54
    5. Hierarchical Databases 00:01:33
    6. Network Databases 00:01:04
    7. Relational Databases 00:02:46
    8. Object Databases 00:01:55
    9. Object-Relational Databases 00:01:37
    10. The History of the Relational Database 00:04:15
  3. Tools for Data Modeling
    1. Entity Relationship Diagrams 00:03:39
    2. Using ERWin Part pt. 1 00:03:19
    3. Using ERWin Part pt. 2 00:01:27
    4. Using ERWin Part pt. 3 00:02:19
    5. Modeling in Microsoft Access 00:05:23
    6. The Parts of an Object Data Model 00:05:18
    7. Basic UML for Object Databases 00:02:19
    8. Building Class Structures 00:04:12
    9. Other UML Diagrams 00:04:15
  4. Introducing Data Modeling
    1. The Relational Data Model 00:03:08
    2. The Object Data Model 00:03:03
    3. The Object-Relational Data Model 00:02:15
    4. Data Warehouse Data Modeling 00:04:17
    5. Client-Server Versus OLTP Databases 00:02:23
    6. Available Database Engines 00:02:43
  5. Relational Data Modeling
    1. What is Normalization? 00:01:24
    2. Normalization Made Simple 00:01:54
    3. Relational Terms and Jargon 00:05:47
    4. 1st Normal Form 00:00:28
    5. Demonstrating 1st Normal Form 00:04:23
    6. 2nd Normal Form 00:01:24
    7. Demonstrating 2nd Normal Form 00:03:19
    8. 3rd Normal Form 00:01:43
    9. Demonstrating 3rd Normal Form 00:04:32
    10. 4th and 5th Normal Forms 00:06:01
    11. Primary/Foreign Keys/Referential Integrity 00:03:19
    12. The Traditional Relational Database Model 00:04:20
    13. Surrogate Keys and the Relational Model 00:05:38
    14. Denormalization pt. 1 00:02:26
    15. Denormalization pt. 2 00:03:53
  6. Object Data Modeling
    1. The Object-Relational Database Model 00:05:13
    2. Relational Versus Object Models 00:02:16
    3. What is the Object Data Model? 00:00:38
    4. What is a Class? 00:02:35
    5. Again - a Class and an Object 00:05:26
    6. What is an Attribute? 00:02:23
    7. What is a Method? 00:03:17
    8. The Simplicity of Objects 00:05:10
    9. What is Inheritance? 00:02:23
    10. What is Multiple Inheritance? 00:02:45
    11. Some Specifics of the Object Data Model 00:05:33
  7. Data Warehouse Data Modeling
    1. The Origin of Data Warehouses 00:04:50
    2. Why the Relational Model Fails 00:02:35
    3. The Dimensional Data Model Part pt. 1 00:04:30
    4. The Dimensional Data Model Part pt. 2 00:02:05
    5. Star Schemas and Snowflake Schemas 00:02:32
  8. Getting Data from a Database
    1. What is Structured Query Language (SQL)? 00:03:00
    2. The Roots of SQL 00:01:15
    3. Queries 00:01:44
    4. Changing Data 00:01:57
    5. Changing Metadata 00:02:06
    6. What is ODQL? 00:02:12
  9. Tuning a Relational Data Model
    1. Normalization Versus Denormalizatrion 00:05:05
    2. Referential Integrity Part pt. 1 00:04:44
    3. Referential Integrity Part pt. 2 00:05:00
    4. Alternate Keys 00:05:04
    5. What is an Index? 00:01:57
    6. Indexing Considerations 00:01:07
    7. Too Many Indexes 00:04:20
    8. Composite Indexing 00:02:53
    9. Which Columns to Index? 00:02:17
    10. Index Types 00:04:11
    11. Match Indexes to SQL Code 00:04:52
    12. Types of Indexing in Detail pt. 1 00:03:28
    13. Types of Indexing in Detail pt. 2 00:04:20
    14. Where Index Types Apply 00:01:33
    15. Undoing Normalization 00:01:08
    16. What to Look For? 00:05:35
    17. Undoing Normal Forms 00:06:18
    18. Some Good and Bad Tricks Part pt. 1 00:03:35
    19. Some Good and Bad Tricks Part pt. 2 00:04:06
  10. Tuning a Data Warehouse Data Model
    1. Denormalization 00:05:04
    2. Star Versus Snowflake Schemas 00:01:32
    3. Dimensional Hierarchies 00:01:33
    4. Specialized Data Warehouse Toys 00:03:10
  11. Other Tricks
    1. RAID Arrays and Striping 00:02:30
    2. Standby Databases 00:02:48
    3. Replication 00:01:47
    4. Clustering 00:01:00
  12. Wrapping it Up
    1. Some Available Database Engines 00:04:53
    2. The Future: Relational or Object? 00:04:19
    3. What You Have Learned 00:00:48
  13. Credits
    1. About the Author 00:02:20