[B! dbms] t-wadaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

t-wada id:t-wada

dbmsã«é–¢ã™ã‚‹t-wadaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (24)

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

DB Onlineï¼šä¼æ¥ã®ITãƒ»çµŒå–¶ãƒ»ãƒ“ã‚¸ãƒã‚¹ã‚’ã¤ãªãæƒ…å ±ã‚µã‚¤ãƒˆ EnterpriseZine (EZ)
ã€Œåƒ•ã€å®Ÿã¯æ–‡ç³»å‡ºèº«ãªã‚“ã§ã™ã‚ˆã€‚ã ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦ã®å‡ºè‡ªã¯ã‚ã¾ã‚Šã‚ˆã‚ã—ããªã„ã‹ã‚‚ã—ã‚Œãªã„ï¼ˆç¬‘ï¼‰ã€â€•é–‹å§‹æ—©ã€…ã€ãƒ¯ãƒ³ãƒ»ã‚ªãƒ¼ãƒ»ãƒ¯ãƒ³ ä»£è¡¨å–ç· å½¹ç¤¾é•· äºŒéšŽå ‚éš†æ°ã¯ç¬‘ã„ãªãŒã‚‰ã“ã†åˆ‡ã‚Šå‡ºã—ãŸã€‚ãƒ¯ãƒ³ãƒ»ã‚ªãƒ¼ãƒ»ãƒ¯ãƒ³ãŒé–‹ç™º/è²©å£²ã™ã‚‹è£½å“ã‚„ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã¯ã€ãƒãƒƒãƒå‡¦ç†ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºãƒ„ãƒ¼ãƒ«ã€Œ101willã€ã‚„Webã‚¢ãƒ—ãƒª... ï¼ˆç¶šãã‚’èªã‚€ï¼‰ 2011å¹´4æœˆ26æ—¥ã€æ—¥æœ¬HPã¯åŒç¤¾ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æˆ¦ç•¥ã«ã¤ã„ã¦ç™ºè¡¨ã‚’è¡Œã£ãŸã€‚ãã®éš›ã®ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã¯ã€Œãƒãƒƒã‚¯ãƒªãƒªãƒ¼ã‚¹ã€ã€‚HPãŒã€ãƒ™ãƒ³ãƒ€ãƒ¼ãƒãƒƒã‚¯ã‚¤ãƒ³ã‚’ç™ºç”Ÿã•ã›ã¦ã„ã‚‹ã¨æŒ‡æ‘˜ã™ã‚‹å¯¾è±¡ã¯ã€ã‚‚ã¡ã‚ã‚“Oracleã®ã“ã¨ã ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ“ã‚¸ãƒã‚¹æ¥ç•Œã§ã€ã„ã£ãŸã„ä½•ãŒèµ·ã“ã£ã¦ã„ã‚‹ã®ã‹â€•... ï¼ˆç¶šãã‚’èªã‚€ï¼‰
t-wada 2011/05/10
DB Magazine ãŒ Web ä¸Šã§å¾©æ´»ã—ãŸã‚ˆã†ãªæ„Ÿã˜ã§ã—ã‚‡ã†ã‹ã€‚æœŸå¾…å¤§ã§ã™ã€‚

dbms

