信息检索与管理

默认只展示每周独有的知识重点；节奏、考核、Tutorial 和避坑信息按需展开。

1. 1

   Course Overview and Intro to DBMS Introduction to database management, including traditional file-based systems, the dat

   ### 📖 核心知识点：Course Overview and Intro to DBMS Introduction to database management, including traditional file-based systems, the database management system and fundamental database concepts. Readings/Ref: CB (Ch. 1, 2) 本周主题来自官方 Course Profile 的 Learning activities。学习建议是先完成概念定义和关键术语对齐，再把 lecture 示例转成你自己的步骤模板，最后用 tutorial/workshop 练习验证是否能在新场景下迁移。这样可以把“听懂”转成“会做、会讲、会比较方案”。 - **核心概念/公式**: Course Overview and Intro to DBMS Introduction to database management, including traditional file-based systems, the database management system and fundamental database concepts. Readings/Ref: CB (Ch. 1, 2), analysis, modelling, SQL/Python, architecture ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见考法是定义辨析 + 场景应用 + 方案取舍，建议按“问题-方法-理由”结构作答。 🧪 **Tutorial/Lab**: 围绕“Course Overview and Intro to DBMS Introduction to database management, including traditional file-based systems, the database management system and fundamental database concepts. Readings/Ref: CB (Ch. 1, 2)”完成练习并整理错因复盘。 📌 **作业关联**: 与当周 assignment/project 模块直接相关，建议本周产出可运行第一版。 ⚠️ **易错点**: 语法正确但业务语义不正确，最终答案与题目目标不一致。 (BISM7206)）

   CourseOverviewandIntrotoDBMSIntroductiondatabasemanagement
2. 2

   Entity Relationship Modelling Entity relationship modelling is explored in terms of a data driven approach using entity-

   ### 📖 核心知识点：Entity Relationship Modelling Entity relationship modelling is explored in terms of a data driven approach using entity-relationship diagrams including design elements such as entities, relationships, attributes, keys and multiplicity. Readings/Ref: CB (Ch. 12 and 13) 本周主题来自官方 Course Profile 的 Learning activities。学习建议是先完成概念定义和关键术语对齐，再把 lecture 示例转成你自己的步骤模板，最后用 tutorial/workshop 练习验证是否能在新场景下迁移。这样可以把“听懂”转成“会做、会讲、会比较方案”。 - **核心概念/公式**: Entity Relationship Modelling Entity relationship modelling is explored in terms of a data driven approach using entity-relationship diagrams including design elements such as entities, relationships, attributes, keys and multiplicity. Readings/Ref: CB (Ch. 12 and 13), analysis, modelling, SQL/Python, architecture ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见考法是定义辨析 + 场景应用 + 方案取舍，建议按“问题-方法-理由”结构作答。 🧪 **Tutorial/Lab**: 围绕“Entity Relationship Modelling Entity relationship modelling is explored in terms of a data driven approach using entity-relationship diagrams including design elements such as entities, relationships, attributes, keys and multiplicity. Readings/Ref: CB (Ch. 12 and 13)”完成练习并整理错因复盘。 📌 **作业关联**: 与当周 assignment/project 模块直接相关，建议本周产出可运行第一版。 ⚠️ **易错点**: 复习时只看结论不做推导，导致考试应用题失分。 (BISM7206)）

   EntityRelationshipModellingrelationshipmodellingisexploredinterms
