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

willnet id:willnet

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

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

BiTemporal Data Modelã«å…¥é–€ä¸ - ã ã„ãŸã„ã‚ˆãã‚ã‹ã‚‰ãªã„ãƒ–ãƒã‚°
BiT emporal Modelingã«ã¤ã„ã¦ã¡ã‚‡ã£ã¨ã ã‘èª¿ã¹ãŸã‚Šã—ãŸã®ã§ãƒ¡ãƒ¢ã€‚ åŸºæœ¬çš„ã« Temporalâ€¨Data Models(pptæ³¨æ„)ã¨Temporal Databasesã‚’å¤§å¹…ã«ç«¯æŠ˜ã£ãŸã‚‚ã®ã«ä»–ã®è³‡æ–™ã‚’å°‘ã—ã ã‘å…¥ã‚ŒãŸæ„Ÿã˜ã®å†…å®¹ã§ã™ã€‚ Temporal Data Models BiT emporal Modelingã¯Temporal Data Modelsã¨ã„ã†åˆ†é‡Žã§ç ”ç©¶ã•ã‚Œã¦ã„ã‚‹ãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã®ä¸€ç¨®ã§ã™ã€‚ Temporal Data Modelã§ã¯æ™‚é–“ã«ã‚ˆã£ã¦å¤‰ã‚ã£ã¦ã„ããƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã„ã¾ã™ã€‚ ã¡ãªã¿ã«ã“ã“ã§ã„ã†Data Modelã¯Data Structureï¼‹Query Languageã‚’æ„å‘³ã—ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãŒæ™‚é–“ã«ã‚ˆã£ã¦å¤‰ã‚ã‚‹ã¨ã„ã†ã“ã¨ã¯ä½•ã‚‰ã‹ã®Updateæ“ä½œãŒå¿…è¦ã§ã™ã€‚ä¸€ç•ªå˜ç´”ãªæ–¹æ³•ã‚’è€ƒãˆã‚‹ã¨DBã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’ç›´æŽ¥æ›´æ–°ï¼ˆç„¡åŠ¹ã«ãªã£ãŸãƒ‡ãƒ¼ã‚¿ã¯å‰Šé™¤ï¼‰ã™ã‚‹ã“ã¨ã§Updateæ“ä½œã‚’å®Ÿ
willnet 2018/07/12
db
ãƒªãƒ³ã‚¯
Create unique constraint with null columns
I have a table with this layout: CREATE TABLE Favorites ( FavoriteId uuid NOT NULL PRIMARY KEY, UserId uuid NOT NULL, RecipeId uuid NOT NULL, MenuId uuid ); I want to create a unique constraint similar to this: ALTER TABLE Favorites ADD CONSTRAINT Favorites_UniqueFavorite UNIQUE(UserId, MenuId, RecipeId); However, this will allow multiple rows with the same (UserId, RecipeId), if MenuId IS NULL. I
willnet 2018/06/23
db
ãƒªãƒ³ã‚¯
Data Models
Data Models: A Comprehensive Guide to Structuring Information for Optimal Insights and Decision-Making In the realm of data management, the use of effective data models plays a pivotal role in organizing and representing information in a structured and meaningful way. Data models serve as the blueprint for databases, facilitating efficient data storage, retrieval, and analysis. This article delves
willnet 2017/12/28
db
ãƒªãƒ³ã‚¯
BrewersCapTheorem - ãƒ–ãƒªãƒ¥ãƒ¯ãƒ¼ã® CAP å®šç†
BrewersCapTheorem - ãƒ–ãƒªãƒ¥ãƒ¯ãƒ¼ã® CAP å®šç† ç›®æ¬¡ ã“ã®æ–‡æ›¸ã«ã¤ã„ã¦ ãƒ–ãƒªãƒ¥ãƒ¯ãƒ¼ã® CAP å®šç† - Amazon ã¨ eBay ã®ã‚¯ãƒ¼ãƒ«ã‚¨ã‚¤ãƒ‰ ãƒ–ãƒªãƒ¥ãƒ¯ãƒ¼ã®(CAP)å®šç† ä¸€è²«æ€§ (Consistency) å¯ç”¨æ€§ (Availability) åˆ†å‰²è€æ€§(Partition Tolerance) å®šç†ã®é‡è¦æ€§ å›³è§£ã§è¨¼æ˜Ž CAP ã¨æŠ˜ã‚Šåˆã† 1. åˆ†å‰²è€æ€§ã‚’è«¦ã‚ã‚‹ 2. å¯ç”¨æ€§ã‚’è«¦ã‚ã‚‹ 3. ä¸€è²«æ€§ã‚’è«¦ã‚ã‚‹ 4. BASE ã«è·³ã¶ 5. å•é¡Œã‚’ã‹ã‚ã—ã¦è¨è¨ˆã™ã‚‹ ã¾ã¨ã‚ å‚è€ƒæ–‡çŒ® ãƒ–ãƒªãƒ¥ãƒ¯ãƒ¼ã® CAP å®šç† ã“ã®æ–‡æ›¸ã«ã¤ã„ã¦ "Brewer's CAP Theorem - The kool aid Amazon and Ebay have been drinking" ã®æ—¥æœ¬èªžè¨³ã§ã™. http://www.julianbrowne.com/article/view
willnet 2017/02/22
db
ãƒªãƒ³ã‚¯
CAPå®šç†ã‚’è¦‹ç›´ã™ã€‚â€œCAPã®3ã¤ã‹ã‚‰2ã¤ã‚’é¸ã¶â€ã¨ã„ã†èª¬æ˜Žã¯ãƒŸã‚¹ãƒªãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã ã£ãŸ
åˆ†æ•£ã‚·ã‚¹ãƒ†ãƒ ã«ãŠã„ã¦ã¯ä»¥ä¸‹ã®3ã¤ã®è¦ç´ ã®ã†ã¡2ã¤ã—ã‹åŒæ™‚ã«æº€ãŸã™ã“ã¨ãŒã§ããªã„ã€ã¨ã„ã†CAPå®šç†ã‚’æå”±ã—ãŸã®ã¯ã€Eric Breweræ°ã§ã—ãŸã€‚ Cï¼šConsistencyï¼ˆä¸€è²«æ€§ï¼‰ Aï¼šAvailabilityï¼ˆå¯ç”¨æ€§ï¼‰ Pï¼šTolerance to network Paritionsï¼ˆãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯åˆ†æ–ã¸ã®è€æ€§ï¼‰ ä¸€èˆ¬ã«ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã¯ã€ä¸€è²«æ€§ï¼ˆCï¼‰ã¨å¯ç”¨æ€§ï¼ˆAï¼‰ã‚’ã§ãã‚‹ã ã‘ä¿è¨¼ã™ã‚‹ä»£ã‚ã‚Šã«ã€ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯åˆ†æ–ã¸ã®è€æ€§ï¼ˆPï¼‰ã‚’çŠ ç‰²ã«ã—ã¦ã„ã¾ã™ã€‚ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ãŒé€”ä¸ã§åˆ‡ã‚ŒãŸã‚Šå¤§ããé…å»¶ã—ãŸå ´åˆã€å‹•ä½œãŒä¿è¨¼ã•ã‚Œãªããªã£ã¦ã—ã¾ã†ã‚ã‘ã§ã™ã€‚ ä¸€æ–¹ã§NoSQLã§ã¯ä¸€è²«æ€§ï¼ˆCï¼‰ã‚ˆã‚Šã‚‚å¯ç”¨æ€§ï¼ˆAï¼‰ã¨ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯åˆ†æ–ã¸ã®è€æ€§ï¼ˆPï¼‰ã‚’å„ªå…ˆã•ã›ã‚‹ã‚‚ã®ãŒå¤šãã€åˆ†æ•£ã‚·ã‚¹ãƒ†ãƒ ã§ã®å‹•ä½œã«å‘ã„ã¦ã„ã‚‹ã¨èª¬æ˜Žã•ã‚Œã¾ã™ã€‚ã“ã®ã‚ˆã†ã«NoSQLã®èª¬æ˜Žã«ã“ã®CAPå®šç†ãŒã—ã°ã—ã°å¼•ç”¨ã•ã‚Œã‚‹ã“ã¨ã«ãªã‚Šã€NoSQLã®æ™®åŠã¨ã¨
willnet 2016/03/11
microserviceã‚’è¨è¨ˆã™ã‚‹æ™‚ã®è€ƒãˆæ–¹ã«ã‚‚é€šã˜ã‚‹æ°—ãŒã™ã‚‹

db
ãƒªãƒ³ã‚¯
[Ruby] ä¾‹ãˆã°ã€ActiveRecord ã® connection_pool ã‚’æ¢ã‚ã‚‹ - sonots:blog
willnet 2016/03/09
rails

db
ãƒªãƒ³ã‚¯
DELETE_FLAG ã‚’ä»˜ã‘ã‚‹å‰ã«ç¢ºèªã—ãŸã„ã“ã¨ã€‚ - Qiita
DELETE_FLAG ã¨ã„ã†æ€è€ƒåœæ¢ãƒ•ãƒ©ã‚° DELETE_FLAG ã¨ã„ã† boolean ã®åˆ—ãŒ DB è¨è¨ˆã§ã‚ˆãè©±é¡Œã«ãªã‚Šã¾ã™ã€‚ è«–ç†å‰Šé™¤ã¨ã„ã†è¨€è‘‰ã§ä¸Šæ‰‹ã«è«–ç†æ¦è£…ã—ã€ã‚¹ã‚ã‚’è¦‹ã›ã‚‹ã¨ã™ãã«å…¥ã‚ŒãŸãŒã‚‹äººãŒãŠã‚Šã€ ä¸€æ–¹ã§ãã‚Œã«ã¤ã‚ˆãåå¯¾ã™ã‚‹äººã‚‚ã„ã¾ã™ã€‚ è‡ªåˆ†ã®çµŒé¨“ã¨ã—ã¦ã¯ã€åºƒç¾©ã®è«–ç†å‰Šé™¤ã¯ã‚ã‚Šãˆã‚‹ã¨æ€ã„ã¾ã™ãŒã€å®Ÿç¾æ–¹æ³•ãŒ DELETE_FLAG ã ã¨ãªã£ãŸæ™‚ã€ãã‚Œã¯ã‚ã¾ã‚Šè€ƒãˆã¦ãªã„ã§ãªã‚“ã¨ãªããƒ‘ã‚¿ãƒ¼ãƒ³ã¨ã—ã¦ç››ã‚Šè¾¼ã‚“ã§ã‚‹å ´åˆãŒå¤šã„ã¨æ„Ÿã˜ã¾ã™ã€‚ ãŸã ã—ã€è¨è¨ˆã«å”¯ä¸€ã®ç”ãˆã¯ç„¡ã„ã®ã§ã€ã‚‚ã—ã‹ã—ãŸã‚‰ãã‚ŒãŒå¦¥å½“ãªè¨è¨ˆã§ã‚ã‚‹å ´åˆãŒã‚ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ä»Šå›žã¯ã€ŒDELETE ãƒ•ãƒ©ã‚°ãŒãªãœãƒ€ãƒ¡ãªã®ã‹ï¼Ÿã€ãªã©ã¨ã„ã†è©±ã‚’ã™ã‚‹ã¤ã‚‚ã‚Šã‚‚ã€ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã ã¨æ–è¨€ã™ã‚‹ã¤ã‚‚ã‚Šã‚‚ã‚ã‚Šã¾ã›ã‚“ã€‚ å•é¡Œã¯ã€ä»•æ§˜ã‚’ãã¡ã‚“ã¨æŠŠæ¡ã™ã‚‹ã¨ã€ã€Œæœ€é©ãªè¨è¨ˆã¯ DELETE_FLAG ã§ã¯ãªã„ã€ã¨ã„ã†å ´åˆãŒæœ‰ã£ã¦ã€ãã®å ´åˆã¯ã€ãã®æœ€é©ãªè¨è¨ˆ
willnet 2015/03/24
db
ãƒªãƒ³ã‚¯
Adding a NOT NULL Column to an Existing Table | Viget
Despite some exciting advances in the field, like Node, Redis, and Go, a well-structured relational database fronted by a Rails or Sinatra (or Django, etc.) app is still one of the most effective toolsets for building things for the web. In the coming weeks, Iâ€™ll be publishing a series of posts about how to be sure that youâ€™re taking advantage of all your RDBMS has to offer. ASSUMING MY LAST POST
willnet 2014/11/08
ã‚«ãƒ©ãƒ è¶³ã—ãŸæ™‚ã«null: falseã ã‘ã—ã¦ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã‚’æŒ‡å®šã—ãªã„å ´åˆã€dbã®ç¨®é¡žã«ã‚ˆã£ã¦æŒ™å‹•ãŒç•°ãªã‚‹

db

rails
ãƒªãƒ³ã‚¯
Offsite Backup for Databases | Dumper
MySQL | PostgreSQL | Mongo DB | Redis Works with AWS, Linode, DigitalOcean, Rackspace, Heroku and more. Automatic daily backup to Amazon S3. Review your backup strategy Replication and RAID aren't a backup. What happens if your database is wiped by a developer by mistake, or taken hostage by an attacker? You have a virtual machine snapshot, but what happens when a wrong instance was dropped? What a
willnet 2012/09/01
railsã®dbãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ï¼ä»Šåº¦ä½¿ã†

rails

db
ãƒªãƒ³ã‚¯
http://outoftime.github.io/sunspot/
willnet 2011/06/18
å…¨æ–‡æ¤œç´¢ã®Solrã‚’ä½¿ã†ãŸã‚ã®ãƒ—ãƒ©ã‚°ã‚¤ãƒ³

rails

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

db
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ¦‚å¿µ - maeshimaã®æ—¥è¨˜
ã“ã‚“ãŒã‚‰ãŒã‚‹ã®ã§ãƒ¡ãƒ¢ ACID RDBã®ç‰¹æ€§ã‚’è¡¨ã—ãŸè¨€è‘‰ Atomic åŽŸåæ€§ Consistency ä¸€è²«æ€§ã€‚ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³é–‹å§‹ã¨çµ‚äº†æ™‚ã«ã‚ã‚‰ã‹ã˜ã‚ä¸Žãˆã‚‰ã‚ŒãŸæ•´åˆæ€§ã‚’æº€ãŸã™ã“ã¨ã‚’ä¿è¨¼ã™ã‚‹ã€‚ Isolation ç‹¬ç«‹æ€§ Durability æ°¸ç¶šæ€§ ACID (ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ç§‘å¦) - Wikipedia BASE RDBä»¥å¤–ã®(ãŠãã‚‰ãNoSQLã®)ã‚·ã‚¹ãƒ†ãƒ ã®ç‰¹æ€§ã‚’è¡¨ã—ãŸè¨€è‘‰ Basically Available å¯ç”¨æ€§ãŒåŸºæœ¬ Soft-state åŽ³å¯†ã§ãªã„çŠ¶æ…‹é·ç§» Eventual Consistency çµæžœã¨ã—ã¦æ•´åˆæ€§ãŒã¨ã‚Œã‚‹ CAP DBã¯ä¸‹è¨˜ã®3ã¤å…¨ã¦ã‚’åŒæ™‚ã«æº€ãŸã™ã“ã¨ãŒå‡ºæ¥ãªã„ã€‚RDBã¯CAåž‹ã§ã€NoSQLã¯CPåž‹ã€PAåž‹ç‰ã„ã‚ã„ã‚ãƒ‘ã‚¿ãƒ¼ãƒ³ãŒã‚ã‚‹ã€‚ consistency èª°ã‹ãŒãƒ‡ãƒ¼ã‚¿ã‚’æ›´æ–°ã—ãŸã‚‰ã€ãã®å¾Œã¯å¿…ãšæ›´æ–°å¾Œã®ãƒ‡ãƒ¼ã‚¿ãŒè¿”ã‚‹ã€‚ACIDã®Cã¨ã¯é•ã†ã€‚ availabi
willnet 2011/02/12
å¾©ç¿’ç”¨ã‚»ãƒ«ã‚¯ãƒžï¼BASEã¨CAPã¯è¦šãˆã«ãã„ãƒ»ãƒ»ãƒ»

