MySQL vs Oracle Databases
Oracle
Oracle yog RDBMS (Cov Khoom Siv Kev Sib Raug Zoo database Management System). Nws yog tsim los ntawm Oracle Corporation. Qhov tseeb version ntawm Oracle database yog 11g uas muab cov kev pabcuam zoo xws li:
• Ob npaug DBA kev tsim khoom
• Tshem tawm cov ntaub ntawv chaw rov ua dua thiab ua kom muaj ntau tshaj plaws.
• Consolidates thiab clusters enterprise applications rau scalable, ceev thiab txhim khu kev qha private huab.
• Txo txoj kev pheej hmoo ntawm kev hloov pauv los ntawm kev ua kom tiav DBS ob npaug.
Muaj ntau yam ntawm cov ntaub ntawv oracle:
Enterprise Edition
tsab ntawv no muab qhov muaj peev xwm, kev ntseeg tau, thiab kev nyab xeeb ntawm ib leeg lossis pawg servers khiav UNIX, Windows thiab Linux. Nws cov txiaj ntsig suav nrog kev tiv thaiv tib neeg yuam kev, server tsis ua haujlwm, kev npaj txo qis thiab qhov chaw tsis ua haujlwm. Cov ntawv no kuj muab kev txheeb xyuas online, cov ntaub ntawv mining thiab warehousing.
Standard Edition
tsab ntawv no yog tus nqi pheej yig nrog rau tag nrho cov ntaub ntawv tshwj xeeb. Nws yog ib qho yooj yim los tswj thiab tuaj yeem ntsuas tau yooj yim thaum muaj kev xav tau ntau ntxiv. Oracle Real Application Clusters kuj muaj nyob rau hauv no version. Ib qho tuaj yeem hloov kho tau yooj yim rau Enterprise Edition raws li nws tau sib xws nrog nws.
Standard Edition Ib
Nws kuj yog ib daim ntawv qhia tag nrho tab sis txhawb nqa txog ob lub qhov (socket). Nws cov haujlwm zoo ib yam li Standard Edition thiab nws tuaj yeem hloov kho tau yooj yim rau Enterprise Edition. Nws muab qhov kev ua tau zoo tshaj plaws txawm tias tus nqi qis.
MySQL database system
MySQL yog qhov qhib qhov chaw tswj hwm qhov system. Nws yog nrov heev vim nws txoj kev ntseeg siab, kev siv yooj yim thiab kev ua haujlwm siab. MySQL yog siv rau ntau daim ntawv thov tshiab uas tau tsim rau Apache, Linux, Perl / PHP thiab lwm yam. Ntau lub koom haum nrov xws li Google, Alcatel Lucent, Facebook, Zappos thiab Adobe cia siab rau qhov kev tswj hwm database.
MySQL tuaj yeem khiav ntawm ntau tshaj nees nkaum lub platform uas suav nrog MAC OS, Windows, Linux, IBM AIX, HP-UX thiab muab kev hloov pauv ntau. Ntau yam ntawm cov cuab yeej database, kev pabcuam, kev cob qhia thiab kev txhawb nqa yog muab los ntawm MySQL database system. MySQL los ntawm ntau yam:
Enterprise Edition
tsab ntawv no muab OLTP (Scalable Online Transaction Processing) cov ntaub ntawv thov thiab tseem muab kev ua haujlwm zoo. Nws muaj peev xwm muaj xws li rollback, kab theem xauv, tag nrho kev cog lus thiab kev sib tsoo rov qab. Txhawm rau tswj hwm thiab txhim kho kev ua haujlwm ntawm cov ntaub ntawv loj loj, kev faib cov ntaub ntawv kuj tau tso cai los ntawm tsab ntawv no.
Cov Enterprise Edition suav nrog MySQL Enterprise Backup, Enterprise Monitor, Query Analyzer thiab MySQL WorkBench.
Standard Edition
tsab ntawv no tseem muab OLTP daim ntawv thov nrog rau kev ua haujlwm siab. Cov ntawv tshaj tawm kuj suav nrog InnoDB uas ua rau nws ua raws li ACID thiab kev lag luam-kev nyab xeeb database. Txhawm rau xa cov ntawv thov tuaj yeem ua tau thiab ua haujlwm siab, kev rov ua dua kuj tau tso cai los ntawm qhov system database.
Classic Edition
Nws yog qhov zoo tshaj plaws database system rau OEMs, VARs thiab ISVs uas siv MyISAM cia lub cav los tsim cov ntawv nyeem ntau heev. Cov ntawv classic yog siv tau yooj yim thiab xav tau kev tswj hwm tsawg. Txawm li cas los xij, tsab ntawv no tsuas yog rau VARs, ISVs thiab OEMs. Ib qho yooj yim tuaj yeem hloov kho mus rau cov ntawv tshaj tawm los ntawm cov ntawv classic.
| Qhov txawv ntawm MySQL thiab Oracle |
| . MySQL yog qhov qhib qhov chaw database whereas Oracle yog RDBMS tsim los ntawm Oracle Corporation. |
| . MySQL txhawb nqa ntau lub platforms piv rau Oracle database. |
| . Oracle - doubles DBA productivity, tshem tawm cov ntaub ntawv chaw redundancy thiab maximizes muaj, consolidates thiab pawg neeg lag luam daim ntawv thov mus rau scalable, ceev thiab txhim khu kev qha private huab, txo qhov kev pheej hmoo ntawm kev hloov los ntawm ob npaug rau DBS productivity |
| . MySQL - kev ntseeg siab, kev siv yooj yim, kev ua haujlwm siab, muab ntau yam cuab yeej database, kev pabcuam, kev cob qhia thiab kev txhawb nqa |
| . Ob lub databases tuaj sib txawv |
