Conclusion and outlook
Availability and performance are essential ingredients of a data platform. From our point of view, Exasol as a high-performance analytical database is a very good technical solution for dealing with these two requirements:
A very open data architecture supports integration of data from various sources both on-premises and in the cloud (AWS, Azure or GCP) and, thus, implementation of a central data pool.
Due to the in-memory and column-oriented architecture, the combination offers high performance which, in our experience, often overtakes the DB competition. As a result, data is not only processed efficiently and promptly, but also evaluated efficiently.
Of course, it should also be noted that in addition to technical measures, it is also necessary to establish organizational measures such as data governance in order to ensure the quality and findability of data in the long term. Without a treatment of data security however, technical performance and availability are rather toothless. After all, what good is performant provision of data if no one is permitted to evaluate them due to missing security measures? In the third part of this blog series, we therefore examine the Protegrity platform in detail, and show how integration with Exasol can be realized here.