{"id":40089,"date":"2026-10-13T15:18:14","date_gmt":"2026-10-13T13:18:14","guid":{"rendered":"https:\/\/inlab.fib.upc.edu\/projecte\/implementation-of-sql-assertions-in-oracle-database"},"modified":"2026-10-13T15:22:15","modified_gmt":"2026-10-13T13:22:15","slug":"implementation-of-sql-assertions-in-oracle-database","status":"publish","type":"projecte","link":"https:\/\/inlab.fib.upc.edu\/en\/project\/implementation-of-sql-assertions-in-oracle-database","title":{"rendered":"Implementation of SQL Assertions in Oracle Database"},"content":{"rendered":"","protected":false},"author":1320,"featured_media":40090,"template":"","meta":{"_acf_changed":false},"experteses":[25],"tencnologies":[43,475],"class_list":["post-40089","projecte","type-projecte","status-publish","has-post-thumbnail","hentry","experteses-knowledge-i-service-engineering","tencnologies-oracle","tencnologies-sql"],"acf":{"minidescripcio":"inLab FIB and Oracle collaborate on the implementation of SQL Assertions to automate the validation of database integrity constraints.","ordre_prioritat":0,"descripcio":"inLab FIB of the Universitat Polit\u00e8cnica de Catalunya (UPC) has collaborated with Oracle on the implementation of SQL Assertions (Structured Query Language Assertions), a feature that enables the automated validation of integrity constraints in database management systems. These constraints are essential for ensuring data quality and consistency, as they define the conditions that data must satisfy and the business rules of an organisation. \n\nTraditionally, checking these conditions requires developers to manually programme mechanisms to detect potential constraint violations using custom code, triggers or stored procedures. This process can be complex, time-consuming and prone to errors, particularly when business rules are numerous or involve multiple database tables. \n\nThe implementation of SQL Assertions simplifies this process. Once the integrity constraints have been defined, the database management system itself checks compliance with them and manages their revalidation automatically and efficiently. This reduces the need to develop additional code to perform these checks and makes applications easier to maintain. ","image":"","url":"https:\/\/www.oracle.com\/database\/?ytid=GqRR804igFQ","data_inici_pro":"20190601","data_fi_pro":"20210430","client":[40087],"entitat_finan":"","colab":"","responsable":[221,1079],"equip":[221,1079,1123,1122,1141,1146],"escert":"0","mpi":"0","accio":"0","padih":"0","nacional":"0","participants":"","participants2":"","projecte_final":"","articles_presentacions":"","slideshare":""},"_links":{"self":[{"href":"https:\/\/inlab.fib.upc.edu\/en\/wp-json\/wp\/v2\/projecte\/40089","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/inlab.fib.upc.edu\/en\/wp-json\/wp\/v2\/projecte"}],"about":[{"href":"https:\/\/inlab.fib.upc.edu\/en\/wp-json\/wp\/v2\/types\/projecte"}],"author":[{"embeddable":true,"href":"https:\/\/inlab.fib.upc.edu\/en\/wp-json\/wp\/v2\/users\/1320"}],"acf:user":[{"embeddable":true,"href":"https:\/\/inlab.fib.upc.edu\/en\/wp-json\/wp\/v2\/users\/1146"},{"embeddable":true,"href":"https:\/\/inlab.fib.upc.edu\/en\/wp-json\/wp\/v2\/users\/1141"},{"embeddable":true,"href":"https:\/\/inlab.fib.upc.edu\/en\/wp-json\/wp\/v2\/users\/1122"},{"embeddable":true,"href":"https:\/\/inlab.fib.upc.edu\/en\/wp-json\/wp\/v2\/users\/1123"},{"embeddable":true,"href":"https:\/\/inlab.fib.upc.edu\/en\/wp-json\/wp\/v2\/users\/1079"},{"embeddable":true,"href":"https:\/\/inlab.fib.upc.edu\/en\/wp-json\/wp\/v2\/users\/221"}],"acf:post":[{"embeddable":true,"href":"https:\/\/inlab.fib.upc.edu\/en\/wp-json\/wp\/v2\/empresa\/40087"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/inlab.fib.upc.edu\/en\/wp-json\/wp\/v2\/media\/40090"}],"wp:attachment":[{"href":"https:\/\/inlab.fib.upc.edu\/en\/wp-json\/wp\/v2\/media?parent=40089"}],"wp:term":[{"taxonomy":"experteses","embeddable":true,"href":"https:\/\/inlab.fib.upc.edu\/en\/wp-json\/wp\/v2\/experteses?post=40089"},{"taxonomy":"tencnologies","embeddable":true,"href":"https:\/\/inlab.fib.upc.edu\/en\/wp-json\/wp\/v2\/tencnologies?post=40089"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}