analytics/webcontent/relmd/vendor/access/relmdVendorAccess.xsd

<?xml version="1.0" encoding="UTF-8"?>
<!--
 Licensed Materials - Property of IBM

 IBM Cognos Products: relmd

 (C) Copyright IBM Corp. 2008, 2015

 US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
-->
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns="http://www.ibm.com/xmlns/prod/cognos/relmd/1/0" targetNamespace="http://www.ibm.com/xmlns/prod/cognos/relmd/1/0" elementFormDefault="qualified" attributeFormDefault="qualified">
	<!--
	Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
	Cognos (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated).

	Relational metadata database extraction rules.
-->
	<xs:group name="extractionRulesResultSetProvider">
		<xs:choice>
			<xs:group ref="sqlAccess"/>
			<xs:group ref="genericResultSetProvider"/>
			<xs:element name="databaseMetadataJdbcFunction"/>
		</xs:choice>
	</xs:group>
	<xs:group name="catalogGrainFilterableSql">
		<xs:sequence>
			<xs:element name="catalogGrainObjectSelectionsInclusion" minOccurs="0" maxOccurs="unbounded">
				<xs:complexType>
					<xs:sequence>
						<xs:element name="catalogGrainSelectionsCondition" maxOccurs="unbounded">
							<xs:complexType>
								<xs:attribute name="schemaExpression"/>
								<xs:attribute name="objectExpression"/>
							</xs:complexType>
						</xs:element>
					</xs:sequence>
					<xs:attribute name="sqlFragment" type="xs:string" use="required"/>
					<xs:attributeGroup ref="whereClauseConditionInsertion"/>
				</xs:complexType>
			</xs:element>
		</xs:sequence>
	</xs:group>
	<xs:group name="sqlInsertionLocation">
		<xs:choice>
			<xs:element name="objectSubstitution"/>
		</xs:choice>
	</xs:group>
	<xs:group name="objectSelectionsWhereClauseInsertion">
		<xs:choice>
			<xs:element name="schemaSelectionsCondition">
				<xs:complexType>
					<xs:attributeGroup ref="whereClauseConditionInsertion"/>
					<xs:attribute name="catalogExpression"/>
					<xs:attribute name="schemaExpression" use="required"/>
				</xs:complexType>
			</xs:element>
			<xs:element name="objectSelectionsCondition">
				<xs:complexType>
					<xs:attributeGroup ref="whereClauseConditionInsertion"/>
					<xs:attributeGroup ref="objectSelectionsSqlExpressionMappings"/>
				</xs:complexType>
			</xs:element>
		</xs:choice>
	</xs:group>
	<xs:attributeGroup name="whereClauseColumns">
		<xs:attribute name="catalog" type="xs:string" use="optional" default="CATALOG_NAME"/>
		<xs:attribute name="schema" type="xs:string" use="optional" default="SCHEMA_NAME"/>
		<xs:attribute name="object" type="xs:string" use="optional" default="OBJECT_NAME"/>
		<xs:attribute name="system_flag" type="xs:string" use="optional" default="SYSTEM_FLAG"/>
	</xs:attributeGroup>
	<xs:attributeGroup name="foreignKeywhereClauseColumns">
		<xs:attribute name="catalog" type="xs:string" use="optional" default="FK_CATALOG_NAME"/>
		<xs:attribute name="schema" type="xs:string" use="optional" default="FK_SCHEMA_NAME"/>
		<xs:attribute name="object" type="xs:string" use="optional" default="FK_OBJECT_NAME"/>
		<xs:attribute name="system_flag" type="xs:string" use="optional" default="SYSTEM_FLAG"/>
	</xs:attributeGroup>
	<xs:attributeGroup name="catalogLevelFilterColumns">
		<xs:attribute name="catalogLevelFilterColumn" type="xs:string" use="required"/>
		<xs:attribute name="schemaLevelFilterColumn" type="xs:string" use="required"/>
		<xs:attribute name="objectLevelFilterColumn" type="xs:string" use="required"/>
	</xs:attributeGroup>
	<xs:attributeGroup name="schemaLevelFilterColumns">
		<xs:attribute name="schemaLevelFilterColumn" type="xs:string" use="required"/>
		<xs:attribute name="objectLevelFilterColumn" type="xs:string" use="required"/>
	</xs:attributeGroup>
	<xs:attributeGroup name="systemObject">
		<xs:attribute name="name" type="xs:string"/>
	</xs:attributeGroup>
	<xs:attributeGroup name="whereClauseConditionInsertion">
		<xs:attribute name="insertLocation" use="required">
			<xs:simpleType>
				<xs:restriction base="xs:NMTOKEN">
					<xs:enumeration value="before"/>
					<xs:enumeration value="after"/>
				</xs:restriction>
			</xs:simpleType>
		</xs:attribute>
		<xs:attribute name="insertPrefix" use="required">
			<xs:simpleType>
				<xs:restriction base="xs:NMTOKEN">
					<xs:enumeration value="WHERE"/>
					<xs:enumeration value="AND"/>
				</xs:restriction>
			</xs:simpleType>
		</xs:attribute>
	</xs:attributeGroup>
	<xs:attributeGroup name="objectSelectionsSqlExpressionMappings">
		<xs:attribute name="catalogExpression"/>
		<xs:attribute name="schemaExpression"/>
		<xs:attribute name="objectExpression"/>
	</xs:attributeGroup>
	<xs:attributeGroup name="sqlDecorator">
		<xs:attribute name="sqlFragment" type="xs:string" use="required"/>
	</xs:attributeGroup>
	<xs:simpleType name="jdbcMethodType">
		<xs:restriction base="xs:NMTOKEN">
			<xs:enumeration value="getTables"/>
			<xs:enumeration value="getColumns"/>
			<xs:enumeration value="getKeys"/>
			<xs:enumeration value="getIndexes"/>
			<xs:enumeration value="getSynonyms"/>
			<xs:enumeration value="getProcedures"/>
			<xs:enumeration value="TBD"/>
		</xs:restriction>
	</xs:simpleType>
	<xs:simpleType name="resultColumnIndexValueUndefined">
		<xs:restriction base="xs:NMTOKEN">
			<xs:pattern value="1"/>
			<xs:enumeration value="-1"/>
		</xs:restriction>
	</xs:simpleType>
	<xs:simpleType name="granularityType">
		<xs:restriction base="xs:NMTOKEN">
			<xs:enumeration value="global"/>
			<xs:enumeration value="catalog"/>
			<xs:enumeration value="schema"/>
			<xs:enumeration value="group"/>
			<xs:enumeration value="table"/>
		</xs:restriction>
	</xs:simpleType>
	<xs:simpleType name="resultSchemaColumnIndexType">
		<xs:union memberTypes="xs:positiveInteger xs:NMTOKEN"/>
	</xs:simpleType>
	<xs:simpleType name="resultSetRecordColumnIndexType">
		<xs:union memberTypes="xs:positiveInteger xs:NMTOKEN"/>
	</xs:simpleType>
	<xs:simpleType name="schemaChildObjectNameIndexType">
		<xs:restriction base="resultSetRecordColumnIndexType"/>
	</xs:simpleType>
	<xs:simpleType name="refCatalogNameIndexType">
		<xs:restriction base="resultSetRecordColumnIndexType"/>
	</xs:simpleType>
	<xs:simpleType name="refSchemaNameIndexType">
		<xs:restriction base="resultSetRecordColumnIndexType"/>
	</xs:simpleType>
	<xs:simpleType name="refQueryObjectNameIndexType">
		<xs:restriction base="resultSetRecordColumnIndexType"/>
	</xs:simpleType>
	<xs:simpleType name="refColumnNameIndexType">
		<xs:restriction base="resultSetRecordColumnIndexType"/>
	</xs:simpleType>
	<xs:simpleType name="refColumnSequenceIndexType">
		<xs:restriction base="resultSetRecordColumnIndexType"/>
	</xs:simpleType>
	<xs:simpleType name="refKeyNameIndexType">
		<xs:restriction base="resultSetRecordColumnIndexType"/>
	</xs:simpleType>
	<xs:group name="schemaGrainFilterableSql">
		<xs:sequence>
			<xs:element name="schemaGrainObjectSelectionsInclusion" minOccurs="0" maxOccurs="unbounded">
				<xs:complexType>
					<xs:sequence>
						<xs:element name="schemaGrainSelectionsCondition" maxOccurs="unbounded">
							<xs:complexType>
								<xs:attribute name="objectExpression"/>
							</xs:complexType>
						</xs:element>
					</xs:sequence>
					<xs:attribute name="sqlFragment" type="xs:string" use="required"/>
					<xs:attribute name="insertLocation" use="required">
						<xs:simpleType>
							<xs:restriction base="xs:NMTOKEN">
								<xs:enumeration value="before"/>
								<xs:enumeration value="after"/>
							</xs:restriction>
						</xs:simpleType>
					</xs:attribute>
					<xs:attribute name="insertPrefix" use="required">
						<xs:simpleType>
							<xs:restriction base="xs:NMTOKEN">
								<xs:enumeration value="WHERE"/>
								<xs:enumeration value="AND"/>
							</xs:restriction>
						</xs:simpleType>
					</xs:attribute>
				</xs:complexType>
			</xs:element>
		</xs:sequence>
	</xs:group>
	<xs:group name="objectGrainSql">
		<xs:sequence>
			<xs:element name="objectGrainSql">
				<xs:annotation>
					<xs:documentation>MIXED CONTENT - The type of this element is THE SQL that will be run against the database; the child elements serve as placeholders within the sql.</xs:documentation>
				</xs:annotation>
				<xs:complexType mixed="true">
					<xs:sequence>
						<xs:element name="catalogSubstitution" minOccurs="0"/>
						<xs:element name="schemaSubstitution"/>
						<xs:element name="objectSubstitution"/>
					</xs:sequence>
				</xs:complexType>
			</xs:element>
		</xs:sequence>
	</xs:group>
	<xs:group name="databaseGrainFilterableSql">
		<xs:sequence>
			<xs:group ref="sql">
				<xs:annotation>
					<xs:documentation>sql that operates on a "per database" level.</xs:documentation>
				</xs:annotation>
			</xs:group>
			<xs:element name="objectSelectionsInclusion" minOccurs="0" maxOccurs="unbounded">
				<xs:annotation>
					<xs:documentation>Generrates additonal WHERE clause filter conditions to be injected into the SQL above, based on a set of "database object selections".</xs:documentation>
				</xs:annotation>
				<xs:complexType>
					<xs:sequence>
						<xs:element name="objectSelectionsCondition" maxOccurs="unbounded">
							<xs:complexType>
								<xs:attribute name="catalogExpression"/>
								<xs:attribute name="schemaExpression"/>
								<xs:attribute name="objectExpression"/>
							</xs:complexType>
						</xs:element>
					</xs:sequence>
					<xs:attribute name="sqlFragment" type="xs:string" use="required"/>
					<xs:attributeGroup ref="whereClauseConditionInsertion"/>
				</xs:complexType>
			</xs:element>
		</xs:sequence>
	</xs:group>
	<xs:group name="sql">
		<xs:choice>
			<xs:element name="sql" type="xs:string"/>
		</xs:choice>
	</xs:group>
	<xs:group name="catalogGrainSql">
		<xs:sequence>
			<xs:element name="catalogGrainSql">
				<xs:annotation>
					<xs:documentation>MIXED CONTENT - The value of this element will appear as a piece of sql with the child substitution elements inside it.</xs:documentation>
				</xs:annotation>
				<xs:complexType mixed="true">
					<xs:sequence>
						<xs:element name="catalogSubstitution" minOccurs="0" maxOccurs="unbounded"/>
					</xs:sequence>
				</xs:complexType>
			</xs:element>
		</xs:sequence>
	</xs:group>
	<xs:attributeGroup name="parentSchemaRecordIndexMappings">
		<xs:attribute name="parentCatalog" type="resultSetRecordColumnIndexType" default="1"/>
		<xs:attribute name="parentSchema" type="resultSetRecordColumnIndexType" default="2"/>
	</xs:attributeGroup>
	<xs:group name="schemaGrainSql">
		<xs:choice>
			<xs:element name="schemaGrainSql" minOccurs="0">
				<xs:annotation>
					<xs:documentation>MIXED CONTENT - The value of this element will appear as a piece of sql with the child substitution elements inside it.</xs:documentation>
				</xs:annotation>
				<xs:complexType mixed="true">
					<xs:sequence>
						<xs:element name="catalogSubstitution" minOccurs="0"/>
						<xs:element name="schemaSubstitution" minOccurs="0" maxOccurs="unbounded"/>
					</xs:sequence>
				</xs:complexType>
			</xs:element>
		</xs:choice>
	</xs:group>
	<xs:group name="genericResultSetProvider">
		<xs:choice>
			<xs:element name="java">
				<xs:complexType>
					<xs:attribute name="className" use="required"/>
				</xs:complexType>
			</xs:element>
			<xs:element name="storedProcedureCall">
				<xs:complexType>
					<xs:sequence>
						<xs:element name="inputParam" minOccurs="0" maxOccurs="unbounded"/>
					</xs:sequence>
				</xs:complexType>
			</xs:element>
			<xs:element name="udaApiCall">
				<xs:complexType>
					<xs:sequence>
						<xs:element name="inputParam" minOccurs="0" maxOccurs="unbounded"/>
					</xs:sequence>
				</xs:complexType>
			</xs:element>
		</xs:choice>
	</xs:group>
	<xs:attributeGroup name="sqlFilterConditionInjection">
		<xs:attribute name="sqlFragment" type="xs:string" use="required"/>
		<xs:attribute name="insertLocation" use="required">
			<xs:simpleType>
				<xs:restriction base="xs:NMTOKEN">
					<xs:enumeration value="before"/>
					<xs:enumeration value="after"/>
				</xs:restriction>
			</xs:simpleType>
		</xs:attribute>
		<xs:attribute name="insertPrefix" use="required">
			<xs:simpleType>
				<xs:restriction base="xs:NMTOKEN">
					<xs:enumeration value="WHERE"/>
					<xs:enumeration value="AND"/>
				</xs:restriction>
			</xs:simpleType>
		</xs:attribute>
	</xs:attributeGroup>
	<xs:group name="javaFunction">
		<xs:sequence>
			<xs:element name="javaClass">
				<xs:complexType>
					<xs:attribute name="qualifiedClassName" type="xs:string" use="required"/>
				</xs:complexType>
			</xs:element>
		</xs:sequence>
	</xs:group>
	<xs:group name="sqlAccess">
		<xs:sequence>
			<xs:choice>
				<xs:group ref="objectGrainSql"/>
				<xs:group ref="schemaGrainSql"/>
				<xs:group ref="catalogGrainSql"/>
				<xs:group ref="sql"/>
			</xs:choice>
			<xs:sequence>
				<xs:element name="objectSelectionsInclusion" minOccurs="0" maxOccurs="unbounded">
					<xs:annotation>
						<xs:documentation>Generrates additonal WHERE clause filter conditions to be injected into the SQL above, based on a set of "database object selections".</xs:documentation>
					</xs:annotation>
					<xs:complexType>
						<xs:sequence>
							<xs:element name="objectSelectionsCondition" maxOccurs="unbounded">
								<xs:complexType>
									<xs:attribute name="catalogExpression"/>
									<xs:attribute name="schemaExpression"/>
									<xs:attribute name="objectExpression"/>
									<xs:attribute name="columnExpression"/>
								</xs:complexType>
							</xs:element>
						</xs:sequence>
						<xs:attribute name="sqlFragment" type="xs:string" use="required"/>
						<xs:attributeGroup ref="whereClauseConditionInsertion"/>
					</xs:complexType>
				</xs:element>
			</xs:sequence>
		</xs:sequence>
	</xs:group>
</xs:schema>