Functioning Structure


Gaio in larger and more robust implementations is divided into two servers:

  • Application: accessed by users

  • Data: stores all data. It is a DBMS (Database Management System), which uses Clickhouse as a database.


The most common process in Gaio is to connect to databases, bring the data to the Data Repository and perform calculations on this data generating Reports.

The image below demonstrates this process, in addition to showing how Gaio stores its metadata, that is, Gaio uses the MySQL to manage users, processes, applications, permissions and other administrative activities.


What is ClickHouse?

​ClickHouse is a column-oriented Database Management System (DBMS) for online query analytical processing (OLAP).

Column-oriented databases are best suited for Analytics scenarios. They are up to 100 times faster in processing most queries.

Row-oriented DBMS

Column-Oriented DBMS


Applications and Processes

Gaio organizes the constructions carried out into two large blocks, applications and processes, which will be explored further in this documentation.


It is an individual or shared development environment, with access control management, which stores all processes created, and consequently all tables produced.

Law Suit

In Gaio, every construction is a flow of data. Therefore, whenever a process is executed, all the elements contained in it will be processed again.

This way, data import and transformation automations can be easily built.

Last updated