The current database market, mainly Oracle, MySQL, IBM's DB2 and Microsoft's SQL Server, where Mysql is free, the other three are relatively good business software. Free to have free benefits, commercial also has the advantage of business, generally speaking, small enterprises and some traditional portals mostly use free software, and large and medium-sized enterprises are using commercial software, because business software for data security, ease of use and so on provide a better solution. So which database products are best for midsize enterprises to use?
How to choose the right database products for midsize enterprises. In general, focus on product security, ease of use and price/performance aspects, because most database products can meet the requirements of data storage and processing. IBM's DB2 has been a high-end route, focusing on large database applications and requiring high-end servers to support it. Microsoft's SQL Server is also more suitable for small businesses, because it is easier to use and cheaper. NET development generally choose SQL Server to do the database, is a relatively low-end of a database products, Oracle database has long been concentrated in the large and medium enterprise market, in the high-end market share is very high, but the price is relatively high, but after oracle11g, He specializes in a version tailored for midsize enterprises, and prices have a competitive advantage over the performance of database products. There is also oracle11g operation is relatively simple. Medium-sized enterprises are generally not strong technical force, will generally choose to operate a simple database products, oracle11g is obviously learned this lesson, improved the way of operation, provides a lot of automation, make it easier to use.
Personally, I am more interested in the new features of oracle11g. SQL Automatic optimization, zoning recommendations, data compression, etc. are very suitable functions, can effectively reduce the database technician learning and maintenance costs. From a technical point of view, the more understand the original, the better, from a practical point of view, simple and easy to use is very important. Therefore, it is recommended that midsize enterprises Select a database product, first consider the oracle11g medium Enterprise version, especially the database used by the Java-developed application system.