The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
May. 05, 2015
Filed:
Jul. 02, 2012
Kathleen F. Hills, Endicott, NY (US);
Thomas Kersjes, Arlington Heights, IL (US);
Mark A. Musa, Brackney, PA (US);
Fu-chen Pan, Endicott, NY (US);
Kathleen F. Hills, Endicott, NY (US);
Thomas Kersjes, Arlington Heights, IL (US);
Mark A. Musa, Brackney, PA (US);
Fu-Chen Pan, Endicott, NY (US);
International Business Machines Corporation, Armonk, NY (US);
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.