Super Pk:sybase and Oracle's 12 performance competition

Sybase Company was founded in 1986, based on the open system platform to develop a client/server architecture of the database system software products. Sybase was a great success when it effectively learned the advanced technologies and concepts in other RDBMS design processes to meet the high performance requirements of online transaction processing (OLTP) applications, and to enhance the networking of open interconnection to heterogeneous data sources. Sybase, in particular, has become the fastest-growing market for the world's databases, especially as it effectively expands its market operations. However, due to the technical problems of the product itself, unable to provide support for large multiprocessor systems, Sybase's market share has plummeted and there have been successive losses. The 1997 loss was $55.4 million trillion, with 81.2 million dollars lost in the first quarter of 1998. At the beginning of 1999, Sybase laid off another 600 people, nearly 10% of all its staff. There was no loss in the first quarter of 2001, but it was feared that the license income had fallen by 10.7% per cent over the same period in 2000. As early as 1997, the renowned market analyst Gartner Group has removed Sybase from the list of "Big 5" DBMS market leaders.

According to Gartner/dataquest's recently released 2001 database market share Statistics report, Oracle is still in the mainstream operating system UNIX and Linux, Windows nt/2000/in the Gartner/dataquest report The relational database on XP occupies an absolute lead in the market, accounting for 63% on Unix and 49.9% of Windows+unix. In the relational database market (including As/400,mainframe), Oracle is still in the leading position of 39.8%.

According to the latest Factpoint survey, Oracle database is still the preferred database for Fortune 100 companies, of which 51% of Fortune 100 companies use Oracle database as a platform for building traditional applications and e-business for the enterprise.

Findings of the Factpoint Group report:

1, Oracle is still the preferred database platform for Fortune 100 companies, Oracle's database market share far more than other competitors, its market share is 2.5 times times the second.

2, 51% of the Fortune 100 companies to use Oracle database to build the enterprise's traditional applications and E-commerce application platform.

3, Fortune 100 selected mainstream application software most of the choice of Oracle database platform, including: 100% of Oracle Application products, 76% of SAP; 72% of PeopleSoft; 81% of Siebel; Oracle database platform is selected for 73% of I2.

4. Oracle database products penetrate into various business areas of Furtune100 company, including 75% of financial applications, 72% of human resource applications, 68% CRM applications and 72% supply chain management applications using Oracle database platform.

5, Oracle database is Furtune100 by customers as the best technology and the best integration with mainstream application software database platform.

The Factpoint group survey involved 400 meetings with the IT managers of Fortune100, whose findings reflect the status of database deployment and use in today's enterprise, based on the use of Fortune 100 's database products, according to Factpoint Group's survey Oracle database Jiyaqunxiong, still maintains the enterprise database market share leader position.

A comparison between ORACLE and Sybase's advanced technology

Compared with Sybase database, Oracle database has great advantages in architecture, parallel support, integrity control and so on.

1, the system structure comparison

Oracle uses multiple threads and multiple process architecture to support distributed database operation, multiple thread processing, parallel processing and online transaction processing directly in kernel. Oracle Enterprise Servers are structured to support centralized multiuser environments, client/server, distributed processing, and Internet computing structures, and technically, transparent network environments, mixed network architectures, and distributed data management for application and system developers

Sybase employs a single process, multiple-threaded architecture, with the core of SQL Server (now renamed Adaptive Server Enterprise, differentiated from Microsoft SQL Server), based on the Client/server architecture, The architecture of the replication server (Replication server) and Multi-function Universal Gateway (Omni SQL Gateway, now called Enterprise CONNECT) and other components, thus forming a software product family.

2. Multi-clue multi-process and single process multi-clue comparison

Both Oracle and Sybase use multiple cues. Multi-clue mode can be used to manage a large number of user processes with less clues, and the thread process is dynamically adjustable, and the thread process automatically increases as the number of users increases, and the thread process automatically decreases as the number of users decreases. Multi-clue structure greatly reduces the utilization of system resources by Oracle and Sybase.

For Oracle architectures, in a centralized multiuser environment, each user consumes a single server process, and in client/server and Internet ways, multiple users can share processes and execute user requests in multiple threads. In addition, for special-level users, you can occupy a single server process and achieve the optimal level of user requests. Oracle's server processes are used to process database requests simultaneously, from request queues, to parsing, permission checks, and a series of internal operations, and to coordinate Oracle's other background processes to work together to complete the processing of the application and return the results of the operation to the answer queue. Oracle Multi-server process architecture can realize parallel processing of database transactions and improve the response speed of concurrent transaction processing. and the multi server structure has the very flexible expansion, when the hardware platform processing ability increases, the server process number also can increase, the database performance also increases. Multi-server structure avoids the server process bottleneck caused by single server structure, and avoids the phenomenon of single server process deadlock.

Sybase adopts single process and multiple threads, and user requests are all scheduled and managed by a process. In single server and adopting single Client/server mode, the management of database is simpler, the memory resource occupies less, and the utilization ratio of system resources is higher than that of multi process in the case of fewer concurrent users. But at the same time, when the number of concurrent users reaches a certain number, can cause the system processing performance to drop greatly, and the server process bottleneck and deadlock and so on, at the same time the system's extensible scope is very narrow.