[B! db] rkfã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

rkf id:rkf

dbã«é–¢ã™ã‚‹rkfã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

${{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}}

ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®å†ç·¨æˆã¨å†æ§‹ç¯‰
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ã‚¨ãƒ³ã‚¸ãƒ³ã§ã¯ã€åŸºã«ãªã‚‹ãƒ‡ãƒ¼ã‚¿ã«å¯¾ã—ã¦æŒ¿å…¥ã€æ›´æ–°ã€ã¾ãŸã¯å‰Šé™¤ã®å„æ“ä½œãŒè¡Œã‚ã‚Œã‚‹ãŸã³ã«ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒè‡ªå‹•çš„ã«å¤‰æ›´ã•ã‚Œã¾ã™ã€‚ ãŸã¨ãˆã°ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã«è¡ŒãŒè¿½åŠ ã•ã‚Œã‚‹ã¨ã€è¡Œã‚¹ãƒˆã‚¢ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹å†…ã®æ—¢å˜ã®ãƒšãƒ¼ã‚¸ãŒåˆ†å‰²ã•ã‚Œã¦ã€æ–°ã—ã„è¡Œã‚’æŒ¿å…¥ã™ã‚‹ãŸã‚ã®ä½™ç™½ãŒä½œæˆã•ã‚Œã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ æ™‚é–“ãŒçµŒã¤ã«å¾“ã„ã€ã“ã®ã‚ˆã†ãªå¤‰æ›´ã«ã‚ˆã‚Šã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹å†…ã®æƒ…å ±ãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å†…ã«æ•£åœ¨ (æ–ç‰‡åŒ–) ã™ã‚‹ã‚ˆã†ã«ãªã‚‹å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚ ãƒ•ãƒ«ã¾ãŸã¯ç¯„å›²ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ã‚¹ã‚ãƒ£ãƒ³ã‚’ä½¿ç”¨ã—ã¦å¤šæ•°ã®ãƒšãƒ¼ã‚¸ã‚’èªã¿å–ã‚‹ã‚¯ã‚¨ãƒªã®å ´åˆã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ–ç‰‡åŒ–ãŒå¤§ãããªã‚‹ã¨ã€ãƒ‡ãƒ¼ã‚¿ã‚’èªã¿å–ã‚‹ãŸã‚ã«è¿½åŠ ã® I/O ãŒå¿…è¦ã«ãªã‚‹ãŸã‚ã€ã‚¯ã‚¨ãƒªã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒä½Žä¸‹ã™ã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ åŒã˜é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’èªã¿å–ã‚‹ãŸã‚ã«ã€å°‘æ•°ã®å¤§ããª I/O è¦æ±‚ã§ã¯ãªãã€å¤šæ•°ã®å°ã•ãª I/O è¦æ±‚ãŒå¿…è¦ã«ãªã‚Šã¾ã™ã€‚ ãƒ©ãƒ³ãƒ€ãƒ I/O ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚ˆã‚Šã‚·ãƒ¼ã‚±ãƒ³ã‚·
rkf 2010/04/06
db

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

SQL Server

index
ãƒªãƒ³ã‚¯
SQLServer2005ã«ã‚ˆã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ–ç‰‡åŒ–è¨ºæ–ã¨ãƒªãƒ“ãƒ«ãƒ‰ - ãƒ¬ãƒ™ãƒ«ã‚¨ãƒ³ã‚¿ãƒ¼å±±æœ¬å¤§ã®ãƒ–ãƒã‚°
DBã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’ã—ã¦ã‚‹ã€‚ ã„ã‚ã„ã‚æŠ€ã‚’é§†ä½¿ã—ã¦ã€åŠ‡çš„ã«ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚¢ãƒƒãƒ—ã—ãŸã¨ãã¯çˆ½å¿«ã ï¼ ä»Šæ—¥ä¾é ¼ã‚’å—ã‘ãŸãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¯ã€çµæžœã¨ã—ã¦ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ–ç‰‡åŒ–ãŒå•é¡Œã ã£ãŸã€‚ ã“ã‚Œã«ã‚ˆã‚Šã€ã€Œ113310ãƒŸãƒªç§’ï¼ˆç´„2åˆ†ï¼‰ã€ã‹ã‹ã£ã¦ã„ãŸã‚¯ã‚¨ãƒªãŒ ã€Œ1923ãƒŸãƒªç§’(ç´„2ç§’)ã€ã¾ã§æ—©ããªã£ãŸã€‚ ã“ã‚ŒãŒãŸã¾ã‚Šã¾ã›ã‚“ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å†ç·¨æˆã™ã‚‹ã«ã‚ãŸã£ã¦ã‚‚ ã¾ãšã¯ã©ã‚Œã ã‘æ–ç‰‡åŒ–ã—ã¦ã„ã‚‹ã®ã‹ã‚’è¨ºæ–ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ â—†SQL Server 2005 Books Onlineã€€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®å†ç·¨æˆã¨å†æ§‹ç¯‰ http://msdn2.microsoft.com/ja-jp/library/ms189858.aspx sys.dm_db_index_physical_statsã®é–¢æ•°ã«ã€ãªã‚Œã¦ãªã‹ã£ãŸã®ã§ ä½¿ã„æ–¹ãŒã¯ã˜ã‚ã‚ã‹ã‚‰ãªã‹ã£ãŸã€‚ ä»¥ä¸‹ã®ã‚ˆã†ã«SQLã‚’æµã™ã¨ã€Indexã®æ–ç‰‡åŒ–ã«ã¤ã„ã¦ã•ã¾ã–
rkf 2010/04/06
db

