NON-EQUIJOIN METADATA
First Claim
1. A system comprising:
- a database to hold tables of data including columns and rows; and
a data store to hold metadata describing relationships between tables, the relationships including one or more non-equijoins of tables in the form of one or more table-column pairs of a first table being non-equal to one or more table-column pairs of a second table.
2 Assignments
0 Petitions
Accused Products
Abstract
The subject mater herein relates to database management and, more particularly, to non-equijoin metadata. Various embodiments described herein provide systems, methods, software, and data structures to facilitate non-equijoins of data. Some such embodiments include a data store to hold metadata describing relationships between database tables. The relationships between database tables may include one or more non-equijoins of tables in the form of one or more table-column pairs of a first table being non-equal to one or more table-column pairs of a second table. In some embodiments, the metadata may be used by a query generator to build query statements including one or more non-equijoin.
-
Citations
20 Claims
-
1. A system comprising:
-
a database to hold tables of data including columns and rows; and a data store to hold metadata describing relationships between tables, the relationships including one or more non-equijoins of tables in the form of one or more table-column pairs of a first table being non-equal to one or more table-column pairs of a second table. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A method of providing non-equijoin data to a query generator, the method comprising:
-
storing metadata descriptive of relationships between database tables in a data store, the relationships including one or more non-equijoins of database tables in the form of one or more table-column pairs of a first database table being non-equal to one or more table-column pairs of a second database table; receiving a metadata request from a requestor including a request for metadata for making a join between two database tables for which non-equijoin metadata exists; and retrieving the requested metadata from the data store. - View Dependent Claims (9, 10, 11, 12, 13, 14)
-
-
15. A tangible computer-readable medium, with instructions encoded thereon, which when executed, cause a suitably configured computing system including a database management system to:
-
maintain a data store holding metadata descriptive of relationships between database tables, the relationships including one or more non-equijoins of database tables in the form of one or more table-column pairs of a first database table being non-equal to one or more table-column pairs of a second database table; receive a metadata request from a requestor including a request for metadata to facilitate a non-equijoin between two database tables for which non-equijoin metadata exists; retrieve the requested metadata from the data store; and build a query statement including a representation of the non-equijoin. - View Dependent Claims (16, 17, 18, 19, 20)
-
Specification