G
G
Gaio Documentation
English
Search
K
Comment on page

Functioning Structure

Architecture

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.

Overview

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.
Uma imagem contendo Interface gráfica do usuário Descrição gerada automaticamente

Clickhouse

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.

Applications

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.