Welcome Guest | My Membership | Login

More MultiValue Database and Products Articles...

Case Study: Applied Concepts migration to QM

Applied Concepts Inc, based in Plano, Texas, trading as Stalker Radar, is the leading manufacturer of radar units for police and sports use. Their application runs all aspects of the company from accounting to sales and is used by almost all staff—about 100 users at their site plus a further 12 off-site.

Conference Schedule

Phoenix 2019 - April 8th-11th
More Info



Release Date: Friday, January 1, 2010

Applied Concepts Inc, based in Plano, Texas, trading as Stalker Radar, is the leading manufacturer of radar units for police and sports use. Their application runs all aspects of the company from accounting to sales and is used by almost all staff—about 100 users at their site plus a further 12 off-site.

They first saw a reference to QM that showed the availability of a free personal version for non-commercial use. Attracted by this, they downloaded the Windows version to give it a try and were impressed by what they saw.

Previously using D3, they wanted to migrate to a new platform to lower the cost of licenses and to provide a more powerful programming environment. Testing with QM showed that both of these objectives would be met and that the advantages would apply both to their character based applications and to their Delphi based Windows programs that communicated with the database. They found that the speed of the QM API interface was several times faster than the interface they had built using D3.

Any migration to a new platform requires some work and, partly because they embarked on this project before some of the compatibility improvements were introduced, they found it necessary to make changes in many Basic programs and several Delphi applications. There were some subtle differences between the code for D3 and QM, mostly to do with case sensitivity. They also decided to convert all S-type dictionary items to the more powerful I-types.

Was it worth it? Yes. James Woods, the senior programmer/analyst in charge of the migration project, said "after an intensive two weeks correcting a lot of problems with reports that malfunctioned because of dictionary differences, the problems have been resolved and we are very happy in the new environment. The users weren't too happy with us for those two initial weeks, but were understanding. Several have since commented on the faster response time".

Migration has had the benefit of providing a programming environment that has advanced features of QM that are not in D3. They plan to explore the opportunities of object oriented programming in QMBasic and are looking at several new projects that would not have been feasible in D3.

To maintain business continuity during the migration process, they ran QM on a separate development machine. Programs and dictionaries were converted on this system using a copy of the live application and then, when ready to switch to QM, they copied the latest data from the production machine to the new machine. They also deployed new Delphi programs on the same day.

Regarding support services, James Woods said "Ladybridge Systems is the most responsive Pick vendor I have ever experienced. It really gave us the feeling that if we were to hit a 'show stopper', they would have it fixed in two hours".

Looking to the future, James Woods added "QM has reduced the cost of adding new users. It also allowed us to remove restrictions on the number of open sessions, increasing productivity. It will provide a faster and richer environment for our new projects".


# # #          # # #          # # #


About Ladybridge Systems Ltd

Ladybridge Systems was founded in 1992 by former Prime Computer personnel and is headquartered in Hardingstone, Northampton, England. The primary activity of the company is the OpenQM multivalue database for which Zumasys were appointed as worldwide sales and marketing partner in January 2015. Ladybridge Systems also provide training, consultancy, development, and maintenance services to MultiValue databases in the UK and worldwide. Ladybridge Systems remains a small privately owned company, offering a personal level of service to clients around the world.

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

About OpenQM

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.

For OpenQM inquiries please visit: http://www.openqm-zumasys.com/ Users with licenses issued before 1/1/15 please visit: www.ladybridge.com

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

Related Articles:

Return to top