123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175 |
- <?xml version="1.0" encoding="UTF-8"?>
- <!-- edited with XMLSpy v2010 rel. 3 sp1 (http://www.altova.com) by Biraj Saha (IBM SWG CANADA) -->
- <!--
- 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:relmd="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="../objectSelections/relmdMetadataObjectSelections.xsd"/>
- <xs:include schemaLocation="relmdMetadataImportRules.xsd"/>
- <xs:include schemaLocation="../source/relmdMetadataSource.xsd"/>
- <!---->
- <!--Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.-->
- <!--Cognos (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated).-->
- <!---->
- <xs:element name="importMetadataRequest">
- <xs:complexType>
- <xs:sequence>
- <xs:group ref="relmd:metadataSourceSelections"/>
- <xs:group ref="relmd:metadataImportFunctions" minOccurs="0">
- <xs:annotation>
- <xs:documentation>If not specified (i.e. if no child elemeents exist), then a "full" database import is presumed.</xs:documentation>
- </xs:annotation>
- </xs:group>
- <xs:group ref="relmd:metadataImportRules" minOccurs="0"/>
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="importMetadataResult">
- <xs:complexType>
- <xs:choice>
- <xs:sequence>
- <xs:element ref="relmd:relationalMetadata"/>
- <xs:group ref="relmd:summaryReport"/>
- </xs:sequence>
- <xs:group ref="relmd:cmDataSourceConnectionFaults"/>
- </xs:choice>
- </xs:complexType>
- </xs:element>
- <xs:group name="metadataImportFunctions">
- <xs:sequence>
- <xs:group ref="relmd:tablesImportChain" minOccurs="0"/>
- <xs:group ref="relmd:viewsImportChain" minOccurs="0"/>
- <xs:group ref="relmd:routinesImportChain" minOccurs="0"/>
- <xs:element name="synonymsImport" minOccurs="0">
- <xs:annotation>
- <xs:documentation>Import synonyms (to tables, views, stored procedures, UDFs and other synonyms).</xs:documentation>
- </xs:annotation>
- </xs:element>
- </xs:sequence>
- </xs:group>
- <xs:group name="tableRelatedmetadataImportFunctions">
- <xs:sequence>
- <xs:group ref="relmd:columnRelatedmetadataImportFunctions"/>
- </xs:sequence>
- </xs:group>
- <xs:group name="columnRelatedmetadataImportFunctions">
- <xs:sequence/>
- </xs:group>
- <xs:group name="routineRelatedmetadataImportFunctions">
- <xs:sequence/>
- </xs:group>
- <xs:group name="summaryReport">
- <xs:sequence>
- <xs:element name="schemaSummary" minOccurs="0" maxOccurs="unbounded">
- <xs:complexType>
- <xs:attribute name="databaseName" use="required"/>
- <xs:attribute name="catalogName"/>
- <xs:attribute name="schemaName" use="required"/>
- <xs:attribute name="tablesCount"/>
- <xs:attribute name="viewsCount"/>
- <xs:attribute name="synonymsCount"/>
- <xs:attribute name="proceduresCount"/>
- <xs:attribute name="functionsCount"/>
- </xs:complexType>
- </xs:element>
- <xs:group ref="relmd:functionSummary"/>
- </xs:sequence>
- </xs:group>
- <xs:group name="tablesImportChain">
- <xs:sequence>
- <xs:element name="tablesImport">
- <xs:annotation>
- <xs:documentation>Import tables.</xs:documentation>
- </xs:annotation>
- </xs:element>
- <xs:element name="columnsImport" minOccurs="0">
- <xs:annotation>
- <xs:documentation>Import columns.</xs:documentation>
- </xs:annotation>
- </xs:element>
- <xs:element name="uniqueKeysImport" minOccurs="0">
- <xs:annotation>
- <xs:documentation>Import unique keys (and primary keys).</xs:documentation>
- </xs:annotation>
- </xs:element>
- <xs:element name="foreignKeysImport" minOccurs="0">
- <xs:annotation>
- <xs:documentation>Import foreign keys.</xs:documentation>
- </xs:annotation>
- </xs:element>
- <xs:element name="indexesImport" minOccurs="0">
- <xs:annotation>
- <xs:documentation>Import (unique and non-unique) indexes.</xs:documentation>
- </xs:annotation>
- </xs:element>
- </xs:sequence>
- </xs:group>
- <xs:group name="viewsImportChain">
- <xs:sequence>
- <xs:element name="viewsImport">
- <xs:annotation>
- <xs:documentation>Import views.</xs:documentation>
- </xs:annotation>
- </xs:element>
- <xs:element name="columnsImport" minOccurs="0">
- <xs:annotation>
- <xs:documentation>Import columns.</xs:documentation>
- </xs:annotation>
- </xs:element>
- <xs:element name="uniqueKeysImport" minOccurs="0">
- <xs:annotation>
- <xs:documentation>Import unique keys (and primary keys).</xs:documentation>
- </xs:annotation>
- </xs:element>
- <xs:element name="foreignKeysImport" minOccurs="0">
- <xs:annotation>
- <xs:documentation>Import foreign keys.</xs:documentation>
- </xs:annotation>
- </xs:element>
- <xs:element name="indexesImport" minOccurs="0">
- <xs:annotation>
- <xs:documentation>Import (unique and non-unique) indexes.</xs:documentation>
- </xs:annotation>
- </xs:element>
- </xs:sequence>
- </xs:group>
- <xs:group name="routinesImportChain">
- <xs:sequence>
- <xs:element name="routinesImport">
- <xs:annotation>
- <xs:documentation>Import stored procedures and user-defined functions (UDFs).</xs:documentation>
- </xs:annotation>
- </xs:element>
- <xs:element name="routineArgumentsImport" minOccurs="0">
- <xs:annotation>
- <xs:documentation>Import arguments contained within various signatures for stored procedures and user-defined functions.</xs:documentation>
- </xs:annotation>
- </xs:element>
- </xs:sequence>
- </xs:group>
- <xs:group name="functionSummary">
- <xs:sequence>
- <xs:element name="importSummary" minOccurs="0" maxOccurs="unbounded">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="event" minOccurs="0" maxOccurs="unbounded">
- <xs:complexType>
- <xs:attribute name="eventText" use="required"/>
- </xs:complexType>
- </xs:element>
- <xs:group ref="relmd:functionSummary"/>
- </xs:sequence>
- <xs:attribute name="functionName" use="required"/>
- <xs:attribute name="rowsProcessed" use="required"/>
- <xs:attribute name="elapsedTime" use="required"/>
- </xs:complexType>
- </xs:element>
- </xs:sequence>
- </xs:group>
- </xs:schema>
|