web
ãƒªãƒ³ã‚¯
NoSQLã®æˆåŠŸã¯1:10å•é¡Œã«ã‹ã‹ã£ã¦ã„ã‚‹:Kenn's Clairvoyance
ã“ã“2-3å¹´ã»ã©ã€ã„ã‚ã‚†ã‚‹éžSQLç³»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒãƒ›ãƒƒãƒˆãªè©±é¡Œã«ãªã£ã¦ãã¦ã„ã¾ã™ã€‚ã“ã®ãƒ ãƒ¼ãƒ–ãƒ¡ãƒ³ãƒˆã‚’ç·ç§°ã—ã¦ã€ŒNoSQL (Not-only SQL)ã€ã¨å‘¼ã°ã‚Œã‚‹ã“ã¨ãŒå¤šã„ã‚ˆã†ã§ã™ã€‚ã¾ã‚‹ã§SQLã‚’å¦å®šã—ã¦ã„ã‚‹ã‹ã®ã‚ˆã†ãªèª¤è§£ã‚’æ‹›ãã‚„ã™ã„ç”¨èªžã§ã™ãŒã€ã‹ã¨ã„ã£ã¦ã‚ãƒ¼ãƒ»ãƒãƒªãƒ¥ãƒ¼åž‹ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã‚„åˆ—æŒ‡å‘DBã‚’ç·ç§°ã§ãã‚‹ä»–ã®å‘¼ã³æ–¹ã‚‚ãªã„ã®ã§ã€ã“ã®ã‚¨ãƒ³ãƒˆãƒªã§ã¯NoSQLã¨ã„ã†ç”¨èªžã‚’ä½¿ã†ã“ã¨ã«ã—ã¾ã™ã€‚ Oracleã‚„MySQLãªã©ã®SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒæˆç†Ÿã—ã¦ã„ãä¸€æ–¹ã§ã€SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç‰¹å¾´ã¥ã‘ã‚‹å¼±ç‚¹ã§ã‚ã‚‹æŸ”è»Ÿæ€§ã®ãªã•ã€å …ç‰¢ã•ã¨å¼•ãæ›ãˆã«çŠ ç‰²ã«ãªã£ãŸæ›´æ–°æ€§èƒ½ã®ä½Žã•ã€ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã®é›£ã—ã•ãªã©ã‹ã‚‰ã€ã€Œä½•ã§ã‚‚ã‹ã‚“ã§ã‚‚RDBã€ã‹ã‚‰ã€Œç›®çš„ã«å¿œã˜ãŸæ°¸ç¶šåŒ–ã€ãŒæ¨¡ç´¢ã•ã‚Œã‚‹æµã‚Œã«ãªã£ã¦ãã¾ã—ãŸã€‚ æ™‚ã‚’åŒã˜ãã—ã¦ã€ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚µãƒ¼ãƒã®ä¸–ç•Œã§ã‚‚ã€Memcachedã®ã‚‚ã¤ã‚·ãƒ³ãƒ—ãƒ«ãªAPIã®ä½¿ã„ã‚„ã™ã•ãŒè©•ä¾¡ã•ã‚Œã‚‹ä¸€æ–¹ã€LRUã«ã‚ˆ
t-wada 2010/09/20
NoSQL ã«é–¢ã™ã‚‹ãƒãƒ©ãƒ³ã‚¹ã®ã¨ã‚ŒãŸè€ƒå¯Ÿã€‚ã•ã™ãŒã€‚

dbms

architecture
ãƒªãƒ³ã‚¯
The relational database needs no "defense" Â· Ted Neward's Blog
t-wada 2007/07/03
opinion

OO

dbms
ãƒªãƒ³ã‚¯
not found
not found
t-wada 2006/08/29
ABD

dbms
ãƒªãƒ³ã‚¯
Selenium 0.7 Tipsã¨Excelã«ã‚ˆã‚‹DBåˆæœŸåŒ–ï¼šCodeZine
ãƒ†ã‚¹ãƒˆã®ç’°å¢ƒã¨ã—ã¦ã¯ã€ãƒãƒ¼ã‚«ãƒ«ãƒžã‚·ãƒ³ã«ã¦Web/APã‚µãƒ¼ãƒï¼ˆTomcatï¼‰ã‚’èµ·å‹•ã—ã¦ãƒ†ã‚¹ãƒˆå¯¾è±¡ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ãƒ‡ãƒ—ãƒã‚¤ã—ã¦ã„ã¾ã™ã€‚ãƒ†ã‚¹ãƒˆå¯¾è±¡ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã—ã¦ã€ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³å±¤ã«Strutsï¼ˆ1.2.7ï¼‰ã‚’ç”¨ã„ã¦ä½œæˆã•ã‚ŒãŸJavaEE/Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½¿ç”¨ã—ã¾ã—ãŸã€‚ãƒ†ã‚¹ãƒˆã‚±ãƒ¼ã‚¹ã®æ›¸ãæ–¹ Tipsé›†ï¼ˆ1/2ï¼‰ã€€ã“ã“ã§ã¯ãƒ†ã‚¹ãƒˆã‚±ãƒ¼ã‚¹ã®æ›¸ãæ–¹ã®ãƒ’ãƒ³ãƒˆã‚„ä¾¿åˆ©ãªã‚³ãƒžãƒ³ãƒ‰ã®ä½¿ã„æ–¹ãªã©ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚openã‚³ãƒžãƒ³ãƒ‰ã®URLæŒ‡å®šã€€Seleniumã§ã¯ã€URLã‚’æŒ‡å®šã—ã¦ã€htmlï¼ˆJSPï¼‰ã‚’é–‹ã„ãŸã‚Šã€ã‚µãƒ¼ãƒ–ãƒ¬ãƒƒãƒˆã‚’èµ·å‹•ã—ãŸã‚Šã§ãã¾ã™ã€‚URLã¯çµ¶å¯¾ãƒ‘ã‚¹ã€ç›¸å¯¾ãƒ‘ã‚¹ã®ã„ãšã‚Œã‚‚æŒ‡å®šå¯èƒ½ã§ã™ã€‚ã—ã‹ã—ã€çµ¶å¯¾ãƒ‘ã‚¹æŒ‡å®šã ã¨ã€ã‚¢ãƒ—ãƒªã‚’èµ·å‹•ã™ã‚‹ãƒžã‚·ãƒ³ï¼ˆIPï¼‰ãŒé™ã‚‰ã‚Œã¦ã—ã¾ã„ã¾ã™ã€‚ã€€ä¾‹ãˆã°ã€ã€Œhttp://localhost:8080/ï½žã€ã¨æŒ‡å®šã—ãŸå ´åˆã€è‡ªåˆ†ã®ãƒãƒ¼ã‚«ãƒ«ãƒžã‚·ãƒ³ã§ã—ã‹ãƒ†ã‚¹ãƒˆã‚’å®Ÿè¡Œã§ãã¾ã›ã‚“ã€‚17
t-wada 2006/08/18
selenium

