July 18, 2008

Red Soft Corporation announces immediate availability of Red Database 2.1.0.

The Red Database 2.1.0 kernel is based on Firebird 2.1 and supports all of its new features and extensions:

  • Triggers for global database events
  • Global Temporary Tables
  • Recursive query support via Common Table Expressions
  • New virtualized system tables for database monitoring
  • and many other.


The Red Database 2.1.0 engine also contains the following new features above Firebird 2.1 baseline:

  • Multi-threading architecture - SuperClassic server
  • External stored procedures
  • Stored procedures and triggers debugger
  • Full-text search
  • Improved security subsystem, providing the full set of tools for:
  • authentication,
  • fine-grained authorization controls, at row and field level,
  • keeping detailed audit trail for users’ access to data,
  • system and data integrity checking,
  • analysis of security incidents.


New features in the security subsystem:

  • Integrated cryptographic module
  • Complete DDL operations access control
  • Complete DML operations access control
  • The roles assigned to a user have cumulative effect on his (her) access rights
  • The roles can be defined globally for the server
  • The support for access policies
  • Multi-factor authentication
  • Audit system with capability to save log in binary format and analyze it via SQL statements
  • Access controls for database service functions (backup, consistency validation, etc)
  • Security clean-up for deallocated memory
  • Integrity checking for server files and data protection facilities
  • Special tools for metadata and data integrity checking using digital signature


DBMS Red Database 2.1.0 is is currently being certified for compliance with FSTEC of Russia regulations for 5th class of data protection from unauthorized access and 4th level of control for the absence of undeclared capabilities.

More details about new features:


Multi-threaded SuperClassic architecture

This feature allows server to combine advantages of both SuperServer and Classic architectures. With this architecture each connection uses dedicated page cache and processes requests in a separate pooled thread. This architecture provides the highest level of query processing parallelism, similar to that of Classic Server, but uses less resources. This architecture is especially well suited for Windows x64 platform, where it allows to reach performance parameters similar to large Unix-based systems. High memory thread locality helps this multi-threaded architecture perform very well on NUMA machines with large number of the CPUs (including enterprise-class servers with 32 CPUs and more).

SuperClassic architecture is developed by Red Soft team and Firebird community.

 

External Stored Procedures and External User Defined Functions on Java

This This feature essentially expands capabilities of PSQL for data processing. User can define External Stored Procedures (ESP) and External User-Defined Functions (EUDF) in Java the same way as regular SP or UDF.
External Stored Procedures and External User Defined Functions have some advantages over UDF:

  • access to query execution context which allows using ESP and EUDF for triggers;
  • ESP could return data sets (as Java ResultSet), and can be used as data source.
  • ESP and EUDF can perform operations between different databases
  • Can use all the power of available Java libraries and frameworks.

Support for other programming languages (such as C#) will be added in the future.

 

Stored procedures and triggers debugger

It can be used for debugging PSQL stored procedures and triggers in the database. The user can see call stack and modify variable values while debugging. Debugger is implemented as the part of engine, and can be used to debug procedures as called from user applications.

 

Full-text search

This feature is based on Lucene engine and allows user to perform search in one or several fields and tables and rank the results. The search engine can execute morphological search, in the BLOB fields containing documents of the following types:

  • plain text
  • Microsoft Office (.doc, .xls, .ppt)
  • Adobe PDF
  • Rich text format (.rtf)
  • OpenOffice (.odt)
  • HTML

The following languages are supported: English, Standard, Russian, German, French, Czech, Portuguese, Chinese, Dutch, Greek and CJK.

Security

The implementation of security subsystem was guided by the following documents:

  • Russian regulations for data protection and cryptography
  • ISO/IEC 27000 series standards
  • Sarbanes-Oxley requirements
  • Various industry-specific security guidelines (e.g. Basel II for financial institutions)

 

For more details please see release notes document

© Red Soft Corporation, 2009