[B! database] hackedã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

hacked id:hacked

databaseã«é–¢ã™ã‚‹hackedã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (22)

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

DWHå°‚ç”¨DBã€ŒGreenplumã€ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ç‰ˆãŒç„¡å„Ÿå…¬é–‹--ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿ã‚¢ãƒ—ãƒªé–‹ç™ºã¸
EMCã‚¸ãƒ£ãƒ‘ãƒ³ã¯2æœˆ8æ—¥ã€è¶…ä¸¦åˆ—å‡¦ç†ï¼ˆMassively Parallel Processingï¼šMPPï¼‰ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã®ãƒ‡ãƒ¼ã‚¿ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹å°‚ç”¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆDBï¼‰ã‚½ãƒ•ãƒˆã€ŒEMC Greenplum Databaseã€ã®ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ç‰ˆã‚’ç„¡å„Ÿã§æä¾›ã™ã‚‹ã¨ç™ºè¡¨ã—ãŸã€‚ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ•ã‚©ãƒ¼ãƒ©ãƒ ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã‚‹ã€‚ ä»Šå›žã®ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ç‰ˆã¯é–‹ç™ºè€…ã‚„ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚¨ãƒ³ãƒ†ã‚£ã‚¹ãƒˆã‚’å¯¾è±¡ã«ã—ã¦ã„ã‚‹ã€‚ã“ã®1ã€œ2å¹´ã§è©±é¡Œã¨ãªã£ã¦ã„ã‚‹â€œBig Dataï¼ˆãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿ï¼‰â€ã‚’å‡¦ç†ã™ã‚‹ãƒ„ãƒ¼ãƒ«ã‚’æ‰‹è»½ã«åˆ©ç”¨ã§ãã‚‹ã¨ã—ã¦ã„ã‚‹ã€‚æä¾›ã•ã‚Œã‚‹ã®ã¯ã€ŒGreenplum Database CEã€ã¨åˆ†æžã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã€ŒMADï¼ˆMagnetic, Agile and Deepï¼‰libã€ã€ãƒ‡ãƒ¼ã‚¿ãƒžã‚¤ãƒ‹ãƒ³ã‚°ãƒ„ãƒ¼ãƒ«ã€ŒAlpine Minerã€ã€‚MADlibã¯ã€æ§‹é€ åŒ–ãƒ‡ãƒ¼ã‚¿ã‚„éžæ§‹é€ åŒ–ãƒ‡ãƒ¼ã‚¿ã‚’æ•°å¦çš„ã€çµ±è¨ˆå¦çš„ã€æ©Ÿä¼šå¦ç¿’æ³•ã§ä¸¦åˆ—å‡¦ç†ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½
hacked 2011/02/08
database
ãƒªãƒ³ã‚¯
Kazuho@Cybozu Labs: Mycached: memcached protocol support for MySQL
It is a well-known fact that the bottlenecks of MySQL does not exist in its storage engines, but rather in the core, for example, its parser and execution planner.Â Last weekend I started to wonder how fast MySQL could be if those bottlenecks were skipped.Â Not being able to stop my curiousity, I startedÂ adding memcached proctol support to MySQL as a UDF.Â And that is Mycached. From what I unders
hacked 2010/01/23
mysql

database