dbms

testing
ãƒªãƒ³ã‚¯
jsys-products.comÂ -Â jsys products ãƒªã‚½ãƒ¼ã‚¹ãŠã‚ˆã³æƒ…å ±
This webpage was generated by the domain owner using Sedo Domain Parking. Disclaimer: Sedo maintains no relationship with third party advertisers. Reference to any specific service or trade mark is not controlled by Sedo nor does it constitute or imply its association, endorsement or recommendation.
t-wada 2006/08/15
dbms

pattern
ãƒªãƒ³ã‚¯
Database Testing: An Introduction to Database Testing
Database Testing: An Introduction to Database Testing Database management systems (DBMSs) persist mission-critical data and implement mission-critical functionality. These DBMSs, henceforth referred to simply as databases, may be based onÂ relational, hierarchical, network, or some other technical architecture.Â Database testing is the act of verifying that a database, also known as a data store, c
t-wada 2006/07/18
testing

dbms
ãƒªãƒ³ã‚¯
dbmstools
About dbmstools dbmstools is a set of utilities for software developers who work with databases. dbmstools understands database schemas (tables, sequences, views etc.) and DBMSs (Database Management Systems, e.g. Oracle, Postgres). It can: Generate the same (or similar) schema for many different DBMSs, all from a single XML representation Migrate a schema from one DBMS to another, via an XML repre
t-wada 2006/06/06
java

dbms

tool
ãƒªãƒ³ã‚¯
2006-06-02
ã€Œä¸€èˆ¬çš„ã«ã¯ã€ç¬¬3æ£è¦å½¢ã¾ã§ã§ã‚ˆã„ã€ç†ç”±ã«ã¤ã„ã¦æ›¸ã‹ã‚ŒãŸè²´é‡ãªè¨˜äº‹ã‚’ãã¡ã‚“ã¨èªã‚“ã§ã¿ãŸã€‚ ç´ æ—©ãæ£è¦å½¢ã‚’è¦‹æŠœãå®Ÿè·µãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ http://www.atmarkit.co.jp/fdb/rensai/db_enginer03/db_enginer03_1.html ã€Œãªãœç¬¬3æ£è¦å½¢ã¾ã§ã§ã‚ˆã„ã®ã‹ã€ã®çµè«–ã¯ä»¥ä¸‹ã®é€šã‚Šï¼š ãƒ†ãƒ¼ãƒ–ãƒ«æ§‹é€ ã‹ã‚‰ãƒ“ã‚¸ãƒã‚¹ãƒ«ãƒ¼ãƒ«ã‚’æŽ’é™¤ã™ã‚‹ã¨ã€ç¬¬ï¼“æ£è¦åŒ–ã¾ã§ã§æ£è¦åŒ–ãŒå®Œäº†ã™ã‚‹ã€‚ ã“ã®è¨˜äº‹ã§ã„ã†ãƒ“ã‚¸ãƒã‚¹ãƒ«ãƒ¼ãƒ«ã¨ã¯ã€è¦ã™ã‚‹ã«é–¢æ•°å¾“å±žæ€§ãƒ»å¤šå€¤å¾“å±žæ€§ãƒ»çµåˆå¾“å±žæ€§ã¨ã‹ã®ã“ã¨ã€‚ ã€Œãƒ“ã‚¸ãƒã‚¹ãƒ«ãƒ¼ãƒ«ã‚’æŽ’é™¤ã™ã‚‹ã€ã¨ã¯ã€ãƒªã‚¢ãƒ«ãƒ¯ãƒ¼ãƒ«ãƒ‰ã«ã‚ã‚‹ï½˜ï½˜å¾“å±žæ€§ã‚’DBä¸Šã®åˆ¶ç´„ã¨ã—ã¦å®Ÿè£…ã—ãªã„ã“ã¨ã€‚ ã¤ã¾ã‚Šã€ã€Œãƒ“ã‚¸ãƒã‚¹ãƒ«ãƒ¼ãƒ«ã€ã¨ã„ã†è¡¨ç¾ã‚’é¿ã‘ã¦ã€ã‚‚ã®ã™ã”ãç •ã„ã¦æ›¸ãã¨ã€ã“ã†ã„ã†ã“ã¨ï¼š ã¨ã‚Šã‚ãˆãšç¬¬ï¼“æ£è¦å½¢ã«ã—ã¦ã€ã¾ã éžå®Œå…¨æ£è¦å½¢ã®ãƒ†ãƒ¼ãƒ–ãƒ«ãŒã‚ã£ãŸã‚‰ã€ã‚µãƒã‚²ãƒ¼ãƒˆã‚ãƒ¼ã‚’ä»˜ã‘ã‚‹ã€‚ ãã—ãŸã‚‰å®Œå…¨æ£è¦å½¢ã«ãªã‚‹ã€‚ ã
t-wada 2006/06/02
dbms
ãƒªãƒ³ã‚¯
mysql:12071ã€€éšŽå±¤åŒ–ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’MySQLã§æ‰±ã†
From: zen kishimoto <zen kishimoto <zen@xxxxxxxxxx>> Date: Sat, 03 Sep 2005 09:24:15 -0700 Subject: [mysql 12071] éšŽå±¤åŒ–ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’MySQLã§æ‰±ã†ã€€ï¼ˆManaging Hierarchical Data in MySQLï¼‰ http://dev.mysql.com/tech-resources/articles/hierarchical-data.html ï¼ˆå›³ã¯ã“ã®ã‚µã‚¤ãƒˆã‚’å‚ç…§ã®ã“ã¨ï¼‰ Mike Hillyerè‘— åˆã‚ã« å¤šãã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¯ä¸€å›žãã‚‰ã„ã¯SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å†…ã§ã€éšŽå±¤åŒ–ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’ æ‰±ã£ãŸã“ã¨ãŒã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ãã®ã¨ãã¯ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ« ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯éšŽå±¤åŒ–ã—ãŸãƒ‡ãƒ¼ã‚¿ç”¨ã«é–‹ç™ºã•ã‚Œãªã‹ã£ãŸã¨è€ƒãˆãŸã¨æ€ã„ã¾ã™ã€‚ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¯éšŽå±¤åŒ–ã•ã‚Œã¦ãŠã‚‰ãš
t-wada 2006/03/16
éžå¸¸ã«å‚è€ƒã«ãªã‚‹

