Compared with other relational database management systems, EXASolution significantly lowers the total cost of ownership.

 

Problems of traditional data mart architectures

As a result of the architectural restrictions of traditional RDMBS, many companies have a variety of data marts that are separated physically. As a rule, these data marts can be optimized specifically because they only have to support a certain user profile. However, this generates a whole set of problems that have a considerable effect on administration costs, as well as on the benefits of the overall solution:

 

• It is difficult to map company-wide business processes
• Active data warehousing is almost impossible
• Data quality and validity is impaired by:

                    - Data redundancy
                    - Data latency
                    - Data inconsistency

 

•  Data mart architectures are very expensive
  

                    - Costs of data transfer
                    - Costs of data synchronization
                    - Costs of system administration
                    - Costs of system maintenance

 
EXASolution consolidates all business-relevant data in your data warehouse. Thanks to the optimum support of different usage profiles, EXASolution can be used across all areas within the company for enterprise data warehouse applications. This reduces the cost of the overall solution and creates additional advantages by making centralized analysis possible. With EXASolution, all users can access the consolidated data warehouse and analyze the detailed data on an ad hoc basis.

 

Typical administration tasks

In a traditional RDBMS, the database administrator (DBA) has to answer the following questions:

• Do I have to de-normalize the schema?
• How do I distribute the data?
• How large do the individual partitions have to be?
• What does the data look like?
• How do users access the data?
• How do I adapt the execution plans of individual queries?
• Which indices do I need for an optimum performance?
• Should some users only receive static reports?
• Which aggregates do I still have to create?

 

EXASolution performs the administrative work automatically, so most of these questions are superfluous. EXASolution is a high-performance solution for any chosen schema. Data distribution is automatic on the basis of the usage profile. The EXASOL optimizer analyzes both data and queries and matches them without the intervention of the DBA. The system automatically creates and administers the indices on the fly on the basis of the query analysis.