Selective deferred index maintenance & concurrency control in integrated information systems

  • Authors:
  • Peter Dadam;Vincent Y. Lum;U. Prädel;Gunter Schlageter

  • Affiliations:
  • -;-;-;-

  • Venue:
  • VLDB '85 Proceedings of the 11th international conference on Very Large Data Bases - Volume 11
  • Year:
  • 1985

Quantified Score

Hi-index 0.01

Visualization

Abstract

New applications of database management systems as in office automation and engineering require the system to process both textual and formatted data. To support text search appropriately, text indexes must be created and on-line text index maintenance be provided. Un- fortunately, text index maintenance is generally a time-consuming task and does not fit well in an on-line environment, where short transaction processing times are usually required. In this paper we discuss how the time for those transactions, which cause text index up-dates, can be shortened by integrating a dedicated predicate-oriented concurrency control method and a selective deferred index update strategy. We also show some practical implementation techniques and some aspects of their performances.