Comparison of common database systems

The reason why the two databases are supposed to be MS SQL Server is to purchase the Sybase SQL Server that Sybase launched in 1987, also known as University edition Ingres's third generation product, so they are essentially the same.

Sybase Company was founded in 1984, belongs to an Up-and-comer. He launched a database that supports the enterprise-wide "Customer/server Architecture". Sybase takes "client/server database Architecture" as an important goal in developing products. They have learned from Ingres's development experience to meet the requirements of online transaction processing applications, with the introduction of Sybase SQL Server in 1987, called University edition Ingres's third-generation product.

Sybase System 11.5 is its latest product to support a variety of database application requirements within the enterprise, such as data warehousing, online transaction processing, decision support systems, and platform applications.

Database server

Sybase is a powerful relational database management system (RDBMS) oriented to online transaction processing with high performance and reliability. Sybase database, multi-Library, multiple devices, multi-user, multiple clues and other features greatly enriched and enhanced the database function. Because Sybase database system is such a complex, multi-function system, so the management of Sybase database system becomes very important, the quality of management and database system is closely related to the performance.

The server side of Sybase System 11.5 and the new product are adaptive server. It integrates the original server family, such as SQL Server, SQL Anywhere, Sybase IQ, Sybase MPP, and so on. It has the ability to deal with many kinds of data sources, including the legacy of non relational data and distributed transactions, provides an optimized method of data storage and access, and provides a single programming model.

The new version of SQL Server is the architecture of SQL Server 7,sql server with more than one thread of process. and SQL Server has only one server process, all customers are connected to multiple of this process. However, the process has broken down into a number of concurrent clues, they share data buffers and CPU time, can timely capture the user process to send access to data requests, and then, according to a certain scheduling algorithm processing these requests, than the operating system directly to the scheduling of these requests more efficient.

Microsoft provides a database engine that can be applied from a mobile laptop running the Microsoft Windows 95/98 operating system to a gigabit symmetric multiprocessor cluster running the Enterprise edition of the Windows NT Server operating system. All of these systems guarantee the security and reliability required by mission-critical business systems.

SQL Server has a large volume of transactions, a fast response, and can maintain this high performance for hundreds of or more users.

SQL Server first implements data integrity control at the core layer, including declaring integrity when building tables and using trigger mechanisms to define the integrity associated with the application.

Support distributed queries and updates.

Development tools

Sybase provides users with a good development tool and development environment to support component creation and rapid application development.

(1) PowerBuilder

PowerBuilder is a visual client/server application development tool, its powerful function can help users develop complex applications quickly. Also, interfaces with other databases are provided.

(2) Power Designer

This is a tightly integrated computer-aided software Engineering (case) tool designed to perform analysis, design, maintenance, documentation, and database creation for complex database applications.

(3) Power J

This is a rapid development tool based on Java applications.

(4) Powre + +

is a set of RAD C + + client/server and Internet object-oriented development tools.