Sybase is a database based on client/server architecture. It is an open, high-performance, programmable database that can use event-driven triggers, multi-threading, etc. to improve performance.
The operating environment of this tutorial: Windows 7 system, Dell G3 computer.
Sybase is a database based on client/server architecture.
General relational databases are based on the master/slave model. In a master/slave architecture, all applications run on one machine. Users just issue commands through the terminal or simply view the results of application execution.
In the client/server structure, the application is divided into multiple machines to run. A machine is a client of another system, or a server of some other machines. These machines are connected through a local area network or a wide area network.
The benefits of the client/server model are:
It supports shared resources and load balancing across multiple devices
Allows the environment to accommodate multiple hosts, making full use of various existing systems in the enterprise
Sybase is a truly open database
Due to the adoption With the client/server structure, the application is divided into multiple machines to run. Furthermore, the application running on the client does not have to be a Sybase product. For general relational databases, precompilation is provided in order to allow applications written in other languages to access the database. Sybase database not only simply provides pre-compilation, but also exposes the application program interface DB-LIB, encouraging third parties to write DB-LIB interfaces. Since the open client DB-LIB allows the use of exactly the same calls on different platforms, applications that access DB-LIB can be easily ported from one platform to another.
Sybase is a high-performance database
The real attraction of Sybase is its high performance. Reflected in the following aspects:
Programmable database
A programmable database is created by providing stored procedures. Stored procedures allow users to write their own database subroutines. These subroutines are precompiled, so they don't have to be compiled, optimized, and query plans generated for each call, resulting in much faster queries.
Event-driven trigger
A trigger is a special stored procedure. A trigger can start another stored procedure to ensure the integrity of the database.
Multi-threading
Another innovation in the architecture of the Sybase database is multi-threading. General databases rely on the operating system to manage connections to the database. When multiple users are connected, the performance of the system will drop significantly. The Sybase database does not let the operating system manage the process, but manages the connection to the database as part of itself. In addition, Sybase's database engine also replaces the operating system to manage some hardware resources, such as ports, memory, and hard disks, bypassing the operating system and improving performance.
The Sybase database is mainly composed of three parts:
(1) Sybase SQL, an online relational database management system for database management and maintenance Server;
Sybase SQL Server is a programmable database management system. It is the core software of the entire Sybase product and plays the role of data management, cache management, and transaction management.
(2) Sybase SQL Toolset, a set of front-end tools that support the establishment and development of database application systems;
ISQL is a SQL syntax analyzer that interacts with SQL Server. ISQL receives the SQL language issued by the user, sends it to SQL Server, and displays the results in a formal manner on the user's standard output.
DWB is the data workbench, which is a main component of Sybase SQL Toolset. Its function is to enable users to set up and manage the database on SQL Server, and to provide users with a way to add information to the database. , update, retrieve, and more. All the functions of ISQL can be completed in DWB, and because DWB is based on windows and menus, the operation is simpler than that of ISQL, and it is a convenient and practical database management tool.
APT is one of the main products of the Sybase client software part and is also the main environment for practical application development. APT Workbench is a tool set for building applications. It can create applications from very simple to very complex. It is mainly used to develop form-based applications. Its user interface adopts window and menu driven methods, and completes the development of forms, menus and processes through a series of selections.
(3) Sybase Open Client/Open Server is an interface that can connect application software of other manufacturers and any type of data in a heterogeneous environment.
Through Open Client's DB-LIB library, applications can access SQL Server. Through Open Server's SERVER-LIB, applications can access other database management systems.
(Recommended tutorial:mysql video tutorial)
The above is the detailed content of What database is sybase?. For more information, please follow other related articles on the PHP Chinese website!