[B! sql] t_itaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

t_ita id:t_ita

sqlã«é–¢ã™ã‚‹t_itaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

ã‚°ãƒ¼ã‚°ãƒ«ã®ãƒ‡ãƒ¼ã‚¿åˆ†æžã‚µãƒ¼ãƒ“ã‚¹ã€ŒBigQueryã€ãŒæ¨™æº–SQLã‚’ã‚µãƒãƒ¼ãƒˆ
æ³•äººå‘ã‘äº‹æ¥ã®åŠ é€Ÿã‚’å›³ã‚‹GoogleãŒç±³å›½æ™‚é–“6æœˆ2æ—¥ã€ã‚¯ãƒ©ã‚¦ãƒ‰ãƒ™ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿åˆ†æžã‚µãƒ¼ãƒ“ã‚¹ã€ŒBigQueryã€ã‚’å¼·åŒ–ã—ãŸã¨ç™ºè¡¨ã—ãŸã€‚å¾“æ¥ã®ãƒ“ãƒƒã‚¯ãƒ‡ãƒ¼ã‚¿ã‚µãƒ¼ãƒ“ã‚¹ã¨ã®äº’æ›æ€§æ”¹å–„ãªã©ãŒåŠ ã‚ã£ãŸã€‚ BigQueryã®å¼·åŒ–ã¨ã—ã¦ã€æ¨™æº–ã®SQLã‚’ã‚µãƒãƒ¼ãƒˆã—ãŸã€‚ã“ã‚Œã«åŠ ãˆã¦ã€é«˜åº¦ãªã‚¯ã‚¨ãƒªãƒ—ãƒ©ãƒ³ãƒ‹ãƒ³ã‚°ã¨æœ€é©åŒ–ã‚‚å¯èƒ½ã¨ãªã‚Šã€SQLã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã§ã®ä»»æ„ã®è¤‡é›‘ãªã‚µãƒ–ã‚¯ã‚¨ãƒªãŒã‹ã‘ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ãªã£ãŸã€‚ã•ã‚‰ã«ã¯ã€æ—¥ã€æ™‚é–“ã€ã‚¢ãƒ¬ã‚¤ã€æ§‹é€ ä½“ãªã©å¹…åºƒã„åž‹ã‚·ã‚¹ãƒ†ãƒ ã€ãã‚Œã«Theta Joinã‚‚ã‚µãƒãƒ¼ãƒˆã—ãŸã€‚ Googleã¯ã¾ãŸã€ã‚¢ã‚¤ãƒ‡ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã¨ã‚¢ã‚¯ã‚»ã‚¹ç®¡ç†ã®æ©Ÿèƒ½ã€ŒCloud IAMã€ã‚’BigQueryã§ã‚‚ãƒ™ãƒ¼ã‚¿ã¨ã—ã¦æä¾›ã™ã‚‹ã€‚ã“ã‚Œã«ã‚ˆã‚Šã€BigQueryãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆå‘ã‘ã®è¨±å¯ã‚’å®Œå…¨ã«è‡ªå‹•åŒ–ã§ãã€ç®¡ç†è€…ã¯è©³ç´°ã«ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãƒãƒªã‚·ãƒ¼ã‚’ä½œæˆã§ãã‚‹ã€‚ æœ€å¾Œã«ã€Googleã¯æ™‚é–“ãƒ™ãƒ¼ã‚¹ã®ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°æ©Ÿèƒ½ã‚‚å°Žå…¥ã—ãŸã€‚è¤‡
t_ita 2016/06/03
ã‚¯ã‚¨ãƒªè¨€èªžã¨ã—ã¦SQLãŒæ¨™æº–åŒ–ã—ã¦ã„ãæ„Ÿã˜ã§ã—ã‚‡ã†ã‹ã€‚JPAã¨ã‹ã‚‚ä½¿ãˆã‚‹ã‚ˆã†ã«ãªã£ãŸã‚Šã¨ã‹ï¼Ÿ

SQL

google
ãƒªãƒ³ã‚¯
SQLãƒ•ã‚©ãƒ¼ãƒžãƒƒã‚¿ãƒ¼For WEB
SQLãƒ•ã‚©ãƒ¼ãƒžãƒƒã‚¿ãƒ¼For WEBÂ Î²013ex1 ã‚µã‚¯ãƒ©ã‚¨ãƒ‡ã‚£ã‚¿SQLæ•´å½¢ãƒžã‚¯ãƒã‚’ãƒ™ãƒ¼ã‚¹ã«WEBåŒ–ã—ã¦ã¿ã¾ã—ãŸã€‚ ãƒãƒ¼ã‚«ãƒ«ã«ä¿å˜ã—ã¦SQLæ–‡æ•´å½¢ãƒ„ãƒ¼ãƒ«ã¨ã—ã¦ã‚‚ãŠä½¿ãˆã§ãã¾ã™ã€‚ 1. ä¸‹ã®ãƒ†ã‚ã‚¹ãƒˆãƒœãƒƒã‚¯ã‚¹ã«SQLã‚’è²¼ã‚Šä»˜ã‘ã‚‹ã€‚ 2. æ€ã†ãŒã¾ã¾ã«ã€Œæ•´å½¢ã™ã‚‹ã€ãƒœã‚¿ãƒ³ã‚’æŠ¼ä¸‹ã™ã‚‹ã€‚ ã„ã„æ„Ÿã˜ã«æ•´å½¢ã§ããŸã‚‰å‡ºæ¥ä¸ŠãŒã‚Šï½žã€‚ æœ¬å®¶ã®ã‚µã‚¯ãƒ©ã‚¨ãƒ‡ã‚£ã‚¿ãƒžã‚¯ãƒç‰ˆã®SQLæ•´å½¢ãƒžã‚¯ãƒã¯ã‚³ãƒãƒ©ã‹ã‚‰ã€‚ â€»Î²009 for Webã‹ã‚‰ã¯ã‚«ãƒ³ãƒžã¯å‰ã¨ã‹ AND/ORã¯å¾Œã‚ã¨ã‹æŒ‡å®šã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã£ï¼ï¼ˆ2010/2/1ï¼‰ â€»Î²010 for Webã‹ã‚‰ã¯JOINå½¢å¼ã‚’æŒ‡å®šã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã£ï¼ï¼ˆ2010/5/1ï¼‰ â€»Î²013ex1 for Webã‹ã‚‰ã¯ãƒ†ã‚ã‚¹ãƒˆå¤‰æ›ãŒã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã£ï¼ï¼ˆ2010/11/3ï¼‰ ã•ã‚‰ã«Cookieã«è¨å®šå€¤ã‚’ä¿æŒã™ã‚‹ã‚ˆã†ã«ã—ãŸã®ã§ã€æ¬¡å›žã‹ã‚‰ã¯å†è¨å®šãŒä¸è¦ã«ãªã‚Šã¾ã—ãŸ
t_ita 2012/10/02
ãƒ„ãƒ¼ãƒ«

web

sql
ãƒªãƒ³ã‚¯
ç¬¬2å›žã€€å†—é•·æ€§ç—‡å€™ç¾¤ï½žæ¡ä»¶åˆ†å²ã‚’UNIONã§è¡¨ç¾ã™ã‚‹ãªã‹ã‚Œ | gihyo.jp
ã“ã“ã¯ã¨ã‚ã‚‹è¡—ã®ç·åˆç—…é™¢ã€‚ ã“ã“ã«ã¯é€šå¸¸ã®è¨ºç™‚ç§‘ã®ã»ã‹ã«ã€ä¸€é¢¨å¤‰ã‚ã£ãŸè¨ºç™‚ç§‘ãŒå˜åœ¨ã™ã‚‹ã€‚ ä½•è»’ã‚‚ã®ç—…é™¢ã‚’ãŸã‚‰ã„ã¾ã‚ã—ã«ã•ã‚ŒãŸã€æ‰‹ã®æ–½ã—ã‚ˆã†ã®ãªã„SQLã‚„ã€ä»Šã™ãã«æ”¹å–„ãŒå¿…è¦ãªSQLãŒæ‹…ãŽè¾¼ã¾ã‚Œã‚‹æ•‘å‘½å®¤ã§ã‚ã‚‹ã€‚ ãã‚ŒãŒSQLç·Šæ€¥æ•‘å‘½å®¤ã€ç•¥ã—ã¦SERï¼ˆSQL Emergency Roomâ ï¼‰â ã€‚ ãã†ã€ã“ã“ã¯å›½å†…ã§ã‚‚å”¯ä¸€ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°å°‚é–€å¤–æ¥ã§ã‚ã‚‹ã€‚ ãƒãƒãƒ¼ãƒˆæ•‘å‘½å®¤éƒ¨é•·ã€‚è…•ã®ç«‹ã¤ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã ãŒã€å£ãŒæ‚ªãæ€§æ ¼ã¯ã‚‚ã£ã¨æ‚ªã„å››åã‚ªãƒ¤ã‚¸ã€‚ ï¼ˆAM10:00 ä¼‘æ†©å®¤ã€‚ãƒ¯ã‚¤ãƒªãƒ¼ãŒæœºã«å‘ã‹ã£ã¦ä¸€äººã§ä½•ã‹ã—ã¦ã„ã‚‹ï¼‰ ã©ã£ã¦ãƒã‚ãƒ¼ã‚“ã©ã£ã¦ãƒã‚ãƒ¼ã‚“ã€ã½ã½ã½ã‚“ã½ãƒ¼ã‚“ã€ã©ã£ã¦ãƒã‚ãƒ¼ã‚“â€¦
t_ita 2011/10/04
UNION ALLã‚’ä½¿ã†ã®ã¯ã‚ˆãè¦‹ã‹ã‘ã‚‹ã€‚ã§ãã‚Œã°ã‚„ã‚ã¦æ¬²ã—ã„ã€‚SQLã¯ã€WHEREå¥ã§ãƒ¬ã‚³ãƒ¼ãƒ‰ã®ã‚¹ãƒˆãƒªãƒ¼ãƒ ã‚’ä½œã£ã¦ã€SELECTå¥ã§ãƒ•ã‚£ãƒ«ã‚¿ã™ã‚‹ã€ã¨ã‚¤ãƒ¡ãƒ¼ã‚¸ã™ã‚‹ã¨ã‚ã‹ã‚Šã‚„ã™ã„ã¨æ€ã† #yam

