Article

Free access

A performance analysis of the gamma database machine

Authors:

S. Ghanderaizadeh,

D. SchneiderAuthors Info & Claims

SIGMOD '88: Proceedings of the 1988 ACM SIGMOD international conference on Management of data

Pages 350 - 360

https://doi.org/10.1145/50202.50245

Published: 01 June 1988 Publication History

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.

References

[1]

Babb. E. "Implementing a Relational Database by Means of Spec~ahzed Hardware" ACM TODS, Vol 4, No 1, March, 1979

Digital Library

[2]

B~tton D, D J DeW~tt, and C Turbyfill, "Benchmarkmg Database Systems - A Systemattc Approach," Proceedings of the 1983 Very Large Database Conference, October, 1983

Digital Library

[3]

Bratbergsengen, Kjell, "Haslung Methods and Relattonal Algebra Operations" Proceexlmgs of the 1984 Very Large Database Conference, August, 1984

Digital Library

[4]

Chou, H-T, DeW~tt, D J, Katz, R, and T Klug, "Deslgn and Implementalaon of the Wisconsin Storage System (W1SS)" Software Practtces and Experience, Vol 15, No 10, October, 1985

Digital Library

[5]

DeWltt, D, et al, "Implementataon Techmques for Mare Memory Database Systems," Proceedings of the 1984 SIGMOD Conference, Boston, MA, June, 1984

Digital Library

[6]

DeWltt, D, and R Gerber, "Mullaproeessor Hash- Based Jom Algorithms," Proceedings of the 1985 VLDB Conference, Stockholm, Sweden, August, 1985

[7]

DeW~tt, D, Gerber, B, Graefe, G, Heytens, M, Kumar, K and M Murahknshna, "GAMMA - A High Performance Dataflow Database Mactune," Proceedings of the 1986 VLDB Conference, Japan, August 19~6

Digital Library

[8]

DeWltt, D, Smith, M, and H Boral, "A Single-User Performance Evaluation of the Teradata Database Machine," MCC Techmcal Report Number DB-081-87, March 5, 1987

[9]

DeW~tt, D, Ghandehanzadeh, S, and D Schneider, "A Performance Analysis of the Gamma Database Machine," Computer Sciences Techmcal Report #742, Jan 1988

[10]

Gerber, R, "Dataflow Query Processing using Muluprocessor Hash-ParUttoned Algorithms," Computer Sciences Techmcal Report #672, October 1986

[11]

gatsuregawa, M, Tanaka, H, and T Moto-oka, "Apphcat,on of Hash to Data Base Machine and its Archttecture,' New Generation Compuung, Vol 1, No 1, 1983

[12]

Proteon Assocmtes, Waltham, Mass, 1985

[13]

R~es, D and R Epstein, "Evaluataon of Dtstnbulaon Cnter ~, for Dastnbuted Database Systems," UCB/ERL Techmcal Re ~rt M78/22, UC Berkeley, May, 1978

[14]

Sehnger,P G, et al, "Access Path Selectton m a Relattorlal Database Management System," Proceedings of the 1979 SIGMOD Conference, Boston, MA, May 1979

Digital Library

[15]

Stonebraker, M~chael, Eugene Wong, and Peter Kreps, "The Design and Implementalaon of INGRES", ACM TODS, Vot 1, No 3, September, 1976

Digital Library

[16]

Teradata Corp, DBC/1012 Data Base Computer Concepts & Facdtt,es, Teradata Corp Document No C02-0001- 00, 1983

Cited By

Alimohammadzadeh HZhu SBai JGhandeharizadeh S(2024)Reliability Groups with Standby Flying Light SpecksProceedings of the 15th ACM Multimedia Systems Conference10.1145/3625468.3647606(1-11)Online publication date: 15-Apr-2024
https://dl.acm.org/doi/10.1145/3625468.3647606
Wang RWang JKadam PTamer Özsu MAref W(2023)dLSM: An LSM-Based Index for Memory Disaggregation2023 IEEE 39th International Conference on Data Engineering (ICDE)10.1109/ICDE55515.2023.00217(2835-2849)Online publication date: Apr-2023
https://doi.org/10.1109/ICDE55515.2023.00217
Deshmukh HSundarmurthy BPatel J(2022)On inter-operator data transfers in query processing2022 IEEE 38th International Conference on Data Engineering (ICDE)10.1109/ICDE53745.2022.00066(820-832)Online publication date: May-2022
https://doi.org/10.1109/ICDE53745.2022.00066
Show More Cited By

Index Terms

A performance analysis of the gamma database machine

Recommendations

A performance analysis of the gamma database machine

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 ...
Performance Analysis of Alternative Database Machine Architectures

