Session1

Session1 - Database Management Systems Session 1(CSCI-585 Instructor Cyrus Shahabi [email protected] Database Management Systems 3ed R Ramakrishnan

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Database Management Systems 3ed, R. Ramakrishnan and J. Gehrke 1 Database Management Systems Session 1 (CSCI-585) Instructor: Cyrus Shahabi [email protected]
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Database Management Systems 3ed, R. Ramakrishnan and J. Gehrke 2 What Is a DBMS? x A very large, integrated collection of data. x Models real-world enterprise. s Entities (e.g., students, courses) s Relationships (e.g., Madonna is taking CS564) x A Database Management System (DBMS) is a software package designed to store and manage databases.
Background image of page 2
Database Management Systems 3ed, R. Ramakrishnan and J. Gehrke 3 Files vs. DBMS x Application must stage large datasets between main memory and secondary storage (e.g., buffering, page-oriented access, 32-bit addressing, etc.) x Special code for different queries x Must protect data from inconsistency due to multiple concurrent users x Crash recovery x Security and access control
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Database Management Systems 3ed, R. Ramakrishnan and J. Gehrke 4 Why Use a DBMS? x Data independence and efficient access. x Reduced application development time. x Data integrity and security. x Uniform data administration. x Concurrent access, recovery from crashes.
Background image of page 4
Database Management Systems 3ed, R. Ramakrishnan and J. Gehrke 5 Why Study Databases?? x Shift from computation to information s at the “low end”: scramble to webspace (a mess!) s at the “high end”: scientific applications x Datasets increasing in diversity and volume. s Digital libraries, interactive video, Human Genome project, EOS project s ... need for DBMS exploding x DBMS encompasses most of CS s OS, languages, theory, AI, multimedia, logic ?
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Database Management Systems 3ed, R. Ramakrishnan and J. Gehrke 6 Data Models x A data model is a collection of concepts for describing data. x A schema is a description of a particular collection of data, using the a given data model. x
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

This document was uploaded on 05/16/2010.

Page1 / 17

Session1 - Database Management Systems Session 1(CSCI-585 Instructor Cyrus Shahabi [email protected] Database Management Systems 3ed R Ramakrishnan

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online