Embarcadero InterBase 2020

Posted By: scutter
Embarcadero InterBase 2020

Embarcadero InterBase 2020 | 255.3 mb

Embarcadero (a division of Idera, Inc.), a provider of cross-platform application developer productivity tools, announced InterBase 2020, the latest release of its flagship database management system including support for tablespaces.

InterBase 2020 Release Notes - Date: November 15, 2019

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.

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.

The InterBase 2020 release adds a number of new features, including tablespaces support for InterBase, allowing for better performance on servers with multiple data storage options.

Database Tablespaces

Tablespaces support is the top new feature added in the InterBase 2020 release.

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.

New OS Platform Support

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.

Enhanced Performance Monitoring

Performance Monitoring of index usage in InterBase 2020 gives you current statistics on what indexes are in use in the database, and how active they are for various queries (optimization, order by clause etc.). This expands on what we already provide in terms of monitoring statistics for various other entities like tables, stored procedures, triggers, attachments, transactions etc.

Data Dictionary DDL

Database tools can greatly benefit from a standard DDL syntax they can use to apply various descriptions to document the user's database schema. New ALTER DESCRIPTION syntax allows you to describe any database entity (for e.g. table, index, stored procedure, generator etc.) in a standard (and independent) way without needing to embed the description as part of the entity definition.

SQL Optimizations

Transform inequality operators and not operators to their opposite representation for index based retrieval. Inequality operators, such as <, <=, !=, <>, >, >= can be transformed and optimized. For e.g. Conditions of the form "NOT A>0" can now get transformed to "A <= 0" by the SQL optimizer to use index retrieval for better performance.

Security Enhancements

InterBase 2020 uses OpenSSL 1.0.2s across all platforms to avail recent vulnerability fixes from OpenSSL project.

IBConsole Improvements

InterBase 2020 comes with an enhanced IBConsole GUI for Windows. It supports the latest feature set including Tablespaces and Data Dictionary modifications and includes enhanced support for InterBase’s patented Change Views functionality. InterBase 64-bit Edition now includes a 64-bit native IBConsole application, that will allow larger datasets to be retrieved in the query window.

Phased Delivery

InterBase 2020 embedded versions and InterBase Server Edition for Windows are immediately available. Server editions for Linux and macOS will follow shortly.

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.

Embarcadero Webinar: InterBase 2020

Embarcadero builds tools that solve productivity problems for application developers. The company's products allow users to design, build and run applications from a single code base across all platforms. Ninety of the Fortune 100 companies and a community of more than three million C++ and Delphi users worldwide rely on Embarcadero's award-winning products to deliver critical enterprise applications. Embarcadero is a division of Idera, Inc

Product: Embarcadero InterBase
Version: 2020 version *
Supported Architectures: 64-bit, 32-bit
Website Home Page : www.embarcadero.com
Language: english
System Requirements: PC **
Supported Operating Systems: **
Size: 255.3 mb

Keygen activates

InterBase 2020 Server
InterBase 2020 Server Edition is a cost effective, zero administration, and lightweight but powerful embeddable database for your business critical applications. As your organization grows, InterBase 2020 Server scales with you. InterBase 2020 Server allows hundreds of simultaneous users to connect to a single database. Every base InterBase Server Edition license includes support for up to 8 CPU cores and 1 user. You can add Additional CPU licenses (8 cores each) for up to a total of 32 cores and you can add Additional Simultaneous User Licenses for 1 to unlimited users. In addition to providing local RDBMS capabilities, the server edition also allows remote connections for increased flexibility. InterBase server provides AES data encryption and SSL communication for more security and access control. Perfect for Enterprises, ISVs, OEMs and VARs who need to embed a database into their applications.
InterBase 2020 ToGo Edition
InterBase 2020 ToGo Edition is a full-featured, multi-device embeddable database for Windows, Linux and macOS that runs in a stand-alone environment but allows deployment of applications which directly utilize the InterBase engine DLLs. With no separate database server process running, the database engine executes in the application process space providing an extremely small footprint. Together with other key features such as high security, zero administration and simple installation, InterBase 2020 ToGo is an incredible solution for VARs, OEMs and ISVs.

InterBase Developer, Desktop and Server Edition (only Windows)

Supported operating systems:
Windows 10
Windows 8, 8.1
Windows 7
Windows Vista
Windows Server 2019
Windows Server 2016
Windows Server 2012, 2012 R2
Windows Server 2008, 2008 R2

Supported processor architecture: Intel x86 or Intel x86-64

Hard disk space: Installation files: ~250MB (~350MB for Japanese version).
Space needed for install:
~46 MB for Client Only installation.
~117 MB for Server and Client installation

InterBase ToGo Edition (only Windows)

Supported operating systems:
Windows 10
Windows 8, 8.1
Windows 7
Windows Vista
Windows Server 2016
Windows Server 2012, 2012 R2
Windows Server 2008, 2008 R2

Please visit my blog

Added by 3% of the overall size of the archive of information for the restoration

No mirrors please

Embarcadero InterBase 2020