Trigger Performance Characteristics in Temporal Environment

Abstract

Data characteristics stored in the database evolve over the time. Nowadays, it is inevitable to store all states of the objects over the time. Paradigms of conventional database are based on managing actual states, which are inappropriate. Therefore, temporal approach has been developed. In this paper, we deal with our proposed temporal solution based on attribute level architecture, which can be used effectively, if the granularity of the attribute change frequency is not the same. Another aspect of the data stored in the database is based on security, therefore, it is necessary to provide access to the data and perform changes only by privileged users. This requirement is mostly provided by the triggers. Multiple trigger characteristics influenced by individual clauses can be declared. Therefore, decision and development must be based on suitability and correctness to provide best performance. In this paper, we define clauses for triggers and compare performance.