We confront the promises of active database systems with the result of their use by application developers. The main problems encountered are insufficient methodological support in analysis and design, the lack of standardization, missing development and administration tools for triggers, and weak performance. We concentrate on performance because we discovered it is one the main reasons that makes users reluctant to use active rules in the development of large applications. We show, using simple concrete examples, that optimizing large applications is rendered difficult by the separation of transactions and triggers and the misunderstanding of their subtle interactions. We argue that tools, which provide assistance to both programmers and database designers to optimize their applications and master their evolution are strongly needed.
Joint work with: Angelika Kotz-Dittrich, Union Bank of Switzerland, Switzerland. Results of this work were published in the proc. of VLDB'95.