What is Sadas Engine?

Sadas Engine is a relational DBMS specifically designed to optimize the execution times of analytical operations on huge volumes of static data, like those in a Data Warehouse.

In what Sadas Engine is different from other DBMSs?

The most relevant difference is the physical organization of data: traditional databases store data by rows, whereas Sadas Engine stores data by columns.

Why has a "columnar" model been used to store data?

The traditional row-based approach is certainly the best in transactional environments, where it is usually necessary to access many attributes connected to a limited number of items.
In OLAP applications, instead, a limited number of attributes connected to very high volumes of data is usually analyzed; in this case, a column-based organization is much more efficient. With a columnar organization it is also possible to have a more efficient compression of data, thus further reducing I/O times of the queries.

On which bases Sadas Engine improves performances compared to traditional databases?

The main factor is the column-based organization, but Sadas Engine also uses other techniques based on the static nature of the data managed (which are fundamentally read-only):
- the creation of specific indexes structures, based on proprietary algorithms, that accelerate the processing of big files with appropriate redundancies;
- an approach of automatic adaptation of the structures depending on the most frequently run queries (learn by usage). Basically, the execution plans deriving from queries are continuously analyzed and, for the most frequent ones, additional specific indexes and data structures are created automatically, thus speeding up their processing.

What is the practical effect of the "learn by usage" techniques used by Sadas Engine?

After a certain utilization period, the most common queries will be executed even more quickly than they were immediately after the installation. It is however remarkable the fact that the original execution time with Sadas Engine is considerably quicker than the execution time with traditional DBMSs.

How faster is Sadas Engine than a traditional database?

To answer this question it was used the TPC Benchmark™H (TPC-H), a standard for the evaluation of DWH systems. The performances obtained were from 5 to 75 times better, depending on the type of query that had been run. These values refer to the "initial" processing and do not consider the further improvements that can be obtained progressively thanks to the "learn by usage" techniques.

What are the practical benefits of using Sadas Engine?

There are two main kinds of benefits:
- operational: users can obtain the results they need much more quickly, and this sometimes has an impact on the actual possibility of doing some particular analyses.
- economic: thanks to the greater operational efficiency of Sadas Engine, the hardware and software infrastructures necessary for the DWH environment are much cheaper than those necessary with traditional tools.

Are there problems as volumes of data increase?

Sadas Engine was specifically designed to manage big volumes of data; these are in fact the cases in which traditional tools sometimes have problems with performances, and in which it is logical to introduce alternative technologies.

If you could not find an answer to your problem and require assistance, please raise a support ticket.

Contact

(+1) 415 429 3969

20 California ST. 7TH Floor
SAN FRANCISCO, CA, 94111, USA

contact form

Login

This site uses cookies to improve the browsing experience of users

Continuing the navigation you accept the use of cookies Learn more

I understand

This site uses cookies to improve the browsing experience of users and to gather information about the site itself. You can know the details by consulting our privacy policy.
Continuing the navigation you accept the use of cookies; Otherwise you can leave the site.