| 1 | Required Elements of Sustainable Online Learning Communities
Introduction to the RDBMS | |
| 2 | Serialization and Concurrency Control
Optimistic and Pessimistic Locking
Pitches by Prospective Clents
Slides: sql-examples.txt (TXT), oracle-multiversion-read.gif (GIF), oracle-serializable-transactions.gif (GIF)) | |
| 3 | Projects Assigned to Teams
Code Review of Basics Problem Set
Dave Mitchell: Roles on Teams | Basics Exercises Due |
| 4 | Data Modelling: Airline Example (TXT)
Improving Query Performance with RDBMS B-tree Indices (GIF) | |
| 5 | Presentations by Teams, Code Review and Discussion
Planning Exercises Completed by Teams
Dave Mitchell: Risks and Process | User Registration and Management Exercises Due |
| 6 | Team Presentations and Discussion
Data Model Normalization and Third Normal Form:
Make sure you've read the normal form sections in the Content Management chapter and maybe this SQL for Web Nerds chapter. We'll be taking apart this table (TXT) for supporting an MP3 sharing service. | Planning Exercises and Exercises 1-3 in Content Management Due |
| 7 | Look and Feel Criticism of Public Internet Sites and Farther-Along Teams | |
| 8 | Team Presentations of Status and Plans | All Exercises in Content Management Due, Including Client Sign-off |
| 9 | Team Presentations of Design Decisions and Documentation | All Exercises in Software Modularity Due |
| 10 | Dave Mitchell: Project Management Wrap-Up | Exercises in Discussion Chapter Due, up to but not including the Usability Test |
| 12 | Discussion of Usability Test Results:
Could the numbers have been predicted from the page flow and HTML designs? | All Exercises in Discussion Chapter Due, except Execution of the Refinement Plan |
| 13 | Three-Person Teams Present Wireless (Mobile) or VoiceXML Chapter Exercises | |
| 14 | Presentation of the Refined Systems | |
| 15 | Class discussion of scaling exercises, ideally starting with each answer being presented by a separate team. | All Exercises in Scaling Gracefully Chapter Due |
| 16 | Discussion of team designs for full-text search. | Exercises 1 and 2 from Search Chapter Due |
| 17 | Cesar Brea returns to help people prepare for the Planning Redux sessions with their clients. | All Exercises from Search Chapter Due |
| 18 | Team presentations of their work and plans for public launch. | Planning Redux Exercises Due |
| 19 | Take-Home Mid-Term Exam | |
| 20 | Discussion of Exam Questions, Answers, and Implications | Mid-Term Exam Due |
| 21 | | Distributed Computing Exercises Due |
| 22 | Sapient Corporation: OpenCourseware's Content Management System | |
| 23 | Ben Adida: Security | Metadata Exercises Due |
| 24 | Empirix: Performance Results | User Activity Analyis Exercises Due |
| 25 | Final Presentations I to Beth Marcus (Entrepreneur), Doug Robinow (Entrepreneur / Lawyer) | |
| 26 | Final presentations II to Ellen Cram (Microsoft Corporation), Brian LaMacchia (Microsoft Corporation), Bob Metcalfe (Ethernet Inventor, 3Com Founder, Polaris Ventures) | |
