Paradigm Systems, LLC

Home » Articles posted by Paradigmsystemsus

Author Archives: Paradigmsystemsus

Mercury Database Console Begins Development of Version 5.0 FLASH!

Happy New Year to all our current and future clients. Here is to a prosperous 2018! We appreciate the time you have spent working with us and look forward to the coming year ahead! 2018 is off to an incredible start for both Paradigm Systems and our customers, with the soon to be released Version 4.3 of Mercury Database Console; Paradigm Systems is pleased to announce the we have begun development of Mercury 5.0 which will be known as FLASH.

Mercury FLASH is going to be a complete redesign of the Mercury Database Console product with an exciting new web based interface. This new release will make it easier for Paradigm Systems to push out product updates, and provide our clients with the features and tools they need to successfully manage their growing U2 database.

Mercury Database Console and FLASH do more than just perform a deep, extensive analysis of all your database files – it literally learns as your database grows. The more knowledge you feed into it, the more effective it becomes at both supporting and empowering the way you like to work. It can even make calculations and recommend adjustments based on not just the current size of a database file, but the projected optimal file size that will handle your future data needs. It’s a tool designed to free up your valuable time, automating these menial tasks so that you can get back to doing what you do best: moving your business forward and achieving your long-term goals in the most proactive way possible.

Some of you may be aware of the recent closing of Fitzgerald and Long; if you are a current or former FAST c/s user and find yourself using a product that is no longer supported, Mercury is the answer!

We want you to be aware that Mercury Database Console and our future FLASH release are considered the premier U2 database management system. We believe in what Mercury Database Console can do for customers everywhere and would be honored to help you take control of your U2 database.

If you’d like to find out more information about the benefits of using Mercury Database Console, visit our website at or call us at 561-705-3688.

Paradigm Launches U2 Software Sales Referral Program

Let’s face facts: nobody knows your UniData and UniVerse databases clients quite like you do. You eat, sleep and breath to help your U2 database clients… which is why we wanted to take a moment to let you know about an incredible new opportunity that we’re sure you’re going to want to know more about.

How It Works

The program itself is incredibly simple: once you sign up and become one of our valued referral partners, you can provide company names, contact names, phone numbers, email addresses and other identifying pieces of information about potential clients that use the U2 database system.

  • Once the necessary information has been entered, we send those leads an email on your behalf in an effort to educate them and to really get them excited about our products and services.
  • The great part is that while we’re doing this, you’re doing it as well – essentially creating a mutually beneficial situation for both parties.
  • If the contact information you’ve entered does eventually result in a sale, you will be awarded a commission/referral fee once the invoice has been paid.
  • Note that your commission/referral fee will be based on a percentage of the sale, up to a set limit per client.

The more sales you help create, the more you get paid. It really is that simple! We have paid over $25,000.00 in commissions last year. Couldn’t you use some extra spending cash?

The best part of all is that you can manage absolutely everything about your participation in our referral program from our Business Connect website. In just a few quick mouse clicks you can manage all of your referrals, monitor your referral fees and so much more – right from the comfort of your very own web browser.

Sign Up For the Paradigm Software Sales Referral Program Today

If all of this sounds exciting to you, just wait – we’re just getting started. Though the program is currently only available to referrers based in the United States, we’ve already got expansion plans lined up that we can’t wait to tell you about in 2018 and beyond.

If you’d like to find out more information about our software sales referral program, or if you’d just like to get more specific answers to all of your important questions, don’t delay – contact us today, or click here to signup for the referral program now.

Take Back Control Of Your U2 Database

You don’t have to be a control freak to appreciate the power, flexibility, and resilience of the U2 database system. U2 database solutions provide the interoperability and outstanding performance—including scalability and manageability (i.e., control)— that data-driven business ap

How users lose control

So, why the title “Take Back Control…”? Where do U2 database users fall behind the control power curve in managing their databases?

Part of the answer lies in the need to carefully monitor U2 database hashed files. The resizing process can be a tedious, but vital, aspect of avoiding file overflow and its consequences of slower performance.

Read all about why you need to resize your U2 database files on our News piece, Why Resize U2 Files?

Dynamic files are not totally “automatic”

Then there is a common misconception about U2 dynamic files that leads to a false sense of security (and, again, loss of control).

Yes, dynamic files are designed to split and merge as you add or delete data. The reality is this “automatic” process often results in excessive overflow or hogging disk space; hence, the slowdown and further loss of control.

Dynamic files, like hashed files, require analysis and continual resizing. Otherwise, they will bog your system down with a slow split-and-rewrite process, which will take a toll on your database speed and add to your maintenance overhead.

Built-in commands don’t go far enough

So, why not maintain control of your U2 applications with the built-in file analysis and resizing commands? Those commands are simple and basic, but are only the first step.

There are other challenges. For example, can you detect the signs of potential file corruption? How do you locate and repair orphaned files? How often should you do the foregoing, and what are the implications in recovering disk space? Do you know how to repair corrupted file and reduce potential data loss?

Finally, there is always work to do in query analysis. Capturing repetitive and overlapping selection-based queries, for example, helps you tune your key indices for optimum database performance. Do you know which dictionary fields are being used for selection and how often?

Fine-tuning your U2 database

Then there are additional U2 database performance monitoring tasks, to keep your database sleek and efficient, such as

  • gathering and analyzing statistics on memory usage, disk utilization, user connectivity, etc.
  • reviewing database configuration files and adjusting them to improve database performance.

If you are up to the foregoing challenges, you are—or have hired—a DBA expert. But experts maintain control of their networks and applications by using monitoring tools—principally third-party file utilities to do the tedious and time-consuming work and concentrate on the mission.

Mercury helps you regain control of your U2 Database

Mercury is that third-party tool that meets every U2 database control challenge described above.

Check out our product features and browse through our product brochure. You don’t have to be an expert to gain control of your U2 Database. If you have a DBA expert working for you, you will free them from the drudgery of routine U2 database tasks so they keep you up, running, and competitive.

IT Vision Improves Application Performance with Mercury

IT Vision is a developer of Digital Enterprise Solutions and has been in business for over 30 years. Their cloud-based software serves Australia’s local governments, port authorities, and more recently, Medicare local branches. Over 170 local government councils use their ERP software and Altus platform solutions. They are big players in the managed services niche, and their SynergySoft suite is a module-based product that is geared to the everyday needs of government administrators.

IT Vision’s products and services rely heavily on the UniVerse MultiValue database system. The UniVerse Database system is user friendly and has multidimensional capabilities, which offer significant advantages over other database models. The UniVerse file system, does, however, require close attention to file analysis and resizing, which can be done in-house. That was IT Vision’s original (and unsuccessful) approach—until they discovered and adopted Mercury Database Console.

Mercury Database Console is now an integrated part of IT Vision’s improved database management system. Mercury is the complete solution to UniVerse file analysis and critical resizing chores necessary to keep the UniVerse database performing well. It is browser based and relieves database managers of the time-consuming tasks necessary to seek out and tune poorly performing database files, and even facilitate database repairs if needed.

IT Vision’s adoption of Mercury Database console ended a five-year quest to find the optimal file resizing and database tuning solution. “Before Mercury we just didn’t get good results in file resizing and the systems did not see any improvements in performance,” says Glenn Summerfield, an IT Vision team leader.

Because of the critical lack of tools and skills available in the industry to properly optimize a UniVerse database, Glenn’s team tried an in-house solution: “We had developed an in house resizing tool and integrity check tool. It was not as efficient as Mercury and did not optimize the database like Mercury.”

IT’s approach before Mercury was mostly hit miss. “Before Mercury there really wasn’t a process. It was simply a matter of tuning a file in hopes of solving a performance issue.”  They tried at least one other alternative solution, which according to Glenn, “simply did not work as advertised.”

Glenn cites the following reasons that the Mercury Database Console is the best solution:

  • As mentioned above, IT Vision’s software relies on the UniVerse database. Their more than 180 customers use the UniVerse database server. Says Glenn, “Mercury is the superior method for optimizing these databases, which reflects positively with our Application performing better.”
  • Mercury ensures a better performing database for their applications, allowing them to give their clients better service.
  • IT Vision provides an array of managed services for a wide variety of customers: Says Glen, “Mercury is a great addition to our Managed Services packages which we already offer to customers. Mercury made it much more cost effective to manage our client’s systems.”
  • Product adoption, training and launch, according to Glenn, went smoothly: “Paradigm Systems did a great job of training our team and help with our first install to ensure it was implemented properly and that we knew the steps required for a proper configuration. We then replicated this configuration for all other clients.”

What was the most obvious advantage that influenced IT Vision’s decision to adopt Mercury Database console? “That is an easy question,” said Glenn. “Mercury highly optimizes our UniVerse database from the moment we started using it and continues to do so on an ongoing basis.”

At the time of the interview, IT Vision had been using the Mercury Database Console for six months. Glenn has already noticed improved productivity and time savings while using Mercury: “Purely based on database benchmark tests, we can see significant improvements in our applications file I/O.”

As far as customer satisfaction, “Mercury has represented better value to our managed services package which translates to more satisfied clients.” Glenn’s bottom line: “Mercury is easy, automatic, thorough, and is the latest and greatest tool for optimizing UniVerse.”

Glenn’s advice to others who might be considering Mercury Database Console: “Mercury is definitely worth trying.”

Why Resize U2 Files?

U2 hashed files are perfect for data storage because they can grow rapidly and store variable length data and can have a wide range of key and data structures. Like any finely tuned machine, regular maintenance is required to retain that efficiency. Just like your car, your database requires regular periodic preventive maintenance.

U2 hashed files are divided into groups and each group can only store a finite about of data. As a file group reaches its maximum capacity, additional overflow groups are linked to each group in order to contain new data. Eventually data becomes distributed across multiple groups located in different areas of the file. These additional groups are referred to as overflow space.  Overflow space is similar to a Champaign fountain. As the first glass reaches its capacity, Champaign overflows to the next glass, and then the next glass, and eventually when it gets to that last glass there is nothing to catch that overflow, and you have a big mess to clean up.  Just like these Champaign glasses, your data will eventually overflow to such a point that your database becomes slow and unstable and then it’s just a matter of time before you experience a database failure which could result in lost data.

As data is distributed across more overflow segments the file becomes inefficient as U2 has to keep track of every overflow group and how each group  is connected in relation to the other groups, it also takes more time to access and update the data.   While a properly sized file is more like a neat bundle of pasta, all organized into identical lengths with a uniform structure which is organized into a neat bundle, a poorly maintained file resembles a bowl of cooked spaghetti, consuming more space and becoming difficult to find the start and end of your data.

In addition to being poorly organized and requiring multiple reads to access the data, poorly sized files consume more space. For example the table below in  figure 1 shows information for a dynamic file containing 1 million randomly sized records ranging from 1k to 3k in size.

Modulo / Block Size Level 1 Overflow File Size
168330 / 16 23,382 3,662,790,656
180731 / 16 0 2,961,162,240

Figure 1

As you can see in this example, when the file is properly sized the overflow space is zero (0) along with the added benefit of reducing the disk space consumed by almost 20% for a savings of 701mb in this case. The benefits are obvious, a properly sized file provides for  improved speed of data access, more efficient use of disk space, and a much more stable file.

It should however be noted that when resizing files you won’t always save space and in many cases you may not be able to eliminate overflow. The goal in resizing is to reorganize the stored data so that U2 may efficiently read and write data to the file with the least amount of effort.

The table below in figure 2, shows three 64 bit static files, each containing one million records ranging in size from 1k to 3k. The first file was created using a minimal size of one, 1k group and the second was created using a more realistic size of 133,723 groups of 4k blocks, while the last file contains 180,719 groups of 16k blocks.

The reason I choose a small block size of one, 1k group, is to amplify and demonstrate the excessive amount of resources consumed to update a poorly sized file.

