DBDB.io The Encyclopedia of Database Systems · Est. 2017
Login
Database of Databases

Database Entry

Gamma

Abandoned OLAP OLTP

Gamma was a parallel relational database machine and database management system developed in the Computer Sciences Department at the University of Wisconsin-Madison for research on parallel query processing and transaction processing on a shared-nothing architecture.[01]

Developer
Country of Origin
US
Start Year
1986
End Year
1990
Project Type
Academic
Written in
C
Operating System
BSD

Database Entry

Gamma

Abandoned OLAP OLTP

Gamma was a parallel relational database machine and database management system developed in the Computer Sciences Department at the University of Wisconsin-Madison for research on parallel query processing and transaction processing on a shared-nothing architecture.[01]

History

The Gamma project was developed in the 1980s as a successor to the earlier DIRECT system and DeWitt's database machine work.

Coordination

Centralized Coordinator

Data Model

Relational

Joins

Nested Loop Join Hash Join Sort-Merge Join Semi Join

Logging

Physical Logging

Parallel Execution

Intra-Operator (Horizontal) Inter-Operator (Vertical) Bushy

Query Compilation

Not Supported

Query Execution

Tuple-at-a-Time Model

Query Interface

SQL

Storage Architecture

Disk-oriented

Storage Model

N-ary Storage Model (Row/Record)

Storage Organization

Heaps

Stored Procedures

Not Supported

System Architecture

Shared-Nothing

Views

Not Supported
People Also Viewed
SH Shore Quickstep Quickstep SH SharedDB GR GRACE

Citations

1 source
  1. https://mwhittaker.github.io/papers/html/dewitt1990gamma.html github.io
Revision #5 Last Updated: