[B! ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°] sosukã®ãƒ

sosuk id:sosuk

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«é–¢ã™ã‚‹sosukã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

DBç®¡ç†è€…ãŒã„ã¾ã™ãç¢ºèªã™ã¹ã3ã¤ã®è¨å®š
DBç®¡ç†è€…ãŒã„ã¾ã™ãç¢ºèªã™ã¹ã3ã¤ã®è¨å®šï¼šçœŸãƒ»Dr. K's SQL Serverãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ç ”ä¿®ï¼ˆ4ï¼‰ï¼ˆ1/3 ãƒšãƒ¼ã‚¸ï¼‰ ç®¡ç†è€…ã®åŠ›é‡ãŒã‚ã‚‰ã‚ã‚Œã‚‹3ã¤ã®è¨å®š å‰å›žã€è¨å®šã•ã‚ŒãŸå€¤ã‚’è¦‹ã‚‹ã ã‘ã§DBç®¡ç†è€…ã®åŠ›é‡ãŒè¦‹ãˆã‚‹ã€ã¨ã„ã†ã“ã¨ã«è§¦ã‚Œã¾ã—ãŸã€‚ä»Šå›žã‚‚å¿…ãšæŠ¼ã•ãˆã¦ãŠããŸã„ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’ã€ãªãœãã®ã‚ˆã†ã«è¨å®šã™ã¹ãã‹ã¨ã„ã†ç†ç”±ã¨ä½µã›ã¦è§£èª¬ã—ã¦ã„ãã¾ã™ã€‚ è¨å®šã™ã¹ããƒã‚¤ãƒ³ãƒˆã¯å¤§å¤‰ã‚·ãƒ³ãƒ—ãƒ«ã§ã™ã€‚ temp dbã®æ•°ã‚’CPUã‚³ã‚¢æ•°ã«ã‚ã‚ã›ã‚ˆ x64ç’°å¢ƒãªã‚‰ã€Œãƒ¡ãƒ¢ãƒªå†…ã®ãƒšãƒ¼ã‚¸ãƒãƒƒã‚¯æŒ‡å®šã€ã‚’å¤‰ãˆã‚ˆ OLTPç’°å¢ƒã§ã¯ã€ä¸¦åˆ—å‡¦ç†ã®æœ€å¤§é™åº¦ï¼ˆMax DOPï¼‰ã¯CPUã‚³ã‚¢æ•°ã®ã€Œ4åˆ†ã®1ã€ã«è¨å®šã›ã‚ˆ ã‚‚ã¡ã‚ã‚“ã€ã“ã‚Œã ã‘å¤‰æ›´ã™ã‚Œã°ã€ãã®éƒ¨åˆ†ã«ãŠã‘ã‚‹æœ€ä½Žé™ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¯å®Œäº†ã—ã¾ã™ã€‚ã—ã‹ã—1ã¤ä¸Šã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚’ç›®æŒ‡ã™ãªã‚‰ã€ãã®ç†ç”±ã¾ã§ãã£ã¡ã‚ŠçŸ¥ã£ã¦ãŠãã¹ãã§ã—ã‚‡ã†ã€‚ãã®ç†ç”±ã‚’çŸ¥ã‚‹ã“ã¨ã§ã€ç›£è¦–ãƒ„ãƒ¼ãƒ«ã‚„å‹•çš„ç®¡ç†ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆãŒç™ºã™ã‚‹ã€Œ
sosuk 2018/09/25
ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

DB

