Gregory M. Kapfhammer
How much data ...
... is there in the world today?
... is being produced on a daily basis?
... can we reliably store in digital media?
What are some ...
... common relational databases management systems?
... well-known types of applications that use databases?
... good reasons for using a relational database?
What is a ...
database management system (DBMS) ?
file processing system (FPS) ?
Which method is better?
What are the advantages and disadvantages?
What are the evaluation metrics?
What are the disadvantages?
Data redundancy and inconsistency
Difficulty in accessing the data
Many locations and formats
Data integrity problems
Serious security problems
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!
View: describes parts of the data
Logical: what data is stored and relationships
Physical: how the data is stored on the disk
A distinction between structure and state!
SQL: Structured query language
DDL: Data definition language
DML: Data manipulation language
SQL = DDL + DML
Imperative versus declarative languages
Program and a host language
Relational database management system
Database interaction point
Meaning of and view on null values
Java query languages (JoSQL and JQL)
Two-tier and three-tier architecture
Advantages and disadvantages?
"Keep the computation close to the data"