(DSS Component)

1

• ????????????????????????????????????
• (DSS Component)

D S S
2
?????? (Topic)

• 1 ????????????????????????????????????
• 1.1 ???????????????? (Data Management
  Subsystem)
• 1.2 ?????????????????? (Model Management
  Subsystem)
• 1.3 ???????????????????? (Knowledge-based
  (Management) Subsystem)
• 1.4 ??????????????????? (User Interface
  Subsystem)
• 1.5 ????????????? (The User)
• 2 ?????????? (Data Warehouse)
• 3 ?????????????????? (Database Technology)
• 4 ???????????????????????? DSS (DSS Hardware)

D S S
3
??????????????????????? (Learning Objective)

• 1. ??????????????????????????????????????????????
  ?????????????????? ???? 5 ???????
• 2. ??????????? (Diagram) ????????????????????????
  DSS (DSS Component) ???
• 3.?????????????????????????? (Data Warehouse)
  ?????????????????????
• 4. ???????????????????????????????????????????????
  ??????????????????????????
• 5. ????????????????????????????????? (Database
  Technology) ????????????????????????
• 6. ????????????????????????????? DSS ???

D S S
4
1 ???????????????????????????????????? (DSS
Components)
D S S
5
????????????????????? ???????? DSS Component

• 1. ??????????????
• 2. ???????????????????????????????? ? ????????
• (????????????,???????????,???????????????)
• 3. ??????????????????????????????? ?
• (???????????,??????????????,?????????????)
• 4. ????????????????????????????? ?
  ????????????????????????????????????????
• 5. ??????????????????????????????????

D S S
6
1 ???????????????????????????????????? (DSS
Components)

• 1.???????????????? (Data Management Subsystem)
  
• 2.?????????????????? (Model Management
  Subsystem)
• 3. ???????????????????? (Knowledge-based
  (Management) Subsystem)
• 4.??????????????????? (User Interface
  Subsystem)
• 5. ????????????? (The User)

D S S
7
DSS Components
User
5
User Interface
4
KBS1
3
D S S
DBMS
MBMS
1
2
KBS3
KBS2
3
3
8
1.1 ???????????????? (The Data Management
Subsystem)

• ?????????????????? 4 ???? ??????
• ????????? DSS (DSS database)
• ??????????????????? (Database management system)
• ???????????? (Data directory)
• ??????????????? (Query facility)

D S S
???
1.2
9
DSS database

• 1. ????????? DSS (DSS database)
  ???????????????? ????????????? DSS
  ??????????????????????????? ???????????????
  ??????????????????????? ????????????????????????
  DSS ??????????????????????????
  ???????????????????????????????????????
  ??????????????????????????????????????????????????
  ? Cleaning ?????????? ????????????? DSS
  ????????????????????????????? ? ??
  (??????????????????????????????????????????)

D S S
10
????????? DSS (DSS Database)

• ?????????????????????? ??????????????????????????
  ???????? DSS ??????????????
• 1. Data warehouse
• 2. Data mining
• 3. Special independent DSS databases
• 4. Extraction of data from internal, external,
  and private sources
• 5. Web browser data access
• 6. Web database servers
• 7. Multimedia databases
• 8. Special GSS databases (like Lotus Notes /
  Domino Server)
• 9. Online Analytical Processing (OLAP)
• 10. Object-oriented databases
• 11. Commercial database management systems (DBMS)

D S S
11
?????????????????????? (The Nature and Sources of
Data)

• ?????????????? DSS ??????????
• 1. ?????? (Documents)
• 2. ?????? (Pictures)
• 3. ?????? (Maps)
• 4. ????? (Sound)
• 5. ????????????? (Animation)
• 6. ?????? (Video)
• ?????????????? DSS ?????????????????????????????
  Hard Copy ??? Soft Copy

D S S
12
??????????? (Data Sources)

• 1. ?????????????????????? (Internal)
• 2. ??????????????????????? (External)
• 3. ?????????????????????? (Personal)

D S S
13
???????????????????????

• 1. ???????? (Survey)
• 2. ??????????? (Observation)
• 3. ??????????? (Interview)
• 4. ?????? (Documentation)
• ??????????????????????????
• 1. ????????????????????????????????
  ???????????????????????????????????
