Method and system for database join disambiguation
US7529730B2 · kind B2 · utility
10Cited by
12References
7Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Feb 12, 2003 |
| Grant date | May 5, 2009 |
| Priority date | — |
| Expiry date | Jan 14, 2024 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99933
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
In cases where two or more database tables can be joined by more than one relationship or criterion on the row values of selected columns, to produce what is effectively a wider table, there may result an ambiguity of which join should be used. The invention provides a means of join disambiguation that is rule-driven. The user is relieved of understanding the details of how the disambiguation is being done. The system described in this invention makes the choice of which join to use based on clear transformation rules which relate to folders of the tables and their relationships.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.