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

jjzak id:jjzak

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

${{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ãƒ†ãƒ¼ãƒ–ãƒ«çµåˆ - ã“ã›ãã®æŠ€è¡“æ—¥è¨˜
ãƒ†ãƒ¼ãƒ–ãƒ«ã®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ã€‚ ã“ã‚“ãªã®ä½¿ã„ã¾ã›ã‚“ã€‚ ãƒ–ã‚¯ãƒžç”¨ç”»åƒã€‚
jjzak 2011/02/20
sql

db

tutorial

tips
ãƒªãƒ³ã‚¯
Oracleã®SQLã‚³ãƒžãƒ³ãƒ‰
Oracleã®SQLã‚³ãƒžãƒ³ãƒ‰ 2006.08.01 Oracle ã‚ˆãä½¿ã†Oracle8iã®ã‚³ãƒžãƒ³ãƒ‰ã‚’ãƒ¡ãƒ¢ã€‚Oracle10iã§ã‚‚ã»ã¼åŒã˜ã€‚ Oracle SQL*Plusç·¨ Oracle ç®¡ç†ç·¨ Oracle SQLç·¨ Oracle ã‚¨ãƒ©ãƒ¼ç·¨ ã€SQL*Plusç·¨ã€‘ â– ã‚·ã‚§ãƒ«ã‹ã‚‰SQL/PLUSã‚’ä½¿ã† $ sqlplus /nolog â– ãƒã‚°ã‚¤ãƒ³ã™ã‚‹ ã„ãã¤ã‹ã®æ–¹æ³•ãŒã‚ã‚‹ã€‚ conn sys as sysdba conn / as sysdba conn sys/change_on_install conn system/manager conn scott/tiger conn scott ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†è€…ãƒ¦ãƒ¼ã‚¶ãƒ¼ SYSãƒ¦ãƒ¼ã‚¶ãƒ¼ï¼šç®¡ç†ã«é‡è¦ãªãƒ‡ãƒ¼ã‚¿ãƒ»ãƒ‡ã‚£ã‚¯ã‚·ãƒ§ãƒŠãƒªã‚’æ‰€æœ‰ã—ã¦ã„ã‚‹ã€‚ SYSTEMãƒ¦ãƒ¼ã‚¶ãƒ¼ï¼šç®¡ç†æƒ…å ±ãŒå«ã¾ã‚Œã‚‹è¡¨ã‚„ãƒ“ãƒ¥ãƒ¼ã‚’æ‰€æœ‰ã—ã¦ã„ã‚‹ã€‚ ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®ç†ç”±ã‹ã‚‰SYSãƒ¦ãƒ¼ã‚¶
jjzak 2011/02/20
oracle

sql

database

db

tips
ãƒªãƒ³ã‚¯
NOSQL Patternsã€å’Œè¨³ - @katzchang.contexts
http://horicky.blogspot.com/2009/11/nosql-patterns.html 11/30æ™‚ç‚¹ã§ã€ä¸€é€šã‚Šç¿»è¨³ã®ã†ã¡ã€æ£ç›´ãƒ™ãƒ¼ã‚¹ã®ã–ã£ãã‚Šæ„Ÿè¦šï¼ˆæ¥ç•Œç”¨èªžï¼‰ã§75%å®Œäº†ã§ã™ã€‚ æœ¬äººã‚‚ç†è§£ãŒæ€ªã—ã„ãªãŒã‚‰è¨³ã—ã¦ã„ã‚‹ã®ã§ã€éšæ‰€ã«é–“é•ã„ã‚’ä»•è¾¼ã‚“ã§ã„ã¾ã™ã€‚ã”æŒ‡æ‘˜é ‚ã‘ã‚Œã°å¹¸ã„ã§ã™ã€‚ NOSQL Patterns ã“ã“æ•°å¹´ã€å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸æ©Ÿæ§‹ãŒç™ºå±•ã—ã¦ã„ã‚‹ã€‚ã“ã‚Œã‚‰ã®æ©Ÿæ§‹ã¯å¾“æ¥ã®RDBMSãƒ¢ãƒ‡ãƒ«ã¨ã¯ç•°ãªã£ã¦ãŠã‚Šã€NOSQLã¨ã‚‚å‘¼ã°ã‚Œã¦ã„ã‚‹ã€‚ã‚ãƒ¼ãƒ—ãƒ¬ã‚¤ãƒ¤ãƒ¼ã¨ã—ã¦ã¯ï¼š GoogleBigTable, HBase, Hyperta ble AmazonDynano, Voldemort, Cassendra, Riak Redis CouchDB, Mongo DB ã“ã‚Œã‚‰ã¯ã€æ¬¡ã®å…±é€šç‚¹ã‚’æŒã£ã¦ã„ã‚‹ã€‚ Key-Valueã‚¹ãƒˆã‚¢ å¤šæ•°å°ã®ä¸€èˆ¬çš„ãªPCã§é‹ç”¨å¯èƒ½ è¤‡æ•°ã‚µãƒ¼
jjzak 2010/08/24
sql

nosql

datastore

database

db
ãƒªãƒ³ã‚¯
http://www.shudo.net/publications/NoSQL-data-model-200912/
jjzak 2010/08/24
database

db

nosql
ãƒªãƒ³ã‚¯
key-valueã‚¹ãƒˆã‚¢ã®åŸºç¤ŽçŸ¥è˜
é¦–è—¤ ä¸€å¹¸ Last-updated: January 5, 2010 æ³¨: ã“ã®ãƒšãƒ¼ã‚¸ã®æ–‡ç« ã¯ Software Design èªŒ 2010å¹´ 2æœˆå·ã«æŽ²è¼‰ã•ã‚ŒãŸä»¥ä¸‹ã®è¨˜äº‹ã®å…ƒåŽŸç¨¿ã§ã™ã€‚ Software Design èªŒç·¨é›†éƒ¨ã®äº†æ‰¿ã®å…ƒã«ã€æœ¬ã‚¦ã‚§ãƒ–ãƒšãƒ¼ã‚¸ã«æŽ²è¼‰ã—ã¦ãŠã‚Šã¾ã™ã€‚ é¦–è—¤ä¸€å¹¸: "key-valueã‚¹ãƒˆã‚¢ã®åŸºç¤ŽçŸ¥è˜", Software Design 2010å¹´ 2æœˆå·, p.14-21, (æ ª)æŠ€è¡“è©•è«–ç¤¾, 2010å¹´ 1æœˆ 18æ—¥ ã‚¯ãƒ©ã‚¦ãƒ‰ã€ç‰¹ã«PaaSå‘ã‘ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™ºãŒç¾å®Ÿã®ã‚‚ã®ã¨ãªã‚Šã€ ãã“ã§ã¯ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯é•ã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒ å‹¢ã„ã‚’å¢—ã—ã¦ã„ã¾ã™ã€‚ ãã®ä»£è¡¨ã§ã‚ã‚‹key-valueã‚¹ãƒˆã‚¢ã‚’è§£èª¬ã—ã¾ã™ã€‚ ã‚‚ãã˜ key-valueã‚¹ãƒˆã‚¢ã¨ã¯ ãªãœkey-valueã‚¹ãƒˆã‚¢ã‹ key-valueã‚¹ãƒˆã‚¢ã®ä½¿ã„ã©ã“ã‚ key-valueã‚¹ãƒˆã‚¢ã¨NoSQLã®
jjzak 2010/08/24
tutorial

column

database

key-value

nosql

architecture

research

db
ãƒªãƒ³ã‚¯
ï¿½Linux/DB Tuning (DevSumi2010, Japanese)
1. é«˜æ€§èƒ½ãƒ»å®‰å®šé‹ç”¨ã®ãŸã‚ã® Linux/DB ã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ / é‹ç”¨æŠ€è¡“ æ¾ä¿¡ å˜‰ç¯„ (MATSUNOBU Yoshinori) ã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºæ ªå¼ä¼šç¤¾ ãƒ—ãƒªãƒ³ã‚·ãƒ‘ãƒ« MySQL ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒˆ 2. ãƒ—ãƒãƒ•ã‚£ãƒ¼ãƒ« 2006 å¹´ 9 æœˆã‹ã‚‰ MySQL->Sun(-> ã‚ªãƒ©ã‚¯ãƒ« ) ã§ MySQL ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒˆã¨ã—ã¦å‹¤å‹™ ä¸»ãªè‘—æ›¸ Linux-DB ã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ / é‹ç”¨å…¥é–€ ç¾å ´ã§ä½¿ãˆã‚‹ MySQL Java ãƒ‡ãƒ¼ã‚¿ã‚¢ã‚¯ã‚»ã‚¹å®Ÿè·µè¬›åº§ Twitter: matsunobu Blog: http://opendatabaselife.blogspot.com * ä»Šå›žã®è³‡æ–™ã¯å…¬é–‹ã—ã¾ã™ * MySQL ç”¨èªžãŒã‚ã¡ã“ã¡ã«å‡ºã¾ã™ãŒã€ çµŒé¨“ã®ç„¡ã„æ–¹ã«ã‚‚åˆ†ã‹ã‚‹ã‚ˆã†ã«é…æ…®ã—ã¦ã„ãã¤ã‚‚ã‚Šã§ã™ 3. å®‰å®šç¨¼åƒã¨é«˜æ€§èƒ½ã‚’æ”¯ãˆã‚‹è¦ç´ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å±¤ã«é–¢ã™ã‚‹æŠ€è¡“ ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è¨
jjzak 2010/08/24
é«˜æ€§èƒ½ãƒ»å®‰å®šé‹ç”¨ã®ãŸã‚ã® Linux/DB ã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ / é‹ç”¨æŠ€è¡“ æ¾ä¿¡ å˜‰ç¯„ (MATSUNOBU Yoshinori) ã‚µ

database

db

performance

linux

mysql
ãƒªãƒ³ã‚¯
http://homepage2.nifty.com/yoks/TechNote/H2/H2_MnFrm.htm
jjzak 2010/08/24
database

db

development

java

h2
ãƒªãƒ³ã‚¯
Oracle ã® B*Tree ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®å†…éƒ¨æ§‹é€ ã«ã¤ã„ã¦ãŠå‹‰å¼·ä¸ï¼ˆãã®ï¼‘ï¼‰
ãŠä»•äº‹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸€å¼ã®ãƒªãƒ¼ã‚¹åˆ‡ã‚Œé–“è¿‘ã¨ã„ã†ã“ã¨ã§ã€ãƒªãƒ¼ã‚¹å»¶é•·ã§è€ãˆã‚‹ã“ã¨ãŒã§ãã‚‹ã®ã‹ã€ãã‚Œã¨ã‚‚ã‚·ã‚¹ãƒ†ãƒ æ›´æ”¹ãŒå¿…è¦ãªã®ã‹ã‚’è¦‹æ¥µã‚ã‚‹ãŸã‚ã€æœ€è¿‘ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å‘¨ã‚Šã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã°ã‹ã‚Šã‚„ã£ã¦ã¾ã™ã€‚ å½“åˆè¨è¨ˆæ™‚ã«ã€ï¼•å¹´é–“æŒã¤è¨è¨ˆã‚’ã—ãŸã®ã§ã™ãŒã€æµçŸ³ã«ï¼•å¹´ç›®ã«ã‚‚ãªã‚‹ã¨äºˆå®šã¨ã¯ãã‚Œãªã‚Šã«ä¹–é›¢ãŒç™ºç”Ÿã™ã‚‹ã‚‚ã®ã§ã™ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ï¼†ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è¨è¨ˆã‚’ãƒ¦ãƒ¼ã‚¶å‘ã‘ã®å‡¦ç†ã‚’ã¨ã«ã‹ãé«˜é€Ÿã«å‡¦ç†ã§ãã‚‹ã‚ˆã†ã«è¨è¨ˆã—ãŸã®ã§ã€ãƒ¦ãƒ¼ã‚¶å‘ã‘ã®å‡¦ç†ã¯é€Ÿåº¦çš„ã«å…¨ç„¶å¤§ä¸ˆå¤«ãªã®ã§ã™ãŒã€ãƒ‡ãƒ¼ã‚¿ã®è‚¥å¤§åŒ–ã«ã‚ˆã‚‹ãƒãƒƒãƒå‡¦ç†ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹åŠ£åŒ–ãŒé¡•è‘—ã§ã™ã€‚å˜ç´”ã«ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã¨ CPU ãƒ‘ãƒ¯ãƒ¼ãŒè¶³ã‚Šã¦ã„ãªã„ã®ã§ã—ã‚‡ã†ã€‚ ã—ã‹ã—ãªãŒã‚‰ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ä½™åœ°ã¯ã¾ã ã¾ã ååˆ†ã«ã‚ã‚Šãã†ã§ã™ã€‚ãƒãƒƒãƒå‘ã‘ã®æœ€é©åŒ–ã‚’å›³ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ã†ã¾ãã„ã‘ã°æ¥å¹´åº¦ã©ã“ã‚ã‹ã€å¾Œæ•°å¹´ã¯ãƒªãƒ¼ã‚¹å»¶é•·ã§å»¶å‘½ã§ãã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ä»Šå›žå®Ÿæ–½ã—ãŸãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ï¼‘ã¤ã®ãƒã‚¤ãƒ³ãƒˆã¨ã—ã¦ã€ãƒãƒƒãƒå‡¦ç†å‘
jjzak 2009/11/14
database

development

db

algorithm
ãƒªãƒ³ã‚¯
ç±³å¤§çµ±é ˜é¸ã§MySQLã¯ã©ã®ã‚ˆã†ã«ä½¿ã‚ã‚ŒãŸã®ã‹
æ—¥æœ¬ã®è¡†è°é™¢é¸æŒ™ãŒé–“è¿‘ã«è¿«ã£ã¦ã„ã¾ã™ãŒã€æ˜¨å¹´ç±³å›½ã§è¡Œã‚ã‚ŒãŸå¤§çµ±é ˜é¸ã«ãŠã„ã¦ã€ã‚ªãƒãƒžé™£å–¶ãŒIT æŠ€è¡“ã‚’é§†ä½¿ã—ãŸã¨ã„ã†è©±ã¯ã‚ˆãçŸ¥ã‚‰ã‚Œã¦ã„ã¾ã™ã€‚MySQLã‚‚ã‚‚ã¡ã‚ã‚“ä½¿ã‚ã‚Œã¦ã„ã¾ã—ãŸã€‚ä»Šå¹´4æœˆã«ã‚µãƒ³ã‚¿ã‚¯ãƒ©ãƒ©ã§é–‹å‚¬ã•ã‚ŒãŸMySQL Conference & Expo 2009ã¨ã„ã†ã‚¤ãƒ™ãƒ³ãƒˆã§ã¯ã€æœ€çµ‚æ—¥ã®ã‚ãƒ¼ãƒŽãƒ¼ãƒˆã«ãŠã„ã¦ã€Obama Tech Teamã®æ–¹ã€…ã‚ˆã‚Šã€å¤§çµ±é ˜é¸ã«ãŠã„ã¦MySQLãŒã„ã‹ã«ä½¿ã‚ã‚ŒãŸã‹ã¨ã„ã†ç™ºè¡¨ãŒè¡Œã‚ã‚Œã¾ã—ãŸã€‚ æœ¬å½“ã¯ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹çµ‚äº†å¾Œã«ã™ãã¡ã‚ƒã‚“ã¨ã—ãŸãƒ¬ãƒãƒ¼ãƒˆã‚’æ›¸ã„ã¦å…¬é–‹ã™ã‚‹äºˆå®šã ã£ãŸã®ã§ã™ãŒã€ãã®é€±ã«èµ·ã“ã£ãŸè‰ãªãŽå‰›é€®æ•ã¨ã‹ã€ãã®ã»ã‹ã®å‡ºæ¥äº‹ã«ã™ã£ã‹ã‚Šæ°—ã‚’å–ã‚‰ã‚Œã¦æ”¾ç½®ã—ã¦ã„ã¾ã—ãŸã€‚Blogã‚’å§‹ã‚ãŸå¥‘æ©Ÿã«Twitterã®ä¸ã§èˆˆå‘³ã‚’æŒã£ã¦ã„ã‚‹æ–¹ãŒã„ã‚‹ã‹ã©ã†ã‹èžã„ãŸã¨ã“ã‚ã€ãã“ãã“ã®æ–¹ãŒèˆˆå‘³ã‚’ç¤ºã—ãŸã®ã§ã€ã“ã“ã§ç°¡å˜ã«ã¾ã¨ã‚ãŸãƒ¡ãƒ¢ã‚’å…¬é–‹ã™ã‚‹ã“ã¨ã«ã—ã¾ã™ã€‚ â—ãƒãƒ¼ãƒ ãƒ¡ãƒ³ãƒãƒ¼ ç™ºè¡¨è€…ã¯
jjzak 2009/09/19
howto

database

db

mysql

architecture
ãƒªãƒ³ã‚¯
MyNA Web Site
Home è³‡æ–™ç½®ãå ´ ä½œè€…ãƒ—ãƒãƒ•ã‚£ãƒ¼ãƒ« â€ æ°åï¼šæ¾ä¿¡ å˜‰ç¯„ (MATSUNOBU Yoshinori) æ‰€å±žï¼šã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºæ ªå¼ä¼šç¤¾ å½¹å‰²ï¼šMySQLã®ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚° Blogï¼šhttp://opendatabaselife.blogspot.com/ Twitterï¼šhttp://twitter.com/matsunobu â†‘
jjzak 2009/08/16
tips

reference

database

db

mysql
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
jjzak 2009/07/20
programming

performance

tips

development

database

db

sql
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
jjzak 2009/07/12
programming

tips

mysql

sql

database

db

algorithm
ãƒªãƒ³ã‚¯
ãƒ‰ãƒ¡ã‚¤ãƒ³ãƒã‚¸ãƒƒã‚¯ã¨SQL
ä»¥ä¸‹ã®æ–‡ç« ã¯ã€Martin Fowler ã«ã‚ˆã‚‹ Domain Logic and SQL ã®æ—¥æœ¬èªžè¨³ã§ã‚ã‚‹ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŒ‡å‘ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™ºè€…ã¨ãƒ¡ãƒ¢ãƒªä¸Š(in-memory)ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™ºè€…ã¨ã®é–“ã®ã‚®ãƒ£ãƒƒãƒ—ã¯ã€ã“ã“æ•°åå¹´ã€å¾ã€…ã«åºƒãŒã£ã¦ãã¦ã„ã‚‹ã€‚ã“ã®ã‚®ãƒ£ãƒƒãƒ—ãŒåŽŸå› ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ©Ÿèƒ½(SQLã‚„ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£)ã‚’ã©ã®ã‚ˆã†ã«æ‰±ãˆã°ã‚ˆã„ã®ã‹ã¨ã„ã†è°è«–ãŒæ•°å¤šãå·»ãèµ·ã“ã£ã¦ã„ã‚‹ã€‚ã“ã“ã§ã¯ã€ãƒ“ã‚¸ãƒã‚¹ãƒã‚¸ãƒƒã‚¯ã‚’ SQL ã«ç½®ãã¹ãã‹ã€ãã‚Œã¨ã‚‚ãƒ¡ãƒ¢ãƒªä¸Šã®ã‚³ãƒ¼ãƒ‰ã«ç½®ãã¹ãã‹ã¨ã„ã£ãŸå•é¡Œã«ã¤ã„ã¦ã€ä¸»ã«ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨æ›´æ–°æ€§ã®è¦³ç‚¹ã‹ã‚‰è€ƒå¯Ÿã‚’è¡Œã†ã€‚è€ƒå¯Ÿã«ã¯ç°¡å˜ãªä¾‹ã‚’ä½¿ã†ãŒã€SQL ã‚¯ã‚¨ãƒªã¯ã—ã£ã‹ã‚Šã¨ã—ãŸã‚‚ã®ï¼ˆrich SQL queriesï¼‰ã‚’ç”¨ã„ã‚‹ã®ã§æ‚ªã—ã‹ã‚‰ãšã€‚ ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ï¼ˆè¨³æ³¨ï¼šä»¥ä¸‹ã€EAï¼‰æ§‹ç¯‰ã«é–¢ã™ã‚‹æœ¬ï¼ˆç§ã®è¿‘è‘—ã€ŽP of EAAã€ãªã©ï¼‰ã‚’èªã‚€ã¨ã€ãƒã‚¸ãƒƒ
jjzak 2009/07/12
programming

development

database

db

design

sql
ãƒªãƒ³ã‚¯
SQLã®åŸºæœ¬ã¨RDBMSã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼ˆRDBMSï¼‰ã¯ï¼Œæ¥å‹™ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ãŠã„ã¦å¿…è¦ä¸å¯æ¬ ãªå˜åœ¨ã§ã™ã€‚ãã®RDBMSã‚’æ“ä½œã™ã‚‹SQLã¯ï¼ŒCè¨€èªžã‚„Javaãªã©ã®æ±Žç”¨ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã¨ãªã‚‰ã‚“ã§ï¼Œãƒ—ãƒã‚°ãƒ©ãƒž/SEã®å¿…é ˆç§‘ç›®ã¨è¨€ãˆã¾ã™ã€‚Part1ã§ã¯ï¼ŒSQLã®åŸºæœ¬ã§ã‚ã‚‹SELECTï¼ŒUPDATEï¼ŒDELETEï¼ŒINSERTã®æ–‡æ³•ã«ã¤ã„ã¦ï¼ŒPart2ã§ã¯å®Ÿç”¨çš„ãªSQLã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’å¦ç¿’ã—ã¾ã™ã€‚Part3ã§ã¯ï¼ŒRDBMSãŒã©ã®ã‚ˆã†ãªåŽŸç†ã§ãƒ‡ãƒ¼ã‚¿ã‚’æ¤œç´¢ã—ã¦ã„ã‚‹ã‹ã‚’å¦ã³ï¼ŒRDBMSã‚’ä½¿ã„ã“ãªã™ãƒ’ãƒ³ãƒˆã‚’ã¤ã‹ã‚“ã§ãã ã•ã„ã€‚ Part1ã€€SQLã®åŸºæœ¬ã‚’ç†è§£ã—ã‚ˆã† Part2ã€€è¤‡é›‘ãªSELECTæ–‡ã‚„SQLé«˜é€ŸåŒ–ã®ã‚³ãƒ„ Part3ã€€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä»•çµ„ã¿ã‚’åŸºç¤Žã‹ã‚‰å¦ã¶
jjzak 2009/07/12
db

database

tutorial

sql
ãƒªãƒ³ã‚¯
SQL (Structured Query Language) in one page : SQL.SU
jjzak 2009/07/12
reference

database

db

cheatsheet

sql
ãƒªãƒ³ã‚¯
iDeaList::Writing
ãƒ•ãƒªãƒ¼ãƒ©ãƒ³ã‚¹ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦ç‹¬ç«‹ã—ã¦ç´„2å¹´ãŒçµŒã¡ã€ã‚ˆã†ã‚„ãæ ªå¼ä¼šç¤¾ã‚¹ãƒ†ãƒ©ãƒ¼ãƒˆ (è‹±èªžè¡¨è¨˜ï¼šSTELLATO, inc.)ã‚’è¨ç«‹ã—ã¾ã—ãŸã€‚ å†…å®¹ãŒé‡è¤‡ã—ã¦ã—ã¾ã„ã¾ã™ã®ã§ã€è©³ã—ãã¯ç§çš„ãªã»ã†ã®ãƒ–ãƒã‚°ã‚’å‚ç…§ã—ã¦ãã ã•ã„ï¼žï¼œ æ€ã„ã®å¤–ã€å¿ƒã®ä¸ã‚’ã¶ã£ã¡ã‚ƒã‘ãŸå†…å®¹ã«ãªã£ã¦ã—ã¾ã£ãŸãŸã‚ã«ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã¯ã“ã¡ã‚‰ã§å…¬é–‹ã™ã‚‹ã®ã‚’ã‚„ã‚ã¾ã—ãŸã€‚ ãƒªãƒ³ã‚¯è¦‹ã‚‹ã®ã‚ã‚“ã©ãã•ã„äººã«å‘ã‘ã¦2è¡Œã§è¦ç´„ã™ã‚‹ã¨ ã¨ã‚Šã‚ãˆãšç¤¾åã‚’ãƒ‘ãƒ³ãƒãƒ©ã‹ã‚¹ãƒ†ãƒ©ãƒ¼ãƒˆã§æ‚©ã‚“ã§ã‚¹ãƒ†ãƒ©ãƒ¼ãƒˆã¨ã„ã†åå‰ã‚’é¸ã³ã¾ã—ãŸã‚ˆãƒ¼ã€‚ ã‚¢ãƒ€ãƒ«ãƒˆç³»ã‚ˆã‚Šã‚‚ã‚¤ã‚¿ãƒªã‚¢èªžã§ã‚ªã‚·ãƒ£ãƒ¬ã¶ã‚Šã¾ã—ãŸï½— ãƒ¯ãƒã‚¹ï½—ï½—ï½— ã¨ã„ã†æ„Ÿã˜ã§ã™ï¼ ã¯ã¦ãƒ€ã¯åŽ»å¹´ã‚ˆã‚Šã‚‚ã†å°‘ã—é »åº¦ã‚’ä¸Šã’ã¦ã€ãªã‚‹ã¹ãæœ‰ç›ŠãªæŠ€è¡“æƒ…å ±è¼‰ã›ã¦ã„ãã‚ˆã†ç¶šã‘ã¦ã„ããŸã„ã¨è€ƒãˆã¦ã„ã¾ã™ï¼ ä»Šã¯cocos2dã‚„Objective-Cã®ã§ãã‚‹ã²ã¨ãŸã¡ã¨ãƒãƒƒã‚«ã‚½ãƒ³ã—ãŸã„ï¼ã‚‚ã£ã¨ç²¾é€²ã—ã¾ã™ï¼ã¦ã¸ãºã‚(ãƒ»Ï‰<)â˜† Heart Beat Â» 2012å¹´
jjzak 2009/06/21
programming

perl

db

blog
ãƒªãƒ³ã‚¯
Account Suspended
Account Suspended This Account has been suspended. Contact your hosting provider for more information.
jjzak 2009/04/14
db

oop

database
ãƒªãƒ³ã‚¯
83's : Gaucheã§MySQL/SQLiteã®å€‹äººçš„ã¾ã¨ã‚
å¤§ä½“ä½¿ã„æ–¹ãŒã‚ã‹ã£ã¦ããŸã€‚Gauche:DBI/DBDè¦‹ã‚Œã° ã‚ã‹ã‚‹ã‘ã©ã€ä¸€å¿œæµã‚Œã‚’ãƒ¡ãƒ¢ã£ã¦ãŠãã€‚ MySQLã®ãƒ‰ãƒ©ã‚¤ãƒã¯DBI | dev | Kahua Projectã‹ã‚‰ã€SQLite3ã®ã¯ãã®ãƒšãƒ¼ã‚¸ã«è¦‹å½“ãŸã‚‰ãªã„ã®ã§uchizonoã«ã‚ã£ãŸã‚‚ã®ã‚’ä½¿ã‚ã›ã¦ã‚‚ã‚‰ãŸã€‚ ãƒ¬ãƒƒãƒ„ãƒ»ã‚³ãƒã‚¯ãƒˆã€‚ (use dbi) (define *mysql-con* (dbi-connect "dbi:mysql:db=test;host=localhost" :username "root" :password "himitsu")) (define *sqlite-con* (dbi-connect "dbi:sqlite3:path/to/db/test.db")) ã‚¯ã‚¨ãƒªã€‚ (let1 q (dbi-prepare *mysql-con* "insert into books (name, pric
jjzak 2009/04/14
scheme

mysql

gauche

sqlite

db

database
ãƒªãƒ³ã‚¯
http://www.mysqlpracticewiki.com/index.php/%E3%83%A1%E3%82%A4%E3%83%B3%E3%83%9A%E3%83%BC%E3%82%B8
jjzak 2009/04/14
tips

wiki

database

db

mysql

performance
ãƒªãƒ³ã‚¯
SQLãƒ©ã‚¤ã‚¯ã«Hadoop Hiveã‚’ä½¿ã„å€’ã™!
ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã‚’åˆ©ç”¨ã™ã‚‹ ä»Šå›žã¯å°‘ã—å‡ã£ãŸãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å®šç¾©ã‚’ã—ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ éƒµä¾¿ç•ªå·ãƒ‡ãƒ¼ã‚¿ã¯æ¯Žæœˆæ›´æ–°ã•ã‚Œã‚‹ã®ã§ã€ãƒ†ãƒ¼ãƒ–ãƒ«æŒ‡å®šæ™‚ã«ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚‚æŒ‡å®šã§ãã‚‹ã‚ˆã†ã«ã—ã¾ã™ã€‚ã“ã®ã‚ˆã†ãªå ´åˆã€Hiveã§ã¯ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã‚’ä½¿ã„ã¾ã™ã€‚ ä»¥ä¸‹ã«éƒµä¾¿ç•ªå·ã‚’ä¿å˜ã™ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã€Œzipã€ã‚’å®šç¾©ã—ã¾ã™ãŒã€æ—¥ä»˜åž‹DATEã®ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³verã‚’è¨å®šã™ã‚‹ã‚ˆã†ã«ã—ã¾ã™ã€‚ hive> CREATE TABLE zip (zip STRING, pref INT, city STRING, town STRING) > PARTITIONED BY (ver DATE) > ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' > LINES TERMINATED BY '\n'; OK Time taken: 0.128 seconds
jjzak 2009/03/22
database

db

mapreduce
ãƒªãƒ³ã‚¯
1 2 3 4 æ¬¡ã®ãƒšãƒ¼ã‚¸