Implementation of DATABASE MANAGEMENT SYSTEMS Krithi Ramamritham WHY
Implementation of DATABASE MANAGEMENT SYSTEMS Krithi Ramamritham
WHY DATABASES? (WHY NOT FILE SYSTEMS? ) • AVOIDING REDUNDANCY • ENSURING CONSISTENCY • IMPROVING EASE OF ACCESS TO DATA • ALLEVIATING –CONCURRENCY –INTEGRITY –SECURITY PROBLEMS
Why should you learn about DBMS? • Databases are everywhere – Banks, industry, personnel, libraries – CAD/CAM – Network switches, web servers – Sensors – Handheld devices
Technology and Usage Trends • A large %age of the data is “outside the box” • Heterogeneity – A typical company has 100’s 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
Why should you learn about DBMS Implementation? • Database implementations techniques provide valuable lessons in key concepts of – query processing – concurrency and recovery – storage structures – performance tuning
GOAL OF COURSE • STUDY DATABASE SYSTEMS FROM A “SYSTEMS PERSPECTIVE” • UNDERSTAND THE “INNARDS” OF A DBMS • KEEP - IMPLIMENTABILITY COST RESOURCES PERFORMANCE IN THE FOREFRONT
COURSE CONTENTS • REVIEW OF RELATIONAL MODEL • • STORAGE AND FILE STRUCTURES EFFICIENCY OF ACCESS – INDEXING, HASHING • QUERY PROCESSING & Optimization • TRANSACTIONS – CONCURRENCY CONTROL – RECOVERY – COMMIT PROTOCOLS
cont. . • DBMS FOR DIFFERENT ARCH. – PARALLEL – DISTRIBUTED – CLIENT-SERVER – MAIN MEMORY – – mobile e-commerce sensor databases data warehouses
WHAT YOU NEED TO DO 1. 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
- Slides: 9