Page History
| Table of Contents | ||||
|---|---|---|---|---|
|
DDML
...
Document Example
The following example presents a possible DDML document.
<tables-definition product=“CD”><!-- CD for customer data -->
<!-- example for a timeslice statistics level table for the Customer’s J2EE data -->
<table-definition name=“PW_JECD_CUSTOMER_DATA_T” type=“STATISTICS” filterable=“TRUE” oracle-storage-clause=“NEXT 4M PCTINCREASE 0”>
<column-definition name=“JECD_TIMESTAMP” data-type=“TIMESTAMP” null=“FALSE” type=“DATE” /><!-- mandatory column -->
<column-definition name=“JECD_PWHG_ID” data-type=“INTEGER” data-length=“4” null=“FALSE” type=“IDENTIFIER” default=“0”/><!-- mandatory column -->
<column-definition name=“JECD_MINUTES_COUNT_SUM” data-type=“INTEGER” data-length=“9” null=“FALSE” type=“SUM” default=“1”/><!-- mandatory column -->
<column-definition name=“JECD_PWII_INSTANCE_ID” data-type=“INTEGER” data-length=“9” null=“FALSE” type=“IDENTIFIER”/><!-- mandatory column -->
<column-definition name=“JECD_RECIEVED_TIMESTAMP” data-type=“TIMESTAMP” null=“FALSE” default=“CURRENT TIMESTAMP” type=“DATE”/><!-- mandatory column -->
<column-definition name=“JECD_IS_SERVICE_REQUEST” data-type=“BOOLEAN” null=“FALSE” type=“IDENTIFIER” default=“FALSE” baseline-value=“F”/><!-- identifer definition -->
<column-definition name=“JECD_THRESHOLD_BREACH” data-type=“BOOLEAN” null=“TRUE” type=“IDENTIFIER”/><!-- identifer definition -->
<column-definition name=“JECD_TYPE” data-type=“VARCHAR” data-length=“254” null=“FALSE” type=“IDENTIFIER” /><!-- identifer definition -->
<column-definition name=“JECD_RESPONSE_TIME_SUM” data-type=“FLOAT” data-length=“15” null=“FALSE” type=“SUM” default=“0”/><!-- counter definition -->
<column-definition name=“JECD_HIT_COUNT_SUM” data-type=“INTEGER” data-length=“19” null=“FALSE” type=“SUM” default=“0”/><!-- counter definition -->
<column-definition name=“JECD_INTERNAL_TIME_SUM” data-type=“FLOAT” data-length=“15” null=“FALSE” type=“SUM” default=“0”/><!-- counter definition -->
<column-definition name=“JECD_JDBC_TIME_AVG” data-type=“FLOAT” data-length=“15” null=“FALSE” type=“AVG” default=“0”/><!-- counter definition -->
<column-definition name=“JECD_ACTIVE_THREADS_AVG” data-type=“FLOAT” data-length=“15” null=“TRUE” type=“AVG”/><!-- counter definition -->
<index-definition name=“IW_JECD_01_T” unique=“FALSE” primary=“FALSE” clustered=“FALSE” columns-order=“JECD_PWII_INSTANCE_ID ASC JECD_RECIEVED_TIMESTAMP ASC JECD_TIMESTAMP ASC” oracle-storage-clause=“NEXT 4M PCTINCREASE 0”/><!-- index definition -->
<summary-hour name=“PW_JECD_CUSTOMER_DATA_H”/><!-- indication to summarize the data at an hourly level -->
<summary-day name=“PW_JECD_CUSTOMER_DATA_D”/><!-- indication to summarize the data at a dayly level -->
<summary-week name=“PW_JECD_CUSTOMER_DATA_W”/><!-- indication to summarize the data at a weekly level -->
<summary-month name=“PW_JECD_CUSTOMER_DATA_M”/><!-- indication to summarize the data at a monthly level -->
<baseline name=“PW_JECD_CUSTOMER_DATA_B” oracle-additional-clause=“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_ORSR_STRUCTURE_CONTROL” type=“PWOTHER” oracle-storage-clause=“initial 1M next 10M minextents 1 maxextents unlimited pctincrease 0”>
<column-definition name=“ORSR_DATABASE_ID” data-type=“VARCHAR” data-length=“255” null=“TRUE”/>
<column-definition name=“ORSR_UPDATE_START” data-type=“TIMESTAMP” null=“TRUE”/>
<column-definition name=“ORSR_STATUS” data-type=“VARCHAR” data-length=“30” null=“TRUE”/>
<column-definition name=“ORSR_ROW_TYPE” data-type=“VARCHAR” data-length=“2” null=“TRUE”/>
<column-definition name=“ORSR_PURGE_DATE” data-type=“TIMESTAMP” null=“TRUE”/>
<column-definition name=“ORSR_LAST_PURGED_TABLE” data-type=“VARCHAR” data-length=“30” null=“TRUE”/>
</table-definition>
<!-- example for a view creation -->
<view-definition name=“ACTIVE_STATUS_VIEW” view-columns=“DATABASE_ID DATABASE_STATUS” as-query=“SELECT ORSR_DATABASE_ID,ORSR_STATUS FROM PW_ORSR_STRUCTURE_CONTROL WHERE ORSR_STATUS=‘ACTIVE’”/>
<!-- example for DDL/DML commands that should be performed during installation -->
<ddl-definition dbms=“ORACLE” version=“” event=“INSTALL” statement=“create sequence PRECISE_STATEMENT_ID_SEQ”/>
<!-- example for DDL/DML commands that should be performed during uninstallation -->
<ddl-definition dbms=“ORACLE” version=“” event=“UNINSTALL” statement=“drop sequence PRECISE_STATEMENT_ID_SEQ”/>
</tables-definition>