Browse Prior Art Database

General database monitoring development environment

IP.com Disclosure Number: IPCOM000194642D
Publication Date: 2010-Apr-06
Document File: 1 page(s) / 20K

Publishing Venue

The IP.com Prior Art Database

Abstract

IBM Tivoli Composite Application Management (ITCAM) for Applications is one of a family of solutions based on Tivoli Monitoring product. ITCAM helps to ensure the availability and performance of critical applications and application middleware in an integratted e-business environment. The capabilities include the following: Auto-discovery of resources to be monitored Problem identification, notification and correction Historical reporting through centralized data warehouse Database system monitoring is a critical part of ITCAM. And there are a number of strong competitors in the industry such as Quest, BMC and CA. For database monitoring, how to develop the database monitoring application to meet the customer's requirement and make the collected data is accurate is an important problem to solve. A challenge issue in database monitoring is how quickly developing the monitoring application with high quality and stable. Most industry products used the hard coded in C/C++ or Java, which make the application development effort big, and big effort in the maintenance life cycle. The hard coded application is hard to test for each database version it need support. Disclosure is a general database monitoring development environment, to allow the developer developing the database monitoring application quickly, generate the database access code automatically, generate collected data presentation and generate the automation test case. The proposed invention is implemented in ITCAM Oracle RAC agent, which will be delivered by Nov. 2009. In addition to Oracle, similar mechanism can be applied to other databases such as DB2, Sybase or Informix.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 62% of the total text.

Page 1 of 1

General database monitoring development environment

General database monitoring development environmentGeneral database monitoring development environment

SQL Definition

SQL DefinitionSQL Definition

     In the SQL definition, the developer need to specify the which requirement ID, and which database version this SQL is compliant. The following sample shows the SQL collecting the SGA information in a database version 10.1 and up, and the requirement ID is RDB_SGA_Detail.
<SQL DBVersion="101" SQLText="

SELECT
INST_ID INSTID,
POOL POOLRESIDE,
NAME COMPNAME,
BYTES MEMSIZE,
round(BYTES/1024,2) * 100 MEMKB,
round(BYTES/(1024*1024),2) * 100 MEMMB
FROM GV$SGASTAT
ORDER BY INST_ID,POOL,NAME
"/>

SQL Engine

SQL EngineSQL Engine


The SQL engine takes the SQL definition as the input data, parse the SQL definition, and run the specified SQL at a real database. By analyzing the information returned from database, the SQL engine knows each column's name, type. More on this, the SQL engine knows what's the valid data on this SQL, and how the collected data should be shown. For example, for the datetime type column, the collected data should be shown as the format YYYY-MM-DD.

Base on the SQL definition and information returned from database, the SQL engine can generate the SQL accessing code for developer, generate the data presentation code depends on how developer present the collected data, and generate the automation test case with test data for QA team .

Generated SQL Accessing Code

Generat...