Paradigm Systems, Inc

Home » News

Category Archives: News

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 www.mercuryconsole.com 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 www.mercuryconsole.com

 

 

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 MC@mbs.net.au

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 www.paradigm-systems.us and www.rmeducationalresources.com).

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 Mike.RMER@gmail.com

 

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 www.mercuryconsole.com.

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 www.rocketsoftware.com.

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 www.paradigm-systems.us.

Mercury 4.1.13 Released

Boca Raton, FL – August 23, 2016 – Paradigm Systems today announced the release of version 4.1.13 of its Mercury Database Console. This latest release resolved several open requests by clients to have improved sorting and quicker display of database files. Jay LaBonte, founder of Paradigm Systems and creator of Mercury Database Console, stated “This release is the first in a series that will focus on specific client requests highlighting our commitment to provide the best U2 database management system available.”

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.

Neumann Tech is Mercury Distributor

Boca Raton, FL – August 15, 2016 – Paradigm Systems announced today that it has appointed Neumann Technology Solutions as its distributor for Mercury Database Console in South Africa. Under the agreement Neumann Technology Solutions will become the primary provider of service and application support in the region.

“With Neumann Technology Solutions as our distributor in South Africa, 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.”

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 Neumann Technology Solutions

Neumann Technology Solutions is a software solutions provider and management consultancy firm specializing in services to the U2 industry. The company was formally incorporated in 2016 by its founder Kurt Neumann and is currently based in Johannesburg, South Africa.  Neumann Technology Solutions core focus includes the development of various Rocket U2 software solutions and Rocket U2 training courses, as well as U2 systems administration.