[B! DB] masakitkã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

masakitk id:masakitk

DBã«é–¢ã™ã‚‹masakitkã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (14)

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

ãªãœã€äººã¯SQLã‚’ãƒ«ãƒ¼ãƒ—ã•ã›ãŸãŒã‚‹ã®ã‹
è¨è¨ˆè€…ã«ã‚‚ã†ã‚Œã—ã„O/Rãƒžãƒƒãƒ‘ã€ŒDBFluteã€ 7æœˆ13æ—¥ã€DB2ã®å‹‰å¼·ä¼šãªã©ã‚’é–‹å‚¬ã™ã‚‹ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã€ŒClubDB2ã€ãŒé–‹å‚¬ã•ã‚Œã¾ã—ãŸã€‚å†’é ã®ãƒ©ã‚¤ãƒˆãƒ‹ãƒ³ã‚°ãƒˆãƒ¼ã‚¯ã§ã¯ãƒ•ãƒªãƒ¼ãƒ©ãƒ³ã‚¹ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ—ãƒã‚°ãƒ©ãƒžã§ã‚ã‚Šã€DBFluteã®ãƒ¡ã‚¤ãƒ³ã‚³ãƒŸãƒƒã‚¿ã§ã‚‚ã‚ã‚‹ä¹…ä¿é›…å½¦ã•ã‚“ï¼ˆå†™çœŸï¼‰ãŒDBFluteã‚’ã‚¢ãƒ”ãƒ¼ãƒ«ã—ã¾ã—ãŸã€‚ DBFluteã‚’ç«¯çš„ã«èª¬æ˜Žã™ã‚‹ã¨ã€ã€ŒDBè¨è¨ˆè€…ã«ã‚‚ã†ã‚Œã—ã„O/Rãƒžãƒƒãƒ‘ã€ã ãã†ã§ã™ã€‚ãŸã ã€O/Rãƒžãƒƒãƒ‘ã‚’ä¹±ç”¨ã•ã‚Œã‚‹ã¨ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«æ‚ªå½±éŸ¿ã‚’åŠã¼ã—ã‹ããªã„ã®ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†è€…ã‹ã‚‰ã™ã‚‹ã¨ã€Œãˆãƒ¼ã‚„ã‚ã¦ãƒ¼ã€ã¨å¿Œé¿ã•ã‚ŒãŒã¡ã§ã™ã€‚ã—ã‹ã—ã€DBFluteã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å¤‰æ›´ã«å¼·ã„ã¨ã„ã†ç‰¹å¾´ãŒã‚ã‚Šã¾ã™ã€‚ã‚«ãƒ©ãƒ ã®è¿½åŠ ãªã©ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å¤‰æ›´å±¥æ´ã‚’è‡ªå‹•ç”Ÿæˆã—ã€é–‹ç™ºç’°å¢ƒã«ã‚¹ãƒ ãƒ¼ã‚ºã«åæ˜ ã•ã›ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ãã‚Œã‚†ãˆã«ãƒ—ãƒã‚°ãƒ©ãƒžã«ã¯å½“ç„¶ã®ã“ã¨ã€ç®¡ç†è€…ã«ã‚‚å½¹ã«ç«‹ã¤O/Rãƒžãƒƒãƒ‘ã¨è¨€ãˆã¾ã™ã€‚ ã¾ãŸä¹…ä¿ã•ã‚“ã¯ã€Œãƒ‡
masakitk 2012/08/23
DB
ãƒªãƒ³ã‚¯
PostgreSQLã®ã‚·ã‚¹ãƒ†ãƒ ãƒ†ãƒ¼ãƒ–ãƒ«å…¥é–€ã€€ï¼ˆæš—è¨˜ç”¨ã®SQLé›†ï¼‰ - ä¸»ã«è¨€èªžã¨ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã«é–¢ã—ã¦
PostgreSQLã§ï¼Œã‚·ã‚¹ãƒ†ãƒ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’åˆ©ç”¨ã™ã‚‹ãŸã‚ã®å…¥é–€ã€‚ ã‚·ã‚¹ãƒ†ãƒ ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½¿ã„æ–¹ã‚’è¦šãˆã‚Œã°ï¼Œè‡ªåˆ†ãŒä½œã£ãŸãƒ†ãƒ¼ãƒ–ãƒ«ã®çµ±è¨ˆæƒ…å ±ã‚„ï¼Œãƒ¡ã‚¿ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã™ã‚‹äº‹ãŒã§ãã‚‹ã€‚ DBãã®ã‚‚ã®ã®ç†è§£ã‚‚æ·±ã¾ã‚‹ã€‚ ï¼ˆï¼‘ï¼‰æƒ…å ±ã‚¹ã‚ãƒ¼ãƒžï¼ˆäººé–“ã«ç†è§£ã—ã‚„ã™ã„ã€‚èª¿ã¹ç‰©ã‚’ã™ã‚‹ã¨ãä¾¿åˆ©ï¼‰ ã‚«ãƒ©ãƒ ä¸€è¦§ åˆ¶ç´„ä¸€è¦§ ï¼ˆï¼’ï¼‰çµ±è¨ˆæƒ…å ±ãƒ“ãƒ¥ãƒ¼ï¼ˆãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹èª¿æ•´ã«ä¾¿åˆ©ï¼‰ ãƒ†ãƒ¼ãƒ–ãƒ«ä¸€è¦§ æŽ¥ç¶šãƒ—ãƒã‚»ã‚¹ä¸€è¦§ ï¼ˆï¼“ï¼‰ã‚·ã‚¹ãƒ†ãƒ ã‚«ã‚¿ãƒã‚°ï¼ˆã‚¢ãƒ—ãƒªã‹ã‚‰ã®åˆ©ç”¨å‘ã‘ï¼‰ ãƒ†ãƒ¼ãƒ–ãƒ«ä¸€è¦§ æ´»ç”¨ä¾‹ ä»¥ä¸‹ã®SQLã¯ï¼Œè¦šãˆã‚„ã™ã„ã‚ˆã†ã«ã‚·ãƒ³ãƒ—ãƒ«ã«è¨˜è¼‰ã—ã¦ã‚ã‚‹ã€‚ ã„ã–ã¨ã„ã†æ™‚ã«ä½¿ã†ãŸã‚ã«ï¼Œå…¨éƒ¨æš—è¨˜ã—ã‚ˆã†ã€‚ å¿…è¦ã«å¿œã˜ã¦PostgreSQLã®æœ€æ–°ç‰ˆã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’å‚ç…§ã™ã‚‹ã“ã¨ã€‚ PostgreSQLæ—¥æœ¬èªžãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ http://www.postgresql.jp/document/ ï¼ˆï¼‘ï¼‰æƒ…å ±ã‚¹ã‚ãƒ¼ãƒžï¼ˆinformation_schemaï¼‰ã‚’ä½¿ãŠã† Postgr
masakitk 2012/07/31
postgresql

DB
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(5) - SH2ã®æ—¥è¨˜
ã¨ã„ã†ã‚ã‘ã§ã€JPOUG> SET EVENTS 20120721 | Japan Oracle User Groupã«å‚åŠ ã—ã¦ç™ºè¡¨ã‚’ã—ã¦ãã¾ã—ãŸã€‚é€šå¸¸ã®å‹‰å¼·ä¼šã¨æ¯”ã¹ã¦ç™ºè¡¨è€…ã¨è´è¬›è€…ã®ä¸€ä½“æ„Ÿã‚’å¢—ã™ãŸã‚ã®å·¥å¤«ãŒãªã•ã‚Œã¦ã„ã¦ã€ã¨ã¦ã‚‚è‰¯ã‹ã£ãŸã¨æ€ã„ã¾ã™ã€‚æœ‰é™ã‚³ãƒ¼ãƒ’ãƒ¼ã‹ã¨æ€ã£ãŸã‚‰ç„¡é™ãƒ“ãƒ¼ãƒ«ã ã£ãŸã®ã‚‚é©šãã§ã™ã€‚JPOUGã®é‹å–¶ãƒ¡ãƒ³ãƒã®ã¿ãªã•ã¾ã€ä¼šå ´ã‚’æä¾›ã—ã¦ãã ã•ã£ãŸæ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ã®ã¿ãªã•ã¾ã€å½“æ—¥ãŠè¶Šã—ã„ãŸã ã„ãŸã¿ãªã•ã¾ã€ã©ã†ã‚‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ ç§ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(5)ã¨é¡Œã—ã¦éŽåŽ»4å›žåˆ†ã®ã¾ã¨ã‚ã¨è‡ªä½œãƒ„ãƒ¼ãƒ«ã®ç´¹ä»‹ã‚’ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚JdbcRunnerã¯Oracle Databaseã€MySQLã¨PostgreSQLã®é–“ã§TPC-Bã¨TPC-Cã®æ€§èƒ½æ¯”è¼ƒãŒã§ãã‚‹å”¯ä¸€ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã®ã§ã€ã„ã‚ã„ã‚è©¦ã—ã¦ã¿ã¦ã„ãŸã ã‘ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚è©¦ã—ãŸçµæžœ
masakitk 2012/07/23
ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«

ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

