MultiValue Databases

MultiValue Databases are a type of multidimensional
database, typically considered synonymous with PICK, a database originally developed as the Pick
operating system.

MultiValue databases differ from traditional relational database in that they have features that
support and encourage the use of attributes having a list of values, rather than all attributes
having a single value. They are often categorized with MUMPS within the category of post-relational
databases, although the data model actually pre-dates the relational model.

Who Uses MultiValue Business Software?

Over 10 million people in companies around the world sign on to a MultiValue system every day
when they arrive at work. MultiValue business software solutions are available for over 300 major
industries and institutions. From the smallest company to companies with thousands of users.

Collectively, the sellers or MultiValue business solutions represent a $2 billion plus annual market
in software alone and have a staggering three million strong user base worldwide which has accumulated
over the past 25 years.

In the late 1990s, International Spectrum conducted a survey of over 500 active companies in the MV
market. These companies were categorized as either a VAR, Software House, or Independent Consulting Firm.

The survey revealed that the average MultiValue VAR generates $4.71 million revenue in the market
annually. The average MultiValue Software House reported $2.04 million annual revenue and the average
MultiValue consultant generates $187K annually. Those doing the best are those who know both the web
and legacy MultiValue applications.

International Spectrum currently is aware of over 400 active MultiValue VARs, 182 active MultiValue
Software Houses and approximately 2,000 independent consultants. Based on the above survey, a simple
linear extrapolation estimates the annual MultiValue market at $2.95 billion.

D3, part of the Rocket MultiValue Application Development Platform, is the choice of more than a thousand application developers world-wide, serving top industries including manufacturing, distribution, healthcare, government, retail, and other vertical markets. Boasting both stability and security, the D3 data server engine offers superior performance, high availability, and low administrative overhead.

Ease of Use and ROI Drive Loyalty

D3 provides software developers with all the necessary tools to quickly adapt to changes and build critical business applications in a fraction of the time as compared to other databases; without compromising data integrity and with low administration costs. For creating real-world applications, D3 manages information in a way that has proven vastly superior to other database schemas.

Performance Your Application Can Harness

D3 delivers high performance via efficient file management that requires minimal system and memory resources. Based on a true 64-bit architecture, D3 applications provide high performance at both the hardware and application level. The 64-bit version of D3 provides larger addressing space per process, larger core memory and overall enhanced application performance.

Security at Multiple Levels

By enhancing security, a continuous goal at Rocket, D3 boasts modern features such as SSL support, which makes D3 application data in transit more secure.

At the application level, for data at rest, D3 provides both file level and field level encryption, making the data secure at any level.

D3 also supports IPv6, so our customers and partners apps benefit from a more secure internet protocol that runs end-to-end encryption, making man in the middle attacks significantly more difficult. Plus, IPv6 supports more secure name resolution, delivering an improved level of trust.

By harnessing local authentication and LDAP, weve added single sign on which not only improves user experience, but also allows users to move between systems securely without typing their credentials each time.

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.

MVON was introduced in 2001 to replace database-dependent foundations, such as UniVerse, UniData, U2, D3, Power95, and PI/Open, with a database-independent foundation that fully supports both Relational and MultiValue databases. With MVON, MultiValue applications operate on Oracle, SQL Server and other databases. We support software companies whether replacing or expanding their DBMS options for their customers.

OpenInsight is a repository-based applications development environment
that enables development teams to work collaboratively to design,
develop, deploy and scale high-performance business solutions on
leading messaging and client/server platforms. OpenInsight is a
Windows-based application development environment that can reside
on either Windows or Linux servers when used in conjuction with our
network product Universal Driver 4.5. Arev32, Character to
OpenInsight (CTO), the U2 Connector, WebOI and the Bravo Dashboard
are all included in OpenInsight 9.0 Server Edition and above.

Effective 1/1/15 Zumasys is the Worldwide Distributor for OpenQM. Users with licenses issued prior to 1/1/15 should visit the Ladybridge website.

OpenQM is a high-performance, self-tuning database with an extremely efficient footprint. At less than half the price of comparable databases, OpenQM comes bundled with AccuTerm and provides incredible value for MultiValue resellers and end users alike. Auto-sizing of database files, object oriented programming, class and exception handling, simplified web development and more can be yours with a move to OpenQM.

Why OpenQM

OpenQM has long sought to revolutionize the MultiValue industry, taking MultiValue to new heights of performance and expectation. OpenQM support and maintenance is now available for the first time directly from Zumasys, one of the largest development and engineering teams in the MultiValue market. With technical support engineers located across the United States and England, you'll always be able to reach someone who knows the importance of keeping your MultiValue application up and running.

Their software developers, technical support engineers, infrastructure experts, and cloud engineers will work with you to support, protect, and modernize your OpenQM database-whether on site or in the cloud. Their cloud platform is optimized for MultiValue database applications using industry-leading technologies from VMware, NetApp, and Cisco, and housed in the world's most secure data center, The SuperNAP, managed by expert engineers who understand your business. They take care of everything including backups, system administration, and monitoring so you can focus resources on your core business while maintaining complete control of your data and applications.

OpenQM In The Cloud

The Zumasys cloud platform has been optimized with Flash memory at multiple tiers to address the disk I/O requirements of OpenQM and other MultiValue databases. If you're interested in leveraging the efficiency, security, and performance of MultiValue in the cloud, Zumasys can help.

