Back to results
US 9,135,297 B2Granted
Database translation system and method
AssigneeGreen Sql Ltd
InventorsDavid Maman, Yuli Stremovsky
Life of this patent
Estimating the term…
Abstract
A system and method for translating database queries across a plurality of different database platforms, regardless of the database protocol and/or structure according to which the database operates.
Claims15
A method for translating of queries for interaction with a plurality of different database types, comprising:
- providing a plurality of specific front ends, each front end relating to a specific query language, and a plurality of specific back ends, each back end relating to a specific query language, and a translating apparatus for translating between query languages;
- sending a query by an accessing application to one of said plurality of front ends at said translating apparatus;
- receiving said query by said translating apparatus to form a received query;
- translating said received query to a specific query language of a database to which said query is to be addressed to form a database query;
- and sending said database query in said specific query language by one of the specific back ends to said database;
- wherein said receiving said query by said translating apparatus comprises determining a query language of said received query and a query language of said database query;
- wherein said translating said query comprises analyzing said query;
- decomposing said query into a plurality of query portions;
- and not translating at least one portion;
- wherein said sending said query comprises sending said non-translated portion to said database as raw data;
- wherein said sending said non-translated portion further comprises also sending a message indication at least one parameter of said raw data.
8 more elements
A system for translating of queries for interaction with a plurality of different database types, comprising:
- a plurality of databases of at least two different database types running on a plurality of servers;
- an accessing application running on at least one computer for sending a query;
- a translation apparatus running on at least one server for receiving said query, for determining a query language of said received query, for determining the receiving database from at least one of said plurality of databases, for determining a query language of said receiving database, for translating said query according to requirements of said receiving database, and for sending said translated query to said receiving database, wherein said translation apparatus comprises a plurality of specific front ends, each front end relating to a specific query language, and wherein said query is received by one of said front ends;
- wherein said translating said query by said translation apparatus comprises analyzing said query;
- decomposing said query into a plurality of query portions;
- and not translating at least one portion;
- wherein said sending said query by said translation apparatus comprises sending said non-translated portion to said receiving database as raw data;
- wherein said sending said non-translated portion further comprises also sending a message indication at least one parameter of said raw data.
5 more elements
Dependencies are inferred from the claim text.