An Empirical Performance Study of the Ingres Search Accelerator for a Large Property Management Database System.

Sarabjot S. Anand, David A. Bell, John G. Hughes: An Empirical Performance Study of the Ingres Search Accelerator for a Large Property Management Database System. VLDB 1994: 676-685

@inproceedings{DBLP:conf/vldb/AnandBH94,
  author    = {Sarabjot S. Anand and
               David A. Bell and
               John G. Hughes},
  editor    = {Jorge B. Bocca and
               Matthias Jarke and
               Carlo Zaniolo},
  title     = {An Empirical Performance Study of the Ingres Search Accelerator
               for a Large Property Management Database System},
  booktitle = {VLDB'94, Proceedings of 20th International Conference on Very
               Large Data Bases, September 12-15, 1994, Santiago de Chile, Chile},
  publisher = {Morgan Kaufmann},
  year      = {1994},
  isbn      = {1-55860-153-8},
  pages     = {676-685},
  ee        = {db/conf/vldb/vldb94-676.html},
  crossref  = {DBLP:conf/vldb/94},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

Abstract

The property management database system under development at the Northern Ireland Housing Executive (NIHE) is one of the largest relational database systems under implementation in Europe. The application system has a high expected transaction processing rate of approximately 37000 transactions per day with approx. 250 on-line users. An implementation on such a large scale requires careful consideration of performance. In this paper we consider the effect of the Ingres Search Accelerator on the transaction processing efficiency of the system. The performance enhancement brought about by SCAFS (ICL's current version of the well-known Content Addressable File Store, CAFS - the heart of the Ingres Search Accelerator) for different file organisations is assessed. Recommendations on how the performance of SCAFS can be improved by tuning certain parameters is provided. We also provide a rough guideline as to when the Ingres Query Optimizer "decides" to use SCAFS for different file organisations and point out deficiencies in this decision making process. We conclude this paper by recommending techniques that may be employed to increase the role of the Ingres Search Accelerator in Ingres database systems.

Copyright © 1994 by the VLDB Endowment. Permission to copy without fee all or part of this material is granted provided that the copies are not made or distributed for direct commercial advantage, the VLDB copyright notice and the title of the publication and its date appear, and notice is given that copying is by the permission of the Very Large Data Base Endowment. To copy otherwise, or to republish, requires a fee and/or special permission from the Endowment.

Online Paper

Download PDF file (www.vldb.org, Darmstadt, Germany)
Download PDF file (www.acm.org, New York, USA)

ACM SIGMOD Anthology

CDROM Version: Load the CDROM "Volume 1 Issue 5, VLDB '89-'97" and ...

Windows: Click the letter of your CD drive
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Mac: Click here
UNIX/LINUX: mount the CD and click on the path of your mount point:
/Anthology/vldb8997 or /cdrom

DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...

Windows: Click the letter of your CD drive
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Mac: Click here
UNIX/LINUX: mount the DVD and click on the path of your mount point:
/Anthology/aDVD1 or /dvd

Printed Edition

Jorge B. Bocca, Matthias Jarke, Carlo Zaniolo (Eds.): VLDB'94, Proceedings of 20th International Conference on Very Large Data Bases, September 12-15, 1994, Santiago de Chile, Chile. Morgan Kaufmann 1994, ISBN 1-55860-153-8
Contents

References

[ANAN93]: ...
[ANAN94]: Sarabjot S. Anand, David A. Bell, John G. Hughes: Database Mining in the Architecture of a Semantic Preprocessor for State Aware Query Optimization. KDD Workshop 1994: 287-298
[ANAN94a]: ...
[BABB79]: Edward Babb: Implementing a Relational Database by Means of Specialized Hardware. ACM Trans. Database Syst. 4(1): 1-29(1979)
[BABB85]: ...
[COUL72]: ...
[INGR91]: ...
[LEUN85]: Clement H. C. Leung, K. S. Wong: File Processing Efficiency on the Content Addressable File Store. VLDB 1985: 282-291
[NIHE88]: ...
[WILE85]: ...