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

peketamin id:peketamin

dbã¨Databaseã«é–¢ã™ã‚‹peketaminã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (20)

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

Five Online Database Modelling Services
https://www.red-gate.com/simple-talk/databases/sql-server/database-administration-sql-server/five-online-database-modelling-services/ Advances in web-based techno logies, particularly HTML5, have made online data modeling a more credible option than ever. Tools have emerged that make it easy and efficient to design a database and generate the SQL code for a specific database product, offering a via
peketamin 2016/02/20
database

erå›³

db
ãƒªãƒ³ã‚¯
Sign in - Google Accounts
Not your computer? Use a private browsing window to sign in. Learn more about using Guest mode
peketamin 2016/02/02
DB

concurrency

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

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

DB

MySQL

database

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

Database

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

mysql

explain
ãƒªãƒ³ã‚¯
ãŠä½¿ã„ã®ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã®ãŠä¾›ã« Illuminate - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
peketamin 2014/10/24
DB

database

php
ãƒªãƒ³ã‚¯
TOTO88 | Bocoran Slot Gacor Hari Ini
Mencari slot gacor hari ini? Anda berada di tempat yang tepat! Dalam dunia perjudian online, istilah "gacor" sering digunakan untuk menggambarkan slot yang sedang "panas" atau memiliki peluang tinggi untuk memberikan kemenangan besar kepada pem ain. Dalam artikel panjang ini, kita akan membahas segala sesuatu tentang slot gacor: cara menemukannya, strategi untuk bermain, dan tentu saja, rekomendasi
peketamin 2014/08/03
database

db

postgresql

streaming
ãƒªãƒ³ã‚¯
DataGrip: The Cross-Platform IDE for Databases & SQL by JetBrains
A powerful IDE from JetBrains for SQL on macOS, Windows, and Linux.
peketamin 2014/06/11
DB

database
ãƒªãƒ³ã‚¯
ãã‚“ãªãƒˆãƒ©ãƒ³ã‚µã‚™ã‚¯ã‚·ãƒ§ãƒ³ãƒžãƒãƒ¼ã‚·ã‚™ãƒ£ã¦ã‚™å¤§ä¸ˆå¤«ã‹ï¼Ÿ
10. XAãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®SQLï¼ˆMySQLã®å ´åˆï¼‰ mysql> XA START 'xatest'; Query OK, 0 rows affected (0.00 sec) mysql> INSERT INTO account VALUES(1, 'takezoe'); Query OK, 1 row affected (0.04 sec) mysql> XA END 'xatest'; Query OK, 0 rows affected (0.00 sec) mysql> XA PREPARE 'xatest'; Query OK, 0 rows affected (0.00 sec) mysql> XA COMMIT 'xatest'; Query OK, 0 rows affected (0.00 sec)
peketamin 2014/06/01
database

DB

ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³
ãƒªãƒ³ã‚¯
sandman.io - Domain Name For Sale | Dan.com
Buyer Protection Program When you buy a domain name at Dan.com, youâ€™re automatically covered by our unique Buyer Protection Program. Read more about how we keep you safe on our Trust and Security page. Next to our secure domain ownership transfer process, we strictly monitor all transactions. If anything looks weird, we take immediate action. And if the seller doesn't deliver on their part of the
peketamin 2014/04/26
api

database

rest

