As an architect I have often been asked this question by my clients, friends and at work.作為一個建築師,我常常有人問這個問題由我的客戶,朋友和工作。 I would like to answer it briefly once and for all.我想回答簡單一勞永逸的。

For enterprise applications which deal with huge data volume (read terabyte range) like bioinformatics applications or with need for data complex analytics using MOLAP, ROLAP etc. should definitely go with Oracle.為企業應用處理龐大的數據量(閱讀TB的範圍)一樣,生物信息學的應用,或與需要複雜的數據分析使用molap , rolap等,一定要到與Oracle 。

Any application that needs complex queries, integration with financial accounting systems, project management systems should again opt for Oracle.任何應用程序,需要複雜的疑問,整合與財務會計系統,項目管理系統應再次選擇甲骨文公司。

For simple online web applications requiring fast read access to data, without need for complex queries and on budget should opt for MySQL. MySQL is poor man’s Oracle.為簡單的在線Web應用程序,要求快速讀取數據的獲取,而不需要複雜的查詢以及預算應該選擇MySQL的。 MySQL的是窮人的甲骨文。
Certain limitations of MySQL like lack of full support for inner queries are sometimes infuriating, but that’s life.某些限制的MySQL一樣,缺乏充分的支持,黨內的疑問,有時激怒,但是這就是生活。 In my experience its robustness is less than Oracle.在我的經驗,其魯棒性是少於甲骨文。

Note: In case you are wondering I am well aware of other databases in this space like Sybase, Ingres, PostgreSql, DB2, Microsoft SQL Server etc.注意:在情況下,您是不知道我清楚知道,其他數據庫,在這個空間一樣,賽貝斯,的Ingres和PostgreSQL ,的DB2 , Microsoft SQL Server的等。

Disclaimer: I am not affiliated with either of these companies in any way, nor have I been paid to write this entry.免責聲明:我不附屬於任何一方,這些公司以任何方式,也不是我已支付給寫此項目。

Note: For Java Heads, HyperSonic SQL is fine for development purposes but strongly not recommended for deployment.注意:對於Java的元首,高超聲速SQL是罰款為發展目的,但強烈建議不要進行部署。 And yes it is based on extensive personal experience with Hypersonic SQL.是的,這是基於廣泛的個人經驗與高超的SQL 。