SQL or NoSQL, You Decide

There is no restrictive legacy Virtual Machine layered on top of your application. jBASE jEDI (jBASE External Database Interface), allows you to write information to virtually any data store.

MultiValue NoSQL

jBASE utilizes a highly flexible multidimensional data model. The fundamental architecture of this data model is one that enables the database to be designed as quickly as you can design forms. So no longer is a crew of DBAs or an army of consultants needed to implement and keep it running. Because the database allows tables embedded within other tables, you do not need to design your application around the database, but rather design it around your business and solving the business requirement at hand.

A relational database table organizes structured data fields into defined columns

A NoSQL database does not incorporate the table model, instead, data can be stored in a single document

Dynamic Files

Imagine your MultiValue system continually adjusting the size and structure of its data on its own? Welcome to Dynamic Files, a free feature that you can toggle on or off in jBASE. Underneath the hood, jBASE manages all the hash algorithms and disk allocation. But to Administrator, this means there is no more file resizing (as your data grows), and no more slowdowns if your file structure outgrows your file plan. In fact, Dynamic Files often run 3x faster than regular files and file sizes can grow up to 64TB on select 64-bit operating systems.

It’s easy to convert your existing files to Dynamic Files. Once converted, the maintenance on your data files should be significantly less. Also, there is no change necessary to your business logic to use this enhancement.


The jEDI enables applications to achieve seamless integration with foreign databases without changes to the jBASE BASIC application code and logic. Some or all of the data can be stored in the external database such as Microsoft SQL Server, Oracle, IBM’s DB2 or MongoDB.

The jEDI architecture is ideal for sites that want to capitalize on their investment in current PICK-based business-critical applications while being able to integrate with the database of their choice. Standard Edition jEDI provides an off-the-shelf integration for design studies, proof of concept projects, and non-business critical applications. While the Business Edition jEDI includes all the facilities to allow the customer to optimize and maintain the interface to meet the needs of the most demanding on-line business application integration with a foreign database. This optimization ensures scalability and results in the best-of-breed integration between PICK BASIC code and data held in a external database keeping you in control of the interface at all times.

Want to learn more?