May 14, 2008

¥×¥í¤È¤·¤Æ¤Î¥Ç¡¼¥¿¥â¥Ç¥ê¥ó¥°ÆþÌç


¥×¥í¤È¤·¤Æ¤Î¥Ç¡¼¥¿¥â¥Ç¥ê¥ó¥°ÆþÌç (Oracle¸½¾ì¼çµÁ)

¥­¡¼¥ï¡¼¥É¡§
¡¡ ÎÓÍ¥»Ò¡¢¥Ç¡¼¥¿¥Ù¡¼¥¹¡¢¥Ç¡¼¥¿¥â¥Ç¥ê¥ó¥°¡¢À߷ס¢ÆþÌç½ñ
¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¥Ç¡¼¥¿¥â¥Ç¥ê¥ó¥°¤¬Ê¬¤«¤ê¤ä¤¹¤¯²òÀ⤵¤ì¤Æ¤¤¤ëËÜ¡£°Ê²¼¤Î¤è¤¦¤ÊÌܼ¡¤Ë¤Ê¤Ã¤Æ¤¤¤ë¡£
  1. INTRODUCTION ¥Ç¡¼¥¿¥Ù¡¼¥¹À߷פνÅÍ×À­
  2. ´ðÁÃÊÔ ¤Ï¤¸¤á¤Æ¤Î¥Ç¡¼¥¿¥â¥Ç¥ê¥ó¥°¡½¥Ç¡¼¥¿Ãæ¿´¥¢¥×¥í¡¼¥Á¤Ë¤è¤ë³µÇ°Àß·×
    1. ¥Ç¡¼¥¿¥â¥Ç¥ê¥ó¥°¤È¤Ï
    2. ¥¨¥ó¥Æ¥£¥Æ¥£¤Î¼ïÎà¤ÈÄêµÁÊýË¡
    3. ¥Ñ¥¿¡¼¥ó¤Ç¤ª¤Ü¤¨¤ë¥ê¥ì¡¼¥·¥ç¥ó¥·¥Ã¥×
    4. Àµµ¬²½
  3. ¼ÂÁ©ÊÔ ¸½¾ì¤Ç»È¤¨¤ë¥Ç¡¼¥¿¥â¥Ç¥ê¥ó¥°¡½¥Ñ¥Õ¥©¡¼¥Þ¥ó¥¹¤ò¹Íθ¤·¤¿ÏÀÍýÀß·×
    1. ÏÀÍýÀ߷פȤÏ
    2. º÷°ú¤Î´ðÁÃÃμ±
    3. º÷°ú¤ÎÀß·×
    4. Ƴ½Ð¹àÌܤȽÅÊ£¹àÌÜ
    5. ÈóÀµµ¬²½
    6. À©Ìó¡½¥Ó¥¸¥Í¥¹¥ë¡¼¥ë
  4. APPENDIX ¼çÍ×ER¿Þɽµ­Ë¡ÂоÈɽ
´ðÁÃÊԤȼÂÁ©ÊÔ¤¬¤¢¤ê¡¢´ðÁÃÊԤǥǡ¼¥¿¥â¥Ç¥ê¥ó¥°¤Î³µÍפÈE-R¿Þ¤ÎºîÀ®¼ê½ç¤äºîÀ®»þ¤Ëµ¤¤ò¤Ä¤±¤Ê¤±¤ì¤Ð¤Ê¤é¤Ê¤¤¤³¤È¡¢¤µ¤é¤Ë¥Æ¡¼¥Ö¥ë¤ÎÀµµ¬²½¤Ê¤¬¼¨¤µ¤ì¤Æ¤¤¤ë¡£¼ÂÁ©ÊԤǤϥѥե©¡¼¥Þ¥ó¥¹¤Ë¹Íθ¤·¤Æº÷°ú¤Î´ðËܤ«¤éº÷°ú¤ò¤É¤³¤ËÀßÄꤹ¤Ù¤­¤«¡¢¤µ¤é¤Ë¤ÏSQLʸ¥ì¥Ù¥ë¤Çº÷°ú¤Î³è¤«¤·Êý¡¢¤Þ¤¿ÈóÀµµ¬²½¤ò¹Ô¤¦¤³¤È¤Ç¥Ñ¥Õ¥©¡¼¥Þ¥ó¥¹¤ò¾å¤²¤ë¤³¤È¤â½ÐÍè¤ë¤Ê¤É¤È¤¤¤Ã¤¿¤³¤È¤¬¼¨¤µ¤ì¤Æ¤¤¤ë¡£

