Relational Database Management System to use for Enterprise Software Development关系型数据库管理系统使用的企业软件开发
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 。
Filed under提起下 Database数据库 , , Headline News头条新闻 , , Open Source Software开放源码软件 , , RDBMS RDBMS的 , , Technology技术 | |
| |
RSS 2.0 2.0 | |
Trackback Trackback跟踪 this Article |此文章|
Email this Article电子邮件此文章
You may also like to read您也可以想读 |



