US 2014/0006367 A1 · AUTOMATED REPORT OF BROKEN RELATIONSHIPS BETWEEN TABLES

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.

Claims15

Dependent claims

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 the 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.

3 more elements

A computer program product 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 computer program product comprising:

one or more computer-readable tangible storage devices and program instructions stored on at least one of the one or more storage devices, the program instructions comprising:
program instructions to receive an original file of a plurality of Data Definition Language (DDL) statements for creating a database;
program instructions to identify 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;
program instructions to generate 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 the build of the database;
program instructions to generate 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, program instructions to create a report comprising data from the one or more database views.

4 more elements

A computer system 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 computer system comprising:

one or more processors, one or more computer-readable memories, one or more computer-readable tangible storage devices and program instructions which are stored on at least one of the one or more storage devices for execution by at least one of the one or more processors via at least one of the one or more memories, the program instructions comprising:
program instructions to receive an original file of a plurality of Data Definition Language (DDL) statements for creating a database;
program instructions to identify 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;
program instructions to generate 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 the build of the database;
program instructions to generate 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, program instructions to create a report comprising data from the one or more database views.

4 more elements

Dependencies are inferred from the claim text.

Automated report of broken relationships between tables

Life of this patent

Automated report of broken relationships between tables

Life of this patent

Abstract

Claims15