analytics/webcontent/relmd/metadata/browse/relmdMetadataBrowseRules.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">
	<xs:include schemaLocation="../../vendor/access/relmdVendorAccess.xsd"/>
	<!--
	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="metadataBrowseRules">
		<xs:sequence>
			<xs:element name="catalogsBrowseRules" minOccurs="0">
				<xs:complexType>
					<xs:choice>
						<xs:group ref="objectBrowseSql"/>
						<xs:group ref="genericResultSetProvider"/>
					</xs:choice>
				</xs:complexType>
			</xs:element>
			<xs:element name="schemasBrowseRules">
				<xs:complexType>
					<xs:choice>
						<xs:sequence>
							<xs:choice>
								<xs:group ref="sql">
									<xs:annotation>
										<xs:documentation>sql that operates on a "per database" level.</xs:documentation>
									</xs:annotation>
								</xs:group>
								<xs:group ref="catalogGrainSql">
									<xs:annotation>
										<xs:documentation>sql that operates on a "per catalog" level.</xs:documentation>
									</xs:annotation>
								</xs:group>
							</xs:choice>
							<xs:group ref="systemObjectFilterInjection" minOccurs="0"/>
						</xs:sequence>
						<xs:group ref="genericResultSetProvider"/>
					</xs:choice>
				</xs:complexType>
			</xs:element>
			<xs:element ref="tablesBrowseRules"/>
			<xs:element ref="viewsBrowseRules"/>
			<xs:element ref="columnsBrowseRules"/>
			<xs:element ref="synonymsBrowseRules"/>
			<xs:element ref="proceduresBrowseRules"/>
			<xs:element ref="functionsBrowseRules"/>
			<xs:element ref="objectListingsRules"/>
		</xs:sequence>
	</xs:group>
	<xs:element name="tablesBrowseRules">
		<xs:complexType>
			<xs:choice>
				<xs:group ref="objectLevelBrowseSqlRule"/>
				<xs:group ref="genericResultSetProvider"/>
			</xs:choice>
		</xs:complexType>
	</xs:element>
	<xs:element name="viewsBrowseRules">
		<xs:complexType>
			<xs:choice>
				<xs:sequence>
					<xs:group ref="schemaGrainSql"/>
					<xs:group ref="systemObjectFilterInjection" minOccurs="0"/>
				</xs:sequence>
				<xs:group ref="genericResultSetProvider"/>
			</xs:choice>
		</xs:complexType>
	</xs:element>
	<xs:element name="columnsBrowseRules">
		<xs:complexType>
			<xs:choice>
				<xs:sequence>
					<xs:group ref="objectGrainSql"/>
				</xs:sequence>
				<xs:group ref="genericResultSetProvider"/>
			</xs:choice>
		</xs:complexType>
	</xs:element>
	<xs:element name="synonymsBrowseRules">
		<xs:complexType>
			<xs:choice>
				<xs:sequence>
					<xs:group ref="schemaGrainSql"/>
					<xs:group ref="systemObjectFilterInjection" minOccurs="0"/>
				</xs:sequence>
				<xs:group ref="genericResultSetProvider"/>
			</xs:choice>
		</xs:complexType>
	</xs:element>
	<xs:element name="proceduresBrowseRules">
		<xs:complexType>
			<xs:choice>
				<xs:sequence>
					<xs:group ref="schemaGrainSql"/>
					<xs:group ref="systemObjectFilterInjection" minOccurs="0"/>
				</xs:sequence>
				<xs:group ref="genericResultSetProvider"/>
			</xs:choice>
		</xs:complexType>
	</xs:element>
	<xs:element name="functionsBrowseRules">
		<xs:complexType>
			<xs:choice>
				<xs:sequence>
					<xs:group ref="schemaGrainSql"/>
					<xs:group ref="systemObjectFilterInjection" minOccurs="0"/>
				</xs:sequence>
				<xs:group ref="genericResultSetProvider"/>
			</xs:choice>
		</xs:complexType>
	</xs:element>
	<xs:group name="objectBrowseSql">
		<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:group ref="systemObjectFilterInjection" minOccurs="0"/>
		</xs:sequence>
	</xs:group>
	<xs:group name="objectLevelBrowseSqlRule">
		<xs:sequence>
			<xs:group ref="schemaGrainSql"/>
			<xs:group ref="systemObjectFilterInjection" minOccurs="0"/>
		</xs:sequence>
	</xs:group>
	<xs:group name="systemObjects">
		<xs:sequence>
			<xs:element name="systemCatalog" minOccurs="0" maxOccurs="unbounded">
				<xs:complexType>
					<xs:attributeGroup ref="systemObject"/>
				</xs:complexType>
			</xs:element>
			<xs:element name="systemSchema" minOccurs="0" maxOccurs="unbounded">
				<xs:complexType>
					<xs:attributeGroup ref="systemObject"/>
				</xs:complexType>
			</xs:element>
			<xs:element name="systemObject" minOccurs="0" maxOccurs="unbounded">
				<xs:complexType>
					<xs:attributeGroup ref="systemObject"/>
				</xs:complexType>
			</xs:element>
		</xs:sequence>
	</xs:group>
	<xs:group name="systemObjectFilterInjection">
		<xs:sequence>
			<xs:element name="systemObjectFilter">
				<xs:complexType>
					<xs:sequence>
						<xs:element name="systemObject" maxOccurs="unbounded">
							<xs:complexType>
								<xs:attribute name="name" type="xs:string" use="required"/>
							</xs:complexType>
						</xs:element>
					</xs:sequence>
					<xs:attributeGroup ref="sqlFilterConditionInjection"/>
					<xs:attribute name="objectExpression" use="required"/>
				</xs:complexType>
			</xs:element>
		</xs:sequence>
	</xs:group>
	<xs:element name="objectListingsRules">
		<xs:complexType>
			<xs:choice>
				<xs:group ref="sql">
					<xs:annotation>
						<xs:documentation>sql that operates on a "per database" level.</xs:documentation>
					</xs:annotation>
				</xs:group>
				<xs:group ref="genericResultSetProvider"/>
			</xs:choice>
			<xs:attributeGroup ref="objectsListingRecordIndexMappings"/>
		</xs:complexType>
	</xs:element>
	<xs:attributeGroup name="objectsListingRecordIndexMappings">
		<xs:attributeGroup ref="parentSchemaRecordIndexMappings"/>
		<xs:attribute name="objectName" type="resultSetRecordColumnIndexType" use="optional" default="3"/>
		<xs:attribute name="objectType" type="resultSetRecordColumnIndexType" use="optional" default="4"/>
		<xs:attribute name="isSystemObject" type="resultSetRecordColumnIndexType" use="optional" default="5"/>
		<xs:attribute name="description" type="resultSetRecordColumnIndexType" use="optional" default="unsupported"/>
	</xs:attributeGroup>
</xs:schema>