????????????????????
???????????? ???????[ 2015/11/20 13:52:53 ] ?????????????? ?????
?????????????????????????????д?????????????????????????????????????????????????????????棬???????????????
???????????λ?????????????????????????????????????????????????檔
????#####################################
??????????????????????????????????????з??????????
???????????????????“???”????????????????????????????????????????? ??????????????????????????????????????hadoop/mapreduce????????????? ??????storm?????????????????????棬??к???仯??
??????????????????????????????????????I/O?????????????? RDBM????????????洢??????????????????д????????????? ????Щ???????о??????70?????80?????????????????????????£? ??????????????70???80?????????????
????????80?????????????? ?????????2T???????????90?????????????????????????????? ?????????????????????????????????е??????????????????????? ????????????????????????????????????????????????????????????? ??????
????????????????????RDBMS?е??????????????????????????????岻?????????д???????????????
??????????????????????????????????к??????????????????????? ??????????????????????????????????????????????????????? ??????????????????????????????????????????????????????????????????????????????λ?????????
???????????ж???????С???????????? ????????????????????????????????????ù?????????????μ?????? ???????????????????к??????key-value??????????oodb??????? ???????????json?????????????Щ?????????????????????????????
???????????????????????????????????????????????????????ж??????
???????????NewSQL???????????????????????????????relax normalization?? ????????洢??????????????????????????projection??Щ????????? ?????????SQL???????????Щ??????????????????????????????????? ??÷????????????“????”????
??????????“??”?????????Ч???????????????????? ???????newSQL????????????????????????????????й????????й????? ???????????????????????????У???????У??????????е??????У????????? ????????????е?????????????????????Щ????????????????п???????????? ???????δ??????????????????????????壬???RDBM????????????????? ??????nation_id??????????????id??????????????New SQL?????????????????????????????д?????????????????????????????
?????????????????????????????????????????????????????????????????????????β???????????????????????????????????????????????????? ??????????λ?????????
??????????????????rdbm????????????????????????????????????????д????????????????????????????????????е??????????????????????????????????? ???????????A?? B?? C???У?A??B?????????????? B?? C?????A?? ?? C ??????????A?????????? B?? C?????B?????????????????????????????????????Ч?????????????????????????????????????????ò??????????
???????????????????????????????????????????????????????????С? ????????????????????д????????????????????????????????????? ????????????????????????read-only database??????????????????????? ????????????????????????????????????????????????е????????
????????read-only????????????????????????????block?????????lzo?? ??????????hdfs?? —— ???????????????????????????????????????
?????????????????????????????????λ??????????
????##########################################
????1. ??????????????????????????????????????洢?????????漰???????????????????????????
????2. ?????????????????????????????????洢??????????????????SQL???棬??????????????? ?????????????MPP????????????????????????????????Teradata?? Oracle ExaData?? Greenplum?? IBM DPF...
????3. ?????????????????÷?????????????????????????????????????????б??????
????4. ?????????е???????????????緶???????????????????????????????SQL??????????????????????????????????CAP???????????Щ??????????????????????????????????Щ????????????????????汾???????????á?
????????SQL on Hadoop/SQL on HDFS???????????????????SQL????????????? ?Щ????????????
??????????????????????С?????rac??exadata??????????????????
????##########################################
????oracle/rac??oracle exadata?????????????exadata?洢????????????oracle server????????oracle rac??
????share nonthing?????????????Teradata?????????hadoop??????????cost effective???????1.hdfs?????????????????????????崻???????????????????????崻??????????????Щ?????????????????????
????2.hadoop/yarn/tez/spark???????????????????????????????????????д???????????????????? ????????????????????share nothing??????????п???????????? ???share???????????????
????????????pg??mongo????????????????????????
????########################################
????mongodb????????????????????????????棬????????????????schema????????????????????檔
????postgresql??mongodb???п??????????????????????postgresql???????????mongodb. postgresql 9.4???????в?????????
????????mongodb?????治??pg
??????
???·???
??????????????????
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