Implementing referential integrity in a database hosting service
US7725495B2 · kind B2 · utility
2Cited by
15References
20Claims
0Family size
Assignee
Inventor
Key dates
| Filing date | Apr 11, 2006 |
| Grant date | May 25, 2010 |
| Priority date | — |
| Expiry date | Oct 29, 2028 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24565
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Generally described, embodiments of the present invention provide the ability to assign primary keys and foreign keys to lists of any number of sites that are maintained by a database hosting service. More specifically, a scalable table, like the master table described below, may continue to be used without specifying primary keys or foreign keys within the table by using two additional tables in which the keys are specified for each list of each site. Integrity may be maintained by confirming that all changes to either a primary key or foreign key are appropriate before applying the changes to the master table.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.