dbms
ãƒªãƒ³ã‚¯
CodeZineï¼šæ¥½ã€…ERDãƒ¬ãƒƒã‚¹ãƒ³ ç¬¬2å›žï¼šã€Œå›³æ›¸é¤¨ã®äºˆç´„ç”³è¾¼æ›¸ã€ç·¨
ã¯ã˜ã‚ã« ãŠã‹ã’ã•ã¾ã§ã€å‰å›žã®è¨˜äº‹ã¯å¤šãã®æ–¹ã€…ã‹ã‚‰ã”å¥½è©•ã‚’ã„ãŸã ã‘ãŸã‚ˆã†ã§ã»ã£ã¨ã—ã¦ãŠã‚Šã¾ã™ã€‚ã‚ã¡ã“ã¡ã®ãƒ–ãƒã‚°ãªã©ã‚’æ‹è¦‹ã—ã¦ã„ã¾ã™ã¨ã€è¨˜äº‹ã‚’ãã£ã‹ã‘ã«ã—ã¦èº«è¿‘ãªä¾‹ã§ERDã‚’æ›¸ã„ã¦ã¿ãŸæ–¹ã‚‚è¦‹å—ã‘ã‚‰ã‚Œã¾ã™ã€‚ä»Šå›žã‚‚èº«è¿‘ãªé¡Œæã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã¨ã„ã†ã‚‚ã®ã‚’è€ƒãˆã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ åˆè¨€è‘‰ã¯ã€ã€Œé‡ã¯è³ªã«è»¢åŒ–ã™ã‚‹ã€ã€‚ã§ã¯ã€ä»Šå›žã‚‚å¼µã‚Šåˆ‡ã£ã¦è¡Œãã¾ã—ã‚‡ã†ã€‚ å¯¾è±¡èªè€… ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã®åˆå¿ƒè€…ï½žä¸ç´šè€…ã€‚ å¿…è¦ãªç’°å¢ƒ ä»¥ä¸‹ã®ã„ãšã‚Œã‹ã®RDBMSã€‚ PostgreSQL 8.0ä»¥ä¸Š MySQL 4.0ä»¥ä¸Š HSQL DB 1.7.2ä»¥ä¸Š MaxDB 7.5ä»¥ä¸Š Oracle 10gä»¥ä¸Š SQL Server 2000ä»¥ä¸Š é¡Œæ ä»Šå›žã®é¡Œæã¯ã€è¿‘æ‰€ã®å›³æ›¸é¤¨ã«ã‚ã£ãŸæ›¸ç±ã®äºˆç´„ç”¨ç´™ï¼ˆå›³1ï¼‰ã§ã™ã€‚åä¾›ãŸã¡ã¨æœ¬ã‚’å€Ÿã‚Šã«è¡Œã£ãŸéš›ã«ã‚«ã‚¦ãƒ³ã‚¿ãƒ¼ã«ç½®ã„ã¦ã‚ã£ãŸã®ã§æ—©é€Ÿåˆ©ç”¨ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ã§ã¯ã€ãƒ‡ãƒ¼
t-wada 2005/10/04
dbms
ãƒªãƒ³ã‚¯
ï¼»MySQLã‚¦ã‚©ãƒƒãƒï¼½ç¬¬20å›ž MySQL 5.0ã§ä¸€æŒ™ã«å¢—åŠ ï¼Œæ§˜ã€…ãªç‰¹å¾´ã‚’æŒã¤ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãƒ»ã‚¨ãƒ³ã‚¸ãƒ³
MySQL 4.0ã§ã¯ï¼Œè¤‡æ•°ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¿ã‚¤ãƒ—ãŒé¸æŠžã§ãã‚‹ã€‚ãã‚Œãžã‚Œã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¿ã‚¤ãƒ—ã¯ï¼Œç‰©ç†çš„ãªãƒ‡ãƒ¼ã‚¿ã®æ ¼ç´æ–¹æ³•ã‚„ãƒ‡ãƒ¼ã‚¿å‡¦ç†ã®æ©Ÿèƒ½ãŒç•°ãªã£ã¦ã„ã‚‹ã€‚ã“ã®ã‚ˆã†ã«ç•°ãªã£ãŸãƒ†ãƒ¼ãƒ–ãƒ«ã‚¿ã‚¤ãƒ—ã‚’ã‚µãƒãƒ¼ãƒˆã§ãã‚‹ã®ã¯ï¼Œç•°ãªã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãƒ»ã‚¨ãƒ³ã‚¸ãƒ³ã‚’æŒã£ã¦ã„ã‚‹ã‹ã‚‰ã§ã‚ã‚Šï¼ŒMySQLã®å¤§ããªç‰¹å¾´ã§ã‚‚ã‚ã‚‹ã€‚ ã¾ã‚‚ãªããƒªãƒªãƒ¼ã‚¹ã•ã‚Œã‚‹MySQL 5.0ã§ã¯ï¼Œã•ã‚‰ã«å¤šãã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãƒ»ã‚¨ãƒ³ã‚¸ãƒ³ã‚’æè¼‰ã™ã‚‹ã€‚ä»Šå›žã¯ï¼ŒMySQL 5.0ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãƒ»ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ç´¹ä»‹ã™ã‚‹ã€‚ ã“ã‚Œã¾ã§ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãƒ»ã‚¨ãƒ³ã‚¸ãƒ³ ã¾ãšï¼ŒMySQL 4.0ã«æè¼‰ã•ã‚Œã¦ã„ã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãƒ»ã‚¨ãƒ³ã‚¸ãƒ³ã‚’èª¬æ˜Žã™ã‚‹ã€‚MySQL 4.0ã§ã¯ï¼Œè¡¨1ã®ã‚ˆã†ãªãƒ†ãƒ¼ãƒ–ãƒ«ã‚¿ã‚¤ãƒ—ã«å¯¾å¿œã—ãŸã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãƒ»ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ä½¿ç”¨ã§ãã‚‹ã€‚ è¡¨1â—MySQL 4.0ã§ä½¿ç”¨ã§ãã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¿ã‚¤ãƒ— ã‚«ãƒ†ã‚´ãƒª ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¿ã‚¤ãƒ— æ¦‚ç•¥
t-wada 2005/09/25
FEDERATEDã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãƒ»ã‚¨ãƒ³ã‚¸ãƒ³ -> ä»–ã®MySQLã‚µãƒ¼ãƒãƒ¼ã®ãƒ†ãƒ¼ãƒ–ãƒ«ãŒãƒãƒ¼ã‚«ãƒ«ã«ã‚ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã¨åŒæ§˜ã«ã‚¢ã‚¯ã‚»ã‚¹å¯èƒ½

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

