Functioning Structure
Last updated
Last updated
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.
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
Source: https://clickhouse.tech/docs
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.
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.