sql

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

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
SQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å•é¡Œèª¿æŸ»ã§EXPLAIN PLANã€SQLãƒˆãƒ¬ãƒ¼ã‚¹ã¯ï¼ˆã»ã¨ã‚“ã©ï¼‰ä½¿ã‚ãªã„ Â« WR blog
December 2014Â (1) February 2014Â (1) January 2014Â (1) September 2012Â (1) April 2012Â (1) March 2012Â (2) October 2011Â (1) June 2011Â (5) May 2011Â (1) April 2011Â (1) March 2011Â (1) February 2011Â (1) January 2011Â (1) December 2010Â (1) September 2009Â (1) April 2009Â (1) March 2009Â (1) January 2009Â (3) November 2008Â (2) October 2008Â (1) December 2005Â (2) October 2005Â (2) September 2005Â (2) August 2005Â (7)
t_ita 2011/02/25
ãƒ¡ãƒ¢ï¼Oracleã§ã‚ˆã‚Šæ£ç¢ºãªå®Ÿè¡Œè¨ˆç”»ã‚’ç¢ºèªã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦ã€‚ã€ŒSQL*Plusã®autotraceâ†’ å†…éƒ¨çš„ã«EXPLAIN PLANã‚’å®Ÿè¡Œã—ã¦ã„ã¾ã™ã€ã“ã‚Œã¯çŸ¥ã‚‰ãªã‹ã£ãŸ

oracle

SQL

ãƒˆãƒ¬ãƒ¼ã‚¹

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

DB
ãƒªãƒ³ã‚¯
ã„ã¾ã™ãä½¿ãˆã‚‹ç„¡æ–™ã®ã‚¯ãƒ©ã‚¦ãƒ‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒClearDBã€
ã‚¯ãƒ©ã‚¦ãƒ‰ä¸Šã«ãƒ›ã‚¹ãƒ†ã‚£ãƒ³ã‚°ã•ã‚Œã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚‚ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã‚‚ã—ã¦ãã‚Œã‚‹ã®ã§é‹ç”¨ã®æ‰‹é–“ãŒã‹ã‹ã‚‰ãªã„ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€‚ãã‚“ãªã‚µãƒ¼ãƒ“ã‚¹ã‚’é–‹å§‹ã—ã¦ã„ã‚‹æä¾›ã—ã¦ã„ã‚‹ã®ãŒã€ŒclearDBã€ã§ã™ã€‚ 1ã¤å‰ã®è¨˜äº‹ã§ã¯ä¼æ¥å‘ã‘ã®ãƒžã‚¤ã‚¯ãƒãƒ–ãƒã‚°ã€ŒYammerã€ã‚’ç´¹ä»‹ã—ã€ç«¶åˆã¨ãªã‚Šãã†ãªã‚»ãƒ¼ãƒ«ã‚¹ãƒ•ã‚©ãƒ¼ã‚¹ãƒ»ãƒ‰ãƒƒãƒˆã‚³ãƒ ã®Chatterã‚‚ç„¡æ–™ã‚µãƒ¼ãƒ“ã‚¹ã‚’é–‹å§‹ã™ã‚‹ã¨ç´¹ä»‹ã—ã¾ã—ãŸãŒã€ä»Šå›žã®ClearDBã‚‚ã€ã‚»ãƒ¼ãƒ«ã‚¹ãƒ•ã‚©ãƒ¼ã‚¹ãƒ»ãƒ‰ãƒƒãƒˆã‚³ãƒ ãŒç™ºè¡¨ã—ãŸã°ã‹ã‚Šã®ã€ŒDatabase.comã€ã¨åŒæ§˜ã®ã‚µãƒ¼ãƒ“ã‚¹ã§ã™ã€‚ç‹™ã£ãŸã‚ã‘ã§ã¯ãªã„ã®ã§ã™ãŒâ€¦â€¦ã€‚ clearDBã®Webã‚µã‚¤ãƒˆã‹ã‚‰ã€ã©ã®ã‚ˆã†ãªã‚µãƒ¼ãƒ“ã‚¹ãªã®ã‹ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ã‚¯ãƒ©ã‚¦ãƒ‰ä¸Šã§100ï¼…ACIDå¯¾å¿œã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ clearDBã¯100ï¼…ACIDã«å¯¾å¿œã—ã€è‡ªå‹•çš„ã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã•ã‚ŒãŸã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ãƒ«ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã ã¨èª¬æ˜Žã•ã‚Œã¦ã„ã¾ã™ã€‚ã€ŒWhat is ClearDB?
t_ita 2010/12/15
#yam ã€Œã‚¯ãƒ©ã‚¦ãƒ‰æ™‚ä»£ã«ã¯ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã•ãˆãƒªãƒ¢ãƒ¼ãƒˆã‹ã‚‰RESTã§ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã€ã¨ã„ã†ã“ã¨ãŒæ™®é€šã«è¡Œã‚ã‚Œã‚‹ã‚ˆã†ã«ãªã‚‹ã®ã§ã—ã‚‡ã†ã‹ã€

