Exasol V7: unlock more data at speed for improved businesses agility

Data Transfer

New Data Vault, Unstructured Data and AI/ML features with support for GPUs transform an organisation’s ability to work with more of its data and react quickly to change and opportunity.

Exasol, the analytics database, launches Exasol V7, bringing unmatched speed, performance, accuracy and insight to enhance organisations’ use of data. The new features empower businesses, giving them the ability to rapidly adapt to the dynamically changing world around them. Exasol V7 gives users the freedom and focus to run analytical models on even larger data volumes to quickly find more business-critical answers. These deeper insights can transform passive employees into data-driven teams, supported by the infrastructure they need to extract more value from data. 

Businesses are amassing data at rapid speeds and need a powerful database that will scale with them, and turn data into business value quicker, easier and more efficiently than ever before. This requires reducing complexity in the technology stack and achieving the flexibility needed to deal with both large data volumes and the growing user base that applies data analytics for decision making.

Mathias Golombek, CTO of Exasol explains,“The business environment is characterised by increasingly high levels of uncertainty and change. Alongside this, the exponential complexity and growth of data sources and formats has heightened business demand for more and more flexibility. Organisations need to ensure they’re building a sustainable data architecture that allows them to solve data challenges now and in years to come. Exasol V7 really ramps up what data-driven organisations are able to do with their data. Many businesses now have the skills and the data to push the boundaries of what’s possible when it comes to analytics — our database is equipped to handle whatever they can throw at it.”

“Today, more than ever, organisations need to build resilience and agility into their decision making and processes,” commented Philip Carnelley, AVP of European Software Research at IDC. “Our latest research shows that one of business’s top three priorities right now is to ramp up investment in analytics and data to minimise the impact of the current recession and prepare for the future. Businesses must exploit their rapidly expanding and valuable data assets using AI and ML, to create truly intelligent operations that power their innovation agenda, as recovery and growth returns to the economy.”


Read More: Predictions on the future of analytics


Key to unlocking competitive advantage and business agility, Exasol V7 allows businesses to bolster AI/ML model training with GPUs and improve the performance of their Data Vault models. It also improves the use of Unstructured Data. 

  • GPUs –  The rapid adoption of AI/ML means organisations need to build or utilise a data infrastructure that is scalable and flexible enough to meet quickly evolving and expanding AI workloads. Supporting the use of GPUs, Exasol V7 provides the speed and performance needed when training and retraining AI/ML models on large data sets and remove barriers to entry for deep learning. Moreover, the ability to run different AI/Ml workloads across on-premises and the cloud can provide the flexibility needed for a cost effective, scalable and secure AI solution. For example, enabling more accurate, faster diagnoses in healthcare and offering acutely personalised customer experiences in retail.
  • Data Vault 2.0 – Being agile in data analytics is crucial given the continued growth in the variety, volume and distributed nature of data. Data Vault modelling in Exasol V7 helps overcome the challenge of traditional dimensional and normalised data modelling techniques that aren’t designed to respond to rapid business change. In Data Vault 2.0, all keys are stored as hashes. These hashes help quickly join and compare data from multiple tables and schemas, to improve query performance, create better user experiences and open up previously prohibitive analysis.
  • Semi-structured Data (JSON Function) – Semi and unstructured data is much trickier to analyse than structured data, but is far more prolific in the enterprise. Industry research predicts that 80% of worldwide data will be unstructured by 2025, influenced by the abundant rise of IoT and social media content. A unified 360° view of different data types is therefore imperative for businesses to stay competitive and make informed decisions. Exasol V7 natively supports multiple data formats (structured and semi-structured) within one database engine bringing the benefits of scale and performance to more types of data. In Exasol V7, JSON functions are natively integrated in SQL and can be executed directly in the database without the need for User-Defined Functions (UDFs). Offering these native functions means the richness of the data is preserved and there’s no need for complex ETL or any up-front modelling. 

Exasol Expert, Peter Kioko, software developer at Grant Street Group had early access to the platform and said, “We are excited about this release, we ran our test suite against it and it performed really efficiently. In particular, the JSON feature will replace some of the custom JSON UDFs I built myself, which will make life easier. We will also begin using the hash data type feature in the near future.”

Exasol V7 will be available from 28th July 2020. Discover all the new features here


Bekki Barnes

With 5 years’ experience in marketing, Bekki has knowledge in both B2B and B2C marketing. Bekki has worked with a wide range of brands, including local and national organisations.

The Future of Smart Buildings: Trends in Occupancy Monitoring

Khai Zin Thein • 12th June 2024

Occupancy monitoring technology is revolutionising building management with advancements in AI and IoT. AI algorithms analyse data from IoT sensors, enabling automated adjustments in lighting, HVAC, and security systems based on occupancy levels. Modern systems leverage big data and AI to optimise space usage and resource management, reducing energy consumption and promoting sustainability. Enhanced encryption...

The need to weave agility throughout the business

John Craig Swartz SVP at POWWR • 11th June 2024

With geopolitical tensions, more extreme weather events and the legacy of a global pandemic, it is more difficult for energy suppliers to preserve their margins and remain competitive than ever before. To thrive in the current climate, it is imperative that a supplier makes marginal gains wherever they can. Profitability within the sector today hinges...

Artificial general intelligence is closer than expected

AI expert Stuart Fenton • 10th June 2024

Whilst most of the attention around artificial intelligence (AI) thus far has been on ChatGPT, it is just the tip of the iceberg. In many ways, ChatGPT shouldn’t be thought of as true AI as it is – at its heart – just generative, learned behaviour. The future of AI, in contrast, is a system...

The State of Data Streaming

Confluent • 06th June 2024

Confluent survey: 90% of respondents say data streaming platforms can lead to more product and service innovation in AI and ML development 86% of respondents cite data streaming as a strategic or important priority for IT investments in 2024 For 91% of respondents, data streaming platforms are critical or important for achieving data-related goals

The State of Data Streaming

Confluent • 06th June 2024

Confluent survey: 90% of respondents say data streaming platforms can lead to more product and service innovation in AI and ML development 86% of respondents cite data streaming as a strategic or important priority for IT investments in 2024 For 91% of respondents, data streaming platforms are critical or important for achieving data-related goals

Grant Funding Awarded to Advance Cancer Therapeutics Discovery

Dr Alan Roth • 04th June 2024

The CRUK (Cancer Research UK) Scotland Institute and Oxford Drug Design, a biotechnology company with core expertise in AI drug discovery, have announced that their joint application for the MRC (UK Medical Research Council) National Mouse Genetics Network (NMGN) Business Engagement Fund has been awarded.