Thursday, June 26, 2014

Episode 34: Databases


Download

News
Book of the Show
Tool of the Show

Databases
  • Flat Files vs. Databases
  • Motivation (Why use a database)
    • Reverse-Indexing
    • Caching
    • Redundancy
    • Scalability
    • Segmentation
    • Analysis
    • Validation
  • Consistency
    • ACID
    • Eventually Consistent
  • Types
    • Relational Databases
      • SQL (Structured Query Language)
    • NoSQL Databases
      • Key/Value Store
      • Column-Family (Key / MultiValue)
      • Document Store
  • Implementations
    • Embedded
      • SQLite (Relational)
      • BerkeleyDB / MapDB (Key/Value)
    • In-Memory Server Database
      • memcached (Key/Value)
      • Redis (Key/Value)
    • Disk-Based Server Database
      • MySQL / Postgres (Structured)
      • HBase / Cassandra  (Column-Family)
      • MongoDB / RethinkDB (Document)