Date of Award
6-1990
Degree Name
Master of Science
Department
Computer Science
First Advisor
Dr. Dalia Motzkin
Second Advisor
Dr. Kenneth Williams
Third Advisor
Dr. Alfred Boals
Access Setting
Masters Thesis-Open Access
Abstract
Many people in data processing desire to know more about the performance of relational databases. Little information about performance exists in the product or public literature. The purpose of this study is to compare one aspect of the performance of relational databases. The aspect explored is the indexing of tables in a relational database. This paper compares the use of indexing in two relational databases, SQL/DS (Ver. 2, Rel. 1) and INGRES (Rel. 5.0/0.6). Queries were created and executed on tables in both databases, first without an index and then with several different indexes.
The findings in this study show that: (a) indexing made a difference in all but one case, (b) the performance gain was not the same for different amounts of data retrieved, and (c) indexing was not the only parameter which affected performance.
Recommended Citation
Bourn, Karen L., "SQL/DS, Ingres and Indexes: A Comparative Study of the Use of Indexes in Two Database Systems" (1990). Masters Theses. 1063.
https://scholarworks.wmich.edu/masters_theses/1063