UMUC

Graduate School of Management and Technology

Course Descriptions - DBST (Database Systems Technology)

DBST 651 Relational Database Systems (3)

(Formerly CSMN 661.) 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.

DBST 652 Advanced Relational/Object-Relational Database Systems (3)

(Formerly CSMN 662.) Prerequisite: CSMN 661 or 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.

DBST 663 Distributed Database Management Systems (3)

(Formerly CSMN 663.) Prerequisite: CSMN 661 or 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.

DBST 665 Data Warehouse Technologies (3)

(Formerly CSMN 665.) Prerequisite: CSMN 661 or DBST 651. An introduction to the knowledge and skills needed to successfully design and implement a data warehouse. Topics include data model approaches such as the star schema and denormalization, loading the warehouse, performance challenges and other concepts unique to the warehouse environment. Assignments require use of a remote access laboratory.

DBST 667 Data Mining (3)

(Formerly CSMN 667.) Prerequisite: CSMN 661 or 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.

DBST 668 Database Security (3)

(Formerly: CSMN 668.) Prerequisite: CSMN 661 or 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.

DBST 670 Database Systems Administration (3)

(Formerly CSMN 666.) Prerequisite: CSMN 661 or DBST 651. 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.