Efficient path-based operations while searching across versions in a repository

A method comprising the steps of:

• receiving a database statement that specifies a particular path and does not specify any version information;
• and
• in response to receiving the database statement:
• determining that at least a first path, satisfies the particular path, wherein the first path identifies a first hierarchical location in a first hierarchy,
• determining that a particular version of a particular versioned resource resides at the first hierarchical location,
• after determining that the particular version resides at the first hierarchical location, searching for other versions of the particular versioned resource,
• as a result of said searching, identifying a plurality of versions of the particular versioned resource, wherein each of the plurality of versions (a) is different than the particular version and (b) resides at a hierarchical location that is identified by a path that does not satisfy any path specified in the database statement, and
• generating, based on the plurality of versions, results of the database statement;
• wherein the steps are performed on one or more computing devices.

One or more storage media storing instructions which, when executed by one or more processors, cause:

• receiving a database statement that specifies a particular path and does not specify any version information;
• and
• in response to receiving the database statement:
• determining that at least a first path, satisfies the particular path, wherein the first path identifies a first hierarchical location a first hierarchy,
• determining that a particular version of a particular versioned resource resides at a first hierarchical location,
• after determining that the particular version resides at the first hierarchical location, searching for other versions of the particular versioned resource,
• as a result of said searching, identifying a plurality of versions of the particular versioned resource, wherein each of the plurality of versions (a) is different than the particular version and (b) resides at a hierarchical location that is identified by a path that does not satisfy any path specified in the database statement, and
• generating, based on the plurality of versions, results of the database statement.

One or more storage media storing instructions which, when executed by one or more processors, cause:

• receiving a database statement that specifies a particular path and one or more conditions relating to either content of one or more resources or metadata associated with the one or more resources;
• and
• in response to receiving the database statement:
• identifying a first set of versions, of one or more versioned resources, that satisfy the one or more conditions in the database statement;
• determining, from among the first set of versions, a second set of one or more versions by determining which versions of the first set of versions are versions of any versioned resource that has any version that satisfies the particular path;
• wherein the second set of one or more versions includes a particular version of a particular versioned resource;
• wherein a path that identifies a hierarchical location of the particular version does not satisfy the particular path;
• wherein a version of the particular versioned resource other than the particular version satisfies the particular path;
• generating, based on the second set of one or more versions, a result of the database statement.