Course Introduction
Introduction to Databases
Instructor: Joe Bockhorst
University of Wisconsin - Milwaukee
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Guidelines and tips
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Storage Space-Introduction to Databases-Tutorial 02-Computer Science, Study Guides, Projects, Research of Introduction to Database Management Systems
Storage Space, Data is Ubiquitous, Processor Speeds, Memory Speeds, Sensors, Hard Drive Capacity, Moore's Law, Microarrays, Data Examples, Data Management, Database Management System, DBMS, Relational Database, RDBMS, Internet Movie Database, IMDB, Physical Data Model, Querying the Database, Implementing Queries, Query Optimization, Integrity of Database, Control Abstraction, Data Abstraction
Typology: Study Guides, Projects, Research
2011/2012
1 / 31
This page cannot be seen from the preview
Don't miss anything!
Related documents
Partial preview of the text
Download Storage Space-Introduction to Databases-Tutorial 02-Computer Science and more Study Guides, Projects, Research Introduction to Database Management Systems in PDF only on Docsity!
Course Introduction
Introduction to DatabasesInstructor: Joe Bockhorst
University of Wisconsin - Milwaukee
First Reading Assignment
•^
Chapters 1 and 2 (today and part of Thursday)Chapter 13 and handout
Data is Ubiquitous
•^
Three classes of technological advances arechanging our relationship with data:
•^
More storage space–^
allows us to keep more data
•^
Faster processor (and memory) speeds–^
allows us to access and process more data
•^
Different “sensors”–^
allows us to access new kinds of data
http://en.wikipedia.org/wiki/Hard_disk
Microarrays – An Example of a
New Sensing Technology
The color of eachspot represents theactivity level of a gene
under some
experimentalcondition10 000s of spotson a single chip
A microarray
Other Data Examples
•^
Airline flight management system
-^
Financial data
-^
Commercial store (eg, WalMart) data
-^
Department of Motor Vehicles
-^
Surveillance video
-^
University student records
-^
Baseball results
-^
Web sites
-^
Medical records
-^
Database Management System (DBMS)
•^
DBMS is:– A collection of software programs– General purpose
•^
DBMS enables users to:– Define DB– Construct DB– Change (or update) DB– Ask questions about the data in DB– Share DB
•^
DBMS maintains the integrity of DB
Some RDBM Systems
Commercial Systems Oracle ($$$$)DB2 (IBM) ($$$)SQL Server (Microsoft) ($$) Open Source Systems PostgreSQLMySQL
Source: International Data Corporation
catalog
Databases are self-describing: catalog describesthe structure of the data stored in the DB
Example: Internet Movie Database (IMDB)
Building a DB:
Define DB
Schema
•^
A schema describes DB using
data model
supported by DMBS (eg,
relational model)
•^
RDBMS – DBMS that supports relational model
Rating
Director
Title
MID
Bday
Name
PID
Rtype
Role
PID
MID MOVIE PERSONACTS_IN
A Schema Diagram for “University” DB
(from the textbook)
tables
columns
Building a DB:Populate DB
Rating R PG
...
29
Star Wars
2
72
The Big Lebowski
1
Director
Title
MID
...
7/13/
Harrison Ford
2
12/4/
Jeff Daniels
1
Bday
Name
PID
...
CO_STAR
Han Solo
2
2
STAR
The Dude
1
1
Rtype
Role
PID
MOVIE MID
PERSON
ACTS_IN
Set initial records of the DB
Querying The Database
•^
Most RDBMS allow users to query the databaseusing SQL (structured query language)
•^
Example: get cast of “The Big Lebowski”
SELECT
Name, Role, Rtype