implementation of database management systems n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Implementation of DATABASE MANAGEMENT SYSTEMS PowerPoint Presentation
Download Presentation
Implementation of DATABASE MANAGEMENT SYSTEMS

Loading in 2 Seconds...

play fullscreen
1 / 9

Implementation of DATABASE MANAGEMENT SYSTEMS - PowerPoint PPT Presentation


  • 67 Views
  • Uploaded on

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?.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Implementation of DATABASE MANAGEMENT SYSTEMS' - brenna-camacho


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
why databases
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
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

- E-commerce - Workflows

Technology and Usage Trends
why should you learn about dbms implementation
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
slide6

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

COURSE CONTENTS
slide8
DBMS FOR DIFFERENT ARCH.

PARALLEL

DISTRIBUTED

CLIENT-SERVER

MAIN MEMORY

mobile

e-commerce

sensor databases

data warehouses

cont....

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

WHAT YOU NEED TO DO