System Architecture

The current version of the system is single user, with or without transactions, and supports a large subset of SQL-92.

As shown in figure the system is made up of two main components: the Relational Engine and the Storage Engine. The relational engine consists of the modules necessary to parse and optimize queries. The storage engine consists of the modules necessary to access and modify data on disk.

The major system modules are:

• Permanent Memory Manager
• Buffer Manager
• Storage Structures Manager
• Access Methods Manager
• Query Manager

Design Decisions

• The JRS architecture is based on the WiSS system, designed by D. DeWitt, and on the Minibase system, designed by M. Carey and R. Ramakrishnan.
• The index manager is based on the GiST (Generalized Search Tree) approach proposed by J. Hellerstein, J. Naughton and A, Pfeffer.
• The transaction manager is based on the ARIES approach proposed by C. Mohan.
• The query optimizer is based on the OPT++ approach proposed by N. Kabra and D. DeWitt.

JRS Home Page