ãã³ã¿ã»ãã¥ãªãã£ã·ã¹ãã ãº(ãã³ã¿ã»ãã¥ãªãã£)ã¯6æ17æ¥ãããã€ãã³ããŒãå®ãããã®å¯Ÿçãæãæ ¹æ¬çãªã»ãã¥ãªãã£è«ç¹ããšé¡ããã³ã©ã ãå ¬éãããã€ãã³ããŒã«ãããã»ãã¥ãªãã£ã®çåããã³ã¢ã¯ã»ã¹å¶åŸ¡ãšæå·åã«ãããè«ç¹ã解説ããã
ãã€ãã³ããŒå¶åºŠã®ã»ãã¥ãªãã£ã«ã€ããŠã¯ãããã€ãã³ããŒãæå·åããã°ã察çã¯å®ç§ããæå·åããŠãããšããã®ããšã®åæ±ãã¯æ°ã«ããªããŠããããšæããŠãã人ãå€ããšãããã³ã©ã ã§ã¯ããã®ç¹ã倧ããªééãã§ããããšãææããŠããã
ããã¯ãããŒã¿ãæå·åããŠãããŒã¿ç®¡çã«ãããå³å¯åºŠã¯äžããŠã¯ãããªããšããã«ãŒã«ãããããã ãšããããŸãããç¹å®å人æ å ±ä¿è·å§å¡äŒãããå ¬è¡šãããŠããã¬ã€ãã©ã€ã³ã§ã¯ãæå·åãªã©ãæ¡çšããŠå€æãããå人èå¥çªå·ã«å¯Ÿãã倿åã®å人èå¥çªå·ãšåã¬ãã«ã§åãæ±ããããšèšãããŠãããšããã
ããã€ãã³ããŒä¿è·ã®æå€§ã®ãªã¹ã¯ã¯ãäœããçåã«æã人ãå€ãã ãããè€éåããããã€ãã³ããŒå¶åºŠã«ãããŠäœãæå€§ã®ãªã¹ã¯ããäžæŠã«èšãåããªããããã®1ã€ã«å人æ å ±ãåãæ±ãçŸå Žã¬ãã«ã§ã¯ããã€ãã³ããŒã«ã¯ã誰ãã¢ã¯ã»ã¹ã§ããã®ãïŒããšããç¹ãæãããããšãããäŒæ¥ã§åŸæ¥è ã«æ å ±ãžã®ã¢ã¯ã»ã¹æš©éãä»äžããã®ã¯ãå€ãã®å Žåãã·ã¹ãã 管çè ãããããŒã¿ããŒã¹ç®¡çè ãã§ãããå瀟ã¯ãã®ç¹ã§ã»ãã¥ãªãã£ã®éçšã屿§ããŠããã
ã·ã¹ãã 管çè ã¯ãçµç¹ã«ãããã·ã¹ãã ã®éçšããã³ç®¡çã«åŸäºããããŒã¿ããŒã¹ç®¡çè ã¯ãåœè©²ããŒã¿ããŒã¹ã«ãããéçšãåçš®åé¡ãžã®å¯Ÿå¿ã«åŸäºããŠããããã®ããããããã®æ åœè ãã¯ãã»ãã¥ãªãã£ã§æ±ããããå人æ å ±ã«ã¢ã¯ã»ã¹ããæš©éãæãããå¿ èŠããªããã°ãã¢ã¯ã»ã¹ããå¿ èŠèªäœããªãã
ããã§ãã·ã¹ãã 管çè ãšããŒã¿ããŒã¹ç®¡çè ã¯ãã€ãŸãå人æ å ±ãžã®ã¢ã¯ã»ã¹æš©éãèšå®ãéçšããŠããå Žåãå€ãããã·ã¹ãã 管çè ã ããããšããåçŽãªè«çã§ãã»ãã¥ãªãã£ç®¡çè ã§ããªãã·ã¹ãã 管çè ãçµç¹ã®ã»ãã¥ãªãã£ããªã·ãŒãç·æ¬ãã倧圹ãèè² ãã±ãŒã¹ãçãããªããšãããå瀟ã¯ããããããå®éçŸå Žã¬ãã«ã§åŒãèµ·ããããå人æ å ±ä¿è·ã«ãããæå€§ã®ãªã¹ã¯ã§ãããšææããŠããã
ããŒã¿ããŒã¹ç®¡çè ã®DBA(Database Administrator)ãã»ãã¥ãªãã£ç®¡çè ãšã®æç¢ºãªè·è²¬åé¢ãå®çŸããªããã°ãªããªããæå·åããããŒã¿ã¯ãèš±å¯ããããŠãŒã¶ãŒã®ã¿ãã¢ã¯ã»ã¹å¯èœã«ãã¹ãã§ãããå šæš©éãæã£ãŠããDBAã§ããã»ãã¥ãªãã£ç®¡çè ããã®èš±å¯ããªããã°æå·åããŒã¿ã®åŸ©å·ã¯ã§ããªãããã«ãã¹ãã§ãããšæèšããŠããã
æ å ±ã»ãã¥ãªãã£æ¥çã«ãããŠãã»ãã¥ãªãã£ã¯ãã§ãŒã³ã®ããã§ããã®ãã§ãŒã³ã®åŒ·åºŠã¯ãæã匱ãéšåã®åŒ·åºŠã§æ±ºãŸãããšèšãããããšãå€ããããã¯ãæ å ±ã»ãã¥ãªãã£å šäœãæ§æãããã¹ãŠã®èŠçŽ ãé«ã¬ãã«ã§ç¶æããããšãäžå¯æ¬ ã ãšããããšã衚ããŠãããã€ãŸããã·ã¹ãã ã®ã»ãã¥ãªãã£ã®ã¬ãã«ã¯ãæãã»ãã¥ãªãã£ã®ã¬ãã«ãäœãéšåã«ãã£ãŠè©äŸ¡ãããŠããŸãããããããæ»æããããšãã·ã¹ãã ã®å šäœããã¡ã«ãªã£ãŠããŸããšããããã ãå瀟ã¯ãå人æ å ±ã®ä¿è·ã«ãããæã匱ãéšåã¯DBAãšã»ãã¥ãªãã£ç®¡çè ã®è·è²¬åé¢ãšææããŠããã
ã¢ã¯ã»ã¹å¶åŸ¡ã¯ããŒã¿ããŒã¹ã®ç®¡çè ãæ°èšããå¿ èŠããã
ãå人æ å ±ã«å¯Ÿãã¢ã¯ã»ã¹å¶åŸ¡ãè¡ã£ãŠããã°ããã¹ãŠã®åé¡ã解決ãããã®ã?ããšèšãããã°ãäžæŠã«ãããšãèšãåããªãã代衚çãªæ å ±ã»ãã¥ãªãã£ã®ææ³ã«ã¯ãæå·åããšãã¢ã¯ã»ã¹å¶åŸ¡ãã®2ã€ããããæå·åãšã¢ã¯ã»ã¹å¶åŸ¡ã¯ã»ãã¥ãªãã£ã®ã¢ãããŒããæç¢ºã«ç°ãªããããäž¡è ã¯çžå®¹ããªãååšãšãªã£ãŠãããšããã
ã¢ã¯ã»ã¹å¶åŸ¡ã®ãœãªã¥ãŒã·ã§ã³ã®ãã³ããŒã¯ãåœç¶ãªããæå·åãšæ¯ã¹ãŠã¢ã¯ã»ã¹å¶åŸ¡ã®ã»ããåªäœã§ãããšäž»åŒµãããã¢ã¯ã»ã¹å¶åŸ¡ã¯ãæå·åã«æ¯ã¹ãŠãæ§ç¯ããã³å°å ¥ã®ç°¡åãããã·ã¹ãã ã®å¯çšæ§ãé«ããã¢ã«ãŠã³ãå¥ã«æ å ±ãžã®ã¢ã¯ã»ã¹æš©éãä»äžåã¯é®æããããšã§ãæ å ±æŒããäºæ ãæªç¶ã«é²ã广ããããšããã®ãèšãåã ã
ããããã·ã¹ãã ããã³ãããã¯ãŒã¯ã®ããã©ãŒãã³ã¹ã«äžãã圱é¿ã®é¢ã§æå·åãšæ¯èŒããŠããã ãã§ãå®å šæ§ã®è«ç¹ãšã¯å°ããããŠãããã³ã©ã ã§ã¯ãã»ãã¥ãªãã£ã®é¢ã§ã¯ãæå·åã®ã»ããåªäœã«ãããšããé説ã§ã¯ãªãããšãæããããäºå®äžããã§ãããããšäž»åŒµããŠããã
äžæ¹ã§æå·åãœãªã¥ãŒã·ã§ã³ã®ãã³ããŒã¯ãæå·åã¯ã¢ã¯ã»ã¹å¶åŸ¡ã«æ¯ã¹ãŠé«ã»ãã¥ãªãã£ãä¿éã§ãããšèªä¿¡ãèŠããŠãããäžãäžãæ å ±æŒããäºæ ãçºçããŠããããŒã¿ãæå·åãããŠããã°ã第äžè ãè§£èªããããšã¯ååã§ããªãã
æå·åã¯ãéå»ã«ãã¡ãªããããã£ããšãããé·ãæ§ç¯æéãæå·ååŸã®ããã©ãŒãã³ã¹å£åãæžå¿µãããŠããããšãããããã©ãŒãã³ã¹ãã·ã¹ãã å®å®æ§ãåŒ·ãæ±ããããéèæ¥çã§ã¯ãæå·åååŸã®ããã©ãŒãã³ã¹ã®å£åãäºæž¬ã§ããªããšããããšãããæå·åã®å°å ¥ããããã£ãŠããçµç·¯ããã£ãã
çŸåšã¯ããããŸã§ææãããŠããã·ã¹ãã ã®å¯çšæ§ã®åé¡ã解決ã§ãããšããŠãããéèæ©é¢ã®ãããªçŸå Žã«æ¬¡ã ãšå°å ¥ãããŠãããšãããã¢ãã©ã€ã¢ã³ã¹åã®å°å ¥ã«ããããŒããŠã§ã¢ãšãœãããŠã§ã¢ã®äžäœåã«ãŠãã¡ãªãããšããŠææãããŠããã¹ããŒãã®åé¡ãŸã§è§£æ±ºããããã®çµæãçŸåšã¯ãæå·åã¯ãã»ãã¥ãªãã£çã«ã¯é«ããšæãããã¹ããŒããåºãªãããšã¯èšããªããªã£ãã
ã¢ã¯ã»ã¹å¶åŸ¡ã®ã»ãã¥ãªãã£ã¯ã以åããã®åŒ±ç¹ãç¶ç¶ããŠãããšãããã¢ã¯ã»ã¹å¶åŸ¡ã·ã¹ãã ã®æ§ç¯ã¯ãããŒã¿ã®ååšããå éšã·ã¹ãã ã§ã¯ãªããå€éšã·ã¹ãã ãšããŠè¡ãããããã¯ãäºå®äžãã1ã€ã®ç®¡çæš©éãäœãããšã«ãªã£ãŠããŸãããã€ãã³ããŒããŒã¿ã«å¯ŸããŠã»ãã¥ãªãã£ç®¡çè ãæå®ããããšã§ã¯ãªããããŒã¿ããŒã¹ã®ã¢ã¯ã»ã¹å¶åŸ¡ã®ããã®ç®¡çè ãæ°èšããªããã°ãããªããããæ ¹æ¬çãªå¯Ÿçã«ã¯ãªã£ãŠããªãããªããã¢ã¯ã»ã¹å¶åŸ¡ã«ãŠæå®ãããã¹åã³æ¡ä»¶ã«è©²åœããªãã¢ã¯ã»ã¹ã®å Žåã察象å€ãšãªãå Žåãããã
å人æ å ±ã¯ãæŒãããã®ããšèããã»ãããã
æ å ±ã»ãã¥ãªãã£å¯Ÿçã§ã¯ãæ å ±ãæåããå€éšã«æŒåºããªãããšããåæãšããã»ãããããæ å ±æŒãããææ¬çã«é®æããããã«ãããããœãªã¥ãŒã·ã§ã³ãæ¡çšã察çãè¬ããŠããçµ¶ããã«å€§èŠæš¡ãªæ å ±æŒããäºæ ã¯çºçããŠãããæ·±å»ãªåé¡ãæ±ããŠããåãªããªã¹ã¯ç®¡çã®è«çã§ãããšãããããªãã
çŸç¶ã®ã»ãã¥ãªãã£ã®æè¡ã¯äžå šã§ã¯ãªãããã®ãããæ å ±ãå®å šã«é²ãããšãã§ããªãããæ å ±ã¯æŒåºãããã®ããšèããã»ãããããšããããã¡ãããã»ãã¥ãªãã£ãã³ããŒã¯æ¥ã ã»ãã¥ãªãã£æè¡ã®åäžã«åªããŠããããããã§ãæ å ±æŒãããå®å šã«é²ããœãªã¥ãŒã·ã§ã³ãæäŸã§ããŠã¯ããªãã
ã»ãã¥ãªãã£å¯Ÿçãèããã ãã§ãªããäžãäžæŒããããŠããŸã£ãæã®ããã«ããã®åŸã®ãå埩åããéèŠã ãšãããããã¯ãæ å ±æŒããã®åœ±é¿ãæå°éã«æããæ¥ã ã®æ¥åç¶æ ã«æ»ããŸã§ãã©ãã ãçæéã§å éšããã³å€éšã«åœ±é¿ãäžããªããããã€ã³ããšãªãã
æå·åã¯æ å ±æŒãããèµ·ããŠããŸã£ãå Žåã§ããæ å ±ãå®å šã«ä¿è·ã§ããå¯äžã®æ¹æ³ã§ãããæ å ±ãæŒããããŠã第äžè ã«ã¯äžèº«ãèªã¿åããªããæ³šæããªããã°ãããªãã®ã¯ãæå·åããããŒã¿ãšæå·åã»åŸ©å·éµãçãŸããããæå·åã®æå³ããªããªã£ãŠããŸãç¹ã ãæå·åããããªããéµç®¡çãã®æ³å®ãæ±ããããã
æå·åã·ã¹ãã ã¯ã誰ãæå·åã»åŸ©å·ã®éµãæã€ã®ããæå®ããããšã§ãæ å ±ãžã®ã¢ã¯ã»ã¹æš©éã管çã§ãããã€ãŸããéµç®¡çãé©åã«è¡ãããŠããã®ã§ããã°ãã¢ã¯ã»ã¹å¶åŸ¡ã®ãœãªã¥ãŒã·ã§ã³ã®ãã³ããŒã䞻匵ããŠããéšåã¯ãã¹ãŠè§£æ±ºã§ãããšããã
ããŒã¿æå·åãåæãšããã»ãã¥ãªãã£ç®¡çã®äžç°ãšããŠã¢ã¯ã»ã¹å¶åŸ¡ãœãªã¥ãŒã·ã§ã³ã䜵çšããæ¹æ³ã¯èãããããåžè²©ã®ããŒã¿æå·å補åã®äžã§ãã»ãã¥ãªãã£ã«é¢ããæ£ç¢ºãªæŠå¿µãæã£ãŠèšèšãããŠãããœãªã¥ãŒã·ã§ã³ã®å Žåã¯ãããŒã¿ããŒã¹ããã³æå·åãããã«ã©ã åäœã§ã¢ã¯ã»ã¹å¶åŸ¡ãèšå®ã§ããã€ã³ã¿ãã§ãŒã¹ããã§ã«å®è£ ãããŠãããããåå¥ã«ã¢ã¯ã»ã¹å¶åŸ¡ãœãªã¥ãŒã·ã§ã³ã远å ã§æ§ç¯ããå¿ èŠããªããªãã
ãŸããæå·åã·ã¹ãã ãæ§ç¯ãããšãçµç¹å šäœã«ãããããŒã¿ç®¡çã®ããã»ã¹ãå€ãããããããå€åã¯ãéçºããã»ã¹ã«ã圱é¿ãäžããããŒã¿ã®çæã»å ±æã»å»æ£ãšããããŒã¿ã®ã©ã€ããµã€ã¯ã«å šäœã«ãããæå·åã»åŸ©å·ã®éµãã©ã®ããã«ç®¡çããã®ããèããªããšè¡ããªã矜ç®ã«ãªããããã¯ãããžãã£ãã«åãå ¥ããã¹ãã§ãããããŒã¿ã®åŠçããã»ã¹ã¯ãã¡ãããéçºããã»ã¹ãŸã§äžæ®µéã©ã³ã¯ã¢ãããããã£ããã«ãªãããã§ããããã®ãããªããšãæ¢ã«çµéšããŠããæ°å€ãã®æµ·å€ã®äŒæ¥ã¯ãæå·åå°å ¥åŸã®æºè¶³åºŠãé«ããšè©äŸ¡ããŠãããšããã