Performance Management Database (PMDB), a Precise repository, stores application performance data for long-term analysis and trending reports. The data is collected by the Precise product suite, which has been designed to provide a comprehensive and methodical performance management solution.
Precise includes the following four major component products: Alerts, Report Manager, Insight, and the Precise family of products. All Precise products use the PMDB to collect and store long-term historical information throughout the application life cycle. For more information, refer to the relevant user’s guide and to the Precise Administration Guide.
The Precise PMDB API Reference Guide explains how you can customize the infrastructure of the PMDB such as to store and retrieve application data that is not loaded into the database by default. You can then perform correlations between your data and data collected by Precise.
This guide explains how to use Precise utilities to perform the following:
- Define and create your own data structure in the PMDB by means of DDML (Data Definition Markup Language).
Creating DDML Documents details the DDML format and explains how to create the database entities using the provided shell script.
- Load your own data into the PMDB using the Data Loader.
Loading Data details the XML format and explains how to load data into the PMDB.
- Retrieve your own data from the PMDB using the Data Retriever.
Retrieving Data details the XML retrieve format and explains how to retrieve data from the PMDB.
The protocols used to define the data structure, load application data, and retrieve that data when needed are derived from the XML (Extensible Markup Language) technology. XML provides a simple and intuitive way to complete these tasks.
We recommend that you use the Precise utilities to take full advantage of the PMDB capabilities:
- Use the PMDB's aggregation mechanism.
- Use the PMDB's purging mechanism.
Store and handle data efficiently—through partitions in an Oracle database and through partitioned views in a Microsoft SQL Server database.
- About the Precise PMDB
- Configuration with MS-SQL
- Configuration with Oracle
- Creating DDML documents
- Loading data
- Retrieving data
- Managing data
- Naming conventions
- Insight general tables
- Insight OS tables
- Insight network and other tables
- Precise for SQL Server tables
- Insight SQL Server group tables
- Precise for Oracle tables
- Insight Oracle application tables
- Insight Oracle groups tables
- Precise for SAP tables
- Insight SAP group tables
- Precise for Web tables
- Insight for Tuxedo tables
- Insight MQ tables
- Precise for J2EE tables
- Precise for Microsoft .NET tables
- Precise for Sybase RS tables
- Precise for Sybase tables
- Precise for vCenter Server tables
- Examples