rdb

Relational Database

ACID

  • Atomicity
  • Consistency
  • Isolation
  • Durability

Normalization

  • 1NF: atomic value
  • 2NF
  • 3NF
  • BCNF

Join

Logical Join

  • innter join
  • outer join
  • cross join

Physical Join

  • Nested Loop Join
  • Sort Merge Join
  • Hash Match Join

Index


written by keyolk on 25/07/2018
comments powered by Disqus