Page History

...

The following example presents a possible DDML document.

<tables-definition product=“CD”><"CD"><!-- CD for customer data -->
<!-- example for a timeslice statistics level table for the Customer’s Customer's J2EE data -->
     <table-definition name=“PW"PW_JECD_CUSTOMER_DATA_T” T" type=“STATISTICS” "STATISTICS" filterable=“TRUE” "TRUE" oracle-storage-clause=“NEXT "NEXT 4M PCTINCREASE 0”>0">
          <column-definition name=“JECD"JECD_TIMESTAMP” TIMESTAMP" data-type=“TIMESTAMP” "TIMESTAMP" null=“FALSE” "FALSE" type=“DATE” "DATE" /><!-- mandatory column -->
          <column-definition name=“JECD"JECD_PWHG_ID” ID" data-type=“INTEGER” "INTEGER" data-length=“4” "4" null=“FALSE” "FALSE" type=“IDENTIFIER” "IDENTIFIER" default=“0”"0"/><!-- mandatory column -->
          <column-definition name=“JECD"JECD_MINUTES_COUNT_SUM” SUM" data-type=“INTEGER” "INTEGER" data-length=“9” "9" null=“FALSE” "FALSE" type=“SUM” "SUM" default=“1”"1"/><!-- mandatory column -->
          <column-definition name=“JECD"JECD_PWII_INSTANCE_ID” ID" data-type=“INTEGER” "INTEGER" data-length=“9” "9" null=“FALSE” "FALSE" type=“IDENTIFIER”"IDENTIFIER"/><!-- mandatory column -->
          <column-definition name=“JECD"JECD_RECIEVED_TIMESTAMP” TIMESTAMP" data-type=“TIMESTAMP” "TIMESTAMP" null=“FALSE” "FALSE" default=“CURRENT TIMESTAMP” "CURRENT TIMESTAMP" type=“DATE”"DATE"/><!-- mandatory column -->
          <column-definition name=“JECD"JECD_IS_SERVICE_REQUEST” REQUEST" data-type=“BOOLEAN” "BOOLEAN" null=“FALSE” "FALSE" type=“IDENTIFIER” "IDENTIFIER" default=“FALSE” "FALSE" baseline-value=“F”"F"/><!-- identifer definition -->
          <column-definition name=“JECD"JECD_THRESHOLD_BREACH” BREACH" data-type=“BOOLEAN” "BOOLEAN" null=“TRUE” "TRUE" type=“IDENTIFIER”"IDENTIFIER"/><!-- identifer definition -->
          <column-definition name=“JECD"JECD_TYPE” TYPE" data-type=“VARCHAR” "VARCHAR" data-length=“254” "254" null=“FALSE” "FALSE" type=“IDENTIFIER” "IDENTIFIER" /><!-- identifer definition -->
          <column-definition name=“JECD"JECD_RESPONSE_TIME_SUM” SUM" data-type=“FLOAT” "FLOAT" data-length=“15” "15" null=“FALSE” "FALSE" type=“SUM” "SUM" default=“0”"0"/><!-- counter definition -->
          <column-definition name=“JECD"JECD_HIT_COUNT_SUM” SUM" data-type=“INTEGER” "INTEGER" data-length=“19” "19" null=“FALSE” "FALSE" type=“SUM” "SUM" default=“0”"0"/><!-- counter definition -->
          <column-definition name=“JECD"JECD_INTERNAL_TIME_SUM” SUM" data-type=“FLOAT” "FLOAT" data-length=“15” "15" null=“FALSE” "FALSE" type=“SUM” "SUM" default=“0”"0"/><!-- counter definition -->
          <column-definition name=“JECD"JECD_JDBC_TIME_AVG” AVG" data-type=“FLOAT” "FLOAT" data-length=“15” "15" null=“FALSE” "FALSE" type=“AVG” "AVG" default=“0”"0"/><!-- counter definition -->
          <column-definition name=“JECD"JECD_ACTIVE_THREADS_AVG” AVG" data-type=“FLOAT” "FLOAT" data-length=“15” "15" null=“TRUE” "TRUE" type=“AVG”"AVG"/><!-- counter definition -->
          <index-definition name=“IW"IW_JECD_01_T” T" unique=“FALSE” "FALSE" primary=“FALSE” "FALSE" clustered=“FALSE” "FALSE" columns-order=“JECD"JECD_PWII_INSTANCE_ID ASC JECD_RECIEVED_TIMESTAMP ASC JECD_TIMESTAMP ASC” ASC" oracle-storage-clause=“NEXT "NEXT 4M PCTINCREASE 0”0"/><!-- index definition -->
          <summary-hour name=“PW"PW_JECD_CUSTOMER_DATA_H”H"/><!-- indication to summarize the data at an hourly level -->
          <summary-day name=“PW"PW_JECD_CUSTOMER_DATA_D”D"/><!-- indication to summarize the data at a dayly level -->
          <summary-week name=“PW"PW_JECD_CUSTOMER_DATA_W”W"/><!-- indication to summarize the data at a weekly level -->
          <summary-month name=“PW"PW_JECD_CUSTOMER_DATA_M”M"/><!-- indication to summarize the data at a monthly level -->
          <baseline name=“PW"PW_JECD_CUSTOMER_DATA_B” B" oracle-additional-clause=“NOLOGGING”"NOLOGGING"/><!-- indication to create a baseline for that table -->
     </table-definition>
