»óǰ ¾îµå¹ÙÀÌÀú °Ë»ö °ø°£ µ¿±âÈ­ »ç¿ë

»óǰ ¾îµå¹ÙÀÌÀú °Ë»ö °ø°£ µ¿±âÈ­¸¦ »ç¿ëÇÏ·Á¸é ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.

  1. "PASyncInfo.xml"À̶ó´Â À̸§ÀÇ µ¿±âÈ­¿ë XML ±¸¼º Á¤º¸ ÆÄÀÏÀ» ÀÛ¼ºÇϽʽÿÀ.
  2. PASyncInfo.xml¿¡, »ç¿ëÇÒ XML ½ºÅ°¸¶·Î¼­ PASync.xsd¸¦ ÁöÁ¤ÇϽʽÿÀ. ¿¹¸¦ µé¸é, ´ÙÀ½°ú °°½À´Ï´Ù.
      <PASync 
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:noNamespaceSchemaLocation='PASync.xsd'

    PASync.xsd ÆÄÀÏÀÌ Á¦°øµË´Ï´Ù. ´ÙÀ½ ÅØ½ºÆ®´Â PASync.xsdÀÇ ³»¿ëÀ» Ç¥½ÃÇÕ´Ï´Ù.

  3.  <?xml version="1.0" encoding="UTF-8"?>
     <xsd:schema xmlns:xsd='http://www.w3.org/2001/XMLSchema'>
     
      <xsd:element name="PASync">
       <xsd:complexType>
         <xsd:sequence>
           <xsd:element ref="SearchScheme" />
           <xsd:element ref="Command" minOccurs="1" maxOccurs="unbounded" />
         </xsd:sequence>
         <xsd:attribute name = "member" type="xsd:string" use="required" />
         <xsd:attribute name = "store" type="xsd:string" use="required" />
       </xsd:complexType>
      </xsd:element>
    
      <xsd:element name="SearchScheme">
       <xsd:complexType>
         <xsd:sequence>
            <xsd:element ref="RelatedTable" />
              <xsd:element ref="Search" minOccurs="1" maxOccurs="unbounded" />
         </xsd:sequence>
         <xsd:attribute name = "tableName" type="xsd:string" use="required" />      
         <xsd:attribute name = "primary" type="xsd:string" use="required" />      
         <xsd:attribute name = "colName" type="xsd:string" use="required" />      
       </xsd:complexType>
      </xsd:element>
    
      <xsd:element name="RelatedTable">
       <xsd:complexType>
         <xsd:attribute name = "tableName" type="xsd:string" use="required" />      
         <xsd:attribute name = "from" type="xsd:string" use="required" />      
         <xsd:attribute name = "to" type="xsd:string" use="required" />      
       </xsd:complexType>
      </xsd:element>
    
      <xsd:element name="Search">
       <xsd:complexType>
         <xsd:attribute name = "value" type="xsd:string" use="required" />   
       </xsd:complexType>
      </xsd:element>
    
      <xsd:element name="Command">
       <xsd:complexType>
         <xsd:attribute name = "tableName" type="xsd:string" use="required" />    
         <xsd:attribute name = "idColumnName" type="xsd:string" use="required" />   
         <xsd:attribute name = "addCommand" type="xsd:string" />   
         <xsd:attribute name = "updateCommand" type="xsd:string" />   
         <xsd:attribute name = "deleteCommand" type="xsd:string" />   
       </xsd:complexType>
      </xsd:element>
       
     </xsd:schema>
  4. PASyncInfo.xml¿¡ µ¿±âÈ­¸¦ ¼öÇàÇÒ ±¸¼º¿ø ID ¹× »óÁ¡ ¿£Æ¼Æ¼ ID¸¦ ÁöÁ¤ÇϽʽÿÀ. ¿¹¸¦ µé¸é, ´ÙÀ½°ú °°½À´Ï´Ù.
  5.   member = "-2000"
      store = "10351"
  6. PASyncInfo.xmlÀÇ °Ë»ö ½ºÅ°¸¶ ¿ä¼Ò ¾Æ·¡ °Ë»ö °ø°£À» ±¸¼ºÇÏ´Â CATGROUP ½Äº°ÀÚ¸¦ ÁöÁ¤ÇϽʽÿÀ. ¿¹¸¦ µé¸é,
      <SearchScheme
        tableName = "catgroup"
        primary = "CATGROUP_ID"
        colName = "identifier" >
    
        <RelatedTable 
          tableName = "catgpenrel" 
          from = "CATGROUP_ID" 
          to = "CATENTRY_ID" />
    
        <Search value="Pants" />
        <Search value="Shirts" />
    
      </SearchScheme>
    

    ¿¹¿¡¼­´Â "Pants" ¹× "Shirts"°¡ ÁöÁ¤µÇ¾ú½À´Ï´Ù. ¿øÇÏ´Â ¸¸Å­ÀÇ CATGROUP ½Äº°ÀÚ¸¦ ÁöÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.

  7. PASyncInfo.xml¿¡¼­ ½ºÄÉÁÙÇÒ ¸í·ÉÀ» °áÁ¤ÇÏ´Â ¼Ó¼ºÀ» ÁöÁ¤ÇϽʽÿÀ. ¿¹¸¦ µé¸é,
        <Command tableName = "CATENTRY" idColumnName = "CATENTRY_ID"
          updateCommand = "UpdateSearchSpaces" 
          deleteCommand = "RemoveProductsFromAllSearchSpaces"
        />
      
        <Command tableName = "CATENTDESC" idColumnName = "CATENTRY_ID"
          addCommand = "UpdateSearchSpaces"
          updateCommand = "UpdateSearchSpaces" 
          deleteCommand = "UpdateSearchSpaces"
        />
      
        <Command tableName = "LISTPRICE" idColumnName = "CATENTRY_ID"
          addCommand = "UpdateSearchSpaces"
          updateCommand = "UpdateSearchSpaces" 
          deleteCommand = "UpdateSearchSpaces"
        />
      
        <Command tableName = "ATTRVALUE" idColumnName = "CATENTRY_ID"
          addCommand = "UpdateSearchSpaces"
          updateCommand = "UpdateSearchSpaces" 
          deleteCommand = "UpdateSearchSpaces"
        />
      
        <Command tableName = "CATENTATTR" idColumnName = "CATENTRY_ID"
          addCommand = "UpdateSearchSpaces"
          updateCommand = "UpdateSearchSpaces" 
          deleteCommand = "UpdateSearchSpaces"
        />
      
        <Command tableName = "CATGPENREL" idColumnName = "CATENTRY_ID"
          addCommand = "AddProductsToSearchSpace"
          deleteCommand = "RemoveProductsFromSearchSpace"
        />
      
      </PASync>
  8. »õ ·Î´õ »ç¿ëÀÚ Á¤ÀÇ Æ¯¼º ÆÄÀÏÀ» ÀÛ¼ºÇϽʽÿÀ.

    Windows NT Windows 2000 AIX Solaris Linux MassLoadCustomizer.properties´Â MassLoader.zip ¾ÆÄ«À̺꿡 ÀÖ½À´Ï´Ù. ÀÌ ÆÄÀÏÀÇ ¾ÐÃàÀ» Ç®°í .properties È®ÀåÀÚ´Â À¯ÁöÇϸ鼭 À̸§À» ¹Ù²Û ´ÙÀ½ classpathÀÇ µð·ºÅ丮¿¡ µÎ½Ê½Ã¿À.

  9. Áß¿ä: ±âÁ¸ MassLoadCustomizer.properties ÆÄÀÏÀ» Á¦°ÅÇϰųª ¼öÁ¤ÇÏÁö ¸¶½Ê½Ã¿À.

    iSeries ISeries_LODWCSDTA_Customizer.properties ÆÄÀÏÀº /QIBM/ProdData/WebCommerce/properties µð·ºÅ丮¿¡ ÀÖ½À´Ï´Ù. ÀÌ ÆÄÀÏÀ» /instroot/xml µð·ºÅ丮¿¡ º¹»çÇϰí .properties È®ÀåÀÚ´Â À¯ÁöÇÏ¸ç »õ ÆÄÀÏÀÇ À̸§À» ¹Ù²Û ÈÄ »õ ÆÄÀÏ¿¡ ÇÊ¿äÇÑ º¯°æÀ» ÇϽʽÿÀ. Áß¿ä: ¿øº» ISeries_LODWCSDTA_Customizer.properties ÆÄÀÏÀ» »èÁ¦Çϰųª ¼öÁ¤ÇÏÁö ¸¶½Ê½Ã¿À.

  10. »õ ·Î´õ »ç¿ëÀÚ Á¤ÀÇ Æ¯¼º ÆÄÀÏ¿¡¼­ XML ±¸¼º Á¤º¸ ÆÄÀÏÀ» ÁöÁ¤ÇϽʽÿÀ. ¿¹¸¦ µé¸é,
      PASyncDocumentURL = PASyncInfo.xml
  11. »õ ·Î´õ »ç¿ëÀÚ Á¤ÀÇ Æ¯¼º ÆÄÀÏ¿¡¼­ µ¿±âÈ­¸¦ »ç¿ë°¡´ÉÇϵµ·Ï ¼³Á¤ÇϽʽÿÀ. ¿¹¸¦ µé¸é,
      PASyncEnabled = true
  12. Load ¸í·ÉÀÇ »ç¿ëÀÚ Á¤ÀÇ ¸Å°³º¯¼ö °ªÀ¸·Î »õ ·Î´õ »ç¿ëÀÚ Á¤ÀÇ Æ¯¼º ÆÄÀÏ À̸§À» ÁöÁ¤ÇϽʽÿÀ.
  13. Load ¸í·É¿¡ SQL ¹ÝÀÔ ¶Ç´Â »èÁ¦ ¹æ¹ýÀ» »ç¿ëÇϽʽÿÀ. ´ÙÀ½Àº ·Î´õ·ÎÀÇ ÀûÀýÇÑ XML ÀÔ·Â ¿¹ÀÔ´Ï´Ù.
      <store-asset>
    
         <catentry
           CATENTRY_ID="10351"
           MEMBER_ID="-2000"
           PARTNUMBER="000051"
           CATENTTYPE_ID="ProductBean"
           MFPARTNUMBER="m000051"
           MARKFORDELETE="0"
           BUYABLE="1"
         />
    
         <catentry
           CATENTRY_ID="10352"
           MEMBER_ID="-2000"
           PARTNUMBER="000052"
           CATENTTYPE_ID="ProductBean"
           MFPARTNUMBER="m000052"
           MARKFORDELETE="0"
           BUYABLE="1"
         />
    
         <catentry
           CATENTRY_ID="10353"
           MEMBER_ID="-2000"
           PARTNUMBER="000053"
           CATENTTYPE_ID="ProductBean"
           MFPARTNUMBER="m000053"
           MARKFORDELETE="0"
           BUYABLE="1"
         />
    
         <catentry
           CATENTRY_ID="10358"
           MEMBER_ID="-2000"
           PARTNUMBER="000058"
           CATENTTYPE_ID="ProductBean"
           MFPARTNUMBER="m000058"
           MARKFORDELETE="0"
           BUYABLE="1"
         />
    
         <catentry
           CATENTRY_ID="10365"
           MEMBER_ID="-2000"
           PARTNUMBER="000065"
           CATENTTYPE_ID="ProductBean"
           MFPARTNUMBER="m000065"
           MARKFORDELETE="0"
           BUYABLE="1"
         />
    
         <catentry
           CATENTRY_ID="10372"
           MEMBER_ID="-2000"
           PARTNUMBER="000072"
           CATENTTYPE_ID="ProductBean"
           MFPARTNUMBER="m000072"
           MARKFORDELETE="0"
           BUYABLE="1"
         />
    
         <catgpenrel
           CATGROUP_ID="10354"
           CATENTRY_ID="10372"
           CATALOG_ID="10351"
           SEQUENCE="3"
         />
    
         <catgpenrel
           CATGROUP_ID="10354"
           CATENTRY_ID="10365"
           CATALOG_ID="10351"
           SEQUENCE="4"
         />
    
         <catgpenrel
           CATGROUP_ID="10354"
           CATENTRY_ID="10358"
           CATALOG_ID="10351"
           SEQUENCE="5"
         />
    
         <catgpenrel
           CATGROUP_ID="10355"
           CATENTRY_ID="10372"
           CATALOG_ID="10351"
           SEQUENCE="3"
         />
    
      </store-asset>
    

ÁÖ: »óǰ ¾îµå¹ÙÀÌÀú °Ë»ö °ø°£ µ¿±âÈ­¸¦ »ç¿ë ¾ÈÇϵµ·Ï ÁöÁ¤ÇÏ¸é ·Î´õ ¼º´ÉÀÌ ³ô¾ÆÁö¹Ç·Î ÀÌ ±â´ÉÀº ÇÊ¿äÇÒ ¶§¸¸ »ç¿ëÇϽʽÿÀ.

°ü·Ã °³³ä

°ü·Ã ŽºÅ©

IBM copyright