SQL VS NoSQL???????????
?????Linux???? ???????[ 2016/11/1 11:43:25 ] ????????????? SQL Server
??????????????????????????????SQL??NoSQL????????????????????????????????????????е??????????????????????????????????
?????????????????????£?
????SQL?????
????· ????洢????????
????· ????????????????????
????· ??????ù淶?????????????????
????· ??????JION????????????SQL?????????????????????
????· ????????????????????????
????· ??????????????????????
????· ????????????
????· ???????SQL??????в??????
????· ??????????????????????????
????NoSQL?????
????· ?????JOSN???????????洢????????
????· ?洢???????????????
????· ??÷?淶???????洢????????????????а??????????????????
????· ????????JION????
????· ?????????????????????洢???????λ??
????· ??????μ????????????????????
????· ?????????????????
????· ???JOSN?????????в??
????· ?????????????
????SQL??????????Щ???????????????????????????????NoSQL?????????????Щ????????????????????Щ?????????????????????????????????
????· SQL??????? ?????????о???????????????????????????ó?????????????????????
????· NoSQL?????? ?????????в?????????????????????ó??????罻???磬???????????????????
???????????????????????????????????????????????????С????????????????κ??????????????????????????????????????????SQL????????????NoSQL??????????????????????????????檔?????????????????????????????????????????????????????????????????
????????????????
?????????????μ?????????????SQL??????????????????????? contact ???????????????;
????· id
????· title
????· firstname
????· lastname
????· gender
????· telephone
????· email
????· address1
????· address2
????· address3
????· city
????· region
????· zipcode
????· country
??????????? ???????????????????????????????????????????Σ?????綽??????綽??????綽????????????????????????????????????????????????????????????????????? telephone ????????????????????????????????????淶?????????????— ?????????????е綽????????
????· contact_id
????· name (?????Σ????????????????.)
????· number
??????????? ?????????????????????????????????????????????????? email ????
????· contact_id
????· name (?????Σ????????????????.)
????· address
???????????? ????????д??????????????????????д???????λ?????????????????????????????ε??????????????????? address ???
????· contact_id
????· name (text such as home?? office?? etc.)
????· address1
????· address2
????· address3
????· city
????· region
????· zipcode
????· country
??????????????? contact ????????
????· id
????· title
????· firstname
????· lastname
????· gender
?????????????????????????淶??????????????????洢?κ??????????綽?????????????????????......
???????????????
???????????п???????????????????????λ???????????????????Σ??????????????????????????????????????罻?????????????????????????????????????????????????????????????????????????д洢????????????????????????????
?????????????????
???????????????????????????????????????????鷳????????????????????Ч???????????????? select ????? JOIN ???????????????????????????????? ????????????????????????????????й??????綽??????????????????????????????3???綽???????????????????????SQL????????30??????????????????Ч??????????
????????????????????????????????????????????favorite????????????β??????????????ж??????????????????????綽?????????????????Щ???????????????????ù? WordPress ?????????????????????????
???????NoSQL?????SQL
???????????????????????????塣????????????????????????????????ε???????????????????????NoSQL???????????NoSQL????????????洢????????????? contacts ??????У?
{
name: [
"Billy"?? "Bob"?? "Jones"
]??
company: "Fake Goods Corp"??
jobtitle: "Vice President of Data Management"??
telephone: {
home: "0123456789"??
mobile: "9876543210"??
work: "2244668800"
}??
email: {
personal: "bob@myhomeemail.net"??
work: "bob@myworkemail.com"
}??
address: {
home: {
line1: "10 Non-Existent Street"??
city: "Nowhere"??
country: "Australia"
}
}??
birthdate: ISODate("1980-01-01T00:00:00.000Z")??
twitter: '@bobsfakeaccount'??
note: "Don't trust this guy"??
weight: "200lb"??
photo: "52e86ad749e0b817d25c8892.jpg"
}
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11