Logo courtesy Wordle.net

California State University Stanislaus

CS 4250: Database Management Systems

Fall 2016

3:00 - 3:50 pm, M W F, DBH 101, Dr. Megan Thomas

[Syllabus ]        [Announcements]        [Calendar/Lecture Notes]        [Homeworks]        [Fun News]

Welcome to CS4250, an introduction to database management systems. Topics include:

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

12/14/2016	Here is a small chunk of the final exam you will take on Friday.
12/6/2016	"These Tech Jobs Are Set To Get a Major Pay Bump" (Fortune, Dec 2, 2016)
12/6/2016	CSU Stanislaus Dreamers: Resources for AB540 and undocumented students
10/19/2016	Here is a partial solution to Homework 2.
10/17/2016	Here is a small chunk of the midterm you will take on Friday.
10/7/2016	"Want a sure-fire well-paid job? Train to fight computer hackers" (Sacramento Bee, 7 Oct 2016)
10/3/2016	Schema: Earthquake (qname, date, latitude, longitude, magnitude, fault) Damage(city, qname, cost, liveslost) Cities(cname, latitude, longitude, population) [Assume cities have unique names.] 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 total cost, per city, of all quakes with magnitude greater than 7.0. Find the name of the quake that did the most damage ($$) in a city with a population less than 2 million (i.e., of all quakes that have damaged cities with populations less than 2 mill, find the one (or more) that did the most damage) 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.
9/23/2016	"Beyond Just 'Big' Data" (IEEE Spectrum, 28 Jul 2015) -- notice the comment about jobs related to big data...
9/21/2016	Schema from class exercise: CREATE TABLE BookAwardWinners (lastname CHAR(20), firstname CHAR(20), title CHAR(30), year INTEGER, award CHAR(10), age INTEGER, PRIMARY KEY (lastname, title, award)) Goofy schema, and not normalized.
9/20/2016	For student who are interested: Psychological Counseling Services Workshops - workshops on coping with stress, and other issues that come up in college years. Also, Fall 2016 Counseling Groups offered by our Psychological Counseling Services.
9/13/2016	For the sports fans in CS 4250: "Tackle This: Football's Newest Most Valuable Player Is a Robot" (IEEE Spectrum, September 2016)
9/13/2016	"How to Break Into Some of the Fastest-Growing Tech Fields" (theinstitute by IEEE, September 2016)
9/8/2016	Fall 2016 Tutoring Schedule for the Commons (1st floor, Naraghi Hall)
8/25/2016	The Louis Stokes Alliance for Minority Participation (LSAMP) program is looking to recruit students and Research Interns this Fall! (https://www.csustan.edu/AMP) Here are a couple of videos explaining more about LSAMP: Becoming a Scientist or Engineer: Your Pathway to the Future with LSAMP (approx. 5 min): https://www.youtube.com/watch?v=Li90yoX_dGA LSAMP: Aiming High and Making a Difference (approx. 30 min): https://www.youtube.com/watch?v=53y7QJoH7Co
8/25/2016	The Commons is hiring Peer Mentors/Tutors for the 2016-2017 academic year. Applications are due by August 31. Upper division students majoring in Biology, Chemistry, Physics, Geology, Math, or Computer Science are needed. Interested students must have a minimum 3.0 GPA. A copy of the complete job announcement with all requirements is available on the HR website at https://www.csustan.edu/hr/employment-opportunities/student-assistants
8/25/2016	As I mentioned in class today, the Girls Who Code organization contacted our department recently, looking for volunteers, particularly those who might be interested in starting and facilitating a local club for middle / high school students.
8/24/2016	Welcome to CS 4250!

Homeworks

Project Overview

	Points
Project Part 1	20
Project Part 2	20
Homework 1	15
Project Part 3	15
Homework 2	40
Project Part 4	10
Mini-Homework 1	7
Project Part 5	25
Homework 3	20
Project Part 6	12
Project Part 7	70
Homework 4	20

Resources

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.

On-line Resources

• IBM's DB2, etc
• MySQL
• Oracle
• PostgreSQL
• Microsoft SQL Server
• SQLite
• SQL for Web Nerds by Philip Greenspun, a free, on-line only database textbook with a focus on Oracle DBMSs
• SQLFiddle.com appears to be a web site that allows uers to "fiddle around" with SQL.
• JDBC Tutorial, courtesy Jeff Ullman
• JDBC Tutorial, courtesy Oracle
• Execute PHP MySQL On-line, a PHP testing facility provided by http://www.tutorialspoint.com/
• XML Tutorial, courtesy w3schools.com, and XML Tutorial, courtesy zvon.com
• XML Tutorial, courtesy zvon.com
• Phlonx's Third Normal Form Tutorial, with numerous illustrative diagrams
• Lynda.com's "Foundations of Programming: Databases" course -- all videos. You would need to authenticate yourself as a CSU Stanislaus student to view the videos.

Fun News Items

• "How to Break Into Some of the Fastest-Growing Tech Fields" (theinstitute by IEEE, September 2016)
• XKCD on SQL
• "Data 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.
• Dream Jobs 2013 a set of magazine articles about engineers with nifty careers
• IBM, Universities Team Up To Build Data Scientists: Big Blue program aims to prepare students for a workplace increasingly driven by data" InformationWeek, 1/15/2013
• "Job Hunting in the Internet Age: A Techwise Conversation with Mike Junge, Google's senior recruiter"
• "Data Modeling for Analytical Data Warehouses. 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.
• Database 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.

Topic Ideas for End of Semester

• Database security
• SQL vs NoSQL DBMS debate
• Troubleshooting DBMSs that are not performing well
• XML, XQuery, etc
• Hadoop
• Data mining, wireless sensor databases, distributed databases...