è² è·ãƒ†ã‚¹ãƒˆ

db
ãƒªãƒ³ã‚¯
PostgreSQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒªã‚«ãƒãƒª (1) - aaabbb_200904ã®æ—¥è¨˜
Nagios ã¨ã®é€£æºã‹ã‚‰å§‹ã¾ã£ãŸã®ã ãŒã€æœ€è¿‘PostgreSQLã‚’é›†ä¸ã—ã¦è§¦ã£ã¦ã„ã‚‹ã€‚ãã®ä¸ã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—&ãƒªã‚«ãƒãƒªã‚’è©¦ã—ã¦ã¿ãŸã€‚ PostgreSQL ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¯ã€DBã®æ©Ÿèƒ½ã‚’ä½¿ã£ãŸã‚‚ã®ã§ã¯ã€ 1. pg_dump ã«ã‚ˆã‚‹DBã”ã¨ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— 2. WALã«ã‚ˆã‚‹ãƒ•ãƒ«ãƒ»å·®åˆ†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— ãŒã‚ã‚‹ã€‚ pg_dump ã¯DBã”ã¨ã«ã¾ã¨ã‚ã¦ãƒ€ãƒ³ãƒ—ã‚’å–ã‚‹æ–¹æ³•ã§ã€ãã®åˆ†å·®åˆ†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¯å–ã‚Œãªã„ã€‚ ä¸€æ–¹2ã®WALãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¯ã€ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ãƒã‚°(å¤‰æ›´å†…å®¹ã‚’æ›¸ãå‡ºã—ãŸãƒ•ã‚¡ã‚¤ãƒ«)ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹ã“ã¨ã§ã€å·®åˆ†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãŒå¯èƒ½ã¨ãªã‚‹ã€‚ ãŸã ã—ã€ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã”ã¨ã« WALã¯1ã¤ã ã‘ã‚‰ã—ãã€DBã”ã¨ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–ã‚‹å ´åˆã«ã¯ã€ãã‚Œãžã‚Œã‚’ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã¨ã—ã¦åˆ†å‰²ã™ã‚‹ã‹ã€pg_dump ã§å€‹åˆ¥ã«å–ã‚‹ã‹ãªã©ã®å¯¾å¿œãŒå¿…è¦ã«ãªã‚Šãã†ã ã€‚ 1ã®pg_dump ã¯ä½¿ã„æ–¹ãŒå‰²åˆç°¡å˜ã§ã€ä¾‹ãˆã°ã€mmmã¨ã„ã†DBã®ãƒãƒƒã‚¯ã‚¢
masakitk 2011/09/14
PostgreSQL

DB

ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—
ãƒªãƒ³ã‚¯
ä¿¡ã˜ã‚‰ã‚Œãªã„DBæ–‡åŒ–ã€Œå›ºå®šé•·DBã€ã§ã‚‚ã‚ã†ã‚“ã§ã™ã€‚å¤§è¦æ¨¡ã‚³ãƒ³ã‚·ãƒ¥ãƒ¼ãƒžå‘ã‘ã‚µãƒ¼ãƒ“ã‚¹ã®RDBè¨è¨ˆ - ãƒ¬ãƒ™ãƒ«ã‚¨ãƒ³ã‚¿ãƒ¼å±±æœ¬å¤§ã®ãƒ–ãƒã‚°
ãšã„ã¶ã‚“æ™‚é–“ãŒã‚ã„ã¦ã—ã¾ã£ãŸã‘ã©ã€å¤§è¦æ¨¡ã‚³ãƒ³ã‚·ãƒ¥ãƒ¼ãƒžå‘ã‘ã‚µãƒ¼ãƒ“ã‚¹RDBè¨è¨ˆã®ç¶šãã€‚ åƒ•ã¯ã“ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚’è‡ªåˆ†ã®RDBã®çŸ¥è˜ã‚’ä½¿ã£ã¦é©æ–°ã—ã¦ã‚„ã‚ã†ã¨æ€ã£ã¦è‡¨ã‚“ã ã€‚ ã—ã‹ã—çµæžœã¨ã—ã¦é€†ã«ã€ã‚³ãƒ³ã‚·ãƒ¥ãƒ¼ãƒžå‘ã‘ã‚µãƒ¼ãƒ“ã‚¹ã«æœ€é©åŒ–ã•ã‚ŒãŸRDBã®ä½¿ã„æ–¹ã«ã¤ã„ã¦æ•™ã‚ã‚‹ã“ã¨ã«ãªã£ãŸã€‚ â€» ã‚ã¨ã€KVSã§ã„ã„ã˜ã‚ƒã‚“ã£ã¦è¨€ã£ã¦ã‚‹äººã‚‚ã„ã‚‹ã‘ã©ã€ãã‚Œã¯KVSå°Žå…¥ã®è‹¦åŠ´ã‚’çŸ¥ã‚‰ãªã„äººã ã¨æ€ã†ã€‚KVSã®è‹¦åŠ´ã¯å¾Œã§æ›¸ãã€‚ åƒ•ã‚‰ãŒæœ€è¿‘æ‰‹ãŒã‘ã¦ã„ã‚‹ã®ã¯ã€ã¨ã¦ã‚‚å¤§è¦æ¨¡ãªã‚³ãƒ³ã‚·ãƒ¥ãƒ¼ãƒžå‘ã‘ã‚µãƒ¼ãƒ“ã‚¹ã ã€‚ 100ä¸‡äººã®å¥‘ç´„ãƒ¦ãƒ¼ã‚¶ãŒä½¿ã„ã€1ãƒ†ãƒ¼ãƒ–ãƒ«ã«1å„„ãƒ¬ã‚³ãƒ¼ãƒ‰ä»¥ä¸Šã®ãƒ‡ãƒ¼ã‚¿ã‚’è²¯ã‚ã€24æ™‚é–“æ¢ã‚ã‚‹ã“ã¨ãŒè¨±ã•ã‚Œãšã€ è¦æ±‚ã‹ã‚‰å¿œç”ã¾ã§ã®ã‚¿ãƒ¼ãƒ³ã‚¢ãƒ©ã‚¦ãƒ³ãƒ‰ã‚¿ã‚¤ãƒ ãŒ1ç§’ä»¥å†…ã¨ã„ã†åŽ³ã—ã„SLAã®ã‚µãƒ¼ãƒ“ã‚¹ã§ã‚ã‚‹ã€‚ ä¸ã§ã‚‚åƒ•ã¯DBã‚„ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã®è¨è¨ˆã¨ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒˆã£ã½ã„ã“ã¨ã‚’æ‹…å½“ã—ã¦ã„ã‚‹ã€‚ åƒ•ãŒã“ã®ç¾å ´ã«æ¥ã¦ã€é©šæ„•ã—ãŸæ–‡åŒ–ãŒ2ã¤ã‚ã‚‹ ãã‚Œã¯ã€ŒJoinç¦æ¢
masakitk 2011/08/09
DB

