Universal database management
AssigneeAmazon Technologies, Inc.
InventorMiles Julian Ward
Life of this patent
Estimating the term…
Abstract
Database messages, such as queries, may be managed to process data based at least in part on performance characteristics. For example, a database query associated with a first database format may be received. The first database format may be one of a plurality of database formats. A second database format may be determined based at least in part on a performance characteristic of the second database format being above a threshold. The second database format may be determined as a result of the received database query. Additionally, the second database format may also be one of the plurality of different database formats. Data communicated by the received database query may be processed according to the second database format.
Claims20
A method comprising:
- under control of one or more computers configured with executable instructions,
- receiving data;
- storing the data in a first database having a first database type;
- storing the data in a second database having a second database type;
- receiving real-time performance information associated with the first database and the second database, the real-time performance information comprising a first efficiency score associated with the first database and a second efficiency score associated with the second database;
- receiving a query;
- determining that a query type of the query corresponds to the second database type;
- revising the query to correspond to the first database type to obtain a revised query;
- sending the revised query to the first database based at least in part on the first efficiency score being higher than the second efficiency score;
- receiving reply data responsive to the revised query;
- and
- outputting the reply data responsive to the revised query.
A system comprising:
- a processor;
- a computer-readable medium coupled to the processor, the computer readable-medium including computer executable instructions to configure the processor to perform operations comprising:
- receiving a first query;
- storing data associated with the first query in a first database, the first database having data of a first format;
- storing the data associated with the first query in a second database, the second database having data of a second format;
- receiving a second query corresponding to the second format;
- analyzing efficiency information associated with the first format and the second format to determine a first efficiency score corresponding to the first database is greater than a second efficiency score corresponding to the second database;
- converting the second query into the first format based at least in part on the efficiency information;
- sending the second query to the first database;
- receiving data responsive to the second query;
- and
- outputting the data responsive to the second query.
A method, comprising:
- under control of one or more computer systems configured with executable instructions,
- receiving a first query;
- storing data associated with the first query in each of a plurality of databases;
- receiving real-time performance information associated with the plurality of databases, the real-time performance information including efficiency data;
- determining, based at least in part on the real-time performance information, a subset of the plurality of databases with an efficiency score above a threshold, the subset of the plurality of databases sharing a first type;
- receiving a second query of a second type;
- converting the second query to the first query type;
- sending the second query to at least one database of the subset of the plurality of databases;
- receiving data responsive to the second query;
- and
- outputting the data responsive to the second query.
Dependencies are inferred from the claim text.