dbms

design
ãƒªãƒ³ã‚¯
Problems with using stored procedures
Indeterminate Heuristics Probl ems with using stored procedures by Dale Asberry September 19, 2005 Summary This is a one-sided analysis of the downsides of using stored procedures. PLEASE do not take this to mean that I'm in any way against their *judicious* use. Errors in the stored procedures tend to affect the database globally, even for applications that are not using it For one of my clients,
t-wada 2005/09/24
dbms
ãƒªãƒ³ã‚¯
DBã®æ™‚åˆ»åˆã‚ã›ã«æ°—ã‚’ã¤ã‘ã‚ˆã† - sanonosaã€€ã‚·ã‚¹ãƒ†ãƒ ç®¡ç†ã‚³ãƒ©ãƒ é›†
ã‚µãƒ¼ãƒè¨å®šã«æ…£ã‚ŒãŸäººã§ã‚ã‚Œã°ã€ã¤ã„ã¤ã„DBã‚µãƒ¼ãƒã«ã‚‚NTPç‰ã‚’ä½¿ã£ãŸè‡ªå‹•æ™‚åˆ»ã‚’ã—ã¦ã—ã¾ã„ãŸããªã‚‹ã‚‚ã®ã§ã™ã€‚ã—ã‹ã—DBã®ä¸ã«ã¯ä¸‹æ‰‹ã«æ™‚åˆ»åˆã‚ã›ã‚’ã—ã¦ã—ã¾ã†ã¨ãƒ€ã‚¦ãƒ³ã—ã¦ã—ã¾ã†ã‚‚ã®ã‚‚ã‚ã‚‹ã®ã§æ°—ã‚’ã¤ã‘ã¾ã—ã‚‡ã†ã€‚ ã€æ™‚åˆ»åˆã‚ã›ã¨DBãƒ€ã‚¦ãƒ³ã®é–¢ä¿‚æ€§ã€‘ æ™‚åˆ»åˆã‚ã›ã¨è¨€ã£ã¦ã‚‚ã€ç¾åœ¨æ™‚åˆ»ã‚ˆã‚Šå…ˆã«é€²ã‚ã‚‹ãƒ‘ã‚¿ãƒ¼ãƒ³ã¨éŽåŽ»ã®æ™‚åˆ»ã«æˆ»ã™ãƒ‘ã‚¿ãƒ¼ãƒ³ãŒã‚ã‚Šã¾ã™ã€‚ã»ã¨ã‚“ã©ã®DBã§ã¯å‰è€…ã®ãƒ‘ã‚¿ãƒ¼ãƒ³ã§ã¯å•é¡ŒãŒã‚ã‚Šã¾ã›ã‚“ã€‚ã—ã‹ã—æ°—ã‚’ã¤ã‘ãªã‘ã‚Œã°ãªã‚‰ãªã„ã®ã¯å¾Œè€…ã®ãƒ‘ã‚¿ãƒ¼ãƒ³ã§ã™ã€‚æ™‚åˆ»ãŒéŽåŽ»ã«æˆ»ã‚‹ã¨DBã«ã‚ˆã£ã¦ã¯ã‚·ã‚¹ãƒ†ãƒ ä¸æ•´åˆã¨æ¤œçŸ¥ã•ã‚Œãƒ€ã‚¦ãƒ³ã—ã¦ã—ã¾ã†ã‚‚ã®ãŒã‚ã‚Šã¾ã™(ORACLEãªã©)ã€‚ ã€DBã®æ™‚åˆ»ã®åˆã‚ã›æ–¹ã€‘ ä¸€ç•ªå®‰å…¨ãªã®ã¯æ™‚åˆ»åˆã‚ã›ã‚’ã™ã‚‹å ´åˆã¯ãƒ¡ãƒ³ãƒ†æ—¥ã«å…¨ã‚·ã‚¹ãƒ†ãƒ ã‚’æ¢ã‚ãŸä¸Šã§æ™‚åˆ»ã‚’åˆã‚ã›ã‚‹ã“ã¨ã§ã™ã€‚ ã€è£æŠ€ã€‘ ã—ã‹ã—ã€ãã†ã¯è¨€ã£ã¦ã‚‚ã¨ã‚ã‚‰ã‚Œãªã„ã‚·ã‚¹ãƒ†ãƒ ã¨ã„ã†ã‚‚ã®ã‚‚ã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ãã†ã„ã£ãŸå ´åˆã¯ã“ã†ã„ã†è£æŠ€ãŒã‚ã‚Šã¾ã™ã€‚ãã‚Œã¯æ™‚åˆ»ã‚’
t-wada 2005/09/24
dbms

