relmdMetadataImport.xsd 6.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!-- edited with XMLSpy v2010 rel. 3 sp1 (http://www.altova.com) by Biraj Saha (IBM SWG CANADA) -->
  3. <!--
  4. Licensed Materials - Property of IBM
  5. IBM Cognos Products: relmd
  6. (C) Copyright IBM Corp. 2008, 2015
  7. US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
  8. -->
  9. <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">
  10. <xs:include schemaLocation="../objectSelections/relmdMetadataObjectSelections.xsd"/>
  11. <xs:include schemaLocation="relmdMetadataImportRules.xsd"/>
  12. <xs:include schemaLocation="../source/relmdMetadataSource.xsd"/>
  13. <!---->
  14. <!--Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.-->
  15. <!--Cognos (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated).-->
  16. <!---->
  17. <xs:element name="importMetadataRequest">
  18. <xs:complexType>
  19. <xs:sequence>
  20. <xs:group ref="relmd:metadataSourceSelections"/>
  21. <xs:group ref="relmd:metadataImportFunctions" minOccurs="0">
  22. <xs:annotation>
  23. <xs:documentation>If not specified (i.e. if no child elemeents exist), then a "full" database import is presumed.</xs:documentation>
  24. </xs:annotation>
  25. </xs:group>
  26. <xs:group ref="relmd:metadataImportRules" minOccurs="0"/>
  27. </xs:sequence>
  28. </xs:complexType>
  29. </xs:element>
  30. <xs:element name="importMetadataResult">
  31. <xs:complexType>
  32. <xs:choice>
  33. <xs:sequence>
  34. <xs:element ref="relmd:relationalMetadata"/>
  35. <xs:group ref="relmd:summaryReport"/>
  36. </xs:sequence>
  37. <xs:group ref="relmd:cmDataSourceConnectionFaults"/>
  38. </xs:choice>
  39. </xs:complexType>
  40. </xs:element>
  41. <xs:group name="metadataImportFunctions">
  42. <xs:sequence>
  43. <xs:group ref="relmd:tablesImportChain" minOccurs="0"/>
  44. <xs:group ref="relmd:viewsImportChain" minOccurs="0"/>
  45. <xs:group ref="relmd:routinesImportChain" minOccurs="0"/>
  46. <xs:element name="synonymsImport" minOccurs="0">
  47. <xs:annotation>
  48. <xs:documentation>Import synonyms (to tables, views, stored procedures, UDFs and other synonyms).</xs:documentation>
  49. </xs:annotation>
  50. </xs:element>
  51. </xs:sequence>
  52. </xs:group>
  53. <xs:group name="tableRelatedmetadataImportFunctions">
  54. <xs:sequence>
  55. <xs:group ref="relmd:columnRelatedmetadataImportFunctions"/>
  56. </xs:sequence>
  57. </xs:group>
  58. <xs:group name="columnRelatedmetadataImportFunctions">
  59. <xs:sequence/>
  60. </xs:group>
  61. <xs:group name="routineRelatedmetadataImportFunctions">
  62. <xs:sequence/>
  63. </xs:group>
  64. <xs:group name="summaryReport">
  65. <xs:sequence>
  66. <xs:element name="schemaSummary" minOccurs="0" maxOccurs="unbounded">
  67. <xs:complexType>
  68. <xs:attribute name="databaseName" use="required"/>
  69. <xs:attribute name="catalogName"/>
  70. <xs:attribute name="schemaName" use="required"/>
  71. <xs:attribute name="tablesCount"/>
  72. <xs:attribute name="viewsCount"/>
  73. <xs:attribute name="synonymsCount"/>
  74. <xs:attribute name="proceduresCount"/>
  75. <xs:attribute name="functionsCount"/>
  76. </xs:complexType>
  77. </xs:element>
  78. <xs:group ref="relmd:functionSummary"/>
  79. </xs:sequence>
  80. </xs:group>
  81. <xs:group name="tablesImportChain">
  82. <xs:sequence>
  83. <xs:element name="tablesImport">
  84. <xs:annotation>
  85. <xs:documentation>Import tables.</xs:documentation>
  86. </xs:annotation>
  87. </xs:element>
  88. <xs:element name="columnsImport" minOccurs="0">
  89. <xs:annotation>
  90. <xs:documentation>Import columns.</xs:documentation>
  91. </xs:annotation>
  92. </xs:element>
  93. <xs:element name="uniqueKeysImport" minOccurs="0">
  94. <xs:annotation>
  95. <xs:documentation>Import unique keys (and primary keys).</xs:documentation>
  96. </xs:annotation>
  97. </xs:element>
  98. <xs:element name="foreignKeysImport" minOccurs="0">
  99. <xs:annotation>
  100. <xs:documentation>Import foreign keys.</xs:documentation>
  101. </xs:annotation>
  102. </xs:element>
  103. <xs:element name="indexesImport" minOccurs="0">
  104. <xs:annotation>
  105. <xs:documentation>Import (unique and non-unique) indexes.</xs:documentation>
  106. </xs:annotation>
  107. </xs:element>
  108. </xs:sequence>
  109. </xs:group>
  110. <xs:group name="viewsImportChain">
  111. <xs:sequence>
  112. <xs:element name="viewsImport">
  113. <xs:annotation>
  114. <xs:documentation>Import views.</xs:documentation>
  115. </xs:annotation>
  116. </xs:element>
  117. <xs:element name="columnsImport" minOccurs="0">
  118. <xs:annotation>
  119. <xs:documentation>Import columns.</xs:documentation>
  120. </xs:annotation>
  121. </xs:element>
  122. <xs:element name="uniqueKeysImport" minOccurs="0">
  123. <xs:annotation>
  124. <xs:documentation>Import unique keys (and primary keys).</xs:documentation>
  125. </xs:annotation>
  126. </xs:element>
  127. <xs:element name="foreignKeysImport" minOccurs="0">
  128. <xs:annotation>
  129. <xs:documentation>Import foreign keys.</xs:documentation>
  130. </xs:annotation>
  131. </xs:element>
  132. <xs:element name="indexesImport" minOccurs="0">
  133. <xs:annotation>
  134. <xs:documentation>Import (unique and non-unique) indexes.</xs:documentation>
  135. </xs:annotation>
  136. </xs:element>
  137. </xs:sequence>
  138. </xs:group>
  139. <xs:group name="routinesImportChain">
  140. <xs:sequence>
  141. <xs:element name="routinesImport">
  142. <xs:annotation>
  143. <xs:documentation>Import stored procedures and user-defined functions (UDFs).</xs:documentation>
  144. </xs:annotation>
  145. </xs:element>
  146. <xs:element name="routineArgumentsImport" minOccurs="0">
  147. <xs:annotation>
  148. <xs:documentation>Import arguments contained within various signatures for stored procedures and user-defined functions.</xs:documentation>
  149. </xs:annotation>
  150. </xs:element>
  151. </xs:sequence>
  152. </xs:group>
  153. <xs:group name="functionSummary">
  154. <xs:sequence>
  155. <xs:element name="importSummary" minOccurs="0" maxOccurs="unbounded">
  156. <xs:complexType>
  157. <xs:sequence>
  158. <xs:element name="event" minOccurs="0" maxOccurs="unbounded">
  159. <xs:complexType>
  160. <xs:attribute name="eventText" use="required"/>
  161. </xs:complexType>
  162. </xs:element>
  163. <xs:group ref="relmd:functionSummary"/>
  164. </xs:sequence>
  165. <xs:attribute name="functionName" use="required"/>
  166. <xs:attribute name="rowsProcessed" use="required"/>
  167. <xs:attribute name="elapsedTime" use="required"/>
  168. </xs:complexType>
  169. </xs:element>
  170. </xs:sequence>
  171. </xs:group>
  172. </xs:schema>