MIS Chap 5 - Data Resource Management

What is Database Management Approach designed to replace ?

Overcome the limitations of traditional file-based system

• Independent files are integrated in a database of various application programs and can be used for storage and information retrieval

What is a Database ?

• collection of logically related data which has a specific meaning and purpose

• allows access, retrieval, modification and use of the data

• created using database software

What are the pros of Database ?

• reduces data redundancy, data isolation and data inconsistency

• maximizes data security, data integrity and independence

What are the 4 major operations of DBMS ?

• Creating and entering data into the database

• Accessing data in the database

• Querying data from the database

• Displaying data from the database

What is Data Model ?

• A collection of interrelated data which is used to identify, control and organize data based on the users’ perspective

• Contains the basic concepts of a database so that end-users and programmers can understand and manipulate the data easily

What are the 3 categories of Data Model ?

• Object-based data model

• Record-based data model

• Physical data model

What is Object-based Data Model ?

Refers to entities, attributes and relationship.

• entity is an object which describes a person, things or events

• attributes are the elements or behaviours of the entity that has been described

• relationship is the connection between two or more entities by the attribute.

What is Record-based Data Model ?

Also KA logical data model

• Consist of Relational, Multidimensional, Network and Hierarchical Data Model

Which is better in terms of size capacity, time of access, and ease of data searching ? Multidimensional or Relational ?

Multidimensional

What is Physical Data Model ?

• Refers to data storage and information process

• These models are not commonly used to compare to logical data models

What is a Data Warehouse ?

Huge storage which is used to store large databases

• Data can be accessed faster and effectively

• Scattered in many different locations using a network connection

• Multidimensional data models are used to store data

• Data in a data warehouse remains once stored

What is OLTP ?

Stands for Online Transaction Processing

• transactions are processed online as soon as it happens

What is OLAP ?

Stands for Online Analytical Processing

• involves analysis of collected data by end-users

What is the advantages of Data Warehouses ?

• End-users can access data easily and quickly

• Data can be analysed accurately and efficiently

What is Data Mart designed for ?

End-users in a small company or department

Differences Between Data Warehouses and Data Mart

DW :

• Larger, More Expensive, Slower Access

DM :

• (Contrary)

What is Data Mining/OLAP and what does it achive ?

Process of accessing and analyzing data in a data warehouse or data mart

• large data are stored in data warehouses, to minimize the process, data mining or OLAP is used to extract data for easier access

Difference between Data Mining & OLAP

• Data Mining : discovers hidden patterns and operates on a more detailed level.

• OLAP : provides a summary of the data and generates rich calculations

However, they both can be ulitized together due to being complementary

What is a Cloud Database ?

• A database that typically runs on a cloud computing platform.

• Hosted by a third-party service provider on a remote server and accessed over the Internet

• Runs on a cloud provider’s platform and data can only be stored or accessed when there is an Internet connection.

What are the Advantages and Disadvantages of Cloud Database ?

• Pros : Easy access, easy to install and maintain scalability, Security

• Cons : Expensive, Inflexible Configuration Setting

What is Data Centre ?

A centralized physical space dedicated to storing data in organizations

• Data centre stores data within an organization’s local network, while cloud computing stores data on the Internet.