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

tvsk id:tvsk

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

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

RDBã§ãƒ„ãƒªãƒ¼æ§‹é€ ã‚’å®Ÿç¾ã™ã‚‹ | ã‚ªãƒ¼ãƒˆãƒæ ªå¼ä¼šç¤¾
Tutorial Advent Calendar 22æ—¥ç›®ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®å‰é‡Žã§ã™ã€‚ å…ˆæ—¥ã€Rails ã§ãƒ„ãƒªãƒ¼æ§‹é€ ã«è§¦ã‚Œã‚‹æ©Ÿä¼šãŒã‚ã‚Šã€ãã®éš›ã«åˆã‚ã¦çŸ¥ã‚‹ã“ã¨ãŒå¤šãã‚ã‚Šã¾ã—ãŸã€‚ä»Šå›žã¯ãã®éš›ã«å¾—ã‚‰ã‚ŒãŸçŸ¥è¦‹ã‚’å…±æœ‰ã•ã›ã¦ã„ãŸã ã“ã†ã¨æ€ã„ã¾ã™ã€‚ ãƒ„ãƒªãƒ¼æ§‹é€ ã£ã¦ä½•ï¼Ÿã¾ãšã€ãƒ„ãƒªãƒ¼æ§‹é€ ï¼ˆæœ¨æ§‹é€ ï¼‰ã¨ã¯ãªã‚“ã®ã“ã¨ã§ã—ã‚‡ã†ã‹ï¼Ÿ Wikipediaã«ã‚ˆã‚‹ã¨ æœ¨æ§‹é€ ï¼ˆãã“ã†ãžã†ï¼‰ã¨ã¯ã€ã‚°ãƒ©ãƒ•ç†è«–ã®æœ¨ã®æ§‹é€ ã‚’ã—ãŸãƒ‡ãƒ¼ã‚¿æ§‹é€ ã®ã“ã¨ã€‚ã ãã†ã§ã™ã€‚ä¸‹ã«ç¤ºã—ãŸçµ„ç¹”å›³ã®ã‚ˆã†ã«ã€ã‚ã‚‹è¦ç´ ã‹ã‚‰æ´¾ç”Ÿã—ã¦éšŽå±¤æ§‹é€ ãŒæˆã‚Šç«‹ã£ã¦ã„ã‚‹ã‚‚ã®ã‚’ã€æœ¨ãŒæ ¹ã‹ã‚‰è‘‰ã¸ã¨åºƒãŒã£ã¦ã„ãæ§˜åã«ãªãžã‚‰ãˆã¦ãƒ„ãƒªãƒ¼æ§‹é€ ã¨å‘¼ã‚“ã§ã„ã‚‹ã‚ã‘ã§ã™ãã€‚ èº«è¿‘ãªã¨ã“ã‚ã§ã‚¤ãƒ¡ãƒ¼ã‚¸ã—ã‚„ã™ã„ã®ã¯ã€ãƒ‘ã‚½ã‚³ãƒ³ã®ãƒ•ã‚©ãƒ«ãƒ€ã§è¦‹ã‚‰ã‚Œã‚‹éšŽå±¤æ§‹é€ ã‚‚ãƒ„ãƒªãƒ¼æ§‹é€ ã«ã‚ãŸã‚Šã¾ã™ã€‚ RDB ã§ãƒ„ãƒªãƒ¼æ§‹é€ ã‚’å®Ÿç¾ã™ã‚‹æ–¹æ³•MySQL ã‚„ PostgresQL ã¨ã„ã£ãŸã€Web ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºã§ã‚ˆãç”¨ã„ã‚‰ã‚Œ
tvsk 2021/12/19
db

rdb

design
ãƒªãƒ³ã‚¯
MySQL InnoDBã®ãƒã‚¯ã‚¹ãƒˆã‚ãƒ¼ãƒãƒƒã‚¯ ãŠã•ã‚‰ã„ - SH2ã®æ—¥è¨˜
MySQLã®InnoDBã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¯è¡Œãƒãƒƒã‚¯ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã¾ã™ã€‚ã—ã‹ã—Oracleã¨åŒã˜æ„Ÿè¦šã§ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½œã£ã¦ã„ã‚‹ã¨ã€æ€ã‚ã¬ã¨ã“ã‚ã§ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ã«å‡ºãã‚ã™ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ã“ã‚Œã¯InnoDBã®ãƒãƒƒã‚¯ç¯„å›²ãŒOracleã‚ˆã‚Šã‚‚å¾®å¦™ã«åºƒã„ãŸã‚ã§ã™ã€‚ å®Ÿéš›ã®ä¾‹ã§ç¢ºèªã—ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ mysql> select * from t; +----+------+ | c1 | c2 | +----+------+ | 10 | a | | 15 | a | | 20 | a | | 25 | a | | 30 | a | | 35 | a | | 40 | a | | 45 | a | | 50 | a | +----+------+c1åˆ—ã¯ä¸»ã‚ãƒ¼ã«ãªã£ã¦ã„ã¾ã™ã€‚1ã¤ã‚ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã§ä»¥ä¸‹ã®SQLã‚’å®Ÿè¡Œã—ã¾ã™ã€‚ mysql> set tx_isolation = 'repeatable-r
tvsk 2021/11/30
mysql