tips
ãƒªãƒ³ã‚¯
http://itpro.nikkeibp.co.jp/free/NSW/NEWS/20050830/167085/
t-wada 2005/08/31
design

dbms
ãƒªãƒ³ã‚¯
æ¥½ã€…ERDãƒ¬ãƒƒã‚¹ãƒ³ ç¬¬1å›žï¼šã€ŒãŠæŒã¡å¸°ã‚Šã”æ³¨æ–‡ç”¨ç´™ã€ç·¨ï¼šCodeZine
ã¯ã˜ã‚ã« ã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ã«ãŠã„ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã¯ä¸å¯æ¬ ã§ã™ã€‚ãã“ã§å¤šãã®æ–¹ãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¨è¨ˆæŠ€æ³•ã«ã¤ã„ã¦æ›¸ç±ã§å¦ã‚“ã ã‚Šã™ã‚‹ã®ã§ã™ãŒã€ãªã‹ãªã‹èº«ã«ã¤ã„ãŸã¨æ„Ÿã˜ã‚‰ã‚Œãªã„ã“ã¨ã‚‚å¤šã„ã®ã§ã¯ãªã„ã‹ã¨æ„Ÿã˜ã¾ã™ã€‚ ãã®ç†ç”±ã¯ã€å®Ÿå‹™ã§ä»»ã›ã‚‰ã‚Œã‚‹æ©Ÿä¼šã¨ã„ã†ã®ãŒå°‘ãªã„ã‹ã‚‰ã¨ã„ã†ã®ãŒå¤§ããªã‚‚ã®ã¨ã—ã¦æŒ™ã’ã‚‰ã‚Œã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã¨ã„ã†ã®ã¯ã€ã‚„ã¯ã‚Šé‡è¦ãªç®‡æ‰€ã§ã™ã‹ã‚‰è‡ªç„¶ã¨çµŒé¨“ã®ã‚ã‚‹äººã«ä»»ã›ã‚‰ã‚Œã‚‹ã“ã¨ãŒå¤šã„ã®ãŒå®Ÿæ…‹ã§ã™ã€‚ã—ã‹ã‚‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã‚’æ‹…å½“ã™ã‚‹ã®ã¯ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆå…¨ä½“ã®ä¸ã§ã‚‚ã”ãå°‘æ•°ã ã‘ã«ãªã‚Šã¾ã™ã‹ã‚‰ã€ãªã‹ãªã‹ãƒãƒ£ãƒ³ã‚¹ãŒå·¡ã£ã¦ãã¾ã›ã‚“ã€‚ ã—ã‹ã—ã€ãã‚Œã‚’å˜†ã„ã¦ã„ã‚‹ã°ã‹ã‚Šã§ã¯ã‚¹ã‚ãƒ«ãŒèº«ã«ã¤ã‹ãªã„ã®ã‚‚é“ç†ã§ã™ã€‚ãã“ã§èº«è¿‘ã«ã‚ã‚‹ã‚‚ã®ã‚’ä½•ã§ã‚‚æ‰‹å½“ãŸã‚Šæ¬¡ç¬¬ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã®ãƒã‚¿ã«ã—ã¦ã—ã¾ã†ã“ã¨ã§ã€ã‚³ãƒ„ã‚³ãƒ„ã¨åœ°åŠ›ã‚’ã¤ã‘ã¦ã„ã“ã†ã¨ã„ã†ã®ãŒã“ã®ã‚·ãƒªãƒ¼ã‚ºã®ä¸»æ—¨ã§ã™ã€‚ åˆè¨€è‘‰ã¯ã€ã€Œè¡¨çµ„ã¿ã‚’è¦‹ãŸã‚‰ERDã‚’æã‘ï¼ã€ã€€ã€‚ã§ã¯ã€
t-wada 2005/08/29
dbms

