Shulou(Shulou.com)06/02 Report--

This article mainly shows you "what is sybase database", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "what is a sybase database" this article.

Sybase is a database based on client / server architecture. It is an open, high-performance and programmable database, which can use event-driven triggers, multi-thread and so on to improve performance.

The operating environment of this tutorial: windows7 system, Dell G3 computer.

Sybase is a database based on client / server architecture.

The general relational database is based on the master / slave model. In the master / slave structure, all applications run on one machine. Users simply issue commands through the terminal or simply view the results of the application.

In the client / server architecture, applications are run on multiple machines. One machine is the client of another system, or the server of some other machine. These machines are connected through a local area network or a wide area network.

The benefits of the client / server model are:

It supports resource sharing and load balancing among multiple devices

An environment that allows for multiple hosts, making full use of the existing systems of the enterprise

Sybase is a really open database.

Due to the use of client / server structure, the application is run on multiple machines. Furthermore, applications running on the client do not have to be Sybase products. For general relational databases, precompilation is provided in order to enable applications written in other languages to access the database. The Sybase database not only provides precompilation, but also exposes the application program interface DB-LIB, which encourages third parties to write DB-LIB interfaces. Because the open client DB-LIB allows identical calls on different platforms, applications that access DB-LIB can be easily migrated from one platform to another.

Sybase is a high performance database.

The real attraction of Sybase is its high performance. It is reflected in the following aspects:

Programmable database

By providing stored procedures, a programmable database is created. Stored procedures allow users to write their own database subroutines. These subroutines are precompiled, so you don't have to compile, optimize, and generate query planning for each call, so the query is much faster.

Event-driven trigger

Trigger is a special stored procedure. Triggers enable you to start another stored procedure, ensuring the integrity of the database.

Multi-wire cable

Another innovation in the architecture of Sybase databases is multithreading. General databases rely on the operating system to manage the connection with the database. When multiple users are connected, the performance of the system will be greatly degraded. The Sybase database does not allow the operating system to manage the process, but manages the connection to the database as part of itself. In addition, Sybase's database engine also takes the place of the operating system to manage some hardware resources, such as port, memory and hard disk, bypassing the operating system and improving performance.

The Sybase database mainly consists of three parts:

(1) an online relational database management system Sybase SQL Server for database management and maintenance

Sybase SQL Server is a programmable database management system. It is the core software of the whole Sybase product. It plays the role of data management, cache management and transaction management.

(2) A set of front-end tools Sybase SQL Toolset that supports the establishment and development of database application systems.

ISQL is a SQL parser that interacts with SQL Server. ISQL receives the SQL language sent by the user, sends it to SQL Server, and displays the result on the user's standard output in a formal way.

DWB is a data workbench and a main part 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 simple way to add, update and retrieve the information in the database. All the functions of ISQL can be completed in DWB, and because DWB is based on windows and menus, it is easier to operate than ISQL, and it is a convenient and practical database management tool.

APT is not only one of the main products of Sybase customer software, but also the main environment for practical application development. The APT workbench is a toolset for building applications that can be used to create applications ranging from very simple to very complex. It is mainly used to develop Form-based applications. Its user interface is driven by windows and menus, and forms (Form), menus and processes are developed through a series of choices.

(3) the interface Sybase Open Client/Open Server that can connect the application software of other manufacturers in the heterogeneous environment with any type of data.

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.

The above is all the contents of the article "what database is sybase?" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.