è¨è¨ˆ
ãƒªãƒ³ã‚¯
ä¿¡ã˜ã‚‰ã‚Œãªã„DBæ–‡åŒ–ã€ŒJoinç¦æ¢ã€ã«ã€Œå›ºå®šé•·DBã€ã€ã€ã§ã‚‚ã€åˆã†ã‚“ã§ã™ã€‚å¤§è¦æ¨¡ã‚³ãƒ³ã‚·ãƒ¥ãƒ¼ãƒžå‘ã‘ã‚µãƒ¼ãƒ“ã‚¹ã®RDBè¨è¨ˆ - ãƒ¬ãƒ™ãƒ«ã‚¨ãƒ³ã‚¿ãƒ¼å±±æœ¬å¤§ã®ãƒ–ãƒã‚°
åƒ•ã‚‰ãŒæœ€è¿‘æ‰‹ãŒã‘ã¦ã„ã‚‹ã®ã¯ã€ã¨ã¦ã‚‚å¤§è¦æ¨¡ãªã‚³ãƒ³ã‚·ãƒ¥ãƒ¼ãƒžå‘ã‘ã‚µãƒ¼ãƒ“ã‚¹ã ã€‚ 100ä¸‡äººã®å¥‘ç´„ãƒ¦ãƒ¼ã‚¶ãŒä½¿ã„ã€1ãƒ†ãƒ¼ãƒ–ãƒ«ã«1å„„ãƒ¬ã‚³ãƒ¼ãƒ‰ä»¥ä¸Šã®ãƒ‡ãƒ¼ã‚¿ã‚’è²¯ã‚ã€24æ™‚é–“æ¢ã‚ã‚‹ã“ã¨ãŒè¨±ã•ã‚Œãšã€ è¦æ±‚ã‹ã‚‰å¿œç”ã¾ã§ã®ã‚¿ãƒ¼ãƒ³ã‚¢ãƒ©ã‚¦ãƒ³ãƒ‰ã‚¿ã‚¤ãƒ ãŒ1ç§’ä»¥å†…ã¨ã„ã†åŽ³ã—ã„SLAã®ã‚µãƒ¼ãƒ“ã‚¹ã§ã‚ã‚‹ã€‚ ä¸ã§ã‚‚åƒ•ã¯RDBã‚„ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã‚’æ‹…å½“ã—ã¦ã„ã‚‹ã€‚ åƒ•ãŒã“ã®ç¾å ´ã«æ¥ã¦ã€é©šæ„•ã—ãŸæ–‡åŒ–ãŒ2ã¤ã‚ã‚‹ ãã‚Œã¯ã€ŒJoinç¦æ¢ã€ã¨ã€Œå›ºå®šé•·DBã€ã ã€‚ ã‚ã‚Šãˆãªã„ã€‚ ã¨ã¯ã„ãˆã€æ£ç›´ã«è¨€ãˆã°ã€Œã¾ãŸã‹ã€ã€ã€ã€ã¨ã„ã†æ„Ÿæƒ³ã§ã‚‚ã‚ã‚‹ã€‚ RDBã‚’çŸ¥ã‚‰ãªã„ãƒ¬ã‚¬ã‚·ãƒ¼ãªäººãŸã¡ãŒè¨è¨ˆã—ãŸDBã§ã¯ã‚ˆãã‚ã‚ŠãŒã¡ãªè¨è¨ˆã ã‹ã‚‰ã ã€‚ ã¨åƒ•ã¯æ—©ã€…ã«ã“ã®æ–‡åŒ–ã¨æˆ¦ã£ã¦ã€çµ¶å¯¾ã«è¦†ã—ã¦ã‚„ã‚ã†ã¨è€ƒãˆã¦ãŸã€‚ éŽåŽ»ã®çµŒé¨“ä¸Šãã‚Œã¯ãŸã‚„ã™ã„ãƒã‚ºã ã£ãŸã€‚ ã—ã‹ã—ã€ã“ã®æ–‡åŒ–ã¨æˆ¦ã†ã“ã¨3ãƒ¶æœˆé–“ã€‚ å±ˆã—ãŸã€‚åˆã‚ã¦å±ˆã—ãŸã€‚ã„ã‚„ã€å±ˆã—ãŸã¨ã„ã†ã‚ˆã‚Šã¯ç†è§£ã—ãŸã€‚ å¤§è¦æ¨¡ã‚³ãƒ³ã‚·ãƒ¥ãƒ¼ãƒžå‘ã‘ã‚µãƒ¼ãƒ“ã‚¹ã®RDBã¨ã„ã†
masakitk 2011/08/09
DB

è¨è¨ˆ
ãƒªãƒ³ã‚¯
NOT IN vs. NOT EXISTS vs. LEFT JOIN / IS NULL: PostgreSQL
Which method is best to select values present in one table but missing in another one? This: SELECT l.* FROM t_left l LEFT JOIN t_right r ON r.value = l.value WHERE r.value IS NULL , this: SELECT l.* FROM t_left l WHERE l.value NOT IN ( SELECT value FROM t_right r ) or this: SELECT l.* FROM t_left l WHERE NOT EXISTS ( SELECT NULL FROM t_right r WHERE r.value = l.value ) Let's see for PostgreSQL 8.
masakitk 2011/07/27
DB

