RDBMS
(Relational Data-Base Management System)
terminology
design phases and techniques
types of data and information found in organizations
levels
formats
granularities
Transactional Data
all of the data contained within a single business process
primary purpose is to support performing daily operational tasks
Analytical Information
all organizational information and its primary purpose is to support the performance of higher-level analysis tasks
functions of database management systems
data filtering and profiling
data quality
data synchronization
data enrichment
data maintenance
Relational DBMS
represent data as two dimensional tables called relations or files
Physical/logical view of data
how data is organized
how data appearss
entity
entity class
attributes
rows
tables
columns
Data Definition Language (DDL)
data dictionary
Data Manipulation Language (DML)
used to manipulate data
used to get data into and out of a database
operations of a relational DBMS
select
Join
project
Master data (attributes)
describes the core entities of the enterprise
transaction data (specific)
activities or transactions
Binaey Large Objects (BLOB)
digitized image and multimedia
typical database design phases
requirement gathering
report design
data design
table design
form design
Entity-Relationship Diagram (ERD)
methodology for documenting databases illustrating relationships between database entities
a key tool employed in the design of databases
ERD parts
entity
relationship
connectivity
cardinality
business rules
Query
set of instructions
select
criterion
parameter
database normalization
process of removing redundant data from your tables tom improve storage efficiency, data integrity, and scalability
usually involves splitting existing tables into multiple ones
three basic query operations to develop useful sets of data
select
join
project
structured query language (SQL)
most popular query language
perform complicated searches by using relatively simple statements or key words
DBMS products fall into two categories
enterprise DBMS
personal/desktop dbms
Data warehouses/data marts
used for business decision-making purposes, data from many sources and over many time periods must be gathered together and organized in a consistent and useful way
ETL
extraction, transformation, and loading
characteristics of a data warehouse
organized by business dimension or subject
use inline analytical processing
integrated
time variant
non-volatile
multidimensional