rahul

rahul.naskar@gmail.com

RDBMS

Spreadsheets

Things that are good

  1. Fast, Flexible
  2. Easy, Pretty Easy…
  3. Distribution is relatively easy
  4. Little infrastructure
  5. Personal Manager - Expenses, Books…
  6. Visualization (Charts and what not)
  7. Reporting

Things that are difficult…

  1. Large Volume
  2. Multiple Access
  3. Real Time (No pun, intended)
  4. Enforce Rules (AKA Constraints)
  5. Integrity (AKA Organized, No Duplicate)

Things that are impossible…

  1. Facebook

RDBMS to rescue

The concepts

  1. The TABLE - A Structural Definition (Relation)
  2. Columns - The Horizontal Axis of a Matrix
  3. Attribute - Christened Columns
  4. Rows/Tuples - The Vertical Axis of a Matrix

rdbmsconcept.png

The Benefits

  1. It's Organized - Logically
  2. Avoids Redundancy - No Duplication
  3. Enforces Integrity - Rules
  4. Transform - Gives Snapshots of Use
  5. Storage & Optimization

An example

Bibliography

Summing it up

  1. [ ] Review
    1. [ ] Databases
      1. [ ] Types of databases
    2. [ ] Models
      1. [ ] What are the newer trends of data models
    3. [ ] Design
      1. [ ] What will be the structural design of your music database

See you on 3rd…

rahul.naskar@gmail.com