Mongo资料分享课件.pptVIP

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} ] 精品 Similar Data Types 精品 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}) John me.awesome true me.shows[1] LOST .age 28 .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 ments.insert({ name :John, body :Because..., post_id : post._id }); var comment = ments.findOne({name:John}); ments.find({post_id: post._id}) { _id : ObjectId(4bee1cc79e89db4e12bf78de), name : John, body : Because..., post_id : ObjectId(4bee1c519e89db4e12bf78dd) } 精品 二、Embedded 关系型数据库的存储方式： 精品 MongoDB的存储方式： 精品 例如： { 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: }) db.sites.insert({domain: }) db.sites.find() { _id : ObjectId(4bee280f9e89db4e12bf78e2), domain: } { _id : ObjectId(4bee283c9e89db4e12bf78e3), domain: