Paradigm Systems, Inc

Home » News

Category Archives: News

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.

Mercury 4 Released

Boca Raton, FL November 8, 2015:  Paradigm Systems, creator of Mercury Database Console, the ultimate file management tool for Rocket Software’s UniData and UniVerse database environment, has released version 4 for UniData and expects to release its updated UniVerse version during the first quarter of 2016, which is currently entering beta testing.

Mercury Console version 4 has been redesigned to support UniData version 8.x with support for 64 bit files systems, including the new type 3 static files as well as WHOLEFILE based dynamic files. Other new feature includes “SmartSize” which has the ability to learn how your database grows, allowing Mercury to learn your file system and your data patterns over time.

Mercury Console is the solution to file analysis, file resize and even file repairs. Mercury was designed from the ground up by an industry leading developer and U2 database engineer to provide a tool that can manage your entire U2 database. Mercury Console has numerous features that allow you to schedule your database analysis, resizing and even perform database repairs. Advanced user can even develop their own plugins for complete customization. Other features include query analysis allowing you to identify how your dictionary fields and indices are used and how to improved data selection, and our index management console allows you to add, delete and re-index your files.

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.