[TOC] ## 概述 mongodb 的關系有 - 1:1 (1對1) - 1: N (1對多) - N: 1 (多對1) - N: N (多對多) ## 關系梳理 有兩個實際 user ``` { "_id":ObjectId("52ffc33cd85242f436000001"), "name": "Tom Hanks", "contact": "987654321", "dob": "01-01-1991" } ``` address ``` { "_id":ObjectId("52ffc4a5d85242602e000000"), "building": "22 A, Indiana Apt", "pincode": 123456, "city": "Los Angeles", "state": "California" } ``` ### 嵌入式關系 把user,address 放入一個集合中 ``` { "_id":ObjectId("52ffc33cd85242f436000001"), "contact": "987654321", "dob": "01-01-1991", "name": "Tom Benzamin", "address": [ { "building": "22 A, Indiana Apt", "pincode": 123456, "city": "Los Angeles", "state": "California" }, { "building": "170 A, Acropolis Apt", "pincode": 456789, "city": "Chicago", "state": "Illinois" }] } ``` 查找語句 ``` db.users.findOne({"name":"Tom Benzamin"},{"address":1}) ``` 缺點: - 如果用戶和用戶地址在不斷增加，數據量不斷變大，會影響讀寫性能。 ### 引用式關系 ``` { "_id":ObjectId("52ffc33cd85242f436000001"), "contact": "987654321", "dob": "01-01-1991", "name": "Tom Benzamin", "address_ids": [ ObjectId("52ffc4a5d85242602e000000"), ObjectId("52ffc4a5d85242602e000001") ] } ``` 需要查詢兩次 ``` > var result = db.users.findOne({"name":"Tom Benzamin"},{"address_ids":1}) > var addresses = db.address.find({"_id":{"$in":result["address_ids"]}}) ```