Welcome Guest | My Membership | Login

More MultiValue Database and Products Articles...

jEDI Development Kit Gets a Turbo Boost

jBASE International recently introduced a major enhancement to its jEDI Development Kit which radically improves the jQL performance for the entire jEDI suite. Recent benchmark results demonstrated performance levels very close to – and in some cases surpassing – native jBASE files.

Conference Schedule

Phoenix 2019 - April 8th-11th
More Info



Release Date: Sunday, November 1, 2009

The jEDI (jBASE External Device Interface) enables applications to achieve seamless integration with foreign databases without any changes to the jBASE MultiValue BASIC application code and logic. Data can be stored in an external database such as Microsoft SQL Server, Oracle or IBM's DB2. Other external databases are supported using an ODBC jEDI ensuring that jBASE can be integrated with any database that supports ODBC.

This means that any jBASE application can read and write to whichever database is required by the customer. A customer can select their preferred database vendor or environment to suit their needs whether this is low cost, high performance, local support or any other factor. In the future, and if the need arises, they can switch database vendor without altering the jBASE MultiValue application.

The jEDI separates the BASIC application from the data source and provides a consistent view of all I/O to the calling program and to the rest of the system. jBASE comes with drivers for its own file system. jEDI drivers relating to the relational databases are available as a jEDI Development Kit (jDK).

It would be reasonable to assume that native jBASE file I/O is faster than manipulating RDBMS tables, e.g. when a jBASE query (jQL) is executing on a large RDBMS data set the response times would be slower than a query against the native jBASE file. The reason being that the jDK was designed as a generic tool set to work on many different RDBMS. However improvements to the query architecture in jQL and the jDK have allowed the jEDI developer to intercept the jQL query and perform some or all of the work involved. In a nutshell, this means translating the jQL to SQL and returning a result set (typically a set of record IDs or a count depending on the jQL statement). It also means that the developer can enhance the jDK for the specific application concerned.

Recently a major South American Software House evaluated options for migrating their application from UniVerse to products that enabled their application to use a relational database. For the evaluation a section of the application was migrated to jBASE and other vendors' products. Initial results indicated that all of the products in the evaluation were slower when writing to a relational database. While each vendor was able to improve their performance, the jBASE jEDI delivered significantly faster performance. Final results demonstrated that jBASE was manipulating SQL faster than the other products and the improvement to the jBASE jEDI was so profound that the query response times were in many cases faster on the relational database than on native jBASE j4 files! The South American Software House is now a new jBASE International Partner.


# # #          # # #          # # #


About jBASE / Zumasys, Inc

In January 2015, Zumasys, a leading provider of cloud computing solutions for business-critical software applications and ERP systems, announced that it had completed the acquisition of the jBASE database from Temenos, based in Geneva Switzerland.

jBASE is a world class Database Management System comprising development tools, middleware and a multi-dimensional database. jBASE takes the best points of the relational database model and adds to it several significant benefits including ease of use, superb performance, small footprint and all the rich MultiValue features, making it ideally suited to all business uses from the Internet to OLAP to transactional applications. The architecture is uniquely designed to allow all and any application development tools and backend databases to form part of a jBASE solution.

jBASE has an impressive installed base spread across 70+ countries worldwide in almost every facet of daily life including Banks, Retailers, Healthcare, Government and General Commerce. Over 300,000 users and 8000 businesses around the world rely on jBASE for mission critical information management.

Zumasys helps companies of every size transition their infrastructure and applications to the cloud. With Zumasys cloud services, customers can easily access the latest software and hardware technologies over the Web, allowing them to focus on growing their core business instead of managing their IT infrastructures. Zumasys delivers personalized service, integrated disaster recovery and the confidence companies need to outsource the hosting of all their databases including SQL, Oracle and Pick MultiValue systems.

For more information, visit http:/​/​www.jbase.com

About jBASE

What is jBASE?

jBASE is a database and a set of programs and libraries that allows normal MultiValue (MV) applications to become native Windows, Unix or Linux programs. All of the traditional MV features are supported, including BASIC, Proc, Paragraph, Query and Dictionaries (Pick and Prime style).

What are the benefits of jBASE?

Because existing MV apps are converted to native executables and shared objects, they run fast and take advantage of the latest compiler optimizations available for Windows, Unix and Linux platforms.

Flexible licensing models support cost-effective application deployment for traditional character-based applications and include models suited for efficient deployment of web and graphical-based applications.

A key differentiator is that jBASE architecture tends to make sense to technical hires who may not have prior MV experience. jBASE organizes itself much like other mainstream applications, with full support for pathing and threading. Because it is native, business objects created in jBASE, even those based on legacy code, can be wrapped with other languages. jBASE is a platform that respects the investments made in custom-built legacy apps while allowing non-MV programmers to build next-generation applications using the latest design tools and methods.

jBASE also has one of the lowest support and maintenance costs among enterprise-level MV databases.

Who actually controls jBASE?

In 2015, Zumasys purchased the jBASE intellectual property and development from Temenos, as well as jBASE sales and support from MPower1. Zumasys now controls and markets jBASE internationally with full time developers located in England and North America. jBASE interested us not just because of its worldwide install-base of loyal customers but also because it is a technology that will utilize the Zumasys Cloud to help those customers move to a SaaS business model. We can serve up MV applications running on a multi-tenanted database architecture with unrivaled price and performance and include unique features such as browser-based access.

What does the future hold for jBASE?

Being a native architecture, the future for jBASE is bright. Advancements in technology outside of jBASE tend to benefit jBASE simply because it has a native architecture. This leaves our engineers with time to focus on internal feature and functions and leave other work such as performance tuning and connectivity to vendors of operating systems.

Developers can continue to develop using traditional MV languages and data or choose to develop in new languages. They can choose whether data should be stored in traditional high-performance MV files or in virtually any other database, such as SQL Server, Oracle, DB2 or modern object data stores and noSQL databases.

For more information, visit http:/​/​www.jbase.com/​

Related Articles:

Return to top