Data resource management l.jpg
This presentation is the property of its rightful owner.
Sponsored Links
1 / 43

Data Resource Management PowerPoint PPT Presentation


  • 79 Views
  • Uploaded on
  • Presentation posted in: General

3. Data Resource Management. Learning Objectives. 3. Explain the importance of implementing data resource management processes and technologies in an organization. Understand the advantages of a database management approach to managing the data resources of a business.

Download Presentation

Data Resource Management

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Data resource management l.jpg

3

Data Resource Management


Learning objectives l.jpg

Learning Objectives

3

  • Explain the importance of implementing data resource management processes and technologies in an organization.

  • Understand the advantages of a database management approach to managing the data resources of a business.


Slide3 l.jpg

Learning Objectives (continued)

3

  • Explain how database management software helps business professionals and supports the operations and management of a business.

  • Illustrate each of the following concepts:

    • Major types of databases

    • Data warehouses and data mining

    • Logical data elements

    • Fundamental database structures

    • Database access methods

    • Database development


Section i l.jpg

Section I

3

  • Managing Data Resources


Data resource management5 l.jpg

Data Resource Management

3

  • A managerial activity

  • Applies information systems technology to managing data resources to meet needs of business stakeholders.


Foundation data concepts l.jpg

Foundation Data Concepts

3

  • Logical Data Elements


Slide7 l.jpg

3

Foundation Data Concepts (continued)

  • Levels of data

    • Character

      • Single alphabetical, numeric, or other symbol

    • Field

      • Groupings of characters

      • Represents an attribute of some entity


Foundation data concepts continued l.jpg

Foundation Data Concepts (continued)

3

  • Records

    • Related fields of data

    • Collection of attributes that describe an entity

    • Fixed-length or variable-length


Slide9 l.jpg

3

Foundation Data Concepts (continued)

  • Files (table)

    • A group of related records

    • Classified by

      • Primary use

      • Type of data

      • permanence


Slide10 l.jpg

3

Foundation Data Concepts (continued)

  • Database

    • Integrated collection of logically related data elements

    • Consolidates records into a common pool of data elements

    • Data is independent of the application program using them and type of storage device


Types of databases l.jpg

Types of Databases

3

  • Operational

    • Supports business processes and operations

    • Also called subject-area databases, transaction databases, and production databases


Types of databases continued l.jpg

Types of Databases (continued)

3

  • Distributed

    • Replicated and distributed copies or parts of databases on network servers at a variety of sites.

    • Done to improve database performance and security


Slide13 l.jpg

Types of Databases (continued)

3

  • External

    • Available for a fee from commercial sources or with or without charge on the Internet or World Wide Web

  • Hypermedia

    • Hyperlinked pages of multimedia


Data warehouses and data mining l.jpg

Data Warehouses and Data Mining

3

  • Data warehouse

    • Stores data extracted from operational, external, or other databases of an organization

    • Central source of “structured” data

    • May be subdivided into data marts


Data warehouses and data mining continued l.jpg

Data Warehouses and Data Mining (continued)

3

  • Data mining

    • A major use of data warehouse databases

    • Data is analyzed to reveal hidden correlations, patterns, and trends


Database management approach l.jpg

Database Management Approach

3

  • Consolidates data records and objects into databases that can be accessed by many different application programs


Database management approach continued l.jpg

Database Management Approach (continued)

3

  • Database Management System

    • Software interface between users and databases

    • Controls creation, maintenance, and use of the database


Slide18 l.jpg

3

Database Management Approach (continued)


Slide19 l.jpg

3

Database Management Approach (continued)

  • Database Interrogation

    • Query

      • Supports ad hoc requests

      • Tells the software how you want to organize the data

      • SQL queries

      • Graphical (GUI) & natural queries


Slide20 l.jpg

3

