Please enable JavaScript.
Coggle requires JavaScript to display documents.
Introduction to Database (Types DATABASE (Multiuser database (supports…
Introduction to Database
What is Database?
shared, integrated computer structure that stores a collection of
-
-
-
Types DATABASE
-
-
-
-
Cloud database
Created and maintained using cloud data services that provide defined performance measures for the database
-
Analytical database
Stores historical data and business metrics used exclusively for tactical or strategic decision making
-
Online analytical processing (OLAP)
•Enable retrieving, processing, and modeling data from the data warehouse
Business intelligence: Captures and processes business data to generate information that support decision making
-
-
Flat file
-
Structural independence:File structure is changed without affecting the application’s ability to access the data
-
Data independence: Data storage characteristics is changed without affecting the program’s ability to access the data
Data Redundancy
•Unnecessarilystoring same data at different places
•Islands of information: Scattered data locations
•Poor data security
•Data inconsistency
•Increased likelihood of data-entry errors when complex entries are made in different files
•Data anomaly: Develops when not all of the required changes in the redundant data are made successfully
-