Logo courtesy Wordclouds.com
California State University Stanislaus
CS 4250: Database Management Systems
11:00 - 12:15 pm, Tu Th, DBH 101, Dr. Megan Thomas
Welcome to CS4250, an introduction to database management systems.
Modeling, development, and implementation of database systems using storage structures,
data definition languages, and data manipulation languages for the relational approach
to database management. Database integrity and security problems. Historical development
of database systems.
Prerequisite: CS 3100.
Announcements and Upcoming Events
All students are being given one extra Late Day. (See syllabus for descriptions
of Late Days.) I strongly encourage students to turn Part 4 in on the Tuesday
deadline, and conserve your new Late Day to use on Part 5 or 7. But it is
your group's choice; you may use the new Late Day on Part 4 if you wish.
For those students who consider 20 (or 10, or 30) characters enough to store a human name,
please take a look at
the full name of Pablo Picasso, the famous painter.
Here is a small chunk of the midterm you will
take on Thursday.
Deadline for Project Part 3 moved, to give students more time to revise Part 2 ER diagrams.
Earthquake (qname, date, latitude, longitude, magnitude, fault)
Damage(cityID, qname, cost, liveslost)
Cities(cID, cname, latitude, longitude, population) [city names may not be unique]
Questions (in SQL, and relational algebra where possible):
- Find the names and dates of earthquakes whose magnitude was greater than 7.0.
- Find the average population of cities whose names start with "San".
- List the lives lost, quake names and city names for all quakes that occurred before 1960.
- Find the names of earthquakes that have occurred in cities with a bigger population than that of Vancouver, Canada. (Query should be written so can "swap in" name of a different city easily.)
- List the city names and total cost, per city, of all quakes with magnitude greater than 7.0.
- List the average magnitude of quakes for each fault (grouped by fault).
- List all earthquakes and, where applicable, also list city names and lives lost in that city for quakes that affected cities.
- List the names of cities whose populations are greater than the average city population.
For the in-class SQL "live" demos, I've been using the command line 'sqlite3'
tool, available to download here, from sqlite.org. (Basic instructions for the command line SQLite are here.)
Feel free to try. I just tried the latest version for Mac, and it worked. 'cd'
(Unix/Mac) or 'chdir' (Windows/ Command Prompt) your command line window into
whatever folder you put the files you downloaded and unzipped, and type ./sqlite3
(Unix/Mac) or .\sqlite3 (Windows) and the SQLite should start up.
I've put the start-up file of SQL commands here.
I usually copy-and-paste the ch5-demo.sql file's contents into the sqlite3 command
prompt. (There is an import command, but it has occasionally behaved oddly for me.)
|| Welcome to CS 4250!
At the CSU Stanislaus library:
- Database Systems: The Complete Book by Garcia-Molina, Ullman and Widom,
three extremely well-respected database researchers and professors at Stanford University.
- Database Management Systems by Raghu Ramakrishnan and Johannes Gherke,
excellent, systems-oriented introduction to the field of database management.
- Database Tuning by Dennis Sasha and Philippe Bonet. A clear
presentation of how database design decisions impact database performance.
Also discusses IBM, Oracle and Microsoft systems and how design choices can impact them.
- MySQL and mSQL by Randy Yarger.
- MySQL by Paul DuBois (electronic).
- Readings in Database Systems by M. Stonebraker. A collection of
influential papers in DBMS research history.
The Ramakrishnan and Garcia-Molina/Ullman/Widom textbooks are both
available at the university library.
CSU Stanislaus Dreamers: Resources
for AB540 and undocumented students
Fun News Items
- "https://www.fastcompany.com/40420383/i-review-thousands-of-resumes-heres-what-im-really-looking-for" (Fast Company, May 2017)
- "Software Engineering Jobs Dominate List of Best Careers for 2017" (IEEE Spectrum, 22 March 2017)
- "Data Scientist, DevOps Engineer and DBA Among Top IT Jobs for 2017" (Datamation.com, Jan 2017)
"Beyond Just 'Big' Data" (IEEE Spectrum, 28 Jul 2015) -- notice the comment
about jobs related to big data...
"How to Break Into Some of the Fastest-Growing Tech Fields" (theinstitute by IEEE, September 2016)
- XKCD on SQL
Center Love: Tech Chiefs Show Off the Gear That Keeps Everything Humming"
by CIO Journal Staff, of the Wall Street Journal, on Dec. 31, 2015.
- "Job Hunting in the Internet Age: A Techwise Conversation with Mike Junge, Google's senior recruiter"
"Top secret Visa data center banks on security, even has moat", (USA Today, 3/2012)
Security guards, power back-ups, earthquake and hurricane protection... credit
card companies take protecting data seriously.
- "Data Modeling for Analytical Data Warehouses,"
an interview with Michael Blaha (3/3/2012) ODBMS Industry Watch.
- "Under the Hood at Google and Facebook:
A peek at the data centers, servers, and software that keep us feeling connected"
IEEE Spectrum, June 2011.
Normalization for the Real World: nice article walking
one through the steps of database normalization, with larger- than- can- fit- on- a-
PowerPoint- slide relation examples.