• 2. ????????????????? ???????????????????
  ?????????? ??????????????????????????
  ??????????????????????????????????

D S S
14

• ??????????????
• 1. ????????????????
• 2. ??????????????????
• 3. ??????????????????????
• 4. ???????????????????????????????
• ??????????????? (Data quality)
• 1. ???????????????????????
• 2. ?????????????????????
• 3. ????????????????????????
• 4. ??????? ???????????
• 5. ???????????????????????????????
• 5. ??????????????? ?????????????
  ?????????????????

D S S
15
???????????????????????????????????? DSS

• 1. ???????????????????????????????????,
  ???????????????
• 2. ?????????? Update ????????????
• 3. ?????????????????? ????????????????
  ?????????????
• 4. ??????????????????????????????????????????????
  ??????????????????

D S S
16
???????????????????????? (Database Organization
and Structure)

• 1. ????????????????????? (Relational databases)
• 2. ????????????????????? (Hierarchical databases)
• 3. ????????????????????? (Network databases)
• 4. ?????????????????? (Object-oriented databases)
• 5. ???????????????????? (Multimedia-based
  databases)
• 6. ??????????????? (Document-based databases)
• 7. ????????????????????????????????????????
  (Intelligent databases)
• 8. ????????????????? (Multidimensional Database
  )

D S S
1.1
17
Database management system DBMS

• 2. ??????????????????? (Database management
  system DBMS)
• ??????????????????????????????????
  ?????????????????????????????????????????? ????
• DBMS ????????????????????????????????
  ???????????? ?????????????? ???????????
• ??????????? User ????????? DBMS ?????????????
  User Interface
• ????????????????????? DSS (Database Management
  Systems in DSS)
• DBMS ????????????? DSS ???????????????????
  (Software program) ?????????????
• - ??????? ???????????? ???????
  ????????????????? (storing)
• - ?????????????? (updating)
• - ???????? (deleting)
• - ????????????( manipulating)
• - ???????????????????????????? (retrieving)

D S S
1.1
18

• 3. ???????????? (Data directory) ?????????
  (index) ?????????????????? ???? DD
  ??????????????????????????????????????????????????
  ????? ??????????????????????????
  ?????????????????????? ???????????????????????????
  ????
• 4. ??????????????? (Query facility)
  ???????????????????????????? ?????????????????????
  ???????????

D S S
1.1
19
1.2 ?????????????????? (The Model Management
Subsystem )

• ?????????? 5 ?????????? ??????
• ??????????? (Model base)
• ????????????????????? (Model base management
  system)
• ?????????????????????? (Modeling language)
• ?????????????? (Model directory)
• ??????????????????????? (Model execution,
  integration, and command processor)

D S S
???
1.3
20
Model base

• 1. ??????????? (Model base)
• ???????????????????????? Model ???? ?
  ???????????? ?????????????????
• ????? ? ???????????????? Model ?????????????? 1
  Model ???????????????????
• - Model ?????????????????????????
• - Model ?????????????????????
• - Model ?????????????????????????
• - Model ?????????????????????? ?

D S S
1.2
21
Model base management system

• 2. ????????????????????? (Model base management
  system)
• ???? MBMS ??????????????????????????????????
  ???????????
• (Model base) ???????? Update ??????????? (Model
  base)
• ??????????????? MBMS ?????????????????????????
  ?????????????????
• (Tools) ???? ? ????????????????
  ????????????????????????? User Interface

D S S
1.2
22
Modeling language

• 3. ?????????????????????? (Modeling language)
• ?????????????????????????????????????????????????
  ??? ???? C,
• C, Visual Basic, Java, Cobol ?????????????
• ???????????????????? Spreadsheet ??? ???? Excel

D S S
1.2
23
Model directory

• 4. ?????????????? (Model directory)
• ?????????????????? (Index) ??????????
  ??????????????????? ??????????????? Model
  ?????????????????????????????????? ???? Model
  directory ????????????????????????, ????????
  ?????????????????? Model ?????????????????

D S S
1.2
24
Model Execution