postgresql
ãƒªãƒ³ã‚¯
PostgreSQLã®ãƒã‚¤ãƒ³ãƒˆã‚¤ãƒ³ã‚¿ã‚¤ãƒ ãƒªã‚«ãƒãƒª(PITR)ã‚ã‚‚ - ã‚ã‚‰ã‚Œãã“ã®ã‚ã‚‚
PostgreSQLã®ãƒã‚¤ãƒ³ãƒˆã‚¤ãƒ³ã‚¿ã‚¤ãƒ ãƒªã‚«ãƒãƒª(PITR)ã®ã—ãã¿ã¨ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ‰‹é †ã€ãƒªã‚«ãƒãƒªæ‰‹é †ã®ã‚ã‚‚ã€‚ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ¦‚è¦ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®ç¨®é¡ž pg_dump ã‚µãƒ¼ãƒã‚’èµ·å‹•ã—ãŸã¾ã¾ã€pg_dumpã‚³ãƒžãƒ³ãƒ‰ã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–å¾—ã—ã¾ã™ã€‚DBã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–ã£ãŸæ™‚ç‚¹ã®ãƒ‡ãƒ¼ã‚¿ã«æˆ»ã™ã“ã¨ãŒã§ãã¾ã™ã€‚PostgreSQLã®ãƒ¡ã‚¸ãƒ£ãƒ¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒç•°ãªã‚‹ã¨ãã€ã“ã®æ–¹æ³•ã§ãƒ‡ãƒ¼ã‚¿ã®ç§»è¡Œã‚’è¡Œã†å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ã‚ªãƒ•ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— ã‚µãƒ¼ãƒã‚’åœæ¢å¾Œã€dataãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªä»¥ä¸‹ã‚’ã¾ã‚‹ã¾ã‚‹ã‚³ãƒ”ãƒ¼ã—ã¾ã™ã€‚DBã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–ã£ãŸæ™‚ç‚¹ã®ãƒ‡ãƒ¼ã‚¿ã«æˆ»ã™ã“ã¨ãŒã§ãã¾ã™ã€‚ ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ç”¨ã—ã¦ã€ã‚µãƒ¼ãƒã‚’èµ·å‹•ã—ãŸã¾ã¾ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚³ãƒ”ãƒ¼ã—ã¾ã™ã€‚ã¾ãŸã€ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ãƒã‚°ã‚‚å–å¾—ã—ã¾ã™ã€‚ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ãƒã‚°ã‚’é©ç”¨ã™ã‚‹ã“ã¨ã§ã€DBã®çŠ¶æ…‹ã‚’ä»»æ„ã®æ™‚åˆ»ã®æ™‚ç‚¹ã«æˆ»ã™ã“ã¨ãŒã§ãã¾ã™ã€‚ ã“ã“ã§ã¯ã€ã“ã®ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒ
masakitk 2011/05/12
postgresql

ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—

DB
ãƒªãƒ³ã‚¯
404 Blog Not Found:æ›¸è©•x3 - SQLæœ¬ä¸‰å¤§å¯¾æ±º
2008å¹´02æœˆ03æ—¥04:00 ã‚«ãƒ†ã‚´ãƒªæ›¸è©•/ç”»è©•/å“è©•Lightweight Languages æ›¸è©•x3 - SQL æœ¬ä¸‰å¤§å¯¾æ±º 404 Blog Not Found:ã“ã®ç™ºæƒ³ã¯ãªã‹ã£ãŸ - æ›¸è©• - é€†ç®—å¼SQLæ•™ç§‘æ›¸ã‚’æ›¸ã„ãŸã‚‰ã€ã€Œã„ã‚„ã€ã†ã¡ã‚‚ã€ã¨ã°ã‹ã‚Šã«ã©ã£ã•ã‚ŠSQL æœ¬ãŒæ¥ãŸã€‚ ã¾ãšã‚ªãƒ©ã‚¤ãƒªãƒ¼ãƒ»ã‚¸ãƒ£ãƒ‘ãƒ³ã®çŸ¢é‡Žæ§˜ã‹ã‚‰ã¯ã€ã€ŒSTATISTICS HACKS(å’Œè¨³)ã€ã¨ä¸€ç·’ã«ã€ŒSQLã‚¯ãƒƒã‚¯ãƒ–ãƒƒã‚¯ã€ã¨ã€ŒSQL Hacks ã€ã‚’ã€ãã—ã¦C&Rç ”ç©¶æ‰€ã®å‰æˆæ§˜ã‹ã‚‰ã¯ã€ŒSQLå®Ÿè·µæ´»ç”¨å¤§äº‹å…¸ ã€ã‚’çŒ®æœ¬ã„ãŸã ã„ãŸã€‚ ã“ã‚Œã ã‘é ‚ãã¨ã€ã¾ã¨ã‚ãªã„ã‚ã‘ã«ã¯è¡Œã‹ãªã„ã ã‚ã†ã¨ã„ã†ã“ã¨ã§ã€ã¾ã¨ã‚ã¦ã¿ãŸã€‚ ã¾ãšã€ã€ŒSQLã‚¯ãƒƒã‚¯ãƒ–ãƒƒã‚¯ã€ã€‚ã“ã¡ã‚‰ã¯ç”³ã—è¨³ãªã„ã®ã ã‘ã©ã€ã‹ãªã‚ŠæœŸå¾…ã¯ãšã‚Œã€‚ç¢ºã‹ã«ã€Œé€†ç®—å¼SQLæ•™ç§‘æ›¸ã€ã‚ˆã‚Šã¯ç”¨ä¾‹ã‚‚å¤šã‹ã£ãŸã®ã ã‘ã©ã€Cookbookã‚’ç‰¹å¾´ã¥ã‘ã¦ã„ãŸç¶¿å¯†ãªDiscussionãŒã‚¹ã‚«ã‚¹ã‚«ã€‚ä»–ãªã‚‰ã¨
masakitk 2011/02/15
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

