The world’s fastest evolving MultiValue Database just got better with Data Integrity Constraints and OpenQM 4.0

OpenQM 4.0 now includes the following features:

OpenQM Profiling Utilities

Analyze OpenQM applications for performance bottlenecks

Application Profiling is a set of tools that enable a developer to identify parts of an application that may be able to be improved when looking for performance issues.

  • FSTAT – Counts file system operations (open, read, write, select, indexing, etc)
  • HSM Hot Spot Monitor – Shows each program used during monitoring, counting number of time it was called, the processor time spent in that program and counts of file system activity (open, read, write, delete).
  • Command Logging – Shows every command executed and where it came from.
  • Lock Tracing – Gathers system wide data for every file lock or record lock action.
  • Event Profiling – Gathers information for actions that may be critical to application performance (subroutine calls, file activity, command execution).
NetObjects API Support

Lift and shift applications from using object libraries that connect to other MultiValue platforms to OpenQM without re-writing code

Data Integrity Constraints

Database field-level data typing and validation with two modes, audit and enforce

Multivalue database products do not normally impose validation rules when writing data to files. Instead, they largely rely on validation being performed when data is entered into the system. In some products, developers who wish to apply validation can do so via a pre-write trigger, rejecting the write request if the validation fails.

QM allows use of a pre-write trigger but also provides an alternative mechanism for hashed files where the validation rules for each field are defined in the dictionary and encoded into the data file in a manner that makes it impossible to skip the validation. This feature is known as Data Integrity Constraints. If both a pre-write trigger and data integrity constraints are present, the trigger is executed before the constraint validation.

MV Connect Integration

Create inbound and outbound RESTful services natively in OpenQM

MV Connect is a cross-platform Web/Rest API development package. The MV Connect API for QM is a set of QMBasic subroutines that can be used to build a web/rest application that works with QM’s internal WEBSVC webserver to expand its underlying functionality. These are equivalent functions to those in other languages such as working with headers, the body, form vars, return codes, etc. Additional information regarding these MV Connect APIs can be found here.

The MV Connect API library is provided as a separate package for download and installation as needed. It can be installed in the private catalogue of an individual account or in the global catalogue to make it available to all accounts.

OpenQM 4.0 Now Certified for the Raspberry Pi 4 “Tiny” Computer

The newest single-board computer developed by the Raspberry Pi Foundation

  • With a reputation as the most affordable and architecturally efficient PICK database, OpenQM fits in as little as 15MB, making it ideal to run on the tiny form factor devices like the Raspberry Pi.
  • Starting at only $35, the Raspberry Pi allows you to deploy your PICK application in new places using OpenQM’s small, efficient footprint. With disk space around 5Mb for Linux and 10Mb for Windows and memory under 1Mb per user plus, the possibilities for deploying MultiValue apps are endless with OpenQM 4.0.

QM 4.0 allows the use of a pre-write trigger but also provides an alternative mechanism for hashed files where the validation rules for each field are defined in the dictionary and encoded into the data file in a manner that makes it impossible to skip the validation. This feature is known as Data Integrity Constraints.

Analyze QM applications for performance bottlenecks. QM 4.0 includes a number of tools for gathering data relating to application performance. Collectively these allow detailed analysis of an application’s performance, a process referred to as Application Profiling. This video summarizes the profiling tools.

Zerion Breaths New Life
Into Its MultiValue Application

Our Partners

We are pleased to feature our partners who enhance OpenQM with their third-party application development tools and solutions.

Partners
DesignBais
Kosday Solutions
Revelation Software
mv Toolbox
mv.net
Maverick Systems
crowell systems
Fusionware
Navigator
Information Capital
Pick Cloud
STAGE7 Software Systems
PAVUK
Nebula
253 Technologies

Dedicated MultiValue Database Support Team