Introduction to Database Systems Module 1, Lecture 1
Introduction to Database Systems Module 1, Lecture 1
Instructor: Raghu Ramakrishnan raghu@cs.wisc.edu UW-Madison
Database Management Systems, R. Ramakrishnan
1
What Is a DBMS?
y A very large, integrated collection of data.
y Models real-world enterprise.
? Entities (e.g., students, courses) ? Relationships (e.g., Madonna is taking CS564)
y A Database Management System (DBMS) is a software package designed to store and manage databases.
Database Management Systems, R. Ramakrishnan
2
Why Use a DBMS?
y Data independence and efficient access. y Reduced application development time. y Data integrity and security. y Uniform data administration. y Concurrent access, recovery from crashes.
Database Management Systems, R. Ramakrishnan
3
?
Why Study Databases??
y Shift from computation to information
? at the "low end": scramble to webspace (a mess!) ? at the "high end": scientific applications
y Datasets increasing in diversity and volume.
? Digital libraries, interactive video, Human Genome project, EOS project
? ... need for DBMS exploding
y DBMS encompasses most of CS
? OS, languages, theory, "A"I, multimedia, logic
Database Management Systems, R. Ramakrishnan
4
Data Models
y A data model is a collection of concepts for describing data.
y A schema is a description of a particular collection of data, using the a given data model.
y The relational model of data is the most widely used model today.
? Main concept: relation, basically a table with rows and columns.
? Every relation has a schema, which describes the columns, or fields.
Database Management Systems, R. Ramakrishnan
5
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- introduction to information systems pdf
- introduction to philosophy lecture notes
- introduction to management lecture notes
- chap 1 introduction to management
- introduction to information systems textbook
- introduction to information systems 6th
- introduction to computer systems pdf
- introduction to computers lecture notes
- introduction to systems engineering
- introduction to information systems ppt
- introduction to microeconomics lecture notes
- introduction to systems theory