of Thesis Presented to the Graduate School of the University of Florida in Partial Fulfillment of the Requirements for the Degree of Master of Science ENHANCED TECHNIQUES FOR TIMER TRIGGER PROCESSING By Lloyd X. Noronha August, 1999 Chairman: Eric Hanson Major Department: Computer and Information Science and Engineering Timer-Driven Triggers allow users to monitor interesting tuples or interesting changes to tuples of a view. Trigger condition testing takes place periodically, i.e., once every few hours, days or weeks. When the timer of a trigger expires, a new copy of the view is retrieved and the trigger predicates applied to that view. Trigger predicates could be transition predicates referring to the attribute values of tuples of a view from the previous timer expiration. Timer Triggers differ from conventional triggers, in that the trigger testing is not done for updated tuples only. Timer triggers could be fired on tuples of a view simply because they satisfy the predic...

....................................................................................................................... vi CHAPTERS 1. INTRODUCTION ......................................................................................................... 1 2. OVERVIEW OF THE TRIGGERMAN ....................................................................... 6 2.1 Introduction ....................................................................................................... 6 2.2 TriggerMan Architecture................................................................................... 7 2.3 TriggerMan Command Language ..................................................................... 8 2.4 The Selection Predicate Indexing Scheme ........................................................ 8 3. RELATED WORK...................................................................................................... 12 3.1 Introduction to Ingres ...................................................