Automated report of broken relationships between tables
US9026561B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Jul 2, 2012 |
| Grant date | May 5, 2015 |
| Priority date | — |
| Expiry date | Jul 25, 2033 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/211
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
In a method for reporting data loaded to a database that does not adhere to referential constraints of the database that are not enforced, a computer receives a file of Data Definition Language (DDL) statements for creating a database. The computer identifies statements from the DDL statements that comprise text indicating the statements are referential constraints that are not to be enforced. The computer converts indentified statements to create view statements. The computer generates a file comprising the create view statements. Create view statements are used to generate database views during database build. The computer generates a file, comprising the received DDL statements without the statements that comprise the text indicating the one or more DDL statements are referential constraints not to be enforced in the database. The computer, responsive to new data being loaded to the database, creates a report comprising data from the database views.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.