JRS is a relational DBMS implemented in Java and designed for instructional use

• to practice with SQL using a platform independent, lightweight system with low memory requirements,
• to practice with query plans, i.e. how the system processes queries,
• to experiment the impact of alternative query optimization techniques and indexes on query plans,
• to understand how a relational DBMS works by exploring the JRS component interfaces,
• to experiment data structures and algorithms to implement database systems.

JRS design was guided by Antonio Albano and the software was developed by the following dedicated students:

• Giovanna Colucci, Patrizia Dedato (SQL Interpreter)
• Martina Filippeschi, Leonardo Candela (Query Optimization)
• Simone Marchi, Cinzia Partigliani (Query Plan Evaluator)
• Stefano Fantechi (Transaction and Concurrency Management),
• Stefano Dinelli, Marco Sbaffi (Tree Indexes)
• Lorenzo Brandimarte (Data Storage and Buffer Management)

The swing interface and the browser were implemented by Renzo Orsini. The representation of a query plan in the form of a tree was implemented by Luca Saiu. Their effort and cooperation in bringing JRS to life are much appreciated.

Index Page