3. 3

   Relational Model Relational model concepts are discussed including specific terminology, keys, views and integrity const

   ### 📖 核心知识点：Relational Model Relational model concepts are discussed including specific terminology, keys, views and integrity constraints. Readings/Ref: CB (Ch. 4) 本周主题来自官方 Course Profile 的 Learning activities。学习建议是先完成概念定义和关键术语对齐，再把 lecture 示例转成你自己的步骤模板，最后用 tutorial/workshop 练习验证是否能在新场景下迁移。这样可以把“听懂”转成“会做、会讲、会比较方案”。 - **核心概念/公式**: Relational Model Relational model concepts are discussed including specific terminology, keys, views and integrity constraints. Readings/Ref: CB (Ch. 4), analysis, modelling, SQL/Python, architecture ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见考法是定义辨析 + 场景应用 + 方案取舍，建议按“问题-方法-理由”结构作答。 🧪 **Tutorial/Lab**: 围绕“Relational Model Relational model concepts are discussed including specific terminology, keys, views and integrity constraints. Readings/Ref: CB (Ch. 4)”完成练习并整理错因复盘。 📌 **作业关联**: 与当周 assignment/project 模块直接相关，建议本周产出可运行第一版。 ⚠️ **易错点**: 复习时只看结论不做推导，导致考试应用题失分。 (BISM7206)）

   RelationalModelmodelconceptsarediscussedincludingspecificterminology
4. 4

   Structured Query Language (I) Introduction to basic SQL DDL and DML statements. Readings/Ref: CB (Ch. 6,7)

   ### 📖 核心知识点：Structured Query Language (I) Introduction to basic SQL DDL and DML statements. Readings/Ref: CB (Ch. 6,7) 本周主题来自官方 Course Profile 的 Learning activities。学习建议是先完成概念定义和关键术语对齐，再把 lecture 示例转成你自己的步骤模板，最后用 tutorial/workshop 练习验证是否能在新场景下迁移。这样可以把“听懂”转成“会做、会讲、会比较方案”。 - **核心概念/公式**: Structured Query Language (I) Introduction to basic SQL DDL and DML statements. Readings/Ref: CB (Ch. 6,7), analysis, modelling, SQL/Python, architecture ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见考法是定义辨析 + 场景应用 + 方案取舍，建议按“问题-方法-理由”结构作答。 🧪 **Tutorial/Lab**: 围绕“Structured Query Language (I) Introduction to basic SQL DDL and DML statements. Readings/Ref: CB (Ch. 6,7)”完成练习并整理错因复盘。 📌 **作业关联**: 与当周 assignment/project 模块直接相关，建议本周产出可运行第一版。 ⚠️ **易错点**: 语法正确但业务语义不正确，最终答案与题目目标不一致。 (BISM7206)）

   StructuredQueryLanguageIIntroductiontobasicSQLDDLand
5. 5

   Structured Query Language (II) Exploring aggregation and grouping, and relational operations to enable search conditions

   ### 📖 核心知识点：Structured Query Language (II) Exploring aggregation and grouping, and relational operations to enable search conditions and order/grouping of results. Readings/Ref: CB (Ch. 6,7) 本周主题来自官方 Course Profile 的 Learning activities。学习建议是先完成概念定义和关键术语对齐，再把 lecture 示例转成你自己的步骤模板，最后用 tutorial/workshop 练习验证是否能在新场景下迁移。这样可以把“听懂”转成“会做、会讲、会比较方案”。 - **核心概念/公式**: Structured Query Language (II) Exploring aggregation and grouping, and relational operations to enable search conditions and order/grouping of results. Readings/Ref: CB (Ch. 6,7), analysis, modelling, SQL/Python, architecture ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见考法是定义辨析 + 场景应用 + 方案取舍，建议按“问题-方法-理由”结构作答。 🧪 **Tutorial/Lab**: 围绕“Structured Query Language (II) Exploring aggregation and grouping, and relational operations to enable search conditions and order/grouping of results. Readings/Ref: CB (Ch. 6,7)”完成练习并整理错因复盘。 📌 **作业关联**: 与当周 assignment/project 模块直接相关，建议本周产出可运行第一版。 ⚠️ **易错点**: 语法正确但业务语义不正确，最终答案与题目目标不一致。 (BISM7206)）

   StructuredQueryLanguageIIExploringaggregationandgroupingrelational
