The Ohio State University
Department of Computer and Information Science

CIS 671: Introduction to Database Systems II
Winter 2002, MWF 8:30-9:18, DL 266
     (http://www.cis.ohio-state.edu/~doug/Cis671)

Instructor: D. S. Kerr, DL 695, doug@cis.ohio-state.edu
    Instructor's Office Hours

Grader: Charles Hadi, DL 172, hadi.9@osu.edu
   Office Hours: TR 2:30-4:30    Phone:

Course Newsgroup: cis.course.cis671

Objectives

• Mastery of the use of object-relational databases.

• Familiarity with data warehousing.
• Familiarity with active databases.
• Familiarity with data and file storage.

• Exposure to GUI interfaces to database systems.

Text

• (EN) Fundamentals of Database Systems, Ramez Elmasri and Shamkant B. Navathe, 3nd ed., Benjamin/Cummings, 2000.

• Sybase
  • OSU-CIS Computer User Guide
    Section 7. CIS Database Server
  • Sybase Manuals All Manuals
    1. Reference Manual
    2. Transact-SQL User's Guide
    3. Utility Programs for UNIX Platforms (includes information on isql)
    4. ANSI Joins New in Version 12
• SQL-99 Complete, really, Peter Gulutzan, 1999. eBook available online through OSU Library.
• OLAP
  • (C) E. F. Codd's, "Providing OLAP to User-Analysts:An IT Mandate", 1993, containing the 12 rules for OLAP systems on Page 12.
  • (CD) "An Overview of Data Warehousing and OLAP Technology,", Surajit Chaudhuri and Umeshwar Dayal, SIGMOD Record, 26, 1, March 1997, pp 65 - 74.
    • Back issues of the SIGMOD Record are available here. Select "Previous Issues".
  • (P) "Database Explosion", Nigel Pendse.
• Data Mining
  • Ronald J. Prachman, Tom Khabaza, Willi Kloesgen, Gregory Piatetsky-Shapiro, and Evangelos Simoudis, "Mining Business Databases," Communications of the ACM, 39, 11, November 1996, pp 42-48.
  • Tomasz Imielski and Heiki Manila, "A Database Perspective on Knowledge Discovery," Communications of the ACM, 39, 11, November 1996, pp 58-64.
    • Available from campus at the ACM Digital Library.
• Disks
  • Disk characteristics from CIS 570, Autumn 2000

    Approximate Syllabus

    Weeks	Topics	Readings
    1	SQL Review including ANSI Joins	EN: 7-8
    1	Review of Relational Database Design	EN: 3-4, 14-15
    1	GUI Interface to a Relational Database System	See Tutorials
    3	Object-Oriented and Extended Relational Database Technology    Object-Oriented Databases    Object-Relational Databases    SQL3	EN: 11-12 EN: 13 D: Appendix F
    2	Data Warehousing    Online Analytical Processing (OLAP)    Data Mining       Association Rules	EN: 26.1, C, CD, P EN: 26.2
    1	Active Databases	EN: 23.1
    1	Introduction to Query Processing    Introduction    Disks    Basic Files    Index Structures for Files       Indexing       B-Trees    Hashing (If time allows.)	EN: 5.1-5.2, particularly 5.2.1 See Disks EN: 5.5-5.8 EN: 6.1 EN: 6.3 EN: 5.9

    Grading Plan (Subject to revision)

    Homework. Late homeworks will not be accepted.	20%
    Midterm Exam: Wednesday, February 13.	35%
    Final Exam: 7:30 - 9:18 AM, Wednesday, March 20.    (Early Senior Final Exam: Tuesday, March 12 (Corrected), 2:30-4:30, Caldwell 183)	45%

    Homework Assignments: (to be added during the quarter)

    Transparencies: (to be added during the quarter)

    Tutorials: (to be added during the quarter)

    ---

    D. S. Kerr
    January 2002