Decision Support Systems: Chapter 5 - Data Management includes Data, Information, Knowledge; Data collection, problems and quality; Database Management Systems in DSS; Data warehousing; OLAP; Data Mining; Data Visualization and Multidimensionality; GIS. | Chapter 5 Data Management Decision Support Systems 5- Outline , Information, Knowledge collection, problems and quality Management Systems in DSS warehousing Mining Visualization and Multidimensionality 5- , Information, Knowledge Data Items that are the most elementary descriptions of things, events, activities, and transactions May be internal or external Information Organized data that has meaning and value Knowledge Processed data or information that conveys understanding, experience or learning applicable to a problem or activity 5- Data Sources Internal data External data Web Government reports and files Research institutes Statistic bureaus Local banks Chambers of commerces Commercial databases Sell access to specialized databases 5- 2. Data collection Raw data collected manually or by instruments Quality is critical Quality determines usefulness Contextual data quality Intrinsic data quality . | Chapter 5 Data Management Decision Support Systems 5- Outline , Information, Knowledge collection, problems and quality Management Systems in DSS warehousing Mining Visualization and Multidimensionality 5- , Information, Knowledge Data Items that are the most elementary descriptions of things, events, activities, and transactions May be internal or external Information Organized data that has meaning and value Knowledge Processed data or information that conveys understanding, experience or learning applicable to a problem or activity 5- Data Sources Internal data External data Web Government reports and files Research institutes Statistic bureaus Local banks Chambers of commerces Commercial databases Sell access to specialized databases 5- 2. Data collection Raw data collected manually or by instruments Quality is critical Quality determines usefulness Contextual data quality Intrinsic data quality Accessibility data quality Representation data quality Often neglected or casually handled Problems exposed when data is summarized 5- 5- Data quality Cleanse data When populating warehouse Data quality action plan Best practices for data quality Measure results Data integrity. There are five issues: Uniformity Version Completeness check Conformity check Genealogy or drill-down 5- Data access and integration Data Integration Access needed to multiple sources Often enterprise-wide Disparate and heterogeneous databases XML becoming language standard 5- Management Systems DBMS is a software program. It is designed to Supplement operating system Manage data Query data and generate reports Ensure data security For DSS application, DBMS combines with modeling language for construction of DSS 5- Database organization and structures Hierarchical Top down, like inverted tree Fields have only one “parent”, each “parent” can have multiple “children” Fast Network .