API

sql

ã‚µãƒ¼ãƒ“ã‚¹

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

ç„¡æ–™

ã‚¯ãƒ©ã‚¦ãƒ‰
ãƒªãƒ³ã‚¯
Oracleã®SQLãƒˆãƒ¬ãƒ¼ã‚¹ã®å–ã‚Šæ–¹ãŒåˆ†ã‹ã‚‰ãªã„
Q è³ªå• Oracleã‚’åˆ©ç”¨ã—ã¦ã„ã¾ã™ã€‚SQLæ–‡ãŒåŽŸå› ã§ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒæ‚ªããªã£ã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ã€Œãƒˆãƒ¬ãƒ¼ã‚¹ã‚’å–ã£ã¦èª¿ã¹ã¦ã¿ã‚ã€ã¨è¨€ã‚ã‚Œã¾ã—ãŸãŒï¼Œã©ã†ã™ã‚Œã°è‰¯ã„ã®ã‹åˆ†ã‹ã‚Šã¾ã›ã‚“ A å›žç” ALTER SESSIONã§å–å¾—ã—ãŸçµ±è¨ˆæƒ…å ±ã‹ã‚‰ï¼Œã‚ãƒ£ãƒƒã‚·ãƒ¥ã®ãƒ’ãƒƒãƒˆçŽ‡ã‚„å®Ÿè¡Œè¨ˆç”»ãªã©ã‚’èª¿ã¹ã¾ã™ Oracleã®SQLãƒˆãƒ¬ãƒ¼ã‚¹æ©Ÿèƒ½ã‚’åˆ©ç”¨ã™ã‚‹ã¨ï¼Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§å®Ÿè¡Œã•ã‚ŒãŸãã‚Œãžã‚Œã®SQLæ–‡ã«ã¤ã„ã¦ï¼Œï¼ˆ1ï¼‰è§£æžï¼Œå®Ÿè¡Œï¼Œå–ã‚Šå‡ºã—ã®å›žæ•°ï¼Œï¼ˆ2ï¼‰CPUå‡¦ç†æ™‚é–“ã‚„çµŒéŽæ™‚é–“ï¼Œï¼ˆ3ï¼‰ç‰©ç†çš„ãªèªã¿è¾¼ã¿ã¨è«–ç†çš„ãªèªã¿è¾¼ã¿ã®ãƒ–ãƒãƒƒã‚¯æ•°ï¼Œï¼ˆ4ï¼‰å‡¦ç†ã—ãŸãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ãªã©ãŒèª¿ã¹ã‚‰ã‚Œã¾ã™ã€‚ ãƒˆãƒ¬ãƒ¼ã‚¹ã‚’å–å¾—ã™ã‚‹æ–¹æ³•ã¯ï¼Œä¸»ã«2é€šã‚Šã‚ã‚Šã¾ã™ã€‚ä¸€ã¤ã¯ç¾è¡Œã‚»ãƒƒã‚·ãƒ§ãƒ³ã®ãƒˆãƒ¬ãƒ¼ã‚¹ã‚’å–ã‚‹æ–¹æ³•ï¼Œã‚‚ã†ä¸€ã¤ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹å…¨ä½“ã®ãƒˆãƒ¬ãƒ¼ã‚¹ã‚’å–ã‚‹æ–¹æ³•ã§ã™ã€‚ å‰è€…ã¯ï¼Œâ€œALTER SESSION SET sql_trace = trueâ€ã¨ã„ã†SQLæ–‡ã‚’å®Ÿ
t_ita 2010/12/07
oracle

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

