Abstract: In an embodiment, a server detects a threshold number of search queries for which the same value at a target node for a document in a semi-structured database is returned as a search result. The server caches the value based on the detection. In another embodiment, the server detects a threshold number of search queries that result in values being returned as search results from a target node. The server caches values at the target node based on the detection. In another embodiment, the server records search result heuristics that indicate a degree to which search results are expected from a set of search queries. The server obtains a merge query and establishes an order in which search queries in the merge query are to be executed based on the recorded search result heuristics.

Abstract: In an embodiment, search parameters in a series of search queries directed to a target node of a semi-structured database are categorized as frequently recurring parameters. A partial search query template is populated with shortcut information related to the search parameters, and then used to facilitate execution of a new search query that includes the same search parameters. In another embodiment, an index is generated that links search parameters that return intermediate search result values to search result values that are configured to be obtained when a search is conducted on the intermediate search result values. The index can be generated based upon monitoring of actual searches within the semi-structured database, or alternatively based upon an inspection of the semi-structured database itself.

Abstract: Disclosed is a method of applying a function to a set of data. Initially a tabular representation of the set of data is displayed, the representation comprising a plurality of columns. The data in the representation is grouped in each column based upon an order of the at least one column in the tabular representation. The method also generates a new column of data comprising a transform of existing column data contained in the tabular representation, wherein transform data within the new column depends upon a grouping context of the existing column data. Desirably the method further repositions the new column of data in the tabular representation and updates the transform data in the new column in accordance with a destination grouping context of a destination position of the new column in the tabular representation.