ã¤ãããªããã«ãããã³ã·ã¼ãæ±ãã¦: å ¨ã¦è¦ãã¾ãï¼ SmartHR ãã¼ã¿ãã¼ã¹ç§»è¡ããã¸ã§ã¯ãã®è£å´ / builderscon 2018
ã¤ãããªããã«ãããã³ã·ã¼ãæ±ãã¦: å ¨ã¦è¦ãã¾ãï¼ SmartHR ãã¼ã¿ãã¼ã¹ç§»è¡ããã¸ã§ã¯ãã®è£å´ / builderscon 2018
販売ããµãã¼ãããµã¼ãã¹ãçµäºãã製åããµã¤ãã¦ãº ãã㨠8ãã®æ¦è¦ããç´¹ä»ãã¾ãã 販売éå§æ¥ãçµäºæ¥ 2009å¹´1æ31æ¥ è²©å£²éå§ 2017å¹´9æ30æ¥ ããµã¤ãã¦ãº ãã㨠8ãæ°è¦ãã©ã³ 販売çµäº 2022å¹´9æ30æ¥ ããµã¤ãã¦ãº ãã㨠8ãç¶ç¶ãã©ã³ããã©ã³å¤æ´ 販売çµäº 2023å¹´9æ30æ¥ ããµã¤ãã¦ãº ãã㨠8ããµãã¼ãçµäº æ¦è¦ ããµã¤ãã¦ãº ããã¨ãã¯å°éç¥èããªãã¦ãããã¾ãã¾ãªé¨éã®æ¥åã«åããããã¼ã«ãä½æã§ãã社å ã®æ å ±ãä¸å 管çãå ±æã»æ´»ç¨ã§ãããããããWebãã¼ã¿ãã¼ã¹ã§ãã ããµã¤ãã¦ãº ãã㨠8ãã¯ãã©ã¤ãã©ãªç®¡çè ãã¦ã¼ã¶ã¼ã®ä½¿ãåæãéè¦ããæ©è½ã追å ããå©ç¨ã·ã¼ã³ãããã«åºããããæ¹åãè¡ã£ããã¼ã¸ã§ã³ã¢ããçã§ãã ç¹å¾´ å°éç¥èããªãã¦ãç°¡åã«ãã¼ã¿ãã¼ã¹ãä½æã§ãã å°éç¥èããªãã¦ããç»é¢ã«å¾ã£ã¦æä½ãããã°ç°¡åã«ãã¼ã¿ãã¼ã¹
DBã¨ã³ã¸ãã¢ã®ããã®æè¡åå¼·ä¼ï¼ç¬¬3åï¼ã§ä½¿ç¨ããè³æã§ãã主ã«ãªã¬ã¼ã·ã§ãã«ã¢ãã«ã¨æ£è¦åã«ã¤ãã¦è§£èª¬ãã¦ãã¾ãããªã¬ã¼ã·ã§ãã«ã¢ãã«ã®éçã«ã¤ãã¦æ£ããèªèãã¦ããããªã¬ã¼ã·ã§ãã«ã¢ãã«ãç解ããã¨è¨ããã¨æãã¾ãã
Webã¨ã³ã¸ãã¢ã®ããã® ãã¼ã¿ãã¼ã¹æè¡[å®è·µ]å ¥é (Software Design plus) ä½è : æ¾ä¿¡åç¯åºç社/ã¡ã¼ã«ã¼: æè¡è©è«ç¤¾çºå£²æ¥: 2012/03/09ã¡ãã£ã¢: åè¡æ¬ï¼ã½ããã«ãã¼ï¼è³¼å ¥: 20人 ã¯ãªãã¯: 486åãã®ååãå«ãããã°ãè¦ã åã¯Webã¨ã³ã¸ãã¢ã§ã¯ãªãããã©ãä¸è¨ã®æ¬ãèªã¿ãã¨ããã11-3ãåæç³»å¦çã¨åæåãã¼ã¿ãã¼ã¹ãèå³æ·±ãèªã¿ã¾ããã ããã§åæç¨éã®ãã¼ã¿ãä½ãå ´åã«ã©ãããã®ãããã®ã調ã¹ã¦ã¿ãã®ã§ã¡ã¢ã£ã¦ããã¾ãã ãããã¤ãè²·ã£ã人ã¯ãã¼ã«ãè²·ãå¾åããããã¿ãããªåæãè¡ãããã«ã¯æç³»åã«å¤§éã®æ¥åãã¼ã¿ãèç©ãã¦DWHãä½ãã¾ãã ãã®éã«ã¹ã¿ã¼ã¹ãã¼ãã¨å¼ã°ããå½¢å¼ã§ãã¼ãã«è¨è¨ããã¾ãã ä¸å¿ã®ãã¡ã¯ããã¼ãã«ã¯åæã®ãã¼ï¼ä¾ï¼ååIDã顧客IDï¼ã¨åæ対象ã®æ°å¤ãã¼ã¿ï¼ä¾ï¼è²©å£²æ°éã販売éé¡ï¼ãæã¡ã¾ãã ãã®
Amazonã¯ã©ã¦ããSSDä¸ã®æ°NoSQLãã¼ã¿ãã¼ã¹ãDynamoDBããå ¬éãæ§è½ããã¤ãããã¯ã«ä¸ãä¸ãå¯è½ ãDynamoDBã¯ã15å¹´ã«ããã大è¦æ¨¡ãªNoSQLãã¼ã¿ãã¼ã¹ã¨ã¯ã©ã¦ããµã¼ãã¹ããå¦ãã ãã¨ã®é大æã ãï¼DynamoDB is the result of 15 years of learning in the areas of large scale non-relational databases and cloud services.ï¼ãAmazon Web Serviceãæ°ãµã¼ãã¹ã¨ãã¦Î²å ¬éããDynamoDBã«ã¤ãã¦ãAmazon.comã®CTOã§ããWerner Vogelsæ°ã¯èªèº«ã®ããã°All Things Distributedã®ã¨ã³ããªãAmazon DynamoDB â a Fast and Scalable NoSQL Database
ãçºè¡¨è ãèªåãããè¥ã人ã°ããã ããå¤è¦ã20代ã«ããè¦ããªãæ±äº¬å·¥æ¥å¤§å¦ã®é¦è¤ä¸å¹¸åææï¼1973å¹´çï¼ã®é©ããã¾ããå°ãé¢ç½ãã£ãã2009å¹´2æ20æ¥ã®å¤ãå¤ãã®Webä¼æ¥ã注ç®ããããã¼ã»ããªã¥ã¼åãã¼ã¿ã¹ãã¢ããéçºããè¥ææè¡è ããæ±äº¬ã»å æ¬æ¨ã®ã°ãªã¼æ¬ç¤¾ã«ä¸å ã«ä¼ããã ãã¼ã»ããªã¥ã¼åãã¼ã¿ã¹ãã¢ï¼ã¾ãã¯ãã¼ã»ããªã¥ã¼åãã¼ã¿ãã¼ã¹ï¼ã¯ã大éã®ã¦ã¼ã¶ã¼ã¨ãã¼ã¿ãæ±ãããã¼ã¿ãã¼ã¹ã®ããã©ã¼ãã³ã¹åé¡ã¨ã³ã¹ãé«ã«é ãæ©ã¾ããWebä¼æ¥ã注ç®ããæè¡ã§ãããè¨è ã¯åæ¥ã«éå¬ããããKey-Value Store åå¼·ä¼ãã«åå ããã¦ããã£ããåå¾7æãã11æã¾ã§ããã¼ã»ããªã¥ã¼åãã¼ã¿ã¹ãã¢ãéçºã»ç 究ããè¥ææè¡è ãç«ã¦ç¶ãã«ç»å ´ãã1人15åã®æã¡æéã§ææãçºè¡¨ããè°è«ãéããã¨ããéã¾ãã ã å¼ã³ãã人ã§ããããªãã¡ã¼ãã¤ã³ãã©ã¹ãã©ã¯ãã£ã¼ï¼PFIï¼æé«æè¡è²¬ä»»è
GT Nitro: Car Game Drag Raceã¯ãå ¸åçãªã«ã¼ã²ã¼ã ã§ã¯ããã¾ãããããã¯ã¹ãã¼ãããã¯ã¼ãã¹ãã«å ¨éã®ã«ã¼ã¬ã¼ã¹ã²ã¼ã ã§ãããã¬ã¼ãã¯å¿ãã¦ãããã¯ãã©ãã°ã¬ã¼ã¹ããã¤ãã¼ï¼å¤å ¸çãªã¯ã©ã·ãã¯ããæªæ¥çãªãã¼ã¹ãã¾ã§ãæãã¯ã¼ã«ã§éãè»ã¨ã«ã¼ã¬ã¼ã¹ã§ãã¾ããã¹ãã£ãã¯ã·ããããã¹ã¿ã¼ããããããè³¢ã使ã£ã¦ç«¶äºãæã¡ç ´ãå¿ è¦ãããã¾ãããã®ã«ã¼ã¬ã¼ã¹ã²ã¼ã ã¯ãã®ãªã¢ã«ãªç©çå¦ã¨ç´ æ´ãããã°ã©ãã£ãã¯ã¹ã§ããªãã®å¿ãççºããã¾ããããã¾ã§ãã¬ã¤ãããã¨ã®ãªããããªãã®ã§ãã GT Nitroã¯ããªãã¬ãã¯ã¹ã¨ã¿ã¤ãã³ã°ã試ãã«ã¼ã¬ã¼ã¹ã²ã¼ã ã§ããæ£ããç¬éã«ã®ã¢ãã·ããããã¬ã¹ãæãåãè¸ãå¿ è¦ãããã¾ããã¾ãã大ç©ãã¡ã¨ç«¶ãã¤ã¤ãè»ã®ãã¥ã¼ãã³ã°ã¨ã¢ããã°ã¬ã¼ããè¡ããªããã°ãªãã¾ãããä¸çä¸ã§æé«ã®ãã©ã¤ãã¼ã¨è»ã¨ã«ã¼ã¬ã¼ã¹ã«æããã¨ã«ãªãããã©ãã°ã¬ã¼ã¹ã®çå
ã¨ããåå¼·ä¼ã§Sunã®ã¨ã³ã¸ãã¢ã®äººã®ãã¬ã¼ã³ãç´æ¥èãæ©ä¼ããã£ãã®ã§ã¡ã¢ã£ããã¨ãå ¬éãã¾ããåºæ¬çãªäºãå¤ããã ãããã©ãé常ã«åèã«ãªãã¾ããã ããã©ã¼ãã³ã¹ã¨ã¯ ã¹ã«ã¼ããã ã¬ã¹ãã³ã¹ã¿ã¤ã /ã¬ã¤ãã³ã· ã¹ã±ã¼ã©ããªã㣠ä¸è¨ã®ã³ã³ããã¼ã·ã§ã³ ã¢ã¼ããã¯ãã£ã¨ã¯ Connection Thread Pool Query Cache Parser SQLã¯ã¨ãªããã¼ã¹ Optimizer Storage Engines ã¢ããªã«ãã£ã¦æé©ãªã¨ã³ã¸ã³ãé¸æãã¹ã ãµã¼ãã®ã³ãã¯ã·ã§ã³&ã¹ã¬ãã my.cnf max_connection (100) å¤ãããã¨ã¡ã¢ãªãæ¶è²»ãããå¯è½æ§ãã thread_cache_size (8) ã¹ã¬ãããã³ãã¯ã·ã§ã³ã®åæå¾ã«ããã£ãã·ã¥ãã¦ããæ° ä¸è¬çã«ã¯ max_connections / 3 sort_buffer_size(2M)
SlowLogã®è¨å® ç°å¢è¨å®ãã¡ã¤ã«(Windowsã§ã¯my.iniï¼Linuxã§ã¯my.cnf)ã«æ¬¡ã®ãããªè¨å®ãå ããã¨SlowLogãæå¹ã«ãªãã log-slow-queries SlowLogã®æå¹å(ãã°ãã¡ã¤ã«åãæå®å¯è½) long-query-time=2 SlowLogã«è¨é²ããå¦çæéã®ä¸é log-long-format ã¤ã³ããã¯ã¹ã使ç¨ããªãSQLæã®è¨é² long-query-timeãã©ã¡ã¼ã¿ã¯ï¼SlowLogã«è¨é²ãããããå¤ãç§åä½ã§è¨å®ããããã®å ´åã«ã¯ï¼2ç§è¶ ããå¦çæéãè²»ãããSQLæãè¨é²ãããã¾ãï¼log-long-formatãæå®ããã¨ï¼ã¤ã³ããã¯ã¹ã使ç¨ããªãSQLæãSlowLogã«è¨é²ããã SlowLogã®ç¢ºèª SlowLogãåä½ãã¦ãããã©ããã¯ï¼æ¬¡ã®ã³ãã³ãã§ç¢ºèªã§ãããlog_slow_queriesãONã§ããã°æå¹ã¨
Oracleãã¼ã¿ãã¼ã¹ã®éç¨ç®¡çè ã¯ãçªçºçã«ç´é¢ããããã©ã¼ãã³ã¹é害ã«ã©ããã£ã¦å¯¾å¦ãããããããæ¬é£è¼ã¯ãé常ã«è¤éãªOracleã®ã¢ã¼ããã¯ãã£ã«é ãæ©ã¾ã管çè ã«åããçæéã§åé¡ãåãåãã対å¦æ³ãè¦ã¤ãããã¦ãã¦ãç´¹ä»ããã対象ã¨ãããã¼ã¸ã§ã³ã¯Oracle8ãã9iã¾ã§ãåºæ¬ã¨ãã10gã®æ å ±ã¯éæå ãã¦ãããï¼ç·¨éå±ï¼ ååãBããªã¼ã¤ã³ããã¯ã¹ã«æé«ã®ããã©ã¼ãã³ã¹ããã§ã¯ãã¤ã³ããã¯ã¹ã®ç¶æ³ã確èªããããã«ANALYZEã³ãã³ãã使ç¨ãã¾ãããæ¬ç¨¿ã§ã¯ãANALYZEã³ãã³ãã§åå¾ããçµ±è¨æ å ±ããããªããã£ãã¤ã¶ãæ£ããå®è¡è¨ç»ãç«ã¦ã¦ãããããã§ãã¯ããæ¹æ³ã解説ãã¾ãã ãªããã£ãã¤ã¶ã®2ã¤ã®ã¢ã¼ã ãªããã£ãã¤ã¶ã¨ã¯ãOracleããã¼ã¿ã«å¯¾ãã¦æãå¹ççãªå®è¡è¨ç»ã決å®ããæ©è½ã§ãããªããã£ãã¤ã¶ã®2ã¤ã®ã¢ã¼ããæ£ããç解ãã¾ãããã ã«ã¼ã«ãã¼ã¹ ãã¼ã¿ã®
ããã¼ã¿ãã¼ã¹ã¯ãã©ãã¯ããã¯ã¹ãã©ããªSQLæãæãããã©ããªçµæãè¿ã£ã¦ãããããç¥ã£ã¦ããã°ããã---ããæã£ã¦ãã人ãå¤ãããããã¾ããã ãããï¼æ¬ç©ã®ã½ããã¦ã¨ã¢ã»ã¨ã³ã¸ãã¢ãç®æãã®ã§ããã°ï¼ãã¼ã¿ãã¼ã¹ãåãä»çµã¿ãå¦ã¶ãã¨ã¯é¿ãã¦éãã¾ãããããã©ã¼ãã³ã¹ãªã©ã«åé¡ãçããã¨ãã©ãããæãä»ãã¦ããã®ãçç®è¦å½ãã¤ããªãï¼ã¨ãã£ãäºæ ã«é¥ãããã¾ããã å¸è²©ã®RDBMSã®å é¨ã¯ããªãè¤éã§ããï¼åºæ¬çãªé¨åãç解ããã®ã¯ããã»ã©é£ããããã¾ããããã®ç¹éã§ãã¼ã¿ãã¼ã¹ã®åãä»çµã¿ãç解ãã¦ãã ããã ã¤ã³ãã âãã©ãã¯ããã¯ã¹ã®ã¾ã¾ã§ããã®ï¼ åºç¤ããç解ãããã¼ã¿ãã¼ã¹ã®ããã¿ï¼1ï¼ ï¼°ï½ï½ï½ï¼ âSQLæã¯ã©ã®ããã«å®è¡ãããã®ã åºç¤ããç解ãããã¼ã¿ãã¼ã¹ã®ããã¿ï¼2ï¼ åºç¤ããç解ãããã¼ã¿ãã¼ã¹ã®ããã¿ï¼3ï¼ åºç¤ããç解ãããã¼ã¿ãã¼ã¹ã®ããã¿ï¼4ï¼ åº
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}