memcached
ãƒªãƒ³ã‚¯
Tokyo Dystopiaã®è¨è¨ˆæ€æƒ³ - mixi engineer blog
å¤æœ¬ç•ªã«å‘ã‘ã¦æµ·ã«è¡Œã‘ã‚‹ä½“ä½œã‚Šã«åŠ±ã¾ãªã„ã¨ã„ã‹ã‚“ãªãƒ¼ã¨æ€ã„ã¤ã¤ã‚‚ã€ã¤ã„ã¤ã„DSã®ã‚¹ã‚¿ãƒ¼ãƒ•ã‚©ãƒƒã‚¯ã‚¹ã§éŠã‚“ã§ã—ã¾ã†mikioã§ã™ã€‚ã•ã¦ä»Šå›žã¯ã€äººçŸ¥ã‚Œãšãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¦ã„ã‚‹æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³Tokyo Dystopiaã®æ¦‚è¦ã¨è¨è¨ˆæ€æƒ³ã«ã¤ã„ã¦è¿°ã¹ã¾ã™ã€‚ Hyper Estraierã¨ã®é•ã„ Tokyo Dystopiaï¼ˆä»¥ä¸‹ã€TDã¨å‘¼ã³ã¾ã™ï¼‰ã¯ã€æ–°ã—ã„æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã§ã™ã€‚ã—ã‹ã—ã€ç§ãŒä½œã£ãŸã‚‚ã†ä¸€ã¤ã®æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³Hyper Estraierï¼ˆä»¥ä¸‹ã€HEã¨å‘¼ã³ã¾ã™ï¼‰ã®å¾Œç¶™ã¨ã—ã¦ã¯ä½ç½®ä»˜ã‘ã¦ã„ã¾ã›ã‚“ã€‚ Hyper Estraierã®è£½å“ã‚³ãƒ³ã‚»ãƒ—ãƒˆã¯ã€ã€Œæ¤œç´¢ã‚·ã‚¹ãƒ†ãƒ ã®éœ€è¦ãŒç”Ÿã˜ã‚‹æ§˜ã€…ãªã‚·ãƒ¼ãƒ³ã§æ‰‹è»½ã«å°Žå…¥ã§ãã‚‹ã€ã“ã¨ã§ã™ã€‚è¨€ã„æ›ãˆã‚Œã°ã€ã€Œã„ã‚ã‚†ã‚‹ã‚·ãƒã‚¦ãƒˆã®äººã§ã‚‚ã€ãŠé«˜ã„å•†ç”¨ã‚·ã‚¹ãƒ†ãƒ ã‚’è²·ãˆãªã„å€‹äººã‚„å°çµ„ç¹”ã§ã‚‚ã€ã¡ã‚‡ã£ã¨ã®åŠªåŠ›ã§è‡ªåˆ†ã®è¦æ±‚ã‚’æº€ãŸã™ã‚·ã‚¹ãƒ†ãƒ ã‚’æ§‹ç¯‰ã§ãã‚‹ã€ã“ã¨ã§ã™ã€‚ãã®ãŸã‚ã«ã€æ§˜ã€…ãªãƒ•ã‚¡ã‚¤ãƒ«å½¢å¼ã«å¯¾å¿œã—ãŸãƒ†
hacked 2010/01/21
database

search

tokyodystopia

C
ãƒªãƒ³ã‚¯
Project Voldemort
Voldemort is a distributed key-value storage system Data is automatically replicated over multiple servers. Data is automatically partitioned so each server contains only a subset of the total data Server failure is handled transparently Pluggable serialization is supported to allow rich keys and values including lists and tuples with named fields, as well as to integrate with common serialization
hacked 2009/12/10
system

server

database

