DBST Course Listing

Relational Database Systems (DBST 651, 3 Credits)
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 Data Modeling (DBST 660, 3 Credits)
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)
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)
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)
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)
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 Administration (DBST 670, 3 Credits)
Prerequisites: DBST 652, DBST 663, DBST 665, DBST 667, and DBST 668. 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.