Please enable JavaScript.
Coggle requires JavaScript to display documents.
Databases & Data Warehouses: Part 1 - Coggle Diagram
Databases & Data Warehouses: Part 1
Business Intelligence (BI)
identify information about customer, competitors,
business partners, environment, and internal operations.
IS information and technologies plays a huge role
for users to make a better business decision
IT Tools
Online Transaction Process (OLTP), gather and
process transaction information
Online Analytical Process (OLAP), allow managers and analyst
to examine and manipulate large amounts data
Databases store latest information about customers,
Data warehouses store history information about the customers
Online Transaction Process
Advantages
It observe daily transaction
Widens customer base of an organization by simplfying individual processes
Disadvantages
If the system failure, the online transaction will get severely affected
Allow multiple users to access which they will change the same data at the same time which could create unprecedented situation
Example
Online Banking
Online Tickets
Online Message
Online Market
Online Analytical Process (OLAP)
Advantages
Creates a single platform
Consistency of information and calculations
Applied security on users to comply with regulations and sensitive data protection
Example
Amazon, analyze purchase by its customers in order to produce a homepage which most likely purchased by its customers
Disavantages
Need IT professional for implementation and maintenance because traditional OLAP tools uses complicated procedure
Need cooperation of people from various department
Logical Views, Data elements and relationship among them
Physical Views, Describe how data are to be stored
Traditional File Processing (TFP), Data are organized, stored, and processed in independent files of data records
Problems of FP
Data Redundency
Lack of Data Integration
Data Dependence
Poor security results from the lack of control
Data sharing is virtually impossible
Relational Database
Create their own table which easier to read and manage
Create a relationship diagram
Database Management System (DBMS)
Software application which uses to create, manage, and administer databases like MySQL, Oracle, and Microsoft SQL Server