°Ê²¼¡¢¼«Ê¬¤¬ÆÃ¤ËÊÙ¶¯¤Ë¤Ê¤Ã¤¿Éôʬ¤ò¼¨¤·¤Æ¤¤¤¯¡£

¤½¤â¤½¤â¥Ç¡¼¥¿¥â¥Ç¥ê¥ó¥°¤È¤Ï²¿¤«¡©¤È¤¤¤¦Éôʬ¤¬¼¨¤µ¤ì¤Æ¤¤¤ë¤È¤³¤í¤¬¤¢¤ë¤Î¤Ç¡¢¤½¤ÎÉôʬ¤òÈ´¿è¡£
¡¡¥Ç¡¼¥¿¥â¥Ç¥ê¥ó¥°¤È¤Ï¡¢¸½¼Â¤ÎÀ¤³¦¤ò¥â¥Ç¥ë²½¤·¡¢¥Ç¡¼¥¿¤ò¹Í¤¨¤ë¤¿¤á¤Î°ÂÄꤷ¤¿´ðÈפòºî¤ë¼êË¡¤Î¤³¤È¤Ç¤¹¡£´ë¶È¤ÎÁ´¾ðÊó¤ò¶¦Í­¤¹¤ë¤¿¤á¤Ë¡¢¥Ç¡¼¥¿¤ò°ì¸µ´ÉÍý¤·¡¢¥Ï¡¼¥É¥¦¥§¥¢¡¢¥½¥Õ¥È¥¦¥§¥¢¡¢¥¢¥×¥ê¥±¡¼¥·¥ç¥ó¤«¤éÆÈΩ¤·¤¿¡¢ÊѲ½¤ËÀ䤨ÆÀ¤ë¥â¥Ç¥ë¤òºî¤ê¤Þ¤¹¡£°ìÈÌŪ¤Ë¤Ï³µÇ°À߷פΥե§¡¼¥º¤ò¼ç¤Ë¥Ç¡¼¥¿¥â¥Ç¥ê¥ó¥°¤È¸Æ¤Ó¤Þ¤¹¡£
(pp.23)
¥Ý¥¤¥ó¥È¤ÏÊѲ½¤ËÀ䤨ÆÀ¤ë¤È¤¤¤¦¤³¤È¤í¡£¥Ç¡¼¥¿¥Ù¡¼¥¹¤È¤¤¤¦¤Î¤Ï¡¢°ìÅÙ¹½ÃÛ¤µ¤ì¤ì¤ÐÅÓÃæ¤Î»ÅÍÍÊѹ¹¤ä³ÈÄ¥¤ò¹Ô¤ï¤ì¤Ê¤¬¤é¤âŤ¯»È¤ï¤ì¤Æ¤¤¤¯¤â¤Î¤Ê¤Î¤Ç¡¢¸½ºß¤Î¾ðÊó¥·¥¹¥Æ¥à¤ÎÌäÂêÅÀ¤È¤·¤Æ¡¢´û¸¥·¥¹¥Æ¥à¤ÎÊѹ¹Í×µá¤ËÂбþ¤¹¤ë¤³¤È¤Ë»þ´Ö¤¬¤«¤«¤ê¡¢¿·¤·¤¤¥·¥¹¥Æ¥à³«È¯¤Ë»þ´Ö¤òÈñ¤ä¤»¤Ê¤¤¤È¤¤¤¦¤³¤È¤¬¤¢¤ë¡£¤½¤Î¤¿¤á¡¢ÊѲ½¤ËÀ䤨ÆÀ¤ë¥â¥Ç¥ë¤¬É¬Íפˤʤ롣

