We're still actively developing this site. If you encounter any issues, please report them! - Report an issue

DATABASE MANAGEMENT SYSTEMS: DESIGN AND IMPLEMENTATION

COMPSCI 564
Course Description

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.

Prerequisites

COMPSCI/ECE 354 and (COMP SCI 367 or COMPSCI 400 ) or graduate/professional standing or declared in the Capstone Certificate in Computer Sciences for Professionals

Satisfies
Credits

Not Reported

Offered

Not Reported

Grade Point Average
3.15

-3.14% from Historical

Completion Rate
95.68%

-1.76% from Historical

A Rate
32.1%

-12.05% from Historical

Class Size
324

139.02% from Historical

Cumulative Grade Distribution

Instructors (2026 Summr)

Sorted by ratings from Rate My Professors

Similar Courses

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.

TOPICS IN DATABASE MANAGEMENT SYSTEMS

COMPSCI 764

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).

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.

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.

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.