StanfordOnline: Databases: Modeling and Theory 01. introduction

https://www.edx.org/course/modeling-and-theory

StanfordOnline: Databases: Modeling and Theory | edX

 

* Physical Data Independence

The operations on the data are independent from the way the data is laid out.

 

* high level query language

declarative: you describe what you want out of the database but you don't need to describe the algorithm to get the data out

 

* 부동산에서 location(입지)이 제일 중요한 것처럼,

데이터베이스에서는 performance(성능)가 제일 중요하다.

 

* middleware: 웹 서버 등등이 데이터베이스와 애플리케이션이 인터렉션하는데 도움을 줄 수 있다

 

 

* data model

a description of how the data is structured.

In the relational data model, the data and the database is thought of as a set of records.

 

* schema

sets up the structure of the database

 

* The data is the actual data stored within the schema.