6. 6

   AI Debate Week – No Lecture

   ### 📖 核心知识点：AI Debate Week – No Lecture 本周主题来自官方 Course Profile 的 Learning activities。学习建议是先完成概念定义和关键术语对齐，再把 lecture 示例转成你自己的步骤模板，最后用 tutorial/workshop 练习验证是否能在新场景下迁移。这样可以把“听懂”转成“会做、会讲、会比较方案”。 - **核心概念/公式**: AI Debate Week – No Lecture, analysis, modelling, SQL/Python, architecture ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见考法是定义辨析 + 场景应用 + 方案取舍，建议按“问题-方法-理由”结构作答。 🧪 **Tutorial/Lab**: 围绕“AI Debate Week – No Lecture”完成练习并整理错因复盘。 📌 **作业关联**: 与当周 assignment/project 模块直接相关，建议本周产出可运行第一版。 ⚠️ **易错点**: 复习时只看结论不做推导，导致考试应用题失分。 (BISM7206)）

   AIDebateWeek–NoLecture
7. 7

   Normalisation Explore how normalisation supports database design and how concepts such as partial, transitive, and funct

   ### 📖 核心知识点：Normalisation Explore how normalisation supports database design and how concepts such as partial, transitive, and functional dependencies enable the logical database design to transition and conform to particular normal forms. Readings/Ref: CB (Ch. 14,15) 本周主题来自官方 Course Profile 的 Learning activities。学习建议是先完成概念定义和关键术语对齐，再把 lecture 示例转成你自己的步骤模板，最后用 tutorial/workshop 练习验证是否能在新场景下迁移。这样可以把“听懂”转成“会做、会讲、会比较方案”。 - **核心概念/公式**: Normalisation Explore how normalisation supports database design and how concepts such as partial, transitive, and functional dependencies enable the logical database design to transition and conform to particular normal forms. Readings/Ref: CB (Ch. 14,15), analysis, modelling, SQL/Python, architecture ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见考法是定义辨析 + 场景应用 + 方案取舍，建议按“问题-方法-理由”结构作答。 🧪 **Tutorial/Lab**: 围绕“Normalisation Explore how normalisation supports database design and how concepts such as partial, transitive, and functional dependencies enable the logical database design to transition and conform to particular normal forms. Readings/Ref: CB (Ch. 14,15)”完成练习并整理错因复盘。 📌 **作业关联**: 与当周 assignment/project 模块直接相关，建议本周产出可运行第一版。 ⚠️ **易错点**: 语法正确但业务语义不正确，最终答案与题目目标不一致。 (BISM7206)）

   NormalisationExplorehownormalisationsupportsdatabasedesignandconcepts
8. 8

   Data Quality and Cleaning Data is a valuable resource and access to accurate, current and informative data is critical t

   ### 📖 核心知识点：Data Quality and Cleaning Data is a valuable resource and access to accurate, current and informative data is critical to business success. Therefore, data needs to be managed and organised like other business assets. 本周主题来自官方 Course Profile 的 Learning activities。学习建议是先完成概念定义和关键术语对齐，再把 lecture 示例转成你自己的步骤模板，最后用 tutorial/workshop 练习验证是否能在新场景下迁移。这样可以把“听懂”转成“会做、会讲、会比较方案”。 - **核心概念/公式**: Data Quality and Cleaning Data is a valuable resource and access to accurate, current and informative data is critical to business success. Therefore, data needs to be managed and organised like other business assets., analysis, modelling, SQL/Python, architecture ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见考法是定义辨析 + 场景应用 + 方案取舍，建议按“问题-方法-理由”结构作答。 🧪 **Tutorial/Lab**: 围绕“Data Quality and Cleaning Data is a valuable resource and access to accurate, current and informative data is critical to business success. Therefore, data needs to be managed and organised like other business assets.”完成练习并整理错因复盘。 📌 **作业关联**: 与当周 assignment/project 模块直接相关，建议本周产出可运行第一版。 ⚠️ **易错点**: 复习时只看结论不做推导，导致考试应用题失分。 (BISM7206)）

   DataQualityandCleaningisavaluableresource
