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:
Jan. 19, 2010
Filed:
Dec. 08, 2003
Srikanth Karimisetty, Peekskill, NY (US);
Srinivasulu Puri, White Plains, NY (US);
Charanjeet Singh, Redwood City, CA (US);
Ravindra Akella, White Plains, NY (US);
Savita Durgada, Tarrytown, NY (US);
Srikanth Karimisetty, Peekskill, NY (US);
Srinivasulu Puri, White Plains, NY (US);
Charanjeet Singh, Redwood City, CA (US);
Ravindra Akella, White Plains, NY (US);
Savita Durgada, Tarrytown, NY (US);
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
A method of and system for searching unstructured data stored in a database. In one embodiment the method comprises storing a plurality of electronic records in a common repository of electronic records in the database that provides an audit trail that cannot be altered or disabled by users of the system where each electronic record comprises unstructured data stored in a character large-object (CLOB) format in a column of a table of the database; creating a security protocol that protects the electronic records against unauthorized access; and creating a query designed to identify electronic records in the database that meet criteria designated in the query. The method further comprises modifying the query in accordance with the security protocol to create a modified query prior to executing the query and running the modified query against the unstructured data. In one particular implementation, the unstructured data comprises a well-formed XML document stored within a column of a table stored in the database.