ID ºÐ¼®±â - MEMBER Å×À̺í·Î µ¥ÀÌÅÍ ·Îµå

ID ºÐ¼®±â´Â ½Ã½ºÅÛ¿¡¼­ Å×À̺í¿ëÀ¸·Î »ý¼ºÇÑ ½Äº°ÀÚ¸¦ °®´Â Å×ÀÌºí¿¡ ´ëÇÑ ºÐ¼®À» ó¸®ÇÕ´Ï´Ù. ¿©±â¿¡´Â KEYS ¶Ç´Â SUBKEYS Å×ÀÌºí¿¡ µî·ÏµÈ ¸ðµç Å×ÀÌºí ¹× ¿­ÀÌ Æ÷ÇԵ˴ϴÙ. ºÐ¼®¿¡´Â µÎ °¡Áö ±¸¼º¿ä¼Ò°¡ ÀÖ½À´Ï´Ù.

  1. µ¥ÀÌÅͺ£À̽º¿¡ 1Â÷ Å×À̺í(Áï, KEYS ¶Ç´Â SUBKEYS¿¡ ³ª¿­µÈ Å×À̺í)ÀÌ ÀÖ´ÂÁö¸¦ ÆÇº°ÇÕ´Ï´Ù.

    ÀÌ ºÐ¼®Àº °íÀ¯ »öÀÎ ºÐ¼® ¶Ç´Â Ư¼º ÆÄÀÏ ½ºÆåÀ» »ç¿ëÇÏ¿© ÇØ´ç ¿ä¼Ò¿¡ ´ëÇÑ XML µ¥ÀÌÅÍÀÇ ÄÁÅÙÃ÷¸¦ ±âº»À¸·Î ÇÕ´Ï´Ù.

  2. 1Â÷ Å×ÀÌºí¿¡ ´ëÇÑ foreign key°¡ ÀÖ´ÂÁö¸¦ ÆÇº°ÇÕ´Ï´Ù.

    ÀÌ´Â °ü·Ã Å×À̺íÀÇ foreign key ¼Ó¼º¿¡ ÀÖ´Â ºÐ¼® ½ºÆåÀ» »ç¿ëÇÏ¿© ¼öÇàµË´Ï´Ù.

MEMBER Å×À̺íÀº ORGENTITY, MBRGRP ¹× USER Å×ÀÌºí¿¡ ´ëÇÑ "½´ÆÛ Ŭ·¡½º"·Î »ç¿ëµË´Ï´Ù. ÀÌ´Â Å×ÀÌºí¿¡ MEMBER Å×À̺íÀÇ ºÎ¼Ó À¯Çü¿¡ ´ëÇÑ foreign key Á¦ÇÑÀÚ°¡ ÀÖÀ» °æ¿ì¿¡ ÂüÁ¶ ¹«°á¼ºÀ» À¯Áöº¸¼öÇÏ´Â µ¥ À¯¿ëÇÑ "is-a" ÆÐÅÏÀ» ÀÛ¼ºÇÕ´Ï´Ù. ±×·¯³ª ¸ðµç MEMBER ºÎ¼Ó À¯ÇüÀÌ °øÅë ±âº» À¯ÇüÀ» °øÀ¯Çϱ⠶§¹®¿¡ ½Äº°ÀÚ´Â ºÎ¼Ó À¯Çü °£¿¡ °íÀ¯ÇØ¾ß ÇÕ´Ï´Ù. ÀÌ´Â ORGENTITY_ID°¡ MBRGRP_ID ¹× USER_ID ¼¼Æ® ³»¿¡¼­ °íÀ¯ÇØ¾ß ÇÔÀ» ÀǹÌÇÕ´Ï´Ù. KEYS Å×À̺íÀº ORGENTITY, MBRGRP ¹× USER Å×ÀÌºí¸¸À» ÂüÁ¶ÇÏ¿© À̸¦ ¼öÇàÇÏ¸ç ½Äº°ÀÚ¿¡ ´ëÇØ µ¶Á¡ÀûÀÎ ¹üÀ§¸¦ ÁöÁ¤ÇÕ´Ï´Ù. °¢ ºÎ¼Ó À¯Çü¿¡´Â 1Â÷ ۰¡ ÀÖÀ¸¸ç, °¢°¢ÀÇ 1Â÷ Ű´Â MEMBER Å×À̺í 1Â÷ Ű¿¡ ´ëÇÑ foreign keyÀ̱⵵ ÇÕ´Ï´Ù.  

MEMBER ¹× ºÎ¼Ó À¯Çü °£ÀÇ Á¦ÇÑÀÚ·Î ÀÎÇØ MEMBER¿Í ºÎ¼Ó À¯ÇüÀÌ µ¿±âÈ­µÈ ID¸¦ °¡Áú ¼ö ¾ø´Â »óȲÀÌ ¹ß»ýÇÕ´Ï´Ù. ·Î´õ ÆÐŰÁö¸¦ »ç¿ëÇÏ¿© ORGENTITY, MBRGRP ¹× USER Å×À̺íÀ» ½Ã½ºÅÛÀ¸·Î ·ÎµåÇϱâ À§ÇØ ID ºÐ¼®±â´Â "is-a" ÆÐÅÏÀ» ÀνÄÇϰí À̸¦ ÀûÀýÇÏ°Ô Ã³¸®ÇÕ´Ï´Ù. ´ÙÀ½Àº ID ºÐ¼®±â¿¡ ´ëÇÑ XML ±¸¹®ÀÔ´Ï´Ù.

  <ORGENTITY
      ORGENTITY_ID="@orgAlias"
      ORGENTITYNAME="Test Org"
      ORGENTITYTYPE="O">
      <ISA>
         <MEMBER 
             TYPE="O" 
             STATE="1" 
         />
      </ISA>
  </ORGENTITY>

¿©±â¼­ ´ÙÀ½°ú °°Àº ±¸¹®ÀÌ »ý¼ºµË´Ï´Ù.

  <MEMBER 
      MEMBER_ID="12345" 
      TYPE="O"
      STATE="1"
  />
  <ORGENTITY
      ORGENTITY_ID="12345"           member ¿ä¼Ò¿Í µ¿±âÈ­
      ORGENTITYNAME="Test Org"
      ORGENTITYTYPE="O"
  />

ÀÌ ¹æ¹ýÀ¸·Î ID ºÐ¼®±â´Â <isa> ºÎ¼Ó ¿ä¼Ò¸¦ ó¸®ÇÏ°í µ¿±âÈ­µÈ ½Äº°ÀÚ¸¦ ÀÛ¼ºÇÕ´Ï´Ù

°ü·Ã °³³ä

°ü·Ã ŽºÅ©

°ü·Ã ÂüÁ¶

IBM copyright