database

db

sql

æœ¬

é–‹ç™ºè³‡æ–™
ãƒªãƒ³ã‚¯
Hadoopï¼‹Hiveæ¤œè¨¼ç’°å¢ƒã‚’æ§‹ç¯‰ã—ã¦ã¿ã‚‹
Hadoopï¼‹Hiveæ¤œè¨¼ç’°å¢ƒã‚’æ§‹ç¯‰ã—ã¦ã¿ã‚‹ï¼šHiveâ€•â€•RDBä½¿ã„ã®ãŸã‚ã®Hadoopã‚¬ã‚¤ãƒ‰ï¼ˆå‰ç·¨ï¼‰ï¼ˆ1/3 ãƒšãƒ¼ã‚¸ï¼‰ Hadoop Hiveã¯Hadoopä¸Šã§SQLãƒ©ã‚¤ã‚¯ãªã‚¯ã‚¨ãƒªæ“ä½œãŒå¯èƒ½ãªDWHå‘ã‘ã®ãƒ—ãƒãƒ€ã‚¯ãƒˆã§ã™ã€‚SQLã«è¿‘ã„æ“ä½œãŒå¯èƒ½ãªãŸã‚ã€HBaseã‚ˆã‚Šã‚‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æ…£ã‚Œè¦ªã—ã‚“ã ã¿ãªã•ã‚“ã«ã¯ä½¿ã„å‹æ‰‹ãŒã„ã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚æœ¬ç¨¿ã§ã¯ã“ã®Hiveã®ä½¿ã„æ–¹ã¨ãƒ¬ãƒ“ãƒ¥ãƒ¼ã‚’è¡Œã£ã¦ã„ãã¾ã™ã€‚
masakitk 2010/11/10
ä½¿ã„æ–¹

hive

hadoop

MapReduce

database

DB

java

cloud
ãƒªãƒ³ã‚¯
è«–ç†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ï¼ˆpg_dump ã¨ pg_dumpallï¼‰ | Let's POSTGRES
NTT ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚»ãƒ³ã‚¿ éˆ´æœ¨ å¹¸å¸‚ 3. è«–ç†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒªã‚¹ãƒˆã‚¢ è«–ç†ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’è¡Œã†ãƒ„ãƒ¼ãƒ«ã¯ pg_dump åŠã³ pg_dumpall ã§ã™ã€‚ pg_dump ã¯ PostgreSQL ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¯ãƒ©ã‚¹ã‚¿ã®å„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å˜ä½ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’è¡Œã„ã¾ã™ã€‚pg_dumpall ã¯ã‚¿ãƒ¼ã‚²ãƒƒãƒˆã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¯ãƒ©ã‚¹ã‚¿ã«æ ¼ç´ã—ã¦ã‚ã‚‹å…¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’è¡Œã„ã¾ã™ã€‚ pg_dump ã‚‚ pg_dumpall ã‚‚ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ã‚¿ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¾©å…ƒã™ã‚‹ãŸã‚ã«å¿…è¦ãª SQL æ–‡ã§æ§‹æˆã•ã‚Œã¾ã™ã€‚ å¾“ã£ã¦ã€pg_dump ã‚„ pg_dumpall ã‚’ä½¿ã†ã¨ PostgreSQL ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…å®¹ã‚’åˆ¥ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ç§»è¡Œã—ãŸã‚Šã€ç‰¹å®šã®ãƒ†ãƒ¼ãƒ–ãƒ«ã ã‘ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã—ãŸã‚Šã™ã‚‹ã“ã¨ãŒå¯èƒ½ã¨ãªã‚Šã¾ã™ã€‚ pg_dump, pg_dumpall ã‚’ä½¿ã†ãŸã‚ã«ã¯ç‰¹åˆ¥ãªç”¨æ„ã¯ã„ã‚Šã¾ã›ã‚“ãŒã€
masakitk 2010/08/24
DB

