Explain the strengths of each and the differences among the 12 types of data models. Create business terms, logical, and physical data models across relational, dimensional, document, and graph approaches. Apply practical techniques such as normalization, dimensional grain and meter design, JSON nested arrays, graph patterns (RDF and Property), denormalization, indexing, views, and partitioning.
Data Modeling Scheme
您将获得的技能
要了解的详细信息
可分享的证书
添加到您的领英档案
最近已更新！
May 2026
作业
13 项作业
授课语言：英语（English）
了解顶级公司的员工如何掌握热门技能
该课程共有13个模块
Become adept at identifying the characteristics used to distinguish each of the 12 different types of data models. There are three levels of detail (align, refine, and design) and four main modeling mindsets (relational, dimensional, document, and graph), leading to 12 different types of models we can create. Align is where we create the business terms model (conceptual data model) to establish a common business vocabulary. Refine is where we create the logical data model to precisely capture the business requirements. Design is where we create the physical data model to document a technology-optimized version of the business requirements. Relational helps us capture business rules, primarily for operational applications (OLTP) and large integration hubs such as data warehouses. Dimensional helps us capture business questions, primarily for analytical applications (OLAP). Document helps us capture nested structures, used for storing and retrieving highly related content (like documents). Graph helps us capture patterns in the data, used for understanding and predicting connections. We'll cover the 12 types at a high level and provide an example of each.
涵盖的内容
4个视频1个作业
4个视频•总计14分钟
- About Data Modeling Schemes•3分钟
- Business Terms Model (BTM) Overview•5分钟
- Logical Data Model (LDM) Overview•4分钟
- Physical Data Model (PDM) Overview•2分钟
1个作业•总计15分钟
- Data Modeling Scheme•15分钟
Learn all about the relational BTM and build one too! Explore several examples of the relational BTM to fully experience the characteristics of this type of model. Next, journey through the steps in building a relational BTM. Finally, design a relational BTM.
涵盖的内容
12个视频1篇阅读材料1个作业
12个视频•总计46分钟
- Why a Business Terms Model and not a Conceptual Data Model?•1分钟
- About the Relational BTM•2分钟
- Relational BTM Example 1 - University•6分钟
- Relational BTM Example 2 - ERP Solution (Vendor Product)•4分钟
- Overview on How to Build a BTM•3分钟
- Step 1 of 5 on Building a Relational BTM: Ask the Six Strategic Questions•5分钟
- Step 2 of 5 on Building a Relational BTM: Identify and Define the Terms•3分钟
- Step 3 of 5 on Building a Relational BTM: Capture the Relationships•3分钟
- Step 4 of 5 on Building a Relational BTM: Determine the Most Useful Form•4分钟
- Step 5 of 5 on Building a Relational BTM: Review and Confirm•0分钟
- A Data Modeling Joke•0分钟
- Technics Publications Exercise•15分钟
1篇阅读材料•总计10分钟
- About the Relational BTM•10分钟
1个作业•总计15分钟
- Relational BTM•15分钟
Learn all about the dimensional BTM and build one too! Explore several examples of the dimensional BTM to fully experience the characteristics of this type of model. Next, journey through the steps in building a dimensional BTM. Finally, design a dimensional BTM.
涵盖的内容
10个视频1篇阅读材料1个作业
10个视频•总计34分钟
- About the Dimensional BTM•2分钟
- Dimensional BTM Example•2分钟
- Overview on How to Build a BTM•3分钟
- Step 1 of 5 on Building a Dimensional BTM: Ask the Six Strategic Questions•6分钟
- Step 2 of 5 on Building a Dimensional BTM: Identify and Define the Terms•1分钟
- Step 3 of 5 on Building a Dimensional BTM: Capture the Relationships•7分钟
- Step 4 of 5 on Building a Dimensional BTM: Determine the Most Useful Form•1分钟
- Step 5 of 5 on Building a Dimensional BTM: Review and Confirm•0分钟
- A Data Modeling Joke•0分钟
- Cozy Cactus Bed & Breakfast Exercise•12分钟
1篇阅读材料•总计10分钟
- About the Dimensional BTM•10分钟
1个作业•总计15分钟
- Dimensional BTM•15分钟
Learn all about the document BTM and build one too! Explore several examples of the document BTM to fully experience the characteristics of this type of model. Next, journey through the steps in building a document BTM. Finally, design a document BTM.
涵盖的内容
9个视频1篇阅读材料1个作业
9个视频•总计28分钟
- About the Document BTM•2分钟
- Document BTM Example•1分钟
- Overview on How to Build a BTM•3分钟
- Step 1 of 5 on Building a Document BTM: Ask the Six Strategic Questions•5分钟
- Step 2 of 5 on Building a Document BTM: Identify and Define the Terms•1分钟
- Step 3 of 5 on Building a Document BTM: Capture the Relationships•1分钟
- Step 4 of 5 on Building a Document BTM: Determine the Most Useful Form•0分钟
- Step 5 of 5 on Building a Document BTM: Review and Confirm•0分钟
- Technics Publications Exercise•13分钟
1篇阅读材料•总计10分钟
- Value of the Business Terms Model•10分钟
1个作业•总计15分钟
- Document BTM•15分钟
Learn all about the graph BTM and build one too! Explore several examples of the graph BTM to fully experience the characteristics of this type of model. Next, journey through the steps in building a graph BTM. Finally, design a graph BTM.
涵盖的内容
11个视频1篇阅读材料1个作业
11个视频•总计41分钟
- About the Graph BTM•2分钟
- Graph BTM Example•1分钟
- Graph Components•7分钟
- How does a Label Property Graph (LPG) Compare with the Resource Development Framework (RDF)?•8分钟
- Overview on How to Build a BTM•3分钟
- Step 1 of 5 on Building a Graph BTM: Ask the Six Strategic Questions•8分钟
- Step 2 of 5 on Building a Graph BTM: Identify and Define the Terms•2分钟
- Step 3 of 5 on Building a Graph BTM: Capture the Relationships•1分钟
- Step 4 of 5 on Building a Graph BTM: Determine the Most Useful Form•1分钟
- Step 5 of 5 on Building a Graph BTM: Review and Confirm•0分钟
- Cozy Cactus Bed & Breakfast Exercise•9分钟
1篇阅读材料•总计10分钟
- About Graph Databases Like Neo4j•10分钟
1个作业•总计30分钟
- Graph BTM•30分钟
Learn all about the relational LDM and build one too! Explore several examples of the relational LDM to fully experience the characteristics of this type of model. Next, journey through the steps in building a relational LDM. Finally, design a relational LDM. Apply all of the levels of normalization, from First Normal Form (1NF) all the way through Fifth Normal Form (5NF)!
涵盖的内容
14个视频1个作业
14个视频•总计59分钟
- About the Relational LDM•4分钟
- Normalization Mindset•1分钟
- Normalization Overview•10分钟
- My Approach to Normalization: The Normalization Hike•2分钟
- The Normalization Hike Overview•6分钟
- Starting with Chaos•6分钟
- First Normal Form (1NF)•7分钟
- Second Normal Form (2NF)•3分钟
- Third Normal Form (3NF)•1分钟
- Boyce/Codd Normal Form (BCNF)•4分钟
- Fourth (4NF) and Fifth Normal Form (5NF)•4分钟
- Summary of Normalization Rules•1分钟
- A Data Modeling Joke•0分钟
- Technics Publications Exercise•9分钟
1个作业•总计30分钟
- Relational LDM•30分钟
Learn all about the dimensional LDM and build one too! Explore several examples of the dimensional LDM to fully experience the characteristics of this type of model. Next, journey through the steps in building a dimensional LDM. Finally, design a dimensional LDM.Compare and contrast the dimensional modeling components of measure, meter, dimension, and grain. Apply the best practices of dimensional modeling through a series of what-to-do and what-not-to-do guidelines for your modeling in analytics applications.Become competent in incorporating different types of measures and dimensions into your models.
涵盖的内容
13个视频1个作业
13个视频•总计57分钟
- About the Dimensional LDM•3分钟
- Measure, Meter, and Dimension•4分钟
- The Importance of Choosing the Right Grain•3分钟
- Fun with Measures and Grain•4分钟
- Dimensional Models are Built for Navigation•6分钟
- Three Types of Measures: Transaction, Snapshot, and Accumulating•6分钟
- Examples of Each Type of Measure•4分钟
- Do's of Dimensional Modeling•7分钟
- Don'ts of Dimensional Modeling•6分钟
- Additional Dimensional Logical Structures: Conformed Dimension•4分钟
- Additional Dimensional Logical Structures: Factless Facts•1分钟
- Additional Dimensional Logical Structures: Behavioral Dimensional•2分钟
- Cozy Cactus Bed & Breakfast Exercise•7分钟
1个作业•总计30分钟
- Dimensional LDM•30分钟
Learn all about the document LDM and build one too! Explore several examples of the document LDM to fully experience the characteristics of this type of model. Next, journey through the steps in building a document LDM. Finally, design a document LDM.
涵盖的内容
3个视频1篇阅读材料1个作业
3个视频•总计21分钟
- About the Document LDM•2分钟
- Building the Document LDM•6分钟
- Technics Publications Exercise•13分钟
1篇阅读材料•总计10分钟
- The Document Model of MongoDB•10分钟
1个作业•总计15分钟
- Document LDM•15分钟
Learn all about the graph LDM and build one too! Explore several examples of the graph LDM to fully experience the characteristics of this type of model. Next, journey through the steps in building a graph LDM. Finally, design a graph LDM.
涵盖的内容
3个视频1篇阅读材料1个作业
3个视频•总计15分钟
- About the Graph LDM•3分钟
- Building the Graph LDM•7分钟
- Cozy Cactus Bed & Breakfast Exercise•5分钟
1篇阅读材料•总计10分钟
- Nuances of Graph Logical Data Modeling in Neo4j•10分钟
1个作业•总计15分钟
- Graph LDM•15分钟
Learn all about the relational PDM and build one too! Explore several examples of the relational PDM to fully experience the characteristics of this type of model. There are four main techniques used as building blocks in the physical: denormalization, indexing, views, and partitioning. Explain the different ways to denormalize and know the pros and cons of each technique. Contrast the different types of indexes and know the default translations from logical to physical. Define views and know the pros and cons of traditional versus materialized views. Describe horizontal and vertical partitioning, and know when to use each.
涵盖的内容
11个视频1个作业
11个视频•总计52分钟
- About the PDM•6分钟
- Denormalization Overview•5分钟
- Denormalization: Standard and Repeating Attributes•7分钟
- Denormalization: Variation of Repeating Attributes (Nested Arrays)•3分钟
- Denormalization: Summarization•1分钟
- Denormalization: Aggregation•6分钟
- Indexing•6分钟
- Views•6分钟
- Partitioning•5分钟
- A Data Modeling Joke•0分钟
- Technics Publications Exercise•7分钟
1个作业•总计30分钟
- Relational PDM•30分钟
Learn all about the dimensional PDM and build one too! Explore several examples of the dimensional PDM to fully experience the characteristics of this type of model. Next, journey through the steps in building a dimensional PDM. Finally, design a dimensional PDM. Apply several modeling techniques specific to dimensional physical modeling, including the use of junk and degenerate dimensions.
涵盖的内容
9个视频1个作业
9个视频•总计33分钟
- Star Schema•2分钟
- Snowflake•5分钟
- Slowly Changing Dimension Overview•4分钟
- Slowly Changing Dimensions Types 0 and 1•4分钟
- Slowly Changing Dimension Type 2•6分钟
- Slowly Changing Dimension Type 3•3分钟
- Degenerate Dimension•2分钟
- Junk Dimension•3分钟
- Cozy Cactus Bed & Breakfast Exercise•4分钟
1个作业•总计30分钟
- Dimensional PDM•30分钟
Learn all about the document PDM and build one too! Explore several examples of the document PDM to fully experience the characteristics of this type of model. Next, journey through the steps in building a document PDM. Finally, design a document PDM.
涵盖的内容
2个视频1篇阅读材料1个作业
2个视频•总计8分钟
- Building the Document PDM•5分钟
- Technics Publications Exercise•3分钟
1篇阅读材料•总计10分钟
- An Example of a Document Pattern in MongoDB: The Approximation Pattern•10分钟
1个作业•总计15分钟
- Document PDM•15分钟
Learn all about the graph PDM and build one too! Explore several examples of the graph PDM to fully experience the characteristics of this type of model. Next, journey through the steps in building a graph PDM. Finally, design a graph PDM.
涵盖的内容
3个视频1篇阅读材料1个作业
3个视频•总计10分钟
- About the Graph PDM•2分钟
- Building the Graph PDM•5分钟
- Cozy Cactus Bed & Breakfast Exercise•3分钟
1篇阅读材料•总计10分钟
- About Design and Neo4j•10分钟
1个作业•总计15分钟
- Graph PDM•15分钟
位教师
人们为什么选择 Coursera 来帮助自己实现职业发展
Felipe M.
自 2018开始学习的学生
''能够按照自己的速度和节奏学习课程是一次很棒的经历。只要符合自己的时间表和心情，我就可以学习。'
Jennifer J.
自 2020开始学习的学生
''我直接将从课程中学到的概念和技能应用到一个令人兴奋的新工作项目中。'
Larry W.
自 2021开始学习的学生
''如果我的大学不提供我需要的主题课程，Coursera 便是最好的去处之一。'
Chaitanya A.
''学习不仅仅是在工作中做的更好：它远不止于此。Coursera 让我无限制地学习。'
常见问题
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.
更多问题
提供助学金，