design
ãƒªãƒ³ã‚¯
ã‚µã‚¤ãƒœã‚¦ã‚ºMySQLæŽ¡ç”¨ã«è¦‹ã‚‹ç ´å£Šçš„ã‚¤ãƒŽãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ - naoyaã®ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼
ã‚µã‚¤ãƒœã‚¦ã‚ºãŒãã‚Œã¾ã§ã®ãƒ—ãƒãƒ—ãƒ©ã‚¤ã‚¨ã‚¿ãƒªãªå§¿å‹¢ã‹ã‚‰ã€MySQLã®æŽ¡ç”¨ã«è¸ã¿åˆ‡ã£ãŸèƒŒæ™¯ã«ã¯ä½•ãŒã‚ã‚‹ã®ã‹ã€‚ã‚µã‚¤ãƒœã‚¦ã‚ºã®ä»£è¡¨å–ç· å½¹ç¤¾é•·ã€é’é‡Žæ…¶ä¹…æ°ãŒãã®çœŸæ„ã‚’èªžã£ãŸã€‚ ã‚µã‚¤ãƒœã‚¦ã‚ºãŒè£½å“ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã«ä½¿ç”¨ã—ã¦ã„ã‚‹DBã‚’ç‹¬è‡ªDBã‹ã‚‰MySQLã«å¤‰æ›´ã—ãŸã€ãã®ç†ç”±ã‚’ç¤¾é•·è‡ªã‚‰ãŒèªžã‚‹ã¨ã„ã†è¨˜äº‹ã€‚å¸‚å ´ã«ãŠã‘ã‚‹MySQLã®ç¾åœ¨ã®çŠ¶æ³ãŒã‚ˆãåˆ†ã‹ã‚‹ã€éžå¸¸ã«æœ‰ç›Šãªè¨˜äº‹ã§ã™ã€‚ ä»¥å‰ã«NDO::Weblogã®æ–¹ã§'MySQL ã¯å•†ç”¨ RDBMS ã«ã¨ã£ã¦ã®ç ´å£Šçš„ã‚¤ãƒŽãƒ™ãƒ¼ã‚·ãƒ§ãƒ³'ã¨é¡Œã—ã¦ã€ã¯ã¦ãªã«ãŠã‘ã‚‹MySQLã®ä½¿ã„æ–¹ã‚’ä¾‹ã«ã€MySQLãŒã©ã†ã—ã¦ç ´å£Šçš„ã‹ã¨ã„ã†ã“ã¨ã‚’è¿°ã¹ã¾ã—ãŸã€‚ã¯ã¦ãªã«ãŠã„ã¦ã¯ã€ ãã“ã¾ã§ã†ã¾ãã„ãã‹ã©ã†ã‹ã¯åˆ¥ã¨ã—ã¦ã€MySQL ã‚„ PostgreSQL ãŒã©ã†ã—ã¦ç ´å£Šçš„ãªã®ã‹ã¨ã„ã†å•ã„ã«é–¢ã—ã¦ã¯ã€ã¾ãšç¬¬ä¸€ã«ãƒ•ãƒªãƒ¼ã ã‹ã‚‰ã¨ã„ã†ç‚¹ãŒæŒ™ãŒã‚Šã¾ã™ã€‚ã—ã‹ã—å®Ÿã¯ã“ã“ã¯é‡è¦ãªãƒã‚¤ãƒ³ãƒˆã§ã¯ãªãã€ã‚³ã‚¹ãƒˆãŒåŠ‡çš„ã«ä¸‹ãŒã£ãŸã“ã¨
t-wada 2005/08/28
dbms

think

business
ãƒªãƒ³ã‚¯
http://yamipro.ameblo.jp/entry-3872463068e49e3f9e00f7198926c6dd.html
t-wada 2005/08/28
dbms

design

hatena
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚«ãƒãƒ¬ãƒƒã‚¸ã¨ã„ã†è€ƒãˆæ–¹ - ãã—ã ã®Hatena
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã‚’ç”¨æ„ã™ã‚‹ã¨ãã€ã©ã†ã„ã†ãƒ‡ãƒ¼ã‚¿ã‚’ç”¨æ„ã—ã¾ã™ã‹ï¼Ÿ ã€Œæ³¨æ–‡ãŒã‚ã£ã¦å‡ºè·ã—ã¦ãªã„ãƒ‡ãƒ¼ã‚¿ã€ã€Œæ³¨æ–‡ãŒã‚ã£ã¦å‡ºè·ã—ã¦ã„ã¦å…¥é‡‘ãŒãªã„ãƒ‡ãƒ¼ã‚¿ã€ã¨ã„ã†é¢¨ã«æ¥å‹™ã®æµã‚Œã«ãã£ã¦ãƒ‡ãƒ¼ã‚¿ã‚’è€ƒãˆã‚‹ã“ã¨ãŒå¤šã„ã¨æ€ã„ã¾ã™ã€‚ ãŸã ã€ãƒ†ã‚¹ãƒˆã®æœ¬ã‚’è¦‹ã¦ã‚‚ã€ã©ã†ã‚„ã£ã¦ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã‚’ç”¨æ„ã™ã‚‹ã‹ã¨ã„ã†ã“ã¨ãŒæ›¸ã‹ã‚Œã¦ã„ã‚‹ã“ã¨ã¯å¤šãã‚ã‚Šã¾ã›ã‚“ã€‚ã¨ã„ã†ã‹å¸‚è²©ã®æœ¬ã§è¦‹ãŸã“ã¨ãŒã‚ã‚Šã¾ã›ã‚“ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã¯ã€ã²ã¨ã¤ã®å‡¦ç†ã§ã¾ã£ãŸãåˆ†å²ãŒãªãä¸Šã‹ã‚‰ä¸‹ã«SQLã‚’é †ç•ªã«ç™ºè¡Œã™ã‚‹ã¨ã„ã†ã“ã¨ãŒå°‘ãªãã‚ã‚Šã¾ã›ã‚“ã€‚ãã†ã„ã†ã¨ãã€C1ã¨ã‹C2ã¨ã‹ã®å‡¦ç†ã‚«ãƒãƒ¬ãƒƒã‚¸ã¨ã„ã†ã®ã¯ç°¡å˜ã«100%ã«è¿‘ããªã£ã¦ã—ã¾ã„ã€ãƒ†ã‚¹ãƒˆãŒã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®çŠ¶æ³ã‚’ç¶²ç¾…ã—ã¦ã„ã‚‹ã‹ã©ã†ã‹ã¨ã„ã†æŒ‡æ¨™ã«ã¯ãªã‚Šã«ãããªã‚Šã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã¯ã€ã€Œã™ã¹ã¦ã®å‡¦ç†ã‚’è¡Œã£ãŸã‹ã©ã†ã‹ã€ã¨ã„ã†å‡¦ç†ã‚«ãƒãƒ¬ãƒƒã‚¸ã§ã¯å……åˆ†ã§ã¯ãªãã€Œã™ã¹ã¦ã®
t-wada 2005/08/24
testing

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