Firebird Database Management System

Firebird Features free of charge compared to other DBMS. It is a project developed by InterBase and maintained by a group of developers in Eastern Europe and Russia. Therefore, many Delphi developers use Firebird. Firebird's current version is 2.5, and 2.1 is also widely used. In China where piracy is rampant, it seems that there are not many applications. The best way to get help from Firebird is its official website:

Http://www.firebirdsql.org/

Firebird's graphic interface is the database workbench of upscene in Austria. Other products of the company include the IB log Manager product family, a tool group for database record and replication.

 

Firebird has three server types ):

Classicserver (-C)

Superserver (-S)

Superclassic (-m): Firebird 2.5's new working mode increases performance in multiple threads.

The main difference lies in the management of cache, thread and process.

 

In 1 super server mode, there is only one page cache, which is shared by all clients. When two clients perform the same SQL query, the latter will benefit from the data in the cache. All clients are connected to the same fbserver process. See Fig 1.

 

 

Fig 1 super server

In the 2 classic server mode, each client has its fbserver process and cache. This mode no longer has the advantages of super sever, but its advantage is high stability, because each process can be relatively independent and independent from each other. The disadvantage is that the disk needs to carry more I/O operations, and the performance bottleneck is obvious in the high parallel (high concurrency) environment. The operating system must also manage a large number of fbserver processes.

Fig 2. Classic Server

 

The 3 super Classic Mode also has the advantages of the above two working modes. In classic server, different processes are responsible for different processes. In super Classic mode, there is a different thread of process, which reduces the workload of the operating system and the I/O overhead.

 

Fig 3. Super classic