Chapter1 - Database Management Systems, R. Ramakrishnan and...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Database Management Systems, R. Ramakrishnan and J. Gehrke Introduction to Database Systems Chapter 1 Instructor: Johannes Gehrke johannes@cs.cornell.edu Database Management Systems, R. Ramakrishnan and J. Gehrke What Is a DBMS? A very large, integrated collection of data. Models real-world enterprise. Entities (e.g., students, courses) Relationships (e.g., Susan is taking COP4710) A Database Management System (DBMS) is a software package designed to store and manage databases. Database Management Systems, R. Ramakrishnan and J. Gehrke Why Use a DBMS? Data independence and efficient access. Reduced application development time. Data integrity and security. Uniform data administration. Concurrent access, recovery from crashes. Database Management Systems, R. Ramakrishnan and J. Gehrke Why Study Databases?? Shift from computation to information at the low end: scramble to webspace (a mess!) at the high end: scientific applications Datasets increasing in diversity and volume. Digital libraries, interactive video, Human Genome project, EOS project ... need for DBMS exploding DBMS encompasses most of CS OS, languages, theory, AI, multimedia, logic ? Database Management Systems, R. Ramakrishnan and J. Gehrke Data Models A data model is a collection of concepts for describing data. A schema is a description of a particular collection of data, using a given data model. The relational model of data is the most widely used model today. Main concept: relation , basically a table with rows and columns. Database Management Systems, R. Ramakrishnan and J. Gehrke Levels of Abstraction Many views , single conceptual (logical) schema and physical schema ....
View Full Document

Page1 / 16

Chapter1 - Database Management Systems, R. Ramakrishnan and...

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