logo

For the Inventor, By the Inventor

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

US 8122035 B1

PDFFull Text
Date of Patent:
Feb. 21, 2012

Filed:

Jun. 28, 2005

Method and system for transactional fingerprinting in a database system

Applicants:

Edward T. Childress, Austin, TX (US);

Rhonda L. Childress, Austin, TX (US);

David B. Kumhyr, Austin, TX (US);

Neil Pennell, Cedar Creek, TX (US);

Inventors:

Edward T. Childress, Austin, TX (US);

Rhonda L. Childress, Austin, TX (US);

David B. Kumhyr, Austin, TX (US);

Neil Pennell, Cedar Creek, TX (US);

Assignee:

International Business Machines Corporation, Armonk, NY (US);

Attorneys:

Yee & Associates, P.C.

Jeffrey S. LaBaw

Primary Examiner:

Shew-Fen Lin

Assistant Examiner:

Jieying Tang

Int. Cl.
CPC ...
G06F 7/00 (2006.01);
U.S. Cl.
CPC ...
Abstract

Transactions with respect to database operations are fingerprinted by associating transaction identifiers with logged information about those database operations. An SQL query is obtained prior to its evaluation by a database engine. A transaction identifier to be associated with the SQL query is also obtained. The SQL query is then modified to generate a modified SQL query, wherein the modified SQL query includes a WHERE clause that contains an expression that always evaluates to a logical true value, and wherein the expression contains the transaction identifier. The modified SQL query is then sent to the database engine for evaluation within the data processing system. When the processing of the modified SQL query is logged with a copy of the modified SQL query, the logged information contains a copy of the transaction identifier.

Find Patent Forward Citations

Childress, Edward. (2012). Method and system for transactional fingerprinting in a database system (U.S. Patent No. 8122035). U.S. Patent and Trademark Office. https://idiyas.com/patent/badge/8122035

Data source: USPTO (United States Patent and Trademark Office) public patent records. Weekly synchronization. How IDiyas builds this profile

Loading…