Course materials for GSM 274 and FEMBA 274:

Database Management for Electronic Commerce/Business

Walt Scacchi
Wscacchi@ics.uci.edu

Spring 2002

Last updated: 8:30, 22 May 2002

*** SUBJECT TO REVISION ***

Class #10: 5 June 2002
  1. Course Evaluations
  2. Final Team Project Presentations
  3. Final Exam (in class)
  4. Final Exam (off-campus ;-)
Class #9: 29 May 2002
  1. Discussion of Case #4: Microsoft TerraServer (long)
  2. Presentation Materials for -- Topic 8: DataWarehousing, Information Discovery, and Knowledge Management
  3. Presentation Materials for -- Topic 9: Workflow, Data Syndication, and Information Logistics
Class #8: 22 May 2002
  1. Added Web links to revised Team Project Guidelines (only some small text changes and Web links were revised) and Team Project Web Page Templates (be sure to download, save, and use these in your project documentation/deliverables). All Project Web Page Templates can also be found in within this ZIP archive.
  2. Team project meetings in class
Class #7: 15 May 2002
  1. Project Discussion: Extra-credit options using "free" open source database management solutions for project prototyping
    1. Apache Web Server, MySQL RDBMS, PHP for Windows 2000 (aka, "WAMP")
    2. ZOPE -- integrated Apache Web server, Object database manager (replaceable), Transactions, etc. for "Content Management" applications for Web Portals
  2. Presentation Materials for -- Topic 6: DataBase Modeling
  3. Discussion of Case Questions for Marshall Industries
  4. Presentation Materials for -- Topic 7: DataBase Query Processing
Class #6: 8 May 2002
  1. Mid-term exam
  2. Presentation Materials for -- Topic 5: DBM Administration
  3. Discussion of Case Questions
  4. Presentation Materials for -- Topic 6: DataBase Modeling
  5. Read Case #4: Microsoft TerraServer (long), ( shorter, revised) (a satellite image of UCI GSM)
Class #5: 1 May 2002
  1. Sample Midterm Exam Questions (in MSWord. doc format)
  2. Assignment #2 Results: Team Project Proposals
  3. Discussion of Case #2 Dell Computer  Questions
  4. Presentation Materials for -- Topic 5: DBM Administration
  5. Presentation Materials for -- Topic 6: DataBase Modeling
  6. Team Project Guidelines
Class #4: 24 April 2002
  1. Discuss Assignment #2 and Submission Guidelines
  2. Presentation Materials for  Topic 4: DBM System Architectures
  3. Case #2 Dell Computer  Questions due 1 May 2002
  4. Case #3 Marshall Industries  Questions due 8 May 2002
  5. Presentation Materials for -- Topic 5: DBM Administration
  6. Prepare and post 2 potential mid-term exam questions on Class Discussion Forum using Catalyst
Class #3: 17 April 2002
  1. Complete presentation materials for  -- Topic 3: DBM-EC Applications
  2. Discuss Case #1 Questions
  3. Presentation Materials for 17 April 2002 -- Topic 4: DBM System Architectures
  4. Assignment #2 -- Prepare a 1-2 page write-up of a team project proposal for discussion next week.
  5. Read Evolving DB-Web Business Model: Dell Computer
  6. Read Evolving Enterprise System Architecture: Marshall Industries
Class #2: 10 April 2002
  1. Assignment #1 Discussion
  2. Presentation materials for 10 April 2002 -- Topic 2: DBM-EC Business Models
  3. Presentation materials for 10 April 2002 -- Topic 3: DBM-EC Applications
  4. Case #1 (required reading) -- Internet-Based Procurement of Contracted Services at ONR
  5. Case #1 Questions
Class #1: 3 April 2002
  1. Background information on Walt Scacchi
  2. Presentation materials for 3 April 2002 -- Course Overview
  3. Presentation materials for 3 April 2002 -- Topic 1: Collecting and Managing Databases
  4. Assignment #1 -- Search the Web for personal information about you!
  5. Future readings and case studies:
    1. Evolving DB-Web Business Model: Dell Computer
    2. Evolving Enterprise System Architecture: Marshall Industries
    3. DB Design, Spatial Data Warehousing (Technical): Microsoft TerraServer (long), ( shorter, revised)
  6. Recommended/Required Books (choose ONE or more to purchase)
    1. Database Processing: Fundamentals, Design and Implementation (8th. edition), ( amazon.com review) by David M. Kroenke, Prentice Hall; ISBN: 0130848166
    2. Web Database Development : Step by Step, ( amazon.com review) by Jim Buyens, Microsoft Press; ISBN: 0735609667
    3. Database Design for Smarties: Using UML for Data Modeling, ( amazon.com review) by Robert J. Muller, Morgan Kaufmann Publishers; ISBN: 1558605150
    4. Designing Systems for Internet Commerce: ( amazon.com review) by G. Winfield Treese and Lawrence C. Stewart;ISBN: 0201571676
  7. DataBase Management System (DBMS) alternatives (for use in your team project)
    1. MS Access for Windows (Windows personal server or IIS must be integrated for Web access)
    2. Filemaker Pro (Web server built in--available for download for 30 days and five users)
    3. NuSphere MySQL (MySQL DBMS + Apache Web server + PHP already integrated, available for free download (or $80 including printed documentation, CDRom, limited support), runs on most computers including Windows, Linux, Solaris, Mac, etc.)
    4. MS SQL7 (Similar to Access, but with full support for SQL-92 and transactions, making it a complete relational DBMS).
  8. Related Resources
    1. DB2 magazine: for example, see the article on E-Business Enterprise Architectures (and the architecture diagram)
    2. Oracle magazine
    3. LAMP: Linux, Apache, MySQL (or PostgresSQL), Perl/Python
  9. Optional/Potential project-related readings (for technically inclined :-)
    1. Virtual Web Databases: one approach to unifying XML, Web, RDBMSs
    2. Microsoft's Multi-TeraByte Astronomy DB Design: A really BIG database