db
ãƒªãƒ³ã‚¯
TwitterãŒåˆ†æ•£ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã€ŒGizzardã€å…¬é–‹ï¼ Scalaã§æ›¸ã‹ã‚ŒãŸShardingã‚’å®Ÿç¾ã™ã‚‹ãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢
TwitterãŒåˆ†æ•£ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã€ŒGizzardã€å…¬é–‹ï¼ Scalaã§æ›¸ã‹ã‚ŒãŸShardingã‚’å®Ÿç¾ã™ã‚‹ãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ Twitterã¯ç‹¬è‡ªã«é–‹ç™ºã—ãŸåˆ†æ•£ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã®ã€ŒGizzardã€ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã¨ã—ã¦å…¬é–‹ã—ã¾ã—ãŸã€‚Gizzardã¯Scalaã§æ›¸ã‹ã‚ŒãŸJavaVMä¸Šã§å‹•ä½œã™ã‚‹ãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã§ã€PHPã‚„Rubyã¨ã„ã£ãŸWebã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰ã®è¦æ±‚ã‚’è‡ªå‹•çš„ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«åˆ†æ•£ã™ã‚‹ã“ã¨ã§ã€å¤§è¦æ¨¡ã§å¯ç”¨æ€§ã®é«˜ã„åˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å®¹æ˜“ã«å®Ÿç¾ã™ã‚‹ãŸã‚ã®ã‚‚ã®ã§ã™ã€‚ Gizzardï¼šãƒ•ã‚©ãƒ«ãƒˆãƒˆãƒ¬ãƒ©ãƒ³ãƒˆãªåˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å®Ÿç¾ The Twitter Engineering Blog: Introducing Gizzard, a framework for creating distributed datastores Twitterã®ãƒ–ãƒã‚°ã«ãƒã‚¹ãƒˆã•ã‚ŒãŸã€ŒIntroducing Gizzard
willnet 2010/11/05
shardingã‚’æ¥½ã«ã™ã‚‹twitterè£½ãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢

twitter

db
ãƒªãƒ³ã‚¯
Long-running transaction - Wikipedia
This article needs additional citations for verification. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed. Find sources:Â "Long-running transaction"Â â€“Â newsÂ Â· newspapersÂ Â· booksÂ Â· scholarÂ Â· JSTOR (October 2015) (Learn how and when to remove this message) Long-running transactions (also known as the saga interaction pattern[1]
willnet 2010/07/08
ã‚ã¨ã§ï¼coodinatorãŒfailureãªæ™‚ã«compesationã‚’ä½¿ã£ã¦rollbackçš„ãªã“ã¨ã‚’å®Ÿç¾ã™ã‚‹ã£ã½ã„ã‘ã©æ—¢å˜ã®transactionã¨å…·ä½“çš„ã«ä½•ãŒé•ã†ã®ã‹ã¯ã‚ˆãåˆ†ã‹ã‚‰ãªã„

db
ãƒªãƒ³ã‚¯
2ç›¸ã‚³ãƒŸãƒƒãƒˆ - Wikipedia
ã“ã®è¨˜äº‹ã¯æ¤œè¨¼å¯èƒ½ãªå‚è€ƒæ–‡çŒ®ã‚„å‡ºå…¸ãŒå…¨ãç¤ºã•ã‚Œã¦ã„ãªã„ã‹ã€ä¸ååˆ†ã§ã™ã€‚ å‡ºå…¸ã‚’è¿½åŠ ã—ã¦è¨˜äº‹ã®ä¿¡é ¼æ€§å‘ä¸Šã«ã”å”åŠ›ãã ã•ã„ã€‚ï¼ˆã“ã®ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã®ä½¿ã„æ–¹ï¼‰ å‡ºå…¸æ¤œç´¢?:Â "2ç›¸ã‚³ãƒŸãƒƒãƒˆ"Â â€“Â ãƒ‹ãƒ¥ãƒ¼ã‚¹Â Â· æ›¸ç±Â Â· ã‚¹ã‚«ãƒ©ãƒ¼Â Â· CiNiiÂ Â· J-STAGEÂ Â· NDLÂ Â· dlib.jpÂ Â· ã‚¸ãƒ£ãƒ‘ãƒ³ã‚µãƒ¼ãƒÂ Â· TWL (2015å¹´10æœˆ) 2ç›¸ã‚³ãƒŸãƒƒãƒˆï¼ˆTwo-Phase Commitï¼‰ã¨ã¯ã€ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãŠã„ã¦ã€åˆ†æ•£ã‚·ã‚¹ãƒ†ãƒ å†…ã®å…¨ãƒŽãƒ¼ãƒ‰ãŒãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®ã‚³ãƒŸãƒƒãƒˆã«åˆæ„ã™ã‚‹ãŸã‚ã®åˆ†æ•£ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã‚ã‚‹ã„ã¯ãƒ—ãƒãƒˆã‚³ãƒ«ã§ã‚ã‚‹ã€‚ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯éšœå®³ã‚„ãƒŽãƒ¼ãƒ‰æ•…éšœã®å ´åˆã‚‚è€ƒæ…®ã•ã‚Œã€çµæžœã¨ã—ã¦ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¯ã‚³ãƒŸãƒƒãƒˆãŒæˆåŠŸã™ã‚‹ã‹å¤±æ•—ã™ã‚‹ã‹ã®ã„ãšã‚Œã‹ã®çŠ¶æ…‹ã¨ãªã‚‹ã€‚ã—ã‹ã—ã€Dale Skeen ã¨ãƒžã‚¤ã‚±ãƒ«ãƒ»ã‚¹ãƒˆãƒ¼ãƒ³ãƒ–ãƒ¬ãƒ¼ã‚«ãƒ¼ã®ç ”ç©¶ã«ã‚ˆã‚Œã°ã€2ç›¸ã‚³ãƒŸãƒƒãƒˆã¯åŒæ™‚ã«è¤‡æ•°ã®ã‚µã‚¤ãƒˆãŒï¼ˆç„¡ä½œç‚º
willnet 2010/07/08
ã“ã®ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã®2ç›¸ã¨ã¯ã€Œèª¿æ•´è€…; coordinatorã€ãŒå…¨ã€Œå‚åŠ è€…; cohortsã€ã®èª¿æ•´ã‚’è¡Œã†ã€Œã‚³ãƒŸãƒƒãƒˆè¦æ±‚ç›¸; commit-request phaseã€ã¨ã€èª¿æ•´è€…ã®æ±ºå®šã«ã‚ˆã£ã¦å…¨å‚åŠ è€…ãŒãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’å®Œäº†ã•ã›ã‚‹ã€Œã‚³ãƒŸãƒƒãƒˆç›¸; commit phaseã€ã§ã‚ã‚‹

db
ãƒªãƒ³ã‚¯
ã‚¹ã‚¯ãƒªãƒ—ãƒˆè¨€èªžã®æ¯ã®æ ¹ã‚’æ¢ã‚ã‚‹ã®ã¯æ¡ˆå¤– SSD ã‹ã‚‚ãª - kwatchã®æ—¥è¨˜
å¤§å¤‰ãŸã„ã¸ã‚“èˆˆå‘³æ·±ã„è¨˜äº‹ã€‚å…¨ãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼ã«ã¨ã£ã¦ã€‚ HDDã®ä»£ã‚ã‚Šã«SSDã‚’åˆ©ç”¨ã—ãŸã‚‰ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ€§èƒ½ã¯ã©ã‚Œã ã‘å‘ä¸Šã™ã‚‹ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ã‚ªãƒ©ã‚¯ãƒ«ã¨å¯Œå£«é€šãŒå…±åŒæ¤œè¨¼ã‚’è¡Œã„ã€ãã®çµæžœã‚’ãƒ›ãƒ¯ã‚¤ãƒˆãƒšãƒ¼ãƒ‘ãƒ¼ã¨ã—ã¦å…ˆé€±ç™ºè¡¨ã—ã¾ã—ãŸ ...(snip)... HDDã¯200ã‚¹ãƒ¬ãƒƒãƒ‰ã§æ€§èƒ½ãŒé æ‰“ã¡ãªã®ã«å¯¾ã—ã€SSDã¯200ã‚¹ãƒ¬ãƒƒãƒ‰ã‹ã‚‰300ã‚¹ãƒ¬ãƒƒãƒ‰ã«ãªã£ã¦ã‚‚ã¾ã æ€§èƒ½ã¯ä¸Šæ˜‡ã€‚ãŸã ã—ã€300ã‚¹ãƒ¬ãƒƒãƒ‰æ™‚ã«ã¯CPUåˆ©ç”¨çŽ‡ãŒ100ï¼…ã«è¿‘ã¥ã„ã¦ãŠã‚Šã€å…ˆã«CPUæ€§èƒ½ã®æ–¹ãŒãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¨ãªã£ã¦ã—ã¾ã£ãŸã‚ˆã†ã§ã™ã€‚ HDDã‚’SSDã«ã—ãŸã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã©ã‚Œã ã‘é€Ÿããªã‚‹ã‹ï¼Ÿ ã‚ªãƒ©ã‚¯ãƒ«ã¨å¯Œå£«é€šãŒå®Ÿé¨“ ï¼ Publickey å‹•çš„ãªã‚¹ã‚¯ãƒªãƒ—ãƒˆè¨€èªž (Ruby ã‚„ Python ãªã©) ã¨é™çš„ãªã‚³ãƒ³ãƒ‘ã‚¤ãƒ«åž‹è¨€èªž (C++ ã‚„ Java ãªã©) ã§ã¯ã€ã ã„ãŸã„ 5 å€ã‹ã‚‰ 10 å€ãã‚‰ã„ã®é€Ÿåº¦å·®ãŒã‚ã‚‹ã€‚ãã‚Œã§ã‚‚ã‚¹ã‚¯ãƒª
willnet 2010/04/27
DBã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ãŒãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã®æ™‚ä»£ãŒçµ‚ã‚ã‚‹ã‹ã‚‚ï¼Ÿã¨è¨€ã†è©±ã€‚ã‚¹ã‚¯ãƒªãƒ—ãƒˆè¨€èªžã©ã†ã“ã†ã¯ã„ã‚ã‚“ãªè¦‹æ–¹ãŒã‚ã‚‹ã‹ã‚‰ä½•ã¨ã‚‚

db
ãƒªãƒ³ã‚¯
HDDã‚’SSDã«ã—ãŸã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã©ã‚Œã ã‘é€Ÿããªã‚‹ã‹ï¼Ÿ ã‚ªãƒ©ã‚¯ãƒ«ã¨å¯Œå£«é€šãŒå®Ÿé¨“
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åˆ©ç”¨ã™ã‚‹éš›ã«ã¯ã€é«˜ã„æ€§èƒ½ã‚’å¼•ãå‡ºã™ãŸã‚ã«ç‰©ç†è¨è¨ˆã‚’ã—ã€ã‚¹ã‚ãƒ¼ãƒžã‚’å·¥å¤«ã—ã€ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¡Œã†ã“ã¨ãŒã¤ãã«è¡Œã‚ã‚Œã¦ãã¾ã—ãŸã€‚ æ€§èƒ½ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¯ãŸã„ãŒã„HDDã«ã‚ã‚Šã€ã„ã‹ã«ãã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’å›žé¿ã™ã‚‹ã‹ãŒãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒã‚¤ãƒ³ãƒˆã§ã™ãŒã€æœ€è¿‘ã§ã¯æ€§èƒ½å‘ä¸Šã®ãŸã‚ã®æ¦å™¨ã¨ã—ã¦ã€HDDã‚ˆã‚Šã‚‚ãšã£ã¨ã‚¢ã‚¯ã‚»ã‚¹æ€§èƒ½ã®é«˜ã„SSDãŒæ³¨ç›®ã•ã‚Œã¦ã„ã¾ã™ã€‚SSDã¯HDDã¨ç½®ãæ›ãˆã‚‹ã ã‘ã§ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ã¾ã£ãŸãæ‰‹ã‚’åŠ ãˆãšã«æ€§èƒ½å‘ä¸Šã‚’å¯èƒ½ã«ã™ã‚‹æ‰‹æ®µã¨ã—ã¦éžå¸¸ã«é…åŠ›çš„ã§ã™ã€‚ HDDã®ä»£ã‚ã‚Šã«SSDã‚’åˆ©ç”¨ã—ãŸã‚‰ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ€§èƒ½ã¯ã©ã‚Œã ã‘å‘ä¸Šã™ã‚‹ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ã‚ªãƒ©ã‚¯ãƒ«ã¨å¯Œå£«é€šãŒå…±åŒæ¤œè¨¼ã‚’è¡Œã„ã€ãã®çµæžœã‚’ãƒ›ãƒ¯ã‚¤ãƒˆãƒšãƒ¼ãƒ‘ãƒ¼ã¨ã—ã¦å…ˆé€±ç™ºè¡¨ã—ã¾ã—ãŸï¼ˆå‚è€ƒã€Œæ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ã¨å¯Œå£«é€š ãƒ•ãƒ©ãƒƒã‚·ãƒ¥æŠ€è¡“æ´»ç”¨ã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é«˜é€ŸåŒ–ã‚’å…±åŒæ¤œè¨¼ã€ï¼‰ã€‚ ãƒ›ãƒ¯ã‚¤ãƒˆãƒšãƒ¼ãƒ‘ãƒ¼ã§ã¯ã€HDDã®ä»£ã‚ã‚Š
willnet 2010/04/26
HDDã¨SSDãã®ã‚‚ã®ã®ã‚¢ã‚¯ã‚»ã‚¹æ€§èƒ½ã‚’æ¯”è¼ƒã—ãŸå ´åˆã¯10å€ã‹ã‚‰20å€æ€§èƒ½ãŒé•ã†ã®ã«å¯¾ã—ã€å®Ÿéš›ã®æ¥å‹™ã‚’æƒ³å®šã—ãŸOLTPå‡¦ç†æ€§èƒ½ã®æ¯”è¼ƒã§ã¯ãã‚ŒãŒ2 å€ï½ž3å€ç¨‹åº¦ã«åŽã¾ã‚Šãã†ã§ã‚ã‚‹ã®ã«ã¯ã‚„ã‚„è‚©ã™ã‹ã—ã‚’é£Ÿã‚‰ã£ãŸæ„Ÿã˜ã‚‚ã—ã¾ã™

db
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
willnet 2010/03/23
3å€¤è«–ç†ã«ãŠã„ã¦ã¯ã€ã€Œã‚ã‚‹åˆ—ã¯2ã‹ã€2ã§ãªã„ã‹ã®ã©ã¡ã‚‰ã‹ã ã€ã¨ã„ã†2å€¤è«–ç†ã®å¤§åŽŸå‰‡ï¼ˆæŽ’ä¸å¾‹ï¼‰ãŒé€šç”¨ã—ãªã„

DB
ãƒªãƒ³ã‚¯
Ryan Park
Infrastructure Engineering at Render in San Francisco. (he/him) Formerly at Slack, Stripe, Runscope, Pinterest, and more. Graduate of Stanford University and George Washington University. Originally from Bettendorf, Iowa. Fan of travel, hiking, techno logy, and rock music.
willnet 2009/03/27
simpledbç³»ã¨æ™®é€šã®RDBMSã¨ã®é•ã„

db
ãƒªãƒ³ã‚¯
Apache CouchDB
Data Where You Need It Apache CouchDB â„¢ lets you access your data where you need it. The Couch Replication Protocol is implemented in a variety of projects and products that span every imaginable computing environment from globally distributed server-clusters, over mobile phones to web browsers. Store your data safely, on your own servers, or with any leading cloud provider. Your web- and native a
willnet 2009/03/27
HTTPã§æ“ä½œã§ãã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

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