Line Modulo / Block Size Level 1 Overflow File Size Time to Build
1 1 / 1 3,000,000 3,096,849,408 03:38:36
2 133723 / 4 866,486 4,096,860,160 00:00:29
3 180719 / 16 35,677 3,545,448,448 00:02:00

Figure 2 – 64 Bit Static Files

In the above example, line 1 is the ridiculously small file mentioned earlier. As you can see this poor sizing has resulted in a massive number of groups in overflow space, which adds a considerable amount of overhead to the system to make updates to the file. In this case it took over 3.5 hours to create the 1 million records.

Line item 2 has a much more realistic file size which results in a larger file, but considerably less overflow space, resulting in much faster file access. While line item 3 uses less disk space and has the least amount of overflow, it still does not provide the fastest file access time. In cases like this we must determine if we are more interested in file access speed or efficient use of disk space.

What about Dynamic Files?

A common misconception is that dynamic files automatically resize themselves. In theory, dynamic file groups are supposed to split as data is added and merge when data is deleted. In reality this process is not as quick or accurate as users are lead to believe. In reality, dynamic files often result in excessive overflow or too much unusable disk space locked away inside each group.

Why is Mercury the Solution?

File analysis and database tuning are paramount in keeping a system operating at peak performance. If you have not been resizing your files on a regular basis, your system is wasting valuable resources by performing unnecessary disk I/O, while large portions of disk space become unusable.

Rocket Software recommends that all files should be routinely analyzed to calculate the proper file size by determining the correct modulo and separation. Once determined, these values must be implemented by resizing each file on the system.

Gain Control

Mercury allows you to take complete control of your database without the need for a full time DBA, saving you piles of cash. It’s like having the premier DBA working for you at a fraction of the cost.

Call your Mercury reseller today to arrange a demostration or visit



StaffOne Saves Time and Money with Mercury Database Console

As one of the leading professional employer organizations (PEOs) in the industry, StaffOne in Dallas, Texas has been providing their clients with impeccable human resource support and services for over 28 years. StaffOne is focused on providing service that will allow their clients to concentrate on the important, day-to-day core operations of their own businesses.

The nature of what StaffOne strives to provide for their own business clients means that they are already very familiar with the concept of turning to another experienced company for solutions that they are not equipped to supply themselves. So when Byron Hay, the Vice President of Information Technology for StaffOne, realized that the company needed to augment their existing expertise in the UniData database to provide the administration functions outside of their application, he turned to Paradigm Systems and our Mercury Database Console tool.

Mercury is a file management tool that provides users with complete control over their database, while also allowing for the convenient automation of processes that can be difficult or tedious to perform manually. Mercury was designed to help keep your database operating at peak performance levels by offering an environment that balances automation and user convenience, as well as providing manual override options that are accessible when you need them.

At Paradigm Systems, we always love hearing from our satisfied clients and wanted to know what led Byron Hay to choose our Mercury Database Console over similar products offered by some of our competitors in the business.

“Mercury is a great product” he said, “it simplifies much of the ordinary UniData maintenance functions via a very powerful graphical web interface and automation processes, saving time and money.”

StaffOne uses the Mercury tool to perform the all maintenance functions on their UniData database.  Because Mercury simplifies the interface that is usually associated with these kinds of functions from a command line interface to a more intuitive, graphic one, it can be easier and less intimidating for those who aren’t experts. Many companies, including StaffOne, that have chosen Mercury Database Console have credited this simplification with saving them the money it would have cost to contract a database administrator.

Paradigm Systems has always been a believer in the reliable automation of database maintenance functions, which is another reason that our clients choose the Mercury tool over other available options. We are confident in our knowledge of the UniData and UniVerse databases and are ready and willing to assist our clients by sharing that knowledge with them and building a solid understanding between what we offer and what our clients need.

Paradigm Systems is so pleased that we have been able to offer StaffOne our service as they continue their dedicated journey to become one of the top professional employer organizations in the nation. We always ask our satisfied customers what they would tell other businesses who are facing the same challenges that led them to us – here’s what StaffOne VP of Information Technology, Byron Hay had to say:

“They should definitely give Paradigm Systems a call and start using Mercury as soon as possible.  You’ll be glad you did!”