sql

ãƒˆãƒ¬ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
åœ°ç„ã®ã‚ˆã†ã«ã‚ˆãã‚ã‹ã‚‹SQLãƒ†ãƒ¼ãƒ–ãƒ«çµåˆ - ã“ã›ãã®æŠ€è¡“æ—¥è¨˜
ãƒ†ãƒ¼ãƒ–ãƒ«ã®JOINãŒè‹¦æ‰‹ã§ã—ãŸãŒã€ã“ã®ä¾‹ã‚’æ€ã„ã¤ã„ã¦ã‹ã‚‰ã¯ã€ã™ã£ãã‚Šãã£ãã‚Šç†è§£ã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ã‚€ã—ã‚é ã‹ã‚‰é›¢ã‚Œã¾ã›ã‚“â€¦â€¦ã€‚ â€» INNERã€OUTERã¯é£¾ã‚Šã€‚çœç•¥ã§ãã‚‹ã€‚ INNER JOIN â†’ JOIN LEFT OUTER JOIN â†’ LEFT JOIN RIGHT OUTER JOIN â†’ RIGHT JOIN â€» ON ...=... ã‚’ã¾ã¨ã‚ã¦ USING(å±žæ€§) ã¨æ›¸ã‘ã‚‹ã€‚ â€» ä½•ã§çµåˆã™ã‚‹ã‹è¨€ã†ã¾ã§ã‚‚ãªã„æ™‚ã¯ã€NATURALã‚’æŒ‡å®šã™ã‚‹ã¨å‹æ‰‹ã«JOINã—ã¦ãã‚Œã‚‹ã€‚NATURALã«JOINã—ã¦â€¦â€¦ã€‚ â€» WHEREã¯çµåˆã—ãŸçµæžœã«ä½œç”¨ã™ã‚‹ã€‚ â€» ç¾å®Ÿã«ã¯ä¸Šå›³ã®ã‚ˆã†ã«1å¯¾1ã§çµåˆã—ã¾ã›ã‚“ã€‚ â€» ãŠã¾ã‘ã€‚CROSS JOINã€‚ ã“ã‚“ãªã®ä½¿ã„ã¾ã›ã‚“ã€‚ ãƒ–ã‚¯ãƒžç”¨ç”»åƒã€‚
t_ita 2010/09/17
ã‚ã‚Œï¼Ÿã‚³ãƒ³ã‚½ãƒ¼ãƒ«ç”»é¢ãŒæ›‡ã£ã¦JOINã§ããªã„ã‚ˆâ€¦ï¼Ÿ

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

sql

ãƒã‚¿

DB
ãƒªãƒ³ã‚¯
NoSQLã¨SQLã«ã¤ã„ã¦ - SQLer ç”Ÿå³¶å‹˜å¯Œ ã®ãƒ–ãƒã‚°
NoSQLï¼ˆNot Only SQLï¼‰ã¨ã¯ã€SQLã‚’ä½¿ã‚ãªã„KVSï¼ˆKey Value Storeï¼‰ãªã©ã‚’æŒ‡ã—ã¾ã™ãŒã€æœ€è¿‘æµè¡Œã®ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã§ã™ã€‚ä»Šæ—¥ã¯NoSQLã«ã¤ã„ã¦ã€‚ SQLã¯è‹±èªžã§ã‚ã‚Šä»•æ§˜æ›¸ã§ã‚ã‚‹ SQLã¯è‹±èªžã§ã‚ã‚Šä»•æ§˜æ›¸ã§ã‚ã‚‹ã€‚ã¨æ›¸ã„ã¦ãã¾ã—ãŸã€‚ SQLã¯ã€ãƒ—ãƒã‚°ãƒ©ãƒ ï¼ˆã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ï¼‰ã‚’çµ„ã‚€ã“ã¨ãŒã§ããªã„æ–‡ç³»ã®äº‹å‹™å“¡ãŒã€è‹±èªžçš„è¨˜è¿°ã§æ›¸ã‘ã°çµæžœãŒå¾—ã‚‰ã‚Œã‚‹ã¨ã„ã†ã‚‚ã®ã§ã™ã€‚SQLæ–‡ä¸ã«ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã¯å˜åœ¨ã—ã¾ã›ã‚“ã€‚ ä¾‹ãˆã°ã€æ¬¡ã®ã‚ˆã†ãªãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã”ç”¨æ„ãã ã•ã„ã€‚ TEST_TABLE ID NUMBER ä¸»ã‚ãƒ¼ NAME VARCHAR(20) IDã«1ã‹ã‚‰1,000,000 NAME åå‰ã®ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ ã“ã®100ä¸‡ä»¶ã®ãƒ‡ãƒ¼ã‚¿ãŒå…¥ã£ãŸã“ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ ï¼‘ï¼‰ SELECT * FROM TEST_TABLE WHERE ID = 1 ï¼’ï¼‰ SELECT * FROM TEST_TABLE WHE
t_ita 2010/06/09
sql