Since 2006, Zumasys has provided enterprise-class cloud hosting for Oracle, SQL and Pick MultiValue applications. They have the depth and experience to keep your systems running. Visit www.zumasys.com/cloud for more information on their architecture, monitoring and customer references.

OpenQM At A Glance

OpenQM began in 1993 as an embedded database from Ladybridge Systems. It was released in its own right in mid-2001 on Windows systems and extended to Linux in 2003 and FreeBSD in 2004. In 2015, OpenQM announced a partnership with Zumasys to provide worldwide distribution, to create a comprehensive telephone support/maintenance program and to multi-tenant OpenQM on the Zumasys Cloud. This allows customers to quickly provision OpenQM servers in the cloud and benefit from a convenient, affordable monthly fee for the database, operating system and underlying infrastructure.

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.

A MultiValue and relational(SQL)-enabled database, it allows users to maximise the use of existing technologies while ensuring their customers needs are met, now and in the future. While maintaining its virtual machine concept, Reality now has open interfaces - using integrated ODBC/JDBC SQL, Web Services, HTML, TCP/IP Sockets and simple extensions to DataBasic - an extended Dartmouth BASIC language with exceptional database and string handling abilities. Remote calls can also be made in order to provide integration with open Java applications and Microsoft Visual Basic/C/C++/C# and .net.

Organizations rely on Rocket UniData, a best-in-class of the MultiValue application platform, for scalable business apps that can evolve as needs change. As a stable, secure, fast data server engine with high availability and low administrative overhead, Rocket UniData is ideal for rapid development using modern tools. On-premises or in the cloud, UniData serves nearly a million users worldwide.

Rocket embeds the most effective security standards for encryption technology deep within the data server, so your data is secure no matter its location, and whether in-transit or stored on disk.

SSL/TLS secures connections to the MultiValue server and encrypts data in transit for protection from snooping or eavesdropping. Third parties can also validate and accredit our cryptographic modules for FIPS 140-2 compliance.

Automatic data encryption ensures only trusted users with the encryption key can view data. Stolen data is rendered useless without the encryption key.

UniData also offers role-based security for users accessing the application. Required DBA maintenance to implement and maintain these capabilities is simple and efficient.

Fast, flexible data management and app development for your enterprise

Rocket UniVerse, a component of the MultiValue application platform, is a fast, flexible data server for developing enterprise apps. Its variable length, table-within-table architecture means speedy data access and low maintenance with user interfaces for Windows, Linux, and UNIX. Deployable to the cloud or on-premises, thousands of customers globally depend on UniVerse to run their businesses.

Does not require a large administrative or programming staff to implement, operate, or maintain

Accelerates the time to value for applications, and provides exceptional short- and long-term ROI

Includes multiple programming languages, including Python, with multiple interfaces for your tiered architecture so you can pick and choose the best development solutions based upon your staffs capabilities

Secure and auditable

SSL/TLS secures connections to the data server, in addition to securing data in transit from snooping or eavesdropping.

Automatic data encryption makes it easy to adhere to the highest security standards, protecting data at rest on the disk.

Only trusted users with the encryption key can view data, and stolen data is rendered useless without the encryption key.

Access is granted at the user or group level via role-based security, reducing the time required for DBA maintenance.

It offers exceptional database engine flexibility combining unparalleled multi-user connectivity with superior price/performance, and ease of use in an open systems world with integrated SQL technology.

Advanced Revelation is an award winning DOS development environment that is distinguished by unrivaled flexibility in application development and robust, multi-user data access. Advanced Revelation combines a powerful and flexible database management system with a suite of professional development tools including: forms designer, report writers, and a Basic compatible programming language.

Advanced Revelation is a complete relational database management system for PCs, LANs and client/server applications. Advanced Revelation provides the critical building blocks that ensure unrivaled flexibility in application development and robust multi-user data access. Advanced Revelation is fully programmable and scalable to handle even your most demanding application development needs. Advanced Revelation is the best database management system for your needs now and for years to come.

Mentor PRO is a portable, 32-bit protected mode database and native
operating environment for Intel-compatible processors which supports
up to 256 users. The integrated database environment makes it an
ideal business application environment with many ease of use features.
Mentor PROs BASIC compiler and run-time are optimized for the
database application environment and offer the best performance
available in a database environment of its kind.
PicLan, included with Mentor PRO, expands the
application environment to the network providing network connectivity
as well as network file transfer and printer sharing.

MVON# runs MultiValue applications in Microsofts .NET on Windows or Linux, and works with a DBMS of your choice, with SQL Server as the most common choice today. A MultiValue-specific p-machine and DBMS are no longer in the picture. It is you, your application, and Microsoft, with other options for the DBMS vendor, if preferred. MVON# was introduced in 2014 in South Africa and is now available worldwide. Because MVON# transpiles code to C#, interoperability issues typical of MV applications go away. .NET handles critical functions, such as memory management and device porting, while achieving exceptional performance with SQL Server. In addition to being secure and reliable with high availability, applications running in .NET with MVON# are horizontally scalable. Applications written in System Builder can also run in .NET with SQL Server using MVON# Netbuilder.

Join the MultiValue Database User and Developer Community

IT'S FREE! Become a member to get the tools and knowledge for
your MultiValue Enterprise.