Automated report of broken relationships between tables

摘要

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.

主权项

1. A method for reporting data loaded to a database that does not adhere to one or more referential constraints of the database that are not enforced, the method comprising the steps of:
a computer receiving an original file of a plurality of Data Definition Language (DDL) statements for creating a database; the computer identifying one or more DDL statements from the plurality of DDL statements that comprise text indicating the one or more DDL statements are referential constraints not to be enforced in the database, and in response, the computer converting the one or more DDL statements to one or more DDL create view statements, respectively; the computer generating a first file comprising the one or more DDL create view statements, wherein the one or more DDL create view statements are used to generate one or more database views, respectively, during a build of the database; the computer generating a second file, comprising the plurality of DDL statements without the one or more DDL statements from the plurality of DDL statements that comprise the text indicating the one or more DDL statements are referential constraints not to be enforced in the database, used to build the database; and responsive to new data being loaded to the database, the computer creating a report comprising data from the one or more database views.