SQL ServerãOracleãããã³ã¯ã©ãŠãã®ããŒã¿ããŒã¹ ã³ã³ãµã«ãã£ã³ã° ãµãŒãã¹
ç§ãã¡ã®æ倧ã®ã¯ã©ã€ã¢ã³ããšãããžã§ã¯ã
ç§ãã¡ã¯ãå»ç/ãã«ã¹ã±ã¢ãæ³åŸãéèãæ è¡ã補é ãªã©ãå¹ åºãæ¥çš®ã®å€ãã®ã¯ã©ã€ã¢ã³ããšååããŠãããããŸãã¯ååããŠããŸããã
å€åéã«ãããäŒæ¥ãšããŠããã®æ¥åã¯ããµãŒããŒã®ã¢ããã°ã¬ãŒãã移è¡ãããããŒã¿ ãŠã§ã¢ããŠã¹ã®éçºãã«ã¹ã¿ã ã¢ããªã±ãŒã·ã§ã³ã«è³ããŸã§ãããŸããŸãªèœåãåããŠããŸãã
ãµãŒããŒã®ã¢ããã°ã¬ãŒããš DBA ãµãŒãã¹
ããã«ã¯ãSQL Server ã®ããããŒãžã§ã³ããå¥ã®ããŒãžã§ã³ãžããªã³ãã¬ãã¹ããã¯ã©ãŠããžã®ããŒã¿ããŒã¹ã®ãµããŒãçµäºç§»è¡ãçœå®³åŸ©æ§ã®èšå®ããã¹ã ãã©ã¯ãã£ã¹ã®å°å ¥ãªã©ã®ããŒã¿ããŒã¹ç®¡çãµãŒãã¹ãå«ãŸããŸãã
äžéšã®ç§»è¡ã«ã¯çŽæ¥ã®ã¢ããã°ã¬ãŒã ãã¹ããªãå Žåããããããå®è¡ããå¿ èŠãããæé ãèšç»ããå¿ èŠã«å¿ããŠç§»è¡åã«å€æŽãå®è¡ããŠãã¹ãããããšãã§ããŸãã
ã³ã¹ããããããªãããŸãã¯ç€Ÿå ã«ãã«ã¿ã€ã ã® DBA ãå¿ èŠãšããŠããããåªããããŒã¿ ã¬ããã³ã¹ã®å¿ èŠæ§ãèªèããŠããäŒæ¥åãã«ããªã¢ãŒã ããŒã¿ããŒã¹ç®¡çãµãŒãã¹ãå©çšã§ãããªãã·ã§ã³ããããŸãã
NHS ã®ä¿è·ãæ¯æŽ
SQL Server ã®ã»ããã¢ãããšã¡ã³ããã³ã¹ãããŒã¿ ãŠã§ã¢ããŠã¹ã®éçºãšã¬ããŒãäœæãªã©ãæ°å€ãã®ãããžã§ã¯ãã§ã¯ã€ã島 NHS ãšååããŠããŸããã
ææ°ã®ãããžã§ã¯ãã§ã¯ããªã³ãµã€ãããã³ãªããµã€ãã®ããã ã¹ã¿ã³ã〠ãµãŒããŒãšã¬ããŒã ãµãŒããŒã䜿çšããŠããã§ãŒã«ãªãŒã㌠ã¯ã©ã¹ã¿ãŒåããã SQL Server ãã»ããã¢ããããŠããŸãã
ã¢ããªã±ãŒã·ã§ã³ã®ç§»è¡
ãããã¯éåžžã1 ã€ãŸãã¯è€æ°ã®ã¬ã¬ã·ãŒ ã¢ããªã±ãŒã·ã§ã³ã«ä¿åãããŠããããŒã¿ã移è¡ããæ°ããã¢ããªã±ãŒã·ã§ã³ã«ã€ã³ããŒãããããŒã¿ã«å€æãããšãã圢ããšããŸãã
ããã«ã¯ãå€æ°ã®ç°ãªãããŒã¿ããŒã¹ç®¡çã·ã¹ãã ã«ãããäœæ¥ãå«ãŸããå Žåãããã10 以äžã®ç¹å®ã®ããŒã¿ ã»ãããå«ã移è¡ã«åãçµãã§ããŸããã
å¿ èŠã«å¿ããŠããŒã¿ã¯ã¬ã³ãžã³ã°ãé©çšããããšãã§ããã¢ãã¬ã¹ãé»è©±çªå·ãããã³éè€é€å»ãã¯ã¬ã³ãžã³ã°ããããã®ããã«äœ¿çšã§ããé¢æ°ãå€æ°ãããŸãã
æ³çãªææŠ
SQL Server ã Oracle ãªã©ãè€æ°ã®ãœãŒã¹ãšãã©ãããã©ãŒã ã䜿çšãã倧èŠæš¡ãªããŒã¿ããŒã¹ç§»è¡ããã³ã¬ããŒãäœæãããžã§ã¯ãã
ããŒããã¹ããµãŠãµã³ããã³ããªãã¯ã¹ãã©ãŒããã¬ãã£ã³ã°ãã«ãŒãã£ãããã³ãã³ã«ãªãã£ã¹ãæã¡ã1000 人以äžã®ã¹ã¿ãããæãããã®å€§èŠæš¡ãªæ³åŸäºåæã®ã¬ããŒãäœæãšäººäºç®æšã®ç®¡çãè¡ãããã«ãã«ã¹ã¿ãã€ãºããã Web ã¢ããªã±ãŒã·ã§ã³ãäœæãããŸããã
ããŒã¿ ãŠã§ã¢ããŠãžã³ã°ãšçµ±å
å€ãã®äŒæ¥ã¯ãããŒã¿ã®ããŸããŸãªãœãŒã¹ãè€æ°ã®ãã©ãããã©ãŒã ã«ãŸããã£ãŠä¿æããŠããŸããããã¹ãŠã 1 ãæã«ãŸãšããçµéšã¯ãããŸããã
ãã®ããŒã¿ã掻çšããŠãåªå 補å SQL Server ã䜿çšããŠããªã³ãã¬ãã¹ãŸãã¯ã¯ã©ãŠãã®ããããã«åºã¥ããŠéäžåãŠã§ã¢ããŠã¹ãæ§ç¯ã§ããŸãã
å¿ èŠã«å¿ã㊠SQL Server Analysis Services (SSAS) ãªã©ã®è¿œå æ©èœãå©çšããããšãã§ããŸãããäžè¬çã«ããããã¯ã¯ã©ã€ã¢ã³ããå®éã«å¿ èŠãšããŠãããã®ã«å¯ŸããŠéå°ã§ããå¯èœæ§ããããŸãã
ç¶ç¶çãªãµããŒãããå¯èœãªå Žåã¯ç€Ÿå ãŸãã¯å®å šã«ãªã¢ãŒãã§å©çšã§ããŸãã
ããªãã®å»è æ ç»ãšã¡ãã£ã¢
ãã³ãã³ããŠã£ã³ã¶ãŒããã£ã³ãããŒã«ãªãã£ã¹ãšç 究æãæã€ãã®Covid19ãã¹ãäŒç€Ÿã®ããŒã¿ããŒã¹èšèšãšWeb /ã¢ããªã±ãŒã·ã§ã³éçºãå«ãé·æãããžã§ã¯ãã
ã«ã¹ã¿ã Web ã¢ããªã±ãŒã·ã§ã³ã¯ãæ¥ã ã®ããžãã¹æŽ»åã管çããã ãã§ãªããè€æ°ã®ããŒã¿ ãœãŒã¹ããŠãŒã¶ãŒç®¡çãããã³ 2 èŠçŽ èªèšŒãçµ±åããŸãã
ãã®ã«ã¹ã¿ã Web ã¢ããªã±ãŒã·ã§ã³ã¯æé«æ°Žæºã§æ§ç¯ãããŠãããæ¯æ 40,000,000 ãè¶ ãããªã¯ãšã¹ããå®æçã«åŠçããŠããŸãã
å ±åãµãŒãã¹
䞻㫠Microsoft ã¹ã¿ãã¯ã䜿çšããŠãããããã¬ããŒã㯠Power BI ãŸã㯠SQL Server Reporting Services (SSRS) ã§äœæãããã¯ã©ãŠã ããŒã¹ãŸãã¯ãªã³ãã¬ãã¹ã® SQL Server ããŒã¿ããŒã¹ã䜿çšããŸãã
QlikView ã Crystal Reports ãã SSRS ãžã®ç§»è¡ãªã©ãæ°å€ãã®ã¬ããŒã ãã©ãããã©ãŒã ã®ç§»è¡ãæåããŠããŸãã
ãããã®ã¯ã©ã€ã¢ã³ãã®å€§å€æ°ã¯ SQL Server ã䜿çšããŠããããããã®äžéšãšã㊠SSRS ã䜿çšã§ããŸãããã®ã¢ãããŒãã«ããã幎éæ°åãã³ãã®ç¯çŽã«ã€ãªãããŸããã
æ§ç¯åŸã¯ãç¶ç¶çãªã¡ã³ããã³ã¹ãšãµããŒããæäŸããŠãã¬ããŒã ãµãŒãã¹ãææ°ã®ç¶æ ã«ä¿ã€ããšãã§ããŸãã
ã¯ã©ãŠãããŒã¹ã®ã¢ããªã±ãŒã·ã§ã³
æ¯æããšã¢ã³ã±ãŒããåãããã®ã«ã¹ã¿ã ã¢ããªã±ãŒã·ã§ã³ã
Claytabase ããŸãšãããã®ã¯çŽ æŽãããã§ããé£çµ¡ããããã³ã«å¹ççãªå¯Ÿå¿ã Claytabase ã¯ãèŠä»¶ãæºããã ãã§ãªããå°æ¥ã®æé·ã«å¯Ÿå¿ã§ããæŠç¥çãªææ¡ãæäŸããŠãããŸããã
ã²ãŠãã§ãã - 2019
ããŒã¿ ãŠã§ã¢ããŠãžã³ã°
ã«ã¹ã¿ã éçº
ããå°ãå®è³ªçãªãã®ãå¿ èŠã§ããïŒ
å€ãã®ããŒã¿ç®¡çãœãªã¥ãŒã·ã§ã³ã«åãçµãã§ããã®ã§ãWeb ããã³ããŒã¿ããŒã¹éçºã®ç¥èã䜿çšããŠãäœãã«ã¹ã¿ã ãªãã®ãé 眮ã§ããŸãã
以åã®ãããžã§ã¯ããé¢äžããŠããŸãã
- åŸæ¥å¡ç®¡ç
- ããŒã 管ç
- ç®æšç®¡ç
- 決æžã·ã¹ãã
- è«æ±æžç®¡ç
- ã«ã¹ã¿ã ã¡ãŒã«
- SMSçæïŒWebããŒãžãžã®ãªã³ã¯ïŒ
- ããžãã¹çšéãžã® Web API ã®çµ±å
ãããã®ãããžã§ã¯ãã¯ãã¹ãŠãå·¥æ°ã®åæžãåå ¥æºã®è¿œå ãéããŠãããªãã®æè³åççãéæããŠããŸãã
ããŒã¿ã¯ããµã€ããã¯ã©ãŠãããŸãã¯åœç€Ÿã§ãã¹ãã§ããŸããè¿ éãªå±éãšéçºãå¿ èŠãªå Žåã¯ãããã«äœ¿çšã§ãããŠãŒã¶ãŒ/ããŒã«ç®¡çæ©èœãåããåœç€Ÿã®ã³ã³ãã³ã管çã·ã¹ãã ãããã¯ããŒã³ãšããŠäœ¿çšã§ããŸãã
ãã®ä»ã®ãã©ãããã©ãŒã
ç§ãã¡ã¯ãSAPãOpenEdge (以å㯠Progress ãšããŠç¥ãããŠãã)ãNoSQLãMySQLãMicrosoft Accessãããã³ããŸããŸãªã¯ã©ãŠãããŒã¹ã®ããŒã¿ ãµãŒãã¹ãå«ããä»ã®å€ãã®ããŒã¿ããŒã¹ ã·ã¹ãã ãšé£æºããŠããŸããããããã®ãœãŒã¹ã®ãããããããŒã¿ ãŠã§ã¢ããŠã¹ãŸãã¯ãããã®ã·ã¹ãã ããã¬ããŒããèšå®ããŸãã
ããŒã¿ãè³¢ãå©çšããããšã§ãããžãã¹ã«åœ¹ç«ãŠãããšãã§ããŸã
1980 幎代ã®ã³ã³ãã¥ãŒã¿ãŒã®æ¹è¯ãšå°ååã«ãããäžçäžã®åŸæ¥å¡ãšããã€ã¹éã§å ±æã§ããããŒã¿éãççºçã«å¢å ããŸããã
ãœãŒã·ã£ã« ã¡ãã£ã¢ ãã©ãããã©ãŒã ãæ€çŽ¢ãšã³ãžã³ã䜿çšããããŠã§ããµã€ãã«ã¢ã¯ã»ã¹ãããATM ãããéãåŒãåºãããã¹ã«ä¹ããé»è©±ãããããæŒé£ãè²·ããªã©ãããŸããŸãªå Žæã§æ¯æ¥äœåãã®æŽ»åèšé²ãäœæããŠããå¯èœæ§ããããŸãããªã¹ãã¯ç¶ããŸãã
ããŒã¿ã¯ç°¡åã«ååŸã§ããŸããããã®æå³ãç解ããããšã¯å¿ ãããç°¡åã§ã¯ãããŸãããæ¥çžŸã奜調ãªäŒæ¥ã¯ããããããã§ã«ãããžã¿ã« ãã©ã³ã¹ãã©ãŒã¡ãŒã·ã§ã³ããåãå ¥ããŠããŒã¿äŒæ¥ã«ãªããæ å ±ã䜿çšããŠç«¶äºäžã®åªäœæ§ãç²åŸããŠããã§ãããã
èªå® ã§ååŸãããããªã³ã©ã€ã³ã§è³Œå ¥ãããã§ããå©çšå¯èœãªããŒã¿ãç解ããããšã¯ãéµäŸ¿çªå·ã IP ã¢ãã¬ã¹ ããŒã¿ãªã©ã®ãªã³ã©ã€ã³ ãœãŒã¹ããããŒã¿ãè³Œå ¥ãããã©ãããéžæããå Žåãšåæ§ã«ãéåžžã«å°é£ãªå ŽåããããŸãã
䜿çšãããã©ãããã©ãŒã ãéžæããããŒã¿ã瀟å ã«çœ®ããã¯ã©ãŠãã«çœ®ããã¯ããã 1 ã€ã®å°é£ãªèª²é¡ã§ããç§ãã¡ã¯äž¡æ¹ã®çµéšãæã£ãŠãããããããã®é·æãšçæã«ã€ããŠèª¬æããããšãã§ããŸãã
ããŒã¿ ããã»ã¹ã®èšå®ãŸãã¯ãªãŒããŒããŒã«ãæ€èšããŠããŠããªãã·ã§ã³ã«ã€ããŠéå ¬åŒã®ãã£ãããåžæããå ŽåããŸãã¯ç§ãã¡ããæäŒãã§ããå Žåã¯ãç¡æã§ãæ°è»œã«ãåãåããããã ããã以äžããèªã¿ãã ããã
ããã€ãã®çµéšã«ç §ãããŠãSQL Server ã®æ¥ä»ã䜿çšããŠãSQL Server ã®ã¡ã³ããã³ã¹ã«é¢ããããã€ãã®èšäºãäœæããŸããã SQL Server é¢æ°ãSQL ããŒã¿ ã¯ã¬ã³ãžã³ã°ãããã³äžçäžã®äŒæ¥ã§ç¬èªã«å®è£ ãããŠããããŸããŸãªããŒã«ã䜿çšããŸãã