Selective Deferred Index Maintenance & Concurrency Control in Integrated Information Systems

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. Unfortunately, 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 fcr those transactions, which cause text index updates, san be shortened by integrating a dedicated predicate-oriented concurrency control method and a selecti.“: deferred index update strategy. We also show some 2s*Rctical implp.mentation techniques and some aspects of their performances.