← Back to Hub ← 返回主页

Week 4: Foundation & Technologies for Decision Making (Part 2) 第 4 周：决策制定基础与技术（二）

Learning Objectives 学习目标

  • Classify DSS based on Power's taxonomy.
  • Explain the three core subsystems of DSS architecture.
  • Identify the roles of Data and Model Management.

Step-by-Step Guide 分步指南

2.4 DSS Classifications

  • Model-driven DSS: Uses mathematical, financial, or simulation models to perform analysis. User interacts with inputs to see output shifts.
  • Data-driven DSS: Accesses and queries large historical databases or data warehouses to find trends.
  • Document-driven DSS: Integrates structured and unstructured documents (e.g., policy manuals, corporate reports) to answer queries.
  • Communication-driven DSS: Supports group collaboration, shared whiteboard design, and meetings.
  • Knowledge-driven DSS: Provides specialized cognitive rules and expert problem-solving heuristics.

Real-world Case: United Airlines

  • United Airlines uses a Model-driven DSS running linear programming mathematical algorithms to optimize passenger scheduling.
  • The model takes aircraft size, crew rules, and flight routes to calculate crew assignments.

Reference: United Airlines Staffing Optimization

2.5 Components of DSS

  • Data Management Subsystem: Includes the database, Database Management System (DBMS), data directory, and query facilities.
  • Model Management Subsystem: Includes the model base, Model Base Management System (MBMS), model directory, and model execution.
  • User Interface Subsystem: Handles dialog and interaction between the user and the system (e.g., input forms, graphical dashboard charts).
  • Knowledge Management Subsystem: Optional component providing reasoning logic to assist other subsystems.

Real-world Case: Procter & Gamble (P&G)

  • P&G's supply chain DSS integrates a DBMS (storing sales logs), an MBMS (forecasting replenishment demand), and a web UI dashboard.
  • This integration allows supply chain planners to run inventory predictions directly from the UI.

Reference: P&G Inventory Optimization Success

Power's DSS Classifications

DSS Type Dominant Driver Target Users Typical Examples
Model-Driven Mathematical & analytical models Analysts, managers Excel Solver, linear optimization scheduler
Data-Driven Access to and manipulation of data Business managers OLAP dashboards, data warehouses
Document-Driven Unstructured text & file retrieval Knowledge workers Corporate intranet policies database, search engine
Communication-Driven Group collaboration & messaging Project teams Microsoft Teams, shared whiteboards, zoom rooms
Knowledge-Driven Expert rules & recommendation engine Specialists, clients Medical diagnostics system, AI loan screening
DBMS (Data Management)

Contains the databases, schemas, and queries handling data storage and retrieval.

MBMS (Model Management)

Stores and coordinates optimization, descriptive, and analytical models used for computations.

2.4 决策支持系统 (DSS) 分类 (Daniel Power)

  • 模型驱动型 DSS： 使用数学、财务或模拟模型来进行分析。用户与输入数据交互以观察输出的变化。
  • 数据驱动型 DSS： 访问和查询大型历史数据库或数据仓库以发现趋势。
  • 文档驱动型 DSS： 整合结构化和非结构化文档（例如政策手册、公司报告）以回答查询。
  • 通信驱动型 DSS： 支持团队协作、共享白板设计和会议。
  • 知识驱动型 DSS： 提供专门的认知规则和专家解决问题的启发式算法。

真实企业案例：美联航 (United Airlines)

  • 联合航空使用模型驱动型 DSS运行线性规划数学算法来优化机组人员排班。
  • 该模型结合飞机尺寸、机组规则和飞行路线来计算最优排班安排。

参考链接： 美联航员工排班优化

2.5 决策支持系统 (DSS) 核心组件

  • 数据管理子系统： 包括数据库、数据库管理系统 (DBMS)、数据字典和数据查询设施。
  • 模型管理子系统： 包括模型库、模型库管理系统 (MBMS)、模型字典和模型执行控制。
  • 用户界面子系统： 处理用户与系统之间的对话和交互（例如输入表单、图形化仪表板图表）。
  • 知识管理子系统： 可选组件，提供推理逻辑以协助其他子系统。

真实企业案例：宝洁公司 (P&G)

  • 宝洁的供应链 DSS 整合了 DBMS（存储销售日志）、MBMS（预测补货需求）和 Web 界面仪表板。
  • 这种集成使供应链计划人员能够直接从用户界面运行库存预测。

