Data Base Management

for the first exam, review notes on laptop

Data

raw, unorganized facts

Information

processed, contextualized data

Knowledge

Contextualized information applied with experience

Wisdom

sound judgement and action based on knowledge

Data silo

an isolated repository accessible to only one department or application, leading to duplication, inconsistency, and lack of transparency

DBMS

optimized for day-to-day transactional processing and fast read/writes

Data Warehouse

optimized for complex reporting, historical, and aggregation

sql

structured query language for databases

ETL

extract transform, load pipeline

Data Mining

discovering hidden patterns in large datasets

Vizulaization

graphical representation of data

Data Governance

The overall management of data availability, usability, integrity, compliance, and security across an organization.

Waterfall method

requirements, design, implementation, verification, maintenance

data consistency

field values through the entire database is exactly the same

Data Integrity

A set of rules or guidelines that governs the validity, consistency, and accuracy of the data in a database.

Entity Integrity

No duplicate rows

Domain Intergrity

Primary Keys

Unique key at the beginning of a table

Foreign Key

primary key in another table

Composite Primary Key

multiple fields or attributes that create a primary key

Text

For storing non-numeric data that is brief, generally under 256 characters

Number

For storing numbers. There are usually a few different number types that can be selected, depending on how large the largest number will be,

Boolean

a data type with two possible values (1,0)

Date

a special form of the number data type that can be interpreted as a date

Time

numerical data type that can be interpreted as a date

long text

text over 256 characters

char

fixed length text, does not contain numbers

varchar

fixed length text that contains text and numbers

fload

for decimal numbers