Partitioned distributed database systems, devices, and methods
First Claim
Patent Images
1. A computer-implemented query system for website query transmission and partial dataset receiving over a computer network connection, the computer-implemented query system comprising:
- a user input device;
an output device; and
one or more processors configured to;
receive, through the user input device, a first user command;
construct a first query based at least in part on the first user command;
send the first query through a network to query a server database on a remote server, wherein the server database comprises records corresponding to a plurality of inventory items, wherein the first query operates on a server partition of the server database that includes a cluster of related records of the server database;
receive, from the remote server, a first response to the first query;
transmit data to the output device to present a website including a result generated based at least in part on the first response, the result comprising data related to one or more of the plurality of inventory items;
receive a plurality of blocks sufficient to form a local partition that comprises at least a portion of the server partition of the server database;
receive, through the user input device, a second user command;
construct a second query based at least in part on the second user command;
after receiving the plurality of blocks;
use the plurality of blocks to construct and locally store a local database comprising the local partition;
determine that the second query references the local database stored in the computer-implemented query system;
execute the second query; and
transmit data to the output device to present, in the website, a second result generated based at least in part on a result of the second query, the second result comprising data related to one or more of the plurality of inventory items.
1 Assignment
0 Petitions
Accused Products
Abstract
A client system can improve processing speeds by executing queries locally. A remote database can have a partitioned, columnar database. Queries from the client can be executed on the remote database, and blocks of a partition of the partitioned, columnar database can be sent to the client. Once the client has enough blocks to form the partition, the client can execute queries that reference the partition. The queries can be executed using templates for specialized expression evaluators.
-
Citations
20 Claims
-
1. A computer-implemented query system for website query transmission and partial dataset receiving over a computer network connection, the computer-implemented query system comprising:
-
a user input device; an output device; and one or more processors configured to; receive, through the user input device, a first user command; construct a first query based at least in part on the first user command; send the first query through a network to query a server database on a remote server, wherein the server database comprises records corresponding to a plurality of inventory items, wherein the first query operates on a server partition of the server database that includes a cluster of related records of the server database; receive, from the remote server, a first response to the first query; transmit data to the output device to present a website including a result generated based at least in part on the first response, the result comprising data related to one or more of the plurality of inventory items; receive a plurality of blocks sufficient to form a local partition that comprises at least a portion of the server partition of the server database; receive, through the user input device, a second user command; construct a second query based at least in part on the second user command; after receiving the plurality of blocks; use the plurality of blocks to construct and locally store a local database comprising the local partition; determine that the second query references the local database stored in the computer-implemented query system; execute the second query; and transmit data to the output device to present, in the website, a second result generated based at least in part on a result of the second query, the second result comprising data related to one or more of the plurality of inventory items. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13)
-
-
14. A computer-implemented method for partial database receiving over a network connection for progressively faster query execution and faster website display, the method comprising:
-
receiving one or more first user commands; constructing one or more first queries based at least in part on the first user commands; determining that at least one of the first queries references a server partition of the database located on a remote server that does not yet have available a corresponding local partition in a client computer system, wherein the database located on the remote server comprises records corresponding to a plurality of inventory items; sending the first queries to the remote server; receiving, from the remote server, one or more first responses to the first queries; receiving blocks to form the local partition of the database; receiving one or more second user commands; constructing one or more second queries based at least in part on the second user commands; after receiving sufficient blocks to form the local partition of the database; determining that the second queries reference the local partition of the database; and executing the second queries. - View Dependent Claims (15, 16, 17, 18)
-
-
19. A server configured to provide faster responses for websites presenting inventory items, the server comprising:
-
one or more storage devices comprising a partitioned, columnar database, wherein the partitioned, columnar database comprises records corresponding to a plurality of inventory items; and one or more processors configured to; receive, from a client system, a first query on the columnar database; determine a server partition of the columnar database referenced by the first query; execute the first query on the server partition of partitioned, columnar database; send a first response to the first query to the client system, the first response comprising data related to one or more of the plurality of inventory items; send one or more first blocks comprising data from the server partition to the client system; receive a second query on the server partition of the partitioned, columnar database; execute the second query on the server partition of the partitioned, columnar database; send a second response to the second query to the client system, the second response comprising data related to one or more of the plurality of inventory items; and send a sufficient number of blocks comprising data from the server partition to the client system for the client system to construct a local partition corresponding to the server partition of the partitioned, columnar database, the sufficient number of blocks including the one or more first blocks. - View Dependent Claims (20)
-
Specification