The difference between "go" SQL Server and Oracle

transferred from: http://soft.chinabyte.com/database/255/12258255.shtmlThe difference between SQL Server and Oracle2012-02-10 00:00 China it lab anonymous Keywords: Oracle

With the rapid development of information technology, data processing is not only more and more demanding in quantity, but also more and more high in quality. Oracle databases are widely used in most organizations, and SQL Server databases are also widely used in enterprises because of their connection to Windows.

The stability of the operating system is critical to the database, where Oracle can run on all major platforms on a database-operable platform, with an open policy objective that enables customers to choose a solution that best suits their specific needs. Customers can take advantage of a variety of third-party applications and tools. It's a big support for developers. While SQL Server can only run on Windows, this is more monotonous, but the SQL Sever on the window platform, and the overall integration of the Windows operating system, ease of use, and Microsoft Open The integration of the platform is much stronger than Oracle. However, the stability and reliability of the Windows operating system are obvious to all, and Microsoft's strategic goal is to lock customers into the Windows Platform environment, and SQL Server can be improved only with the improvement of Windows performance. From the operational platform, Oracle is completely superior to SQL Server.

As you can see from the data, Oracle's security certifications are certified to the highest certification level, and SQL Server does not have any security certifications. This proves that Oracle is more secure than SQL Server.

Buy a product, the first consideration of course is the performance of the product, when considering the performance of course, and certainly how much money to spend in this product is also a key issue. To establish and run a database system. It includes not only the cost of the initial acquisition of software and hardware, but also the costs of training and later maintenance. The price of the Orcale database is much higher than the SQL Server database, why the Oracle database is much higher than the SQL Server database price, on the one hand Oracle's initial cost is relatively high, especially when considering the tool software, Oracle has a lot of tools to buy separately, and Oracle is more expensive than Microsoft's free SQL Server Tools software. However, because SQL Server can only run under Windows, it is generally considered that the reliability of the SQL Server database is relatively poor. Oracle's performance benefits are reflected in his multi-user, and SQL Server performance benefits are more than enough for multiple users.

operation on SQL Server is significantly simpler than Orcale, if you have used Java and dotnet development platform, the difference is basically Oracle and SQL Server different, Oracle interface is basically Java-based, most of the tools are DOS interface, Even sqlplus, SQL Server is the same as VB, the full graphical interface, rarely see dos windows. Enterprise Manager in SQL Server provides the user with an integrated management console with a full graphical interface to centrally manage multiple servers. Oracle also has its own Enterprise Manager, and its performance in some ways even exceeds the SQL Server Enterprise Manager, but it is more difficult to install.

Orcale database and SQL Server database that's faster? It is a difficult question to answer because there are many uncertainties, including the type of processing, the distribution of data, and the hardware infrastructure.

SQL Server 2000 is a database product with full web support, with Extensible Markup language core support and the ability to query over the Internet and outside the firewall, with scalability, flexibility, extensibility, and low price, Oracle has a reliable security that is a hundredfold faster than SQL Server, but its price is hundreds of times times higher than SQL Server in implementation.

In fact, various industries consider choosing that kind of database, which is determined by the characteristics of the database and the comprehensive consideration of the business needs and infrastructure.