postgresql
ãƒªãƒ³ã‚¯
Cassandraå…¥é–€ã¨ã€ã•ã‚‰ã«è©³ã—ãçŸ¥ã‚‹ãŸã‚ã®ãƒªã‚½ãƒ¼ã‚¹é›†
ã‚¯ãƒ©ã‚¦ãƒ‰æ™‚ä»£ã®æ–°ã—ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ã€éžãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãªæ§‹é€ ã‚’æŒã¤NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒè©±é¡Œã«ãªã£ã¦ã„ã¾ã™ï¼ˆNoSQLï¼Not Only SQLã€‚å‘½åã®çµŒç·¯ã¯ã“ã¡ã‚‰ï¼‰ã€‚ãã®NoSQLã®ä¸ã§ã€ã‚‚ã£ã¨ã‚‚æ³¨ç›®ã•ã‚Œã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®1ã¤ãŒApacheã®Cassandraã§ã™ã€‚ Cassandraã¯ã€Facebookã§å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿å‡¦ç†ã®ãŸã‚ã«é–‹ç™ºã•ã‚Œã€ãã®å¾Œã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã¨ãªã‚Šã€ç¾åœ¨ã§ã¯Apache Software Foundationã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã¨ã—ã¦é–‹ç™ºã•ã‚Œã¦ã„ã¾ã™ã€‚ ç¾åœ¨ã€Cassandraã¯Facebookã‚„Diggãªã©ã§ä½¿ã‚ã‚Œã¦ã„ã‚‹ã€ã‚‚ã—ãã¯ä½¿ã†ã“ã¨ãŒæ¤œè¨Žã•ã‚Œã¦ã„ã‚‹ã¨ã•ã‚Œã€Twitterã§ã‚‚ï¼ˆãƒ„ã‚¤ãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã®æ ¼ç´ã«ã¯ä½¿ã‚ã‚Œãªã„ã‚ˆã†ã§ã™ãŒã€ãã‚Œä»¥å¤–ã®ç”¨é€”ã§ï¼‰åˆ©ç”¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ Twitterã¨DiggãŒNoSQLã®ã€ŒCassandraã€ã‚’é¸ã¶ç†ç”± TwitterãŒã€Cassandr
masakitk 2010/07/29
ã‚ã¨ã§èªã‚€

é–‹ç™º

cassandra

NoSQL

db
ãƒªãƒ³ã‚¯
PostgreSQL 9.0.1æ–‡æ›¸
è£½ä½œè‘—ä½œ Â© 1996â€“2023 The PostgreSQL Global Development Group, ï¼ˆç¿»è¨³ï¼‰æ—¥æœ¬PostgreSQLãƒ¦ãƒ¼ã‚¶ä¼š
masakitk 2010/07/21
postgresql

ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹

è³‡æ–™

DB
ãƒªãƒ³ã‚¯
PostgreSQLæ—¥æœ¬èªžãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ
PostgreSQLæ—¥æœ¬èªžãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ æœ€æ–°ç‰ˆã®ä»˜å±žãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ ç¿»è¨³ä½œæ¥ä¸ã®æœ€æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³/PostgreSQL 17.x æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ« ãƒãƒ¼ã‚¸ãƒ§ãƒ³16 PostgreSQL16æœ€æ–°ç‰ˆ æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ« PostgreSQL16.4 æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ« PostgreSQL16.3 æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ« PostgreSQL16.0 æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ« ãƒãƒ¼ã‚¸ãƒ§ãƒ³15 PostgreSQL15æœ€æ–°ç‰ˆ æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ« PostgreSQL15.4 æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ« PostgreSQL15.3 æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ« PostgreSQL15.0 æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ« ãƒãƒ¼ã‚¸ãƒ§ãƒ³14 PostgreSQL14æœ€æ–°ç‰ˆ æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ« PostgreSQL14.5 æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ« PostgreSQL14.0 æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ« ãƒãƒ¼ã‚¸ãƒ§ãƒ³13 PostgreSQL13æœ€æ–°ç‰ˆ æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ« Post
masakitk 2010/07/20
postgresql

æ—¥æœ¬èªž

ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹

ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«

DB
ãƒªãƒ³ã‚¯
1