9. 9

   Guest Lecture

   ### 📖 核心知识点：Guest Lecture 本周主题来自官方 Course Profile 的 Learning activities。学习建议是先完成概念定义和关键术语对齐，再把 lecture 示例转成你自己的步骤模板，最后用 tutorial/workshop 练习验证是否能在新场景下迁移。这样可以把“听懂”转成“会做、会讲、会比较方案”。 - **核心概念/公式**: Guest Lecture, analysis, modelling, SQL/Python, architecture ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见考法是定义辨析 + 场景应用 + 方案取舍，建议按“问题-方法-理由”结构作答。 🧪 **Tutorial/Lab**: 围绕“Guest Lecture”完成练习并整理错因复盘。 📌 **作业关联**: 与当周 assignment/project 模块直接相关，建议本周产出可运行第一版。 ⚠️ **易错点**: 复习时只看结论不做推导，导致考试应用题失分。 (BISM7206)）

   GuestLecture
10. 10

    Transaction Management This lecture explores the critical role of transaction management in business systems, focusing o

    ### 📖 核心知识点：Transaction Management This lecture explores the critical role of transaction management in business systems, focusing on how organisations maintain data integrity and consistency in multi-user environments and recover from failures to ensure reliable operations. Readings/Ref: CB (Ch. 22) 本周主题来自官方 Course Profile 的 Learning activities。学习建议是先完成概念定义和关键术语对齐，再把 lecture 示例转成你自己的步骤模板，最后用 tutorial/workshop 练习验证是否能在新场景下迁移。这样可以把“听懂”转成“会做、会讲、会比较方案”。 - **核心概念/公式**: Transaction Management This lecture explores the critical role of transaction management in business systems, focusing on how organisations maintain data integrity and consistency in multi-user environments and recover from failures to ensure reliable operations. Readings/Ref: CB (Ch. 22), analysis, modelling, SQL/Python, architecture ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见考法是定义辨析 + 场景应用 + 方案取舍，建议按“问题-方法-理由”结构作答。 🧪 **Tutorial/Lab**: 围绕“Transaction Management This lecture explores the critical role of transaction management in business systems, focusing on how organisations maintain data integrity and consistency in multi-user environments and recover from failures to ensure reliable operations. Readings/Ref: CB (Ch. 22)”完成练习并整理错因复盘。 📌 **作业关联**: 与当周 assignment/project 模块直接相关，建议本周产出可运行第一版。 ⚠️ **易错点**: 只写组件清单，不写故障场景与容量取舍。 (BISM7206)）

    TransactionManagementThislectureexploresthecriticalroleoftransaction
11. 11

    Database Security and Control We’ll look at why database security matters, the main threats to data security, and the co

    ### 📖 核心知识点：Database Security and Control We’ll look at why database security matters, the main threats to data security, and the core ideas of confidentiality, integrity, and availability (the CIA triad). We’ll also cover practical countermeasures and finish with an overview of Data Control Language (DCL). Readings/Ref: CB (Ch. 20) 本周主题来自官方 Course Profile 的 Learning activities。学习建议是先完成概念定义和关键术语对齐，再把 lecture 示例转成你自己的步骤模板，最后用 tutorial/workshop 练习验证是否能在新场景下迁移。这样可以把“听懂”转成“会做、会讲、会比较方案”。 - **核心概念/公式**: Database Security and Control We’ll look at why database security matters, the main threats to data security, and the core ideas of confidentiality, integrity, and availability (the CIA triad). We’ll also cover practical countermeasures and finish with an overview of Data Control Language (DCL). Readings/Ref: CB (Ch. 20), analysis, modelling, SQL/Python, architecture ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见考法是定义辨析 + 场景应用 + 方案取舍，建议按“问题-方法-理由”结构作答。 🧪 **Tutorial/Lab**: 围绕“Database Security and Control We’ll look at why database security matters, the main threats to data security, and the core ideas of confidentiality, integrity, and availability (the CIA triad). We’ll also cover practical countermeasures and finish with an overview of Data Control Language (DCL). Readings/Ref: CB (Ch. 20)”完成练习并整理错因复盘。 📌 **作业关联**: 与当周 assignment/project 模块直接相关，建议本周产出可运行第一版。 ⚠️ **易错点**: 语法正确但业务语义不正确，最终答案与题目目标不一致。 (BISM7206)）

    DatabaseSecurityandControlWe’lllookatwhydatabasesecurity
