Deutsch   |   English
   
 digg.com  del.icio.us 

EXASOL SQL

EXASolution SQL 

EXASolution supports the bigger part of the SQL Standard 2003, core and optional features. The articles in this section provide information about the enhancements and specifics of EXASOL SQL.

FAQ
Answers to frequently asked questions about EXASOL SQL, eg. analytical functions support

Data Modeling
Best practices for data modeling with EXASolution and typical questions, eg. Multi-Tenancy.

Multipath SQL
Often, an analysis will be complex enough that it is very hard or cumbersome to express in a single SQL statement.

User-defined scalar functions
EXASolution does support user-defined functions. While querying the database is not possible within these functions, they can be used to evaluate their input parameters and process them into some return value.

Analytical functions
Analytical functions are designed to address such problems as "Calculate a running total", "Find percentages within a group", "Top-N queries", "Compute a moving average" and many more.

EXISTS
In which cases does it make sense to use correlated sub-selects?

NULL in EXASolution
How does EXASolution handle NULL values? Is this dependant on the underlying data type? Is there anything special? What functions can be used to treat NULL values?

MERGE Statement
MERGE is a powerfull SQL command, which combines INSERT, UPDATE and DELETE. It will be typically used in ETL processes. We introduce in the article some use cases.

IMPORT / EXPORT
IMPORT/EXPORT commands build an user friendly interface to a high performance bulk loader, which supports various data sources and targets.

SQL in examples
If you find yourself asking "How can I implement this in SQL?", take a look in this section.

Best practices ETL
Best practices ETL and data quality

Are you stuck?

To Support

Let us present EXASolution
to you!

In a webinar

Learn from the experts:

Training

References
  • AHOOLY
  • COOP

  • “With EXASolution, we are best prepared for future data growth. The fact that we can now process geodata – that is to say, also evaluate the dimension of the spatial reference – means that we can offer our customers brand new analysis options and even more comprehensive market overviews. We are very satisfied with the new solution. We can react flexibly to future demands but still reduce our total cost of ownership as the selected BI stack fully supports our vision of a ‘lean BI’.”

    Guido Niermann, Head of IT, Dataforce GmbH
    Dataforce

  • "By integrating EXASOL we can offer our customers a whole new experience in explorative data analysis… Besides the technical aspects we were also extremely pleased with the pre-sales advice and support during the integration." 

    Martin Heink
    CEO and owner, econda 
    Econda

  •  

     

     

     
     
    IMS

  • "With EXASOL’s innovative database we are able to perform complex analyses more precisely and with a larger amount of data. Thus we have a significant technological lead over our competitors." 

    Tobias Kiessling
    CTO, intelliAd 
    Intelliad

  • "The continuously high performance and the possibility to run real-time-analyses were the decisive factors for us when chosing EXASolution." 

    Tobias Kroha, CEO, seto GmbH (m-pathy-project)

     
    m-pathy
  • Media Control
  • Olympus

  • "We chose EXASolution because of its high performance; it offers optimal flexibility and handles our increasing amount of data very well." 

    Dr Michael Röbbecke
    (former) CEO, RatePAY 
    RatePAY

  • "With EXASolution we can considerably optimise our business processes."

    Gerhard Zapf
    Project Leader, Semikron 
    Semikron

  • "Reliable and quick support, excellent customer care and proven expertise…"

    David Hodge
    IT Director, Sony Music Entertainment Germany 
    Sony Music
  • SOQUERO
  • SponsorPay
  • Stayfriends

  • "EXASOL’s database is technology made in Germany on which we can count on in the long term. As it is self-scaling and physically expandible, the database grows with our company, and we are able to react to new requirements flexibly and quickly also in the future." 

    Heinrich Zetlmayer
    CEO, Turtle Entertainment 
    Turtle Entertainment
  • United Internet Dialog

  • "With EXASolution, we have acquired a database solution that ideally meets the high standards we demand of complex analyses on increasing volumes of data for our customers." 

    Christian Sauer
    CEO, Webtrekk 
    Webtrekk

  • "We chose the solution from EXASOL after an extensive benchmark test. The high performance of the system, the price/performance relationship and the service had us completely convinced." 

    Dr Ulrich Fricke
    Head of Business Intelligence, XING 
    Xing

  • "Efficiency, speed, high performance and flexibility were the determing criteria when chosing our database… The new database offers us scalability with reduced total cost of ownership. Thus also in the future we are able to perform optimal analyses for our customers…" 

    Sebastian Hoop
    Head of Operations, xplosion interactive     
    Xplosion
  • Zalando

EXASOL is developing a data management system capable of rapid data analysis and evaluation. EXASolution is an on in-memory technology based relational database, designed for time-critical, complex analytics, planning and reporting. Specially developed for enterprise data warehouse applications and business intelligence solutions. Successfully in use in a broad field of applications, e.g. web analytics, data mining, big data and cloud computing.