Database Management Technology

The DBAnalyzer Performance Database exposes performace metrics maintained by Ingres and the host operating system. These metrics are represented as a collection of tables in the DBAnalyzer database. These tables fall into two broad types, primitive and virtual. Both table types are queried the same way and the distinction is largely transparent to the user.

Primitive Tables

• organize raw Ingres metrics exposed by the IMA interface
• registered in the DBAnalyzer database at build time
• naming convention is table_name_prim
• dynamically populated by the IMA gateway when queried
• consume no disk space
• visible to DBAnalyzer and Ingres supplied query tools

Virtual Tables

• expose calculated values and operating system statistics not available through IMA
• for Ingres metrics this includes items such as delta columns and data items requiring some degree of computation
• provide derived data items which are difficult to compute using standard SQL
• dynamically materialized by the DBAnalyzer Query Engine as Ingres global temporary tables
• visible only through the DBAnalyzer supplied query tools

Example

wait_locklists table

• contains one row for each locklist in a lock wait state
• the table is not created or updated until it is queried by one of the DBAnalyzer tools
• steps required to create and update the table are transparent to the user
• the timestamp column measures the duration of the lock wait state
• simplifies the process of writing Sentinel alarms which detect lock waits of a given duration