SQL

è¨ºæ–

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹
ãƒªãƒ³ã‚¯
A5:SQL Mk-2 - ãƒ•ãƒªãƒ¼ã®SQLé–‹ç™ºãƒ„ãƒ¼ãƒ«/ERå›³ãƒ„ãƒ¼ãƒ«
A5:SQL Mk-2ã¯è¤‡é›‘åŒ–ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºã‚’æ”¯æ´ã™ã‚‹ãŸã‚ã«é–‹ç™ºã•ã‚ŒãŸãƒ•ãƒªãƒ¼ã®SQLé–‹ç™ºãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ é«˜æ©Ÿèƒ½ã‹ã¤è»½é‡ã§ã€ä½¿ã„æ–¹ãŒåˆ†ã‹ã‚Šã‚„ã™ã„ã“ã¨ã‚’ç›®æ¨™ã«é–‹ç™ºã•ã‚Œã¦ã„ã¾ã™ã€‚ SQLã‚’å®Ÿè¡Œã—ãŸã‚Šã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ç·¨é›†ã™ã‚‹ã»ã‹ã«ã€SQLã®å®Ÿè¡Œè¨ˆç”»ã‚’å–å¾—ã—ãŸã‚Šã€ERå›³ã‚’ä½œæˆã—ãŸã‚Šã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã™ã€‚ ç‰¹å¾´ãƒ»æ©Ÿèƒ½ OCIæŽ¥ç¶šãƒ»ç›´æŽ¥æŽ¥ç¶šãƒ»ADOã¾ãŸã¯ODBCã‚’ä»‹ã—ãŸDBã¸ã®æŽ¥ç¶š Oracle Databaseã¯OCIçµŒç”±ã®æŽ¥ç¶šãƒ»ç›´æŽ¥æŽ¥ç¶šãŒå‡ºæ¥ã¾ã™ã€‚ PostgreSQLã¨MySQLã¯ç›´æŽ¥æŽ¥ç¶šãŒå‡ºæ¥ã¾ã™ã€‚ Microsoft SQL Serverã¯ã€OLE DBãƒ—ãƒãƒã‚¤ãƒ€ã‚’ç›´æŽ¥å‘¼ã³å‡ºã—ãŸæŽ¥ç¶šãŒã§ãã¾ã™ã€‚ IBM DB2ã¯ã€ODBCãƒ‰ãƒ©ã‚¤ãƒã‚’ç›´æŽ¥å‘¼ã³å‡ºã—ãŸæŽ¥ç¶šãŒã§ãã¾ã™ã€‚ ãã®ä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€ADOã¾ãŸã¯ODBCã‚’åˆ©ç”¨ã—ã¦æŽ¥ç¶šã—ã¾ã™ã€‚ Oracle, PostgreSQL, MySQLã¯ã€A5:SQL
rkf 2010/02/23
DB