12. 12

    Distributed Database Management Systems We examine distributed DBMSs including concepts, problems, technologies and prot

    ### 📖 核心知识点：Distributed Database Management Systems We examine distributed DBMSs including concepts, problems, technologies and protocols. Readings/Ref: CB (Ch. 24, 25) 本周主题来自官方 Course Profile 的 Learning activities。学习建议是先完成概念定义和关键术语对齐，再把 lecture 示例转成你自己的步骤模板，最后用 tutorial/workshop 练习验证是否能在新场景下迁移。这样可以把“听懂”转成“会做、会讲、会比较方案”。 - **核心概念/公式**: Distributed Database Management Systems We examine distributed DBMSs including concepts, problems, technologies and protocols. Readings/Ref: CB (Ch. 24, 25), analysis, modelling, SQL/Python, architecture ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见考法是定义辨析 + 场景应用 + 方案取舍，建议按“问题-方法-理由”结构作答。 🧪 **Tutorial/Lab**: 围绕“Distributed Database Management Systems We examine distributed DBMSs including concepts, problems, technologies and protocols. Readings/Ref: CB (Ch. 24, 25)”完成练习并整理错因复盘。 📌 **作业关联**: 与当周 assignment/project 模块直接相关，建议本周产出可运行第一版。 ⚠️ **易错点**: 语法正确但业务语义不正确，最终答案与题目目标不一致。 (BISM7206)）

    DistributedDatabaseManagementSystemsWeexaminedistributedDBMSsincludingconcepts
13. 13

    Overview and Big Data & Technologies Exploring why data management technologies and approaches have expanded beyond rela

    ### 📖 核心知识点：Overview and Big Data & Technologies Exploring why data management technologies and approaches have expanded beyond relational databases and data warehousing. 本周主题来自官方 Course Profile 的 Learning activities。学习建议是先完成概念定义和关键术语对齐，再把 lecture 示例转成你自己的步骤模板，最后用 tutorial/workshop 练习验证是否能在新场景下迁移。这样可以把“听懂”转成“会做、会讲、会比较方案”。 - **核心概念/公式**: Overview and Big Data & Technologies Exploring why data management technologies and approaches have expanded beyond relational databases and data warehousing., analysis, modelling, SQL/Python, architecture ⏰ **本周节奏**: 难度 ⭐⭐⭐ | 预计投入 9h（Lecture 2h + 自学 4h + 作业/Lab 3h） 🎯 **考试关联**: 常见考法是定义辨析 + 场景应用 + 方案取舍，建议按“问题-方法-理由”结构作答。 🧪 **Tutorial/Lab**: 围绕“Overview and Big Data & Technologies Exploring why data management technologies and approaches have expanded beyond relational databases and data warehousing.”完成练习并整理错因复盘。 📌 **作业关联**: 与当周 assignment/project 模块直接相关，建议本周产出可运行第一版。 ⚠️ **易错点**: 语法正确但业务语义不正确，最终答案与题目目标不一致。 (BISM7206)）

    OverviewandBigData&TechnologiesExploringwhydatamanagement