Novel Approach to Delivering Data Accuracy

DENVER, January 31, 2018 ––insightsoftware.com today announced that it has received a new patent from the U.S. Patent and Trademark Office for a technology the company refers to as SQL Double Counting Resolver. This technology is a core capability to the Hubble business performance management platform, which includes integrated reporting, analytics and planning for professionals to help solve today’s most pressing business challenges.

SQL Double Counting Resolver eliminates a common problem with database queries. Accountants often refer to a phenomenon called “double counting,” which occurs when a database query inadvertently pulls duplicate data due to multiple, complex table relationships. The result is incorrect data, and for business professionals, this can lead to erroneous reporting with potential legal consequences. With this patent, the Hubble solution holds an algorithm that automatically rewrites complex queries and resolves “double counting” before the query pulls information from the database. For Hubble customers, it is a seamless way to extrapolate data from their Oracle, SAP or JD Edwards ERP database, and eliminates a complicated, error-prone query process. The patent was awarded to Stephan Hoffmann, a 20-year veteran and senior developer at insightsoftware.com. 

“We are more than pleased about this patent because it gets to the heart of what drives Hubble innovation – our fierce commitment to the customer experience,” said Craig Strong, Chief Product Officer at Hubble by insightsoftware.com. “We want Hubble customers to have the utmost confidence in their real-time data, to feel liberated by an efficient process and be empowered to drive strategy within their organizations. We are very proud of our employees and this recognition is a great testament to the talent at our organization.”

For more information about SQL Double Counting Resolver, read the Q&A with insightsoftware.com Chief Product Officer Craig Strong and senior developer and patent holder, Stephan Hoffmann.

About Hubble by insightsoftware.com

insightsoftware.com formed in 2000 to address a critical need for business professionals to extract and manipulate data from extensive ERP systems, such as JD Edwards, SAP and Oracle E-Business Suite, without IT intervention. Today, the company helps enterprises and organizations worldwide solve some of their greatest business information challenges.

Hubble® is an integrated suite of Business Performance Management apps from insightsoftware.com. Hubble provides real-time reporting, analytics, and planning in a single solution purpose-built for critical business systems including ERP, HCM, and CRM technology. Hubble enables over 1,000 enterprise customers to bridge the information to decision making divide so they can easily understand, manage, and predict business outcomes.


Hubble® is a registered trademark of insightsoftware.com International. © 2018 insightsoftware.com International. All Rights Reserved.


For media inquiries:

Karen Lambert

Director of Marketing Communications

insightsoftware.com, Inc.




This website uses cookies. Cookies remember you so we can give you a better service online.

By using this website, you are agreeing to our Cookies Notice. Dismiss