• 5. ???????????????????????
• (Model execution, integration, and command
  processor)
• ????????????????????? ?????? Model
  ????????????????????? ???
• ???????????????????? ? ???????????????????? 1
  Model ???????????????
• ??????? (Output) ?????????Model
  ?????????????????? Input ???
• ????????????????? Model ??? 2 ?????????
  ????????????????????????????
• ??????????????????????? ??????????????????????????
  ???????????
• (Process) ????????????????????????? ?
  ?????????????????? ??????
• ???????????? (Coordinate)

D S S
1.2
25
1.3 ???????????????????? (Knowledge-based
(Management) Subsystem)

• 1. ???????????????????????????????????????????????
  ???????????????????? ?????????????????
• 2. ??????????????????????????????????????? expert
  system ???? intelligent system
• 3. ???? DSS ?????????????????
  ???????????????????? ??????????? (knowledge
  based management component)
• 4. ???? DSS ?????????????????????????????????????
  ???? intelligent DSS ???????????? Data mining

D S S
???
1.4
26
????????????? KBMS

• 1. ??????????????????????????????? (Expert
  Source) ?????????????????????????????????????????
  ?????????????? ?????????????????????? ?
  ????????????????????????????????????? Knowledge
  Representation
• 2. ???????????????????? (Knowledge
  Representation) ????????????????????????????????
  ??????????????????????????????????????????????????
  ?????? ??????????????????????????????????
  ??????????????????????? ? ????????????????????????
  ??????????????????? ?????????????????????????????
  ?????
• 3. ?????????????? (Knowledge Base)
  ?????????????????????????????????
  ???????????????????????????????????
  ?????????????????????????????????????
• 4. ?????????????????? (Knowledge Validation)
  ??????????????????????????????????????????????????
  ???????????????????????
• 5. ????????? (Explanation) ??????????????????????
  ????????????? ? ????????????????????????????????
  ?????????????????????? ??????????????????
• 6. ??????????? (Inferencing) ???????????????????
  ????????

D S S
27
1.4 ??????????????????? (User Interface
(Dialog) Subsystem)

• 1. ?????????????????????? (communication)?????????
  ???????????
• 2. ???????????? GUI (Graphical user interfaces)
• 3. ????????????????? (Voice recognition)
  ?????????????????????????????
• (speech synthesis possible)
• 4. ???????????????????

D S S
???
1.5
28
User Interface Subsystem

• ?????????????????????? User Interface ??????????
• ????????????????????????? Input Device
• ???????????????????????????? (Translation)
• ????????????????????? User Interface (User
  Interface Management System)
• ???????????????????????????????? DBMS ????
  Knowledge Base ???? MBMS (Model Base Management
  System) ????????????? 3 ????????????????????????
  ????????? ???????????????????????????????????
  Output Device
• Note ????????????? User Interface
  ????????????????????????? graphic
  ????????????????????????? (Input Device)
  ?????????????????? graphic ??????????????????????
  ???????? ???????????????? ??? user
  ????????????????? user interface ???

D S S
29
1.5. ????????????? (The User)

• ????????????? DSS ????????????????????????????????
  ?????????? ???? user, manager,
• ??????????????????????? (decision maker)
• 1. Managers
• 2. Staff specialists
• ???????????????????????????? (Intermediaries)
  ?????????????? decision maker 1. Staff
  assistant 2. Expert tool user 3. Business
  (system) analyst 4. GSS Facilitator

