Embarcadero, a division of Idera, announced InterBase 2020, the latest release of its database management system including support for tablespaces. InterBase is a light, ultra-fast, embeddable SQL database with commercial grade data security, disaster recovery and change synchronization.
The solution leverages multi-core CPUs and multi-CPU systems, along with a unique versioning approach and advanced disk I/O caching to retrieve and update data quickly. With a small footprint and fast install, it is ideal for use in mission-critical contexts such as patient management, railways, medical labs, multi-national POS, CRM, and emergency response systems.
In previous versions of InterBase, all files for a SQL database had to be mapped to the same physical storage, either a fast but small SSD or a large but slow HDD or SAN. With InterBase 2020, support for tablespaces maps individual tables and indexes to specific files and storage for improved performance and more balanced, optimized use of hardware technologies. These include SSDs for key tables and indexes and HDDs for larger but less commonly used tables.
Tablespaces allow for better performance and more balanced and optimized use of the hardware. Technically this feature allow a database object definition to specify a storage location in a particular logical file collection. This is especially beneficial for disk technologies, allowing you to better mix the use of fast SSDs and large HDDs. This is a key difference, since prior to InterBase 2020, all of the files for a database had to be mapped to the same storage.
A database administrator can leverage tablespace characteristics to optimize runtime database performance. Selective tablespaces including active data can be backed up and restored as needed to minimize backup/restore time.
InterBase 2020 expands the OS platform support. Embedded InterBase (IBLite and IBToGo) is now available for Android 64-bit and macOS 64-bit. This allows RAD Studio developers to build InterBase enabled 64-bit Delphi applications and target both the Google Play Store and macOS App Store.
The full list of supported InterBase 2020 IBLite and IBToGo platforms include Windows, macOS, Linux, Android and iOS. Supported platforms for InterBase 2020 Server Edition include Windows with macOS and Linux support currently in beta and coming later.
InterBase 2020 comes in two versions: InterBase Server and Embedded InterBase (IBLite and IBToGo editions), the latter of which is now available for Android 64-bit and macOS 64-bit. IBLite and IBToGo can be used without InterBase Server as a stand-alone embedded database across multiple platforms, reducing costs and improving application speed and user experience with mobile data encryption support. Change Views provides the infrastructure for ensuring offline data is kept current with minimal effort.
InterBase Server powers Embarcadero’s RAD Server REST-service engine and the Embedded version is an integral part of RAD Studio which offers single-source applications for mobile and desktop operating systems.
No comments:
Post a Comment