nextkeylock

db

sql

strategy
ãƒªãƒ³ã‚¯
ScyllaDB - Wikipedia
ScyllaDB is an open-source distributed NoSQL wide-column data store. It was designed to be compatible with Apache Cassandra while achieving significantly higher throughputs and lower latencies. It supports the same protocols as Cassandra (CQL and Thrift) and the same file formats (SSTable), but is a completely rewritten implementation, using the C++20 language replacing Cassandra's Java, and the S
tvsk 2021/10/20
cassandra

nosql

db
ãƒªãƒ³ã‚¯
Sqlite vs. MySQL vs. PostgreSQL: A Comparison of Relational Databases | Logz.io
tvsk 2019/05/28
db

architecture

product

proscons

èªã¿ç‰©
ãƒªãƒ³ã‚¯
Selecting the Right Database for Your Microservices
Join our community of software engineering leaders and aspirational developers. Always stay in-the-know by getting the most important news and exclusive content delivered fresh to your inbox to learn more about at-scale software development.
tvsk 2019/05/28
DBé¸å®šã€‚redis ã«ã‚‚ãƒ•ã‚©ãƒ¼ã‚«ã‚¹

architecture

db

service
ãƒªãƒ³ã‚¯
GitHub - numetriclabz/awesome-db: A curated list of amazingly awesome database libraries, resources and shiny things by https://www.numetriclabz.com/
Aerospike - Aerospike Database Server â€“ flash-optimized, in-memory, nosql database Alchemy-Database - AlchemyDB is now Aerospike cstore_fdw - Fast columnar store for analytics with PostgreSQL website LMDB - Very fast embedded key/value store with full ACID semantics. memcache - Free & open source, high-performance, distributed memory object caching system monet db - website mongo - The Mongo Databa
tvsk 2019/05/28
db

index

list

opensource
ãƒªãƒ³ã‚¯
3Percent.club
I was born and raised in Thousand Oaks, CA . I have watched as my State/Country has tumbled into chaos and despotism. It has gotten so bad I cannot foresee a future I would want to raise children in. I was fortunate enough to grow up in a beautiful City by loving parents, I want the same for future generations. Too long have I sat on the sidelines expecting my â€œrepresentativesâ€ to take correct and
tvsk 2019/05/28
â€œfast interprocess communicationâ€ "No Server Process"

db

embedded

ipc

nosql
ãƒªãƒ³ã‚¯
MySQL 5.6ã§ã¯profilingãŒéžæŽ¨å¥¨ã«ãªã£ã¦ã—ã¾ã£ãŸä»¶ | GMOãƒ¡ãƒ‡ã‚£ã‚¢ ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€DBAã®ãŸãªã‹ã§ã™ã€‚ ã¹ã‚“ã‚Šãªã¹ã‚“ã‚Šãªprofilingã§ã™ãŒã€5.6ã‹ã‚‰ã¯éžæŽ¨å¥¨ã«ãªã£ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ mysql56> SET profiling= 1; Query OK, 0 rows affected, 1 warning (0.03 sec) mysql56> SHOW WARNINGS; +---------+------+----------------------------------------------------------------------+ | Level | Code | Message | +---------+------+----------------------------------------------------------------------+ | Warning | 1287 | '@@profiling' is
tvsk 2018/07/24
MySQL ã® performance_schema ã®ä½¿ã„ã‹ãŸ å°Žå…¥

mysql

db

tuning

application
ãƒªãƒ³ã‚¯
IBM Developer
IBM Developer is your one-stop location for getting hands-on training and learning in-demand skills on relevant techno logies such as generative AI, data science, AI, and open source.
tvsk 2017/02/24
MySQLã‹ã‚‰æ´¾ç”Ÿã—ãŸè£½å“ã®ç´¹ä»‹ã€‚ãã‚Œã‚‰ã‚’é¸ã¶ãƒ¡ãƒªãƒƒãƒˆã¨å‹•å‘è¦³æ¸¬

