StanfordOnline: Databases: Modeling and Theory 01. introduction
https://www.edx.org/course/modeling-and-theory
StanfordOnline: Databases: Modeling and Theory | edX
This course is one of five self-paced courses on the topic of Databases, originating as one of Stanford's three inaugural massive open online courses released in the fall of 2011. The original "Databases" courses are now all available on edx.org. This cour
www.edx.org
* 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.
