Implementation of DATABASE MANAGEMENT SYSTEMS

1
Implementation of DATABASE MANAGEMENT SYSTEMS
Krithi Ramamritham
2
WHY DATABASES?
(WHY NOT FILE SYSTEMS?)

• AVOIDING REDUNDANCY
• ENSURING CONSISTENCY
• IMPROVING EASE OF ACCESS TO DATA
• ALLEVIATING
• CONCURRENCY
• INTEGRITY
• SECURITY
• PROBLEMS

3
Why should you learn about DBMS?

• Databases are everywhere
• Banks, industry, personnel, libraries
• CAD/CAM
• Network switches, web servers
• Sensors
• Handheld devices

4
Technology and Usage Trends

• A large age of the data is outside the box
• Heterogeneity
• A typical company has 100s of DBs inter
  operating within the company
• Automobiles of tomorrow will be driven by
  information rather than by humans
• different vendors, platforms, needs
• Data Warehousing and mining
• a db never forgets, it knows more than you think
• All the data All the time
• Application - aware information management
• - mobility - enterprise
  management
• - E-commerce - Workflows

5
Why should you learn about DBMSImplementation?

• Database implementations techniques provide
  valuable lessons in key concepts of
• query processing
• concurrency and recovery
• storage structures
• performance tuning

6

• GOAL OF COURSE
• STUDY DATABASE SYSTEMS FROM A SYSTEMS
• PERSPECTIVE
• UNDERSTAND THE INNARDS OF A DBMS
• KEEP - IMPLIMENTABILITY
• - COST
• - PERFORMANCE
• IN THE FOREFRONT

7
COURSE CONTENTS

• REVIEW OF RELATIONAL MODEL
• STORAGE AND FILE STRUCTURES
• EFFICIENCY OF ACCESS
• INDEXING, HASHING
• QUERY PROCESSING Optimization
• TRANSACTIONS
• CONCURRENCY CONTROL
• RECOVERY
• COMMIT PROTOCOLS

8
cont....

• DBMS FOR DIFFERENT ARCH.
• PARALLEL
• DISTRIBUTED
• CLIENT-SERVER
• mobile
• e-commerce
• sensor databases
• data warehouses

9
WHAT YOU NEED TO DO

• Participate in in-class discussions
• -- lectures
• -- tutorials (code walk-thrus)
• 2. Do quizzes (in-class) n-1/n
• 3. Do mid-sem exam
• 4. Do Project/homework/assignments
• 5. Write final exam