Back to results
US 8,898,143 B2Granted
Database comparison system and method
AssigneeSap SE
InventorMarco Valentin
Life of this patent
Estimating the term…
Abstract
A system and method include receiving a request for data at a programmed computer, the request identifying a field and an operation for an embedded database, translating the request via the programmed computer into multiple requests tailored to schemas of multiple different databases, estimating a cost to execute the request against each of the multiple different databases, and identifying the database that can execute the request with the least cost.
Claims20
A method comprising:
- receiving a transaction request for data at a programmed computer, the transaction request identifying a field and an operation for an embedded database to obtain a transaction result, including forming an aggregated value;
- converting the transaction request having embedded database internal structures into a request having a standardized structure that can be understood by multiple different databases, wherein the embedded database is an in memory database;
- translating the request via the programmed computer into multiple requests tailored to schemas of multiple different databases;
- identifying connections to the multiple different databases;
- estimating a cost to execute the request against each of the multiple different databases;
- and
- identifying the database that can execute the request with the least cost.
4 more elements
A computer readable storage device having instructions stored thereon for causing a computer to perform a method, the method comprising:
- receiving a transaction request for data at a programmed computer, the transaction request identifying a field and an operation for an embedded database to obtain a transaction result, including forming an aggregated value;
- converting the transaction request having embedded database internal structures into a request having a standardized structure that can be understood by multiple different databases;
- translating the request via the programmed computer into multiple requests tailored to schemas of multiple different databases;
- identifying connections to the multiple different databases;
- estimating a cost to execute the request against each of the multiple different databases;
- and
- identifying the database that can execute the request with the least cost.
4 more elements
A system comprising:
- a user interface generator to receive a request for data, the request identifying a field and an operation for an embedded database to obtain a transaction result, including forming an aggregated value;
- a module to convert the transaction request having embedded database internal structures into a request having a standardized structure that can be understood by multiple different databases;
- a translator to translate the request via the programmed computer into multiple requests tailored to schemas of multiple different databases;
- a module to identify connections to the multiple different databases;
- and
- an estimator to determine a cost to execute the request against each of the multiple different databases and identify the database that can execute the request with the least cost.
3 more elements
Dependencies are inferred from the claim text.