??Oracle???Mysql???????50????
???????????? ???????[ 2014/10/28 11:27:42 ] ????????????? Oracle MySQL
????1?? ???????????????????
????2?? ???????????????
????3?? ????????????????
????4?? ???????????????????????
????5?? ????????????
????6?? ?????????????????????????????????????????????л??????????(???????????????)????????????????????/????????????????/?????????????????????????????????????????????Oracle??????????????
????7????????????????????????????LDAP??Active Directory?????????????????????????
????8??Mysql Cluster??????????????н?????
????9???洢????????????????????
????10????????????????
????11???????MPP(???????д???)??
????12?????SMP(????????)??????????????????????4??8????(core)???Mysql???????????
????13??????????????????????????????????????洢?????
????14??????????д?洢???????????????????????洢??????????????????
????15????л?????(roll-back)???????????????(roll-forward)?????????
????16??????????????
????17??????????????(database link)??????????Federated??洢?????????????????????????????????????????????????????????????????????
????18??????????????????????????????????????????????????????С?
????19?????????????м??????????????????
????20????????????????????????????(nested-loop)???????????-???????(sort-merge join)?????????(hash join)??
????21????????????????????????;???Щ????£?????????????????????????????????????????????????????????軹?????
????22???????λ?????(bitmap index)?????洢???涼????????????????????洢???涼???B-Tree??????
????23??????????????????????????
????24????г???????????????IDE??????????????????ò???????????б?д?洢????????????????(?????????)?в??????????????????
????25??????????????????????洢???檔
????26??????洢?????????????????????????????????к?????
????27??????洢???涼??????????
????28??????洢????(MyISAM)??????????????????????
????29????????е?洢????InnoDB??Oracle??С?
????30????Щ??м???????????洢???檔????????Count???????????洢????????к???????????洢?????п?????????
????31????м??????????????????????????????????????
????32?????????????????? ??????????????洢???檔 Ditto????????????/????????????
????33???????????????????δ???????????????????????????????????????沢?????????????????????CPU?????
????34????м??????????(business intelligence)?? OLAP ?????????????????
????35???????Grid Control????????(http://solutions.mysql.com/go.php?id=1296&t=s)
????36???????????RAC?????????????”??????Mysql??????RAC”?????????????????
????37??????????????????????(domain)??
????38?? ??????????????????????61??
????39??MySQL????SQL??(ANSI SQL???)???С??????????????????????????Oracle??with ???????????????????????????????????????Merge?????????????SQL????????????????Oracle??????????????
????40?? ??????????(????????????????У?Oracle11g ??????????У????????汾???????(rownum??rowid))??
????41????????????????????????????????е???????
????42??????????????
????43???????洢?????????????????????????е?洢??????????????????????????(cardinality)???????Χ???????(rows-in-a-range)?? ???仰???????????????????????????????????????????
????44??????????????????????л??????
????45??????(Replication)????????????????к????????????磬?????????(single-threaded)?????????????????????Slave??????????????????????????????Master??
????46?? Cluster??????????????????????????????????????????????????????顣
????47?????????(INFORMATION_SCHEMA)???????????????????????(????????????????????????)??
????48????????????Alter Table??????
????49???????Sequence??
????50????????ALTER TABLE??CREATE TABLE???????????????????????????δ????????????????????????????????Schame?????????????????????????????洢????????
??????
???·???
??????????????????
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