DATA 504Database & Lrg Data Repostries

Catalog

The focus of this course is on understanding information systems and infrastructure used in Data Analytics. The course will provide an introduction to elements of database design and database query languages. Students will also gain technical understanding of and hands-on experience with the information technology infrastructure required for data analytics. The first part of the course focuses on traditional databases and structured data. It covers association between data elements and data models (including entity-relationship and relational models), relational database design techniques, database query languages. Students will be exposed to the basics in query processing, transaction management, and concurrency control. The second part of the course covers non-relational databases and big data infrastructure. Students compare and contrast as well as have hands-on experience with various non-relational databases including document, graph, and column databases. Students will also be exposed to Hadoop environment and basic services available in this environment, distributed file systems, storage, and processing.