Combined database index of unstructured and structured columns
First Claim
1. A method of generating an index to provide access to a database where the database includes structured data columns and unstructured data columns, the method comprising the steps of:
- identifying one or more unstructured data columns and one or more structured data columns from the database;
generating a combined index of the unstructured and structured data columns, the combined index providing associative access to the database using a query that includes both unstructured conditions and structured conditions.
2 Assignments
0 Petitions
Accused Products
Abstract
A database management system and method provides access to a data table having structured data and unstructured data. A user interface allows a user to issue instructions to the database management system such as to build an index based on the structured and unstructured data and to search the data table. An indexing logic generates an index structure by combining the structured and unstructured data. With this index structure, a single query can contain search conditions from both the structured data and the unstructured data. In this manner, efficiency for searching the data table for combined structured and unstructured conditions is improved.
-
Citations
21 Claims
-
1. A method of generating an index to provide access to a database where the database includes structured data columns and unstructured data columns, the method comprising the steps of:
-
identifying one or more unstructured data columns and one or more structured data columns from the database;
generating a combined index of the unstructured and structured data columns, the combined index providing associative access to the database using a query that includes both unstructured conditions and structured conditions. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A database management system for providing access to a data table, the system comprising:
-
a user interface for receiving instructions from a user; and
indexing logic that generates an index structure by combining an unstructured data column and a structured data column from the data table, the index structure allowing data retrieval from the data table based on a query received from the user interface having conditions associated to both the unstructured data column and the structured data column. - View Dependent Claims (11, 12, 13, 14, 15)
-
-
16. A method of searching a data table having at least a column of structured data and a column of unstructured data, the method comprising the steps of:
-
converting the unstructured data into a structured-like form;
generating an index structure based on the converted unstructured data and the structured data; and
searching the data table using the index structure in response to a query having conditions from both the unstructured data and the structured data. - View Dependent Claims (17, 18, 19, 20, 21)
-
Specification