seoul accord - day1

◆ Database ~ set of data

◆ DBMS

  - OLTP --- Transaction

  - OLAP --- Analysis

  - tpc --- DBMS 벤치마크 사이트 : http://www.tpc.org/

 

◆ File system 문제점

  - Redundancy <-> consistency

  - dependency

  - integrity

 

◆ NoSQL

 

◆ Relational Model

  - Data Model --- 어떤 형태로? 데이터마다 적합 모델은 따로 !

  - schema --- logical structure of DB

    * instance --- actual contents at a particular point in time

    * null --- * unknown, undefined

  - relational model --- " relation ":set --- (수학적) 집합

    : set of tuples / set of attributes 

    : Domain, Attribute, Tuple, Relation, Database

 

  ◇ Key 

     - http://mirai_neco.blog.me/110150068760

     - superkey

     - candidate key

     - primary key ~ *entity integrity

     - foreign key ~ * referential integrity

 

   - 

 

 

◆◆◆◆◆◆◆◆◆◆◆◆◆◆◆◆◆◆◆◆◆◆◆

 

 

데이터베이스론 참고

http://tistory.izyou.net/2460960