1C ã§ã¯ã瀟å
ã®ä»äºãæŽçããããã«ç¬èªã®éçºãåºã䜿çšããŠããŸãã ç¹ã«ã
1C ã§ã¯ 11 人以äžã®åŸæ¥å¡ãææžç®¡çã䜿çšããŠããŸãã ããŒã¿ããŒã¹ã¯ãã§ã«èšå€§ãªãã®ã«ãªã£ãŠããŸã (XNUMX å件ã®ã¬ã³ãŒã)ãããã¯ãããæ éãªç®¡çãšãã匷åãªæ©åšãå¿ èŠã§ããããšãæå³ããŸãã
ç§ãã¡ã®ã·ã¹ãã ãã©ã®ããã«æ©èœããããããŒã¿ããŒã¹ãç¶æãããšãã«ã©ã®ãããªåé¡ãçºçãããããããŠããããã©ã®ããã«è§£æ±ºããã (DBMS ãšã㊠MS SQL Server ã䜿çšããŸã) - èšäºã§èª¬æããŸãã
åã㊠1C 補åã«ã€ããŠèªãæ¹ãžã
1C:Document Flowã¯ãæ¥åã¢ããªã±ãŒã·ã§ã³ãéçºããããã®ãã¬ãŒã ã¯ãŒã¯ã§ãã1C:Enterpriseãã©ãããã©ãŒã ãããŒã¹ã«å®è£
ãããã¢ããªã±ãŒã·ã§ã³ãœãªã¥ãŒã·ã§ã³ïŒæ§æïŒã§ãã
ã1C: Document Flow 8ãïŒDO ãšç¥ç§°ïŒã䜿çšãããšãäŒæ¥å
ã®ããã¥ã¡ã³ãã®æäœãèªååã§ããŸãã åŸæ¥å¡ãšã®ããåãã®ããã®äž»ãªããŒã«ã® XNUMX ã€ã¯é»åã¡ãŒã«ã§ãã ã¡ãŒã«ã«å ããŠãDO ã¯ä»ã®åé¡ã解決ããŸãã
- æé远跡
- åŸæ¥å¡ã®æ¬ å€è¿œè·¡
- å® é 䟿ã»ééæ¥ã®ç³ã蟌ã¿
- åŸæ¥å¡ã®å€åã«ã¬ã³ããŒ
- éä¿¡ã®ç»é²
- åŸæ¥å¡ã®é£çµ¡å (ã¢ãã¬ã¹åž³)
- äŒæ¥ãã©ãŒã©ã
- éšå±ã®äºçŽ
- ã€ãã³ãäŒç»
- CRM
- ãã¡ã€ã«ã®å ±åäœæ¥ (ãã¡ã€ã« ããŒãžã§ã³ã®ä¿å)
- ãã
ææžç®¡çã«å
¥ããŸã
ãããŠãDocument Flow ã«æ¥ç¶ãããä»ã®è£œåã®ãããã§ã
DO ã®æåæ°ã¯ãã§ã« 100 åãè¶ ããŠãããDBMS ã«ã¯äžè¬ã« 11 åãè¶ ããã¬ã³ãŒãããããŸãã åèšã§ãã·ã¹ãã ã¯ã»ãŒ 30 TB ã®ã¹ãã¬ãŒãžã䜿çšããŸããããŒã¿ããŒã¹ ããªã¥ãŒã 㯠7,5 TBãéåäœæ¥çšã®ãã¡ã€ã«ã¯åå¥ã«ä¿åãããããã« 21 TB ãå æããŸãã
ããå ·äœçãªæ°åã«ã€ããŠèšãã°ãçŸæç¹ã§ã®æåæ°ãšãã¡ã€ã«æ°ã¯æ¬¡ã®ãšããã§ãã
- éä¿¡ã¡ãŒã« â 14,7 äžä»¶ã
- åä¿¡æçŽ â 85,4 äžéã
- ãã¡ã€ã«ã®ããŒãžã§ã³ â 70,8 äžã
- å éšææž â 30,6å件ã
DO ã«ã¯ã¡ãŒã«ããã¡ã€ã«ã ãã§ã¯ãããŸããã ãã®ä»ã®äŒèšãªããžã§ã¯ãã®æ°å€ã¯ä»¥äžã®ãšããã§ãã
- äŒè°å®€ã®äºçŽ â 52
- é±æ¬¡ã¬ããŒã â 153
- æ¥æ¬¡ã¬ããŒã â 628
- æ¿èªã㶠â 11
- åä¿¡ããã¥ã¡ã³ã â 79
- éä¿¡ããã¥ã¡ã³ã â 28
- ãŠãŒã¶ãŒã®ä»äºã«ã¬ã³ããŒã®ã€ãã³ãã«é¢ãããšã³ã㪠â 168
- å® é 䟿ã®ç³ã蟌㿠â 21件
- ååŒçžæ â 81
- ååŒçžæãšã®äœæ¥èšé² â 45
- ååŒçžæã®é£çµ¡å æ åœè - 41
- ã€ãã³ã â 10
- ãããžã§ã¯ã â 6
- åŸæ¥å¡ã®ã¿ã¹ã¯ â 245
- ãã©ãŒã©ã ã®æçš¿ â 26
- ãã£ããã¡ãã»ãŒãž â 891 095
- ããžãã¹ ããã»ã¹ - 109ãåŸæ¥å¡éã®ããåãã¯ãæ¿èªãå®è¡ãã¬ãã¥ãŒãç»é²ã眲åãªã©ã®ããã»ã¹ãéããŠçºçããŸãã ããã»ã¹ã®æéããµã€ã¯ã«æ°ãåå è æ°ãè¿åæ°ãæéå€æŽãªã¯ãšã¹ãã®æ°ã枬å®ããŸãã ãããŠããã®æ å ±ã¯ãäŒæ¥å ã§ã©ã®ãããªããã»ã¹ãè¡ãããŠããããç解ããåŸæ¥å¡ã®ã³ã©ãã¬ãŒã·ã§ã³ã®å¹çãé«ããããã«åæããã®ã«éåžžã«åœ¹ç«ã¡ãŸãã
ããããã¹ãŠãã©ã®ãããªè£ 眮ã§åŠçããã®ã§ãããã?
ãããã®æ°åã¯ãèšå€§ãªéã®ã¿ã¹ã¯ã瀺ããŠããããã瀟å
åäŒç€Ÿã®ããŒãºã«åãããŠããªãçç£æ§ã®é«ãèšåãå²ãåœãŠãå¿
èŠã«çŽé¢ããŸããã çŸåšããã®ç¹åŸŽã¯æ¬¡ã®ãšããã§ã: 38 ã³ã¢ã240 GB ã® RAMã26 TB ã®ãã£ã¹ã¯ã ãµãŒããŒã®è¡šã¯æ¬¡ã®ãšããã§ãã
ä»åŸãèšåã®å®¹éãå¢ãããŠããäºå®ã§ãã
ãµãŒããŒã®è² è·ã¯ã©ããªã£ãŠããŸãã?
ãããã¯ãŒã¯æŽ»åãåœç€Ÿãã客æ§ã«ãšã£ãŠåé¡ã«ãªã£ãããšã¯äžåºŠããããŸããã ã¡ã¢ãªäžè¶³ã«å¯ŸåŠããæ¹æ³ã¯èª°ãããã§ã«ç¥ã£ãŠãããããååãšããŠã匱ç¹ã¯ããã»ããµãšãã£ã¹ã¯ã§ãã 以äžã¯ãªãœãŒã¹ ã¢ãã¿ãŒããã®ãµãŒããŒã®ã¹ã¯ãªãŒã³ã·ã§ããã§ããã²ã©ãè² è·ã¯ãªããéåžžã«æ§ããã§ããããšãããããŸãã
ããšãã°ã以äžã®ã¹ã¯ãªãŒã³ã·ã§ããã§ã¯ãCPU è² è·ã 23% ã§ãã SQL ãµãŒããŒã瀺ãããŠããŸãã ããã¯éåžžã«åªããææšã§ã (æ¯èŒã®ããã«ãè² è·ã 70% ã«è¿ã¥ããšãåŸæ¥å¡ã®äœæ¥ã¯ããªãå€§å¹ ã«é ããªãå¯èœæ§ãé«ããªããŸã)ã
1 çªç®ã®ã¹ã¯ãªãŒã³ã·ã§ããã¯ã38C:Enterprise ãã©ãããã©ãŒã ãå®è¡ãããã¢ããªã±ãŒã·ã§ã³ ãµãŒããŒã瀺ããŠããŸããããã¯ãŠãŒã¶ãŒ ã»ãã·ã§ã³ã®ã¿ãæäŸããŸãã ããã§ã¯ãããã»ããµã®è² è·ã¯ãããã«é«ããXNUMXïŒ
ã§ãããã¹ã ãŒãºã§ç©ããã§ãã ãã£ã¹ã¯ã®èªã¿èŸŒã¿ãå€å°ãããŸããã蚱容ç¯å²ã§ãã
1 çªç®ã®ã¹ã¯ãªãŒã³ã·ã§ããã¯ãå¥ã® 90C:Enterprise ãµãŒããŒã瀺ããŠããŸã (ãã㯠100 çªç®ã§ãã¯ã©ã¹ã¿ãŒå
ã« 88 å°ãããŸã)ã åã®ãã®ã ãããŠãŒã¶ãŒã«ãµãŒãã¹ãæäŸããããããããã®ãã®ãåŠçããŸãã ããšãã°ãã¡ãŒã«ã®åä¿¡ãææžã®è»¢éãããŒã¿ã®äº€æãæš©å©ã®èšç®ãªã©ãè¡ããŸãã ããããã¹ãŠã®ããã¯ã°ã©ãŠã³ã ã¢ã¯ãã£ããã£ã¯ãçŽ XNUMX ïœ XNUMX ã®ããã¯ã°ã©ãŠã³ã ãžã§ããå®è¡ããŸãã ãããŠããã®ãµãŒããŒã®è² è·ã¯ XNUMX% ãšéåžžã«é«ããªã£ãŠããŸãã ããããããã¯äººã«ã¯åœ±é¿ãäžãããããã¥ã¡ã³ã管çãè¡ãã¹ããã¹ãŠã®èªååãæ£ç¢ºã«å®è£
ããŸãã
ããã©ãŒãã³ã¹ã枬å®ããææšã¯äœã§ãã?
åœç€Ÿã®åäŒç€Ÿã«ã¯ãããã©ãŒãã³ã¹ææšã枬å®ããããŸããŸãªææšãèšç®ããããã®æ¬æ Œçãªãµãã·ã¹ãã ãçµã¿èŸŒãŸããŠããŸãã ããã¯ãçŸæç¹ããã³æŽå²çãªèŠ³ç¹ãããã·ã¹ãã ã§äœãèµ·ãã£ãŠããã®ããäœãæªåããŠããã®ããäœãæ¹åããŠããã®ããç解ããããã«å¿ èŠã§ãã ç£èŠããŒã« (ã¡ããªã¯ã¹ãšæé枬å®) ã¯ãã1C: Document Flow 8ãã®æšæºæäŸã«å«ãŸããŠããŸãã ã¡ããªã¯ã¹ã¯å®è£ æã«ã«ã¹ã¿ãã€ãºãå¿ èŠã§ãããã¡ã«ããºã èªäœã¯æšæºã§ãã
ã¡ããªã¯ã¹ã¯ãç¹å®ã®æç¹ã§ã®ããŸããŸãªããžãã¹ææšã®æž¬å®å€ã§ã (ããšãã°ãã¡ãŒã«ã®å¹³åé ä¿¡æé㯠10 åã§ã)ã
ã¡ããªã¯ã¹ã® 1000 ã€ã¯ãããŒã¿ããŒã¹å ã®ã¢ã¯ãã£ã ãŠãŒã¶ãŒã®æ°ã瀺ããŸãã å¹³åãããšã1400 æ¥äžã« 2144 ïœ XNUMX åååšããŸãã ã°ã©ãã¯ãã¹ã¯ãªãŒã³ã·ã§ããã®æç¹ã§ããŒã¿ããŒã¹å ã« XNUMX 人ã®ã¢ã¯ãã£ã ãŠãŒã¶ãŒãããããšã瀺ããŠããŸãã
ãã®ãããªè¡çºã¯ 30 件以äžããããªã¹ãã¯ãŸã æªå
¬éã§ãããªã¹ã
- ãã°ã€ã³
- ãµã€ã³ã¢ãŠã
- ã¡ãŒã«ãèªã¿èŸŒã¿äž
- ãªããžã§ã¯ãã®æå¹æ§ã®å€æŽ
- ã¢ã¯ã»ã¹æš©ã®å€æŽ
- ããã»ã¹ã®äž»é¡ãå€æŽãã
- ãªããžã§ã¯ãã®ã¯ãŒã¯ã°ã«ãŒãã®å€æŽ
- ãããã®æ§æãå€æŽãã
- ãã¡ã€ã«ã®å€æŽ
- ãã¡ã€ã«ã®ã€ã³ããŒã
- ã¡ãŒã«ã§éã
- ãã¡ã€ã«ã®ç§»å
- ã¿ã¹ã¯ã®ãªãã€ã¬ã¯ã
- é»å眲åã«çœ²åãã
- 詳现ããæ¢ã
- å šææ€çŽ¢
- ãã¡ã€ã«ãåä¿¡ãã
- ããã»ã¹ã®äžæ
- éè³
- 埩å·å
- ææžç»é²
- ã¹ãã£ã³
- åé€ã®ããŒã¯ãå€ã
- ãªããžã§ã¯ãã®äœæ
- ãã£ã¹ã¯ãžã®ä¿å
- ããã»ã¹ã®éå§
- ãŠãŒã¶ãŒãã°ãšã³ããªã®åé€
- é»å眲åã®åé€
- åé€ããŒã¯ãèšå®ãã
- æå·å
- ãã©ã«ããŒããšã¯ã¹ããŒããã
å ã é±ãåœç€Ÿã®å¹³åãŠãŒã¶ãŒ ã¢ã¯ãã£ããã£ã¯ 3 åã«å¢å ããŸãã (ã°ã©ãã®èµ€ã§ç€ºãããŠããŸã)ãããã¯ãã»ãšãã©ã®åŸæ¥å¡ã (ããç¥ãããã€ãã³ãã®ãã) ãªã¢ãŒãã¯ãŒã¯ã«ç§»è¡ããããã§ãã ãŸããåŸæ¥å¡ãæºåž¯é»è©±ãç©æ¥µçã«äœ¿çšãå§ãããããã¢ã¯ãã£ã ãŠãŒã¶ãŒã®æ°ã¯ 2 åã«å¢å ããŸãã (ã¹ã¯ãªãŒã³ã·ã§ããã§ã¯éè²ã§è¡šç€º)ãåã¢ãã€ã« ã¯ã©ã€ã¢ã³ãã¯ãµãŒããŒãžã®æ¥ç¶ãäœæããŸãã çŸåšãå¹³åããŠååŸæ¥å¡ã¯ãµãŒããŒã« XNUMX ã€ã®æ¥ç¶ãæã£ãŠããŸãã
ç§ãã¡ç®¡çè
ã«ãšã£ãŠãããã¯ããã©ãŒãã³ã¹ã®åé¡ã«ãã£ãšæ³šæãæããç¶æ³ãæªåããŠããªããã©ããã確èªããå¿
èŠããããšããåå³ã§ãã ãããããããä»ã®ãã©ã¡ãŒã¿ã«åºã¥ããŠæ€èšããŸãã ããšãã°ãå
éšã«ãŒãã£ã³ã°ã®ã¡ãŒã«é
ä¿¡æéãã©ã®ããã«å€åããã (äžã®ã¹ã¯ãªãŒã³ã·ã§ããã§ã¯éã§ç€ºãããŠããŸã)ã ä»å¹ŽãŸã§ã¯å€åããŠããŸããããçŸåšã¯å®å®ããŠããŸããç§ãã¡ã«ãšã£ãŠãããã¯ã·ã¹ãã ããã¹ãŠé 調ã§ããããšã瀺ãææšã§ãã
ç§ãã¡ã«é©çšããããã XNUMX ã€ã®ææšã¯ãã¡ãŒã« ãµãŒããŒããã¬ã¿ãŒãããŠã³ããŒããããšãã®å¹³ååŸ
ã¡æéã§ã (ã¹ã¯ãªãŒã³ã·ã§ããã§ã¯èµ€ã§è¡šç€ºãããŠããŸã)ã 倧ãŸãã«èšãã°ããã®æçŽãåŸæ¥å¡ã«å±ããŸã§ã«ã©ããããã®æéã€ã³ã¿ãŒãããäžã«æŒæµããããšã«ãªãã§ããããã ã¹ã¯ãªãŒã³ã·ã§ãããèŠããšãä»åãæè¿ãšäœãå€ãã£ãŠããªãããšãããããŸãã åå¥ã®ã¹ãã€ã¯ããããŸããããããã¯é
延ã«é¢é£ããŠããã®ã§ã¯ãªããã¡ãŒã« ãµãŒããŒã§ã®æéã倱ãããŠãããšããäºå®ã«é¢é£ããŠããŸãã
ãŸãã¯ãããšãã°ããã©ã«ããŒå
ã®æåã®æŽæ°ãšããå¥ã®ææš (ã¹ã¯ãªãŒã³ã·ã§ããã§ã¯éã§è¡šç€º) ãèããããŸãã ã¡ãŒã« ãã©ã«ããŒãéãã®ã¯éåžžã«äžè¬çãªæäœã§ãããè¿
éã«è¡ãå¿
èŠããããŸãã ãããã©ãã ãéãå®è¡ããããã枬å®ããŸãã ãã®ææšã¯ã¯ã©ã€ã¢ã³ãããšã«æž¬å®ãããŸãã äŒç€Ÿã®å
šäœåãšãããšãã°åã
ã®åŸæ¥å¡ã®ãã€ããã¯ã¹ã®äž¡æ¹ã確èªã§ããŸãã ã¹ã¯ãªãŒã³ã·ã§ããã¯ãä»å¹ŽãŸã§ææšã®ãã©ã³ã¹ã厩ããŠããããšã瀺ããŠããŸãããã®åŸãããã€ãã®æ¹åãå ããŸããããçŸåšã¯æªåããŠããããã°ã©ãã¯ã»ãŒå¹³åŠã«ãªã£ãŠããŸãã
ã¡ããªã¯ã¹ã¯åºæ¬çã«ãã·ã¹ãã ãç£èŠããã·ã¹ãã ã®åäœã®å€åã«è¿
éã«å¯Ÿå¿ããããã®ç®¡çè
çšããŒã«ã§ãã ã¹ã¯ãªãŒã³ã·ã§ããã¯ããã®å¹Žã®ç€Ÿå
åäŒç€Ÿã®ææšã瀺ããŠããŸãã ã°ã©ããæ¥äžæããŠããã®ã¯ã瀟å
åäŒç€Ÿã®è²æãšãã課é¡ãäžããããããšã«ãããã®ã§ãã
以äžã«ããã®ä»ã®ææšã®ãªã¹ãã瀺ããŸã (æç²)ã
ã¡ããªã¯ã¹
- ãŠãŒã¶ãŒã¢ã¯ãã£ããã£
- ã¢ã¯ãã£ã ãŠãŒã¶ãŒ
- ã¢ã¯ãã£ããªããã»ã¹
- ãã¡ã€ã«æ°
- ãã¡ã€ã«ãµã€ãº(MB)
- ææžã®æ°
- åä¿¡è ã«éä¿¡ããããªããžã§ã¯ãã®æ°
- ååŒçžæã®æ°
- æªå®äºã®ã¿ã¹ã¯
- éå» 10 åéã®ã¡ãŒã« ãµãŒããŒããã®ã¡ãŒã«ã®ããŠã³ããŒãã®å¹³ååŸ ã¡æé
- å€éšããŒã¿ãããã¡: ãã¡ã€ã«æ°
- çŸåšã®æ¥ä»ããã®é è¡å¢çç·
- é·èã®å
- æäœãã¥ãŒ
- å€éšã«ãŒãã£ã³ã°ã«ããçã®ã¢ã«ãŠã³ãã®çµéæé
- å éšã«ãŒãã£ã³ã°åä»ãã¥ãŒãµã€ãºïŒãã³ã°ãã¥ãŒïŒ
- å éšã«ãŒãã£ã³ã°åä»ãã¥ãŒãµã€ãºïŒé«éãã¥ãŒïŒ
- å éšã«ãŒãã£ã³ã°ã«ããã¡ãŒã«é ä¿¡æé (é·ããã¥ãŒ)
- å éšã«ãŒãã£ã³ã° (é«éãã¥ãŒ) ã«ããã¡ãŒã«é ä¿¡æé
- å€éšã«ãŒãã£ã³ã°ã«ããã¡ãŒã«é ä¿¡æéïŒå¹³åïŒ
- æžé¡ææ° äºçŽ
- æžé¡æ° æ¬ åž
- ææžæ°ãååŒå ãšã®äœæ¥èšé²ã
- ã¡ãŒã« ãã©ã«ããŒå ã®ã¬ã¿ãŒãæŽæ°ãã
- ã¡ãŒã« ã¬ã¿ãŒã«ãŒããéã
- ã¡ãŒã« ã¬ã¿ãŒããã©ã«ããŒã«è»¢éãã
- ã¡ãŒã« ãã©ã«ãéã®ç§»å
åœç€Ÿã®ã·ã¹ãã 㯠150 以äžã®ææšã XNUMX æé枬å®ããŠããŸããããã®ãã¹ãŠãããã«ç£èŠã§ããããã§ã¯ãããŸããã ãããã¯ãæŽå²çãªèŠ³ç¹ããåŸã§åœ¹ç«ã€å¯èœæ§ããããããžãã¹ã«ãšã£ãŠæãéèŠãªãã®ã«éäžã§ããŸãã
ããšãã°ãå®è£ ã® 5 ã€ã§ã¯ã150 ã€ã®ã€ã³ãžã±ãŒã¿ãŒã®ã¿ãéžæãããŸããã ã客æ§ã¯ãæå°éã®ææšã»ãããäœæãããšããç®æšãèšå®ããŸããããåæã«äž»èŠãªäœæ¥ã·ããªãªãã«ããŒã§ããããã«ããŸããã äŒæ¥å ã§ãã£ãŠããã©ã®ææšã蚱容ããããšèãããããã«ã€ããŠåæããããšã¯å°é£ã§ãããããåæ ŒèšŒææžã« 5 ã®ææšãå«ããããšã¯äžåœã§ãã ãããŠã圌ãã¯ããã 3 ã€ã®ææšã«ã€ããŠç¥ã£ãŠãããå®è£ ãããžã§ã¯ãã®éå§åã«æ¢ã«ã·ã¹ãã ã«æ瀺ããŠããããããã¯ç«¶æææžã«å«ãŸããŠããŸãããã«ãŒããéãæé㯠5 ç§ä»¥å ããã¡ã€ã«ã䜿çšããŠã¿ã¹ã¯ãå®äºããæé㯠XNUMX ç§ä»¥å ã§ãã XNUMXç§ä»¥äžãªã©ã ç§ãã¡ã®åäŒç€Ÿã§ã¯ã顧客ã®æè¡ä»æ§ããã®å ã®èŠæ±ãéåžžã«æ確ã«åæ ããææšãæã£ãŠããŸããã
ããã©ãŒãã³ã¹æž¬å®ã®ãããã¡ã€ã«åæããããŸãã ããã©ãŒãã³ã¹ææšã¯ãé²è¡äžã®åæäœ (ããŒã¿ããŒã¹ãžã®ã¬ã¿ãŒã®æžã蟌ã¿ãã¡ãŒã« ãµãŒããŒãžã®ã¬ã¿ãŒã®éä¿¡ãªã©) ã®ç¶ç¶æéãèšé²ããŸãã ããã¯æè¡è ã®ã¿ã䜿çšããŸãã ç§ãã¡ã®ããã°ã©ã ã«ã¯å€ãã®ããã©ãŒãã³ã¹ææšãèç©ãããŠããŸãã çŸåšãçŽ 1500 ã®äž»èŠãªæäœã枬å®ããŠããããããã¯ãããã¡ã€ã«ã«åå²ãããŠããŸãã
ç§ãã¡ã«ãšã£ãŠæãéèŠãªãããã¡ã€ã«ã® XNUMX ã€ã¯ããæ¶è²»è
ã®èŠ³ç¹ããèŠãã¡ãŒã«ã®äž»èŠææšã®ãªã¹ããã§ãã ãã®ãããã¡ã€ã«ã«ã¯ãããšãã°æ¬¡ã®ææšãå«ãŸããŸãã
- ã³ãã³ãå®è¡ïŒã¿ã°ã§éžæ
- ãã©ãŒã ãéã: ãªã¹ããã©ãŒã
- ã³ãã³ãå®è¡ïŒãã©ã«ãã§éžæ
- èªã¿åããšãªã¢ã«æåã衚瀺ãã
- æçŽããæ°ã«å ¥ãã®ãã©ã«ããŒã«ä¿åãã
- 詳现ããæåãæ€çŽ¢ãã
- æçŽãäœæãã
äœããã®ããžãã¹ææšã®ææšã倧ãããªããããŠããããšãããããšïŒããšãã°ãç¹å®ã®ãŠãŒã¶ãŒããã®æçŽãéåžžã«é·ãéå±ãå§ããŠãããªã©ïŒãç§ãã¡ã¯ãããææ¡ãå§ããæè¡çãªæäœã®æéã®æž¬å®ã«ç§»ããŸãã ãã¡ãŒã« ãµãŒããŒã§ã®ã¬ã¿ãŒã®ã¢ãŒã«ã€ãããšããæè¡çãªæäœããããŸãããã®æäœã®æéããæåŸã®æéã§è¶ éããŠããããšãããããŸãã ãã®æäœã¯ãããšãã°ã¡ãŒã« ãµãŒããŒãšã®æ¥ç¶ã®ç¢ºç«ãªã©ãä»ã®æäœã«å解ãããŸãã äœããã®çç±ã§ãçªç¶éåžžã«å€§ãããªã£ãããšãããããŸã (10 ãæéãã¹ãŠã®æž¬å®å€ãåŸãããŠããŸããå é±ã¯ 1000 ããªç§ã§ããããçŸåšã¯ XNUMX ããªç§ã§ãããšæ¯èŒã§ããŸã)ã ãããŠãããã§äœããå£ããŠããããšãç解ããŠããŸã - ãããä¿®æ£ããå¿ èŠããããŸãã
ãã®ãããªå€§èŠæš¡ãªããŒã¿ããŒã¹ãã©ã®ããã«ç¶æããã®ã§ãããã?
åœç€Ÿã®ç€Ÿå DO ã¯ãå®éã«æ©èœããé«è² è·ãããžã§ã¯ãã®äžäŸã§ãã ãã®ããŒã¿ããŒã¹ã®æè¡çç¹åŸŽã«ã€ããŠè©±ããŸãããã
倧èŠæš¡ãªããŒã¿ããŒã¹ããŒãã«ãåæ§ç¯ããã«ã¯ã©ã®ãããæéãããããŸãã?
SQL ãµãŒããŒã¯ãããŒãã«ãæŽçããããã®å®æçãªã¡ã³ããã³ã¹ãå¿ èŠã§ãã è¯ãæå³ã§ãããã¯å°ãªããšã 11 æ¥ã« XNUMX åå®è¡ããå¿ èŠããããéèŠã®é«ãããŒãã«ã®å Žåã¯ããã«é »ç¹ã«å®è¡ããå¿ èŠããããŸãã ããããããŒã¿ããŒã¹ã倧èŠæš¡ãªå Žå (ã¬ã³ãŒãæ°ããã§ã« XNUMX åãè¶ ããŠããå Žå)ãããŒã¿ããŒã¹ã®ç®¡çã¯ç°¡åã§ã¯ãããŸããã
6 幎åã«ããŒãã«ã®åæ§ç¯ãè¡ããŸããããæéãããããããŠæ¯æ©ã®ééã«åãŸããªããªããŸããã ãŸãããããã®æäœã¯ SQL ãµãŒããŒã«å€§ããªè² è·ãããããããä»ã®ãŠãŒã¶ãŒã«å¹ççã«ãµãŒãã¹ãæäŸããããšãã§ããŸããã
ãããã£ãŠãçŸåšã¯ããŸããŸãªããªãã¯ã䜿çšããå¿ èŠããããŸãã ããšãã°ãå®å šãªããŒã¿ã»ããã«å¯ŸããŠãããã®æé ãå®è¡ããããšã¯ã§ããŸããã ããµã³ãã« 500000 è¡ãæŽæ°ãããæé ã«é Œãå¿ èŠããããŸããããã«ã¯ 14 åããããŸãã ããŒãã«å ã®ãã¹ãŠã®ããŒã¿ã®çµ±èšãæŽæ°ããã®ã§ã¯ãªããXNUMX äžè¡ãéžæãããããã䜿çšããŠããŒãã«å šäœã«äœ¿çšããçµ±èšãèšç®ããŸãã ããã¯ããçšåºŠã®ä»®å®ã§ãããç¹å®ã®ããŒãã«ã«ã€ã㊠XNUMX å件ã®ã¬ã³ãŒãå šäœã®çµ±èšãåéããã«ã¯èš±å®¹ã§ããªãã»ã©é·ãæéãããããããããããããåŸãŸããã
ãã®ä»ã®ã¡ã³ããã³ã¹æäœãéšåçã«æé©åããŸããã
DBMS ã®ä¿å®ã¯äžè¬ã«è€éãªã¿ã¹ã¯ã§ãã åŸæ¥å¡éã®æŽ»çºãªããåãã®å ŽåãããŒã¿ããŒã¹ã¯æ¥éã«å¢å€§ãã管çè ãçµ±èšã®æŽæ°ãããã©ã°ãã€ã³ããã¯ã¹äœæãªã©ããŒã¿ããŒã¹ãç¶æããããšããŸããŸãå°é£ã«ãªããŸãã ããã§ã¯ããŸããŸãªæŠç¥ãé©çšããå¿ èŠããããŸãããç§ãã¡ã¯ãããè¡ãæ¹æ³ãããç¥ã£ãŠãããçµéšãããããããå ±æããããšãã§ããŸãã
ãã®ãããªããªã¥ãŒã ã§ã¯ããã¯ã¢ããã¯ã©ã®ããã«å®è£ ãããŸãã?
DBMS ã®å®å šããã¯ã¢ãã㯠XNUMX æ¥ XNUMX åå€éã«å®è¡ãããå¢åããã¯ã¢ãã㯠XNUMX æéããšã«å®è¡ãããŸãã ãŸãããã¡ã€ã« ãã£ã¬ã¯ããªã¯æ¯æ¥äœæããããã¡ã€ã« ã¹ãã¬ãŒãžã®å¢åããã¯ã¢ããã®äžéšãšãªããŸãã
å®å šããã¯ã¢ãããå®äºãããŸã§ã«ã©ããããæéãããããŸãã?
ããŒã ãã©ã€ããžã®å®å šããã¯ã¢ãã㯠20 æéã§å®äºããéšåããã¯ã¢ãã㯠XNUMX æéã§å®äºããŸãã ããŒã (ãªãã£ã¹ã®å€ã«ä¿ç®¡ãããŠããç¹å¥ãªã«ã»ããã«ããã¯ã¢ãã ã³ããŒãäœæããç¹å¥ãªè£ 眮ã転éå¯èœãªã³ããŒãããŒãã«äœæããããµãŒã㌠ã«ãŒã ãçŒå€±ããå Žåãªã©ã«ä¿åãããŸã) ãžã®æžã蟌ã¿ã«ã¯æéãããããŸãã ããã¯ã¢ããã¯ãŸã£ããåããµãŒããŒäžã§äœæãããŸããããã®ãã©ã¡ãŒã¿ãŒã¯ããé«ããããã»ããµãŒè² è·ã XNUMX% ã® SQL ãµãŒããŒã§ãã ãã¡ãããããã¯ã¢ããæã«ã¯ã·ã¹ãã ã¯å€§å¹ ã«æªåããŸããããŸã æ©èœããŠããŸãã
éè€æé€ã¯ãããŸãã?
èªã¿åãå°çšããŒãã¯ãããŸãã?
èªã¿åãããŒã (èªã¿åãçšã®ããŒã¿ãåä¿¡ããå¿ èŠããããŠãŒã¶ãŒã«ãµãŒãã¹ãæäŸããå°çšã®ã·ã¹ãã ããŒã) ã¯ãããŸããã DO ã¯å¥ã® BI ããŒãã«çœ®ãäŒèšã·ã¹ãã ã§ã¯ãããŸããããéçºéšéçšã«å¥ã®ããŒãããããJSON 圢åŒã§ã¡ãã»ãŒãžã亀æãããéåžžã®ã¬ããªã±ãŒã·ã§ã³æéã¯åäœæ°åç§ã§ãã ãã®ããŒãã¯ãŸã å°ãããã¬ã³ãŒãæ°ã¯çŽ 800 å件ã§ãããæ¥éã«æé·ããŠããŸãã
åé€å¯Ÿè±¡ãšããŠããŒã¯ãããã¡ãŒã«ã¯ãŸã£ããåé€ãããªãã®ã§ãããã?
ãŸã ã ããŒã¹ã軜ããããšãã課é¡ã¯ãããŸããã 2009 幎ãå«ããåé€å¯Ÿè±¡ã®æåã«èšåããå¿ èŠãããããªãæ·±å»ãªã±ãŒã¹ãããã€ããããŸããã ãã®ãããä»ã®ãšãããã¹ãŠãä¿åããããšã«ããŸããã ãããããã®ã³ã¹ããäžåœã«ãªã£ãå Žåã«ã¯ãæ€å»ãæ€èšããããšã«ãªããŸãã ãã ããçè·¡ãæ®ããªãããã«ããŒã¿ããŒã¹ããå¥ã®æåãå®å šã«åé€ããå¿ èŠãããå Žåã¯ãç¹å¥ãªãªã¯ãšã¹ãã«ãã£ãŠãããè¡ãããšãã§ããŸãã
ãªãä¿ç®¡ããã®ã§ãã? å€ãææžãžã®ã¢ã¯ã»ã¹ã«é¢ããçµ±èšã¯ãããŸãã?
çµ±èšã¯ãããŸããã ããæ£ç¢ºã«ã¯ãããã¯ãŠãŒã¶ãŒ ãã°ã®åœ¢åŒã§ãããé·æéä¿åããããã®ã§ã¯ãããŸããã XNUMX 幎以äžåã®ãšã³ããªã¯ãããã³ã«ããåé€ãããŸãã
XNUMX 幎åãããã«ã¯ XNUMX 幎åã®å€ãéä¿¡ãæ€çŽ¢ããå¿ èŠãããç¶æ³ããããŸããã ãããŠãããã¯åžžã«ãããããªå¥œå¥å¿ããã§ã¯ãªããè€éãªããžãã¹äžã®ææ決å®ãè¡ãããã«è¡ãããŸããã 察å¿å±¥æŽããªããã°ã誀ã£ãããžãã¹äžã®ææ決å®ãè¡ãããŠããå¯èœæ§ãããã±ãŒã¹ããããŸããã
ææžã®äŸ¡å€ã¯ã©ã®ããã«è©äŸ¡ãããä¿ç®¡æéã«å¿ããŠå»æ£ãããŸãã?
çŽã®ææžã®å Žåãããã¯ä»ã®äººãšåæ§ã«éåžžã®äŒçµ±çãªæ¹æ³ã§è¡ãããŸãã é»åçãªãã®ã«ã¯ãã®ãããªããšã¯ããŸãããé»åçãªãã®ã¯èªåã§ä¿ç®¡ããŠãããŠãã ããã ã座ãã¯ããã§ãã ã¡ãªããããããŸãã ã¿ããªå æ°ã ãã
ã©ã®ãããªçºå±ã®èŠéããããã®ã§ããããïŒ
çŸåšãç§ãã¡ã® DO ã¯çŽ 30 ã®å éšåé¡ã解決ããŠããããã®äžéšã¯èšäºã®åé ã§æãããã®ã§ãã DL ã¯ãããŒãããŒåãã«å¹Ž XNUMX åéå¬ããã«ã³ãã¡ã¬ã³ã¹ãæºåããããã«ã䜿çšãããŸããããã°ã©ã å šäœããã¹ãŠã®ã¬ããŒãããã¹ãŠã®äžŠè¡ã»ã¯ã·ã§ã³ãäŒå Žãªã©ãããããã¹ãŠã DL ã«å ¥åãããDL ããããŠã³ããŒããããå°å·ãããããã°ã©ã ã«ãªããŸããäœãããŠããŸãã
DO ã§ã¯ããã§ã«è§£æ±ºããŠããã¿ã¹ã¯ã«å ããŠãããã«ããã€ãã®ã¿ã¹ã¯ãé²è¡äžã§ãã å
šç€Ÿçãªã¿ã¹ã¯ãããã°ãç¹å®ã®éšéã®ã¿ã«å¿
èŠãªãŠããŒã¯ã§çããã¿ã¹ã¯ããããŸãã 圌ããæ¯æŽããå¿
èŠããããŸããããã¯ã1C å
ã§ã·ã¹ãã ã䜿çšãããå°çããæ¡å€§ããããšãã€ãŸãé©çšç¯å²ãæ¡å€§ãããã¹ãŠã®éšéã®åé¡ã解決ããããšãæå³ããŸãã ããã¯ãããã©ãŒãã³ã¹ãšä¿¡é Œæ§ããã¹ãããã®ã«æé©ãªãã¹ãã§ãã ç§ã¯ããã®ã·ã¹ãã ãæ°å
件ã®ã¬ã³ãŒãããã¿ãã€ãåäœã®æ
å ±ãåŠçã§ããããšãæåŸ
ããŠããŸãã
åºæïŒ habr.com