Integrating vertical partitioning into physical database design
US7366716B2 · kind B2 · utility
20Cited by
4References
20Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | May 6, 2005 |
| Grant date | Apr 29, 2008 |
| Priority date | — |
| Expiry date | Apr 9, 2026 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99933
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Systems and methodologies that split a table into a plurality of sub-tables, and vertical partitions. By analyzing an associated work load to determine frequently referenced columns, the subject invention supplies a compromise among various vertical partitioning strategies (e.g., candidate selection for table spilt) via a merging act, such that the table is split optimally for the work load taken as a whole Accordingly, an incoming query can optimally reference only required columns.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.