November 8, 2024. "RED SOFT announces the release of RED Database 5.0. The new version improves database administration and optimization capabilities, adds features for application developers, and improves system security.
Among the new features of RED Database 5.0 are: tablespaces, JSON support, SQL and PSQL code profiler, parallel backup, recovery and garbage collection, partial index support, improved query optimizer, compiled query cache, improved record compression algorithm, new functions and packages for working with BLOB, support for synchronous asynchronous replication mode.
New opportunities for application developers
JSON format support
Using JSON allows you to organize data exchange with external services, store loosely structured objects with a large number of attributes without the need to create separate structures for them in the form of linked tables with many fields. You can learn more about working with JSON in RED Database from the video on the RDBMS RED Database channel.
Support for international time zones
Allows you to solve the challenges of handling events in different time zones and to develop geographically distributed systems. Developers can now use session time zone, time zone format and data types to support time zones. Time zones are updated without updating the server, avoiding unnecessary time wasting.
Support for bulk data insertion
Batch insert operations have become much faster, and the time to fill tables with large data has been reduced. It is now possible to perform batch operations with prepared statements containing several parameter sets. The option is already supported in the Jaybird driver.
Efficient work with BLOBs
Allows you to solve problems related to processing events in different time zones, as well as to develop geographically distributed systems. Developers can now use session time zone, time zone format and data types to support time zones. Time zones are updated without updating the server, avoiding unnecessary time wasting.
Support for bulk data insertion
Batch insert operations have become much faster, and the time to fill tables with large data has been reduced. It is now possible to perform batch operations with prepared statements containing several parameter sets. The option is already supported in the Jaybird driver.
Efficient work with BLOB
The RDB$BLOB_UTIL system package allows you to work efficiently with BLOB fields on the server, save computing resources and prevent database file enlargement. Now you can work with BLOB data inside PSQL code as flexibly as in a client application.
Database Administration
Job Scheduler
The built-in scheduler allows you to start tasks on a schedule and notify you about their start and completion, as well as about errors encountered during execution. A task can be a block of PSQL operators or operating system commands. Increases the isolation of the OS and DBMS administrators' functions by executing the scheduled procedures without requiring access to the environment where the DBMS is installed.
Tablespaces
Allows you to separate certain database objects, such as indexes and tables, for storage, expand the current database size limits, and provides the ability to control and optimize the database's use of available space, reducing the cost of disk subsystem upgrades.
Connection and query timeouts
Connection timeouts allow you to automatically close user connections that occupy server memory and block database objects, preventing other connections from executing queries, after a certain period of inactivity. They can be used by both database administrators and application developers as a substitute for independent control over connection lifetime.
Query timeouts are intended for automatic termination of SQL statement execution if it is executed longer than the specified time. They allow to eliminate excessive consumption of server and disk subsystem resources.
Synchronous-asynchronous replication
A new replication mode that combines two approaches. Replication starts in asynchronous mode, allowing the replica to retrieve all missing data from the master database. Once both bases are synchronized, the process switches to synchronous mode. Synchronous-asynchronous replication provides data protection, ensuring that the replica does not lose information even in case of a temporary disconnection from the master database.
Database performance optimization
SQL and PSQL Profiler
Allows you to measure the performance of code sections, identify the longest of them, optimize the resources used and improve database performance. The package collects statistics on the number of executed code sections, their execution time with nanosecond accuracy, gives access to the statistics of explicit and implicit SQL-cursors and detailed information about plan nodes.
Cache of compiled queries
The server now supports automatic caching of compiled queries, including stored procedures, functions and triggers, thus avoiding unnecessary resource consumption when recompiling, optimizing and validating queries. This functionality can be useful in web applications where a single query can be executed multiple times for different users.
New disk record compression algorithm
Increased compression ratio for long, incomplete strings. Repeated bytes are now stored more compactly, reducing database size.
The problem of long transactions has been solved
The new concept of database state snapshots allows for intermediate garbage collection, removing those in the version chain that no one needs. This significantly reduces the length of the version chain, especially when there are long active transactions, which in turn prevents database fragmentation and improves overall system performance.
Partial indexes
More compact indexes for a subset of table rows allow indexing only the necessary and relevant part of data and provide faster data retrieval by reducing the depth of the index tree. When creating an index, an optional WHERE clause is specified that specifies a search condition that limits the subset of table records to be indexed.
Security
RED Database 5.0 complies with the new Information Security Requirements for Database Management Systems approved by Order of the Federal Service for Technical and Export Control of Russia No. 64 dated April 14, 2023, according to protection class 4 and confidence level 4. Certificate of Conformity of FSTEC of Russia №2729 is extended until October 8, 2028 for versions 3.0 and 5.0.
Users have access to additional options for organizing secure work:
Extended authentication methods;
Security policies that allow controlling the parameters of the authentication factors used;
Fault Tolerant Cluster.
DBMS RED Database provides a high level of security when working with data and can be used in:
Significant objects of critical information infrastructure (1 category of significance);
State information systems (security class 1);
Automated control systems of production and technological processes (1 class of security);
Personal data information systems (security level 1);
Class II public information systems.
The full list of changes is available on the DBMS RED Database website.
Roman Simakov, DBMS RED Database Architect and Director of the System Product Development Department of RED SOFT:
"The new major version of RED Database adds the tools requested by database administrators: tablespaces and task scheduler will allow to manage server resources more efficiently; PSQL-profiler and compiled query cache have been developed to optimize database operation; and JSON support will allow application developers to create information systems using our DBMS even more conveniently. The improvements made in this release open the way to further development of our DBMS, and we are already actively working on version 6."
Rustam Rustamov, Deputy General Director of RED SOFT:
"DBMS RED Database is one of our key products. The new version of RED Database is an important development stage and the result of well-coordinated work of a professional team. We have taken into account the experience and wishes of our partners and customers and offer many new features that will allow us to develop partner products even more efficiently and build new secure information systems based on fully Russian products. RED Database has earned the trust of our customers and is widely used in such spheres as medicine, government agencies, transportation, which confirms its functionality, security, reliability and performance. RED Database is built on the open source Firebird project, and our developers are its contributors. We are actively involved in the development of the Firebird community in Russia and have already held two Firebird Conf conferences, with plans to hold a third in 2025."
Reference:
Red Database is a modern industrial certified Russian open source database management system by RED SOFT. RED Database complies with internationally accepted industrial standards of quality, reliability and security.
RED SOFT is a Russian software developer. The company's portfolio includes an ecosystem of solutions for organization and management of IT infrastructure, as well as application products that provide the basis for automation of government information systems. The company's expertise is based on more than 15 years of experience in developing solutions for major customers in the public and commercial sectors. RED SOFT products are included in the Register of Russian Software of the Ministry of Finance of Russia and are certified by FSTEC of Russia. RED SOFT is among the licensees of FSTEC of Russia and FSB of Russia.
Company's website: https://red-soft.ru/