{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Session1 - Database Management Systems Session 1(CSCI-585...

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 Document Right Arrow Icon
Database Management Systems 3ed, R. Ramakrishnan and J. Gehrke 2 What Is a DBMS? xrhombus A very large, integrated collection of data. xrhombus Models real-world enterprise. square4 Entities (e.g., students, courses) square4 Relationships (e.g., Madonna is taking CS564) xrhombus 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 xrhombus Application must stage large datasets between main memory and secondary storage (e.g., buffering, page-oriented access, 32-bit addressing, etc.) xrhombus Special code for different queries xrhombus Must protect data from inconsistency due to multiple concurrent users xrhombus Crash recovery xrhombus 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 Document Right Arrow Icon
Database Management Systems 3ed, R. Ramakrishnan and J. Gehrke 4 Why Use a DBMS? xrhombus Data independence and efficient access. xrhombus Reduced application development time. xrhombus Data integrity and security. xrhombus Uniform data administration. xrhombus Concurrent access, recovery from crashes.
Background image of page 4
Database Management Systems 3ed, R. Ramakrishnan and J. Gehrke 5 Why Study Databases?? xrhombus Shift from computation to information square4 at the “low end”: scramble to webspace (a mess!) square4 at the “high end”: scientific applications xrhombus Datasets increasing in diversity and volume. square4 Digital libraries, interactive video, Human Genome project, EOS project square4 ... need for DBMS exploding xrhombus DBMS encompasses most of CS square4 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 Document Right Arrow Icon
Database Management Systems 3ed, R. Ramakrishnan and J. Gehrke 6 Data Models xrhombus A data model is a collection of concepts for describing data. xrhombus A schema is a description of a particular collection of data, using the a given data model.
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.

{[ snackBarMessage ]}