Dynamic partition enhanced joining using a value-count index
US7640244B1 · kind B1 · utility
8Cited by
13References
22Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | Jun 7, 2004 |
| Grant date | Dec 29, 2009 |
| Priority date | — |
| Expiry date | Jul 6, 2026 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99939
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Methods, computer programs, and database systems for performing a database query to join two or more tables on a condition are disclosed. Each table includes one or more join columns. Each of the join columns includes zero or more join-column values. The method includes excluding join-column values that do not satisfy the condition, using one or more value-count indexes and performing the database query on non-excluded join-column values.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.