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

justoneplanet id:justoneplanet

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

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

[ãƒ¬ãƒãƒ¼ãƒˆ] é«˜é€Ÿã§PDCAã‚µã‚¤ã‚¯ãƒ«ã‚’å›žã—ã€ã‚¼ãƒãƒ€ã‚¦ãƒ³ã‚¿ã‚¤ãƒ ã§AWSã«ç§»è¡Œã—ãŸPokÃ©mon GOãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆ #reinvent [GAM304] | DevelopersIO
2016å¹´å¤ PokÃ©mon GoãŒãƒãƒ¼ãƒ³ãƒ ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’ã‚¹ã‚±ãƒ¼ãƒ«ã—ã€é©åˆ‡ãªã‚µã‚¤ã‚ºã« 2017å¹´å¤ ä»£æ›¿ã§ããã†ãªãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã‚’èª¿æŸ»ã—å§‹ã‚ã‚‹ DynamoDBã‹ã€Aurora MySQLã‹ã€Aurora PostgreSQL ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒãƒ¼ãƒ ã‚’ç™»ç”¨ 2018å¹´æ˜¥ DynamoDBã¯ã¾ã ä¿å˜æ™‚ã®æš—å·åŒ–ã‚’ã‚µãƒãƒ¼ãƒˆã‚µãƒãƒ¼ãƒˆã—ã¦ã„ãªã‹ã£ãŸ Aurora PostgreSQLãŒãƒã‚¤ãƒ†ã‚£ãƒ–ã§JSONã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ãŸãŸã‚ã€ãƒ™ã‚¹ãƒˆãªé¸æŠžè‚¢ã« 2018å¹´å¤ PostgreSQLã‚’èªè¨¼ç”¨ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ä½¿ç”¨ è¤‡é›‘ãªå‡¦ç†ã‚’ã—ãŸããªã‹ã£ãŸã®ã§ã€ãƒ‡ãƒ¼ã‚¿ã‚’JSONã¸å¼•ãå…¥ã‚Œ PostgreSQLã‚’MySQLã¸ã®ãƒ©ãƒ³ãƒ‡ã‚£ãƒ³ã‚°ãƒ»ãƒ‘ãƒƒãƒ‰ã¨ã—ã¦ã€ãŸã ä½¿ã‚ãªã„ ãƒ‡ãƒ¼ã‚¿ãƒ»ãƒ‰ãƒªãƒ–ãƒ³ãªã‚¢ãƒ—ãƒãƒ¼ãƒ å—ã‘å…¥ã‚ŒåŸºæº–ï¼ˆAcceptance criteriaï¼‰ èªè¨¼ï¼š 2k/ç§’ ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚µã‚¤ãƒ³ã‚¢ãƒƒãƒ—ï¼š 60+/ç§’ èªã¿è¾¼ã¿é‡è¦–ã®ã‚¢ãƒ—
justoneplanet 2020/01/05
aws

database

Pokemon
ãƒªãƒ³ã‚¯
Amazon Auroraã®å…ˆé€²æ€§ã‚’èª°ã‚‚è§£èª¬ã—ã¦ãã‚Œãªã„ã‹ã‚‰è§£èª¬ã™ã‚‹ - Qiita
TL;DR; Amazon Auroraã¯In-Memory DBã§ã‚‚ãªãDisk-Oriented DBã§ã‚‚ãªãã€In-KVS DBã¨ã§ã‚‚å‘¼ã¶ã¹ãæ–°åœ°å¹³ã«ç«‹ã£ã¦ã„ã‚‹ã€‚ ãã®æ–¬æ–°ã•ãŸã‚‹ã‚„ãƒžã‚¹ã‚¿ãƒ¼ã®ãƒ¡ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªã¯ã‚ãƒ£ãƒƒã‚·ãƒ¥ã§ã‚ã‚ŠãªãŒã‚‰Write-Backã§ã‚‚ãªãWrite-Throughã§ã‚‚ãªã„ã¨ã„ã†é©šå¤©å‹•åœ°ã€‚ ã¤ã„ã§ã«å¾“æ¥ã®ãƒã‚§ãƒƒã‚¯ãƒã‚¤ãƒ³ãƒˆå‡¦ç†ã‚‚ä¸è¦ã«ãªã£ãŸã®ã§ã‚¹ãƒ«ãƒ¼ãƒ—ãƒƒãƒˆã‚‚å‘ä¸Šã—ãŸã€‚ è©³ç´°ãŒæ°—ã«ãªã‚‹äººã¯ã“ã®è¨˜äº‹ã‚’ãƒã‚§ã‚ï¼ Amazon Aurora Amazon Auroraã¯AWSã®ä¸ã§åˆ©ç”¨å¯èƒ½ãªãƒžãƒãƒ¼ã‚¸ãƒ‰(ï¼é‹ç”¨ã‚’AWSãŒé¢å€’è¦‹ã¦ãã‚Œã‚‹)ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒ“ã‚¹ã€‚ ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‹ã‚‰ã¯ãŸã ã®MySQLã€ã‚‚ã—ãã¯PostgreSQLã¨ã—ã¦æ‰±ã†äº‹ãŒã§ãã‚‹ã®ã§ãã‚Œã‚‰ã«ä¾å˜ã™ã‚‹æ—¢å˜ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³è³‡ç”£ã‚’ãã®ã¾ã¾åˆ©ç”¨ã™ã‚‹äº‹ãŒã§ãã¦ã€è½ã¡ãŸã‚‰å†èµ·å‹•ã—ãŸã‚Šã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãƒ‘ãƒƒãƒã‚’ãƒ€ã‚¦ãƒ³ã‚¿ã‚¤ãƒ ãªã—ã§(!?)é©
justoneplanet 2017/12/16
aurora

DB

aws

Amazon

database

Amazon Aurora
ãƒªãƒ³ã‚¯
RDBã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ // Speaker Deck
PHPã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2016ã®è³‡æ–™ã§ã™ http://phpcon.php.gr.jp/2016/
justoneplanet 2016/11/03
RDB

MySQL

ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³

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

database
ãƒªãƒ³ã‚¯
Clojureã®ä½œè€…ãŒä½œã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹DatomicãŒå‡„ã„
ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžClojureã®ä½œè€…Rich Hickeyæ°çŽ‡ã„ã‚‹Clojure Hackerã®ãƒãƒ¼ãƒ ãŒDatomic(ãƒ‡ãƒ¼ãƒˆãƒŸãƒƒã‚¯ã¨ç™ºéŸ³ã™ã‚‹ã‚‰ã—ã„)ã¨ã„ã†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ãƒªãƒªãƒ¼ã‚¹ã—ã¾ã—ãŸã€‚ã“ã‚ŒãŒä½•ã‚„ã‚‰ã¨ã¦ã¤ã‚‚ãªã„ã§ã™ã€‚10å¹´å…ˆã‚’è¡Œã£ã¦ã‚‹æŠ€è¡“ã˜ã‚ƒãªã„ã§ã—ã‚‡ã†ã‹ã€‚ ã¾ã æœ¬ç•ªã‚µãƒ¼ãƒ“ã‚¹ã¯å§‹ã¾ã£ã¦ã„ã¾ã›ã‚“ãŒé–‹ç™ºç’°å¢ƒç”¨ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªãŒé…å¸ƒã•ã‚Œã¦ã„ã¾ã™ã€‚ Datomicã¯æ–¬æ–°ãªã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ãªã®ã§ä¸€è¨€ã§èª¬æ˜Žã™ã‚‹ã®ã¯ã¨ã¦ã‚‚é›£ã—ã„ã§ã™ã€‚ ç§ãŒç†è§£ã§ããŸã“ã¨ã‚’ç°¡å˜ã«èª¬æ˜Žã—ã¾ã™ã€‚ 2014/1/20è¿½è¨˜ ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ãƒ¢ãƒ‡ãƒ«ã€ã‚µãƒãƒ¼ãƒˆã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã€ã‚µãƒ¼ãƒ“ã‚¹ã¨ã—ã¦ã§ã¯ãªãç‹¬ç«‹ã—ã¦ä½¿ç”¨ã™ã‚‹å½¢ã«ãªã‚‹ãªã©è¨˜äº‹ä½œæˆæ™‚ã®å†…å®¹ã‹ã‚‰è‰²ã€…å¤‰æ›´ãŒåˆã£ãŸéƒ¨åˆ†ã‚’æ›´æ–°ã—ã¾ã—ãŸã€‚ å¤‰æ›´ä¸å¯ãªAppend-onlyãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ å¾“æ¥ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã€ã‚ã‚‹ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’å¤‰æ›´ã™ã‚‹ã¨ã„ã†ã®ã¯ãã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã«å¯¾å¿œã—ãŸå ´æ‰€ãŒã‚ã‚Šã€ãã“ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ›¸ãæ›ãˆã‚‹ã¨ã„ã†ã“
justoneplanet 2015/02/03
DBMS

Clojure

Datomic

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

database

DB
ãƒªãƒ³ã‚¯
Save data in a local database using Room Â |Â App data and files Â |Â Android Developers
Build AI experiences Build AI-powered Android apps with Gemini APIs and more. Get started Start by creating your first app. Go deeper with our training courses or explore app development on your own.
justoneplanet 2014/10/15
android

BaseColumns

Database

tutorial
ãƒªãƒ³ã‚¯
ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰Androidã‚¢ãƒ—ãƒªã«ãŠã‘ã‚‹æœ€è¿‘ã®DBé‹ç”¨äº‹æƒ… - ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰é–‹ç™ºè€…ãƒ–ãƒã‚°
ãƒ¢ãƒã‚¤ãƒ«ãƒ•ã‚¡ãƒ¼ã‚¹ãƒˆå®¤ã® @rejasupotaro ã§ã™ã€‚ Androidãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã«ã¯ç«¯æœ«å†…ã«SQLiteã§ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã™ã‚‹ã—ãã¿ãŒã‚ã‚Šã¾ã™ãŒã€ã¿ãªã•ã‚“ã¯ã©ã®ã‚ˆã†ã«ã—ã¦ã¾ã™ã‹ï¼Ÿ ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã®Androidã‚¢ãƒ—ãƒªã§ã¯ã€ActiveAndroidã‚’ä½¿ã£ã¦DBã«ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã¾ã™ã€‚ ActiveAndroidã¨ã¯ ActiveAndroid ã¨ã¯ã€Active Recordãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’æŽ¡ç”¨ã—ãŸAndroidã®ORMã§ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã®CREATEã‚’è¡Œã†ã¨ãã«ã€SQLiteOpenHeleperã‚’ç¶™æ‰¿ã—ãŸã‚¯ãƒ©ã‚¹ã§onCreateã‚’Overrideã—ã¦db.execQueryã§CREATEã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œâ€¦ã¨ã—ãªãã¦ã‚‚ã€ActiveAndroidã‚’ä½¿ãˆã°ã€ public class MyApplication extends Application { @Override public void
justoneplanet 2014/09/19
database

DB

android

cookpad

orm
ãƒªãƒ³ã‚¯
èª°ã‚‚æ•™ãˆã¦ãã‚Œãªã‹ã£ãŸMySQLã®éšœå®³è§£æžæ–¹æ³• - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
justoneplanet 2014/07/12
mysql

éšœå®³

ã‚µãƒ¼ãƒç®¡ç†

ã‚·ã‚¹ãƒ†ãƒ é‹ç”¨

database

DB
ãƒªãƒ³ã‚¯
DBã‚¹ã‚ãƒ¼ãƒžã‚‚ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç†ã—ãŸã„ï¼
PostgreSQLã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2013 LightningTalk ï¼ˆ2013-11-13: migr8.rbã®è¨å®šç®‡æ‰€ã‚’è‹¥å¹²ä¿®æ£ï¼‰ ï¼ˆ2013-11-14: SQLite3ã§ã®è¨å®šç‰ã‚’ä¿®æ£ã€ã€Œmigr8.rb new --table=usersã€ã‚’è¿½åŠ ï¼‰
justoneplanet 2013/11/18
ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç†

migration

database

mysql
ãƒªãƒ³ã‚¯
MySQLã®å†—é•·åŒ– 2013-01-24
ï¼œSKILL BASECAMP 2013ï¼ž MySQLã®å†—é•·åŒ–ï½žç„¡åœæ¢é‹ç”¨ã‚’å®Ÿç¾ã™ã‚‹ã«ã¯ï½ž http://www.pasonatech.co.jp/entry/index.jsp?mode=2&d=on&no=3756
justoneplanet 2013/01/29
MySQL

å†—é•·åŒ–

mysql

database
ãƒªãƒ³ã‚¯
ã‚°ãƒ¼ã‚°ãƒ«ã®BigQueryã€é«˜é€Ÿå‡¦ç†ã®ä»•çµ„ã¿ã¯ã€Œã‚«ãƒ©ãƒ åž‹ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã€ã¨ã€Œãƒ„ãƒªãƒ¼æ§‹é€ ã€ã€‚è§£èª¬æ–‡æ›¸ãŒå…¬é–‹ ï¼ Publickey
ã‚°ãƒ¼ã‚°ãƒ«ã®BigQueryã€é«˜é€Ÿå‡¦ç†ã®ä»•çµ„ã¿ã¯ã€Œã‚«ãƒ©ãƒ åž‹ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã€ã¨ã€Œãƒ„ãƒªãƒ¼æ§‹é€ ã€ã€‚è§£èª¬æ–‡æ›¸ãŒå…¬é–‹ SQLã®ã‚¯ã‚¨ãƒªã«å¯¾å¿œã—ã€3å„„ä»¶ã‚’è¶…ãˆã‚‹ãƒ‡ãƒ¼ã‚¿ã«å¯¾ã—ã¦ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã‚ãªã„ãƒ•ãƒ«ã‚¹ã‚ãƒ£ãƒ³æ¤œç´¢ã§10ç§’ä»¥å†…ã«çµæžœã‚’å‡ºã™ã€‚ã‚°ãƒ¼ã‚°ãƒ«ã®BigQueryã¯å¤§è¦æ¨¡ãªã‚¯ã‚¨ãƒªã‚’è¶…é«˜é€Ÿã§å®Ÿè¡Œã™ã‚‹èƒ½åŠ›ã‚’æä¾›ã™ã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã§ã™ã€‚ãã®å†…éƒ¨ã‚’è§£èª¬ã™ã‚‹æ–‡æ›¸ã€ŒAn Inside Look at Google BigQueryã€ï¼ˆPDFï¼‰ã‚’å…¬é–‹ã—ã¾ã—ãŸã€‚ ã‚°ãƒ¼ã‚°ãƒ«ã¯å¤§è¦æ¨¡ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã™ã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã¨ã—ã¦ç¤¾å†…ã§ã‚³ãƒ¼ãƒ‰ãƒãƒ¼ãƒ ã€ŒDremelã€ã‚’æ§‹ç¯‰ã—ã¦ãŠã‚Šã€2010å¹´ã«ãã®Dremelã‚’è§£èª¬ã™ã‚‹æ–‡æ›¸ã€ŒDremel: Interactive Analysis of Web-Scale Datasetsã€ã‚’å…¬é–‹ã—ã¦ã„ã¾ã™ã€‚BigQueryã¯ã€ãã®Dremelã‚’å¤–éƒ¨å…¬é–‹å‘ã‘ã«å®Ÿè£…ã—ãŸã‚‚ã®ã§ã™ã€‚ ã‚°ãƒ¼ã‚°ãƒ«ã¯ã“ã®Dremel/BigQue
justoneplanet 2012/11/19
database

Google

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

bigquery
ãƒªãƒ³ã‚¯
Cassandra vs MongoDB vs CouchDB vs Redis vs Riak vs HBase comparison :: Software architect Kristof Kovacs
Hello, Iâ€™m Kristof, a human being like you, and an easy to work with, friendly guy. I've been a programmer, a consultant, CIO in startups, head of software development in government, and built two software companies. Some days Iâ€™m coding Golang in the guts of a system and other days I'm wearing a suit to help clients with their DevOps practices. While SQL databases are insanely useful tools, their
justoneplanet 2012/09/10
database

cassandra

nosql

MongoDB

couchdb

redis

CouchDB

æ¯”è¼ƒ
ãƒªãƒ³ã‚¯
http://smartappscreative.com/iphone/iphone%E3%82%A2%E3%83%97%E3%83%AA%E9%96%8B%E7%99%BA%E3%81%A7%E4%BD%BF%E3%81%88%E3%82%8Bobjective-c%E3%83%A9%E3%82%A4%E3%83%96%E3%83%A9%E3%83%AA%E3%81%AE%E7%B4%B9%E4%BB%8B/
justoneplanet 2012/08/02
iOS

library

database
ãƒªãƒ³ã‚¯
ã‚°ãƒ¼ã‚°ãƒ«ã€BigQueryã‚’æ£å¼å…¬é–‹ã€‚SQLã§å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã«å¯¾ã—ã¦é«˜é€Ÿå‡¦ç†
BigQueryã¯ã‚«ãƒ©ãƒ åž‹ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã®ä¸€ç¨®ã§ã€ãƒ†ãƒ©ãƒã‚¤ãƒˆã‚¯ãƒ©ã‚¹ã®å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã«å¯¾ã—ã¦å¤§é‡ã®ä¸¦åˆ—å‡¦ç†ã‚’è¡Œã†ã“ã¨ã§é«˜é€Ÿã«çµæžœã‚’å¾—ã‚‹ã“ã¨ãŒå¯èƒ½ã€‚ã‚°ãƒ¼ã‚°ãƒ« ä½è—¤ä¸€æ†²æ°ã®ç™ºè¨€ã«ã‚ˆã‚‹ã¨ã€ OLAP/DWH/Data Miningã§è¡Œã‚ã‚Œã‚‹ã‚ˆã†ãªread onlyã®ad hocã‚¯ã‚¨ãƒªã‚’ãã‚ã‚ã¦é«˜é€Ÿï¼ˆæ•°ç§’ã€œæ•°åç§’ï¼‰ã«å®Ÿè¡Œã—ã¾ã™ã€‚ ã¨ã®ã“ã¨ã€‚ SQLã«ã‚ˆã‚‹å•ã„åˆã‚ã›ãŒå¯èƒ½ ã“ã®é«˜é€Ÿæ€§ã«åŠ ãˆã€BigQueryã§ã¯SQLã‚’å•ã„åˆã‚ã›è¨€èªžã«ä½¿ãˆã‚‹ã¨ã„ã†ç‚¹ã«ã‚‚å¤§ããªç‰¹å¾´ãŒã‚ã‚Šã¾ã™ã€‚æ•°ç§’ç¨‹åº¦ã®ãƒ¬ã‚¹ãƒãƒ³ã‚¹ã¨SQLæ–‡ã«ã‚ˆã‚‹è¨˜è¿°ã¯ã€å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã«å¯¾ã™ã‚‹ã‚¢ãƒ‰ãƒ›ãƒƒã‚¯ãªå‡¦ç†ã‚’è¡Œã†ã®ã«é©ã—ãŸã‚µãƒ¼ãƒ“ã‚¹ã ã¨ã„ãˆã‚‹ã§ã—ã‚‡ã†ã€‚ BigQueryã®SQLã®æ§‹æ–‡ã¯ã€ŒQuery Referenceã€ã§è§£èª¬ã•ã‚Œã¦ã„ã¾ã™ãŒã€SELECTæ–‡ã«FROMã€WHEREã€JOINã€HAVINGã€GROUP BYã€ORDER BYã€LIMITãªã©ãŒä½¿ãˆã‚‹ãŸã‚
justoneplanet 2012/06/25
bigquery

DB

database

bigdata

BigQuery

SQL

google
ãƒªãƒ³ã‚¯
Microsoft PowerPoint - oracle_mysql_design_publish.ppt
1 Oracle Database MySQL ( ) Oracle OpenWorld Unconference presented by JPOUG 2012/04/06 2 â€¢ DB Oracle MySQL â€“ RDBMS â€“ Oracle MySQL 8 2 â€¢ Twitter @sh2nd â€¢ id:sh2 â€¢ 3 â€¢ Oracle Database MySQL â€¢ Oracle Database MySQL â€¦ â€¢ MySQL Oracle Database â€¦ 4 MySQL 5 MySQL â€¢ 2001/01 MySQL 3.23 RHEL 2.1/3 â€¢ 2003/03 MySQL 4.0 UNION â€¢ 2004/10 MySQL 4.1 4.1.12 Windows Shift_JIS (Microsoft Code Page 932) RHEL 4 â€¢ 2005/
justoneplanet 2012/04/20
MySQL

oracle

database

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

è³‡æ–™

mysql
ãƒªãƒ³ã‚¯
Introduction to Databases
Feedback View Video Lectures Previous video Next video 1.5x1.2x 1.0x
justoneplanet 2012/03/17
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

database

english

db

å¦ç¿’

stanford

è‹±èªž
ãƒªãƒ³ã‚¯
MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°è™Žã®å·»ï¼ã‚½ãƒ¼ãƒˆã«é–¢é€£ã™ã‚‹ãƒˆãƒ”ãƒƒã‚¯ã¨ã‚¯ã‚¨ãƒªã®æ›¸ãæ›ãˆ
EnterpriseZineï¼ˆã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºã‚¸ãƒ³ï¼‰ç·¨é›†éƒ¨ã§ã¯ã€æƒ…å ±ã‚·ã‚¹ãƒ†ãƒ æ‹…å½“ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£æ‹…å½“ã®æ–¹ã€…å‘ã‘ã«ã€EnterpriseZine Dayã€Security Online Dayã€DataTechã¨ã„ã†ã€3ã¤ã®ã‚¤ãƒ™ãƒ³ãƒˆã‚’é–‹å‚¬ã—ã¦ãŠã‚Šã¾ã™ã€‚ãã‚Œãžã‚Œç·¨é›†éƒ¨ç‹¬è‡ªã®åˆ‡ã‚Šå£ã§ã€æ¥ç•Œãƒˆãƒ¬ãƒ³ãƒ‰ã‚„æœ€æ–°äº‹ä¾‹ã‚’ç¶²ç¾…ã€‚æœ€æ–°ã®å‹•å‘ã‚’çŸ¥ã‚‹ã“ã¨ãŒã§ãã‚‹å ´ã¨ã—ã¦ã€å¥½è©•ã‚’å¾—ã¦ã„ã¾ã™ã€‚
justoneplanet 2012/01/18
ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

MySQL

database
ãƒªãƒ³ã‚¯
ã‚ªãƒ©ã‚¯ãƒ«ãŒNoSQLã«æœ¬æ°—ã€‚ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºå‘ã‘ã€ŒOracle NoSQL Database 11gã€å…¬é–‹ã€‚ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ç‰ˆã‚‚ç™»å ´
ç±³ã‚ªãƒ©ã‚¯ãƒ«ã¯ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºå‘ã‘NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒOracle NoSQL Database 11gã€ã®å…¬é–‹ã‚’ç™ºè¡¨ã€‚è©•ä¾¡ç‰ˆã®ç„¡å„Ÿãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã‚’é–‹å§‹ã—ã¾ã—ãŸã€‚ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã«åŸºã¥ãã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ç‰ˆã‚‚æº–å‚™ä¸ï¼ˆ10æœˆ26æ—¥ç¾åœ¨ã€ãƒ©ã‚¤ã‚»ãƒ³ã‚¹æ‰¿èªå¾…ã¡ï¼‰ã¨ã®ã“ã¨ã§ã™ã€‚ Oracle NoSQL Databaseã¯ã€åŒç¤¾ã®ã‚ãƒ¼ãƒãƒªãƒ¥ãƒ¼ã‚¹ãƒˆã‚¢ã§ã‚ã‚‹Oracle Berkeley DB Java Editionã‚’ãƒ™ãƒ¼ã‚¹ã«ã€åˆ†æ•£å‡¦ç†æ©Ÿèƒ½ã€ãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚¹ã€ç®¡ç†æ©Ÿèƒ½ã€ãƒžãƒ«ãƒãƒŽãƒ¼ãƒ‰ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ©Ÿèƒ½ãªã©ã‚’è¿½åŠ ã—ãŸã‚‚ã®ã€‚å¤§è¦æ¨¡ãªãƒ‡ãƒ¼ã‚¿ã‚’é«˜é€Ÿã«æ‰±ã†ã“ã¨ãŒã§ãã€é«˜ã„å¯ç”¨æ€§ã¨ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã‚’å®Ÿç¾ã™ã‚‹ã¨èª¬æ˜Žã•ã‚Œã¦ã„ã¾ã™ã€‚ åˆ†æ•£ã‚ãƒ¼ãƒãƒªãƒ¥ãƒ¼ã‚¹ãƒˆã‚¢ã§å˜ä¸€éšœå®³ç‚¹ã‚’æŽ’é™¤ NoSQL Databaseã®åŸºæœ¬çš„ãªã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã¯ã€ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ã®ãƒãƒƒã‚·ãƒ¥ã«ã‚ˆã£ã¦æŒ‡å®šã•ã‚ŒãŸãƒŽãƒ¼ãƒ‰ã«ã‚ãƒ¼ï¼ãƒãƒªãƒ¥ãƒ¼ã®ãƒšã‚¢ã‚’æ›¸ãè¾¼ã‚€åˆ†æ•£ã‚ãƒ¼ãƒãƒªãƒ¥
justoneplanet 2011/10/26
database

oracle

nosql
ãƒªãƒ³ã‚¯
Indexed Database API ã«ã¤ã„ã¦
Indexed Database APIï¼ˆä»¥ä¸‹ã€indexedDBï¼‰ã«ã¤ã„ã¦ã€ã“ã‚Œã¾ã§è¿½ã„ã‹ã‘ã¦ããŸæƒ…å ±ã‚’ã¨ã‚Šã¾ã¨ã‚ãŸã®ã§å…¬é–‹ã—ã¾ã™ã€‚ indexedDBã¯å½“åˆã¯ä»•æ§˜ãŒå›ºã¾ã£ã¦ãŠã‚‰ãšã€ã‚µãƒ³ãƒ—ãƒ«ã‚³ãƒ¼ãƒ‰ã‚‚å½“ç„¶ã®ã‚ˆã†ã«å‹•ã‹ãªã‹ã£ãŸã®ã§ï¼ˆä»Šã‚‚å‹•ãã¾ã›ã‚“ãŒâ€¦ï¼‰ã€æ¤œè¨¼ã™ã‚‹ã«ã¯ã‹ãªã‚Šãƒãƒ¼ãƒ‰ãªçŠ¶æ³ã§ã—ãŸã€‚æœ€è¿‘ã«ãªã£ã¦ã©ã†ã«ã‹å‹•ãã‚ˆã†ã«ãªã£ã¦ããŸã®ã§ã€@komasshu ã•ã‚“ã¨è‰²ã€…ã‚„ã‚Šå–ã‚Šã—ãªãŒã‚‰ä¸€é€šã‚Šã®å‹•ä½œã‚’ç¢ºèªã—ã¾ã—ãŸã€‚ ç¾æ™‚ç‚¹ã§åˆ©ç”¨ã§ãã‚‹ãƒ–ãƒ©ã‚¦ã‚¶ã¯ Chrome 9 ä»¥é™ ã¾ãŸã¯ Firefox 4 beta 8 ä»¥é™ã¨ãªã‚Šã¾ã™ã€‚ã¾ã ã¾ã ä»•æ§˜ã¯å‹•ã„ã¦ã„ã¾ã™ã®ã§ã€æ¤œè¨¼ã®éš›ã¯ã€ãªã‚‹ã¹ãæœ€æ–°ã®é–‹ç™ºç‰ˆã‚’ä½¿ã†ã“ã¨ã‚’ãŠã™ã™ã‚ã—ã¾ã™ã€‚æœ¬ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã§ã¯ã€Chrome 9 beta ã€Firefox 4 beta 8 ã«ã¦æ¤œè¨¼ã—ã¾ã™ã€‚ã¾ãŸã€è³‡æ–™ã¯ã€2011å¹´1æœˆ20æ—¥æ™‚ç‚¹ã® W3C Editor's Draft ã‚’å‚ç…§
justoneplanet 2011/07/25
chrome

database

IndexedDB

JavaScript
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«ãŠã‘ã‚‹7ã¤ã®å¤§ç½ª
ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹åˆ†æžã¯ä¸€ç‹ç¸„ã§ã¯ã„ã‹ãªã„ã“ã¨ãŒå¤šã„ã®ã§ã™ãŒã€ãã‚Œã¯å¯å¤‰è¦ç´ ãŒéžå¸¸ã«å¤šãã€ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã®ç‰¹æ€§ã€ãƒ¯ãƒ¼ã‚¯ãƒãƒ¼ãƒ‰ã€ç‰©ç†çš„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã€ãŠã‚ˆã³ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³è¨è¨ˆãªã©ã€ã‚ã‚‰ã‚†ã‚‹è¦ç´ ã‚’æ¤œè¨Žã™ã‚‹å¿…è¦ãŒã‚ã‚Šã€ã¾ãŸã“ã‚Œã‚‰ã®è¦ç´ ã®é–“ã«ãƒˆãƒ¬ãƒ¼ãƒ‰ã‚ªãƒ•ã‚„å‰¯ä½œç”¨ãŒå˜åœ¨ã™ã‚‹ã‹ã‚‰ã§ã™ã€‚ã“ã‚ŒãŒæ£è§£ã€ã¨è¨€ãˆã‚‹ã‚‚ã®ãŒè¦‹ã¤ã‹ã‚‰ãªã„ã®ãŒæ™®é€šã§ã™ã€‚ å°‘ã—å‰ã€SQL Anywhereã®ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒˆã§ã‚ã‚‹Breck CarterãŒã€ã€ŒHow to Make SQL Anywhere Slowï¼ˆSQL Anywhereã‚’é…ãã™ã‚‹æ–¹æ³•ï¼‰ã€ã¨ã„ã†è¨˜äº‹ã‚’æ›¸ãã¾ã—ãŸã€‚ã“ã‚Œã¯ä»Šã¾ã§ã«èªã‚“ã è¨˜äº‹ã®ãªã‹ã§ã‚‚æœ€å¤§ã®ãŠæ°—ã«å…¥ã‚Šã®1ã¤ã§ã™ã€‚Breckã¯ã“ã®è¨˜äº‹ã®ä¸ã§ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®ä½Žä¸‹ã«ã¤ãªãŒã‚‹38ã®ç•°ãªã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³è¨è¨ˆã€ãŠã‚ˆã³ã‚µãƒ¼ãƒæ§‹æˆè¨å®šã‚’åˆ—æŒ™ã—ã¦ã„ã¾ã™ã€‚ã“ã®è¨˜äº‹ã‚’å—ã‘ã¦ã€ä»Šå¾Œã—ã°ã‚‰ãã¯ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ãƒ—ãƒªã‚±
justoneplanet 2011/07/12
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

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

database
ãƒªãƒ³ã‚¯
RDBã¨NoSQLã®ãƒ‡ãƒ¼ã‚¿æ›¸ãè¾¼ã¿æ³•ã®é•ã„
æœ€çµ‚å›žã¨ãªã‚‹ä»Šå›žã¯ã€NoSQLã¨RDBã®ãƒ‡ãƒ¼ã‚¿æ›¸ãè¾¼ã¿æ–¹æ³•ã‚’æ¯”è¼ƒã—ã¦ã€ãã‚Œãžã‚Œã®å¾—æ„ä¸å¾—æ„ã‚’è€ƒãˆã¦ã¿ã¾ã™ï¼ˆç·¨é›†éƒ¨ï¼‰ ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã‚„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’äº‹å‰ã«ç”¨æ„ å‰å›žã¯ã€ã€ŒNoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§RDBMSã®æ©Ÿèƒ½ã‚’å®Ÿç¾ã™ã‚‹ã€ã®å¾ŒåŠæˆ¦ã¨ã—ã¦ã€RDBãªã‚‰é›†è¨ˆå‡¦ç†ã‚„ãƒ†ãƒ¼ãƒ–ãƒ«çµåˆã‚’ä½¿ã£ã¦ç°¡å˜ã«ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã§ãã‚‹å ´åˆã‚’æƒ³å®šã—ã€ãã‚Œã‚’NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§å®Ÿç¾ã™ã‚‹ãŸã‚ã®è€ƒãˆæ–¹ã‚„æ–¹æ³•ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã—ãŸã€‚ NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¯RDBã®ã‚ˆã†ã«èªã¿å–ã‚Šæ™‚ã«ãƒ‡ãƒ¼ã‚¿ã‚’åŠ å·¥ã™ã‚‹æ©Ÿèƒ½ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚é›†è¨ˆã‚„çµåˆã¨ã„ã£ãŸãƒ‡ãƒ¼ã‚¿ã®åŠ å·¥ã¯äº‹å‰ã«æ¸ˆã¾ã›ã€ãƒ‡ãƒ¼ã‚¿ã‚ãƒ£ãƒƒã‚·ãƒ¥ã¨ã—ã¦ä¿å˜ã—ã¦ãŠã„ãŸã‚‚ã®ã‚’èªã¿å‡ºã—ã¾ã™ã€‚ã¾ãŸã€ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚’æ ¼ç´ã™ã‚‹ãŸã‚ã®ç‰©ç†çš„ãªãƒ‡ãƒ¼ã‚¿ã®æ§‹é€ ã‚„é…ç½®ã«ã‚‚æ°—ã‚’é…ã‚‰ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ãƒ‡ãƒ¼ã‚¿ã®æŒã¡æ–¹ã§èªã¿å‡ºã—æ€§èƒ½ãŒå¤§ããå¤‰ã‚ã‚‹ã‹ã‚‰ã§ã™ã€‚ ç¬¬3å›žã§ç´¹ä»‹ã—ãŸãƒ‡ãƒ¼ã‚¿æ¤œç´¢ã‚„ä¸¦ã¹æ›¿ãˆã®å®Ÿç¾æ–¹æ³•ã‚‚ã€ã€Œè»¢
justoneplanet 2011/06/26
NoSQL

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

nosql

database

rdb
ãƒªãƒ³ã‚¯
1 2 3 4 æ¬¡ã®ãƒšãƒ¼ã‚¸