Database Management Systems Implementation

Lab1 : Data Pipeline

• specifications
• solution:
  • Database design
    • ER diagram
    • pubSchema
    • Queries on raw data
  • Data Transformation
    • Author
    • Publication
    • Wrote
    • Article
    • Incollection
    • Inproceedings
    • Book
  • Data Analysis
    • Queries
    • Data visualization

Lab2 : SimpleDB part I

Implement the core modules of the educational DBMS SimpleDB, such as tuples, fields, the Catalog, the BufferPool etc. See the specifications for more.

Lab3 : SimpleDB part II

Expand Lab 2 with join operators (e.g. SMJ, HJ), selection, insertion and deletion operators as well as aggregates. See the specifications for more.