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: 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: 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: An apparatus and method are provided for analyzing traffic on a network by monitoring packets sent between devices on the network and identifying applications occurring between devices on the network based on information derived from monitoring the packets. Techniques are provided to examine header information of the packets, such as information in the header of Internet Protocol (IP) packets, to identify applications that are occurring on the network. In some cases, information about the packet beyond the header information is examined to match a packet to a particular application. Using these techniques, a list is built of all of the applications occurring between devices on the network. Parameters may be generated to track one or more of the response time, latency and traffic volume associated with a particular device on the network.

Abstract: A technique for measuring delay variation (jitter) of data traffic (protocol data units (PDUs)) traversing a communication network involves: generating first PDU identifiers of PDUs observed at a first point and corresponding first timestamps indicating observation times of the PDUs at the first point; generating second PDU identifiers of PDUs observed at a second point and corresponding second timestamps indicating observation times of the PDUs at the second point; and computing, from first and second timestamps having matching PDU identifiers, a measure of variation indicating a delay variation of PDUs between the first and second points.