<!-- example for a nonstatistcs table that should be part of the PMDB schema -->
     <table-definition name=“PW"PW_ORSR_STRUCTURE_CONTROL” CONTROL" type=“PWOTHER” "PWOTHER" oracle-storage-clause=“initial "initial 1M next 10M minextents 1 maxextents unlimited pctincrease 0”>0">
          <column-definition name=“ORSR"ORSR_DATABASE_ID” ID" data-type=“VARCHAR” "VARCHAR" data-length=“255” "255" null=“TRUE”"TRUE"/>
          <column-definition name=“ORSR"ORSR_UPDATE_START” START" data-type=“TIMESTAMP” "TIMESTAMP" null=“TRUE”"TRUE"/>
          <column-definition name=“ORSR"ORSR_STATUS” STATUS" data-type=“VARCHAR” "VARCHAR" data-length=“30” "30" null=“TRUE”"TRUE"/>
          <column-definition name=“ORSR"ORSR_ROW_TYPE” TYPE" data-type=“VARCHAR” "VARCHAR" data-length=“2” "2" null=“TRUE”"TRUE"/>
          <column-definition name=“ORSR"ORSR_PURGE_DATE” DATE" data-type=“TIMESTAMP” "TIMESTAMP" null=“TRUE”"TRUE"/>
          <column-definition name=“ORSR"ORSR_LAST_PURGED_TABLE” TABLE" data-type=“VARCHAR” "VARCHAR" data-length=“30” "30" null=“TRUE”"TRUE"/>
     </table-definition>
<!-- example for a view creation -->
     <view-definition name=“ACTIVE"ACTIVE_STATUS_VIEW” VIEW" view-columns=“DATABASE"DATABASE_ID DATABASE_STATUS” STATUS" as-query=“SELECT "SELECT ORSR_DATABASE_ID,ORSR_STATUS FROM PW_ORSR_STRUCTURE_CONTROL WHERE ORSR_STATUS=‘ACTIVE’”'ACTIVE'"/>
<!-- example for DDL/DML commands that should be performed during installation -->
     <ddl-definition dbms=“ORACLE” "ORACLE" version=“” "" event=“INSTALL” "INSTALL" statement=“create "create sequence PRECISE_STATEMENT_ID_SEQ”SEQ"/>
<!-- example for DDL/DML commands that should be performed during uninstallation -->
     <ddl-definition dbms=“ORACLE” "ORACLE" version=“” "" event=“UNINSTALL” "UNINSTALL" statement=“drop "drop sequence PRECISE_STATEMENT_ID_SEQ”SEQ"/>
</tables-definition>

Retrieve Request Example

The following example sends one query to retrieve data.