ERå›³
ãƒªãƒ³ã‚¯
SQL -TECHSCORE-
ã“ã“ã§ã¯ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«åž‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œã™ã‚‹ãŸã‚ã«å¿…é ˆã¨ãªã‚‹ä¸–ç•Œæ¨™æº–è¨€èªž SQL ã«ã¤ã„ã¦ã€åŸºç¤Žã‹ã‚‰å¿œç”¨ã¾ã§è©³ã—ãèª¬æ˜Žã—ã¦ã„ã¾ã™ã€‚ ã¾ãŸã€SQL ã®ã¿ã«ã¨ã©ã¾ã‚‰ãšã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒžãƒãƒ¼ã‚¸ãƒ¡ãƒ³ãƒˆã‚·ã‚¹ãƒ†ãƒ (RDBMS) ã®æŒã¤æ§˜ã€…ãªæ©Ÿèƒ½ã«ã¤ã„ã¦è©³ã—ãèª¬æ˜Žã—ã¦ã„ã¾ã™ã€‚ æœ€å¾Œã«ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¨è¨ˆã«é–¢ã™ã‚‹éžå¸¸ã«é‡è¦ãªè€ƒãˆæ–¹ã«ã¤ã„ã¦ã‚‚è§¦ã‚Œã¦ã„ã¾ã™ã®ã§ã€ã“ã‚Œã‚‰ã‚’å…¨ã¦å¦ç¿’ã™ã‚‹ã¨ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ“ä½œã‹ã‚‰è¨è¨ˆã¾ã§å¹…åºƒã„çŸ¥è˜ã‚’èº«ã«ã¤ã‘ã‚‹ã“ã¨ãŒã§ãã‚‹ã§ã—ã‚‡ã†ã€‚ SQL INDEX 1. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ¦‚è¦ 1.1. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯ 1.2. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã®ç‰¹å¾´ 1.3. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ãƒ•ã‚¡ã‚¤ãƒ«ã®é•ã„ 1.4. ä»£è¡¨çš„ãªãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ« 1.5. ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«åž‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ 1.6. ã¾ã¨ã‚ 2. SQL 2.1. SQL ã®æ´å² 2.2. SQL ã¨ã¯ 2.3. SQL ã®æ©Ÿèƒ½ 2.
rkf 2010/02/05
åŸºæœ¬äº‹é …ãŒã®ã£ã¦ãŠã‚Šã¾ã™

DB

SQL
ãƒªãƒ³ã‚¯
NPOæ³•äºº æ—¥æœ¬PostgreSQLãƒ¦ãƒ¼ã‚¶ä¼š
æ—¥æœ¬ PostgreSQL ãƒ¦ãƒ¼ã‚¶ä¼š ï¼ˆç•¥ç§° JPUGï¼‰ã® Web ã‚µã‚¤ãƒˆã§ã™ã€‚ PostgreSQL ã®æ—¥æœ¬èªžè¨³ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã€PostgreSQL ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã¸ã®ãƒªãƒ³ã‚¯ã€å„ç¨®ã‚¤ãƒ™ãƒ³ãƒˆã®ãŠçŸ¥ã‚‰ã›ã€ãƒ¦ãƒ¼ã‚¶ä¼šå„çµ„ç¹”ã®æƒ…å ±ã‚’æŽ²è¼‰ã—ã¦ã„ã¾ã™ã€‚ æ¯Žå¹´ ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ ã‚’é–‹å‚¬ã—ã¦ã„ã¾ã™ã€‚ PostgreSQL ã«é–¢ã™ã‚‹ã”è³ªå•ãƒ»ã”ç›¸è«‡ã¯ã€å½“ä¼šã®ãƒ¡ãƒ¼ãƒªãƒ³ã‚°ãƒªã‚¹ãƒˆã‚„ ãƒ¯ãƒ¼ã‚¯ã‚¹ãƒšãƒ¼ã‚¹ï¼ˆã® #beginners ã‚„ #general ãƒãƒ£ãƒ³ãƒãƒ«ï¼‰ã«æŠ•ç¨¿ãã ã•ã„ã€‚ ä»–ã® PostgreSQL ãƒ¦ãƒ¼ã‚¶ã‹ã‚‰ã®ã‚³ãƒ¡ãƒ³ãƒˆã‚’è²°ãˆã‚‹ã¨æ€ã„ã¾ã™ã€‚ ï¼»JPUG ãƒ¡ãƒ¼ãƒªãƒ³ã‚°ãƒªã‚¹ãƒˆï¼Slackãƒ¯ãƒ¼ã‚¯ã‚¹ãƒšãƒ¼ã‚¹ï¼½ https://www.postgresql.jp/npo/mailinglist ã¾ãŸã€å§‰å¦¹ã‚µã‚¤ãƒˆã§ PostgreSQL ã®å„ç¨®è¨˜äº‹ã‚’é›†ç©ã—ã¦ã„ã‚‹ Let's Postgres ã‚‚ã”å‚ç…§ãã ã•ã„ã€‚
rkf 2010/02/05
NPOæ³•äººãªã‚“ã ã

db
ãƒªãƒ³ã‚¯
1