Search 
MyUMUC 
WebTycho Graduate School of Management & Technology – Programs
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 foundation established in DBST 651, exploring advanced concepts. Advanced knowledge in logical design, physical design, performance, architecture, data distribution, and data sharing in relational databases is provided. The concepts of object-relational design and implementation are introduced and developed. Remote access laboratory component required.
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. Knowledge and awareness of current trends and emerging technologies in distributed data management is quintessential to 21st-century database management. The fundamentals of database systems that manage distributed data are built upon. A survey of various topics in distributed database management systems includes 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 concepts needed for successfully designing and implementing a data warehouse. Topics include the technological knowledge base for data model approaches such as the star schema and denormalization, issues such as loading the warehouse, performance challenges, and other concepts unique to the warehouse environment.
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. As the amount of data has grown, so has the difficulty in analyzing it. Data mining is the search for hidden, meaningful patterns in large databases. Identifying these patterns and rules can provide significant competitive advantage to businesses. Data mining applications are introduced and algorithms and techniques useful for solving different problems are identified. Many of the techniques will include the application of wellknown statistical, machine learning, and database algorithms, including decision trees, similarity measures, regression, Bayes theorem, nearest neighbor, neural networks, and genetic algorithms. Topics include researching data mining applications and learning how to integrate 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. Information stored in databases is a valuable asset that needs to be protected from damage. 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 are studied. Models for multilevel secure databases for both relational and object-relational databases are analyzed. Practical applications of database security concepts are applied in the remote access laboratory component.
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 included.