Abstract: Architecture for security trimming results in a document version environment. Versioned documents are stored with metadata that includes associated access rights. All versions are searched using multiple user accounts of varying levels of access that correspond to the document versions. Result sets are returned for each user account and trimmed during a merge process by considering the user rights associated with each of multiple versions of objects or documents. Each document metadata includes a scope ID that defines security rights for that document. In a two-version document (major and minor) implementation, successive queries are run as a user with rights to all minor versions, and as a user with rights to all major items, but not the minor items. The result sets are merged into a final trimmed result set by examining the rights to each item in the versioned sets that align with rights of the current user.

Abstract: Efficient querying across disparate schemas can be implemented by initially limiting the total number of lists and the total number of items queried and by using a mechanism for aligning data during the query. Querying across disparate data (e.g., data that is stored in accordance with disparate schemas) can comprise removing lists that are not applicable, defining a data alignment for the lists being searched, and executing the query.

Abstract: User-structured data tables can be queried more efficiently by storing a copy of the important data from a user-structured data base table in one or more special indexes. A special index normally comprises Name Value Pairs (NVP) that can be used to efficiently query the important data by using the database indexes. Efficient querying can be accomplished by creating a separate table for a user-structured table, indexing the separate table using NVPs; and creating multiple tables in a collation order in order to search data that is sorted in accordance with user conventions in various locales.

Abstract: Architecture for security trimming results in a document version environment. Versioned documents are stored with metadata that includes associated access rights. All versions are searched using multiple user accounts of varying levels of access that correspond to the document versions. Result sets are returned for each user account and trimmed during a merge process by considering the user rights associated with each of multiple versions of objects or documents. Each document metadata includes a scope ID that defines security rights for that document. In a two-version document (major and minor) implementation, successive queries are run as a user with rights to all minor versions, and as a user with rights to all major items, but not the minor items. The result sets are merged into a final trimmed result set by examining the rights to each item in the versioned sets that align with rights of the current user.