SYBASE database -- Introduction (2)

Sybase Database Composition

(1) An online Relational Database Management System sybasesqlserver for database management and maintenance;

Sybasesqlserver is a programmable database management system. It is the core software of the entire Sybase product and plays the role of data management, high-speed buffer management, and transaction management.

(2) A set of front-end tools sybasesqltoolset supporting the establishment and development of database application systems;

ISQL is an SQL syntax analyzer that interacts with sqlserver. ISQL receives the SQL language from the user, sends it to sqlserver, and displays the results in a formal manner on the user's standard output.

DWB is a data workbench and a major component of sybasesqltoolset. It enables users to set and manage databases on sqlserver, it also provides users with a simple method to add, update, and retrieve database information. All functions of iSQL can be completed in DWB. Since DWB is based on Windows and menus, it is easier to operate than iSQL and is a convenient and practical database management tool.

APT is one of the main products of Sybase customer software and is also the main environment for practical application development. The APT workbench is a tool set used to create applications. It can create very simple to very complex applications. It is mainly used to develop applications based on forms. The user interface is driven by a window and menu, and forms, menus, and processing are developed through a series of selections.

(3) The sybaseopenclient/openserver interface that connects application software from other vendors in heterogeneous environments with any types of data.

Through the DB-LIB library of openclient, applications can access sqlserver. With the SERVER-LIB of openserver, applications can access other database management systems.