ibm

èªã¿ç‰©

db

architecture
ãƒªãƒ³ã‚¯
(pdf) MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°æ¦‚è¦ - Oracle
<Insert Picture Here> MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°æ¦‚è¦ æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ« MySQL Global Business Unit CopyrightÂ© 2011, Oracle. All rights reserved. ä»¥ä¸‹ã®äº‹é …ã¯ã€å¼Šç¤¾ã®ä¸€èˆ¬çš„ãªè£½å“ã®æ–¹å‘æ€§ã«é–¢ã™ã‚‹æ¦‚è¦ã‚’èª¬æ˜Žã™ã‚‹ã‚‚ã®ã§ã™ã€‚ ã¾ãŸã€æƒ…å ±æä¾›ã‚’å”¯ä¸€ã®ç›®çš„ã¨ã™ã‚‹ã‚‚ã®ã§ã‚ã‚Šã€ã„ã‹ãªã‚‹å¥‘ç´„ã«ã‚‚çµ„ã¿è¾¼ã‚€ã“ã¨ã¯ ã§ãã¾ã›ã‚“ã€‚ä»¥ä¸‹ã®äº‹é …ã¯ã€ãƒžãƒ†ãƒªã‚¢ãƒ«ã‚„ã‚³ãƒ¼ãƒ‰ã€æ©Ÿèƒ½ã‚’æä¾›ã™ã‚‹ã“ã¨ã‚’ã‚³ãƒŸãƒƒãƒˆãƒ¡ãƒ³ ãƒˆï¼ˆç¢ºç´„ï¼‰ã™ã‚‹ã‚‚ã®ã§ã¯ãªã„ãŸã‚ã€è³¼è²·æ±ºå®šã‚’è¡Œã†éš›ã®åˆ¤æ–ææ–™ã«ãªã•ã‚‰ãªã„ã§ä¸‹ã• ã„ã€‚ã‚ªãƒ©ã‚¯ãƒ«è£½å“ã«é–¢ã—ã¦è¨˜è¼‰ã•ã‚Œã¦ã„ã‚‹æ©Ÿèƒ½ã®é–‹ç™ºã€ãƒªãƒªãƒ¼ã‚¹ãŠã‚ˆã³æ™‚æœŸã«ã¤ã„ ã¦ã¯ã€å¼Šç¤¾ã®è£é‡ã«ã‚ˆã‚Šæ±ºå®šã•ã‚Œã¾ã™ã€‚ Oracleã¨Javaã¯ã€Oracle Corporation åŠã³ãã®åä¼šç¤¾ã€é–¢é€£ä¼šç¤¾ã®ç±³å›½åŠã³ãã®ä»–ã®å›½ã«ãŠã‘ã‚‹ç™»éŒ²å•†æ¨™ã§ã™ã€‚æ–‡
tvsk 2017/02/24
ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®æ–¹é‡ç–å®š/çµŒå–¶çš„åˆ¤æ–ã®ã‚¤ãƒ³ãƒ—ãƒƒãƒˆ

db

mysql

architecture

performance

slide