D S S
???
30
2 ?????????? (Data Warehouse)
D S S
31
2 ?????????? (Data Warehouse)
- ??? ????????????????????????????? IS
???????????????????????????????????????
??????????????????? (Transaction record)
?????????????????????? ??????????????????????????
?????????????????? ?????????? ???????????????
??????????????????????????????????????????????????
???? ????????????? ??????????? ???????
????????????????? ??????????????????
??????????????????????? ??????????????????????????
???????? ????????????? Data Warehouse 1.
??????????????????????????? 2.
??????????????????? 3. Data mart 4. DSS ??? EIS
D S S
32
2 ?????????? (Data Warehouse)
???????????? Data Warehouse ?????????? 1.
Subject-Oriented ???????????????????????????????
????????? ???? ?????? ?????? ?????? 2.
Integrated ?????????????????????????????????
??????????????????????????????????????? 3.
Time-valiant ???????????????????????????????????
??????????????? ???? 5-10 ??????????
??????????????????????????????????????????????????
????????????????????????????????? 4.
None-Volatile ??????????????????????????????????
?????????? ??????????????????????????????????????
?????? ??????????????????????
D S S
33
2 ?????????? (Data Warehouse)
???????? Data Warehouse 1. ???????????????????????
?? 2. ????????????????????????????? 3.
????????????????????????????? ?????????? Data
Warehouse 1. ???????????????? load
??????????????????????????? 2.
???????????????????????????????????????????? ?
3. ?????????????????????????????? 4.
???????????????????????????
D S S
34
??????????? Data Warehouse (Data Warehouse
Architecture)
D S S
??????????????? Multi-Tiered Architecture
35
???????????????????? Data Warehouse
????????????????? 2 ???? 1. ??????????????????????
?? ?????????????????? ??????????????????? ?
????????? ???????????????? ??? ??????
??????????????????????????????????????????????????
????? (??????????????????????????? Query and
Reporting) 2. ???????????????????????
??????????????? (Tools) ??????????????????????????
??????????? ?????????????????????????????????????
?????????????? ????????????????????????
(???????????????????? Multidimensional Data
Analysis) Note ?????????? 2 ????????????????????
?????????????????? Data Mining ???
D S S
36
3 ?????????????????? (Database Technology)
D S S
37
3 ?????????????????? (Database Technology)

• ?????????????????????????????????????????????????
  ?????????????????????? ???
• ???????? (Decision Maker) ???????????????????????
  ???????????? ???????????
• ?????????????????? ??????
• 1. ?????????? (Data Warehouse)
• 2. Data Mart
• 3. ????????????????? (Multidimensional Database)
• ???????? ???????????????????????? ??????
  ????????????????????????????????????????
• (Online Analytical ProcessingOLAP),
  ????????????????? (Data
• Mining)

D S S
38
????????????????? (Multidimensional Database )

• ????????????????????????????????????????????????
  ????????? ?
• ???????????? ????????????????????????????????
  (Relational
• database) ????????????????????????????????????????
  
• ???????????????????????????? (OLAP)

D S S
39
????????????? OLAP

• 1. Roll up (drill-up) ??????????????????
• ?????????????????????????????????????????????????
  ????????????? Drill down
• ????????? ??????????????? ?
• 2. Drill down (roll down) ?????????????????????
• ??????????????????????????????????
  ?????????????????????????
• 3. Slice and dice
• slice ?????????????????????????????????????????
  ???????????????????
• dice ??????????????????????????????
  ??????????????????????????
• 4. Pivot (rotate) ??????????????????????????
  (cube), visualization
• ???????????????? 2 ??????????? 3 ????

D S S
40
??????????? OLAP

• 1. ?????????????????????????????????????????? ?
• 2. ???????????????????????????????????????????????
  ??????????????????????
• 3. ????????????????????????????????????????????
• 4. ?????????????????????????????????
• 5. ????????????????????????????? ?
  ??????????????????????? ???????????
• ??????????????????

D S S
41
??????????? OLAP
D S S
??????????????? Data Cube
42
??????????? OLAP
D S S
???????????????????? Data Cube
43
Data Visualization
????????? Data Visualization ?????? 1. Digital
images 2. Geographic information systems 3.
Graphical user interfaces 4. Multidimensions 5.
Tables and graphs 6. Virtual reality 7.
Presentations 8. Animation
D S S
44
4 ???????????????????????? DSS (DSS Hardware)
D S S
45
4 ???????????????????????? DSS (DSS Hardware)

• ?????????????? Tools ??????????????? DSS
  ???????????? computer
• hardware ??????????????????? software ,???????
  Hardware ??
• ??????????
• 1. Mainframe
• 2. Workstation
• 3. Personal computer
• 4. Web server system
• - Internet
• - Intranets
• - Extranets

D S S
46

• ..The End..

D S S