Topics in Database Technology

Objectives:

(a) To study in detail fundamental and advanced issues on database design and implementation (full text indexing and spatial data, triggers, transaction management, recursive SQL).
(b) To study modern trends in data models and database applications (post-relational databases, XML, Semantic Web).

Skills:

Acquire knowledge in terms of theory and practice on database development issues. Get to know and use modern models and applications of databases.

Prerequisites:

Undergraduate course in Databases (entity-relationship model, relational model, normalization, relational algebra, SQL).

Content:

Database Transactions and Concurrency Control Technologies (Multi-granular locking CC, Multi-versioning CC, Optimistic CC), case studies on IBM DB2, Oracle, MySQL, Postgresql. Multi-dimensional data and text indexes. Partitioning, Replication and Clustering. Recursive SQL. Τriggers. XML Databases. NoSQL Databases. Document-based Databases (MongoDB). Graph Databases (Neo4j). Linked Data.

Textbooks:

Database Management Systems (3rd edition), by Raghu Ramakrishnan and Johannes Gehrke, McGraw-Hill, 2002.

Database Systems: The Complete Book (2nd Edition), by Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer Widom, Prentice Hall, 2008.

Readings in Database Systems (4th edition), by J. M. Hellerstein and M. Stonebraker (eds.), Morgan Kaufmann Publishers, 2005.

Assessment:

Homework Assignments (50%)
Final Written Examination (50%)

Webpage:

https://openeclass.uom.gr/courses/MAI103/