Method of and system for creating queries that operate on unstructured data stored in a database
First Claim
1. A method of searching unstructured data stored in a database, the method comprising:
- storing unstructured data in a column of a database table;
allowing a user to identify elements in the unstructured data as indexed elements;
creating an intermediate index into the unstructured data from the identified elements; and
allowing a user to create queries on the unstructured data using the indexed elements.
1 Assignment
0 Petitions
Accused Products
Abstract
A method of and system for searching unstructured data stored in a database. In one embodiment the method comprises storing unstructured data in a column of a database table; allowing a user to identify elements in the unstructured data as indexed elements; creating an intermediate index into the unstructured data from the identified elements; and allowing a user to create queries on the unstructured data using the indexed elements. In some implementations of this embodiment the unstructured data comprises a well-formed XML document stored within a column of a database table. Also, in some implementations the unstructured data is part of an electronic record stored in a common repository of electronic records that provides an audit trail that cannot be altered or disabled by users of the database.
-
Citations
20 Claims
-
1. A method of searching unstructured data stored in a database, the method comprising:
-
storing unstructured data in a column of a database table;
allowing a user to identify elements in the unstructured data as indexed elements;
creating an intermediate index into the unstructured data from the identified elements; and
allowing a user to create queries on the unstructured data using the indexed elements. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A method of searching XML data stored in a column of a database table in character large object (CLOB) format, the method comprising:
-
storing the XML data in the column of the database table, wherein the XML data comprises a first plurality of XML elements that conform to a first data type definition (DTD) and a second plurality of XML elements that conform to a second DTD;
allowing a user to identify elements from the first and second plurality of XML elements in XML data as indexed elements;
creating an intermediate index into the XML data from the identified elements; and
allowing a user to create queries on the unstructured data using the indexed elements. - View Dependent Claims (10)
-
-
11. A computer system for searching unstructured data stored in a database, the computer system comprising:
-
a processor;
a database; and
a computer-readable memory coupled to the processor, the computer-readable memory configured to store a computer program;
wherein the processor is operative with the computer program to;
(i) store unstructured data in a column of a database table;
(ii) allow a user to identify elements in the unstructured data as indexed elements;
(iii) create an intermediate index into the unstructured data from the identified elements; and
(iv) allow a user to create queries on the unstructured data using the indexed elements. - View Dependent Claims (12, 13)
-
- 14. The computer system of claim 163 wherein the unstructured data comprises well-formed XML documents stored within a column of a table stored in the database.
-
16. A computer program stored on a computer-readable storage medium for searching unstructured data stored in a database, the computer program comprising:
-
storing unstructured data in a column of a database table;
allowing a user to identify elements in the unstructured data as indexed elements;
creating an intermediate index into the unstructured data from the identified elements; and
allowing a user to create queries on the unstructured data using the indexed elements. - View Dependent Claims (17, 18, 19)
-
Specification