The new major version of Mimer SQL is the result of more than three years development with focus on performance and scalability. The result is improved performance in the database kernel, in the SQL compiler and the optimizer, performance in the integration with the host operating system and performance in the client communication, just to mention a few.
A minor, but still very visible, change on the Windows platform is the new installer. The installation procedure has been streamlined and can now be done in just a few steps and it takes seamlessly care of an upgrade situation and un-installs the previous version automatically.
In May 2019 Unicode version 12.1 was announced and this new standard has been implemented in Mimer SQL 11 with the result that Mimer SQL has support for 150 different language collations, as well as support for all 137.929 characters.
We are also proud to announce that with the release of Mimer SQL 11 we support all of SQL-2016 core SQL features as well as 137 of the extended features.
Mimer SQL 11 database kernel
All internal formats have changed for the first time in 30 years and everything is now 64-bit in order to leverage the new and powerful processors and computers that exist and will emerge in the future. 64-bit means virtually unlimited storage and the only constraints and limits to storage are now the underlying file system and operating system.
The result of this work is that records can now be of variable length and all datatypes are implemented in formats native to the platform we are running on. The larger page size allows Mimer SQL 11 to better use improvements in modern disk technology, and data is stored in a more compact and more efficient manner than ever before. In addition, the main memory cache also has unlimited size which allows Mimer SQL to use large main memory efficiently, typically found on server systems.
The upshot is an increase in performance which is a prerequisite for scalability, expandability, and is a foundation for taking Mimer SQL to the next level.
Mimer SQL 11 Compiler
The new compiler has full support of the SQL core features from the ANSI/ISO SQL-2016 standard. In addition to this Mimer SQL has support for new datatypes, such as the Universally Unique Identifiers (UUID) and these can be generated automatically in the server or supplied by the application. The new compiler also has extended domain support as well as support for FULL OUTER JOIN, DISTINCT and UNIQUE predicates.
The WITH clause allows recursive traversal of data, allowing hierarchical data to be easily queried by the system.
All platforms now support IEEE float with improved precision for conversions using these types.
Mimer SQL 11 Client access
In Mimer 11 we have improved our range of client access possibilities with a newly written native API, called Mimer API. This gives the programmer much improved handling of database access with all modern features without the need for a driver manager and the overhead and extra administration that comes with that.
Mimer SQL 11 still has excellent support for ODBC, JDBC, and ADO.net and with this new native API Mimer SQL 11 have added yet another native connection method to an already proven and trusted offering.
Mimer SQL 11 SQL Monitor
The new SQL Monitor allows the user to see which statements are running, which resources are used and which users are currently putting a load on the system. All this data can be accessed both via a graphical user interface (GUI) as well as from the command line and allows a DBA to better monitor, analyze, and understand production systems.
Mimer SQL Module Language
SQL module language is in a way similar to embedded SQL but instead of interleaving code with SQL, the SQL module language gives the programmer a way to separate procedural code from SQL.
In Mimer SQL 11 we have support for SQL module language for C, COBOL, FORTRAN and Pascal.