¤Þ¤¿¡¢¥×¥í¥»¥¹Ãæ¿´¥¢¥×¥í¡¼¥Á¤ÎÀ߷פˤè¤ê¡¢¶È̳ñ°Ì¤Çºî¶È¤ò¿Ê¤á¤Æ¤­¤Æ¤·¤Þ¤¤¡¢¥·¥¹¥Æ¥àÁ´ÂΤòį¤á¤ë¤ÈƱ¤¸¤è¤¦¤Ê¥Ç¡¼¥¿¤¬Â¸ºß¤·¤Æ¤·¤Þ¤Ã¤Æ¤¤¤ë¤È¤¤¤¦ÌäÂê¤â¤¢¤ë¤è¤¦¤À¡£¤½¤¦¤Ê¤ë¤È¥Ç¡¼¥¿¤Î°ì¸µ´ÉÍý¤¬¤Ç¤­¤Ê¤¤¤Î¤Ç¡¢¥×¥í¥»¥¹Ãæ¿´¥¢¥×¥í¡¼¥Á¤ÎÀ߷פ«¤é¥Ç¡¼¥¿Ãæ¿´¤Î¥¢¥×¥í¡¼¥Á¤ÇÀ߷פ·¤Ê¤±¤ì¤Ð¤Ê¤é¤Ê¤¤¤è¤¦¤À¡£¥Ç¡¼¥¿Ãæ¿´¥¢¥×¥í¡¼¥Á¤È¤¤¤¦¤Î¤Ï¡¢¥Ç¡¼¥¿¤òÀè¤Ë¹Í¤¨¡¢1¤Ä¤Î¼«¾Î¤ò1²Õ½ê¤Ç´ÉÍý¤¹¤ëÊýË¡¤È¤¤¤¦¤³¤È¤é¤·¤¤¡£¤Ê¤ë¤Û¤É¤È»×¤Ã¤¿¡£

¥Ç¡¼¥¿Ãæ¿´¥¢¥×¥í¡¼¥Á¤Î¥Ç¡¼¥¿¥â¥Ç¥ê¥ó¥°¤Î¼ê½ç¤Ï°Ê²¼¤Î¤è¤¦¤Ë¤Ê¤ë¡£
¼ê½ç³µÍ×
1¥â¥Ç¥ê¥ó¥°¤ÎÊý¿Ë·èÄê¥È¥Ã¥×¥À¥¦¥ó¤«¥Ü¥È¥×¥¢¥Ã¥×¤«¤Ê¤É¡¢¥Ç¡¼¥¿¥â¥Ç¥ëºîÀ®¤ÎÊý¿Ë¤ò·è¤á¤ë
2³µÇ°¥Ç¡¼¥¿¥â¥Ç¥ë¤Î²¾Àâ¤ÎºîÀ®Êý¿Ë¤Ë¤·¤¿¤¬¤¤¥Ç¡¼¥¿¥â¥Ç¥ë¤Î¤¿¤¿¤­Âæ¤òºîÀ®¤·¡¢µ¿ÌäÅÀ¤äÉÔÌÀÅÀ¤òÀö¤¤½Ð¤¹
3³µÇ°¥Ç¡¼¥¿¥â¥Ç¥ë¤Î¾ÜºÙ²½¼ê½ç2¤ÇºîÀ®¤·¤¿²¾Àâ¥â¥Ç¥ë¡Ê¤¿¤¿¤­Âæ¡Ë¤Î¥ì¥Ó¥å¡¼¤ò¹Ô¤¤¡¢É¬ÍפʾðÊó¤òÆÀ¤Æ¡¢¾ÜºÙ²½¤·¤Æ¤¤¤¯
4³µÇ°¥Ç¡¼¥¿¥â¥Ç¥ë¤Î¸¡¾Úµ¡Ç½Ì̤ʤɤ«¤é¥Ç¡¼¥¿¤Î²áÉÔ­¤Ë¤Ä¤¤¤Æ¸¡¾Ú¤¹¤ë
(pp.24)

¤Þ¤¿¡¢¥È¥Ã¥×¥À¥¦¥ó¥¢¥×¥í¡¼¥Á¤ÇE-R¿Þ¤òºîÀ®¤¹¤ë¼ê½ç¤Ï°Ê²¼¤Î¤è¤¦¤Ë¤Ê¤ë¡£
  1. ¥¨¥ó¥Æ¥£¥Æ¥£¤òÀö¤¤½Ð¤¹
  2. ¥ê¥ì¡¼¥·¥ç¥ó¤òÀö¤¤½Ð¤¹
  3. °À­¤òÀö¤¤½Ð¤¹
  4. ¥ª¥«¥ì¥ó¥¹¤ò¼±Ê̤¹¤ë°À­¤Þ¤¿¤Ï°À­¤ÎÁȹ礻¤ò¸«¤Ä¤±¤ë
