A performance analysis of the gamma database machine
- 1 June 1988
- journal article
- Published by Association for Computing Machinery (ACM) in ACM SIGMOD Record
- Vol. 17 (3) , 350-360
- https://doi.org/10.1145/971701.50245
Abstract
This paper presents the results of an initial performance evaluation of the Gamma database machine. In our experiments we measured the effect of relation size and indices on response time for selection, join, and aggregation queries, and single-tuple updates. A Teradata DBC/1012 database machine of similar size is used as a basis for interpreting the results obtained. We also analyze the performance of Gemma relative to the number of processors employed and study the impact of varying the memory size and disk page size on the execution time of a variety of selection and join queries. We analyze and interpret the results of these experiments based on our understanding of the system hardware and software, and conclude with an assessment of the strengths and weaknesses of Gamma.Keywords
This publication has 6 references indexed in Scilit:
- Design and implementation of the wisconsin storage systemSoftware: Practice and Experience, 1985
- Implementation techniques for main memory database systemsPublished by Association for Computing Machinery (ACM) ,1984
- Application of hash to data base machine and its architectureNew Generation Computing, 1983
- Implementing a relational database by means of specialzed hardwareACM Transactions on Database Systems, 1979
- Access path selection in a relational database management systemPublished by Association for Computing Machinery (ACM) ,1979
- The design and implementation of INGRESACM Transactions on Database Systems, 1976