¸±¸®½º Á¤º¸

4°íÀ¯ÇÏÁö ¾ÊÀº ¼Ó¼º ¹× ¿ä¼Ò À̸§À» Æ÷ÇÔÇÏ´Â XML ExtenderÀÇ ¹®¼­ ºÐ¼®

4ÀÌÁ¦ DXXQ045E ¿À·ù¸¦ ¹ß»ý½ÃŰÁö ¾Ê°í µ¿ÀÏÇϰųª ´Ù¸¥ Å×À̺íÀÇ ´Ù¸¥ Ä÷³¿¡ ¸ÊÇεǴ 4°íÀ¯ÇÏÁö ¾ÊÀº ¼Ó¼ºÀ̳ª ¿ä¼Ò À̸§À» Æ÷ÇÔÇÏ´Â ¹®¼­¸¦ ºÐ¼®ÇÒ ¼ö ÀÖ½À´Ï´Ù. 4´ÙÀ½Àº °íÀ¯ÇÏÁö ¾ÊÀº ¼Ó¼º°ú ¿ä¼Ò À̸§À» °¡Áø XML ¹®¼­ÀÇ ¿¹ÀÔ´Ï´Ù.

4<Order ID="0001-6789">
4       <!-- Note: attribute name ID is non-unique -->
4       <Customer ID = "1111">
4                    <Name>John Smith</Name>
4        </Customer>
4       <!-- Note: element name Name is non_unique -->
4       <Salesperson ID = "1234"> 
4              <Name>Jane Doe</Name>
4       </Salesperson>
4       <OrderDetail>
4              <ItemNo>xxxx-xxxx</ItemNo>
4              <Quantity>2</Quantity>
4              <UnitPrice>12.50</UnitPrice>
4       </OrderDetail>
4       <OrderDetail>
4              <ItemNo>yyyy-yyyy</ItemNo>
4              <Quantity>4</Quantity>
4              <UnitPrice>24.99</UnitPrice>
4       </OrderDetail> 
4</Order>

4Áߺ¹ ¿ä¼Ò ¹× ¼Ó¼ºÀ» ´Ù¸¥ Ä÷³¿¡ ¸ÊÇÎÇÏ´Â ¼ö¹ÝµÇ´Â DAD´Â ´ÙÀ½°ú °°½À´Ï´Ù.

4         <element_node name="Order">
4                    <RDB_node>
4    <table name="order_tab" key="order_id"/>
4    <table name="detail_tab"/>
4                       <condition>
4      order_tab.order_id = detail_tab.order_id
4                       </condition>
4                    </RDB_node>
4 
4  <!--attribute ID duplicated below, but mapped to a different col-->
4    <attribute_node name="ID">
4                    <RDB_node>
4          <table name="order_tab" />
4      <column name="order_id" type="char(9)"/>
4                    </RDB_node>
4                                         </attribute_node>
4 
4  <element_node name="Customer">
4    <!--attribute ID duplicated above, but mapped to a different col-->
4    <attribute_node name="ID">
4                    <RDB_node>
4          <table name="order_tab" />
4        <column name="cust_id" type="integer"/>
4                    </RDB_node>
4                                         </attribute_node>
4 
4    <!--element name duplicated below, but mapped to a different col-->
4    <element_node name="Name"> 
4                 <text_node>
4                    <RDB_node>
4          <table name="order_tab" />
4          <column name="cust_name" type="char(20)" />
4                    </RDB_node>
4        </text_node>
4              </element_node>
4              </element_node>
4 
4  <element_node name="Salesperson">
4    <!--attribute ID duplicated above, but mapped to a different col-->
4    <attribute_node name="ID">
4                    <RDB_node>
4                    <RDB_node>
4          <table name="order_tab" />
4        <column name="salesp_id" type="integer"/>
4                    </RDB_node>
4                                         </attribute_node>
4 
4    <!--element name duplicated above, but mapped to a different col--> 
4    <element_node name="Name"> 
4                 <text_node>
4                    <RDB_node>
4          <table name="order_tab" />
4          <column name="salesp_name" type="char(20)" />
4                    </RDB_node>
4        </text_node>
4              </element_node>
4              </element_node>
4 
4  <element_node name="OrderDetail" multi_occurrence="YES">
4    <element_node name="ItemNo">
4                 <text_node>
4                    <RDB_node>
4          <table name="detail_tab" />
4          <column name="itemno" type="char(9)"/>
4                    </RDB_node>
4        </text_node>
4              </element_node>
4    <element_node name="Quantity">
4                 <text_node>
4                    <RDB_node>
4          <table name="detail_tab" />
4          <column name="quantity" type="integer"/>
4                    </RDB_node>
4        </text_node>
4              </element_node>
4    <element_node name="UnitPrice">
4                 <text_node>
4        <RDB_node>detail_tab" />
4          <table name="detail_tab" /> 
4          <column name="unit_price" type="decimal(7,2)"/>
4                    </RDB_node>
4        </text_node>
4              </element_node>
4              </element_node>
4</element_node>

4Å×À̺íÀÇ ÄÁÅÙÃ÷´Â À§ÀÇ ¹®¼­°¡ ºÐ¼®µÈ ÈÄ¿¡ ´ÙÀ½ »ùÇÃó·³ Ç¥½ÃµË´Ï´Ù.

4ORDER _TAB:
4 
4ORDER_ID       CUST_ID       CUST_NAME       SALESP_ID       SALESP_NAME
40001-6789      1111          John Smith      1234            Jane Doe
4 
4DETAIL_TAB:
4 
4ORDER_ID          ITEMNO         QUANTITY          UNIT_PRICE
40001-6789         xxxx-xxxx      2                 12.50
40001-6789         yyyy-yyyy      4                 24.99
4ÁÖ:
5µ¿ÀÏÇÑ Å×À̺íÀÇ µ¿ÀÏÇÑ Ä÷³¿¡ º¹¼ö ¿ä¼Ò ¹× ¼Ó¼ºÀ» ¸ÊÇÎÇÏ·Á¸é Å×ÀÌºí¿¡ ´ëÇÑ º°¸íÀ» Á¤ÀÇÇÏ¿© 5¸ÊÇÎ Áß ÇϳªÀÇ DAD <table> ¿ä¼Ò¿¡¼­ ÀÌ º°¸íÀ» »ç¿ëÇϽʽÿÀ. 5


[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ ]