際際滷

蛍�繁�吹吹 http://weibo.com/lidaohang

NoSQL 膨寄窃 1.key-value 贋刈 Examples Tokyo Cabinet/Tyrant, Redis, Voldemort, Oracle BDB 灸侏哘喘魁尚坪否産贋�麼勣喘噐侃尖寄楚方象議互恵諒減墮�匆喘噐匯乂晩崗狼由吉吉。方象庁侏 Key 峺� Value 議囚峙斤�宥械喘 hash table 栖糞� 膿� 臥孀堀業酔樋� 方象涙潤更晒�宥械峪瓜輝恬忖憲堪賜宀屈序崙方象

NoSQL 膨寄窃 2. 双塀方象垂 Examples Cassandra, HBase, Riak 灸侏哘喘魁尚蛍下塀議猟周狼由方象庁侏參双関塀贋刈�繍揖匯双方象贋壓匯軟膿� 臥孀堀業酔�辛制婢來膿�厚否叟序佩蛍下塀制婢樋� 孔嬬�斤蕉�

3. 猟亀侏方象垂 NoSQL 膨寄窃 Examples CouchDB, MongoDb 灸侏哘喘魁尚 Web 哘喘�嚥 Key-Value 窃貌� Value 頁潤更晒議�音揖議頁方象垂嬬校阻盾 Value 議坪否� 方象庁侏 Key-Value 斤哘議囚峙斤� Value 葎潤更晒方象膿� 方象潤更勣箔音冢鯉�燕潤更辛延�音俶勣�購狼侏方象垂匯劔俶勣圓枠協吶燕潤更樋� 臥儂來嬬音互�遇拝髪窪由匯議臥儂囂隈。

4. 夕潤更方象垂 NoSQL 膨寄窃 Examples Neo4J, InfoGrid, Infinite Graph 灸侏哘喘魁尚芙住利大�容呪狼由吉。廨廣噐更秀購狼夕惇方象庁侏夕潤更膿� 旋喘夕潤更�購麻隈。曳泌恷玉揃抄儖峽� N 業購狼臥孀吉樋� 載謹扮昨俶勣斤屁倖夕恂柴麻嘉嬬誼竃俶勣議佚連�遇拝宸嶽潤更音湊挫恂蛍下塀議鹿蛤圭宛。

MongoDB 初府豊壓聞喘 ?

MongoDB 初府 Mongo 頁匯倖互來嬬�蝕坿�涙庁塀議猟亀侏方象垂�万壓俯謹魁尚和辛喘噐紋旗勧由議購狼侏方象垂賜囚 / 峙贋刈圭塀。 Mongo 聞喘 C++ 蝕窟。

MongoDB 初府蒙泣互來嬬、叟何俸、叟聞喘�贋刈方象掲械圭宴。麼勣孔嬬蒙來嗤� 中�鹿栽贋刈�叟贋刈斤�窃侏議方象。庁塀徭喇。屶隔強蓑臥儂。屶隔頼畠沫哈�淫根坪何斤�。屶隔臥儂。屶隔鹸崙才絞嬾志鹸。聞喘互丼議屈序崙方象贋刈�淫凄寄侏斤��泌篇撞吉�。徭強侃尖哩頭�參屶隔堝柴麻蚊肝議制婢來屶隔 Python � PHP � Ruby � Java � C � C# � Javascript � Perl 式 C++ 囂冱議駁強殻會 , 芙曝嶄匆戻工阻斤 Erlang 式 .NET 吉峠岬議駁強殻會。猟周贋刈鯉塀葎 BSON �匯嶽 JSON 議制婢� 辛宥狛利大恵諒

MongoDB 初府癖喘魁栽利嫋方象� Mongo 掲械癖栽糞扮議峨秘�厚仟嚥臥儂�旺醤姥利嫋糞扮方象贋刈侭俶議鹸崙式互業阜抹來。産贋�喇噐來嬬載互� Mongo 匆癖栽恬葎佚連児粥譜仏議産贋蚊。壓狼由嶷尼岻朔�喇 Mongo 喜秀議隔消晒産贋蚊辛參閲窒和蚊議方象坿狛墮。寄樫雁�詰勺峙議方象�聞喘勧由議購狼侏方象垂贋刈匯乂方象扮辛嬬氏曳熟虻酷�壓緩岻念�載謹扮昨殻會埀吏吏氏僉夲勧由議猟周序佩贋刈。互阜抹來議魁尚� Mongo 掲械癖栽喇方噴賜方為岬捲暦匂怏撹議方象垂。 Mongo 議揃�夕嶄厮将淫根斤 MapReduce 哈陪議坪崔屶隔。喘噐斤�式 JSON 方象議贋刈� Mongo 議 BSON 方象鯉塀掲械癖栽猟亀晒鯉塀議贋刈式臥儂。

MongoDB 初府音癖喘魁栽 1. 互業並暦來議狼由�箭泌咢佩賜氏柴狼由。勧由議購狼侏方象垂朕念珊頁厚癖喘噐俶勣寄楚圻徨來鹸墫並暦議哘喘殻會。 2. 勧由議斌匍崘嬬哘喘�寞斤蒙協諒籾議 BI 方象垂氏斤恢伏互業單晒議臥儂圭塀。斤噐緩窃哘喘�方象花垂辛嬬頁厚栽癖議僉夲。

MongoDB 荷恬芦廾 wget http://downloads.mongodb.org/linux/mongodb-linux-x86_64-1.2.4.tgz tar -zxvf mongodb-linux-x86_64-1.2.4.tgz mkdir -p /data/db cd /data/db mkdir m_data m_log cd mongodb-linux-x86_64-1.2.4 尼強� bin/mongod --dbpath=/data/db/m_data --logpath=/data/db/m_log --logappend --port=27017 &

MongoDB 荷恬 INSERT 聞喘 insert 峨秘猟亀。 ( insert into blog.users values(＾user1￣,￣23) ) > use blog switched to db blog > u = { name:"user1", age:23 } > db.users.insert(u)

_id 才 ObjectId 恬喘 MongoDB 嶄贋刈議猟亀駅倬嗤匯倖＾ _id￣囚。宸倖囚辛參頁販吭窃侏� 潮範頁 ObjectId 。 ObjectId 議怏栽� 0 | 1 | 2 | 3 4 | 5 | 6 7 | 8 9 | 10 | 11 扮寂漢字匂 PID 柴方匂 1. 扮寂漢�扮寂音僅延晒議 2. 字匂�麼字議率匯炎紛鷹。宥械頁字匂麼字兆議柊双峙�宸劔辛參鳩隠音揖麼字伏撹音揖議 ObjectId �音恢伏喝融。 3.PID: 葎阻鳩隠壓揖匯岬字匂貧旺窟議謹倖序殻恢伏議 ObjectId 頁率匯議� 侭參紗貧序殻炎紛憲 (PID). 4. 柴方匂�湘倖忖准隠屬阻揖匯昼嶝音揖字匂音揖序殻恢伏議 ObjectId 頁率匯議。朔眉倖忖准祥頁匯倖徭強奐紗議柴方匂�鳩隠�揖序殻揖匯昼恢伏議 ObjectId 匆頁 ObjectId 匆音頁音匯劔。揖匯昼恷謹塋俯耽倖序殻啜嗤 16 777 216 倖音揖議 ObjectId 。

2. Query MongoDB 屶隔謹嶽鹸墫議臥儂圭塀�嬬糞�寄謹方 T-SQL 孔嬬�垓音頁 Key-Value 岻窃議 NoSQL DB 侭嬬曳亭議。 �購痕方荷恬心貧肇掲械� .NET/C# Linq Method Syntax 。嗤購臥儂單晒才沫哈議聾准萩歌深朔猟。麼勣喘欺議臥儂痕方塀 find() 才 findOne() �念宀卦指匯倖亨旗匂 cursor �朔宀卦指汽倖猟亀。 WHERE # select * from users where name = 'user1' > db.users.find({name:"user1"}) { "_id" : ObjectId("4c4528a0b55f2224d447e4b0"), "name" : "user1", "age" : 21, "sex" : 1 } # select * from users where name = 'user1' and age = 21 > db.users.find({name:"user1", age:21}) { "_id" : ObjectId("4c4528a0b55f2224d447e4b0"), "name" : "user1", "age" : 21, "sex" : 1 } MongoDB 荷恬

FIELDS # select name, age from users where age = 21 > db.users.find({age:21}, {'name':1, 'age':1}) { "_id" : ObjectId("4c452c343d48c8f284b388e0"), "name" : "user1", "age" : 21 } # select name, age from users > db.users.find({}, {'name':1, 'age':1}) SORT # select * from users order by age > db.users.find().sort({age:1}) # select * from users order by sex asce, age desc > db.users.find().sort({sex:1, age:-1}) SLICE # select * from users skip 2 limit 3 > db.users.find().skip(2).limit(3) Conditional Operators # select * from users where sex = 1 and age > 23 and age < 28 > db.users.find({sex:1, age:{$gt:23, $lt:28}}) 曳熟荷恬淫凄� $gt (>) 、 $lt (<) 、 $gte (>=) 、 $lte(<=) 、 $ne (!=) 。

(6) IN # select * from users where age in (23, 26, 32) > db.users.find({age:{$in:[23,26,32]}}) 斤哘議荷恬憲嗤 $nin (not in) 。 (7) COUNT # s elect count(*) from users where age > 30 > db.users.find({age:{$gt:30}}).count() OR # select * from users where age = 25 or age = 28 # select * from users where age <= 23 or age >= 33 > db.users.find({$or:[{age:25}, {age:28}]}) > db.users.find({$or:[{age:{$lte:23}}, {age:{$gte:33}}]}) MongoDB 荷恬

Update 辛岷俊喘窃貌 T-SQL 訳周燕器塀厚仟�賜喘 Save() 厚仟貫方象垂卦指欺猟亀斤�。 # update users set age = 100, sex = 0 where name = 'user1' > db.users.update({name:"user1"}, {$set:{age:100, sex:0}}) update() 嗤叱倖歌方俶勣廣吭。 db.collection.update(criteria, objNew, upsert, mult) criteria: 俶勣瓜厚仟議訳周燕器塀 objNew: 厚仟燕器塀 upsert: 泌朕炎芝村音贋壓�頁倦峨秘仟猟亀。 multi: 頁倦厚仟謹倖猟亀。 # update users set age = age + 10 > db.users.update({}, {$inc:{age:10}}, false, true) # update users set age = age + 10, sex = 1 where name = 'user1' > db.users.update({name:"user1"}, {$inc:{age:10}, $set:{sex:1}}) Remove remove() 喘噐評茅汽倖賜畠何猟亀�評茅朔議猟亀涙隈志鹸。 > id = db.users.findOne({name:"user2"})._id ObjectId("4c4508818c4a1e0bf570460f") > db.users.remove(id) // 卞茅 name='use2' 議佩 > db.users.remove()// 卞茅侭嗤

MongoDB: Index // single ascending db.colors.ensureIndex({name: 1}) // non-blocking in background db.colors.ensureIndex({name: 1}, {background: true}) // unique db.colors.ensureIndex({email: 1}, {unique: true}) // single descending db.colors.ensureIndex({created_at: -1}) // compound > db.colors.ensureIndex({name: 1, created_at: -1})

MongoDB:Aggregation 1.> db.colors.count() >6 2. > db.colors.distinct('name') [ "blue", "green", "orange", "purple", "red", "yellow" ] 3. > db.items.insert({title:'Home', template:'home'}) > db.items.insert({title:'What We Do', template:'page'}) > db.items.insert({title:'Our Writing', template:'page'}) > db.items.insert({title:'Who We Are', template:'page'}) > db.items.insert({title:'Hire Us', template:'page'}) > var key = {template: true}; > var initial = {count:0}; > var reduce = function(obj, prev) { prev.count += 1; }; > db.items.group({key:key, initial:initial, reduce:reduce}) [ {"template" : "home", "count" : 1}, {"template" : "page", "count" : 4} ]

> db.people.insert({ name : 'John', awesome : true, shows : ['Dexter', 'LOST', 'How I Met Your Mother'], info : { age : 28, home: 'South Bend, IN', dob : (new Date('November 25, 1981')) } }) > var me = db.people.findOne({name:'John'}) > me.name John > me.awesome true > me.shows[1] LOST > me.info.age 28 > me.info.dob.getFullYear() 1981

One to Many 匯、 Normalized // insert post > db.posts.insert({title:'Why Mongo Rocks'}); > var post = db.posts.findOne({title:'Why Mongo Rocks'}); // insert comment > db.comments.insert({ name :'John', body :'Because...', post_id : post._id }); var comment = db.comments.findOne({name:'John'}); > db.comments.find({post_id: post._id}) { "_id" : ObjectId("4bee1cc79e89db4e12bf78de"), "name" : "John", "body" : "Because...", "post_id" : ObjectId("4bee1c519e89db4e12bf78dd") }

屈、 Embedded 購狼侏方象垂議贋刈圭塀�

箭泌� { "VendroId": 1, "Name": " 斌社 1", "ItemInfo": [ { "ItemId": "634422022659939961", "ItemName": " 斌瞳 634422022659939961", "ServiceCateId": 1 }, { "ItemId": "634422022659949961", "ItemName": " 斌瞳 634422022659949961", "ServiceCateId": 1 } ], "_id": "4de0c71bbeb52e0ecc000001" } db.VendorInfo.find({＾ItemInfo￣:{＾$elemMatch￣:{"ItemId", "634422022659949961"}}})

Many to Many db.sites.insert({domain: 'orderedlist.com'}) db.sites.insert({domain: 'railstips.org'}) > db.sites.find() { "_id" : ObjectId("4bee280f9e89db4e12bf78e2"), "domain": "orderedlist.com" } { "_id" : ObjectId("4bee283c9e89db4e12bf78e3"), "domain": "railstips.org" }

> db.users.insert({ name: 'John', authorizations: [ ObjectId('4bee280f9e89db4e12bf78e2'), ObjectId('4bee283c9e89db4e12bf78e3') ] }) > db.users.insert({ name: 'Steve', authorizations: [ ObjectId('4bee280f9e89db4e12bf78e2') ] }) > var orderedlist = db.sites.findOne({domain:'orderedlist.com'}) db.users.find({authorizations:orderedlist._id}) > var railstips = db.sites.findOne({domain:'railstips.org'}) db.users.find({authorizations:railstips._id}) > var john = db.users.findOne({name:'John'}) > db.sites.find({_id:{$in: john.authorizations}})

Tools Performance Indicators Remedies

3. Profiler ? > db. setProfilingLevel (2) { "was" : 0, "slowms" : 100, "ok" : 1 } > db.system.profile. find (). sort ({$natural: -1}) { "ts" : ISODate ("2011-05-24T14:20:09.711Z"), "info" : "query docs.spreadsheets reslen:257 nscanned:1805535 query: { query: {}, $explain: true } nreturned:1 1407ms", "millis" : 1407 }

際際滷

珂看稼乙看酔堀秘壇

Recommended

More Related Content

What's hot (17)

Viewers also liked (20)

Similar to 珂看稼乙看酔堀秘壇 (20)

More from Lucien Li (6)

珂看稼乙看酔堀秘壇