参考链接： 宝洁库存优化成功案例

Power 的 DSS 门类分类法

DSS 类型 主导驱动技术 目标用户 典型示例
模型驱动型 数学与分析计算模型 分析师、部门经理 Excel Solver 规划求解器、线性规划排程器
数据驱动型 数据访问与多维操作 业务经理 OLAP 报表仪表板、数据仓库系统
文档驱动型 非结构化文本与文件检索 知识工作者 企业内网制度库、搜索引擎系统
通信驱动型 群组协作与信息交互 项目团队 Microsoft Teams、共享白板、视频会议系统
知识驱动型 专家系统规则与推荐引擎 专业人员、客户 医疗诊断辅助系统、AI 贷款自动审批系统
DBMS 数据管理子系统

包含数据库、数据模式和查询，负责数据的存储与提取。

MBMS 模型管理子系统

存储并协调用于计算的优化模型、描述模型和分析模型。

Concept Visualization 概念可视化

1. DBMS (Data)2. MBMS (Models)3. KBMS (Rules)User Interface

Educational Infographic 教学信息图

Visual concept map explaining the key module topic: 解释该模块核心主题的视觉概念图：

Dialogue (User Interface) DBMS (Data Base) MBMS (Model Base)

📊 Practical Decision Support Suite (Week 4) 📊 实用决策支持套件（第 4 周）

📗 Excel DSS Classification & Component Mapping

Categorize enterprise DSS types and their core subsystem drivers:

| DSS Category | Primary Component | Key Subsystem Driver | Business Example | |---|---|---|---| | Model-Driven | MBMS | Excel Solver / Optimization | Production scheduling | | Data-Driven | DBMS | Data Warehouse / OLAP | Sales trend dashboard | | Document-Driven | Knowledge Base | AI NLP / Search Engine | Policy manual search |

Tips 提示

Be ready to identify the DBMS vs MBMS components. Remember that User Interface is the key dialog component connecting them to the manager.
随时准备识别 DBMS 与 MBMS 组件。记住，用户界面是连接它们与管理者的核心对话组件。

Knowledge Check 知识自测

1. A DSS that relies on mathematical and simulation models is classified as: 依赖于数学和模拟模型的 DSS 被分类为：

Show Explanation 显示解析
Correct Answer: Option 1 正确选项：选项 1

2. Which subsystem coordinates the execution and updating of mathematical formulas in a DSS? 在 DSS 中，哪个子系统协调数学公式的执行和更新？

Show Explanation 显示解析
Correct Answer: Option 2 正确选项：选项 2

3. Daniel Power's DSS taxonomy contains how many dominant categories? Daniel Power 的 DSS 分类学包含多少个主要类别？

Show Explanation 显示解析
Correct Answer: Option 2 正确选项：选项 2

Practical Exercise 实践练习

Task 1: Write an Excel formula to sum cells B1 to B5. 任务 1: 编写一个 Excel 公式，对单元格 B1 到 B5 的值进行求和。

Task 2: SQL query to find unique values in the 'Class' column of 'DSS_Types' table. 任务 2: SQL 查询：查找 'DSS_Types' 表中 'Class' 列的唯一值。

Task 3: DAX formula to calculate year-to-date sales from Sales[Amount] based on Sales[Date]. 任务 3: DAX 公式：根据 Sales[Date] 计算 Sales[Amount] 的年初至今 (YTD) 销售额。

Revision Guide 复习指南

Revision Checklist:

  • I can name and describe the 5 types of DSS in Power's taxonomy.
  • I understand the roles of the Database, Model Base, and User Interface subsystems.
  • I can identify which type of DSS is appropriate for a given business scenario.

Key Concepts to Remember:

  • DSS Classifications:
    • Model-driven DSS: Uses mathematical, financial, or simulation mod...
    • Components of DSS:
      • Data Management Subsystem: Includes the database, Database Manage...

Matching Game 配对游戏

Match the term on the left with its definition on the right. 将左侧的术语与右侧的定义进行配对。

DBMS
Manages database tables and query filters管理数据库表和查询过滤器
Model-driven DSS
Analytical support using simulation or optimization formulas使用模拟或优化公式的分析支持
MBMS
Accesses database queries to extract historical metrics访问数据库查询以提取历史指标
Data-driven DSS
Coordinates model creation and goal-seeking execution协调模型创建和目标求解执行