Efficient main memory data management using the DBgraph storage model
Proceedings of the sixteenth international conference on Very large databases
Organizing long-running activities with triggers and transactions
SIGMOD '90 Proceedings of the 1990 ACM SIGMOD international conference on Management of data
Distributed and Parallel Databases - Special issue: Research topics in distributed and parallel databases
Strip: a soft real-time main memory database for open systems
Strip: a soft real-time main memory database for open systems
View indexing in relational databases
ACM Transactions on Database Systems (TODS)
Overview of the STanford Real-time Information Processor (STRIP)
ACM SIGMOD Record
On Transaction Boundaries in Active Databases: A Performance Perspective
IEEE Transactions on Knowledge and Data Engineering
Main Memory Database Systems: An Overview
IEEE Transactions on Knowledge and Data Engineering
Database Support for Efficiently Maintaining Derived Data
EDBT '96 Proceedings of the 5th International Conference on Extending Database Technology: Advances in Database Technology
Deriving Production Rules for Incremental View Maintenance
VLDB '91 Proceedings of the 17th International Conference on Very Large Data Bases
Composite Event Specification in Active Databases: Model & Implementation
VLDB '92 Proceedings of the 18th International Conference on Very Large Data Bases
A Multidatabase System for Tracking and Retrieval of Financial Data
VLDB '94 Proceedings of the 20th International Conference on Very Large Data Bases
Composite Events for Active Databases: Semantics, Contexts and Detection
VLDB '94 Proceedings of the 20th International Conference on Very Large Data Bases
NAOS - Efficient and Modular Reactive Capabilities in an Object-Oriented Database System
VLDB '94 Proceedings of the 20th International Conference on Very Large Data Bases
Design and performance evaluation of a main memory relational database system (t tree)
Design and performance evaluation of a main memory relational database system (t tree)
Project synopsis: evaluating STRIP
CIKM '96 Proceedings of the workshop on Databases: active and real-time
Triggered Updates for Temporal Consistency in Real-TimeDatabases
Real-Time Systems
Effective Scheduling of Detached Rules in Active Databases
IEEE Transactions on Knowledge and Data Engineering
Real-Time and Active Databases: A Survey
ARTDB '97 Proceedings of the Second International Workshop on Active, Real-Time, and Temporal Database Systems
Active rules for XML: A new paradigm for E-services
The VLDB Journal — The International Journal on Very Large Data Bases
Schema driven assignment and implementation of life science identifiers (LSIDs)
Journal of Biomedical Informatics
| Hi-index | 0.00 |
Derived data is maintained in a database system to correlate and summarize base data which records real world facts. As base data changes, derived data needs to be recomputed. This is often implemented by writing active rules that are triggered by changes to base data. In a system with rapidly changing base data, a database with a standard rule system may consume most of its resources running rules to recompute data. This paper presents the rule system implemented as part of the STandard Real-time Information Processor (STRIP). The STRIP rule system is an extension of SQL3-type rules that allows groups of rule actions to be batched together to reduce the total recomputation load on the system. In this paper we describe the syntax and semantics of the STRIP rule system, present an example set of rules to maintain stock index and theoretical option prices in a program trading application, and report the results of experiments performed on the running system. The experiments verify that STRIP's rules allow much more efficient derived data maintenance than conventional rules without batching.