decision
ãƒªãƒ³ã‚¯
NoSQL - Wikipedia
NoSQLï¼ˆä¸€èˆ¬ã« "Not only SQL" ã¨è§£é‡ˆã•ã‚Œã‚‹ï¼‰ã¨ã¯ã€é–¢ä¿‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ (RDBMS) ä»¥å¤–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ã‚’æŒ‡ã™ãŠãŠã¾ã‹ãªåˆ†é¡žèªžã§ã‚ã‚‹ã€‚é–¢ä¿‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“åå®šè¦ã«é©ç”¨ã—ã¦ããŸé•·ã„æ´å²ã‚’æ‰“ç ´ã—ã€ãã‚Œä»¥å¤–ã®æ§‹é€ ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®åˆ©ç”¨ãƒ»ç™ºå±•ã‚’ä¿ƒé€²ã•ã›ã‚ˆã†ã¨ã™ã‚‹é‹å‹•ã®æ¨™èªžã¨ã—ã¦ã®æ„å‘³åˆã„ã‚’æŒã¤ã€‚é–¢ä¿‚ãƒ¢ãƒ‡ãƒ«ã§ã¯ãªã„ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã®ç‰¹å¾´ã¨ã—ã¦ã€å›ºå®šã•ã‚ŒãŸã‚¹ã‚ãƒ¼ãƒžã«ç¸›ã‚‰ã‚Œãªã„ã“ã¨ã€é–¢ä¿‚ãƒ¢ãƒ‡ãƒ«ã®çµåˆæ“ä½œã‚’åˆ©ç”¨ã—ãªã„ã“ã¨ã€æ°´å¹³ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ãŒç¢ºä¿ã—ã‚„ã™ã„äº‹ãŒå¤šã„ã“ã¨ã€é«˜åº¦ãªãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã‚’åˆ©ç”¨ã§ããªã„ã‚‚ã®ãŒå¤šã„ã“ã¨ãªã©ãŒæŒ™ã’ã‚‰ã‚Œã‚‹ã€‚å¦è¡“çš„ãªä¸–ç•Œã§ã¯ã€ã“ã®ç¨®ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã“ã¨ã‚’æ§‹é€ åž‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ (structured storage) ã¨å‘¼ã¶ã“ã¨ãŒå¤šã„[1][2][3][4]ã€‚ NoSQLç³»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ã¯ã€ãƒ‡ãƒ¼ã‚¿ã®æ ¼ç´ãŠã‚ˆã³å–å¾—ãŒé«˜åº¦ã«æœ€é©åŒ–ã•ã‚Œã¦ã„
tvsk 2016/05/10
NoSQL ã®åˆ†é¡ž KeyValueStore -> DynamoDB, Redis/SortedColumn-> Cassandra, HBase /DocumentStore -> MongoDB, CouchDB

word

db
ãƒªãƒ³ã‚¯
ã„ã¬ã”ã‚„ãã£ã¨
Lãƒžã‚¦ãƒ³ãƒˆæ©Ÿæã§æ’®å½±ã•ã‚ŒãŸå†™çœŸç´¹ä»‹ã¨æ„›ã¨åè¦‹ã§ç‡»è£½ã•ã‚ŒãŸã‚³ãƒ©ãƒ ã€‚
tvsk 2016/03/30
åˆ†å‰²ã€é›†ç´„ã€ã‚µãƒžãƒªã€ãƒžãƒ¼ãƒˆ

db

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

readlater

db
ãƒªãƒ³ã‚¯
ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¯”è¼ƒ Cassandraã€Mongodbã€SQLiteã€H2ã€MySQLã€Postgres - cypher256's blog
ä¸‹è¨˜ã®ã‚ˆã†ãªã‚·ã‚¹ãƒ†ãƒ ã§ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒè‰¯ã•ã’ãª SQLite ã‚’ä½¿ç”¨äºˆå®šã§ã™ãŒã€ã‚‚ã£ã¨é€Ÿã„ã‚‚ã®ãŒç„¡ã„ã‹ç¢ºèªã®ãŸã‚ä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’è¨ˆæ¸¬ã—ã¦ã¿ã¾ã—ãŸã€‚SQL åˆ©ç”¨å‰æã§ã™ãŒã€NoSQL ãŒåœ§å€’çš„ãªæ€§èƒ½ã‚’å‡ºã™å ´åˆã¯æ¤œè¨Žã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã®ã§ KVS ã‚‚ç¢ºèªã—ã¾ã—ãŸã€‚ ãƒ‡ãƒ¼ã‚¿ä»¶æ•°ã¯ 1 å„„ä»¶ç¨‹åº¦ã€JDBC SQL åˆ©ç”¨å¯èƒ½ INSERTã€UPDATE ã¯ãƒãƒƒãƒ SELECT ã¯ä¸»ã‚ãƒ¼ã‚¢ã‚¯ã‚»ã‚¹æ€§èƒ½ã‚’é‡è¦– å°†æ¥ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã®ãŸã‚ã®åˆ†æ•£ã¯ã‚ã‚Šãˆã‚‹ãŒã€ã‚¹ã‚¿ãƒ³ãƒ‰ã‚¢ãƒãƒ³ã§é…ã„ã®ã¯ã ã‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¯”è¼ƒ è¨ˆæ¸¬ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å ã‚¿ã‚¤ãƒ— å½¢æ…‹ è©•åˆ¤ è¨ˆæ¸¬ã«ã¤ã„ã¦ã®å‚™è€ƒ SQLite RDB çµ„ã¿è¾¼ã¿ â€»2 ãŠã‚‚ã¡ã‚ƒã€Androidæ¨™æº– JDBCæ“ä½œ â€»1 H2 RDB çµ„ã¿è¾¼ã¿ â€»2 çµ„ã¿è¾¼ã¿æœ€é€Ÿ JDBCæ“ä½œ â€»1 Derby RDB çµ„ã¿è¾¼ã¿ â€»2 Javaæ¨™æº–ã§
tvsk 2015/08/24
2012å¹´ã®è¨˜äº‹ã€‚åˆ†æ•£KVS ã¨ SQLiteã€MySQL ãªã©

