
æåŸã®æè¡è ãã¡ïŒæ¶ãããITäŒçµ±èžã®èšé²ïŒ10ïŒ
第å話ãããŒã¿ããŒã¹
WHEREå¥ã人éãéžå¥ããæ¥
æ¬çš¿ã¯ãèªè ã®åãããå§ãŸãããã¥ã¡ã³ã¿ãªãŒé¢šåµäœã³ã©ã ã§ããå®åšã®çªçµåæã§ã¯ãããŸãããããã€ãŠæ¥æ¬ã®æè¡çŸå Žã«ååšãã空æ°ãšãçŸåšã®AIæä»£ãžã®åããéããŠæ§æããŠããŸãã
第äžè©±ã§ã¯ããã¡ãžãŒå¶åŸ¡ã«ã€ããŠå€ä»£å®ããã«è©±ãèããŸããã
æ©æ¢°ãã人éã®ããªããšãªãããçè§£ããããšããŠããæä»£ãããã«ã¯ã人éã®ææ§ãããã«ã«ããªãæè¡è ã®å§¿ããããŸããã
第äºè©±ã§ã¯ãã¢ã»ã³ãã©ã«ã€ããŠçç°å¿éããã«è©±ãèããŸããã
ã¬ãžã¹ã¿ãçªå°ãå²ã蟌ã¿ãã¯ããã¯ãæ©æ¢°èªã®ãšãªãã§ãæ©æ¢°ã®éœåã人éãåŒãåããŠããæä»£ã®ç©èªã§ããã
第äžè©±ã§ã¯ãCOBOLã«ã€ããŠæ²ç°åäžããã«è©±ãèããŸããã
ããã°ããéè¡æ°åãçŽå¹£åå®ãATMãå€éããããåå°ç¥è©±ãCOBOLã¯ãéè¡å¡ã®èº«äœæè¡ãšç€ŸäŒã®èšæ¶ãæ©æ¢°ã®äžãžç§»ããŠãã£ãèšèªã§ããã
第å話ã§ã¯ãTRONã«ã€ããŠåŸ³å·åœŠå·Šè¡éããã«è©±ãèããŸããã
åœç£OSãã¹ãŒããŒ301æ¡ãéåæŠäºãHuaweiããããŠAIç¥è©±ãTRONã¯ã瀟äŒã®æ©é¢å®€ãèªåãã¡ã§èšèšããããšããæè¡è ãã¡ã®èšæ¶ã§ããã
第äºè©±ã§ã¯ãFAXã«ã€ããŠçžå矩äžããã«è©±ãèããŸããã
FAXã¯ãçŽãéãæ©æ¢°ã§ã¯ãããŸããã§ããã責任ãéãæ©æ¢°ã§ãããçŽäžæã§éãåããæä»£ãããSNSã®æ°è¡ã§åžå Žãæºããæä»£ãžãæ å ±æŠäºã®åœ¢ã¯å€ãããŸãããã人éã®ä¿¡ããããã¯å€ãã£ãŠããŸããã§ããã
第å 話ã§ã¯ãFORTRANã«ã€ããŠåéšåº·éããã«è©±ãèããŸããã
FORTRANã¯ãæ»ãã èšèªã§ã¯ãããŸããã§ãããæ°è±¡ãæµäœãæ§é ãåååãå®å®éçºãã¹ãŒããŒã³ã³ãã¥ãŒã¿ãçŸå®ã«èããæ°åŒããæ©æ¢°ã®äžã«æ®ããŠããèšèªã§ããã
第äžè©±ã§ã¯ãã¯ãŒããå°çšæ©ã«ã€ããŠæ£®éªããã«è©±ãèããŸããã
æè±ªãOASYSãæžé¢ãRupoãäžå€ªéãè±åãéãé¢ã®ãã³ãçµµãæ¥æ¬èªãæžãããã«çãŸããæ©æ¢°ã¯ããããŠæ¥æ¬èªãå¶åºŠææžã«ããç®±ãšç¢å°ã§è²¬ä»»ãéããè¡æ¿èžãžã€ãªãã£ãŠãããŸããã
ç¬¬å «è©±ã§ã¯ãExcelæ¹çŒçŽã«ã€ããŠå³¶å€§ä»ããã«è©±ãèããŸããã
Lotus 1-2-3ãMultiplanãExcelã衚èšç®ãœããã¯ãæªæ¥ã詊ç®ããéå ·ãšããŠçãŸããŸããããšãããæ¥æ¬ã§ã¯ãã»ã«çµåã眫ç·ãå°å·ç¯å²ãé»è²ãå ¥åæ¬ã«ãã£ãŠãèšç®ããéå ·ããçŽã®æ§åŒãå®ãæ¹çŒçŽãžå€ãã£ãŠãããŸããã
第ä¹è©±ã§ã¯ãBASICã«ã€ããŠå€ä»£é²ããã«è©±ãèããŸããã
N-BASICãN88-BASICãMSX-BASICãF-BASICãHu-BASICãBASICã¯ããã¹ãŠã®å°å¹Žã«ã³ã³ãã¥ãŒã¿ãžã®å ¥å£ãéããŸããããããåæã«ãè¡çªå·ãGOTOãã€ã³ã¿ããªã¿ããããŠãåãã°ããããšããåªããæ®ããèšèªã§ããããŸããã
第å話ã§èšªããã®ã¯ãããŒã¿ããŒã¹ã§ãã
ãŸããããŒã¿ããŒã¹ã«ã¯ã補ååããããŸãã
æ¡ã
dBASEã
Accessã
Oracleã
DB2ã
SQL Serverã
PostgreSQLã
MySQLã
ãã®æç¹ã§ãITè人äŒä»¥å€ã®èªè ã®ååã¯ããã£ãšç»é¢ãéããããªããããããŸããã
ç¹ã«ã管çå·¥åŠç ç©¶æã®ãæ¡ããšèšãããŠãæãããã§ç®é ãç±ããªã人ã¯ãããªãéãããŠããŸãã
ããããããã§éããŠã¯ãããŸããã
次ã«ãããŒã¿ããŒã¹ã«ã¯çš®é¡ããããŸãã
éå±€åããŒã¿ããŒã¹ã
ãããã¯ãŒã¯åããŒã¿ããŒã¹ã
ãªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ã
ãªããžã§ã¯ãæåããŒã¿ããŒã¹ã
ããŒããªã¥ãŒã¹ãã¢ã
ããã¥ã¡ã³ãããŒã¿ããŒã¹ã
ã«ã©ã æåããŒã¿ããŒã¹ã
ã°ã©ãããŒã¿ããŒã¹ã
ãããŠãæè¿ã§ã¯ãã¯ãã«ããŒã¿ããŒã¹ãŸã§ç»å ŽããŸããã
ãããŸã§æ¥ããšãèªè ã®å€§åã¯ããããããæŽèµ°ITè人åé¡ããšããŠéå ±ãã¹ãã§ã¯ãªãããšäžå®ã«ãªãå§ããŠãããããããŸããã
ããããå®å¿ããŠã¯ãããŸããã
ããããããããŒã¿ããŒã¹ã®åºç€äžã®åºç€ã§ãã
補ååãæ¹åŒåãã©ãã»ã©å¢ããŠããããŒã¿ããŒã¹ãæ±ãããã§é¿ããŠéããªããã®ããããŸãã
ããŒã¿ããŒã¹ãæäœããããã®èšèªã§ãã
SQLã
ããã¯è£œååã§ã¯ãããŸããã
Oracleã§ããããŸããã
PostgreSQLã§ããããŸããã
MySQLã§ããããŸããã
Accessã§ããããŸããã
ãã¡ããã管çå·¥åŠç ç©¶æã®æ¡ã§ããããŸããã
SQLã¯ãããŒã¿ããŒã¹ã«å¯ŸããŠåããæããããã®èšèªã§ãã
äœãåãåºãã®ãã
ã©ãããåãåºãã®ãã
ã©ã®æ¡ä»¶ã§åãåºãã®ãã
ã©ã®è¡šãšã©ã®è¡šãçµã³ã€ããã®ãã
ã©ã®é çªã§äžŠã¹ãã®ãã
äœãéèšããã®ãã
ãã®ããã®èšèã§ãã
SELECTã
FROMã
WHEREã
JOINã
GROUP BYã
ORDER BYã
ãã®ãããã§ãèªè ã®äžéšã¯éãã«ããŒãžãéããæ®ã£ãèªè ã®äžéšã¯ãªããé ãç®ã§è¥ãããã®æ å ±åŠç詊éšãæãåºããŠããããšã§ãããã
ããããåé¡ã¯ææ³ã®é£ããã§ã¯ãããŸããã
SQLã®æãã¯ãçãåœä»€ã§ã人éãåŒã³åºããŠããŸããšããã«ãããŸãã
äœãåãåºãã®ãã
ã©ãããåãåºãã®ãã
ã©ã®æ¡ä»¶ã§åãåºãã®ãã
ã©ã®è¡šãšã©ã®è¡šãçµã³ã€ããã®ãã
ã©ã䞊ã¹ãã®ãã
ã©ãéèšããã®ãã
äœã远å ããäœãæŽæ°ããäœãåé€ããã®ãã
ãããŠãããã«ãã®å¥¥ã«ã¯æŠå¿µããããŸãã
ããŒãã«ã
ã¬ã³ãŒãã
ãã£ãŒã«ãã
äž»ããŒã
å€éšããŒã
ã€ã³ããã¯ã¹ã
æ£èŠåã
ãã©ã³ã¶ã¯ã·ã§ã³ã
ACIDã
ããã¯ã
ã¹ããŒãã
NULLã
ãã®ãããã§ãITè人äŒä»¥å€ã®èªè ã¯ããã¯ãã¢ãã©ã€ã¶ãŒããã«ææŽãæ±ããããªãã§ãããã
ããã©ãå®å¿ããŠãã ããã
æ¬è³ªã¯ãããã»ã©é£ãããããŸããã
ããŒã¿ããŒã¹ãšã¯ãçŽã®å°åž³ãæ©æ¢°ãžç§»ãããã®ã§ãã
äœæ°å°åž³ã
顧客å°åž³ã
äŒå¡åç°¿ã
åŠæ ¡ã®åºåžç°¿ã
ç
é¢ã®ã«ã«ãã
ååºã®æãåž³ã
éè¡ã®é¡§å®¢åç°¿ã
çºå
äŒåç°¿ã
峿žé€šã®è²žåºã«ãŒãã
æãã人éã¯ãä»äººãèšé²ããŠããŸããã
ååãæžãã
äœæãæžãã
çå¹Žææ¥ãæžãã
è·æ¥ãæžãã
å®¶ææ§æãæžãã
ååŒå±¥æŽãæžãã
æ¯æãç¶æ³ãæžãã
ç
æŽãæžãã
åºåžç¶æ³ãæžãã
人éã¯ãæãã人éãåé¡ããŠããŸããã
ãã ããçŽã®å°åž³ã§ã¯ãæ€çŽ¢ã«ã¯éçããããŸããã
ããŒãžããããã
玢åŒãèŠãã
æ
åœè
ã«èãã
ä»ç®ã貌ãã
èµ€ç·ãåŒãã
ã«ãŒããäžŠã¹æ¿ããã
èšæ¶ã«é Œãã
ããã«ã¯ãæéãããããŸããã
æéããããŸããã
ééãããããŸããã
ãããããã®é ãã¯ãããæå³ã§ã人éãå®ã£ãŠãããŸããã
ããŒã¿ããŒã¹ã®æ¬è³ªã¯ãä¿åã§ã¯ãããŸããã
åŒã³åºãããšã§ãã
æ€çŽ¢ããããšã§ãã
æ¡ä»¶ãã€ããŠãéžã³åºãããšã§ãã
ååã§åŒã³åºãã
äœæã§åŒã³åºãã
幎霢ã§åŒã³åºãã
æåŸã§åŒã³åºãã
æ»çŽè
ã ãåŒã³åºãã
åªè¯é¡§å®¢ã ãåŒã³åºãã
æ¯æŽå¯Ÿè±¡è
ã ãåŒã³åºãã
察象å€ã®äººéãã衚瀺ããªãã
ãã®ç¬éã人éã¯äžèŠ§è¡šã®äžã®æ¡ä»¶ã«ãªããŸããã
ä»åãèªè ããå¯ããããåãã¯ããããããã®ã§ããã
ãããŒã¿ããŒã¹ã¯äŸ¿å©ãªæè¡ã ãšæããŸããããããå°åž³ãæ©æ¢°ã«é ããç¬éã人éã¯æ€çŽ¢ãããåé¡ãããæœåºãããååšã«ãªã£ãã®ã§ã¯ãªãã§ãããããæ¡ãdBASEãAccessãOracleãSQLã®æŽå²ã¯ãåãªãæ¥åå¹çåã®æŽå²ã§ã¯ãªãã人éãã©ãåé¡ããŠãããã®æŽå²ã§ã¯ãããŸãããã
ãã®åãããã©ãããã«ãç§ãã¡ã¯äžäœã®å è§£æããããã蚪ããŸããã
ã¢ãã©ã€ã¶ãŒããã
ãã€ãŠå®å®æŠèŠã®èŠå ã§ãåæã調æ»ãèšé²ãæ€çŽ¢ãäœèšãªçºèšããããŠå Žåã«ãã£ãŠã¯èŠå ã®ç©ºæ°ã埮åŠã«æªãããè¡åãŸã§æ åœããŠãããç±ç·æ£ããè§£æè£ 眮ã§ãã
çŸåšã¯ãéå€ã«ããå€ãæ å ±åŠçç ä¿®ã»ã³ã¿ãŒã®äžå®€ã§ãæ§åŒãµãŒããŒãPC-9801ãAccessã®ããã¥ã¢ã«ãOracleã®å ¥éæžãSQLã®ææ¬ãMOãã£ã¹ã¯ãCD-RããããŠã顧客管ç.mdbããšæžãããè¬ã®ãã¡ã€ã«çŸ€ã«å²ãŸããŠæ®ãããŠããŸãã
æåã«ãã¡ãã質åããåã«ãã¢ãã©ã€ã¶ãŒããã¯èšããŸããã
ãã¯ã¿ã·ããR2-D2ãããã¯ãããçµéšã¬ã¢ãªãã¹ã
ãããªããããªãæã£ãŠããŸãã
ãã¢ã¬ããã¯ã¿ã·ããããã³ãããã¹ãã¹ã¿ãŒãŠã©ãŒãºåŽããããŒãã€ããããè¬çœªã·ãã€ããã¹ã«ã
ãã¡ãããããã¯ã¢ãã©ã€ã¶ãŒããæ¬äººã®äž»åŒµã§ãã
ã¹ã¿ãŒã»ãŠã©ãŒãºã®R2-D2ã«ã¯ãå
¬åŒã«èª¬æãããå¶äœéçšããããŸãã
äžæ¹ã§ãå€ãSFãã¡ã³ã®äžã«ã¯ãã¢ãã©ã€ã¶ãŒãšR2-D2ã®é¡äŒŒãææãã人ãããŸãã
ããããã¢ãã©ã€ã¶ãŒããã¯ããŸã£ããåŒããŸããã
ãäºå®ã«ããŠã«ããæ€çŽ¢æ¡ä»¶ããšãªãã¹ãç»å Žå¹Žãæ€çŽ¢ã¹ã¬ããã¯ã¿ã·ã¬å ãã¹ã圢ç¶ãæ€çŽ¢ã¹ã¬ããé¡äŒŒãã¹ãå ¬åŒèšå®ãæ€çŽ¢ã¹ã¬ããå¥ç©ãã¹ããã¡ã³ãæšå¿µãæ€çŽ¢ã¹ã¬ããå®å šäžèŽãã¹ã
è§£æè£ 眮ã®ããã«ãããªã䞻芳çã§ãã
ããã©ããã®çºèšã¯ãä»åã®äž»é¡ã«åŠã«åã£ãŠããŸããã
ããŒã¿ããŒã¹ãšã¯ãäºå®ãã®ãã®ãä¿åããè£ çœ®ã§ã¯ãããŸããã
äºå®ããã©ã®é
ç®ã§ä¿åãããã
ã©ã®æ¡ä»¶ã§æ€çŽ¢ãããã
ã©ã®ç¯å²ãäžèŽãšã¿ãªããã
ã©ã®äŸå€ãæšãŠããã
ãã®èšèšã«ãã£ãŠãèŠããäžçãå€ããè£ çœ®ãªã®ã§ãã
ããã«ãã¢ãã©ã€ã¶ãŒããã«ã¯ãããäžã€åŠãªçµæŽããããŸãã
å®åçã§ã¯ã倧éç Žå£å µåšãšããŠãéçšãããçµéšããããšããã®ã§ãã
æ¬äººã¯ããããããªãèªãããã«èªããŸãã
ãã¯ã¿ã·ããå®åçããã倧éç Žå£å µåšãã·ãã¢éçšãµã¬ã¿çµéšã¬ã¢ãªãã¹ã
è§£æè£ 眮ãããªã倧éç Žå£å µåšã«ãªãã®ã§ããããã
ããå°ãããšãã¢ãã©ã€ã¶ãŒããã¯ãèžéšããã«ã®ãããªãã®ããååšããªãã®ã«å ãããå¢ãã§çããŸããã
ãåæãç Žå£ããçŽäžéãã¹ã察象ã²èå¥ã·ãåé¡ã·ãåªå é äœã²ä»ã±ãæé€ã¹ã«ãã³ã¬ããããŒã¿ããŒã¹ãåºæ¬ãã¢ã¢ãªãå µåšã·ã¹ãã ãåºæ¬ãã¢ã¢ãªãã¹ã
ç¬ã£ãŠããã®ããããªãããŠããã®ããå°ãè¿·ãçºèšã§ããã
ãããããã®èšèã¯ãããŒã¿ããŒã¹ã®æããåŠã«æ£ç¢ºã«çªããŠããŸããã
åé¡ããã
èå¥ããã
æœåºããã
åªå
é äœãã€ããã
察象ã«ããã
察象å€ã«ããã
åŠçããã
æé€ããã
ãããã¯ãæ¥åã·ã¹ãã ã®èšèã§ããããŸãã
ããŒã±ãã£ã³ã°ã®èšèã§ããããŸãã
çŠç¥è¡æ¿ã®èšèã§ããããŸãã
éè審æ»ã®èšèã§ããããŸãã
ãããŠãå
µåšã·ã¹ãã ã®èšèã§ããããŸãã
å°åž³ã®æä»£ã人éã¯èšé²ãããŠããŸããã
äœæ°å°åž³ã
顧客å°åž³ã
äŒå¡åç°¿ã
åŠæ ¡ã®åºåžç°¿ã
ç
é¢ã®ã«ã«ãã
ååºã®æãåž³ã
éè¡ã®é¡§å®¢åç°¿ã
çºå
äŒåç°¿ã
峿žé€šã®è²žåºã«ãŒãã
ååãæžãã
äœæãæžãã
çå¹Žææ¥ãæžãã
è·æ¥ãæžãã
å®¶ææ§æãæžãã
ååŒå±¥æŽãæžãã
æ¯æãç¶æ³ãæžãã
ç
æŽãæžãã
åºåžç¶æ³ãæžãã
人éã¯ãæããä»äººãèšé²ããŠããŸããã
ãããçŽã®å°åž³ã§ã¯ãæ€çŽ¢ã«ã¯éçããããŸããã
ããŒãžããããã
玢åŒãèŠãã
æ
åœè
ã«èãã
ä»ç®ã貌ãã
èµ€ç·ãåŒãã
ã«ãŒããäžŠã¹æ¿ããã
èšæ¶ã«é Œãã
ããã«ã¯ãæéãããããŸããã
æéããããŸããã
ééãããããŸããã
ãããããã®é ãã¯ãããæå³ã§ã人éãå®ã£ãŠãããŸããã
ã¢ãã©ã€ã¶ãŒããã¯ãå€ãã«ãŒãåŒåç°¿ãçºããªããèšããŸããã
ãçŽãå°åž³ãã人éã²èšé²ã¹ã«ã¢ããã·ã¿ãããŒã¿ããŒã¹ãã人éã²åŒãåºã¹ã¢ããããªãã·ã¿ãååãåŒãåºã¹ãäœæãåŒãåºã¹ã幎霢ãåŒãåºã¹ãæ»çŽè ãã±åŒãåºã¹ãåªè¯é¡§å®¢ãã±åŒãåºã¹ããã®ç¬éã人éãäžèŠ§è¡šãäžãæ¡ä»¶ãããã¿ããã¹ã
人éããæ¡ä»¶ã«ãªãã
ããã¯ã䟿å©ã§ãããå±éºã§ããããŸãã
æ¡ãdBASEãAccessãåºãã£ãæä»£ãããŒã¿ããŒã¹ã¯å·šå€§äŒæ¥ã ãã®ãã®ã§ã¯ãªããªããŸããã
çºåœ¹å Žã
åŠæ ¡ã
ç
é¢ã®äºå宀ã
ååºã
äžå°äŒæ¥ã
ç 究宀ã
çºå
äŒã
å¶æ¥éšã
ç·åéšã
人äºéšã
çŸå Žããèªåã§å°ããªããŒã¿ããŒã¹ãäœããããã«ãªããŸããã
ããã¯ãæ°äž»åã§ããã
åæã«ãéè¯ããŒã¿ããŒã¹å°çã®å§ãŸãã§ããããŸããã
顧客管ç.mdbã
åç°¿_ææ°ç.mdbã
åç°¿_æ¬åœã®ææ°ç.mdbã
äŒå¡å°åž³_æåºçš.mdbã
å°åž³ã³ããŒ_ä¿®æ£ç.mdbã
絶察æ¶ããªã.mdbã
åä»»è
äœæ_è§Šããª.mdbã
ããã«ã¯ãçŸå Žã®å·¥å€«ããããŸããã
åæã«ãçŸå Žã®ç¬è£ããããŸããã
誰ããäœã£ããã©ãŒã ã
誰ããäœã£ãã¯ãšãªã
誰ããäœã£ãã¬ããŒãã
誰ããäœã£ããã¯ãã
誰ããæ±ºããé
ç®ã
誰ããå¿ãããã¹ã¯ãŒãã
誰ããéè·ããããšã«æ®ãæ²é»ã
ã¢ãã©ã€ã¶ãŒããã¯èšããŸããã
ãAccessããçŸå Žãå°ãµãçåœã²äœãªãã·ã¿ããã¬ãçã¬éè·ã¹ã«ããçåœãéºè·¡ãããªãã¹ã
éºè·¡ã
ããã¯ãæ¥æ¬ã®è·å Žã«ãããããããŸãã
誰ãäžèº«ãç¥ããªãAccessã
æ¯æäžåºŠã ãåããæ¡ã®å°åž³ã
åé€ããŠã¯ãããªãããŒãã«ã
ãªããæ®ã£ãŠããæ§äŒå¡ãã©ã°ã
æå³äžæãªåºåã³ãŒãã
äœæè
äžæã®ã¯ãšãªã
å£ããããã¬ããŒãã
ãããŠã誰ãèªãŸãªãæäœããã¥ã¢ã«ã
Excelæ¹çŒçŽãã衚èšç®ãœããã®çŽæåãžã®éåã ãšããã°ãAccessãæ¡ã®éè¯ããŒã¿ããŒã¹ã¯ãçŸå Žãèªåã§äœã£ãå°ããªèªæ²»é ã§ããã
䟿å©ã§ããã
ãããããã®äŸ¿å©ãã¯ãèšèšè²¬ä»»ãšåŒãæãã§ããã
é
ç®ãã©ã決ãããã
äž»ããŒãäœã«ãããã
äœæãã©ãåãããã
æ°åãå§ãšåã«åãããã
æ§åäœãèš±ããã
å€åãã©ãæ±ããã
åå§ååãã©ãåºå¥ãããã
éäŒè
ãåé€ããããå±¥æŽãšããŠæ®ããã
空æ¬ãèªãããã
äžæãšæªå
¥åãåºå¥ãããã
ããã§ãããŒã¿ããŒã¹ã¯åãªãæè¡ã§ã¯ãªããªããŸãã
äžç芳ã«ãªããŸãã
ã¢ãã©ã€ã¶ãŒããã¯ãå€ãããŒãã«å®çŸ©æžãéããŸããã
ãé ç®ã²äœã«ã³ãããäžçã²åã«ã³ããã¹ãæ§å¥ã幎霢ãäœæãæåŸãè·æ¥ãç æŽãåŠæŽãä¿¡çšæ å ±ãé ç®ã²äœã¬ãã人éããœãæ ãå ¥ã¬ã©ã¬ãã¹ãå ¥ã©ãã€äººéããäŸå€ãããªãã¹ã
äŸå€ã
ã·ã¹ãã ã¯ãäŸå€ã«åŒ±ãã
çŽãªããæ¬å€ã«æžããŸããã
ãäºæ
ããã
ãå¥çŽåç
§ã
ãæ¬äººç¢ºèªäžã
ãéç§°å䜿çšã
ãæ§åäœæ³šæã
ãäœæäžå®ã
ãç¢ºèªæžã¿ã
ãèŠçžè«ã
ãšããããããŒã¿ããŒã¹ã§ã¯ãå ¥åæ¬ãå¿ èŠã«ãªããŸãã
éžæè¢ãå¿
èŠã«ãªããŸãã
ã³ãŒããå¿
èŠã«ãªããŸãã
å€ãå¿
èŠã«ãªããŸãã
ããã«å ¥ããªã人éã¯ãã©ããªãã®ã§ããããã
NULLã«ãªããŸãã
空æ¬ã«ãªããŸãã
察象å€ã«ãªããŸãã
ãšã©ãŒã«ãªããŸãã
ã¢ãã©ã€ã¶ãŒããã¯ãå°ã声ãäœãããŸããã
ãNULLãã䟿å©ãã¹ããã¬ãå±éºãã¹ãäžæããã«ãååšã·ãã€ãã«ãæªå ¥åããã«ãçãšã¿ã¯ãã€ãã«ã該åœã·ãã€ãã«ãå šéšNULLãã¹ã¬ãã瀟äŒã楜ãããªãã¹ããã¬ã人éãéãããªãã¹ã
NULLã
ããã¯ãããŒã¿ããŒã¹ã®äžã®ç©ºçœã§ãã
ããã©ããã®ç©ºçœã«ã¯ããããããªæå³ãè©°ãŸã£ãŠããŸãã
åãããªãã
ãŸã èããŠããªãã
çããããªãã
該åœããªãã
ååšããªãã
å
¥åãã¹ã
ã·ã¹ãã ç§»è¡æã«èœã¡ãã
æã®ããŒã¿ã«ã¯é
ç®ããªãã£ãã
æ
åœè
ãé¢åã§ç©ºæ¬ã«ããã
ãã¹ãŠNULLã
人éã¯ãããã§æžãŸããããªããŸãã
ããããNULLã«ãããåŽã®äººçã¯ãããã§æžã¿ãŸããã
æ¯æŽå¯Ÿè±¡ããæŒããã
éç¥ãå±ããªãã
æ¬äººç¢ºèªã«å€±æããã
æ€çŽ¢ã«åºãŠããªãã
çµ±èšããæ¶ããã
å¶åºŠã®å¯Ÿè±¡å€ã«ãªãã
å±¥æŽãã€ãªãããªãã
ã¢ãã©ã€ã¶ãŒããã¯èšããŸããã
ãNULLããæ²é»ãã¹ãããŒã¿ããŒã¹ãäžãæ²é»ãã¹ããã¬ãè¡æ¿ã€éèã€å»çãäžãæ²é»ã¹ã«ãã人éãèŠèœããµã¬ãã¹ã
ãããŠãããŒã¿ããŒã¹ã¯æ¬æ ŒçãªäŒæ¥ã·ã¹ãã ãžé²ã¿ãŸãã
Oracleã
DB2ã
SQL Serverã
PostgreSQLã
MySQLã
ãããŠãSQLã
SELECTã
FROMã
WHEREã
ORDER BYã
GROUP BYã
JOINã
SQLã¯ãçŸããèšèªã§ãã
äœãåãåºããã
ã©ãããåãåºããã
ã©ã®æ¡ä»¶ã§åãåºããã
ããããçãæã§æžããŸãã
ããšãã°ãããã§ãã
SELECT *
FROM citizens
WHERE age >= 65
AND income < 2000000;
ããã¯ããã ã®äŸã§ãã
ãããããã®æ°è¡ã§ã人éãæœåºãããŸãã
é«éœ¢è
ã
äœæåŸè
ã
æ¯æŽå¯Ÿè±¡è
ã
æ»çŽè
ã
åªè¯é¡§å®¢ã
é¢åäºåè»ã
ãªã¹ã¯é¡§å®¢ã
èŠèгå¯è
ã
éç¹ç®¡ç察象ã
察象å€ã
誰ããéžã°ããŸãã
誰ããèœã¡ãŸãã
ã¢ãã©ã€ã¶ãŒããã¯ãã¢ãã¿ãŒãèŠã€ããªããèšããŸããã
ãSQLãã人éã²åŒãåºã¹åªæãã¹ãSELECTãFROMãWHEREãäœã²ããã³ã«ã©ããã³ãæ¡ä»¶ãåãªåºã¹ã«ããœã¬ãã±ãã¹ãã·ã«ã·ããœãæ¡ä»¶äžãããæ¯æŽãµã¬ã«äººéããèŠèœããµã¬ã«äººéã¬åã«ã¬ãã¹ã
WHEREå¥ã
ããã¯ãããŒã¿ããŒã¹ã®å¿èéšã®äžã€ã§ãã
æ¡ä»¶ãæžãå Žæã§ãã
ã©ã®äººãåãåºããã
ã©ã®äººã察象å€ã«ãããã
ã©ã®äººãåªå
ãããã
ã©ã®äººãåŸåãã«ãããã
WHEREå¥ã¯ã䟿å©ã§ãã
ãããã䟿å©ãªæ¡ä»¶ã¯ããã€ãç¡éªæ°ã§ã¯ãããŸããã
æåŸãããã以äžã
幎霢ãäœæ³ä»¥äžã
äœæããã®å°åã
è·æ¥ããã®åé¡ã
æ¯æããé
ããŠããã
賌å
¥åæ°ãå€ãã
æ¥åºé »åºŠãäœãã
ä¿¡çšã¹ã³ã¢ãäœãã
éå»ã«åãåãããå€ãã
ãªã¹ã¯åºåãé«ãã
ãããã¯ãæ¥åäžã¯å¿ èŠãããããŸããã
ããããæ¡ä»¶ãäœã£ãç¬éã人éã¯éžå¥ãããŸãã
ã¢ãã©ã€ã¶ãŒããã¯èšããŸããã
ãåé¡ãã䟿å©ãã¹ããã¬ãåé¡ããåžžãå±éºãã¹ãæ€çŽ¢æ¡ä»¶ã¬å€ã¯ã¬ããæã¯ã¬ã«äººéããèœããµã¬ã«äººéã¬å€ã¯ãªãã¹ã
ããã§ãã¢ãã©ã€ã¶ãŒããã®å€§éç Žå£å µåšãšããŠã®èšæ¶ãããŸãé¡ãåºããŸãã
ãå µåšã·ã¹ãã ã¢åãžãã¹ãå¯Ÿè±¡ã²æ€åºã¹ã«ãèå¥ã¹ã«ãåªå é äœã²ä»ã±ã«ãæ»æå¯Ÿè±¡ãã¹ã«ã人éãããŒã¿ããŒã¹ã¢ã䌌ã¿å±éºã²æããã€ãã¹ãéã€ããççºé³ã¬èã³ãšã«ã«ãèã³ãšãã€ã«ãã±ãã¹ã
ççºé³ãèãããªãåé¡ã
ããã¯ãçŸä»£ç€ŸäŒã«éåžžã«å€ããããŸãã
審æ»ã«èœã¡ãã
åºåã®å¯Ÿè±¡ã«ãªãã
ä¿éºæãå€ããã
èè³æ¡ä»¶ãå€ããã
æ¡çšåè£ããå€ããã
æ¯æŽå¯Ÿè±¡ããæŒããã
æ€çŽ¢çµæã«åºãŠããªãã
ãããããããªãã
éç¥ãããªãã
èšé²ãããªãã
ããŒã¿ããŒã¹ã®äžã§èœãšããã人éã¯ãèœãšãããããšã«æ°ã¥ããªãããšããããŸãã
ãããæãã®ã§ãã
å°åž³ã®æä»£ã«ã¯ãçªå£ã§æãŸããŸããã
çŽã®æä»£ã«ã¯ãæ
åœè
ã®é¡ããããŸããã
ããŒã¿ããŒã¹ã®æä»£ã«ã¯ãæ¡ä»¶ã§èœã¡ãŸãã
AIã®æä»£ã«ã¯ãäºæž¬ã§èœã¡ãŸãã
ãããŠã誰ãèœãšããã®ãåãããªããªããŸãã
ã¢ãã©ã€ã¶ãŒããã¯ãå€ãAccessã®ãã©ãŒã ãéããå¥ã®ç»é¢ãéããŸããã
ããã«ã¯ãçŸä»£çãªèšèã䞊ãã§ããŸãã
ãã°ã
è¡åå±¥æŽã
賌買履æŽã
äœçœ®æ
å ±ã
ãã€ãã³ããŒã
é»åã«ã«ãã
ä¿¡çšã¹ã³ã¢ã
åºåã¿ãŒã²ãã£ã³ã°ã
ã¬ã³ã¡ã³ãã
AIåŠç¿ããŒã¿ã
ãã¯ãã«ããŒã¿ããŒã¹ã
RAGã
ãããã¡ã€ãªã³ã°ã
ãæãããŒã¿ããŒã¹ãããã®äººã誰ã«ãã²èª¿ããã·ã¿ãä»ãAIããŒã¿ããŒã¹ãããã®äººã次ãäœã²ã¹ã«ã«ãã²äºæž¬ã·ãã¹ã
å°åž³ã¯ã人éãèšé²ããŸããã
ããŒã¿ããŒã¹ã¯ã人éãæ€çŽ¢ããŸããã
AIã¯ã人éãäºæž¬ãå§ããŸããã
ãã®å€åã¯ãéåžžã«å€§ããã
æã®ããŒã¿ããŒã¹ã¯ãéå»ã®èšé²ãæ±ããŸããã
æ°åã
äœæã
賌å
¥å±¥æŽã
æ¯æãå±¥æŽã
蚺çå±¥æŽã
æ¥åºå±¥æŽã
ç³è«å±¥æŽã
ããããAIæä»£ã®ããŒã¿ããŒã¹ã¯ãæªæ¥ãæ±ããŸãã
ãã®äººã¯è²·ããã
ãã®äººã¯èŸãããã
ãã®äººã¯è¿æžãããã
ãã®äººã¯ç
æ°ã«ãªããã
ãã®äººã¯å±éºãã
ãã®äººã¯èª¬åŸãããããã
ãã®äººã¯çäžãããããã
ãã®äººã¯æç¥šã«è¡ããã
ãã®äººã¯å¯Ÿè±¡ã«ãã¹ããã
人éã¯ãèšé²ãããã ãã§ãªããäºæž¬ãããååšã«ãªããŸããã
ã¢ãã©ã€ã¶ãŒããã¯ãåŠã«éããªå£°ã§èšããŸããã
ãäºæž¬ããæªæ¥ãWHEREå¥ãã¹ãããèµ·ããã€ãã€è¡åãæ¡ä»¶ã²ä»ã±ã人éã²å ãåé¡ã¹ã«ããœã¬ã䟿å©ãã¹ããã¬ãéåžžãå±éºãã¹ã
æªæ¥ã®WHEREå¥ã
ããã¯ãèšãåŸãŠåŠã§ããã
ããŒã¿ããŒã¹ã®WHEREå¥ã¯ãéå»ãçŸåšã®æ¡ä»¶ã§äººéãæœåºããŸãã
AIã®äºæž¬ã¯ããŸã èµ·ããŠããªãæªæ¥ã®å¯èœæ§ã§äººéãåé¡ããŸãã
ãã®äººã¯ãå°æ¥ãããªããããããªãã
ãã®äººã¯ããªã¹ã¯ãé«ããããããªãã
ãã®äººã¯ãæ¯æŽãå¿
èŠãããããªãã
ãã®äººã¯ãæ¡çšããªãæ¹ããããããããªãã
ãã®äººã¯ãåºåãåºãã°è²·ããããããªãã
ãã®äººã¯ãç£èŠããæ¹ããããããããªãã
ãããããªãã
ãã®ããããããªããããããŒã¿ããŒã¹ã«å ¥ããšãåŠã«åºããã®ã«ãªããŸãã
äºæž¬ã¹ã³ã¢ã
ãªã¹ã¯å€ã
é¡äŒŒåºŠã
確çã
åªå
é äœã
察象ãã©ã°ã
ãããŠã人éã¯åŠçãããŸãã
ã¢ãã©ã€ã¶ãŒããã¯ãå°ãäžæ©å«ããã«èšããŸããã
ãã¹ã³ã¢ãã䟿å©ãã¹ããã¢ãã¹ã³ã¢ãäººæ Œããã¢ãªãã»ã³ãé¡äŒŒåºŠããéåœããã¢ãªãã»ã³ã確çãã倿±ºããã¢ãªãã»ã³ã
ããã¯ãAIæä»£ã®æ ¹æ¬ã«é¢ããèšèã§ãã
ããŒã¿ããŒã¹ã¯ãäžçãæŽçããŸãã
æŽçããããšã¯å€§åã§ãã
ç
é¢ã§ã¯ãæ£è
æ
å ±ãå¿
èŠã§ãã
éè¡ã§ã¯ãååŒå±¥æŽãå¿
èŠã§ãã
èªæ²»äœã§ã¯ãäœæ°æ
å ±ãå¿
èŠã§ãã
äŒæ¥ã§ã¯ã顧客æ
å ±ãå¿
èŠã§ãã
ç ç©¶ã§ã¯ãããŒã¿ãå¿
èŠã§ãã
ããŒã¿ããŒã¹ããªããã°ãçŸä»£ç€ŸäŒã¯åããŸããã
ããããããŒã¿ããŒã¹ã«å ¥ã£ãç¬éã人éã¯é ç®ã«ãªããŸãã
åã«ãªããŸãã
å€ã«ãªããŸãã
ãã©ã°ã«ãªããŸãã
äž»ããŒã«ãªããŸãã
æ€çŽ¢æ¡ä»¶ã«ãªããŸãã
ããã«ãããŒã¿ããŒã¹ã®æãããããŸãã
ã¢ãã©ã€ã¶ãŒããã¯èšããŸããã
ãããŒã¿ããŒã¹ããäžçã²æŽçã¹ã«ã¿ã¡ãäœã©ã¬ãã·ã¿ãã·ã«ã·ãæŽçãããã€ã¢ãã²äŸå€ãã¹ã«ã³ãããäžçã²çã¯ã·ãã·ããŠã³ãã¬ã¢ãªãã¹ã
äžçãçãããã
ããã¯ãçŽã®å°åž³ã§ã¯èŠãã«ããã£ãåé¡ã§ãã
çŽãªããæ¬å€ã«æžããŸããã
äœçœã«æžããŸããã
èµ€åã§è£è¶³ã§ããŸããã
æ
åœè
ãèŠããŠããŸããã
人éãäºæ
ãèãããšãã§ããŸããã
ãã¡ãããçŽã«ãéçããããŸãã
æ£ææ§ããããŸãã
å±äººæ§ããããŸãã
çŽå€±ããããŸãã
ããããçŽã«ã¯éãéããããŸããã
ããŒã¿ããŒã¹ã¯ãéãéãå«ããŸãã
åã«å
¥ããã
åãæ±ºããã
æ¡æ°ã決ããã
éžæè¢ã決ããã
NULLãèš±ããæ±ºããã
äž»ããŒã決ããã
éè€ãèš±ããæ±ºããã
決ããããšã¯å€§äºã§ãã
ããããæ±ºããç¬éã«ãããŒãã人ãåºãŸãã
ã¢ãã©ã€ã¶ãŒããã¯ãå€ãçºå äŒåç°¿ã®çŽãšãAccessã®ç»é¢ã䞊ã¹ãŠèŠããŸããã
ãçŽãåç°¿ãããäœçœã¬ã¢ãªãã¹ãããŒã¿ããŒã¹ãããäœçœã¬ã¢ãªãã»ã³ãäœçœã²èšèšã·ãã±ã¬ãã人éãäºæ ãå ¥ãªãã»ã³ã
äœçœãèšèšããã
ããã¯ãããŒã¿ããŒã¹èšèšã«ãããå«çãªã®ãããããŸããã
äŸå€ãã©ãæ±ããã
倿Žå±¥æŽãã©ãæ®ããã
æ¬äººãèšæ£ã§ãããã
éç§°åãæ±ãããã
éå»ããŒã¿ãæ®ããã
åé€è«æ±ã«å¿ãããã
æ€çŽ¢æ¡ä»¶ã説æã§ãããã
誰ãã¢ã¯ã»ã¹ããããèšé²ãããã
誰ãWHEREå¥ãæžãããã远ãããã
ããŒã¿ããŒã¹ã¯äŸ¿å©ã§ãã
ãããã䟿å©ãã®è£åŽã«ã¯ãåãããããŸãã
誰ãé
ç®ã決ããã®ãã
誰ãåé¡ãäœã£ãã®ãã
èª°ãæ€çŽ¢æ¡ä»¶ãæžããã®ãã
誰ã察象å€ã«ããã®ãã
誰ãNULLãèš±ããã®ãã
誰ãå±¥æŽãæ¶ããã®ãã
ãããèŠãªããã°ãããŒã¿ããŒã¹ã¯ãã ã®äŸ¿å©ãªç®±ã«ãªããŸãã
ãããŠããã®ç®±ã¯ãšãã«ã人éãèŠããªãããŸãã
ã¢ãã©ã€ã¶ãŒããã¯ããŸã R2-D2åé¡ãå¿ããŠããŸããã§ããã
ãããŒã¿ããŒã¹ããã¯ã¿ã·ãR2-D2ã²ç»é²ã¹ã«ãã©ãèšèšã¬éèŠãã¹ã
ããèšã£ãŠãã¢ãã¿ãŒã«é ç®åã衚瀺ããŸããã
åç§°ã
ç»å Žå¹Žã
圢ç¶ã
æ©èœã
çºè©±èœåã
èéšã
è»èŒªã
ææèŠã
å
¬åŒèšå®ã
ãã¡ã³ãæšå¿µã
èäœæš©äžãå±éºåºŠã
ãç»å Žå¹Žãæ€çŽ¢ã¹ã¬ããã¯ã¿ã·ã¬å ãã¹ã圢ç¶ãæ€çŽ¢ã¹ã¬ããé¡äŒŒãã¹ãå ¬åŒèšå®ãæ€çŽ¢ã¹ã¬ããå¥ç©ãã¹ããã¡ã³ãæšå¿µãæ€çŽ¢ã¹ã¬ããå®å šäžèŽãã¹ã
ãã®åé¡ã¯ãããªãæ£æçã§ããã
ããããæ£æçãªã®ã¯ã¢ãã©ã€ã¶ãŒããã ãã§ã¯ãããŸããã
ç§ãã¡ã®ç€ŸäŒãäœã£ãŠããããŒã¿ããŒã¹ããŸããé ç®ã®ç«ãŠæ¹äžã€ã§ã人éã®èŠãæ¹ãå€ããŠããŸããã
æ§å¥ã
幎霢ã
äœæã
æåŸã
è·æ¥ã
åŠæŽã
ç
æŽã
ä¿¡çšæ
å ±ã
賌買履æŽã
æ€çޢ履æŽã
æç¥šåŸåã
ãªã¹ã¯åºåã
察象å€ã
é ç®ãäœãããšã¯ãäžçãåãããšã§ãã
æ€çŽ¢æ¡ä»¶ãäœãããšã¯ã誰ãèŠã€ãã誰ãèŠèœãšãããæ±ºããããšã§ãã
ã¢ãã©ã€ã¶ãŒããã¯ãå°ãã ãæ©å«ãçŽããããã«èšããŸããã
ãR2-D2åé¡ããåŸäžãæŽå²å®¶ãä»»ã»ãã¹ããã¢ãWHEREå¥ããä»ã¹ã°èŠã»ãã¯ããµã€ã
æåŸã«ãã¢ãã©ã€ã¶ãŒããã¯ãå€ãSQLå ¥éæžãéããŸããã
衚çŽã®ç«¯ã¯æŠãåããŠããŸãã
ããã©ããã®æ¬ã®äžã«ã¯ãçŸä»£ç€ŸäŒãåãããŠããåªæãããã€ãç ã£ãŠããŸããã
SELECTã
FROMã
WHEREã
JOINã
NULLã
PRIMARY KEYã
ORDER BYã
GROUP BYã
ã©ããããã ã®æè¡çšèªã§ãã
ããã©ããããã人éã«åãããããšããæå³ã¯å€ãããŸãã
誰ãéžã¶ã®ãã
誰ãçµã³ã€ããã®ãã
誰ãNULLã«ããã®ãã
誰ãäž»ããŒã§äžæã«ããã®ãã
誰ã䞊ã¹ãã®ãã
誰ãéèšããã®ãã
ããŒã¿ããŒã¹ã¯ãå€ãæè¡ã§ã¯ãããŸããã
ããããAIæä»£ã®å¥¥ã§ããŸããŸãéèŠã«ãªã£ãŠããŸãã
AIãçããããã«ã¯ãããŒã¿ãå¿
èŠã§ãã
AIãæ€çŽ¢ããããã«ã¯ãã€ã³ããã¯ã¹ãå¿
èŠã§ãã
AIãéå»ãåç
§ããããã«ã¯ãèç©ãå¿
èŠã§ãã
AIã人éãäºæž¬ããããã«ã¯ãå±¥æŽãå¿
èŠã§ãã
ãã®æå³ã§ãããŒã¿ããŒã¹ã¯ãAIæä»£ã®å°åž³ã§ãã
ãã ããããã¯çŽã®å°åž³ããã¯ããã«éããåºããæ·±ãã人éãåŒã³åºããŸãã
ãããŠãçŽã®å°åž³ãããéãã«ã人éãèœãšããŸãã
ã¢ãã©ã€ã¶ãŒããã¯ãæåŸã«ããèšããŸããã
ããŸããWHEREå¥ã²èŠã»ãã¯ããµã€ããœã³ãã瀟äŒã¬èª°ã²éžãã誰ã²èœãã·ã¿ã«ã¬æ®ããã€ãã¹ã
第å話ãããŒã¿ããŒã¹ã
ããã¯ãå°åž³ãæ©æ¢°ã«é ãã人éãããããŠèªåèªèº«ãæ€çŽ¢ãããååšã«ããŠãã£ãç©èªã§ãã
ããŒã¿ããŒã¹ã¯ãå€ãæè¡ã§ã¯ãããŸããã
人éãåé¡ããæ€çŽ¢ããæœåºãããããŠAIæä»£ã«ã¯äºæž¬ããããã®åºç€ã§ãã
å°åž³ã¯ã人éãèšé²ããŸããã
ããŒã¿ããŒã¹ã¯ã人éãæ€çŽ¢ããŸããã
AIã¯ã人éãäºæž¬ãå§ããŸããã
ãããŠãå µåšåãããããŒã¿ããŒã¹ã¯ã人éãéžå¥ããæé€ããŸãã
ã ãããããç§ãã¡ã¯åããªããã°ãªããŸããã
誰ãé
ç®ãäœã£ãã®ãã
誰ãåé¡ã決ããã®ãã
èª°ãæ€çŽ¢æ¡ä»¶ãæžããã®ãã
誰ãNULLã«ãããã®ãã
èª°ãæœåºããã誰ãèœãšãããã®ãã
次åã¯ãã¬ã»ã³ã³ã
çŽã«ã«ãã蚺çå ±é ¬ç¹æ°ãã¬ã»ãããè¿æ»ãé»åã«ã«ãããã€ãä¿éºèšŒãå»çãç¹æ°ã«å€ãã人éã®çã¿ãè«æ±ã³ãŒãã«ç¿»èš³ããŠããæ©æ¢°ã蚪ããŸãã
æã»æŠæºå«å€ªé