发明申请
US20050108212A1 Method of and system for searching unstructured data stored in a database
有权
搜索存储在数据库中的非结构化数据的方法和系统
- 专利标题: Method of and system for searching unstructured data stored in a database
- 专利标题(中): 搜索存储在数据库中的非结构化数据的方法和系统
-
申请号: US10731673申请日: 2003-12-08
-
公开(公告)号: US20050108212A1公开(公告)日: 2005-05-19
- 发明人: Srikanth Karimisetty , Srinivasulu Puri , Charanjeet Singh , Ravindra Akella , Savita Durgada
- 申请人: Srikanth Karimisetty , Srinivasulu Puri , Charanjeet Singh , Ravindra Akella , Savita Durgada
- 申请人地址: US CA Redwood City
- 专利权人: ORACLE INTERNATIONAL CORPORATION
- 当前专利权人: ORACLE INTERNATIONAL CORPORATION
- 当前专利权人地址: US CA Redwood City
- 主分类号: G06F7/00
- IPC分类号: G06F7/00 ; G06F17/30
摘要:
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.