[B! mongo] kuchitamaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kuchitama id:kuchitama

mongoã«é–¢ã™ã‚‹kuchitamaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

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

MongoDBã«ãŠã‘ã‚‹é–¢é€£ï¼ˆRelationï¼‰ã®ã‚¹ã‚ãƒ¼ãƒžè¨è¨ˆ - masa_wã®æ—¥è¨˜
å‰å›žã€Mongo DBã§SNSã¤ãã‚‹ãžã¨ã„ã†è¨˜äº‹ã‚’æ›¸ã„ã¦ã‹ã‚‰éšåˆ†æ™‚é–“ãŒãŸã£ã¦ã—ã¾ã„ã¾ã—ãŸã€‚å˜ã«ç§ãŒã ã‚‰ã‘ã¦ã„ãŸã¨ã„ã†ã“ã¨ã‚‚ã‚ã‚‹ã®ã§ã™ãŒã€ä¸€ç•ªã²ã£ã‹ã‹ã£ã¦æ™‚é–“ã‚’å–ã‚‰ã‚Œã¦ã„ãŸã®ãŒã€Mongo DBã«ãŠã‘ã‚‹ã‚¹ã‚ãƒ¼ãƒžè¨è¨ˆã®è€ƒãˆæ–¹ã§ã™ã€‚ ã„ã¾ã ã«è©¦è¡ŒéŒ¯èª¤ä¸ã§ã¯ã‚ã‚Šã¾ã™ãŒã€ç¾æ™‚ç‚¹ã«ãŠã„ã¦ç§ãŒã“ã†ã‚ã‚‹ã¹ãã¨ç†è§£ã—ã¦ã„ã‚‹ã¨ã“ã‚ã‚’ã‚¢ã‚¦ãƒˆãƒ—ãƒƒãƒˆã—ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ï¼‘ï¼ŽOne to Many ã®ã‚±ãƒ¼ã‚¹ ãŸã¨ãˆã°æ³¨æ–‡ã¨æ³¨æ–‡æ˜Žç´°ã®ã‚±ãƒ¼ã‚¹ã‚’è€ƒãˆã¦ã¿ã¾ã™ã€‚RDBã§1å¯¾å¤šã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚’è¨è¨ˆã™ã‚‹å ´åˆã€ ã¨ã„ã†ã‚ˆã†ã«ã€æ³¨æ–‡æ˜Žç´°ã‚’åˆ¥ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã™ã‚‹ã®ãŒæ™®é€šã‹ã¨æ€ã„ã¾ã™ã€‚ã—ã‹ã—ã€ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆæŒ‡å‘ã®Mongo DBã«ãŠã„ã¦ã¯ã€RDBã¨é•ã£ã¦ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆå†…ã«æŸ”è»Ÿãªãƒ‡ãƒ¼ã‚¿æ§‹é€ ã‚’å®Ÿç¾ã§ãã‚‹ãŸã‚ã€ ã¨ã„ã†ã‚ˆã†ã«ä¸€ã¤ã®Collectionå†…ã«ãƒ‡ãƒ¼ã‚¿ã‚’åŸ‹ã‚è¾¼ã‚“ã§ã—ã¾ã†ã®ãŒã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®ç‚¹ã‹ã‚‰ã‚‚è‰¯ã—ã¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ ãŸã ã—ã€ä»¥ä¸‹ã®2ç‚¹ã«ã¤ã„ã¦
kuchitama 2012/08/21
database

è¨è¨ˆ

db

mongo

mongodb

schema

schema-design

NoSQL
ãƒªãƒ³ã‚¯
SQL to MongoDB Mapping Chart - MongoDB Manual v8.0
In addition to the charts that follow, you might want to consider the Frequently Asked Questions section for a selection of common questions about Mongo DB. Terminology and Concepts The following table presents the various SQL terminology and concepts and the corresponding Mongo DB terminology and concepts.
kuchitama 2012/03/29
mongo

mongodb

sql

db

ãƒãƒ¼ãƒˆã‚·ãƒ¼ãƒˆ
ãƒªãƒ³ã‚¯
MongoDB åŸºæœ¬ã‚³ãƒžãƒ³ãƒ‰ Â» Soho-Style.org
Mongo DBã®åŸºæœ¬ã‚³ãƒžãƒ³ãƒ‰ã‚’ãƒ¡ãƒ¢ã—ã¦ãŠãã¾ã™ã€‚ ã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã®èµ·å‹• /usr/bin/mongo ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¡¨ç¤º show dbs ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®åˆ‡æ›¿(testã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å) use test ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³ã®è¡¨ç¤º show collections ãƒ‡ãƒ¼ã‚¿ã®ä¿å˜ db.test.save({"åå‰" : "å±±ç”°","éƒµä¾¿ç•ªå·" : "123-456", "ä½æ‰€" : "æ±äº¬éƒ½æ–‡äº¬åŒº1-1-1"}) å…¨ä»¶æ¤œç´¢(testã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å) db.test.find() å®Œå…¨ä¸€è‡´æ¤œç´¢(testã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å) db.test.find({åå‰ : å±±ç”°}) å‰æ–¹ä¸€è‡´æ¤œç´¢(testã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å) db.test.find({éƒµä¾¿ç•ªå· : /^123/}) å¾Œæ–¹ä¸€è‡´æ¤œç´¢(testã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å) db.test.find({éƒµä¾¿ç•ªå· : /456$/}) éƒ¨åˆ†ä¸€è‡´æ¤œç´¢(testã¯ãƒ‡ãƒ¼ã‚¿
kuchitama 2012/02/01
mongo

MongoDB
ãƒªãƒ³ã‚¯
1

ãŠçŸ¥ã‚‰ã›

ã‚‚ã£ã¨èªã‚€

å…¬å¼Twitter

@hatebu
æœ€æ–°ã®äººæ°—ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®é…ä¿¡

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

jæ¬¡ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kå‰ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

lã‚ã¨ã§èªã‚€

eã‚³ãƒ¡ãƒ³ãƒˆä¸€è¦§ã‚’é–‹ã

oãƒšãƒ¼ã‚¸ã‚’é–‹ã

è¨å®šã‚’å¤‰æ›´ã—ã¾ã—ãŸx

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (10)

mongoã«é–¢ã™ã‚‹kuchitamaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

ãŠçŸ¥ã‚‰ã›

ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã—ãŸã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®ã‚¿ã‚¤ãƒˆãƒ«å¤‰æ›´æ©Ÿèƒ½ã®æä¾›ã‚’ä¸€æ™‚çš„ã«åœæ¢ã—ã¾ã™

ã€å¾©æ—§æ¸ˆã€‘ã€Œãƒžã‚¤ãƒ›ãƒƒãƒˆã‚¨ãƒ³ãƒˆãƒªãƒ¼ã€ã€ŒãŠæ°—ã«å…¥ã‚Šã€ã€Œé–¢å¿ƒãƒ¯ãƒ¼ãƒ‰ã€ãŒåˆ©ç”¨ã§ããªã„éšœå®³ãŒç™ºç”Ÿã—ã¦ã„ã¾ã—ãŸ

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´1æœˆç¬¬3é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (10)

mongoã«é–¢ã™ã‚‹kuchitamaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

MongoDBã«ãŠã‘ã‚‹é–¢é€£ï¼ˆRelationï¼‰ã®ã‚¹ã‚­ãƒ¼ãƒžè¨­è¨ˆ - masa_wã®æ—¥è¨˜

SQL to MongoDB Mapping Chart - MongoDB Manual v8.0

MongoDB åŸºæœ¬ã‚³ãƒžãƒ³ãƒ‰ Â» Soho-Style.org

ãŠçŸ¥ã‚‰ã›

ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã—ãŸã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®ã‚¿ã‚¤ãƒˆãƒ«å¤‰æ›´æ©Ÿèƒ½ã®æä¾›ã‚’ä¸€æ™‚çš„ã«åœæ­¢ã—ã¾ã™

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2025å¹´1æœˆç¬¬3é€±ï¼‰

å…¬å¼Twitter

ã‚­ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (10)

mongoã«é–¢ã™ã‚‹kuchitamaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

MongoDBã«ãŠã‘ã‚‹é–¢é€£ï¼ˆRelationï¼‰ã®ã‚¹ã‚ãƒ¼ãƒžè¨è¨ˆ - masa_wã®æ—¥è¨˜

ãŠçŸ¥ã‚‰ã›

ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã—ãŸã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®ã‚¿ã‚¤ãƒˆãƒ«å¤‰æ›´æ©Ÿèƒ½ã®æä¾›ã‚’ä¸€æ™‚çš„ã«åœæ¢ã—ã¾ã™

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´1æœˆç¬¬3é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