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:
Apr. 07, 2009
Filed:
Nov. 14, 2006
Latha Sankar Colby, Sunnyvale, CA (US);
Sangeeta T. Doraiswamy, San Jose, CA (US);
Jun Rao, San Jose, CA (US);
Hetal Thakkar, Wilmington, CA (US);
Latha Sankar Colby, Sunnyvale, CA (US);
Sangeeta T. Doraiswamy, San Jose, CA (US);
Jun Rao, San Jose, CA (US);
Hetal Thakkar, Wilmington, CA (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
A method for cleansing anomalies from sequence-based data at query time. Sequence-based data such as RFID data is loaded into a database. A cleansing rule is received at a cleansing rules engine. The cleansing rule engine converts the cleansing rule to a template that includes logic to compensate for anomalies in the sequence-based data. A query to retrieve the sequence-based data is received by a query rewrite engine. The query rewrite engine rewrites the query by applying the template logic and an expanded rewrite technique. The rewritten query is executed at query time. The result of the rewritten query execution is identical to the result of executing the original query on a data set generated by applying the cleansing rule to all of the sequence-based data.