DATABASE TRANSLATION SYSTEM AND METHOD

• US 20130060803A1
• Filed: 05/17/2011
• Published: 03/07/2013
• Est. Priority Date: 05/17/2010
• Status: Active Grant

• Current Assignee: HexaTier Services Ltd.
• Original Assignee: Green SQL Limited
• Inventors: Maman, David, Stremovsky, Yuli
• Granted Patent: US 9,135,297 B2
• Time in Patent Office: Days
• US Class Current: 707/760
• CPC Class Codes: G06F 16/2452 Query translation

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.

Claims

1. A method for translating of queries for interaction with a plurality of different database types, comprising:

providing a front end, 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 said front end 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.

2. The method of claim 1, 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.

3. The method of claim 2, wherein said determining said query language of said received comprises analyzing said query language of said received query.

4. The method of claim 2, wherein said determining said query language of said received query comprises detecting a port or address receiving said query.

5. The method of claim 4, further comprising providing a plurality of specific front ends, each front end having a specific port or address, each front end relating to a specific query language.

6. The method of claim 1, 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.

7. The method of claim 6, wherein said sending said query comprises sending said non-translated portion to said database as raw data.

8. The method of claim 7, wherein said sending said non-translated portion further comprises also sending a message indicating at least one parameter of said raw data.

9. The method of claim 1, wherein said translation apparatus for translating said query is separate from said database.

10. The method of claim 1, wherein said translation apparatus comprises a translation interface operated by the same hardware as said database.

11. The method of claim 1, wherein said database comprises a plurality of databases, of which at least one has a different format, database protocol, structure and/or query language.

12. The method of claim 1, further comprising translating said results and passing said translated results to said query application by said front end.

13. The method of claim 1, wherein said translating said query further comprises determining whether said translated query and response are stored at a storage outside of said database;

and if so, returning said response stored at said storage outside of said database.

14. The method of claim 1, wherein said query languages comprise SQL.

15. The method of claim 1, wherein said query languages are limited to SQL.

16. 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;

an accessing application for sending a query;

a translation apparatus for receiving said query and for translating said query, and for sending said translated query to at least one of said plurality of databases to form a receiving database, wherein said translated query is translated according to requirements of said receiving database.

17. The system of claim 16, wherein said translation apparatus further comprises a front end for receiving said query and a back end for providing said query to said database.

18. The system of claim 17, wherein said query languages comprise SQL.

19. The system of claim 17, wherein said query languages are limited to SQL.