| US 7,472,140 B2 | ||
| Label-aware index for efficient queries in a versioning system | ||
| Nipun Agarwal, Santa Clara, Calif. (US); Sam Idicula, San Jose, Calif. (US); Thomas Baby, Foster City, Calif. (US); and Eric Sedlar, San Francisco, Calif. (US) | ||
| Assigned to Oracle International Corporation, Redmond Shores, Calif. (US) | ||
| Filed on Dec. 20, 2005, as Appl. No. 11/313,526. | ||
| Prior Publication US 2007/0143363 A1, Jun. 21, 2007 | ||
| Int. Cl. G06F 17/30 (2006.01) | ||
| U.S. Cl. 707—203 [707/1; 707/2; 707/3; 707/101; 707/200] | 22 Claims |

| 1. A computer-implemented method comprising:
receiving a database statement for searching across resources, associated with a particular label of a plurality of labels,
in a repository,
wherein each label of the plurality of labels (a) is associated with no more than one version of any particular resource and
(b) is associated with a different label identifier;
wherein the plurality of labels are separate and distinct from any version information that indicates the version of each
resource, in the repository, relative to other versions of said each resource;
in response to receiving the database statement, executing the database statement; and
during execution of the database statement:
traversing a particular index based, at least in part, on a label identifier that is associated with the particular label,
to locate entries within the particular index that are associated with the label identifier, wherein the particular index
indexes multiple versions of multiple resources;
accessing resources associated with the particular label based on information from the entries associated with the label identifier;
and
generating output in response to accessing the resources associated with the particular label based on information from the
entries associated with the label identifier.
|