´ÙÀ½ ¿¹´Â ¸Å°³º¯¼ö¸¦ ¼¼ °¡Áö À¯ÇüÀÇ ¸ÞŸµ¥ÀÌÅÍ ÀÛ¾÷À¸·Î ±¸¼ºÇÒ ¼ö ÀÖ´Â ¹æ¹ýÀ» º¸¿© ÁÝ´Ï´Ù. ÀÌ ¿¹Á¦¿¡¼´Â XML ±¸Á¶ÀÇ ºÐÇÒ ¿µ¿ªÀÌ Á¦¿ÜµÇ¾î ÀÖÁö¸¸ »ý·«(...)µÇ¾î Ç¥ÇöµÈ °ÍÀÔ´Ï´Ù.
´ÙÀ½ ¿¹´Â describe¶ó´Â °Ë»ö ÀÛ¾÷ÀÌ ±¸¼ºµÇ´Â ¹æ¹ýÀ» º¸¿©ÁÝ´Ï´Ù. describe ÀÛ¾÷¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ Á¤º¸´Â °Ë»ö ÀÛ¾÷ÀÇ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ. ¸ÞŸµ¥ÀÌÅÍ ¸Å°³º¯¼ö´Â ÀÔ·Â ½Ã¿¡´Â ºñ¾î ÀÖÁö¸¸ Ãâ·Â ½Ã¿¡´Â ä¿öÁý´Ï´Ù.
<olap:request xmlns:olap="http://www.ibm.com/olap" ... > <describe objectType="cube" recurse="no"> <restriction> <predicate property="schema" operator="=" value ="myschema"/> </restriction> </describe> </olap:request> <olap:metadata xmlns:olap="http://www.ibm.com/olap" ... />
<olap:response xmlns:olap="http://www.ibm.com/olap" ... > <describe> <status id="0" text="Operation completed successfully."type="informational"/> </describe> </olap:response> <olap:metadata xmlns:olap="http://www.ibm.com/olap" ... > <cube name="cube1" schema="myschema" ... > ... </cube> ... <cube name="cubeN" schema="myschema" ... > ... </cube>" </olap:metadata>
´ÙÀ½ ¿¹´Â create¶ó´Â ¼öÁ¤ ÀÛ¾÷ÀÌ ±¸¼ºµÇ´Â ¹æ¹ýÀ» º¸¿©ÁÝ´Ï´Ù. create ÀÛ¾÷ ¹× ±âŸ ¼öÁ¤ ÀÛ¾÷¿¡ °üÇÑ ÀÚ¼¼ÇÑ Á¤º¸´Â ¼öÁ¤ ÀÛ¾÷À» ÂüÁ¶ÇϽʽÿÀ. ¸ÞŸµ¥ÀÌÅÍ ¸Å°³º¯¼ö´Â ÀÔ·Â ½Ã¿¡´Â ä¿öÁöÁö¸¸ Ãâ·Â ½Ã¿¡´Â ºñ¾î ÀÖ½À´Ï´Ù.
<olap:request xmlns:olap="http://www.ibm.com/olap" ... > <create/> </olap:request> <olap:metadata xmlns:olap="http://www.ibm.com/olap" ... > <attribute name="LocationID" ... > ... </attribute> <attribute name="Country" ... > ... </attribute> <attribute name="State" ... > ... </attribute> <attribute name="City" ... > ... </attribute> <dimension name="Location" ... type="regular"> <attributeRef name="LocationID" ... </attributeRef> <attributeRef name="Country" ... </attributeRef> <attributeRef name="State" ... </attributeRef> <attributeRef name="City" ... </attributeRef> ... </dimension> </olap:metadata>
<olap:response xmlns:olap="http://www.ibm.com/olap" ... > <create> <status id="0" text="Operation completed successfully."type="informational"/> </create> </olap:response> b<olap:metadata xmlns:olap="http://www.ibm.com/olap" ... >
´ÙÀ½ ¿¹´Â validate¶ó´Â °ü¸® ÀÛ¾÷ÀÌ ±¸¼ºµÇ´Â ¹æ¹ýÀ» º¸¿©ÁÝ´Ï´Ù. validate ÀÛ¾÷¿¡ °üÇÑ ÀÚ¼¼ÇÑ Á¤º¸´Â °ü¸® ÀÛ¾÷À» ÂüÁ¶ÇϽʽÿÀ.
<olap:request xmlns:olap="http://www.ibm.com/olap" ... > <validate objectType="cube" mode="base"> <restriction> <predicate property="schema" operator="=" value ="myschema"/> </restriction> </describe> </olap:request> <olap:metadata xmlns:olap="http://www.ibm.com/olap" ... />
<olap:response xmlns:olap="http://www.ibm.com/olap" ... > <validate> <status id="1" text="...Additional information returned."type="informational"/> <info><message id="6299" text="At least one database view was found during validation." type="warning"/></info> </validate> </olap:response> <olap:metadata xmlns:olap="http://www.ibm.com/olap" ... >