SQL Server
ãƒªãƒ³ã‚¯
ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®ç›£è¦–ã¨ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° - SQL Server
é©ç”¨å¯¾è±¡: SQL Server Azure SQL Database Azure SQL Managed Instance ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç›£è¦–ã™ã‚‹ç›®çš„ã¯ã€ã‚µãƒ¼ãƒãƒ¼ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’è©•ä¾¡ã™ã‚‹ã“ã¨ã§ã™ã€‚ é©åˆ‡ãªç›£è¦–ã«ã¯ã€ç¾åœ¨ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆã‚’å®šæœŸçš„ã«ã‚ãƒ£ãƒ—ãƒãƒ£ã—ã¦å•é¡Œã®åŽŸå› ã¨ãªã£ã¦ã„ã‚‹ãƒ—ãƒã‚»ã‚¹ã‚’ç‰¹å®šã—ãŸã‚Šã€é•·æœŸã«ã‚ãŸã£ã¦ç¶™ç¶šçš„ã«ãƒ‡ãƒ¼ã‚¿ã‚’æŽ¡å–ã—ã¦ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®å‚¾å‘ã‚’è¿½è·¡ã™ã‚‹ä½œæ¥ãŒå¿…è¦ã§ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®ç¶™ç¶šçš„ãªè©•ä¾¡ã¯ã€å¿œç”æ™‚é–“ã‚’æœ€å°é™ã«ã—ã€ã‚¹ãƒ«ãƒ¼ãƒ—ãƒƒãƒˆã‚’æœ€å¤§é™ã«ã—ã¦ã€æœ€é©ãªãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’å®Ÿç¾ã™ã‚‹ãŸã‚ã«å½¹ç«‹ã¡ã¾ã™ã€‚ ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æœ€å¤§é™ã«é«˜ã‚ã‚‹ã«ã¯ã€åŠ¹çŽ‡çš„ãªãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ ãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ã€ãƒ‡ã‚£ã‚¹ã‚¯ I/Oã€ãŠã‚ˆã³ CPU ä½¿ç”¨ãŒé‡è¦ã§ã™ã€‚ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è¦ä»¶ã‚’ååˆ†ã«åˆ†æžã—ã€ãƒ‡ãƒ¼ã‚¿ã®è«–ç†æ§‹é€ ã¨ç‰©ç†æ§‹é€ ã‚’ç†è§£ã—ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä½¿ç”¨çŠ¶æ³ã‚’è©•ä¾¡ã—ã€ç«¶åˆã™ã‚‹å‡¦ç†
sosuk 2018/07/20
SQL Server

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
ã‚·ã‚¹ãƒ†ãƒ åŸºç›¤ AtlasBaseÂ®ï½œBIPROGYæ ªå¼ä¼šç¤¾
ä¼æ¥æƒ…å ± ä¼æ¥æƒ…å ±ãƒˆãƒƒãƒ— BIPROGYã«ã¤ã„ã¦ ãƒˆãƒƒãƒ—ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ ä¼šç¤¾æ¦‚è¦ Purpose,Principles Vision2030ãƒ»çµŒå–¶æ–¹é‡ï¼ˆ2024-2026ï¼‰ ã‚³ãƒ¼ãƒãƒ¬ãƒ¼ãƒˆãƒ–ãƒ©ãƒ³ãƒ‰ ã‚°ãƒ«ãƒ¼ãƒ—ä¼šç¤¾ æ‹ ç‚¹æ‰€åœ¨åœ° çµ„ç¹”å›³ å½¹å“¡ä¸€è¦§ ä¼æ¥ç†å¿µ ä¼æ¥è¡Œå‹•æ†²ç« å½¹è·å“¡è¡Œå‹•è¦ç¯„ PDF èª¿é”ãƒ»è³¼è²·ã«é–¢ã™ã‚‹æŒ‡é‡ç‰ã«ã¤ã„ã¦ BIPROGYã‚°ãƒ«ãƒ¼ãƒ—ã®AIå€«ç†æŒ‡é‡ PDF BIPROGYã‚°ãƒ«ãƒ¼ãƒ—ã®æ´å² BIPROGYã®ä¼æ¥æ´»å‹• ã‚µã‚¹ãƒ†ãƒŠãƒ“ãƒªãƒ†ã‚£ åºƒå‘Šå®£ä¼æ´»å‹• ã‚¤ãƒ™ãƒ³ãƒˆï¼ã‚»ãƒŸãƒŠãƒ¼ å‡ºç‰ˆç‰© ãƒ‡ã‚¸ã‚¿ãƒ«ãƒ¡ãƒ‡ã‚£ã‚¢ BIPROGY TERASU åˆ¥ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã§é–‹ã BIPROGYãƒãƒ‰ãƒŸãƒ³ãƒˆãƒ³ãƒãƒ¼ãƒ æ±äº¬ãƒ‡ã‚£ã‚ºãƒ‹ãƒ¼ãƒ©ãƒ³ãƒ‰ã€Œã‚¨ãƒ¬ã‚¯ãƒˆãƒªã‚«ãƒ«ãƒ‘ãƒ¬ãƒ¼ãƒ‰ãƒ»ãƒ‰ãƒªãƒ¼ãƒ ãƒ©ã‚¤ãƒ„ã€ æ±äº¬ãƒ‡ã‚£ã‚ºãƒ‹ãƒ¼ã‚·ãƒ¼ã€Œãƒ•ã‚©ãƒ¼ãƒˆãƒ¬ã‚¹ãƒ»ã‚¨ã‚¯ã‚¹ãƒ—ãƒãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã€ BIPROGYã®ç ”ç©¶æ´»å‹• BIPROGYç·åˆæŠ€è¡“ç ”ç©¶æ‰€ Techno logy Foresight
sosuk 2018/07/20
SQL Server

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
PostgreSQLã®å®Ÿè¡Œè¨ˆç”»ã‚’èªã¿è§£ããŸã‚ã®å‚è€ƒè³‡æ–™é›† - ã±ã¨éšŠé•·æ—¥èªŒ
ã¯ã˜ã‚ã« PostgreSQLã¯å•†ç”¨DBã«æ¯”ã¹ã¦æ›¸ç±ãŒå°‘ãªãã€ã¾ã¨ã¾ã£ãŸæƒ…å ±ãŒå…¥æ‰‹ã—ã«ãã„ã§ã™ã€‚ã¾ãŸã€æœ‰å¿—ã®æ–¹ãŒPostgreSQLã«é–¢ã™ã‚‹è³‡æ–™ã‚’å…¬é–‹ã—ã¦ã„ã¾ã™ãŒã€æ•£åœ¨ã—ã¦ãŠã‚Šã€ã›ã£ã‹ãã®æœ‰ç›Šãªæƒ…å ±ã«ã‚¢ã‚¯ã‚»ã‚¹ã—ã«ãã„çŠ¶æ³ã«ã‚ã‚Šã¾ã™ã€‚ ãã“ã§ã€æœ¬ã‚¨ãƒ³ãƒˆãƒªã§ã¯PostgreSQLã®å®Ÿè¡Œè¨ˆç”»ã«ç„¦ç‚¹ã‚’çµžã‚Šã€å…¬é–‹ã•ã‚Œã¦ã„ã‚‹æœ‰ç”¨ãªè³‡æ–™ï¼ˆæ›¸ç±å«ã‚€ï¼‰ã‚’ã¾ã¨ã‚ã¾ã—ãŸã€‚èªã¿è¿”ã—ãŸã„è³‡æ–™ã‚’æŽ¢ã—ã‚„ã™ãã™ã‚‹ãŸã‚ã€å†…å®¹ã®ãƒã‚¤ãƒ³ãƒˆã‚‚ä½µã›ã¦ç´¹ä»‹ã—ã¦ã¾ã™ã€‚ æœ¬ã‚¨ãƒ³ãƒˆãƒªã‚’ãã£ã‹ã‘ã«ã€ã“ã‚Œã‚‰ã®è³‡æ–™ãŒã•ã‚‰ã«æ´»ç”¨ã•ã‚Œã‚‹ã“ã¨ã‚’é¡˜ã£ã¦ã„ã¾ã™ã€‚ å‰æ å„è³‡æ–™ã®å‰æã¨ã—ã¦ã„ã‚‹PostgreSQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ç•°ãªã‚‹ã“ã¨ã«ã”æ³¨æ„ãã ã•ã„ã€‚èª¿æŸ»å¯¾è±¡ã®PostgreSQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒç•°ãªã‚Œã°ã€çŠ¶æ³ã¯å¤‰ã‚ã£ã¦ã„ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ å„è³‡æ–™ã«ã¯å†…å®¹ã®é‡è¤‡ãŒã‚ã‚Šã€ã»ã¼åŒä¸€å†…å®¹ã®å ´åˆã‚‚ã‚ã‚Šã¾ã™ã€‚é‡è¤‡ã—ã¦ã„ã‚‹å†…å®¹ã«ã¤ã„ã¦ã¯ãƒã‚¤ãƒ³ãƒˆã‹ã‚‰å‰²æ„›ã™ã‚‹ã“ã¨ãŒã‚ã‚Šã¾
sosuk 2017/09/22
PostgreSQL

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚»ãƒ©ãƒ”ãƒ¼ / Oracleã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®åŸºç¤ŽçŸ¥è˜ã‚’èº«ã«ã¤ã‘ã‚‹
ã‚·ã‚¹ãƒ†ãƒ ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¯ã€éžå¸¸ã«è¤‡é›‘ãªä½œæ¥ã§ã™ã€‚è¨è¨ˆã€é–‹ç™ºæ®µéšŽã«ãŠã‘ã‚‹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‹ã‚‰ã€é‹ç”¨é–‹å§‹å¾Œã®ç¶™ç¶šçš„ãªç›£è¦–ã®çµæžœã€å¿…è¦ã¨ãªã‚‹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãªã©æ§˜ã€…ã§ã™ã€‚Oracle RDBMSã®å…·ä½“çš„ãªãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°æ–¹æ³•ã«å…¥ã‚‹å‰ã«ã€ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ãŠã‘ã‚‹åŸºç¤ŽçŸ¥è˜ã‚’ç¿’å¾—ã—ã¾ã™ã€‚
sosuk 2017/02/16
oracle

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ï½žãŠæ‰‹è»½ã«ä½¿ãˆã‚‹ãƒ’ãƒ³ãƒˆå¥ã¾ã§ - Qiita
ORACLEã§ã®çµŒé¨“ã‚’å…ƒã«æ›¸ã„ã¦ã„ã¾ã™ãŒã‚³ã‚¹ãƒˆãƒ™ãƒ¼ã‚¹ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ã¹ãƒ¼ã‚¹ãªã‚‰å…¨èˆ¬çš„ã«å…±é€šã®è€ƒãˆæ–¹ã§å¯¾å¿œã§ãã‚‹ã¨æ€ã„ã¾ã™ã€‚ SQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã„ãˆã°æ¯”è¼ƒçš„å®¹æ˜“ã«æ¸ˆã‚€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ã¨ã‚Šã‚ãˆãšä½œæˆã™ã‚‹ã€‚ã¨ã„ã£ãŸå¯¾å¿œã‚’å–ã‚‰ã‚ŒãŒã¡ã§ã™ãŒã€æ•°ä¸‡ãƒ¬ã‚³ãƒ¼ãƒ‰ç¨‹åº¦ã§ã®ãƒ‡ãƒ¼ã‚¿é‡ã§ã¯ã‚ã¾ã‚ŠåŠ¹ãç›®ãŒãªãã€ã¾ãŸã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä¹±ç«‹ã™ã‚‹ã¨è¤‡æ•°ã®æ¡ä»¶ãŒã‚ã‚‹æ™‚ãªã©ã«ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ãŒèª¤ä½œå‹•ã‚’èµ·ã“ã™è¦å› ã¨ã‚‚ãªã‚Šã¾ã™ã€‚ã‚ˆã£ã¦æœ¬å½“ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒãªã„ã“ã¨ãŒåŽŸå› ãªã®ã‹ï¼Ÿã‚’ç†Ÿè€ƒã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ åŸºæœ¬çš„ã«ãƒ«ãƒ¼ãƒ«ãƒ™ãƒ¼ã‚¹ã¨é•ã„ã‚³ã‚¹ãƒˆãƒ™ãƒ¼ã‚¹ã«ãªã‚‹ã®ã§ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã«ã‚ˆã£ã¦ä½œæˆã•ã‚Œã‚‹å®Ÿè¡Œè¨ˆç”»ãŒæœ›ã¿é€šã‚Šã®è¨ˆç”»ã«ãªã£ã¦ã„ã‚‹ã®ã‹ã‚’è¦‹ãªãŒã‚‰ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã¦ã„ãå¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ä»Šã¾ã§è¦‹ã¦ããŸé…ã„SQLã¯ã¨ã‚“ã§ã‚‚ãªã„çµåˆé †ã‚„ä½¿ç”¨ã•ã‚Œã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒãªã‚“ã§ã“ã“ã‹ã‚‰ï¼Ÿã¨ã„ã£ãŸå®Ÿè¡Œè¨ˆç”»ã«ãªã£ã¦ã„ãŸäº‹ãŒå¤§åŠã§ã—ãŸã€‚ ãã†ã„ã†æ™‚ã«æ£ã—ã„å®Ÿè¡Œè¨ˆç”»ã‚’ã‚ªãƒ—
sosuk 2017/02/16
ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

SQL
ãƒªãƒ³ã‚¯
ï¼ ITï¼šé€£è¼‰è¨˜äº‹ ã€ŒOracle SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°è¬›åº§ã€
ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å‘ä¸Šã®æœ€çŸã‚³ãƒ¼ã‚¹ã‚’çŸ¥ã‚‹ Oracle SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°è¬›åº§ï¼ˆ1ï¼‰ã€€SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã§DBãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¯æ•°ç™¾å€ã‚‚å‘ä¸Šã™ã‚‹ã€‚ã¾ãšã¯RDBMSã®æ§‹é€ ã‚’çŸ¥ã‚Šã€ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®å„ªå…ˆé †ä½ã‚’ç†è§£ã—ã‚ˆã†
sosuk 2017/02/16
Oracle

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
1