Segment matching search system and method
A planning and search system are described wherein a graph search and segment matching are used to handle very large searches at a higher speed.
1. A database management system comprising at least one processor coupled to a memory, and further comprising,
at least one server including an engine configured to:
communicate with at least one data storage unit;
cause storage in the at least one data storage unit of data in a symbolic relational format of tables, a match diagram, using at least one set of tuples, wherein the at least one set of tuples has at least one attribute; and
create at least one sub-tree of the match diagram using a projection of the tuple attributes,
wherein the sub-tree includes at least one node that is a vertex table that is represented one of directly and indirectly by the match diagram and includes at least one edge that defines at least one relationship with at least one other node; and wherein the indirectly represented Vertex Table is one of a nested match diagram and a query applied to an external database.
2. The system of claim 1 wherein the at least one edge is at least one of a directed edge and an undirected edge.
3. The system of claim 1 wherein the relationship includes pairings between the attributes.
4. The system of claim 1 wherein the server is further configured to represent the match diagram in a set of relational database tables.
5. The system of claim 1 wherein each node further comprises a Vertex Table.
6. The system of claim 5 wherein the database is further configured to allow database queries based on the edges.
7. The system of claim 1 the directly represented Vertex Table is located in a primary storage.
8. The system of claim 7 wherein the primary storage is RAM.
9. The system of claim 1 wherein the indirectly represented Vertex Table is located in a secondary storage.
10. The system of claim 9 wherein the secondary storage is at least one of a remotely stored disk, flash memory and CD.
11. The system of claim 1 wherein the query applied to the external database is an SQL expression.
12. The system of claim 8 wherein the match diagram is traversed using one node from each table; and wherein an inter-table pointer is configured to indicate a row in the table to use when selecting the next node for a match.
13. The system of claim 1 wherein the match diagram represents each relation in a relation table.
14. The system of claim 1 wherein the match diagram is configured to allow data retrieved from the data storage unit to be interpreted as a tuple.
15. The system of claim 1 wherein the match diagram is configured to allow data input in the data storage unit to be interpreted as a graph.
16. The system of claim 1 wherein the data storage unit is configured to represent the match diagram using only one attribute for each table.
17. A database management system comprising at least one processor coupled to a memory, and further comprising,
at least one server including an engine configured to:
communicate with at least one data storage unit;
cause storage in the at least one data storage unit of data in a symbolic relational format of tables, a match diagram, using at least one set of tuples, wherein the at least one set of tuples has at least one attribute; and
create at least one sub-tree of the match diagram using a projection of the tuple attributes,
wherein the at least one node includes at least one edge that defines at least one relationship with at least one other node and each node further comprises a Vertex Table, wherein the Vertex Table is represented one of directly and indirectly by the match diagram and located in RAM,
wherein the match diagram is traversed using one node from each table; and wherein an inter-table pointer is configured to indicate a row in the table to use when selecting the next node for a match; and
wherein the tables are configured to join two or more rows, using each row, in a linked list.