A method for providing availability of geographic data to enterprise clients. The method is implemented by processing hardware and includes generating a storage storing geographic information available to an enterprise client via an API call, where the enterprise client configured to (i) receive service requests from user devices and (ii) invoke the API to provide, in response to the service requests, information related to geography. When the enterprise client invokes the API to submit a query (304), the method includes: in a first instance, transmitting the query to a geographic service via a communication network (306) and generating a network-based response to the query using geographic information received from the geographic service in response to the query (312), and in a second instance, generating a storage-based response to the query using the geographic information stored in the storage (322).

Distributed pseudo-random subset generation includes obtaining a data-query indicating a first table having a first column including unique values, a second table having a second column including unique values, a join clause joining the first table and the second table on the first column and the second column, and a limit value, pseudo-random filtering the first table to obtain left intermediate data and left filtering criteria, pseudo-random filtering the second table to obtain right intermediate data and right filtering criteria, obtaining intermediate results data by full outer joining the left intermediate data and the right intermediate data, obtaining results data by filtering the intermediate results data using most-restrictive filtering criteria among the left filtering criteria and the right filtering criteria, and outputting the results data, wherein outputting the results data includes limiting the cardinality of rows of the results data to be at most the limit value.

The present disclosure provides a system for performing a method for scaling one or more query processes elastically. The method includes a first step of receiving a request for running the one or more query processes concurrently. In addition, the method includes another step of pre-determining amount of space required for efficient operation and processing of the one or more query processes. Further, the method includes yet another step of creating one or more virtual spaces in a query space outside the data space for efficient running of the one or more query processes. Furthermore, the method includes yet another step of decompressing compressed data stored in the one or more memory regions of the data space requested by the one or more query processes. Moreover, the method includes yet another step of compressing decompressed data present in the virtual space of the one or more virtual spaces.

Efficient aggregation of time series data is disclosed, including: obtaining a first entry value corresponding to an item, wherein the first entry value comprises a first recorded data point that is associated with a first time interval; generating a compressed block based at least in part on compressing the first entry value with at least a second entry value; storing the compressed block in a document corresponding to the item; determining that the item matches an aggregation search query; decompressing the compressed block from the document corresponding to the item to obtain the first entry value and the second entry value; and generating an aggregation result in response to the aggregation search query based on at least a portion of the first entry value and the second entry value.

A database management system includes: a hierarchical database including one primary database, an intermediate database, and end databases; and a searching unit which searches, from registered data in the hierarchical database, for matching data which matches a search criterion. At least the end databases store plural pieces of the registered data. The primary database or the intermediate database includes a virtual data table in which search paths are grouped by common information relating to the plural pieces of the registered data. The search paths lead to the registered data stored in: a next-lower database; or the intermediate database or the end database, each being indirectly connected to the primary database or the intermediate database through the next-lower database. The searching unit adopts, as a starting point of a search, the intermediate database or the end database which involves the common information contained in the search criterion.

Techniques for configuring query result information include decoding a query received from a client device of a network-based database system. A multi-stage execution of the query is configured to obtain a plurality of query result subsets. A combined query result is generated using the plurality of query result subsets. The combined query result further includes storage location information for each of the plurality of query result subsets. The combined query result is encoded for transmission to the client device in response to the query.

Described are methods, systems and computer readable media for GUI control elements and associated processing methods.

The present application relates to database management in a cloud environment. A compute service generates a transaction log for database actions. The compute service writes at least a first portion of the transaction log to a log replica service. The log replica service replicates at least the first portion of the transaction log to two or more local log replicas persisted on solid state drives. A page server service updates database data in a remote storage based on at least a second portion of the transaction log retrieved from at least one of the log replicas. The page server service moves at least the second portion of the transaction log to the remote storage. The log replica service truncates the local log replicas by purging the second portion.

Described are methods, systems and computer readable media for data object publishing/subscribing via a multicast key-value protocol.

A method includes receiving a first signal and updating a bitmap index responsive to the first signal. The bitmap index includes a plurality of bit strings, where a value stored in a particular location in each of the bit strings indicates whether a corresponding signal associated with a signal source has been received. Updating the bitmap index responsive to the first signal includes updating a first bit of the bitmap index and updating first metadata values stored in the bitmap index, wherein the first metadata values comprise a plurality of sort index values indicating relative ranks of the first bit string relative to other bit strings. The method also includes outputting query results based on a query, wherein the query results identify one or more signals associated with one or more bit strings of the plurality of bit strings and one or more signal sources of a plurality of signal sources, and wherein the query results are sorted according to one of the first metadata values.