Data Management

Data Management

1. Lecture Learning Objectives

   • Objectives
     • Understand the advantages of a database management.
     • Understand the basic approach to managing the data resources of a business
   • Outcomes
     • Be able to explain data management principles.
     • Demonstrate knowledge of a database systems.
     • 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.

2. The Context of Information Technology

   • Information Technology promotes efficiency and speed by enabling information sharing across the organization, and by removing unnecessary communication and duplication of data.

3. Information Systems Management

   • Management needs information to make a decision. The basic element of all information is the data. The company must collect data from multiple sources (internal and external) and transform it into useful information.
   • Information must be analyzed and presented to decision makers in a format that is relevant to their specific functions.

4. Traditional Files vs. Database

   • 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.
     • problems
       • Data redundancy
       • Data inconsistency
       • Data isolation
       • Data integrity
       • Security
   • Traditional File vs. Database -2
     • The use of computers, especially databases, helps organize files and records, and computing storage updates and retrieval are much easier.
     • Benefits
       • Minimal data redundancy
       • Data consistency
       • Integration of data
       • Sharing of data
       • Data independence
       • Uniform security, privacy and integrity

5. Database

   • Database (DB) is an integrated collection of logically related data elements.
   • A collection of information organized in such a way that a software application can quickly select desired pieces of data.
   • Most databases are organized by fields, records, and files. A field is a single piece of information. A record is one complete set of fields. A file is a collection of records.
   • To access information from a database, you need a Database management system (DBMS). This is a collection of programs that enable you to enter, organize, and select data in a database.

6. Big Data – 5 V

   • Value: refers to our ability turn our data into value.
   • Volume: refers to the vast amount of data generated every second.
   • Variety: refers to the different types of data we can now use.
   • Veracity: refers to the messiness or trustworthiness of the data.
   • Velocity: refers to the speed at which new data is generated and the speed at which data moves around