If your own business could benefit from a robust database management tool that can make your database operations run smoother and more efficiently, contact us today to schedule a product demo. We look forward to hearing from you!

EngagePEO and Mercury Database Console: A Success Story

When Ralph Labarta, the CTO at EngagePEO in Tampa, Florida began looking for a database management solution to alleviate the issues his rapidly growing business was facing, he researched the options available and ultimately chose to use our software, Mercury Database Console.

For those who may be unfamiliar with Mercury Database Console, it is a robust file management tool that can help keep your UniData or UniVerse (U2) database maintained properly – a process that requires more than simply analyzing and resizing your files.

In order to perform at the highest level, U2 databases also require file type analysis and the creation, organization and management of file indices, as well as regular monitoring for signs of potential file corruption and if needed,  the repair of corrupted files. Mercury has been designed to analyze your database files extensively and use the results of that analysis to recommend new parameters, which you can either accept or override on a per file basis. Mercury gives you complete control over your database, but also allows you the choice to conveniently automate processes as needed.

When EngagePEO, a Professional Employer Organization, which provides other companies with outsourced services in managing payroll, benefits and human resources and with only 5 years under their belt in an industry full of competition, their dedication to providing excellent service to their clients has paid off, making them one of the largest and most respected service providers in their field. This success has led to a welcome stream of new clients coming in all the time. But as their business grows, so does the ongoing challenge of ensuring that the technical resources of their business operations can stay apace with their impeccably high level of service to clients.

“Growth, although a good thing, stresses your capability to focus on the very things that have made you successful” said Labarta. “Technology investment is the key to addressing these challenges.”

We are proud that Mercury has been the solution to EngagePEO’s concerns about staying true to the things that earned them so many clients in the first place. They chose to go with Mercury for their database maintenance and monitoring, and have been pleased to find that it is both easy to use and that it also fills in some of the functional gaps that are not a built-in part of the U2 database software provided by the database manufacturer.

Since implementing Mercury, the technology personnel at EngagePEO have had more time to focus on making improvements and had to spend less time on the routine database maintenance tasks that can be automated with the Mercury software. Labarta was also happy to report that they have seen other benefits of using Mercury, such as a reduction in downtime and resource requirements and an increased performance of their database, as well as more confidence in the reliability of their system.

Ralph Labarta had this final remark regarding what he would say to other businesses facing a challenge similar to EngagePEO. “Technology investment must be challenged based on sound economic logic. The analysis must encompass all the elements that contribute to the customer experience. You can’t spend on application development only to have database related availability issues. We started our analysis from the bottom-up, first establishing a sound and well maintained database infrastructure and then developing applications on that foundation.”

To learn more about Paradigm Systems, Mercury Database Console product, please visit our web site at and locate a reseller in your area.

Paradigm Systems, Inc. appoints Meier Business Systems as Asia Pacific Distributor

Boca Raton, FL – February 21, 2016 – Paradigm Systems announced today that it has appointed Meier Business System (MBS) as its distributor in the Asia Pacific region. Under the agreement MBS will become the primary provider of service and application support in the region.

“With MBS as our distributor in the Asia Pacific region, we bring our state-of-the-art solution for U2 database management to the area” said Jay LaBonte, President and CEO of Paradigm Systems, Inc. “Our goal is to continuously improve our customers’ experience in every aspect. Expanding our network of sales and support personnel and being in close proximity to where our customers are is a key initiative towards achieving that initiative.”

This agreement covers Australia, New Zealand, China, Hong Kong, Japan, India and the ASEAN countries. “We are particularly pleased and excited by this appointment as it provides an excellent opportunity for our existing and potential partners to work much closer with their customer base” said Brian Egan (MBS Channel Manager, Asia Pacific). “We were initially attracted to Paradigm Systems because Mercury Console is a solution for all Rocket U2 environments and is designed to lessen the load on System Administrators and Managed Services Providers alike”.

About Mercury Database Console

