Temple University Home     CIS Home 

 
 

CIS 9616 (formerly CIS 616): Data Management

Instructor: Alexander Yates

Course Description:

This course covers fundamental and advanced topics in Database Management Systems, including:
  • Database System Architecture: ANSI/SPARC architecture; data abstraction; external, conceptual, and internal schemata; data independence; data definition and data manipulation languages.
  • Data Models: Entity-relationship and relational data models; data structures, integrity constraints, and operations for each data model.
  • Relational Query Languages: SQL, algebra, calculus.
  • Theory of Database Design: Functional dependencies, normal forms, dependency preservation, information loss.
  • Query Optimization: Equivalence of expressions, algebraic manipulation, optimization of selections and joins.
  • Storage Strategies: Indices, B-trees, hashing.
  • Transaction Processing: Recovery and concurrency control.
  • Other advanced topics, possibly including: Object-oriented and object-relational Data Model. Parallel and Distributed Databases. Multimedia databases and queries by content. Data mining, data warehousing, mobile databases, Web databases.

Prerequisites:

CIS 8511 and CIS 8512

Announcements:

  • 2/20: Instructions for connecting to the CISORA database are here.

  • 2/20: Project Proposals are due Friday, March 7.
    I encourage each team to come meet with me to discuss the proposal before handing it in. That will help ensure that the proposals are of the appropriate scope (not too hard, not too easy) for this class. A description of what I would like to see in the project proposal is available on the projects page. Descriptions of the project ideas that I presented in class are available on the blackboard site for this course, under the "Course Documents" section.

  • 2/20: The first assignment is now due on Friday, March 7.
    The SQL*Loader utility will be installed on the first row of machines in Wachman 200 starting on Monday (I hope).

  • 2/11: The first assignment is now available. It is due on Monday, Feb. 25 at 4pm.

  • 1/29: The book for this course is Database System Concepts, the 5th Edition.
    It is by Abraham Silberschatz, Henry F. Korth, and S. Sudarshan. The ISBN is 0-07-295886-3, and it's published by McGraw Hill.

  • 1/27: Welcome to CIS 9616!