Exasol brings SaaS-flex to on-prem and public cloud systems

In-memory data warehouse and analytic system Exasol is bringing the separation of storage and compute it introduced in its SaaS offering to hosted public cloud and on-prem installations.

The re-working of the system - used by Adidas, Dell, and German retail giant Otto - would give customers flexibility and performance combined with cost-optimisation, Exasol says. It also offers cost advantages over serverless system such as Google's BigQuery, according to CTO Mathias Golombek.

One analyst said the company's cost-based query optimizer was critical in helping users get the most cost-effective approach to perform a given query based on the location and nature of the database objects.

Speaking to The Register, Golombek explained the latest release brought the same technical approach introduced in its SaaS offering, launched last year, to its hosted public cloud and on-prem systems.

"We are closing the gap between the on-premises, cloud installations and SaaS world," Golombek said. "SaaS already offers multi-cluster elasticity through the separation of storage and compute. That same architecture will now be available for installations in your own cloud infrastructure - AWS, Google and Azure - and on-prem systems," he added.

The move means customers could keep data ownership on their systems, or preferred cloud provider while taking advantage of the flexibility offered by SaaS. It also means customers could try out new installations in the DBaaS before moving them to their preferred environments without changing the underlying architecture.

Since it was founded in 2000, Exasol has placed an emphasis on speed performance with its in-memory architecture. This is replicated in the cloud by specifying locally attached main memory.

Also included in the release is a new version of its cost-based optimizer, to help manage spending on "very complex queries, [with] dozens of tables in one query joining them and doing very complex aggregations and analytical functions," Golombek said.

Other approaches to cloud data warehousing - such as Google's BigQuery and MotherDuck - have gone serverless, which allows users to scale up and down without provisioning the database.

But Golombek said Exasol does not share the approach because it can add unnecessary cost with its in-memory architecture.

"There are use cases where serverless might be the right mix, but if you're looking for that real-time, analytics workload, it is not serving your needs because you would need a lot of infrastructure and you would need many parallel servers to get the same level of performance compared to our system where the data is processed in-memory and already cached. Otherwise, you need to load data into the cache of many servers in parallel, which drives up costs. That's why you see, for instance, BigQuery's serverless alternative becoming very expensive if you're looking at heavy lifting workloads," he argued.

Matt Aslett, VP and research director, Ventana Research, said Exasol had done well with customers who have a significant performance issue with an existing data warehouse or realise that an initiative will require a high-performance analytic database.

"Developed as a parallel system based on a shared-nothing architecture, Exasol enables organizations to distribute queries across various nodes in a cluster using optimized and parallel algorithms to process data locally. This can provide linear scalability for more users and advanced analytics, including predictive analytics, by bringing AI/ML algorithms directly to the data," he said.

Aslett added that the company's cost-based query optimizer is critical in helping users ascertain the most cost-effective approach to perform a given query based on the location and nature of the database objects involved.

We have asked Google's BigQuery to comment ®

About Us
Website HardCracked provides softwares, patches, cracks and keygens. If you have software or keygens to share, feel free to submit it to us here. Also you may contact us if you have software that needs to be removed from our website. Thanks for use our service!
IT News
Sep 29
UTM: An Apple hypervisor with some unique extra abilities

Friday FOSS Fest Fancy running Windows, Linux and Classic MacOS on your modern x86-64 or Arm64 Mac? Walk this way

Sep 29
Bringing AI to reality

Sponsored Feature How DeepBrain made the most of Lenovo's AI Innovators Program

Sep 29
CNCF's chief techie talks WebAssembly, AI and licenses

Interview Or how one pesky press release ruined a vacation

Sep 29
Infosys launches aviation cloud it claims can halve lost luggage

Also optimises routes and tames crowds, but can't stop that person who just reclined into your knees

Sep 29
Red Hat bins Bugzilla for RHEL issue tracking, jumps on Jira

Just in time to get Atlassian's latest cross-team collab bits

Sep 29
Medium asks AI bot crawlers: Please, please don't scrape bloggers' musings

OpenAI might respect robots.txt but dunno about the others

Sep 29