A tool for efficiently implementing business rules validation, in any database system, to ensure the quality of the data.
The Challenge
Nowadays, data is gaining more importance than ever. For instance, data is driving the decisions of the business world (Business Intelligence), it is capturing the production state of the Industry (Industry 4.0), it is essential for automatizing administration (digital administration), and it is the key for new trends affecting our lives (from Smart mobility, to digital Healthcare).
Still, ensuring the quality of the data is a manual process. That is, engineers from all the previous domains, in order to guarantee whether their data complies with any business rules, must spend time and dedication to manually creating validation processes for such rules. This is a time-consuming and error prone task that is increasing the costs of producing any software, when not compromising its quality, over the whole world, affecting, among others, all the previous cited sectors.
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.
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.
Applications and Target Market
Innovative advantages
The Universitat Politècnica de Catalunya - BarcelonaTech is a public institution dedicated to higher education and research in the fields of engineering, architecture and science, which contributes its knowledge and expertise in order to increase scientific output, transfer its results to society and provide a network of scientific and technical state-of-the-art facilities and technology valorization services that place us at the leading edge of innovation and economic development.
The UPC has established itself as a driver of innovation and is the technology partner of choice for companies and organizations with which it develops projects and builds partnerships. A role borne out by the numerous agreements and research projects that have been set in motion by groups, organizations and laboratories; the creation of new technology-based companies; the generation and exploitation of patents, and the scientific and technical services UPC makes available to its environment in order to generate progress and employment.
The Technology Transfer Office (SGI) is responsible of Designing, coordinating and implementing research valorisation strategies, carrying out the protection policy of the research results, marketing these results through license contracts and designing and setting up the University's enterprise creation model in order to transfer the results of the research to the market, protect and commercialize these results, promote the culture of entrepreneurship and innovation, and create technology-based companies within the UPC environment.
Create your free account to connect with Universitat Politècnica de Catalunya - UPC and thousands of other innovative organizations and professionals worldwide
Send a request for information
to Universitat Politècnica de Catalunya - UPC
Technology Offers on Innoget are directly posted
and managed by its members as well as evaluation of requests for information. Innoget is the trusted open innovation and science network aimed at directly connect industry needs with professionals online.
Need help requesting additional information or have questions regarding this Technology Offer?
Contact Innoget support
