Disclosed are various embodiments for validating documents using a blockchain data. Multiple documents can be included in the validation process using a merge and hash process and a summary terms document. Validation can be performed by hashing and merging operations, followed by comparing hash values.

Processing a database table comprises receiving a multi-dimensional processing instruction for processing at least two columns of the database table, wherein the two columns comprise a selection column and a sort column, wherein the multi-dimensional processing instruction is for selecting a plurality of candidate rows by sorting based on the selection column and the sort column. An index takes the selection column as master column and the sort column as slave column. Nodes in the index are selected according to the selection column. Each of the selected nodes is associated with a respective slave column value sequence. A merge sort is performed on each of the slave column value sequences to obtain a sort result for the candidate rows.

Processing a database table comprises receiving a multi-dimensional processing instruction for processing at least two columns of the database table, wherein the two columns comprise a selection column and a sort column, wherein the multi-dimensional processing instruction is for selecting a plurality of candidate rows by sorting based on the selection column and the sort column. An index takes the selection column as master column and the sort column as slave column. Nodes in the index are selected according to the selection column. Each of the selected nodes is associated with a respective slave column value sequence. A merge sort is performed on each of the slave column value sequences to obtain a sort result for the candidate rows.

According to embodiments of the present invention, apparatus, systems, methods and computer program products for sorting and compressing an unordered set of data records from a structured database are provided. Fields of the unordered set of data records are prioritized based on an impact of those fields to a compression scheme for column-oriented compression. The unordered set of data records are sorted based on the prioritized field(s) with a greatest impact on the performance metric. Data of the sorted data records are compressed according to a compression scheme. In some embodiments, prioritizing the fields may be based on an anticipated level of usage of data within those fields and/or a cost function associated with a performance metric as well as optimization of compression. A performance metric may include a faster computational time, reduced I/O computation, faster scan time, etc.

According to embodiments of the present invention, apparatus, systems, methods and computer program products for sorting and compressing an unordered set of data records from a structured database are provided. Fields of the unordered set of data records are prioritized based on an impact of those fields to a compression scheme for column-oriented compression. The unordered set of data records are sorted based on the prioritized field(s) with a greatest impact on the performance metric. Data of the sorted data records are compressed according to a compression scheme. In some embodiments, prioritizing the fields may be based on an anticipated level of usage of data within those fields and/or a cost function associated with a performance metric as well as optimization of compression. A performance metric may include a faster computational time, reduced I/O computation, faster scan time, etc.

Embodiments relate to systems and methods for tracking local and remote file usage, and aggregating the resulting file usage statistics for presentation to a user. The operating system of a local computer can cause presentation of a merged list of unified file usage information, wherein the merged list of unified file usage information comprises a first representation of the local file associated with local file usage information and a second representation of a Web application file associated with remote file usage information from a remote network host. The operating system can further receive a selection of at least one of the local file or the Web application file from the merged list of unified file usage information, determine, using saved preference information, a default application with which to open the at least one of the local file or the Web application file, and, responsive to a request, open the at least one of the local file or the Web application file with an application other than the default application.

Embodiments relate to systems and methods for tracking local and remote file usage, and aggregating the resulting file usage statistics for presentation to a user. The operating system of a local computer can cause presentation of a merged list of unified file usage information, wherein the merged list of unified file usage information comprises a first representation of the local file associated with local file usage information and a second representation of a Web application file associated with remote file usage information from a remote network host. The operating system can further receive a selection of at least one of the local file or the Web application file from the merged list of unified file usage information, determine, using saved preference information, a default application with which to open the at least one of the local file or the Web application file, and, responsive to a request, open the at least one of the local file or the Web application file with an application other than the default application.

A computer-implemented method for indexing metadata which corresponds to data stored in a storage system, according to one embodiment, includes: identifying a subset of metadata stored in a first data store to archive in response to determining that an amount of metadata stored in the first data store has reached a threshold, identifying an index for storing information about the subset of the metadata, executing a sort operation on the subset of the metadata, generating index information corresponding to the subset of the metadata, writing the subset of the metadata to an archive medium, and recording the index information in the identified index. Other systems, methods, and computer program products are described in additional embodiments.

A computer-implemented method for indexing metadata which corresponds to data stored in a storage system, according to one embodiment, includes: identifying a subset of metadata stored in a first data store to archive in response to determining that an amount of metadata stored in the first data store has reached a threshold, identifying an index for storing information about the subset of the metadata, executing a sort operation on the subset of the metadata, generating index information corresponding to the subset of the metadata, writing the subset of the metadata to an archive medium, and recording the index information in the identified index. Other systems, methods, and computer program products are described in additional embodiments.

An embodiment may involve: transmitting a first graphical user interface (GUI) that allows selection of a plurality of item streams for a mobile user interface; receiving a selection of a first item stream; transmitting a second GUI, where the first item stream is populated from a first database table and the second GUI allows selection of a first field from the first database table; receiving a selection of a second item stream; transmitting the second GUI, where the second item stream is populated from a second database table and the second GUI allows selection of a second field from the second database table, where the first and second fields are of a common type; and transmitting, to a mobile device, the mobile user interface with items from the first and second item streams sorted according to values in the first and second fields.