Computer Science @ UC Davis | Course Descriptions

ECS 165B DATABASE SYSTEMS (4) III

Lecture: 3 hours

Discussion: 1 hour

Prerequisite: Course ECS 165A

Grading: Letter; projects (50%), midterm/final (50%)

Catalog Description:
Advanced Database Systems: Object-Oriented and Object-Relational Database Systems; Distributed and Multidatabase Systems; Advanced Database Applications: Web-Based Database Access, Data Warehouses.

Expanded Course Description:

Object-Oriented Database Systems (OODBMS)
1. The Object-Oriented Data Model
2. Complex Types and Object-Orientation in Database Systems
3. Query Processing in OODBMS
4. Storage Structures for OODBMS
5. The ODMG Standard
Object-Relational Database Systems
1. Object-Relational Data Models
2. User-Defined Types and Functions
3. Query Processing
4. Object-Relational System Architectures
5. The SQL3 standard
Distributed Database Systems
1. Concepts of Distributed Databases
2. Distributed Database Design
3. Distributed Query Processing and Transaction Management
Other Types of Database Systems
1. Multidatabase Systems
2. Geographic Information Systems
Advanced Database Applications
1. Database Connectivity: ODBC and JDBC
2. Querying Databases through the Web
3. Multidatabase Systems and Database Integration
4. Data Warehouses, OLAP and Data Mining

Textbook:
A. Silberschatz, H.F. Korth, and S. Sudarshan: Database System Concepts, (5th Edition), McGraw-Hill, 2006

Computer Usage:
Students work individually on projects in a UNIX/Linux workstation environment, using standard UNIX/Linux tools as well as major database software packages, including the Oracle RDBMS and major Web-based programming interfaces to database systems.

Programming Projects:
This course is heavily design-oriented. In at least three projects, students have to apply design and system concepts learned in class to design and implement real-world database applications on top of major database management system software. The projects establish certain techniques to be used, but then give open-ended design assignments to include programming and design opportunities.

Engineering Design Statement:
The projects involve design, implementation and verification of database applications using a variety of database systems including object-oriented, object-relational and distributed database systems. The systems and tools used for these projects resemble those that would be found in industry to the extent possible, including the standard database query languages SQL and OQL. Projects are graded based on the design, performance, and correctness, including documentation. Examination questions are based on database models and database design techniques discussed in the lecture and from the projects.

ABET Category Content:
Engineering Science: 2 units
Engineering Design: 2 units

Goals:
Students will:

learn the basic concepts and design issues related to object-relational database systems as well as database standards, such as SQL3
learn and apply concepts underlying distributed databases systems including distribution design, distributed query processing, transaction management, and data integration
learn and apply techniques underlying advanced database systems and applications, such as XML, Web-based database access, data warehouses, data mining, and OLAP

Student Outcomes:

An ability to apply knowledge of mathematics, science, and engineering
An ability to design and conduct experiments, as well as to analyze and interpret data
An ability to design a system, component, or process to meet desired needs within realistic constraints such as economic, environmental, social, political, ethical, health and safety, manufacturability, and sustainability
An ability to identify, formulate, and solve engineering problems
A recognition of the need for, and an ability to engage in life-long learning
A knowledge of contemporary issues
use the techniques, skills, and modern engineering tools necessary for engineering practice

Instructor: B. Ludaescher

Prepared By: M. Gertz (February 2006)

Overlap Statement:
This course does not duplicate any existing course.

5/06

Back to Course Descriptions