Draft Schedule
Date Topic Reading Lab
Aug 26 Course Introduction None Database Ubiquity: Start off reviewing a bunch of websites and talking about “how is a database used here?” Have each student take a site, explore it, and then we’ll discuss as a class? or Analyze FB, Google, others gathers, stores, analyzes, and uses data
Sep 02 Why Data Matters Chapter 1 from Redman Book Review websites & “how is database used?” Each student or group takes a site, explores it, and draws a conclusion about how a database is used
Sep 09 Decision-Making & Analytics Two articles on not finding info & data quality article Drawing databases from popular sites?
Sep 16 Decision-Making & Analytics (continued) Two HBR Articles ERP & Decision Support? SAP to DB2 and Oracle?
Sep 23 Relational Revisited tbd SQL Lab
Sep 30 Relational Revisited (continued) tbd Query Optimization & Declarative Programming
Oct 07 Under the Covers: How Data is Stored) Cory Doctorow @ PetaCenters http://craphound.com/?p=2124 (podcast, post, and photos) Some sort of exercise to learn how data is written to disk, caching, clustering, etc. Use this to explore why relational isn’t the answer to all problems.
Oct 14 Under the Covers: Database Architectures tbd Cloud Project: Oracle APEX or http://wiki.developerforce.com/index.php/Apex
Oct 21 Under the Covers: Database Architectures (continued) None Cloud Project (continued)
Oct 28 Why BIG Data Matters Release 2.0 Reading and What is Big Data? http://www.youtube.com/watch?v=yBFPTvch7y4 Column-Oriented DB Project
Nov 04 Why BIG Data Matters (continued) More Release 2.0 Reading and Hadoop in the NYT http://www.nytimes.com/2009/03/17/technology/business-computing/17cloud.html?_r=1 Hadoop & MapReduce Project http://hadoop.apache.org/
Nov 11 BIG Data at Work http://scienceblogs.com/goodmath/2008/01/databases_are_hammers_mapreduc.php and http://typicalprogrammer.com/programming/mapreduce/ Hadoop & MapReduce Project (continued)
Nov 18 Specialized Databases (XML, Stream/Real Time, Analytic) http://www.theregister.co.uk/2009/04/10/ibm_system_s_super/ and http://www.informationweek.com/news/software/database/showArticle.jhtml?articleID=207801436 and http://www.dbms2.com/2007/01/22/are-row-oriented-rdbms-obsolete/ Hands-on with XIndex and XQuery?
Nov 25 THANKSGIVING BREAK
Dec 02 Uh oh, I misplaced my data Data Breaches & Secrets for Sale Video FB Terms of Svc: Who owns the data? Backup/Recovery, Security, Privacy
Dec 16 FINAL
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License