Improving data reporting at Teixo: a focus on innovation

Discover how Teixo, the leading waste management solution, adapts to regulatory and technological challenges with an innovative strategy, ensuring performance and compliance in a constantly evolving sector.

This is some text inside of a div block.

Waste management is accompanied by the generation of large amounts of data (type, quantity, treatment...). To interpret this information, make strategic decisions and comply with current regulations, it is essential to have effective digital tools.

Among them is Teixo, the software solution for professional waste management developed by TEIMAS and currently used by more than 990 waste management centers in Spain.

Challenges after the implementation of the Royal Decree on Transfers and the Waste Law in Spain

In 2020, Royal Decree 553/2020 came into force, which regulates the transfer of waste within the territory of the State. This regulation established the obligation to carry out all waste transport procedures electronically and the subsequent entry into force of the Waste Law 07/2022 have been decisive in promoting the digitalisation of a traditionally analog sector.

These regulatory developments caused a significant increase in the number of Teixo users, which brought two side effects: on the one hand, Teixo should be able to support more simultaneous users to process data and documentation and, on the other hand, it should deal with requests for reports with a larger volume of data. All of this had to be achieved without compromising Teixo's performance. The complexity of this challenge was that the optimal type of data processing to handle common transactions - such as high, low and record modifications (OLTP) - is not the most suitable for generating extensive reports.

Cumulative number of TEIMAS Teixo users

Implementing OLAP to improve performance

Faced with this challenge, TEIMAS chose to separate common transactions (registration, deletion and modification of records) from reporting tasks. The use of OLTP for everyday transactions was maintained and OLAP was introduced for report generation. While OLTP is ideal for processing many small transactions, OLAP is designed to effectively handle fewer large transactions.

Evolution of Teixo and future prospects

The TEIMAS Development and Systems teams launched a process of Denormalisation, Transformation and Synchronisation (which every night dumps information available in Teixo, useful for generating reports), as well as an API that serves information to those clients who need to process large amounts of data.

The second phase, currently under development, seeks to perform this synchronisation practically in real time thanks to a complex mechanism that allows the software to be aware of and act on changes, as well as queues of messages, queries, deletions and insertions that allow information to be obtained at a speed hundreds of times greater and without affecting Teixo's performance.

As a result of the development of the data report, in 2024 the Teixo software achieved an evolution that, in the words of Cristina Vázquez, CEO of TEIMAS, “responds to the company's ability to innovate and find solutions that meet the changing demands of the market. It's a clear testament to our ongoing commitment to the waste value chain sector in an increasingly demanding regulatory environment.”

Consult in the glossary of terms the meanings of OLAP, OLTP or API.


Subscribe to newsletter

Do you want to receive our news in your inbox?