Page 52 - DCAP208_Management Support Systems

Unit 4: Dialogue Management, Data Management and Model .......

4.2 Data Management for DSS Notes

The data management subsystem is composed of:

DSS database
DBMS
Data directory
Query facility
Figure 4.3: Data Management Subsystem

Internal data
sources
External data
sources Finance Marketing Production Personnel Other

Organizational Extraction Private,
knowledge base personal
data
Decision Corporate
Query data
facility Support warehouse
database

Database Interface
management Management
system
Retrieval
Inquiry Model
Data Update Management
directory Report generation
Delete
knowledge-based
Subsystem

These are discussed below:
Database: Internal data come mainly from the organization’s transaction processing system.
External data include industry data, market research data, census data, regional employment
data, government regulations, tax rate schedules, and national economic data. Private
data can include guidelines used by specific decision makers and assessments of specific
data and/or situations.
Data extraction: The process of capturing data from several sources, synthesizing them,
summarizing them, determining which of them are relevant, and organizing them,
resulting in their effective integration.

DBMS: Software for establishing, updating, and querying (e.g., managing) a database
Query Facility: The (database) mechanism that accepts requests for data, accesses them,
manipulates them, and queries them

Directory: A catalog of all the data in a database or all the models in a model base.
Key database and database management system issues include:
Data quality
Data integration

LOVELY PROFESSIONAL UNIVERSITY 45