Who do you choose for Oracle and ms SQL Server?

Microsoft (China) Co., Ltd. announced that in March 2001, Microsoft SQL Server 2000 received three consecutive
Grand Prize, highly scalable data warehouse, and business intelligence features won deep recognition. In April 2001, 2000 million enterprises of Microsoft SQL Server
Industry Edition and Windows 2000 Datacenter Server show its
Powerful scalability brings new challenges to traditional and expensive enterprise system suppliers. In May 2001, according to
Gartner, a well-known market research company, said that in the Windows NT database software market, the world's largest software Manufacturing Company
Operator ?? Microsoft has already exceeded Oracle, taking the lead. In the database market with a total value of $8.8 billion
In September 2001, Oracle launched its new Oracle software ?? Oracle9i and
Fast, think simple, think smart started the promotion of Oracle9i, leading the database market
Goat ?? Oracle began its efforts to defend its dominant position. So far, the database market has started a new round of competition
The battle of deer. Both Oracle and Microsoft are the world's top companies.
Microsoft SQL Server software is also developed by world-class development teams. Both companies claim that their software is the most
1. Brief Review
Oracle was founded in 1977 and its original intention was to build a database management system. Today, Oracle has
It has developed many excellent applications and service programs, far surpassing its original intention. In the fiscal revenue of 2000, only relationship
Oracle received more than $1 billion in revenue when the database management system license was sold.
More than 41000 employees in the world have become the second largest software company in the world.
Microsoft has never been familiar with it. Its development process can be summarized as "starting with a desktop operating system, and then stepping
The military server software is now making every effort to develop Internet software ". It entered the database field in 1987. Today, its products
The market share of Microsoft SQL Server is second only to Oracle, ranking second in the world. In the fiscal year of 2000
Microsoft earned more than $2.2 billion in revenue and more than 32000 employees, leading the world's software industry
2. Introduction to Oracle 8i and Microsoft SQL Sever2000
When talking about databases, the first company that comes to mind is generally Oracle. Founded in 1977, the company was initially
A company that specializes in database development. Oracle has been in the leading position in the database field. First, the relational database
Go to the desktop computer. Then, the next version of Oracle, Version 5, takes the lead in introducing distributed databases, customers/
Server structure and other new concepts. Oracle version 6 is the first line lock mode and supports symmetric multi-processing computers ......
Oracle8 mainly added the object technology to become a relational-object database system, and Oracle8i added the internet function. Contents
Previously, ORACLE products covered dozens of models, including large, medium, and minicomputers. Oracle databases have become the world's most widely used
As a general database system, Oracle has complete database functions, including storing a large amount of data
Define and operate concurrency control, security control, integrity control, fault recovery and advanced language interfaces. Oracle or
A distributed database system supports various distributed functions, especially Internet processing. As an application development
Environment, Oracle provides a set of user-friendly and functional database development tools, allowing users to have a good application
Development environment. Oracle uses the PL/SQL language to provide open, executable, and scalable operations.
In particular, Oracle 8i and later versions support object-oriented functions, such as support classes, methods, and attributes, so that Oracle
Microsoft SQL Server and Sybase SQL Server. In 1988, Sybase and Microsoft
SQL Server on OS/2 systems jointly developed by Asbton-Tate has been released. Later, Asbton-Tate pushed
Developed SQL Server, and Microsoft and Sybase signed a joint development agreement. By March 1992
To Port SQL Server to the Windows NT platform. Then, Microsoft and Sybase cancel the contract.
Develop your own SQL Server. Microsoft is committed to developing SQL Server on the Windows NT platform.
Sybase is dedicated to developing UNIX platforms. In 1996, Microsoft launched SQL Server 6.5.
SQL Server 1998 was launched in 7.0 and SQL Server August 2000 was launched in 2000, including the Enterprise Edition and standard
Microsoft SQL Sever2000 is a typical relational database management system with a client/server architecture.
It uses the Transact-SQL statement to send requests and responses between the server and the client. Microsoft SQL Sever
It features reliability, scalability, manageability, and availability, providing users with a complete database solution.
The server environment of Microsoft SQL Sever2000 can be Windows 2000, Windows NT, or Windows 9.
The client environment can be Windows 2000, Windows NT, Windows 9x, Windows 3.x, MS-DOS
Third-party platforms and Internet browsers. In addition, Microsoft SQL Sever2000 can work well with Microsoft
3. Product Features Comparison
(1) openness of the database operating platform
Oracle can run on all major platforms (including Windows) and fully supports all industrial labels
Therefore, customers can use many third-party applications, tools, gateways, and management utilities. Oracle
Policy, which allows customers to select a solution that best suits their specific needs. SQL Server is only available in Windows
The objective of Microsoft's proprietary policy is to lock the customer to a Windows environment.
The double-edged sword is conducive to the development of SQL Server and its market share. Because SQL Server is closely bound
Therefore, with the improvement of the reliability, openness and performance of the Windows operating system
(2) performance/price ratio
When people choose database products, of course, they must first consider the performance of database products, and also care about how much it will cost.
Able to establish and run a set of Oracle or SQL Server database systems. The money not only includes the fee for the initial purchase of software and hardware
It also covers the maintenance and training costs. Both companies claim that their performance is better than the price. In fact, on the Oracle side
Microsoft focuses more on product reliability and practicality, while Microsoft focuses more on product prices. Because the operating system
The reason is that the reliability of SQL Server is poor, while the initial cost of Oracle is relatively high, especially
When considering the tool software, Oracle is more expensive than SQL Server's free tool software. So
When considering the software to use, you should consider it based on your business needs and infrastructure.
(3) tool software
Makes the database easy to install, use, and manage ?? The combination is called "simple operation "?? Is a cost reduction
Key factors. Microsoft products have an easy-to-use reputation, and SQL Server has benefited in many aspects.
It is easy to use. SQL Server Enterprise Manager is an SQL Server
An integral part of the software provides you with an integrated management console to centrally manage multiple servers. Oracle
By its own enterprise manager, its performance has improved with the version improvement, and some aspects have even surpassed the SQL Server Enterprise
Industry Manager, but it is difficult to install, some of the better components need to be purchased separately. SQL Server and Windows operating system
Seamless integration, Microsoft always tries its best to bundle all software functions, unless you need other
Useful operation software package, otherwise the function is sufficient. Oracle handed over the tool software to a third-party software vendor.
High cost, especially when other people's software is provided free of charge, this problem becomes more prominent.
(4) database performance
Which database is faster? This is actually a difficult question to answer, because there are many uncertainties, including the processing type.
Data distribution and hardware infrastructure. Microsoft announced SQL Server February 2002 Bata2 in 2000.
The windows 227079 operating system has a maximum running speed of transactions per minute. Oracle challenges
Microsoft withdrew the test results and provided higher test results in March, almost double the previous one.
. This test is useful in many ways, but does not explain the operational performance of each user's application. Experience tables
Oracle Database is superior to SQL Server in terms of long running of a large number of transactions. However, in terms of cluster technology, SQL
4. Outlook on Oracle and SQL Server
Oracle9i has been released, which enhances the new features of e-commerce and Internet application support.
Provides an online transaction processing (OLTP) environment for large data volumes, query-intensive data warehouses, and demanding Internet applications.
YuKon, the next generation of SQL Server 2000, is expected to be launched this year. The main enhancement feature of YuKon is cluster
Each server processes data, manages memory, locks, and transactions on its own, while maintaining
Its internal contact prevents a machine in the cluster from working and does not affect the work of the entire system.
In short, in order to take the lead in the competition, the two companies will continuously develop database management systems with better functions and better functions.
System. Oracle has the advantage that many companies have invested in the development of related hardware products and software products, Microsoft
The company itself is a mountain. In the end, the company will win in the fierce competition. Let's wait and see, no matter who wins