Mercury is the ultimate file management tool for Rocket Software’s UniData and UniVerse (U2) databases. No other database management system available for U2 offers a complete solution like Mercury. Mercury allows you to take complete control of your database, saving time and money in the process.

About Paradigm Systems

Paradigm Systems, Inc. is a true pioneer of U2 administration services. The company was founded by Jay LaBonte, creator of Mercury Database Console, and former Vice President of the U2 Users Group. With more than 35 years of experience managing Multivalue databases, he has managed many high availability systems in such industries as airspace manufacturing and materials distribution, real estate, professional employment organizations (PEO), staffing companies, land development, oil companies, marinas, and the restaurant industry.

About Meier Business Systems

MBS is a specialized Value Added Software Distributor and IT services company and are the principal supplier of Rocket Software products in the Asia Pacific region as well as being a leading supplier of IBM Software in Australia.

Founded in 1987, MBS services its MultiValue customers from its corporate head office in Melbourne as well as offices located in Sydney, Kuala Lumpur and Singapore.

Enquiries should be directed to

MV Education Company joins Paradigm Systems, Inc

Boca Raton, FL January 25, 2015:  Paradigm Systems is pleased to announce that Rocky Mountain Educational Resources (RMER), a MultiValue education company, has signed a distribution agreement to promote our Mercury Console product and become part of our authorized vendor network around the world (visit and

Mike Ryan, president of RMER, stated, “We are very pleased with the depth of technology the Mercury product offers. The array of options to better manage and maintain the UniData and UniVerse environments is second to none and dovetails very nicely with our range of technical course offerings. We are encouraged by our current (and future) customers’ requirements for better tools. Now, we can offer a solution!”

The Mercury Console product was built from necessity by brilliant programmers who created solutions to typical problems; situations that all MultiValue systems eventually encounter. For example:

  • Why continually repeat sizing files the same old way with little day-to-day monitoring?
    • Mercury intelligently solves this issue.
  • How efficient are the multitude of queries against the database?
    • Mercury advises administrators on that.
  • Is there a way to determine if the fields indexed are performing at optimum and should another heavily used field be indexed?
    • Mercury recommends that, too.

It is no longer necessary to experience a crisis. Rather, let Mercury warn you of its pending potential.

RMER, a premier training partner of Rocket Software, begins its fourth year of business and training for MultiValue customers in February 2017.

For more information about Mercury or to set up MultiValue training, contact Mike Ryan at Rocky Mountain Educational Resources in Colorado. Phone or email: 303.349.5300 or


Paradigm System is now an Authorized Rocket Software Partner

Boca Raton, FL October, 24, 2016 – Paradigm Systems, Inc., a leader in U2 database management software announced today that it is now an authorized partner of Rocket Software.

“We are thrilled to be a global Rocket Software Partner and are proud to promote the U2 brand along with our Mercury Database management tool.” Said Jay LaBonte, President and CEO of Paradigm Systems, Inc. “Our goal is to bring Mercury Database Console to every UniData and UniVerse installation and provide the tools needed to keep our customer databases running at peak performance.”

About Mercury Database Console

Mercury is the ultimate file management tool for Rocket Software’s UniData and UniVerse (U2) databases. No other database management system available for U2 offers a complete solution like Mercury. Mercury allows you to take complete control of your database, saving time and money in the process. For more information about Mercury, visit

About Rocket Software, Inc.

Rocket Software is a global software development firm that builds enterprise products and delivers enterprise solutions in the following segments: Business Information and Analytics; Storage, Networks, and Compliance; Application Development, Integration, and Modernization; and Database Servers and Tools. Rocket is engaged in business and technology partnerships with IBM, EMC, Fujitsu, HP Enterprise Services, Hitachi Data Systems, Avaya, Epicor, and many others. The company is headquartered in Waltham, Massachusetts. To learn more, visit

About Paradigm Systems, Inc.

Paradigm Systems, Inc. provides software utilities for the U2 database environment for a wide range of functions designed to fill various gaps within the database environment, allowing those responsible for the management of the U2 environment, more time and resources for other important tasks. Paradigm Systems, Inc is headquartered Boca Raton, FL. For more information visit