TOPICS IN DATABASE MANAGEMENT SYSTEMS

COMPSCI 764

Course Description

Implementation of database management systems, the impact of new technology on database management systems, back-end database computers, distributed database management systems, concurrency control, and query execution in both distributed and centralized systems, implementation of multiple user views, roll-back and recovery mechanisms, database translation. Students are strongly encouraged to have knowledge of database design (e.g.,COMP SCI 564).

Prerequisties

Graduate/professional standing

Satisfies

This course does not satisfy any prerequisites.

Credits

Offered

Occasionally

Grade Point Average

3.56

-4.15% from Historical

Completion Rate

100%

0.71% from Historical

A Rate

52.94%

-16.96% from Historical

Class Size

-35.26% from Historical

Instructors (2025 Fall)

Sorted by ratings from Rate My Professors

XIANGYAO YU

[email protected]

Rating

Similar Courses

APPLIED DATABASE DESIGN

LIS 464

Introduces the applications of databases to real-world data and information problems. Overview of the principles and practices of user-oriented database design, management, and application. Discussion and practice cover database application lifecycle, data modeling, relational database design, SQL queries, reports and other interfaces to database data, and database documentation.

INTRODUCTION TO DATABASES

INFOSYS 322

Introduction to database management systems with a focus on relational databases. Covers designing, creating, populating, managing, and retrieving data from databases. SQL will be used with a focus on querying for business applications and intelligence, data retrieval for summary reports, and data visualization. Offers a brief introduction to non-relational databases for business applications.

FOUNDATIONS OF DATA MANAGEMENT

COMPSCI 784

Foundational concepts in databases and data management. The first part of the course discusses topics on query languages (conjunctive queries, Datalog), their expressivity and complexity of evaluation. The second part studies advanced topics in modern data management, including data streams, massive parallelism, provenance, uncertain data management and privacy. There are no specific course prerequisites. It is strongly encouraged that the students are familiar with databases and relational algebra (COMP SCI 564or equivalent). Knowledge of algorithms, complexity theory and probability will also be helpful.

DATABASE MANAGEMENT SYSTEMS: DESIGN AND IMPLEMENTATION

COMPSCI 564

What a database management system is; different data models currently used to structure the logical view of the database: relational, hierarchical, and network. Hands-on experience with relational and network-based database systems. Implementation techniques for database systems. File organization, query processing, concurrency control, rollback and recovery, integrity and consistency, and view implementation.

DATABASE DESIGN FOR INFORMATION PROFESSIONALS

LIS 751

Introduction to contemporary database management systems, the design process employed when implementing databases to solve data and information management problems, developing queries and scripts, and other issues in employing databases to solve organizational information and data challenges.