¤·¤Ã¤«¤ê¤³¤Î¼ê½ç¤ò¼é¤ë¤³¤È¤¬¤è¤¤³µÇ°¥â¥Ç¥ë¤òºî¤ë¥³¥Ä¤é¤·¤¤¡£¤³¤Î¼ê½ç¤Ï¶ñÂÎÎã¤ò¤â¤È¤ËÃúÇ«¤Ë²òÀ⤵¤ì¤Æ¤¤¤ë¤Î¤Ç¤«¤Ê¤êʬ¤«¤ê¤ä¤¹¤¤¡£º£¤Þ¤Ç´¶³ÐŪ¤ËÀ߷פò¤·¤Æ¤¤¤¿¤³¤È¤òÈ¿¾Ê¤·¤¿¡£

¾¤Ë¤â3¾Ï¤ÇE-R¿Þ¤Î¥«¡¼¥Ç¥£¥Ê¥ê¤ÎÀßÄê¤Î»ÅÊý¤â¤È¤Æ¤âÊÙ¶¯¤Ë¤Ê¤ë¡£Â¿Âп¤Î¥ê¥ì¡¼¥·¥ç¥ó¥·¥Ã¥×¤¬¤¢¤ë¾ì¹ç¤Ï¡¢À߷פ«¤é¤â¤ì¤Æ¤¤¤ë¥¨¥ó¥Æ¥£¥Æ¥£¤¬Â¸ºß¤¹¤ë¤È¤¤¤³¤È¤é¤·¤¤¡£¤³¤ì¤ÏÃΤé¤Ê¤«¤Ã¤¿¤Ê¡£

¼ÂÁ©ÊԤΤۤ¦¤Ï¤è¤êDBÀ߷פ˿¼¤¯´Ø¤ï¤ë¿Í¸þ¤±¤À¤È»×¤¦¡£¤·¤«¤·¡¢¥×¥í¥°¥é¥Þ¥ì¥Ù¥ë¤Ç¤Ï¡¢SQLʸ¤Ç¤ÏHAVING¶ç¤è¤ê¤âWHERE¶ç¤ÎÊý¤¬¥Ñ¥Õ¥©¡¼¥Þ¥ó¥¹¤¬¤¢¤¬¤ë¡¢º÷°ú¤¬ÄêµÁ¤µ¤ì¤Æ¤¤¤ëÎó¤Ç·×»»¤ò¤·¤¿¤ê´Ø¿ô¤ò»ÈÍѤ¹¤ë¤Èº÷°ú¤¬»ÈÍѤµ¤ì¤Ê¤¤¤È¤¤¤Ã¤¿¤³¤È¤Ê¤É¤ÏÃΤäƤª¤¯¤Ù¤­¤À¤È»×¤¦¡£º£¤Þ¤Ç¥Ñ¥Õ¥©¡¼¥Þ¥ó¥¹¤ò¹Íθ¤·¤¿SQLʸ¤ò½ñ¤¤¤Æ¤³¤Ê¤«¤Ã¤¿¤Î¤Ç¡¢¾¯¤·È¿¾Ê¡£

¥Ç¡¼¥¿¥â¥Ç¥ê¥ó¥°¤Ï¡¢¥Ç¡¼¥¿¤òʬÀϤ¹¤ë¥¹¥­¥ë¤¬É¬Íפǡ¢¤³¤ì¤Ï¶È̳¥¹¥­¥ë¤¬¤Ê¤¤¤È¤Ç¤­¤Ê¤¤¤È¼¨¤µ¤ì¤Æ¤¤¤Æ¡¢¤Ê¤ë¤Û¤É¤Ê¤¡¤È»×¤Ã¤¿¡£¶È̳¤¬Ê¬¤«¤Ã¤Æ¤¤¤Ê¤¤¤È¤è¤¤À߷פʤ󤫤Ǥ­¤Ê¤¤¤Ê¤È²þ¤á¤Æ»×¤Ã¤¿¡£¥Ç¡¼¥¿¥â¥Ç¥ê¥ó¥°¤Ï¤«¤Ê¤ê¾åή¤è¤ê¤À¤Ê¤È»×¤Ã¤¿¡£

