Computer Science 380:

Principles of Database Systems

Chapter 1

Gregory M. Kapfhammer


creative commons licensed ( BY-NC-SA ) flickr photo shared by danmachold

Data Management

Important Questions

How much data ...

... is there in the world today?

... is being produced on a daily basis?

... can we reliably store in digital media?

Relational Databases

Important Questions!

What are some ...

... common relational databases management systems?

... well-known types of applications that use databases?

... good reasons for using a relational database?

Common Ground

What is a ...

database ?

database management system (DBMS) ?

file processing system (FPS) ?


creative commons licensed ( BY-NC-SA ) flickr photo shared by M.Y

Data Management Trade-Offs

Which method is better?

What are the advantages and disadvantages?

What are the evaluation metrics?

File Processing Systems

What are the disadvantages?

Data redundancy and inconsistency

Difficulty in accessing the data

Many locations and formats

Data integrity problems

Atomicity concerns

Concurrency challenges

Serious security problems


creative commons licensed ( BY-NC ) flickr photo shared by Domiriel

Focus and Choice

Both FPSs and DBMSs have their place

We will implement and evaluate both

Pick the best at handling the current challenge

Let's first investigate the relational database!

Levels of Data Management

View: describes parts of the data

Logical: what data is stored and relationships

Physical: how the data is stored on the disk

Schema and Instances

A distinction between structure and state!

Database Models

Relational

Object

Semi-structured

Database Languages

SQL: Structured query language

DDL: Data definition language

DML: Data manipulation language

SQL = DDL + DML

Imperative versus declarative languages

Database Applications

Program and a host language

Relational database

Relational database management system

Database interaction point

Entity-Relationship Models

Normalization

Meaning of and view on null values

Object-relational mapping

Java query languages (JoSQL and JQL)

Database Architecture

Query processor

Storage manager

Two-tier and three-tier architecture

Advantages and disadvantages?

"Keep the computation close to the data"


creative commons licensed ( BY ) flickr photo shared by Light Painting

Learning More

SIGMOD

PODS

TODS

VLDB

CIDR


creative commons licensed ( BY ) flickr photo shared by Light Painting