La tecnologia/The technology

TINTIN is a tool for automatically ensuring the quality of the data, by means of efficiently checking that it complies with the required business rules, without programmatic efforts. On the one hand, TINTIN creates a code that captures user updates. On the other, it rewrites the business rules into queries that join the captured updates. In this way, TINTIN builds incremental queries: that is, queries that only take into account the last update applied to check whether some business rule has been violated. This incremental capability is the key for ensuring the efficiency of TINTIN.

Avantatges innovadores/Innovative advantages

• Efficiency: the revalidation of the business rules is only applied when some data update might violate them. Furthermore, it only revalidates the rule that can have been violated, and only for the modified part of the data that may affect it.
• Full automation: users of the tool only need to write the business rules that data must satisfy, and the tool automatically generates all the necessary code.

Fase actual de desenvolupament/Current stage of development

Right now, TINTIN is a proof of concept tool that reads a set of business rules that data must satisfy, currently specified as SQL assertions, and generates some code, currently under the form of SQL triggers and procedures, that automatically guarantees that any update on the data satisfies the constraints. All the code generated is automatically installed in the database without human intervention.

Aplicacions i mercat objectiu/Applications and target market