Á´ÂÎŪ¤Ë¿Þ¤â¿¤¯¡¢¥á¥ê¥Ï¥ê¤¬¤Ä¤¤¤¿ÆâÍÆ¤Ç¤«¤Ê¤êʬ¤«¤ê¤ä¤¹¤¤¡£²¿¤è¤ê¤â²¿Å٤Ⳬ¤­¤¿¤¯¤Ê¤ë¤è¤¦¤Ê»æ¼Á¤¬¤¤¤¤¡£µ»½ÑËÜ¤ÏÆâÍÆ¤âÂç»ö¤À¤±¤É¡¢ÊªÍýŪ¤Ê»æ¼Á¤â½ÅÍפʵ¤¤¬¤¹¤ë¡£

ÆþÌç¼Ô¤«¤é¤½¤ì¤Ê¤ê¤ËÀºÄ̤·¤¿¿Í¤Þ¤ÇÂоÝÈϰϤϹ­¤¤¤È»×¤¦¡£¤¿¤À¡¢¤µ¤¹¤¬¤Ë¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î´ðËÜ»ö¹à¤¬Ê¬¤«¤Ã¤Æ¤¤¤Ê¤¤¤È¼¨¤µ¤ì¤Æ¤¤¤ë¤³¤È¤ÎÀ߷פΥݥ¤¥ó¥È¤Ê¤É¤Ïʬ¤«¤ê¤Ë¤¯¤¤¤È»×¤¦¡£

¤³¤Î¡Ø¥×¥í¤È¤·¤Æ¤Î¡Á¡Ù¥·¥ê¡¼¥º¤Ï¤«¤Ê¤êʬ¤«¤ê¤ä¤¹¤¤¤â¤Î¤¬Â¿¤¤¤È»×¤¦¡£¡Ø¥×¥í¤È¤·¤Æ¤ÎOracle PL/SQLÆþÌç¡Ù¤âʬ¤«¤ê¤ä¤¹¤¯¤Æ²¿ÅÙ¤âÆÉ¤ßÊÖ¤·¤Æ¤¤¤ë¡£¤³¤Ã¤Á¤â¤ªÁ¦¤á¡£

º£²ó¤Ï̵Â̤Ëtable¥¿¥°¤ò»ÈÍѤ·¤Æ¤ß¤¿¡£ÂκۤòÀ°¤¨¤ë¤Î¤Ë»þ´Ö¤¬¤«¤«¤Ã¤¿¡¦¡¦¡¦¡£¥Æ¥ó¥×¥ì²½¤·¤Æ»È¤¤¤Þ¤ï¤½¤¦¡£

ÆÉ¤à¤Ù¤­¿Í¡§
  • ¥Æ¡¼¥Ö¥ëÀ߷פλÅÊý¤¬Ê¬¤«¤é¤Ê¤¤¿Í
  • E-R¿Þ¤¬»×¤¦¤è¤¦¤Ë¤«¤±¤Ê¤¤¿Í
  • ¥Ñ¥Õ¥©¡¼¥Þ¥ó¥¹¤ò¹Íθ¤·¤¿ÏÀÍýÀ߷פ¬É¬ÍפʿÍ
Amazon.co.jp¤Ç¡Ø¥Ç¡¼¥¿¥â¥Ç¥ê¥ó¥°¡Ù¤Î´ØÏ¢½ñÀÒ¤ò¸«¤ë

¤Ë¤Û¤ó¥Ö¥í¥°Â¼ ËÜ¥Ö¥í¥°¤Ø bana1 ¥é¥ó¥­¥ó¥°¤Ø



¥È¥é¥Ã¥¯¥Ð¥Ã¥¯URL

¥³¥á¥ó¥È¤¹¤ë

̾Á°:
URL:
  ¾ðÊó¤òµ­²±¡§ ɾ²Á¡§  ´é   À±