Untitled

Data Management

1. Objectives

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

2. Outcomes

   • Be able to explain how database management software can help business operations
   • Be able to describe the different between database, data warehouse and data mining
   • Be able to explain data management principles
   • Demonstrate knowledge of a database systems

3. Foundation Of Data

   • Characters
   • Fields
   • Records
   • Files

4. Levels Of Abstraction

   • Many views, single logical schema and physical schema
   • Views describe how users see the data
   • Conceptual schema defines logical structure
   • Physical schema describes the files and indexes used

5. Big Data

   • Some real-world examples
   • 5 V

6. Roles & Responsibilities

   • Database Administration
   •  Data Planners
   •  Data Administration

7. Principles

   • Data must be represented and stored so that it can be accessed later
   • Data must be organized so that it can be selectively and efficiently accessed
   • Data must be protected and managed so that it will retain value
   • Data must be processed and presented so that it supports the user effectively

8. Database

   • Database Management System (DBMS) is a software package designed to store and manage databases
   • Database (DB) is an integrated collection of logically related data elements
   • Benefits Of DBMS
   • Components of DBMS

9. Traditional Files

   • vs. Database -1
     • Before the invention of the computer, files and records were kept as paper documents and stored in several file cabinets
     • Data redundancy, Data inconsistency, Data isolation, Data integrity, Security
   • vs. Database -2
     • The use of computers, especially databases, helps organize files and records, and computing storage updates and retrieval are much easier
     • Minimal data redundancy, Data consistency, Integration of data, Sharing of data , Data independence, Uniform security, privacy and integrity