key-value
ãƒªãƒ³ã‚¯
Kazuho@Cybozu Labs: ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ (BPStudy#25ç™ºè¡¨è³‡æ–™)
å…ˆé€±é‡‘æ›œæ—¥ã€BPStudy#25ã§ã€ã€Œãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã€ã¨ã„ã†é¡Œç›®ã§è©±ã‚’ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ãã®éš›ã«ä½¿ç”¨ã—ãŸç™ºè¡¨è³‡æ–™ã¯ä»¥ä¸‹ã®ã¨ãŠã‚Šã§ã™ã€‚ 1. Happy Optimization æœ€åˆã«ã€æœ€é©åŒ–ã®è€ƒãˆæ–¹ã¨ã—ã¦ã€ä¸Šé™å€¤ã‚’äºˆæ¸¬ã—ã€ãã‚Œã‚’å…ƒã«ãƒªã‚½ãƒ¼ã‚¹é…åˆ†ã‚’è€ƒãˆã‚‹ã€ã¨ã„ã†æ‰‹æ³•ã‚’èª¬æ˜Žã—ã¾ã—ãŸã€‚
hacked 2009/09/29
database

DB

è² è·åˆ†æ•£

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

database

development
ãƒªãƒ³ã‚¯
DTOãƒ»DAOãƒ‘ã‚¿ãƒ¼ãƒ³ã®ãƒ¡ãƒªãƒƒãƒˆã‚’ä½“é¨“ã—ã‚ˆã†
é€£è¼‰ç¬¬6å›žã€ŒDAOãƒ‘ã‚¿ãƒ¼ãƒ³ã§ã™ã£ãã‚Šã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ï¼ã€ã§ã¯DTOãƒ»DAOãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’ä½¿ã£ã¦ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ã‚¯ã‚»ã‚¹ã«é–¢é€£ã™ã‚‹æ“ä½œã‚’It emDaoã‚¯ãƒ©ã‚¹ã«é›†ç´„ã—ã¾ã—ãŸã€‚DAOãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ã‚¯ã‚»ã‚¹ã®ã‚ˆã†ãªç…©é›‘ãªæ‰‹é †ã‚’æœ¬æ¥å¿…è¦ãªå‡¦ç†ã‹ã‚‰åˆ‡ã‚Šé›¢ã—ã€PHPã‚³ãƒ¼ãƒ‰ã‚’ç°¡ç´ åŒ–ã§ãã¾ã™ã€‚ ä»Šå›žã¯ã€It emã‚¯ãƒ©ã‚¹ã‚„It emDaoã‚¯ãƒ©ã‚¹ã‚’å®Ÿéš›ã«åœ¨åº«ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ã«çµ„ã¿è¾¼ã¿ã€åœ¨åº«ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ æœ¬ä½“ã®å‡¦ç†ãŒã„ã‹ã«ç°¡ç´ åŒ–ã•ã‚Œã‚‹ã‹ã‚’ç¢ºèªã—ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ ç°¡æ˜“åœ¨åº«ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ã®ä½œæˆï¼ˆ1ï¼‰ æ¤œç´¢ï¼æŒ¿å…¥ï¼æ›´æ–°ï¼å‰Šé™¤ã¨ã„ã£ãŸå‡¦ç†ã¯ã€ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³phpã§åˆ©ç”¨ã§ãã‚‹ã‚‚ã®ã‚’å‰å›žä½œæˆã—ã¾ã—ãŸã€‚ä»Šå›žã¯ã€ã“ã‚Œã‚’åŸºã«Webã‹ã‚‰ä½¿ç”¨ã§ãã‚‹ã‚‚ã®ã‚’ç”¨æ„ã—ã¾ã™ã€‚ãã®éš›ã€æ›´æ–°ï¼å‰Šé™¤ï¼æŒ¿å…¥ãªã©ã®å‡¦ç†ã”ã¨ã«PHPãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç”¨æ„ã›ãšã€1ã¤ã®PHPãƒ•ã‚¡ã‚¤ãƒ«ã«ã¾ã¨ã‚ã‚‹ã“ã¨ã«ã—ã¾ã™ï¼ˆIt emDaoã®åˆ©ç”¨ã§å„å‡¦ç†ãŒç°¡æ½”ã«ãªã£ã¦ã„ã‚‹ãŸã‚ï¼‰ã€‚ ãªãŠã€
hacked 2009/09/16
DAO

database

DTO

java

php
ãƒªãƒ³ã‚¯
ã‚«ã‚«ã‚¯ã‚³ãƒ ç¤¾å†…å‹‰å¼·ä¼šã«å‚åŠ - mir the developer
id:kiskeã•ã‚“ã«ãŠèª˜ã„ã„ãŸã ã„ã¦å…ˆé€±é‡‘æ›œæ—¥ã«ã‚«ã‚«ã‚¯ã‚³ãƒ ã•ã‚“ã®ç¤¾å†…å‹‰å¼·ä¼šã§ãŠè©±ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚è²´é‡ãªæ©Ÿä¼šã‚’ã„ãŸã ãã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ è‡ªç”±ã«è©±ã—ã¦OKã§ã™ã‚ˆã¨ã®ã“ã¨ã ã£ãŸã®ã§ã€ä½•ã«ã—ã‚ˆã†ã‹ãªã¨å°‘ã—è€ƒãˆãŸçµæžœã€ã“ã‚“ãªã‚¹ãƒ©ã‚¤ãƒ‰ãŒã§ãã‚ãŒã‚Šã¾ã—ãŸã€‚ MySQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®è©±View more presentations from ikdttr. MySQLã‚‚ä»Šã¨ãªã£ã¦ã¯ã‹ãªã‚Šåºƒãä½¿ã‚ã‚Œã¦ã„ã¦ã€ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã‹ã‚‚ä¸€é€šã‚Šã®ã“ã¨ã¯çš†ã•ã‚“ã”å˜çŸ¥ã ã‚ã†ã¨æ€ã£ãŸã®ã§ã€Œãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’ã™ã‚‹éš›ã«ã‚½ãƒ¼ã‚¹ã‚’èªã‚“ã§èª¿ã¹ãŸã„ã¨æ€ã£ãŸã‚‰ã©ã†ã—ãŸã‚‰ã„ã„ã‹ã€ã¨ã„ã£ãŸã‚ˆã†ãªãƒ†ãƒ¼ãƒžã«å¯¾ã™ã‚‹ç”ãˆã®ä¸€ä¾‹è¦‹ãŸã„ãªæ„Ÿã˜ã®å†…å®¹ã«ãªã‚Šã¾ã—ãŸã€‚ æ™®æ®µä½¿ã£ã¦ã„ã‚‹/å‚ç…§ã—ã¦ã„ã‚‹ã‚µãƒ¼ãƒå¤‰æ•°ã‚„ã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹å¤‰æ•°ãŒã©ã®ã‚ˆã†ã«å®Ÿè£…ã•ã‚Œã¦ã„ã¦ã€ãã‚Œã‚‰ã‚’ã‚½ãƒ¼ã‚¹ä¸Šã§è¿½ã„ã‹ã‘ã‚‹ã«ã¯ã©ã†ã—ãŸã‚‰ã„ã„ã‹ã€ã¿ãŸã„ãªæ„Ÿã˜ã§ã™ãã€‚ å‹‰å¼·ä¼šã§ã¯gdb
hacked 2009/09/10
mysql

database
ãƒªãƒ³ã‚¯
åˆ†æ•£Key-Valueã‚¹ãƒˆã‚¢ã®æœ¬å‘½ã€ŒBigtableã€
RDBã¨ã¯åˆ¥ã®ã€ã‚¯ãƒ©ã‚¦ãƒ‰æ™‚ä»£ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦æ³¨ç›®ã‚’æµ´ã³ã¦ã„ã‚‹ã€Œåˆ†æ•£Key-Valueã‚¹ãƒˆã‚¢ã€ã€‚ãã®æœ¬å‘½ã¨ã‚‚ã„ãˆã‚‹ã€Googleã®æ•°ã€…ã®ã‚µãƒ¼ãƒ“ã‚¹ã®åŸºç›¤æŠ€è¡“ã€ŒBigtableã€ã«ã¤ã„ã¦å¾¹åº•è§£èª¬ ã‚‚ã†1ã¤ã®ã€DBã®ã‹ãŸã¡ã€åˆ†æ•£Key-Valueã‚¹ãƒˆã‚¢ã¨ã¯ åˆ†æ•£Key-Valueã‚¹ãƒˆã‚¢ã®æœ¬å‘½ã€ŒBigtableã€ï¼ˆ1ï¼‰ã€€ä¼æ¥ã®ã‚·ã‚¹ãƒ†ãƒ ã§å¤šãä½¿ã‚ã‚Œã‚‹RDBã¨ã¯åˆ¥ã«DBã«ã¯ã‚‚ã†1ã¤ã®â€œã‹ãŸã¡â€ãŒå˜åœ¨ã™ã‚‹ã€‚RDBã¨ã®é•ã„ã‚„é•·æ‰€ãƒ»çŸæ‰€ã‚’è§£èª¬ã—ã‚ˆã†
hacked 2009/09/07
database

Key-Valueã‚¹ãƒˆã‚¢
ãƒªãƒ³ã‚¯
InnoDB Plugin 1.0.4 - InnoDBå²ä¸Šæ¥µã‚ã¦é‡è¦ãªãƒªãƒªãƒ¼ã‚¹
æ—¥æœ¬æ™‚é–“ã®ä»Šæ—¥ã€InnoDB Pluginã®æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³1.0.4ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸã€‚ã“ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã¯ã€ã€Œãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’æœ‰åŠ¹ã«ã™ã‚‹ã¨ã‚°ãƒ«ãƒ¼ãƒ—ã‚³ãƒŸãƒƒãƒˆãŒåŠ¹ã‹ãªããªã‚‹å•é¡Œã€ãŒä¿®æ£ã•ã‚Œã¦ã„ã¾ã™ã€‚ã»ã¨ã‚“ã©ã®ç’°å¢ƒã«ã¨ã£ã¦æ¥µã‚ã¦åŠ¹æžœã®é«˜ã„ä¿®æ£ã§ã™ã€‚ã»ã‹ã«ã‚‚I/Oã‚¹ãƒ¬ãƒƒãƒ‰ã®å¤šé‡åŒ–(åŒæ§˜ã®ã‚‚ã®ãŒMySQL5.4ã«ã‚‚æè¼‰)ãªã©åŠ¹æžœçš„ãªä¿®æ£ãŒè¡Œãªã‚ã‚Œã¦ã„ã¾ã™ã€‚ InnoDB Pluginã¯ã¾ã GA(å®‰å®šç‰ˆ)ã§ã¯ãªã„ã®ã§ã€å“è³ªé¢ã§ã¯æ¨™æº–æè¼‰ã•ã‚Œã¦ã„ã‚‹InnoDBã‚ˆã‚Šã‚‚è½ã¡ã¾ã™ã€‚ãŸã ã—MySQL Enterpriseã‚µãƒ–ã‚¹ã‚¯ãƒªãƒ—ã‚·ãƒ§ãƒ³ã‚’è²·ã£ã¦ã„ã‚‹æ–¹ã§ã‚ã‚Œã°è¿½åŠ è²»ç”¨ç„¡ã—ã§InnoDB Pluginã®ã‚µãƒãƒ¼ãƒˆã‚’å—ã‘ã‚‹ã“ã¨ãŒã§ãã‚‹ã®ã§ã€ãŠæ°—è»½ã«è©¦ã—ã¦ã¿ã¦é ‚ã‘ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ ã‚°ãƒ«ãƒ¼ãƒ—ã‚³ãƒŸãƒƒãƒˆå•é¡Œä¿®å¾©ã®åŠ¹æžœã®ã»ã©ã¯ã€ä¸€ç›®çžç„¶ãªã®ã§å›³ã‚’è¦‹ãŸæ–¹ãŒåˆ†ã‹ã‚Šã‚„ã™ã„ã§ã—ã‚‡ã†ã€‚ä¸‹å›³ã¯ã€mysqlslapã§ã€è¤‡æ•°ã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã‹ã‚‰ä¸¦
hacked 2009/09/04
ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

database

innodb

mysql

plugin
ãƒªãƒ³ã‚¯
http://labs.cybozu.co.jp/blog/kazuho/archives/2008/06/friends_timeline.php
hacked 2009/06/21
database

DB

mysql
ãƒªãƒ³ã‚¯
mysqlã§ã„ã¡ã„ã¡show databasesã¨ã‹æ‰“ã¤ã®ãŒã‚ã‚“ã©ã„â†’readlineã®ãƒžã‚¯ãƒã§è§£æ±º - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
MySQLã§ã„ã¡ã„ã¡show tables;ã¨ã‹æ‰“ã¤ã®ãŒã ã‚‹ã„ã€‚\tã¿ãŸã„ãªaliasè¨å®šã§ããªã„ã®ã‹ãªã http://twitter.com/weboo/status/1658300902 ãŠã‰ã€readlineã®ãƒžã‚¯ãƒã‚’ä½¿ãˆã°ã„ã„ã®ã‹ãƒ¼ http://twitter.com/weboo/status/1658314333 ãªã‚‹ã»ï¼ã£ã¦ã“ã¨ã§ã¡ã‚‡ã£ã¨è¨å®šã—ã¦ã¿ã¾ã—ãŸã€‚ # ~/.inputrc $if mysql "\C-xd": "show databases;" "\C-xt": "show tables;" "\C-xu": "select user,host,password from mysql.user order by user,host;" "\C-xb": "select user,host,db from mysql.db order by user,host;"
hacked 2009/06/01
database

DB

mysql
ãƒªãƒ³ã‚¯
ã‚ªãƒ¬ã‚ªãƒ¬SQLã®ä½œã‚Šæ–¹ã€œMySQLç·¨ã€œ - ã‚ˆãã®ã¯ã¦ãª
ã‚ªãƒ¬ã‚ªãƒ¬è¨€èªžå…¨ç››æœŸã®ç‚Žæš‘ã®å€™ã€ã„ã‹ãŒãŠéŽã”ã—ã§ã—ã‚‡ã†ã‹ã€‚ ã‚ªãƒ¬ã‚ªãƒ¬SQLã®ä½œã‚Šæ–¹ã€œPostgreSQLç·¨ã€œã«ç¶šãã€ã‚ªãƒ¬ã‚ªãƒ¬SQLã®ä½œã‚Šæ–¹ã€œMySQLç·¨ã€œã¨ã„ã†äº‹ã§ MySQLã«ã€è‡ªä½œã®SQLé–¢æ•°(UDF)ã‚’çµ„ã¿è¾¼ã‚€ã‚„ã‚Šæ–¹ã‚’ç°¡å˜ã«ç´¹ä»‹ã—ã¾ã™ã€‚ MySQLã¯åã®é€šã‚Šã€ç§ã®SQLãªã®ã§ã‚ªãƒ¬ã‚ªãƒ¬SQLã«ã¯æŒã£ã¦ã“ã„ã§ã™ãã€‚ ç°¡å˜ã«è¨€ãˆã° select oreore(); select oreore(column1, column2) from table1; è‡ªåˆ†ã§å®šç¾©ã—ãŸCè¨€èªžã®oreoreé–¢æ•°ã‚’DBã«çµ„ã¿è¾¼ã‚“ã§ä½¿ãŠã†ã¨ã„ã†äº‹ã§ã™ã€‚ æœ€çµ‚ç›®æ¨™ã¯ã€SQLã®çµæžœã§JSONã‚’è¿”ãã†ã¨æ€ã„ã¾ã™ã€‚ select json(a, b) from c;ã®çµæžœã§ { "aaa" : 1, "bbb" : "abc" } å›ºå®šå€¤ã‚’è¿”ã™é–¢æ•° æ—©é€Ÿã€å›ºå®šã§999ã‚’è¿”ã™é–¢æ•°ã‚’ä½œã£ã¦ã¿ã¾ã™ã€‚ â€»ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯MySQL5.
hacked 2009/04/11
cè¨€èªž

database

mysql

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

database

DB
ãƒªãƒ³ã‚¯
[ThinkIT] ç¬¬1å›žï¼šMySQLã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®æ¦‚è¦ (1/3)
æœ¬é€£è¼‰ã§å–ã‚Šä¸Šã’ã‚‹MySQLã¯ã€éžå¸¸ã«äººæ°—ã®é«˜ã„ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®RDBMSã§ã™ã€‚ã“ã®MySQLã®å¤§ããªç‰¹é•·ã¯ã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’é¸æŠžã§ãã‚‹ã¨ã“ã‚ã«ã‚ã‚Šã¾ã™ã€‚ãã“ã§æœ¬é€£è¼‰ã§ã¯ã€MySQLã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã«ç„¦ç‚¹ã‚’ã‚ã¦ã€æ§˜ã€…ãªã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®ç‰¹é•·ã‚„æ§‹é€ ã‚’è§£èª¬ã—ã¦ã„ãã¾ã™ã€‚æœ€å¾Œã¾ã§ã€ãŠä»˜ãåˆã„ãã ã•ã„ã€‚ MySQLã®æ¦‚è¦ã«ã¤ã„ã¦ã¯ã”å˜çŸ¥ã®æ–¹ã‚‚å¤šã„ã¨æ€ã„ã¾ã™ãŒã€å¾©ç¿’ã®æ„å‘³ã‚‚è¾¼ã‚ã¦ç°¡å˜ã«ç´¹ä»‹ã—ã¾ã™ã€‚ MySQLã¯ã€MySQLç¤¾ã‚’ä¸å¿ƒã¨ã—ã¦é–‹ç™ºãŒé€²ã‚ã‚‰ã‚Œã¦ã„ã‚‹RDBMSã§ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®æ¨™æº–çš„ãªãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã‚’æ„å‘³ã™ã‚‹ã€ŒLAMPã€ã¨ã„ã†è¨€è‘‰ï¼ˆLinuxï¼Apacheï¼MySQLï¼PHPï¼‰ã«æŽ¡ç”¨ã•ã‚Œã‚‹ã»ã©æœ‰åãªã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§ã™ã€‚ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã¨ã—ã¦ã¯ã€GPLã¨å•†ç”¨ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã®ãƒ‡ãƒ¥ã‚¢ãƒ«ãƒ©ã‚¤ã‚»ãƒ³ã‚¹å½¢æ…‹ã§æä¾›ã•ã‚Œã¦ã„ã¾ã™ã€‚ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.0ã‚ˆã‚Šã‚¹ãƒˆã‚¢ãƒ¼ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã‚„ãƒˆãƒªã‚¬ãªã©ã‚’ã‚µãƒãƒ¼ãƒˆã—ã€ä»–ã®RDB
hacked 2009/02/22
database

mysql
ãƒªãƒ³ã‚¯
ã€ãƒã‚¦ãƒ„ãƒ¼ã€‘RDBMSæ“ä½œãƒ„ãƒ¼ãƒ«æ±ºå®šæ‰“!? - Eclipseã‹ã‚‰Oracle/DB2/MySQL/PostgreSQLã‚’æ“ä½œ (2) ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« Eclipse SQL Explorerã®ã‚µã‚¤ãƒˆã‹ã‚‰Eclipse IDEå‘ã‘ã®ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ãŒãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã‚‹ãŸã‚ã€ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ãã‚Œãžã‚Œfeaturesãƒ•ã‚©ãƒ«ãƒ€ã€pluginsãƒ•ã‚©ãƒ«ãƒ€ã«ã‚³ãƒ”ãƒ¼ã—ã¦ã»ã—ã„(ã‚µã‚¤ãƒˆã«ã¯Software Updatesæ©Ÿèƒ½ã‚’ä½¿ã£ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ãã‚‹ã¨ã‚ã‚‹ãŒã€æ‰‹å…ƒã§è©¦ã—ãŸé™ã‚Šã§ã¯ã§ããªã‹ã£ãŸ)ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã‚‰ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‹ã‚‰ã€ŒHelpã€->ã€ŒAbout SQL Explorerã€ã‚’é¸æŠžã¦ã¿ã‚ˆã†ã€‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚Œã°ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‚¢ã‚¤ãƒ†ãƒ ãŒã‚ã‚Šã€ãƒ€ã‚¤ã‚¢ãƒã‚°ãŒèµ·å‹•ã™ã‚‹ã€‚ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‹ã‚‰ã€ŒWindowã€->ã€ŒPreferences...ã€ã‚’é¸æŠžã™ã‚Œã°è¨å®šãƒ€ã‚¤ã‚¢ãƒã‚°ã«é …ç›®ãŒè¿½åŠ ã•ã‚Œã¦ã„ã‚‹ã“ã¨ã‚‚ç¢ºèªã§ãã‚‹ã€‚ å›³2.1 Eclipse SQL Explorer â€“ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚’ç¢ºèª å›³2.2 Preferencesãƒ€ã‚¤ã‚¢ãƒã‚°ã«Eclipse SQL Explo
hacked 2009/02/16
DB

eclipse

RDBMS

database
ãƒªãƒ³ã‚¯
iBATISã®ORMã¨Springã®AOPã‚’æ´»ç”¨ã—ãŸDBã‚¢ã‚¯ã‚»ã‚¹
é€£è¼‰ç¬¬2å›žã®ã€ŒHello Worldï¼ã§ç†è§£ã™ã‚‹ã€Webã‚¢ãƒ—ãƒªé–‹ç™ºã®åˆ†æ¥åŒ–ã€ã§ã¯ã€TERASOLUNA Server Framework for Java Webç‰ˆï¼ˆä»¥ä¸‹ã€TERASOLUNAãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ï¼‰ã‚’ä½¿ã£ã¦ã€Hello Worldã‚’å‡ºåŠ›ã™ã‚‹ç°¡å˜ãªã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½œæˆã—ã¾ã—ãŸã€‚
hacked 2008/12/25
[O/Rãƒžãƒƒãƒ”ãƒ³ã‚°][java]

database
ãƒªãƒ³ã‚¯
O/Rãƒžãƒƒãƒ”ãƒ³ã‚°ã®å½¹å‰²ã¨ãƒ¡ãƒªãƒƒãƒˆ
O/Rãƒžãƒƒãƒ”ãƒ³ã‚°ã¯ã€å¾“æ¥ã®ç…©é›‘ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã™ã‚‹å‡¦ç†ã®è¨˜è¿°ã‚’ã‚¹ãƒžãƒ¼ãƒˆã«ã—ã€ã€æŸ”è»Ÿãªã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®æ§‹ç¯‰ã‚’å¯èƒ½ã«ã—ã¾ã™ã€‚æœ¬é€£è¼‰ã§ã¯ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®O/Rãƒžãƒƒãƒ”ãƒ³ã‚°ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã€ŒHibernateã€ã‚’ç”¨ã„ã¦O/Rãƒžãƒƒãƒ”ãƒ³ã‚°ã®åŸºç¤Žã‚’è§£èª¬ã—ã¾ã™ã€‚ãã—ã¦ã•ã‚‰ã«ã€J2EEã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¸ã®å®Ÿè·µçš„ãªé©ç”¨æ–¹æ³•ã¨ãã®ãƒ¡ãƒªãƒƒãƒˆã‚‚ç´¹ä»‹ã—ã¦ã„ãã¾ã™ã€‚ï¼ˆç·¨é›†å±€ï¼‰
hacked 2008/12/16
database

DB

hibernate

java
ãƒªãƒ³ã‚¯
Infoseek[ã‚¤ãƒ³ãƒ•ã‚©ã‚·ãƒ¼ã‚¯] - æ¥½å¤©ãŒé‹å–¶ã™ã‚‹ãƒãƒ¼ã‚¿ãƒ«ã‚µã‚¤ãƒˆ
äººæ°—å†ç‡ƒï¼ãƒã‚±ãƒ¢ãƒ³ GOã‚’ã‚ˆã‚Šæ¥½ã—ã‚€ã‚¦ã‚§ã‚¢ãƒ©ãƒ–ãƒ«ãƒ‡ãƒã‚¤ã‚¹4é¸ è¡—ä¸ã§ã€Žãƒã‚±ãƒ¢ãƒ³ GOã€ã‚’éŠã¶ã«ã—ã¦ã‚‚ã€ã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³ã‚’å‡ºã—ãŸã‚Šã—ã¾ã£ãŸã‚Šã—ãªãŒã‚‰æ©ãã®ã¯ãªã‹ãªã‹é›£ã—â€¦
hacked 2008/11/19
database

db

oracle

sql

ã‚ã¨ã§èªã‚€

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
ï¼»MySQLã‚¦ã‚©ãƒƒãƒï¼½ç¬¬28å›ž MySQL 5.1æœŸå¾…ã®ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°æ©Ÿèƒ½
æ•°ã‚«æœˆå‰ã«MySQL 5.1 GAç‰ˆ ã®ãƒªãƒªãƒ¼ã‚¹è¦‹é€šã—ã‚’5æœˆã¨è¨˜è¿°ã—ãŸãŒï¼Œæ®‹å¿µãªãŒã‚‰ä¸‹åŠæœŸã«çªå…¥ã—ãŸç¾åœ¨ã‚‚Bataç‰ˆã«ã¨ã©ã¾ã£ã¦ã„ã‚‹ã€‚ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.0ã‹ã‚‰5.1ã¸ã®ã‚¢ãƒƒãƒ—ã¯ï¼Œç•ªå·ã¨ã—ã¦ã¯ãƒã‚¤ãƒ³ãƒˆä»¥ä¸‹ã®ãƒžã‚¤ãƒŠãƒ¼ãƒ»ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã ã€‚ã—ã‹ã—ï¼Œéžå¸¸ã«å¤§ããªæœŸå¾…ã‚’æŒã£ã¦å¾…ã£ã¦ã„ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚‚å¤šã„ã ã‚ã†ã€‚ãã‚Œã¯ï¼ŒMySQL 5.1 ã‹ã‚‰MySQL ClusterãŒã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸å¯¾å¿œã«ãªã‚‹ã‹ã‚‰ã ã€‚ ä»Šå›žã¯ï¼ŒMySQL 5.1 GAç‰ˆ ã®ãƒªãƒªãƒ¼ã‚¹æº–å‚™ã¨ã—ã¦ï¼ŒæœŸå¾…ã®é«˜ã¾ã‚‹MySQL Clusterã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸å¯¾å¿œã‚’ç´¹ä»‹ã™ã‚‹ã€‚ MySQL Cluster ã®ç™»å ´ ã‚‚ã¨ã‚‚ã¨MySQL Clusterã¯ï¼ŒNDB Clusterã¨ã„ã†å•†å“ã ã£ãŸã‚‚ã®ã‚’MySQL ABãŒè‡ªç¤¾è£½å“ã¨ã—ã¦å–ã‚Šè¾¼ã¿ï¼ŒMySQL 4.1.3 (RPMç‰ˆã¯MySQL 4.1.10)ã‹ã‚‰å®Ÿè£…ãŒå§‹ã¾ã£ãŸã€‚ãã‚Œä»¥å‰ã¯ï¼Œæ¨™æº–æ©Ÿèƒ½ã®Replicationã‹ã‚µ
hacked 2008/11/03
database

cluster

mysql
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