Study Set Content:
Why do we need databases? In today’s world, data is?
UBIQUITOUS(ABUNDANT, GLOBAL, EVERYWHERE)
PERVASIVE(UNESCAPABLE, PREVALENT, PERSISTENT)
consists of raw facts.
DATA
the result of processing raw data to reveal its meaning.
INFORMATION
Data is the foundation of information, which is the bedrock of _____ — that is, the body of information and facts about a specific subject.
KNOWLEDGE
a discipline that focuses on the proper generation, storage, and retrieval of data
data management
_____ is a shared, integrated computer structure that stores a collection of the following:
database
the following:
end-user data
metadata
raw facts of interest to the end user
end-user data
data about data, through which the end-user data is integrated and managed
metadata
describes the data characteristics and the set of relationships that links the data found within the database.
metadata
is a collection of programs that manages the database structure and controls access to the data stored in the database.
dbms(database management system)
7 advantages of dbms:
improved data sharing
improved data security
better data integration
minimized data inconsistency
improved data access
improved decision-making
increased end-user productivity
exists when different versions of the same data appears in different places.
data inconsistency
is a comprehensive approach to promoting the accuracy, validity, and timeliness of the data.
data quality
refers to the activities that focus on the design of the database structure that will be used to store and manage end-user data.
database design
4 basic file terminology:
data - raw facts
field - a character or a group of characters
record - connected set of one or more fields
file - a collection of related records
Problems with File System Data Processing. Problems with file systems data processing include:
data redundancy
data anomalies:
- update anomalies
- insertion anomalies
- deletion anomalies
A data abnormality in which inconsistent changes have been made to a database.
data anomaly
refers to an organization of components that define and regulate the collection, storage, management, and use of data within a database environment.
database system
five major parts of database system:
hardware
software
people
procedures
data
three types of software:
operating system software
dbms software
application programms and utilities
