Mimer SQL overview

The Mimer SQL Products

Mimer SQL is a highly configurable product, with various components and features working as pieces of a puzzle.

Mimer SQL provides small footprint, scalable and robust relational database solutions that conform to international ISO SQL standards, solutions that are very well suited for high performance mission critical systems as well as for mobile and embedded applications. Mimer SQL offers effective adaptions to common database APIs like ODBC, JDBC, Embedded SQL, and ADO.NET, and in addition there are native ones optimized especially for the Mimer SQL database server.  Mimer SQL runs on all major platforms including Windows, Linux, macOS, Android and OpenVMS. In addition, various embedded platforms are supported.

Enterprise

The foundation and standard configuration is an enterprise product, based upon the Mimer SQL Experience database server. It includes all the database functionality that is the mark of Mimer SQL, and that customers around the world appreciate. 24×7 operation, online-backup, immediate restart, automatic reorganization, BLOBs/CLOBs/NCLOBs, distributed transactions (XA, MS DTC), Unicode, Collations, J2EE support — you name it, we got it. And you can get it too – download free test and development versions from our Download Central. Want to read more about the latest enterprise features? See the article describing some of the recent Mimer SQL Highlights.

By adding, replacing or removing parts of the enterprise compilation, other products are created that often focuses on specific target issues.

Automotive

The Automotive approach is a product area that focuses on the increasing use of computer technology within the car industry. Here, usually the Mimer SQL Realtime database server is used as a component. The real-time extension in the Mimer SQL solution makes it possible to model both hard real-time and non real-time data in one single database. Data can safely be shared between these two worlds without any need for data redundancy and homemade data storage solutions. The product is based on a research project at the Mälardalen Real-Time Research Centre with input from automotive, process automation and telecommunication industries. For further technical details, read the article Mimer SQL Realtime Edition.

Mobile

Another approach is solutions for use in Mobile phones or other communicative devices. Nowadays devices like this usually have system resources enough to easily run the standard Mimer SQL Experience server, which is very configurable and efficient when it comes to resource consumption. But, for some of these devices the platform provides a limited environment, which is the case where the Mimer SQL Mobile database server may be the ideal choice. With the Mimer SQL Mobile concept, using a runtime environment without a SQL compiler, a complete and full-featured RDBMS can be provided for this kind of system platforms. All functionality is there! You want multi-user functionality on your device, you want client/server access, you want multi-lingual support, you want all that powerful database functionality. Read some more about the good stuff in the article Mimer SQL Mobile Highlights.

Embedded

The final product line is called Embedded. Here we provide the possibility to ask for a unique embedded solution, tailor-made to fit your hardware/OS configuration and your applications. As we don’t know what you need, we haven’t done it yet, but put us to the test. It might be a slight mix of the approaches discussed here. Please do contact us for a discussion.

If you want a taste of what we have to offer, download a suitable Mimer SQL product from our Download Central and take it for a drive – Mimer SQL is always free for development and evaluation.

 

A guide to further reading

  • Interested in an overview of the general capabilities of Mimer SQL?
    See the compilation article named Mimer SQL in a nutshell.
  • Or, do you want to get more details of Mimer SQL in a comprehensive review?
    In that case, read the Mimer SQL Technical Description.
  • Mimer SQL provides an extensive multilingual support!
    Start reading about it on the Multi-Lingual page.
  • Interested in the advanced real-time capabilities?
    Take a look at the Mimer SQL Real-Time Edition – White Paper.
  • Want to know a bit more about distributed transactions in the Mimer SQL environment?
    Look at the Mimer SQL and Distributed Transactions article, for a sneak preview.
  • Storing large objects in Mimer SQL – what’s it all about LOBs?
    Take a glance at the Mimer SQL and LOBs article for more information.
  • LOAD/UNLOAD to insert data or migrate – looking for details?
    See Mimer SQL Load/Unload to get the low-down.
  • Want to know more about Unicode and Collations?
    Read the Character Data, Unicode and Collations article for the details
  • Mimer SQL is using Optimistic Concurrency Control. Want to know more about this?
    See the chapter named ” Transaction Handling and Database Security” in the Programmer’s Manual part of the Mimer SQL Documentation Set.
  • Want to know more about the products and platforms currently available?
    See our Documentation page, or go to the Download Central.
  • Do you have any questions? Do you want to get involved?
    Don’t hesitate in contact us if you have some feedback for us or if you want to be part of the Mimer SQL evolution.