Patent ID: 9026561
Filing Date: 2015-05-05
Classification: G06F

Abstract:
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.