Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\lib\oracle\dms\aggregator\aggregator.xsd
<?xml version='1.0' encoding='UTF-8' ?> <schema targetNamespace="http://www.oracle.com/iAS/aggregator" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:ag="http://www.oracle.com/iAS/aggregator" xmlns="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified"> <annotation> <documentation xml:lang="en"> Aggregator schema Copyright (c) 2004, Oracle Corporation. All rights reserved. </documentation> </annotation> <!-- include the common definition --> <include schemaLocation="aggregatorCommons.xsd"/> <!-- Do not use "Rate" element inside "Union" element. If "Rate" element contains both "ColumnFrom" elements, it calculates the rate of change using the following algorithm. {delta of ColumnFrom1} = {Current Value of ColumnFrom1} - {Previous Value of ColumnFrom1} {delta of ColumnFrom2} = {Current Value of ColumnFrom2} - {Previous Value of ColumnFrom2} rate = {delta of ColumnFrom1} / {delta of ColumnFrom2} If "Rate" element contains only one "ColumnFrom" element, it calculates the rate of change using the following algorithm. {interval} = {interval between the two samplings} rate = {delta of ColumnFrom1} / {interval} If {delta of ColumnFrom2} or {interval} is 0, it returns the default value specified by the "Default" element. --> <element name="Rate"> <complexType> <sequence> <!-- You should only reference tables specified in "TableFrom" elements. The tables referenced should have key columns and the values of the key columns should not change between archiving. The two column values specified by both "ColumnFrom" elements will be taken from the same cross table row. This means that you can not calculate the rate between two column values at the two different table rows. --> <element name="ColumnFrom" type="ag:ColumnFrom_T" maxOccurs="2"/> <element name="Default" type="token" minOccurs="0"/> </sequence> <!-- archiving interval in milliseconds. It should not be less than 1000 milliseconds --> <attribute name="Interval" type="ag:PositiveInt1k" use="required"/> <!-- do not use "Always" more than necessary --> <attribute name="Archiving" type="ag:ArchiveOptions_T" default="OnDemand"/> </complexType> </element> <!-- Rate --> <!-- The global type definition for archiving previous values --> <simpleType name="ArchiveOptions_T"> <restriction base="Name"> <enumeration value="OnDemand"/> <enumeration value="Always"/> </restriction> </simpleType> <!-- The global type definition for condition type --> <complexType name="ConditionTopSelectChoice_T"> <group ref="ag:ConditionTopSelectChoice"/> </complexType> <!-- The global type definition for unbound condition type --> <complexType name="ConditionTopSelectChoiceUnbound_T"> <group ref="ag:ConditionTopSelectChoice" minOccurs="2" maxOccurs="unbounded"/> </complexType> <!-- choice group definition for conditions --> <group name="ConditionTopSelectChoice"> <choice> <element name="Condition"> <complexType> <sequence> <choice> <element name="ColumnFrom" type="ag:ColumnFrom_T"/> <element name="Expression" type="ag:ExpressionSelect_T"/> <element name="Aggregation" type="ag:AggregationSelect_T"/> <element name="If" type="ag:IfSelect_T"/> <element ref="ag:Function"/> <element ref="ag:GetEnv"/> <element ref="ag:Rate"/> <element ref="ag:Value"/> </choice> <choice> <element name="ColumnFrom" type="ag:ColumnFrom_T"/> <element name="Expression" type="ag:ExpressionSelect_T"/> <element name="Aggregation" type="ag:AggregationSelect_T"/> <element name="If" type="ag:IfSelect_T"/> <element ref="ag:Function"/> <element ref="ag:GetEnv"/> <element ref="ag:Rate"/> <element ref="ag:Value"/> <!-- "Null" element can only be used when the "Operator" attribute is "EQ" or "NE" --> <element ref="ag:Null"/> </choice> </sequence> <attribute name="Operator" type="ag:ConditionOperator_T" default="EQ"/> <attribute name="Type" type="ag:ColumnValue_T" use="required"/> </complexType> </element> <!-- Condition --> <element name="And" type="ag:ConditionTopSelectChoiceUnbound_T"/> <element name="Or" type="ag:ConditionTopSelectChoiceUnbound_T"/> <element name="Not" type="ag:ConditionTopSelectChoice_T"/> </choice> </group> <!-- ConditionTopSelectChoice --> <!-- The global type definition for condition type --> <complexType name="ConditionSelectChoice_T"> <group ref="ag:ConditionSelectChoice"/> </complexType> <!-- The global type definition for unbound condition type --> <complexType name="ConditionSelectChoiceUnbound_T"> <group ref="ag:ConditionSelectChoice" minOccurs="2" maxOccurs="unbounded"/> </complexType> <!-- choice group definition for conditions --> <group name="ConditionSelectChoice"> <choice> <element name="Condition"> <complexType> <sequence> <choice> <element name="ColumnFrom" type="ag:ColumnFrom_T"/> <element name="Expression" type="ag:ExpressionSelect_T"/> <element name="Aggregation" type="ag:AggregationSelect_T"/> <element name="If" type="ag:IfSelect_T"/> <element ref="ag:Function"/> <element ref="ag:GetEnv"/> <element ref="ag:Rate"/> <element ref="ag:Value"/> </choice> <choice> <element name="ColumnFrom" type="ag:ColumnFrom_T"/> <element name="Expression" type="ag:ExpressionSelect_T"/> <element name="Aggregation" type="ag:AggregationSelect_T"/> <element name="If" type="ag:IfSelect_T"/> <element ref="ag:Function"/> <element ref="ag:GetEnv"/> <element ref="ag:Rate"/> <element ref="ag:Value"/> <!-- "Null" element can only be used when the "Operator" attribute is "EQ" or "NE" --> <element ref="ag:Null"/> </choice> </sequence> <attribute name="Operator" type="ag:ConditionOperator_T" default="EQ"/> </complexType> </element> <!-- Condition --> <element name="And" type="ag:ConditionSelectChoiceUnbound_T"/> <element name="Or" type="ag:ConditionSelectChoiceUnbound_T"/> <element name="Not" type="ag:ConditionSelectChoice_T"/> </choice> </group> <!-- ConditionSelectChoice --> <!-- The global type definition for condition type --> <complexType name="ConditionTopWhereChoice_T"> <group ref="ag:ConditionTopWhereChoice"/> </complexType> <!-- The global type definition for unbound condition type --> <complexType name="ConditionTopWhereChoiceUnbound_T"> <group ref="ag:ConditionTopWhereChoice" minOccurs="2" maxOccurs="unbounded"/> </complexType> <!-- choice group definition for conditions --> <group name="ConditionTopWhereChoice"> <choice> <element name="Condition"> <complexType> <sequence> <choice> <element name="ColumnFrom" type="ag:ColumnFrom_T"/> <element name="Expression" type="ag:ExpressionWhere_T"/> <element name="If" type="ag:IfWhere_T"/> <element ref="ag:Function"/> <element ref="ag:GetEnv"/> <element ref="ag:Value"/> <element ref="ag:Rate"/> </choice> <choice> <element name="ColumnFrom" type="ag:ColumnFrom_T"/> <element name="Expression" type="ag:ExpressionWhere_T"/> <element name="If" type="ag:IfWhere_T"/> <element ref="ag:Function"/> <element ref="ag:GetEnv"/> <element ref="ag:Value"/> <element ref="ag:Rate"/> <!-- "Null" element can only be used when the "Operator" attribute is "EQ" or "NE" --> <element ref="ag:Null"/> </choice> </sequence> <attribute name="Operator" type="ag:ConditionOperator_T" default="EQ"/> <attribute name="Type" type="ag:ColumnValue_T" use="required"/> </complexType> </element> <!-- Condition --> <element name="And" type="ag:ConditionTopWhereChoiceUnbound_T"/> <element name="Or" type="ag:ConditionTopWhereChoiceUnbound_T"/> <element name="Not" type="ag:ConditionTopWhereChoice_T"/> </choice> </group> <!-- ConditionTopWhereChoice --> <!-- The global type definition for condition type --> <complexType name="ConditionWhereChoice_T"> <group ref="ag:ConditionWhereChoice"/> </complexType> <!-- The global type definition for unbound condition type --> <complexType name="ConditionWhereChoiceUnbound_T"> <group ref="ag:ConditionWhereChoice" minOccurs="2" maxOccurs="unbounded"/> </complexType> <!-- choice group definition for conditions --> <group name="ConditionWhereChoice"> <choice> <element name="Condition"> <complexType> <sequence> <choice> <element name="ColumnFrom" type="ag:ColumnFrom_T"/> <element name="Expression" type="ag:ExpressionWhere_T"/> <element name="If" type="ag:IfWhere_T"/> <element ref="ag:Function"/> <element ref="ag:GetEnv"/> <element ref="ag:Value"/> <element ref="ag:Rate"/> </choice> <choice> <element name="ColumnFrom" type="ag:ColumnFrom_T"/> <element name="Expression" type="ag:ExpressionWhere_T"/> <element name="If" type="ag:IfWhere_T"/> <element ref="ag:Function"/> <element ref="ag:GetEnv"/> <element ref="ag:Value"/> <element ref="ag:Rate"/> <!-- "Null" element can only be used when the "Operator" attribute is "EQ" or "NE" --> <element ref="ag:Null"/> </choice> </sequence> <attribute name="Operator" type="ag:ConditionOperator_T" default="EQ"/> </complexType> </element> <!-- Condition --> <element name="And" type="ag:ConditionWhereChoiceUnbound_T"/> <element name="Or" type="ag:ConditionWhereChoiceUnbound_T"/> <element name="Not" type="ag:ConditionWhereChoice_T"/> </choice> </group> <!-- ConditionWhereChoice --> <!-- The global type definition for condition type --> <complexType name="ConditionUnionChoice_T"> <group ref="ag:ConditionUnionChoice"/> </complexType> <!-- The global type definition for unbound condition type --> <complexType name="ConditionUnionChoiceUnbound_T"> <group ref="ag:ConditionUnionChoice" minOccurs="2" maxOccurs="unbounded"/> </complexType> <!-- choice group definition for conditions --> <group name="ConditionUnionChoice"> <choice> <element name="Condition"> <complexType> <sequence> <choice> <element name="ColumnFrom" type="ag:Name_T"/> <element name="Expression" type="ag:ExpressionUnion_T"/> <element name="Aggregation" type="ag:AggregationUnion_T"/> <element name="If" type="ag:IfUnion_T"/> <element ref="ag:Function"/> <element ref="ag:GetEnv"/> <element ref="ag:Value"/> </choice> <choice> <element name="ColumnFrom" type="ag:Name_T"/> <element name="Expression" type="ag:ExpressionUnion_T"/> <element name="Aggregation" type="ag:AggregationUnion_T"/> <element name="If" type="ag:IfUnion_T"/> <element ref="ag:Function"/> <element ref="ag:GetEnv"/> <element ref="ag:Value"/> <!-- "Null" element can only be used when the "Operator" attribute is "EQ" or "NE" --> <element ref="ag:Null"/> </choice> </sequence> <attribute name="Operator" type="ag:ConditionOperator_T" default="EQ"/> </complexType> </element> <!-- Condition --> <element name="And" type="ag:ConditionUnionChoiceUnbound_T"/> <element name="Or" type="ag:ConditionUnionChoiceUnbound_T"/> <element name="Not" type="ag:ConditionUnionChoice_T"/> </choice> </group> <!-- ConditionUnionChoice --> <!-- The global type definition for column value type --> <complexType name="ColumnValueSelectChoice_T"> <group ref="ag:ColumnValueSelectChoice"/> </complexType> <!-- choice group definition for column value --> <group name="ColumnValueSelectChoice"> <choice> <element name="ColumnFrom" type="ag:ColumnFrom_T"/> <element name="Expression" type="ag:ExpressionSelect_T"/> <element name="Aggregation" type="ag:AggregationSelect_T"/> <element name="If" type="ag:IfSelect_T"/> <element ref="ag:Value"/> <element ref="ag:Function"/> <element ref="ag:GetEnv"/> <element ref="ag:Rate"/> </choice> </group> <!-- ColumnValueSelectChoice --> <!-- The global type definition for column value type --> <complexType name="ColumnValueWhereChoice_T"> <group ref="ag:ColumnValueWhereChoice"/> </complexType> <!-- choice group definition for column value --> <group name="ColumnValueWhereChoice"> <choice> <element name="ColumnFrom" type="ag:ColumnFrom_T"/> <element name="Expression" type="ag:ExpressionWhere_T"/> <element name="If" type="ag:IfWhere_T"/> <element ref="ag:Value"/> <element ref="ag:Function"/> <element ref="ag:GetEnv"/> <element ref="ag:Rate"/> </choice> </group> <!-- ColumnValueWhereChoice --> <!-- The global type definition for column value type --> <complexType name="ColumnValueUnionChoice_T"> <group ref="ag:ColumnValueUnionChoice"/> </complexType> <!-- choice group definition for column value --> <group name="ColumnValueUnionChoice"> <choice> <element name="ColumnFrom" type="ag:Name_T"/> <element name="Expression" type="ag:ExpressionUnion_T"/> <element name="Aggregation" type="ag:AggregationUnion_T"/> <element name="If" type="ag:IfUnion_T"/> <element ref="ag:Value"/> <element ref="ag:Function"/> <element ref="ag:GetEnv"/> </choice> </group> <!-- ColumnValueUnionChoice --> </schema>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de