MSIT 5133 - Database Systems and Technology

Principles of database systems and technologies, including their application to business systems. This course will cover modern database technologies, factors influencing their successful implementation and contemporary applications of those systems to business applications. The course will start with a review of traditional RDMS and their applications to data warehouses and OLTP applications. It will then cover newer approaches such as NoSQL, graph and array databases and Hadoop. The course will present trends in modern database technology, including column stores vs. row stores, main memory databases and high availability systems. Factors influencing successful database system implementation such as performance, availability, security and privacy will be discussed. Finally, application of modern database technology to current business applications will be presented, including data storage needs of modern web applications, large data problems and documented-oriented data stores.