nosql
ãƒªãƒ³ã‚¯
NoSQLç™»å ´ã®èƒŒæ™¯ã€CAPå®šç†ã€ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã®åˆ†é¡ž
ãã®ä¾‹ã¨ã—ã¦Beckæ°è‡ªèº«ãŒéŽåŽ»ã«å–ã‚Šçµ„ã‚“ã§ããŸç”Ÿå‘½ä¿é™ºä¼šç¤¾ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä¾‹ã«æŒ™ã’ã¾ã™ã€‚ãã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã¯æ¯Žæ—¥ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãŒå¤‰åŒ–ã™ã‚‹ãŸã‚ã€SQLã¨ORM(Object-Relational Mappingï¼‰ã§ã¯å¯¾å¿œã§ããšã€ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®Gemstoneã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ã§å¯¾å¿œã§ããŸã¨è¿°ã¹ã¦ã„ã¾ã™ã€‚ ã“ã†ã—ãŸSQLã ã‘ã§ã¯æº€ãŸã›ãªã„ã•ã¾ã–ã¾ãªè¦ä»¶ã€ä¸Šè¨˜ã®å›³ã«ã‚ã‚‹ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžã®å¯å¡‘æ€§ã€ã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ãƒ«ãªãƒ‡ãƒ¼ã‚¿èªã¿è¾¼ã¿ã€æ›¸ãè¾¼ã¿ã€å‡¦ç†ã®æŸ”è»Ÿæ€§ãªã©ã‚’æº€ãŸã™ãŸã‚ã«ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä»¥å¤–ã®NoSQLãªè£½å“ãŒé–‹ç™ºã•ã‚ŒãŸã€‚ã“ã‚ŒãŒNoSQLã®ç™»å ´ã®èƒŒæ™¯ã«ã‚ã‚‹ã¨Beckæ°ã¯è§£èª¬ã—ã¾ã™ã€‚ä¸€æ–¹ã§ã€ã“ã†ã—ãŸã•ã¾ã–ã¾ãªNoSQLã‚’ã€NoSQLã¨ã„ã†è¨€è‘‰ã§è¡¨ã™ã®ã¯é©å½“ã§ã¯ãªã„ã¨ã„ã†æ†‚æ…®ã‚‚ç¤ºã—ã¦ã„ã¾ã™ã€‚ Here is where the futility of defining NoSQ
t_ita 2010/03/18
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

NoSQL

SQL

DBMS
ãƒªãƒ³ã‚¯
InfoQ: Neo4j: Java ãƒ™ãƒ¼ã‚¹ã®éž SQL ã‚°ãƒ©ãƒ•ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
Spring Bootã«ã‚ˆã‚‹APIãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰æ§‹ç¯‰å®Ÿè·µã‚¬ã‚¤ãƒ‰ ç¬¬2ç‰ˆ ä½•åƒäººã‚‚ã®é–‹ç™ºè€…ãŒã€InfoQã®ãƒŸãƒ‹ãƒ–ãƒƒã‚¯ã€ŒPractical Guide to Building an API Back End with Spring Bootã€ã‹ã‚‰ã€Spring Bootã‚’ä½¿ã£ãŸREST APIæ§‹ç¯‰ã®åŸºç¤Žã‚’å¦ã‚“ã ã€‚ã“ã®æœ¬ã§ã¯ã€å‡ºç‰ˆæ™‚ã«æ–°ã—ããƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚ã‚‹ Spring Boot 2 ã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ã€‚ã—ã‹ã—ã€Spring Boot3ãŒæœ€è¿‘ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã€é‡è¦ãªå¤‰...
t_ita 2010/03/03
ã‚°ãƒ©ãƒ•

ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹

graph

java

sql

db
ãƒªãƒ³ã‚¯
ã‚¦ãƒŽã‚¦ãƒ©ãƒœ Unoh Labs: RDBã§éšŽå±¤æ§‹é€ ã‚’æ‰±ã†ã«ã¯ï¼Ÿ
yukiã§ã™ã€‚ãƒ€ã‚¤ã‚¨ãƒƒãƒˆã‚’å§‹ã‚ã¦3kgæ¸›ã£ãŸã¨æ€ã£ãŸã‚‰ã€é¢¨é‚ªã‚’å¼•ã„ã¦è¦‹äº‹ã«1kgå¢—é‡ã€‚ é‹å‹•ã—ãªã„ã¨é§„ç›®ã§ã™ãã€‚ã‚ã¨æ®‹ã‚Š20kgã€é“ã®ã‚Šã¯é ã„ã§ã™ã€‚ ã•ã¦ä»Šå›žã¯ã€ã€ŒRDBã§éšŽå±¤æ§‹é€ ã‚’æ‰±ã†ã«ã¯ï¼Ÿã€ã§ã™ã€‚ ã‚ã‚‹ã‚µã‚¤ãƒˆã‚’æ§‹ç¯‰ä¸ã«éšŽå±¤æ§‹é€ ã‚’ã‚‚ã£ãŸã‚«ãƒ†ã‚´ãƒªæ§‹é€ ã«ã™ã‚‹ã“ã¨ã«ãªã‚Šã€ã©ã®ã‚ˆã†ã«DBã§æ‰±ã†ã‹æ‚©ã¿ã¾ã—ãŸã€‚ DBã¯MySQLã‚’æŽ¡ç”¨ã—ã¦ã„ãŸã®ã§ã€ã“ã®æ™‚ç‚¹ã§ã±ã£ã¨é ã«æµ®ã‹ã‚“ã é¸æŠžè‚¢ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªã‚‚ã®ã§ã—ãŸã€‚ XML-DBã‚’åˆ©ç”¨ã™ã‚‹ è¦ªã‚«ãƒ†ã‚´ãƒªãƒ¬ã‚³ãƒ¼ãƒ‰ã®ãƒ—ãƒ©ã‚¤ãƒžãƒªIDã‚’åã‚«ãƒ†ã‚´ãƒªãƒ¬ã‚³ãƒ¼ãƒ‰ã«æŒãŸã›ã‚‹ è¦ªã‚’å«ã‚ãŸã€Žçµ¶å¯¾ãƒ‘ã‚¹ã€ã‚’åç§°ã¨ã—ã¦æ‰±ã„ã€å–ã‚Šå‡ºã—ãŸå¾Œã«ãƒ‘ãƒ¼ã‚¹ ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã«åŒæ§˜ã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªæ§‹é€ ã‚’ä½œã‚Šã€æ¯Žå›žãƒ‘ãƒ¼ã‚¹ã™ã‚‹ (1)ã®XMLDBã¯ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®eXistã‚„Xindiceã€Yggdrasillãªã©æ§˜ã€…ãªé¸æŠžè‚¢ãŒã‚ã‚Šã¾ã—ãŸãŒã€ã‚«ãƒ†ã‚´ãƒªã®ã¿ã®åˆ©ç”¨ãªå‰²ã«ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã‚³ã‚¹ãƒˆãŒé«˜ã™ãŽã‚‹ã®ã§è¦‹é€ã‚Šã¾
t_ita 2010/01/25
SQL
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒã‚’è¤‡æ•°å°æ§‹æˆã¨ã‹2010å¹´ä»£ã«ã¯æµè¡Œã‚‰ãªã„ - blog.nomadscafe.jp
å¥¥ä¸€ç©‚ã•ã‚“ã®ã€Œã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚µãƒ¼ãƒã‚’è¤‡æ•°å°æ§‹æˆã¨ã‹2010å¹´ä»£ã«ã¯æµè¡Œã‚‰ãªã„ã€ã«ãƒ•ã‚©ãƒãƒ¼ã®ã‚ˆã†ãªæ„Ÿã˜ã§ã€‚ ä¾‹ã«ã‚ˆã£ã¦ã‚¿ã‚¤ãƒˆãƒ«ã¯ç…½ã‚Šã§ã™ã€‚ å¥¥ä¸€ç©‚ã•ã‚“ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã§ã¯ã€ã€Œ5,000ä¸‡PV/Monthã€ã¨ã„ã†è¦‹ç©ã‚‚ã‚Šã§ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚µãƒ¼ãƒã®å°æ•°ã‚’1å°ã¨è¨ˆç®—ã—ã¦ã„ã¾ã™ãŒã€ã“ã‚Œã‹ã‚‰ã¯ã€Œ1,000ä¸‡PV/Dayã€ã‚’è¶…ãˆã‚‹ã‚µã‚¤ãƒˆãŒå¤šãç”Ÿã¾ã‚Œã¦ãã‚‹ã¨äºˆæƒ³ã—ã¦ã„ã¾ã™ã€‚ã©ã‚“ãªã‚µã‚¤ãƒˆã‹ã¨ã„ã†ã¨ã€mixiã‚¢ãƒ—ãƒªã‚„ãƒ¢ãƒã‚²ãƒ¼ãªã©ã«ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã‚’æä¾›ã™ã‚‹ã‚µã‚¤ãƒˆã§ã™ã€‚ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã‚µã‚¤ãƒˆã®ã‚ãƒ£ãƒ‘ã‚·ãƒ†ã‚£ãƒ—ãƒ©ãƒ³ãƒ‹ãƒ³ã‚°ã«ã¤ã„ã¦ã¯ä¸æ¾¤ã•ã‚“ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ãŒå‚è€ƒã«ãªã‚Šã¾ã™ã€‚ The Art of ãƒ¢ãƒã‚²ãƒ¼ Capacity Planning The Art of Mixi-mobile-appli Capacity Planning æœ€ã‚‚äººæ°—ãŒã§ãŸå ´åˆã«ã¯æ•°åƒä¸‡ã‹ã‚‰æ•°å„„PV/Dayã¨ã„ã†æ•°å—ãŒãªã‚‰ã‚“ã§ã„ã¾ã™ã€‚æ€–ã„æ€–
t_ita 2010/01/14
sql

performance

é‹ç”¨

database

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
SQLã§æœ¨ã¨éšŽå±¤æ§‹é€ ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†â€•â€•å…¥ã‚Œåé›†åˆãƒ¢ãƒ‡ãƒ«
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
t_ita 2007/09/03
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ãƒ‡ãƒ¼ã‚¿æ§‹é€

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

sql

db

æœ¨æ§‹é€
ãƒªãƒ³ã‚¯
çª“ã®æœ - ã€NEWSã€‘SQLæ–‡ã‚’GUIã§ä½œæˆã§ãã‚‹ãƒ•ãƒªãƒ¼ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºç’°å¢ƒã€Œé»’çŒ« SQL Studioã€
GUIã«ã‚ˆã‚‹SQLæ–‡ã®ä½œæˆãªã©ã€ã•ã¾ã–ã¾ãªé–‹ç™ºæ”¯æ´æ©Ÿèƒ½ã‚’å‚™ãˆã‚‹SQLé–‹ç™ºç’°å¢ƒã€Œé»’çŒ« SQL Studioã€v1.1.7.413ãŒ6æœˆ4æ—¥ã«å…¬é–‹ã•ã‚ŒãŸã€‚Windows 2000/XPã«å¯¾å¿œã—ã¦ãŠã‚Šã€å€‹äººä½¿ç”¨ãƒ»æ¥å‹™ã«ã‹ã‹ã‚ã‚‰ãšãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆã¨ã—ã¦åˆ©ç”¨å¯èƒ½ã€‚ç¾åœ¨ä½œè€…ã®ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã‚‹ã€‚ ã€Œé»’çŒ« SQL Studioã€ã¯ã€SQLæ–‡ã®ä½œæˆã‚„ãƒ†ã‚¹ãƒˆã‚’è¡Œãˆã‚‹æ±Žç”¨ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºç’°å¢ƒã€‚æœ¬ã‚½ãƒ•ãƒˆä¸Šã‹ã‚‰OLE DBæŽ¥ç¶šã¾ãŸã¯ODBCãƒ‰ãƒ©ã‚¤ãƒã«å¯¾å¿œã™ã‚‹å„ç¨®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ç›´æŽ¥æŽ¥ç¶šå¯èƒ½ã§ã€ä½œæˆã—ãŸSQLæ–‡ã‚’å®Ÿéš›ã«ãƒ†ã‚¹ãƒˆå®Ÿè¡Œã§ãã‚‹ã€‚ç”»é¢ã¯3ãƒšã‚¤ãƒ³æ§‹æˆã§ã€å·¦å´ã«ã¯è¤‡æ•°ã®SQLã‚½ãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç®¡ç†ã§ãã‚‹ãƒ•ã‚¡ã‚¤ãƒ©ãƒ¼ã€ä¸å¤®ã«ã¯è¤‡æ•°ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚¿ãƒ–ã§åˆ‡ã‚Šæ›¿ãˆã¦è¡¨ç¤ºã§ãã‚‹ã‚¨ãƒ‡ã‚£ã‚¿ãƒ¼ã€å³å´ã«ã¯æŽ¥ç¶šã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ§‹é€ ã‚’ãƒ„ãƒªãƒ¼ã¨ãƒªã‚¹ãƒˆã§è¡¨ç¤ºã™ã‚‹â€œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ã‚¯ã‚¹ãƒ—ãƒãƒ¼ãƒ©â€ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã€‚ SQLæ–‡ã®ä½œæˆæ™‚ã¯ã€ã•ã¾ã–
t_ita 2007/07/05
sql

ä¾¿åˆ©ãƒ„ãƒ¼ãƒ«
ãƒªãƒ³ã‚¯
1