Dynamic database indexes for entity attribute value stores
US10061789B2 · kind B2 · utility
Assignee
Inventor
Key dates
| Filing date | Oct 28, 2013 |
| Grant date | Aug 28, 2018 |
| Priority date | — |
| Expiry date | Feb 11, 2034 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/221
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A system and method for database storage may be dynamically optimized for entity-attribute-value (EAV) data. In one embodiment, this dynamic EAV database may include one column for the entity identification (“ID”) and a second column for the serialized data for that ID (each attribute and the values for those attributes). The database may be dynamically updated to move or copy certain attributes to a separate column. The dynamic updating of one or more attributes may be based on certain factors (seasonal, temporal, usage, etc.), such as frequent requests for a particular attribute. This dynamic updating and indexing of particular attributes may improve certain queries and data requests.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.