Use this resource - and many more! - in your textbook!
AcademicPub holds over eight million pieces of educational content for you to mix-and-match your way.
Scalable trigger processing
By: Noronha, L.; Carnes, C.; Konyala, M.; Huang, L.; Parthasarathy, S.; Hanson, E.N.; Vernon, A.; Park, J.B.;
1999 / IEEE / 0-7695-0071-4
This item was taken from the IEEE Conference ' Scalable trigger processing ' Current database trigger systems have extremely limited scalability. This paper proposes a way to develop a truly scalable trigger system. Scalability to large numbers of triggers is achieved with a trigger cache to use the main memory effectively, and a memory-conserving selection predicate index based on the use of unique expression formats called expression signatures. A key observation is that if a very large number of triggers are created, many will have the same structure, except for the appearance of different constant values. When a trigger is created, tuples are added to special relations created for expression signatures to hold the trigger's constants. These tables can be augmented with a database index or main-memory index structure to serve as a predicate index. The design presented also uses a number of types of concurrency to achieve scalability, including token (tuple)-level, condition-level, rule action-level and data-level concurrency.
Main Memory Usage
Memory-conserving Selection Predicate Index
Database Index Structure
Main-memory Index Structure
Rule Action-level Concurrency
Electrical Capacitance Tomography
Database Trigger Systems
Scalable Trigger Processing
Unique Expression Formats