The rapid advances in the development of low-cost computer hardware have led to many proposals for the use of this hardware to improve the performance of database management systems. Usually the design proposals are quite vague about the performance of ...
Performance analysis of "Groupby-After-Join" query processing in parallel database systems

Queries containing aggregate functions often combine multiple tables through join operations. This query is subsequently called "Groupby-Join". There is a special category of this query whereby the group-by operation can only be performed after the join ...

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences

SIGMOD '88: Proceedings of the 1988 ACM SIGMOD international conference on Management of data

June 1988

443 pages

ISBN:0897912683

DOI:10.1145/50202

ACM SIGMOD Record Volume 17, Issue 3
June 1988
431 pages
ISSN:0163-5808
DOI:10.1145/971701
Issue’s Table of Contents

Copyright © 1988 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

SIGMOD: ACM Special Interest Group on Management of Data

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 01 June 1988

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Qualifiers

Article

Conference

SIGMOD88

Sponsor:

SIGMOD

SIGMOD88: International Conference On Management of Data

June 1 - 3, 1988

Illinois, Chicago, USA

Acceptance Rates

Overall Acceptance Rate 785 of 4,003 submissions, 20%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

63
Total Citations
View Citations
1,073
Total Downloads

Downloads (Last 12 months)606
Downloads (Last 6 weeks)538

Reflects downloads up to 16 Oct 2024

Other Metrics

View Author Metrics

Citations

Cited By

Alimohammadzadeh HZhu SBai JGhandeharizadeh S(2024)Reliability Groups with Standby Flying Light SpecksProceedings of the 15th ACM Multimedia Systems Conference10.1145/3625468.3647606(1-11)Online publication date: 15-Apr-2024
https://dl.acm.org/doi/10.1145/3625468.3647606
Wang RWang JKadam PTamer Özsu MAref W(2023)dLSM: An LSM-Based Index for Memory Disaggregation2023 IEEE 39th International Conference on Data Engineering (ICDE)10.1109/ICDE55515.2023.00217(2835-2849)Online publication date: Apr-2023
https://doi.org/10.1109/ICDE55515.2023.00217
Deshmukh HSundarmurthy BPatel J(2022)On inter-operator data transfers in query processing2022 IEEE 38th International Conference on Data Engineering (ICDE)10.1109/ICDE53745.2022.00066(820-832)Online publication date: May-2022
https://doi.org/10.1109/ICDE53745.2022.00066
Iu MZwaenepoel WMorin CMuller G(2010)HadoopToSQLProceedings of the 5th European conference on Computer systems10.1145/1755913.1755939(251-264)Online publication date: 13-Apr-2010
https://dl.acm.org/doi/10.1145/1755913.1755939
Aguilar-Saborit JTrancoso PMuntes-Mulero VLarriba-Pey J(2008)Dynamic adaptive data structures for monitoring data streamsData & Knowledge Engineering10.1016/j.datak.2007.12.00666:1(92-115)Online publication date: 1-Jul-2008
https://dl.acm.org/doi/10.1016/j.datak.2007.12.006
Aguilar-Saborit JMuntes-Mulero VZuzarte CZubiri ALarriba-Pey J(2006)Dynamic out of Core Join Processing in Symmetric MultiprocessorsProceedings of the 14th Euromicro International Conference on Parallel, Distributed, and Network-Based Processing10.1109/PDP.2006.31(28--35)Online publication date: 15-Feb-2006
https://dl.acm.org/doi/10.1109/PDP.2006.31
Ng BLau RSi ALi F(2005)Multiserver support for large-scale distributed virtual environmentsIEEE Transactions on Multimedia10.1109/TMM.2005.8583887:6(1054-1065)Online publication date: 1-Dec-2005
https://dl.acm.org/doi/10.1109/TMM.2005.858388
Marek RRahm E(2005)Performance evaluation of parallel transaction processing in shared nothing database systemsPARLE '92 Parallel Architectures and Languages Europe10.1007/3-540-55599-4_95(295-310)Online publication date: 14-Jul-2005
https://doi.org/10.1007/3-540-55599-4_95
Wilschut AApers PFlokstra J(2005)Parallel query execution in PRISMA/DBParallel Database Systems10.1007/3-540-54132-2_69(424-433)Online publication date: 8-Jun-2005
https://doi.org/10.1007/3-540-54132-2_69
Apers PHertzberger LHulshof BOerlemans AKersten M(2005)PRISMA, a platform for experiments with parallelismParallel Database Systems10.1007/3-540-54132-2_56(167-180)Online publication date: 8-Jun-2005
https://doi.org/10.1007/3-540-54132-2_56
Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

Media

Figures

Other

Tables

View Table of Contents