Course Listings

Relational Database Systems

DBST 651 | 3 Credits

Course Desc: An introduction to relational databases, one of the most pervasive technologies today. Presentation covers fundamental concepts necessary for the design, use, and implementation of relational database systems. Focus is on basic concepts of database modeling and design, the languages and facilities provided by database management systems, and techniques for implementing relational database systems. Topics include implementation concepts and techniques for database design, query optimization, concurrency control, recovery, and integrity. A foundation for managing databases in important environments is provided. Assignments require use of a remote access laboratory.

Advanced Relational/Object-Relational Database Systems

DBST 652 | 3 Credits

Course Desc: Prerequisite: DBST 651. A continuation of the study of relational database systems, exploring advanced concepts. Topics include logical design, physical design, performance, architecture, data distribution, and data sharing in relational databases. The concepts of object-relational design and implementation are introduced and developed. Assignments require the use of a remote access laboratory.

Advanced Data Modeling

DBST 660 | 3 Credits

Course Desc: Prerequisite: DBST 651. An introduction to fundamental concepts and techniques for successfully designing databases for structured and unstructured data. Topics include database quality techniques and relational, dimensional, and NoSQL modeling, as well as best practices for selecting methods and modeling tools to design the database models (relational, dimensional, wide column, document, and graph/RDF). Assignments require the use of a remote access laboratory.

Distributed Database Management Systems

DBST 663 | 3 Credits

Course Desc: Prerequisite: DBST 651. An introduction to the development of distributed database management, focusing on concepts and technical issues. Survey covers distributed database management systems, including architecture, distributed database design, query processing and optimization, distributed transaction management and concurrency control, distributed and heterogeneous object management systems, and database inoperability.

Data Warehouse Technologies

DBST 665 | 3 Credits

Course Desc: Prerequisite: DBST 651. An introduction to the technology approaches for successfully designing and implementing a data warehouse for structured and unstructured data. Topics include data modeling techniques; extraction, transformation, and loading of data; performance challenges; and system tradeoffs in the development of the warehouse environment. Assignments require use of a remote access laboratory.

Data Mining

DBST 667 | 3 Credits

Course Desc: Prerequisite: DBST 651. An overview of the data mining component of the knowledge discovery process. Data mining applications are introduced, and algorithms and techniques useful for solving different problems are identified. Topics include the application of well-known statistical, machine learning, and database algorithms, including decision trees, similarity measures, regression, Bayes theorem, nearest neighbor, neural networks, and genetic algorithms. Discussion also covers researching data mining applications and integrating data mining with data warehouses.

Database Security

DBST 668 | 3 Credits

Course Desc: Prerequisite: DBST 651. An overview of both the theory of and applications for providing effective security in database management systems. Topics include conceptual frameworks for discretionary and mandatory access control, data integrity, availability and performance, secure database design, data aggregation, data inference, secure concurrency control, and secure transactions processing. Models for multilevel secure databases for both relational and object-relational databases are analyzed. Assignments focus on database security concepts and require use of a remote access laboratory.

Database Systems Technology Capstone

DBST 670 | 3 Credits

Course Desc: Prerequisites: 30 credits of program coursework, including all core courses. An introduction to the knowledge, skills, and tools needed to successfully administer operational database systems. The conceptual and operational tools for analysis and resolution of problems such as performance, recovery, design, and technical issues are provided. Tools used to assist in the administration process are also included.