Advanced Databases

In this course, the state of the art in Big Data management and retrieval is discussed with specific emphasis on flexibility and scalability. First, query processing in SQL is inspected to understand opportunities of optimization and parallelization. NewSQL provides new, particularly effective relational technology. Further, NoSQL approaches are considered which provide new data models, such as documents, graphs and arrays, together with dedicated architectures. This will be contrasted with the MapReduce approach leading to general scalability considerations. Finally, we briefly address security issues and approaches to overcome them. As a result of this course, students will know the state of the art in data management for particularly large and complex data, with guidance on how to choose and use advanced database technology.

I will subscribe all by the end of the drop/add period to the course mailing list:

If you attend the course, make sure you are subscribed to that list to not miss important information! I will NOT make use of the Campus.net course list (not even reading it)!

Slides

• Introduction to course and lab
• Anatomy of a Database System: [ Database design | Relational model | SQL | Normal Forms | Transactions | WWW | Web Service Protocols | DB Application Development | disk storage | DB storage | Indexing | Spatial indexing | Physical design | Query processing ]
• Advanced topics: [ OLAP | NoSQL | MapReduce | Virtualization | Content Delivery Networks | Security ]
• wrap up

Homework Assignments

(see assignments distributed via course mailing list)

Literature

• Hector Garcia-Molina, Jeff Ullman, and Jennifer Widom: Database Systems: The Complete Book.
• further readings indicated in lecture