Database Management Approach (continued)

  • Report Generator

    • Turns results of query into a useable report

  • Database Maintenance

    • Updating and correcting data


  • Slide21 l.jpg

    3

    Database Management Approach (continued)

    • Application Development

      • Data manipulation language

      • Data entry screens, forms, reports, or web pages


    Implementing data resource management l.jpg

    Implementing Data Resource Management

    3

    • Database Administration

      • Develop and maintain the data dictionary

      • Design and monitor performance of databases

      • Enforce database use and security standards


    Implementing data resource management continued l.jpg

    Implementing Data Resource Management (continued)

    3

    • Data Planning

      • Corporate planning and analysis function

      • Developing the overall data architecture


    Slide24 l.jpg

    Implementing Data Resource Management (continued)

    3

    • Data Administration

      • Standardize collection, storage, and dissemination of data to end users

      • Focused on supporting business processes and strategic business objectives

      • May include developing policy and setting standards


    Slide25 l.jpg

    Implementing Data Resource Management (continued)

    3

    • Challenges

      • Technologically complex

      • Vast amounts of data

      • Vulnerability to fraud, errors, and failures


    Section ii l.jpg

    Section II

    3

    • Technical Foundations of Database Management


    Database structures l.jpg

    Database Structures

    3

    • Hierarchical

      • Treelike

      • One-to-many relationship

      • Used for structured, routine types of transaction processing


    Database structures continued l.jpg

    Database Structures (continued)

    3

    • Network

      • More complex

      • Many-to-many relationship

      • More flexible but doesn’t support ad hoc requests well


    Slide29 l.jpg

    Database Structures (continued)

    3

    • Relational

      • Data elements stored in simple tables

      • Can link data elements from various tables

      • Very supportive of ad hoc requests but slower at processing large amounts of data than hierarchical or network models


    Slide30 l.jpg

    Database Structures (continued)

    3

    • Multi-Dimensional

      • A variation of the relational model

      • Cubes of data and cubes within cubes

      • Popular for online analytical processing (OLAP) applications


    Slide31 l.jpg

    Database Structures (continued)

    3


    Slide32 l.jpg

    Database Structures (continued)

    3

    • Object-oriented

      • Key technology of multimedia web-based applications

      • Good for complex, high-volume applications


    Slide33 l.jpg

    Database Structures (continued)

    3


    Accessing databases l.jpg

    Accessing Databases

    3

    • Key fields (primary key)

      • A field unique to each record so it can be distinguished from all other records in a table


    Accessing databases continued l.jpg

    Accessing Databases (continued)

    3

    • Sequential access

      • Data is stored and accessed in a sequence according to a key field

      • Good for periodic processing of a large volume of data, but updating with new transactions can be troublesome


    Slide36 l.jpg

    Accessing Databases (continued)

    3

    • Direct access

      • Methods

        • Key transformation

        • Index

        • Indexed sequential access


    Database development l.jpg

    Database Development

    3

    • Data dictionary

      • Directory containing metadata (data about data)

        • Structure

        • Data elements

        • Interrelationships

        • Information regarding access and use

        • Maintenance & security issues


    Database development continued l.jpg

    Database Development (continued)

    3

    • Data Planning & Database Design

      • Planning & Design Process

        • Enterprise model

        • Entity relationship diagrams (ERDs)

        • Data modeling

          • Develop logical framework for the physical design


    Discussion questions l.jpg

    Discussion Questions

    3

    • How should an e-business enterprise store, access, and distribute data & information about their internal operations & external environment?

    • What roles do database management, data administration, and data planning play in managing data as a business resource?


    Discussion questions continued l.jpg

    Discussion Questions (continued)

    3

    • What are the advantages of a database management approach to organizing, accessing, and managing an organization’s data resources?

    • What is the role of a database management system in an e-business information system?


    Slide41 l.jpg

    Discussion Questions (continued)

    3

    • Databases of information about a firm’s internal operations were formerly the only databases that were considered to be important to a business. What other kinds of databases are important for a business today?

    • What are the benefits and limitations of the relational database model for business applications?


    Slide42 l.jpg

    Discussion Questions (continued)

    3

    • Why is the object-oriented database model gaining acceptance for developing applications and managing the hypermedia databases at business websites?

    • How have the Internet, intranets, extranets, and the World Wide Web affected the types and uses of data resources available to business end users?


    References l.jpg

    References

    3

    • James A. O'Brien; George M. Marakas. Management Information Systems: Managing Information Technology in the Business Enterprise 6th Ed., Boston: McGraw-Hill/ Irwin,2004


  • Login