Sybase Product Overview

1. The composition of Sybase software

Sybase software can be divided into three parts:

One is to conduct data management and maintenance of the online relational database management system Sybase SQL Server;

The second is to support the establishment of database application system and the development of a group of front-end tools software Sybase SQL tools;

The third is the interface software Open Client/open Server which can connect the application software of other vendors and any type of data in heterogeneous environment.

SQL Server is a programmable database management system (DBMS), which is the core software of the entire Sybase product, and plays the role of data management, buffer zone management and transaction management.

2. Basic features of SQL Server

SQL Server is a relational database management system that has the following basic characteristics:

The A.sql server can be placed on several disk devices, with at least 17MB of disk space required for initial installation.

The B.sql server supports a multiple-library structure, which means that there can be multiple databases in the Sybase system. Sybase can manage multiple databases.

C.sql server can compile and run T-SQL statements and return the results required by the client program. The T-SQL statement is an extension of standard SQL, which mainly adds process control statements in addition to data definition statements, data manipulation statements, and data control statements.

D.sql server can manage multiple users and has higher transaction throughput and lower transaction response times.

A customer's application can access data from one or several databases in the server.