db
ãƒªãƒ³ã‚¯
ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒãªã‹ã£ãŸã‚‰INSERTã—ã¦è¿”ã™ã¿ãŸã„ãªã®ã‚’ç¢ºå®Ÿã«ã‚„ã‚‹ | ãŠãã‚‰ãã¯ãã‚Œã•ãˆã‚‚å¹³å‡¡ãªæ—¥ã€…
find_or_createçš„ãªã‚„ã¤ã¯å¤§ä½“ã©ã‚“ãªORMã§ã‚‚ ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æŽ¢ã™ ç„¡ã‹ã£ãŸã‚‰INSERT ã¿ãŸã„ã«å®Ÿè£…ã™ã‚‹ã“ã¨ã«ãªã‚‹ã¨æ€ã†ã€‚ãŸã ã“ã‚Œã ã¨ã€1ã¨2ã®é–“ã§ãƒ¬ãƒ¼ã‚¹ã‚³ãƒ³ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ã§ã‚¨ãƒ©ãƒ¼èµ·ãã‚‹ã“ã¨ãŒã‚ã‚‹ã€‚ä»–ã®ãƒ—ãƒã‚»ã‚¹ãŒINSERTã—ã¦ã—ã¾ã†ã¨ã‹ãã†ã„ã†ã‚„ã¤ã€‚ ãã‚Œã‚’é˜²ãŽãŸã„å ´åˆã«ã€1ã®æ™‚ç‚¹ã§FOR UPDATEã™ã‚‹ã®ã¯ã™ã”ããƒ€ãƒ¡ã§ã€ç©ºè¡Œã«FOR UPDATEã—ãŸã‚Šã™ã‚‹ã¨MySQLã ã¨ç››å¤§ã«ä¹™ã‚‹ã®ã¯æœ‰åãªè©±ã€‚ ã‚¨ãƒ©ãƒ¼ã‚’èµ·ã“ã•ãªã„ã§ã€ç¢ºå®Ÿã«ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’å–ã‚ŠãŸã„å ´åˆã«ã¯ã©ã†ã™ã‚Œã°ã‚ˆã„ã‹ã¨ã„ã†ã¨ã€ä»¥ä¸‹ã®ã‚ˆã†ã«ã™ã‚‹ã®ãŒè‰¯ã„ã¨æ€ã£ã¦ã„ã‚‹ã€‚UNIQUEã‚ãƒ¼åˆ¶ç´„ãªã‚ŠãŒã¡ã‚ƒã‚“ã¨ä»˜ã„ã¦ã„ã‚‹å‰æã€‚ã‚µãƒ³ãƒ—ãƒ«ã‚³ãƒ¼ãƒ‰ã¯Tengã®å ´åˆã€‚ sub find_or_create_surely { my ($self, $table, $where, $opt) = @_; my $row; my $txn = $self-
peketamin 2014/03/03
MySQL

ORM

database

Insert

db

ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³
ãƒªãƒ³ã‚¯
Comparison of database administration tools - Wikipedia
The following tables compare general and technical information for a number of available database administration tools. Please see individual product articles for further information. This article is neither all-inclusive nor necessarily up to date. Systems listed on a light purple background are no longer in active development.
peketamin 2013/06/17
database

db
ãƒªãƒ³ã‚¯
3å¹´åŠã®Î²ã‚’çµŒã¦Amazon RDSãŒã€Œä¸€èˆ¬å…¬é–‹ã€ã«
ç±³Amazon Web Servicesï¼ˆAWSï¼‰ã¯6æœˆ6æ—¥ã€3å¹´åŠã«ã‚ãŸã£ã¦Î²ç‰ˆã¨ã—ã¦æä¾›ã—ã¦ããŸã€ŒAmazon Relational Database Serviceï¼ˆRDSï¼‰ã€ã®æ£å¼æä¾›é–‹å§‹ã‚’ç™ºè¡¨ã—ãŸã€‚ ç±³Amazon Web Servicesï¼ˆAWSï¼‰ã¯6æœˆ6æ—¥ã€ã‚¯ãƒ©ã‚¦ãƒ‰ä¸Šã§ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’é‹ç”¨ã§ãã‚‹ã€ŒAmazon Relational Database Serviceï¼ˆRDSï¼‰ã€ã®æ£å¼æä¾›é–‹å§‹ã‚’ç™ºè¡¨ã—ãŸã€‚ Amazon RDSã¯Î²ç‰ˆã¨ã—ã¦ç«‹ã¡ä¸Šã’ã‚‰ã‚Œã¦ã‹ã‚‰3å¹´åŠãŒçµŒéŽã—ã€ä»Šã§ã¯Samsungã‚„Unileverã€NASAã‚¸ã‚§ãƒƒãƒˆæŽ¨é€²ç ”ç©¶æ‰€ã¨ã„ã£ãŸå¤§æ‰‹ä¼æ¥ã‚„æ”¿åºœæ©Ÿé–¢ã«ã‚‚æŽ¡ç”¨ã•ã‚Œã‚‹ã‚ˆã†ã«ãªã£ãŸã€‚ã¾ãŸå½“åˆã‚µãƒãƒ¼ãƒˆã—ã¦ã„ãŸMySQLã«åŠ ãˆã€Oracleã€SQL Serverãªã©ã®ä¸»è¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã«å¯¾å¿œã™ã‚‹ã¨ã¨ã‚‚ã«ã€å¤šæ•°ã®æ–°æ©Ÿèƒ½ã‚’è¿½åŠ ã—ã¦ããŸã¨AWSã¯èª¬æ˜Žã™ã‚‹ã€‚ ã“ã†ã—ãŸ
peketamin 2013/06/07
DB

database

aws
ãƒªãƒ³ã‚¯
HBaseã¨ã¯ã©ã‚“ãªNoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãªã®ã‹ï¼Ÿ æ—¥æœ¬èªžã§èªã‚ã‚‹æƒ…å ±ã‚’é›†ã‚ã¦ã¿ãŸ
FacebookãŒæ–°ã—ã„ã‚µãƒ¼ãƒ“ã‚¹ã€ŒMessagesã€ã®åŸºç›¤ã¨ã—ã¦ã€NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã€ŒHBaseã€ã‚’é¸æŠžã—ãŸã“ã¨ã‚’ã€å…ˆæ—¥ã®è¨˜äº‹ã€ŒFacebookãŒæ–°ã‚µãƒ¼ãƒ“ã‚¹ã®åŸºç›¤ã«ã—ãŸã®ã¯ã€MySQLã§ã‚‚Cassandraã§ã‚‚ãªãã€HBaseã ã£ãŸã€ã§ç´¹ä»‹ã—ã¾ã—ãŸã€‚ HBaseã¯ã€Facebookã«ã‚ˆã‚‹ã¨æ¬¡ã®ã‚ˆã†ãªç‰¹å¾´ã‚’å‚™ãˆã¦ã„ã‚‹ã¨èª¬æ˜Žã•ã‚Œã¦ã¾ã™ã€‚ è² è·ã«å¯¾ã—ã¦éžå¸¸ã«é«˜ã„ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã¨æ€§èƒ½ã‚’ç™ºæ® Cassandraã‚ˆã‚Šã‚‚ã‚·ãƒ³ãƒ—ãƒ«ãªConsistency Modelï¼ˆä¸€è²«æ€§ãƒ¢ãƒ‡ãƒ«ï¼‰ã‚’å‚™ãˆã¦ã„ã‚‹ è‡ªå‹•ãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚¹ã€ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ã€åœ§ç¸®æ©Ÿèƒ½ ã‚µãƒ¼ãƒãƒ¼ã”ã¨ã«æ•°åå€‹ã®ã‚·ãƒ£ãƒ¼ãƒ‰ã‚’å‰²ã‚Šå½“ã¦å¯èƒ½ã€ãªã©ãªã© ã“ã®HBaseã¯ã©ã®ã‚ˆã†ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãªã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ æƒ…å ±ã‚’é›†ã‚ã¦ã¿ã¾ã—ãŸã€‚ HBaseå…¥é–€ã®ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ æœ€åˆã«ç´¹ä»‹ã™ã‚‹ã®ã¯ã€ŒHBaseã‚¨ãƒãƒ³ã‚¸ã‚§ãƒªã‚¹ãƒˆã€Tatsuya Kawanoæ°ã®ãƒ—ãƒ¬ã‚¼ãƒ³
peketamin 2013/01/18
Hadoop

HBase

nosql

database

db

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

programming

database

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

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

å‹‰å¼·

db

ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ

ãƒ—ãƒã‚°ãƒ©ãƒ
ãƒªãƒ³ã‚¯
å‰Šé™¤ãƒ•ãƒ©ã‚°ã®ã¯ãªã—
6. id name pass is_deleted 1 ryu xxx FALSE 2 ken xxx FALSE 3 honda xxx TRUE 8. id name pass is_deleted 1 ryu xxx FALSE 2 ken xxx FALSE 3 honda xxx TRUE 3 honda xxx FALSE
peketamin 2011/08/10
index

database

postgresql

slide

slideshare

db

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

oracle

database

è¨è¨ˆ

Oracle

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

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

é–‹ç™º

ã‚µãƒ¼ãƒ“ã‚¹
ãƒªãƒ³ã‚¯
DBã‚µãƒ¼ãƒãƒ¼ã®è² è·åˆ†æ•£
MySQLã‚¢ã‚¯ã‚»ã‚¹ã‚’è² è·åˆ†æ•£ã™ã‚‹ ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‹ã‚‰ã®ã‚¢ã‚¯ã‚»ã‚¹æ•°ãŒéžå¸¸ã«å¤šã„Webã‚µã‚¤ãƒˆã«ãŠã„ã¦ã€MySQLã®SLAVEã‚µãƒ¼ãƒãƒ¼ã‚’è¤‡æ•°å°ä¸¦ã¹ã¦è² è·åˆ†æ•£ã•ã›ã‚‹ã¨ã„ã†ã“ã¨ãŒã‚ˆãè¡Œã‚ã‚Œã¦ã„ã¾ã™ã€‚ãŸã ã€Webã‚¢ã‚¯ã‚»ã‚¹ã®è² è·åˆ†æ•£ã¯ä¸€èˆ¬çš„ãªãƒ†ãƒ¼ãƒžãªã®ã§ã„ã‚ã„ã‚ãªã¨ã“ã‚ã§èªžã‚‰ã‚Œã¦ã„ã‚‹ã®ã«å¯¾ã—ã€DBã‚¢ã‚¯ã‚»ã‚¹ã®è² è·åˆ†æ•£ã¨ã„ã†ãƒ†ãƒ¼ãƒžã¯ä¸€èˆ¬çš„ã§ãªã„ã®ã‹ã‚ã¾ã‚Šèªžã‚‰ã‚Œã¦ã„ãªã„ã‚ˆã†ã«æ„Ÿã˜ã¾ã™ã€‚ DBã‚¢ã‚¯ã‚»ã‚¹ã‚’è² è·åˆ†æ•£ã™ã‚‹ã«ã‚ãŸã£ã¦ä¸€ç•ªè’ã£ã½ã„æ–¹æ³•ã¯ã€Webã‚µãƒ¼ãƒãƒ¼ä¸Šã®ãƒ—ãƒã‚°ãƒ©ãƒ ã®ä¸ã§ã©ã®SLAVEã‚µãƒ¼ãƒãƒ¼ã«æŽ¥ç¶šã™ã‚‹ã‹ã‚’ãƒ©ãƒ³ãƒ€ãƒ ã§æ±ºã‚ã‚‹æ–¹æ³•ã§ã™ã€‚ãƒ©ãƒ³ãƒ€ãƒ ã¨è¨€ã£ã¦ã‚‚é•·æ™‚é–“ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ã„ã‚‹ã¨ã»ã¼æŽ¥ç¶šå…ˆãŒå‡ç‰åŒ–ã•ã‚Œã‚‹ã®ã§ã€ä¸€è¦‹ã“ã®æ–¹æ³•ã§ã‚‚å•é¡Œãªã„ã‚ˆã†ã«è¦‹ãˆã¾ã™ã€‚ã—ã‹ã—ã“ã®æ–¹æ³•ã ã¨ã€æŽ¥ç¶šã—ã«è¡Œã“ã†ã¨ã—ãŸSLAVEã‚µãƒ¼ãƒãƒ¼ãŒé«˜è² è·ã‚‚ã—ãã¯ã‚µãƒ¼ãƒ“ã‚¹åœæ¢ä¸ã§ã‚ã£ã¦ã‚‚æ§‹ã‚ãšæŽ¥ç¶šã—ã«è¡Œã£ã¦ã—ã¾ã†ã¨ã„ã†å•é¡ŒãŒã‚ã‚Šã¾ã™ã€‚ ã“ã®ã‚ˆã†ãªå•é¡Œã‚’è§£æ±ºã™ã‚‹
peketamin 2011/07/22
DB

mysql

linux

IPã‚¢ãƒ‰ãƒ¬ã‚¹

database

è² è·åˆ†æ•£

ã‚µãƒ¼ãƒãƒ¼

ã‚·ã‚¹ãƒ†ãƒ

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

programming

DB

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

SQL

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

db

è¨è¨ˆ

DBè¨è¨ˆ
ãƒªãƒ³ã‚¯
ã€ŒMobageã€å·¨å¤§ã‚µãƒ¼ãƒãƒ¼ã‚’æ”¯ãˆã‚‹DeNAã®MySQLæ´»ç”¨ã¨ã¯ï½œã€Techç·ç ”ã€‘
Mobageãªã©ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦MySQLã‚’æŽ¡ç”¨ã—ã¦ã„ã‚‹DeNAã¯ã€ã“ã®ã»ã©MySQLã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£æœ€å¤§ã®ã‚¤ãƒ™ãƒ³ãƒˆã§ã€ã€ŒCorporate Contributor of the Year 2011ã€ã‚’å—è³žã—ãŸã€‚ãã“ã§ç¤ºã•ã‚ŒãŸDeNAã®ä¸–ç•Œã«é€šç”¨ã™ã‚‹æŠ€è¡“åŠ›ã¨ã¯â”€â”€ã€‚ ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ä¸–ç•Œä¸ã§ä½¿ã‚ã‚Œã¦ã„ã‚‹MySQLã€‚å¤§è¦æ¨¡ãªãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’å‡¦ç†ã™ã‚‹ã‚µã‚¤ãƒˆæ§‹ç¯‰ã«ã¯ä¸å¯æ¬ ã®æŠ€è¡“ã ãŒã€æ ªå¼ä¼šç¤¾ãƒ‡ã‚£ãƒ¼ãƒ»ã‚¨ãƒŒãƒ»ã‚¨ãƒ¼ï¼ˆDeNAï¼‰ã¯MySQLã‚’å¾¹åº•ã—ã¦ä½¿ã„å€’ã—ã€ç‹¬è‡ªã®æ‹¡å¼µæŠ€è¡“ã‚’é–‹ç™ºã™ã‚‹ã“ã¨ã‚’é€šã—ã¦ã€ãã®å¯ç”¨æ€§ã‚’é«˜ã‚ã¦ããŸã€æ—¥æœ¬ã‚’ä»£è¡¨ã™ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼ä¼æ¥ã®ä¸€ã¤ã¨ã—ã¦çŸ¥ã‚‰ã‚Œã¦ã„ã‚‹ã€‚ç¾åœ¨ã€Mobageï¼ˆãƒ¢ãƒã‚²ãƒ¼ï¼‰ã‚µãƒ¼ãƒ“ã‚¹ã‚’å‹•ã‹ã™ãŸã‚ã«ã€ç´„700å°ã®MySQLã‚µãƒ¼ãƒãƒ¼ãŒç¨¼åƒã—ã¦ãŠã‚Šã€ãã®æ•°ã¯ä¸–ç•Œçš„ã«ã‚‚æœ‰æ•°ã®ã‚‚ã®ã ã€‚ 4æœˆä¸æ—¬ã«ç±³ã‚µãƒ³ã‚¿ã‚¯ãƒ©ãƒ©ã§é–‹ã‹ã‚ŒãŸMySQLã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£æœ€å¤§ã®ã‚¤ãƒ™ãƒ³ãƒˆã€MySQL
peketamin 2011/05/11
mysql

DeNA

work

interview

MySQL

é–‹ç™º

ã‚¤ãƒ³ãƒ•ãƒ©

database

DB
ãƒªãƒ³ã‚¯
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ | BLOG - DeNA Engineering
ã“ã‚“ã«ã¡ã¯ã“ã‚“ã«ã¡ã¯ã€‚æœ€è¿‘ãŠè…¹ç—›ã„ã°ã£ã‹ã‚Šè¨€ã£ã¦ã‚‹ã“ã¨ã§æœ‰åãªiwanagaã§ã™ã€‚ DeNAã¯å¤–éƒ¨çš„ã«ã¯ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ çš„ãªéƒ¨åˆ†ã®æ–¹ãŒãƒ•ã‚£ãƒ¼ãƒãƒ£ãƒ¼ã•ã‚Œã‚‹ã“ã¨ãŒå¤šã„ã§ã™ãŒã€å®Ÿã¯ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®æä¾›ã‚‚è¡Œã£ã¦ã„ã¾ã™ã€‚æ€ªç›—ãƒãƒ¯ã‚¤ãƒ¤ãƒ«ã¨ã‹ã€ã©ã“ã‹ã§èžã„ãŸã“ã¨ãŒã‚ã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ åƒ•ã¯DeNAã§ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ãŒèª•ç”Ÿã—ãŸè¾ºã‚Šã‹ã‚‰ãšã£ã¨ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã‚’è¦‹ã¦ãã¾ã—ãŸãŒã€ãã‚“ãªé‹ç”¨ã®ä¸ã§è‡ªåˆ†ãŒè²¯ã‚ã¦ããŸçŸ¥è¦‹ã¨ã‹TIPSã‚’ã”ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‹ã‚Œã“ã‚Œ10ã‚¿ã‚¤ãƒˆãƒ«è¿‘ãã¯ãƒ¬ãƒ“ãƒ¥ãƒ¼ã—ãŸã‚Šé‹ç”¨ã—ãŸã‚Šã—ã¦ã‚‹ãŸã‚çµæ§‹è¨€ã„ãŸã„ã“ã¨ã¯ã„ã£ã±ã„ã‚ã‚‹ã®ã§ã€å°å‡ºã—ã«ã—ã¤ã¤è©•åˆ¤ã‚ˆã‘ã‚Œã°æ¬¡ã‚‚æ›¸ãã¾ã™ã€‚ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ä¸€è¦§ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ - Techno logy of DeNA ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€2 - Techno logy of DeNA ã€ŒMySQL
peketamin 2010/11/16
mysql

ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ

ã‚ã¨ã§èªã‚€

DeNA

database

db

performance

tips

RDBMS
ãƒªãƒ³ã‚¯
1