Chapter 4 - Data and Knowledge Management

Chapter 4: Data and Knowledge Management

Objectives

  • Differentiate between Traditional File Organization and Database Approach

  • Advantages and Disadvantages of Database Approach

  • Importance of Data Management Systems

  • Creating Databases with Microsoft Access (via video)

  • Identifying Database Applications

  • Understanding Data Warehouses and Business Intelligence

Usage of Database Systems

  • Essential in Corporate ResourcesExamples include:

    • Online Search Engines

    • E-commerce Systems

    • ATM Systems

    • Online Enrollment Systems

    • Social Media Profiles (e.g., Facebook)

    • E-banking Systems

    • E-ticketing Systems

    • Call Centers

Managing Digital Data

  • Impact of Not Using Database Systems:

    • Inability to locate customer debt records.

    • Difficulty in responding to customer inquiries.

    • Online shoppers unable to find product details.

    • Real-time balance inquiries not possible.

  • Key Features of Database Systems:

    • Facilitate transactions at ATM across various banks.

    • Enable detailed online product viewing.

    • Allow efficient information searching via engines.

    • Support online purchasing and payment processing.

    • Without databases, services like online banking and catalogs would not exist.

Importance of Data Management Knowledge

  • Solutions to Common Problems:

    • How to retrieve and access data effectively.

    • Determine necessary reports.

    • Identify retrievable data types to resolve issues.

  • Benefit: Enhancing productivity by understanding database construction and queries.

Data Resource Management Definition

  • An organizational function involved in planning, organizing, describing, and controlling data resources, typically stored using Database Management Systems (DBMS) or software like spreadsheets.

Methods to Organize and Maintain Data

  1. Traditional File Organization

  2. Database Approach

Traditional File Organization Overview

  • Requires each user to maintain individual files tailored for specific applications, leading to data silos.

Problems with Traditional File Organization

  • Data Redundancy: Duplicate data stored in multiple files.

  • Data Inconsistency: Different values for the same attribute across files.

  • Program-Data Dependence: Changes in data require program updates.

  • Lack of Flexibility: Complicated reporting processes.

  • Poor Security: Weak data control leading to potential data leaks.

  • Data Sharing Issues: Difficulty in timely access and sharing of information.

Database Approach Definition

  • A system that pools related data in one location shared by multiple DBMS programs.

  • DBMS includes software like Microsoft Access, Oracle, MySQL, SyBASE, facilitating user interaction with the database.

Advantages of Database Approach

  1. Enhanced Strategic Use of Data: Decision-makers receive accurate, up-to-date data.

  2. Reduced Data Redundancy: Centralized data storage limits duplicates.

  3. Improved Data Integrity: Changes reflect universally across the database.

  4. Easier Modifications: Coordinated updates; users don’t know storage locations.

  5. Better Data Protection: Security measures protect sensitive data.

  6. Shared Data Resources: Costs shared among multiple applications and users.

Disadvantages of Database Approach

  1. Increased Complexity: Users must understand database concepts to utilize DBMS effectively.

  2. Recovery Challenges: Failures can impact the entire database as opposed to single file issues.

  3. Higher Costs: Purchase and operational expenses for DBMS can be significant.

Importance of Database Systems

  • Track transactions for suppliers, orders, customer records, and employee payments.

  • Assist in managerial decision-making for product popularity and profitability.

  • Support capabilities for analyzing data and implementing data warehousing and mining.

Data Management Example

  • Developed using MS Access: Sales order report screen.

Database Content

  • Databases store more than text/numbers; e.g., real estate databases display property images along with details.

Hierarchy of Data

  • Character: Basic information unit (e.g., letters, digits).

  • Field: Descriptive names or identifiers (e.g., 'John Doe').

  • Record: Collection of related data fields.

  • File: Collection of related records.

  • Database: Organized collection of files.

Database Views

  • Multiple user-specific views from the same database (e.g., HR manager vs. Payroll personnel).

Relational Database Example

  • Tables highlighting data relationships, such as Customers, Rentals, and Titles within the DVD Rental schema.

Database Applications

  • Today's applications enable the manipulation of database data for strategic business uses, including online access and decision making.

Data Warehouses

  • Data Warehouse: Collects business information across enterprise sources; facilitates multidimensional data analysis.

  • Data Mart: Subset of a data warehouse focusing on specific business areas.

Business Intelligence (BI)

  • Utilizes data warehouses through software tools for meaningful information generation to aid in business decision-making.

  • Includes: OLAP for multidimensional data analysis, and data mining for finding patterns and relationships in data.

Summary

  • Overview of traditional file organization, database approach, DBMS examples, data warehouses, and business intelligence concepts.

The End.