db

performance

2012
ãƒªãƒ³ã‚¯
http://old.postgresql.jp/misc/seminar/2003-05-17/B3_nagayasu.pdf
tvsk 2012/02/25
2ç›¸ã‚³ãƒŸãƒƒãƒˆã¨ã¯ã€‚pptè³‡æ–™ã€‚

db
ãƒªãƒ³ã‚¯
çŸ¥ã‚‰ã‚Œã–ã‚‹ã€Œãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ãƒˆã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã€ï¼ˆ3ï¼‰ï½žã‚¹ã‚ãƒ¼ãƒžã¨ãƒ¡ã‚¿ãƒ‡ãƒ¼ã‚¿ã®è¬Ž ï¼ Publickey
ã‚»ãƒ¼ãƒ«ã‚¹ãƒ•ã‚©ãƒ¼ã‚¹ãŒæŽ¡ç”¨ã—ã¦ã„ã‚‹ãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ãƒˆã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã§ã¯ã€ã™ã¹ã¦ã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒåŒä¸€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€åŒä¸€ã‚¹ã‚ãƒ¼ãƒžã‚’å…±æœ‰ã—ã¦ã„ã¾ã™ã€‚ ã§ã¯ã€å€‹åˆ¥ã«å…¥åŠ›é …ç›®ã‚’å¢—ã‚„ã™ã‚ˆã†ãªã‚¹ã‚ãƒ¼ãƒžã®å¤‰æ›´ã‚’ä¼´ã†ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºã‚„ã€æ–°ãŸãªãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã—ã¦ãã“ã«ç‹¬è‡ªãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã™ã‚‹ã‚ˆã†ãªã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®æ–°è¦ä½œæˆã¯ã§ããªã„ã®ã‹ï¼Ÿ ã¨ã„ãˆã°ã€ãã‚“ãªã“ã¨ã¯ãªãã€ã‚»ãƒ¼ãƒ«ã‚¹ãƒ•ã‚©ãƒ¼ã‚¹ãŒæä¾›ã™ã‚‹ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã®ä¸Šã§ã€è‡ªç”±ã«é …ç›®ã®è¿½åŠ ã‚„æ–°ã—ã„ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½œæˆãŒå¯èƒ½ã§ã™ã€‚ å…¨ãƒ¦ãƒ¼ã‚¶ãƒ¼ã§ã‚¹ã‚ãƒ¼ãƒžã‚’å…±æœ‰ã—ãªãŒã‚‰ã€ã—ã‹ã—å€‹åˆ¥ã®ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºã‚’è¨±å®¹ã™ã‚‹ã€‚ã“ã®ä¸€è¦‹çŸ›ç›¾ã™ã‚‹è¦ä»¶ã‚’ã€ã‚»ãƒ¼ãƒ«ã‚¹ãƒ•ã‚©ãƒ¼ã‚¹ã¯ã©ã®ã‚ˆã†ã«å®Ÿç¾ã—ã¦ã„ã‚‹ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ï¼ˆæœ¬ã‚¨ãƒ³ãƒˆãƒªã¯ã€ŒçŸ¥ã‚‰ã‚Œã–ã‚‹ã€Žãƒžãƒ«ãƒãƒ†ãƒŠãƒ³ãƒˆã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã€ï¼ˆ2ï¼‰ï½žã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®ã‚«ã‚®ã¯çµ„ç¹”IDã€ã‹ã‚‰ã®ç¶šãã§ã™ã€‚ï¼‰ å…¬é–‹ã•ã‚Œã¦ã„ã‚‹ã‚¹ã‚ãƒ¼ãƒžã‚’è¦‹ã¦ã¿ã‚‹ ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒã‚¹ã‚ãƒ¼ãƒžã‚’å¤‰æ›´ã—ãŸã‚Šã€æ–°è¦ãƒ†ãƒ¼ãƒ–ãƒ«
tvsk 2012/02/03
æ±Žç”¨DBå®šç¾©ã€€salesforceã®äº‹ä¾‹ç ”ç©¶

db

design

saas

architecture
ãƒªãƒ³ã‚¯
1