-
A group of related records
File
-
A set of fields whose data values describe one entity
Record
-
A row in a data base
Tuple
-
Attributes in a data base
Column
-
Each individual cell in database
Field
-
Set of related, centrally data files, with little redundancy
Database
-
Program that manages and controls the data and interface between the data and the application program that uses the data stored in the DB
Database Management System (DBMS)
-
DB, DBMS, the application programs that access the database through the DBMS
Database system
-
this person is responsible for the coordination, controlling, and managing the DB.
Database Administrator
-
is one or more very large DB containing both the detailed and summarized data for the number of years that is used for analysis rather than transaction processing
DW
-
analyzing large amounts of data for strategic decision making
Business Intelligence (BI)
-
using queries to investigate hypothesize relationship among data
Online Analytical Process (OLAP)
-
sophisticated analysis used to discover relationship
Data Mining
-
Proper Controls
- -Scrubbing: verifying the data's accuracy
- - Restrict access and data encryption
- - regularly backing up the data
|
|