Introduction to Databases

Introduction to Databases

1. Data

   • raw info
     • used in application systems
       • online purchases
       • elearning
       • social media

2. File system

   • each program
     • manages own data
   • limitations
     • fixed query
     • separates data
     • duplicates data
     • data dependance
     • incompatible formats

3. DBMS

   • database system
     • create
     • organize
     • manages
   • Advantage
     • Data consistency
     • Concurrency
     • Backup
     • Flexibiity
     • Redunduncy control
   • Disadvantage
     • complexity
     • size
     • cost
     • performance

4. DB: structured collection of related info organized for multiple usage

   • components
     • people
     • hardware
     • software
     • procedure
     • data