The ability to more accurately query any set of data without impacting performance is an essential aspect of data analysis. However, it is not always possible to do this, mainly when working with large data sets.
Intelligent tech solutions developer Nuqleous, for instance, found that it was running into the limits of what its SQL server could handle when working with data sets of 1-2TB. This meant that the company had to look for ways to improve performance.
The company needed to keep data load and clock times within established parameters to continue providing a high-quality analytics service and meet agreed SLAs. To meet its performance needs in the analytics layer, Nuqleous decided to work with analytics database company Exasol in 2020 to implement a solution.
Following this partnership, Nuqleous announced that it had seen huge improvements in data performance. According to Nuqleous, the partnership with Exasol has contributed to growth over the past two years and has supported it in strengthening its retail partner relationships. Nuqleous claims that its customers benefit from Exasol’s ability to provide them with increased efficiency, heightened analytics capabilities and business performance communication.
“Since partnering in 2020, Exasol has been integral to getting our real-time query rate down to the level we needed to support our interface,” said Paul Springmann, founder and president at Nuqleous. “While we still have many complex queries, now we have the confidence to execute them effectively and provide an answer without having to throw more resources at it.”
Nuqleous has partnered with several brands since 2018, including T. Marzetti Company and The Kraft Heinz Company. The company works to help these clients operate their businesses more efficiently. Its Spotlight product automates the retail analytics processes of its customers, delivering ready-to-go, ready-to-share information that helps them identify areas where they can drive value into their businesses.
The company has been growing at a rate of 50% year-on-year, providing in-depth analytics to a growing number of users. By leveraging the Exasol platform and optimizing its use, Nuqleous has reduced load times by up to 85%.
With companies no longer needing to maintain or tune their databases, they can now dedicate more resources to building new applications and improving the customer interface.