Modeling of a non-relational database as a normalized relational database

1. A computer-implemented method comprising:

identifying, using one or more processors, a column having a first type in a column-oriented, non-relational database;

determining, using one or more processors, whether the column-oriented, non-relational database includes at least one column having a second type;

responsive to determining that column-oriented, non-relational database includes at least one column having the second type, identifying, using one or more processors, the one or more columns having the second type;

virtually dividing, using one or more processors, the column-oriented, non-relational database based on column type; and

generating, using one or more processors, a normalized, relational model of the column-oriented, non-relational database based on the virtual division of the column-oriented, non-relational database, the normalized, relational model including catalog information representing a parent table including the column having the first type and, when the column-oriented, non-relational database includes at least one column having the second type, catalogue information representing a child table, the parent table and child table both represented as relational tables.

2. The computer-implemented method of claim 1 , wherein the catalogue information representing the parent table includes each column in the column-oriented, non-relational database having the first type.

3. The computer-implemented method of claim 1 , wherein the column-oriented, non-relational database is a Cassandra database and uses Cassandra Query Language version 2.

4. The computer-implemented method of claim 1 , wherein the column-oriented, non-relational database is a Cassandra database and uses Cassandra Query Language version 3.

5. The computer-implemented method of claim 1 , wherein the one or more identified columns having the second type are represented as a separate child table in the normalized, relational model.

6. The computer-implemented method of claim 1 , wherein the non-relational database table includes a plurality of columns having the second type and the relation model includes catalogue information representing at least two child tables including a first child table including a first set of the plurality of columns having the second type and a second child table including a second set of the plurality of columns having the second type.

7. The computer-implemented method of claim 1 , further comprising:

receiving a relational query from a driver;

retrieving the normalized, relational model of the column-oriented, non-relational database;

mapping the relational query to associated fields and query language for the column-oriented, non-relational database using the normalized, relational model of the column-oriented, non-relational database;

generating a non-relational query; and

sending the non-relational query to the column-oriented, non-relational database.

8. The computer-implemented method of claim 7 , wherein the driver is one of a Java Database Connectivity driver and an Open Database Connectivity driver.

9. The computer-implemented method of claim 1 , further comprising:

receiving a non-relational response from the column-oriented, non-relational database;

retrieving the normalized, relational model of the column-oriented, non-relational database;

mapping the non-relational response to associated fields and query language for a driver that uses a relational query language using the normalized, relational model of the column-oriented, non-relational database;

generating a relational response; and

sending the relational response to the driver that uses the relational language.

10. The computer-implemented method of claim 9 , wherein the driver that uses the relational language is one of a Java Database Connectivity driver and an Open Database Connectivity driver.

11. A computer program product comprising a non-transitory computer usable medium including a computer readable program, wherein the computer readable program when executed on a computing device causes the computing device to:

identify a column having a first type in a column-oriented, non-relational database;

determine whether the column-oriented, non-relational database includes at least one column having a second type;

responsive to determining that column-oriented, non-relational database includes at least one column having the second type, identifying, using one or more processors, the one or more columns having the second type;

virtually divide the column-oriented, non-relational database based on column type; and

generate a normalized, relational model of the column-oriented, non-relational database based on the virtual division of the column-oriented, non-relational database, the normalized, relational model including catalog information representing a parent table including the column having the first type and, when the column-oriented, non-relational database includes at least one column having the second type, catalogue information representing a child table, the parent table and child table both represented as relational tables.

12. A system comprising:

a processor;

a memory storing instructions that, when executed, cause the system to:

identify a column having a first type in a column-oriented, non-relational database;

determine whether the column-oriented, non-relational database includes at least one column having a second type;

responsive to determining that column-oriented, non-relational database includes at least one column having the second type, identifying, using one or more processors, the one or more columns having the second type;

virtually divide the column-oriented, non-relational database based on column type; and

generate a normalized, relational model of the column-oriented, non-relational database based on the virtual division of the column-oriented, non-relational database, the normalized, relational model including catalog information representing a parent table including the column having the first type and, when the column-oriented, non-relational database includes at least one column having the second type, catalogue information representing a child table, the parent table and child table both represented as relational tables.

13. The system of claim 12 , wherein the catalogue information representing the parent table includes each column in the column-oriented, non-relational database having the first type.

14. The system of claim 12 , wherein the column-oriented, non-relational database is a Cassandra database and uses Cassandra Query Language version 2.

15. The system of claim 12 , wherein the column-oriented, non-relational database is a Cassandra database and uses Cassandra Query Language version 3.

16. The system of claim 12 , wherein the one or more identified columns having the second type are represented as a separate child table in the normalized, relational model.

17. The system of claim 12 , wherein the non-relational database table includes a plurality of columns having the second type and the relation model includes catalogue information representing at least two child tables including a first child table including a first set of the plurality of columns having the second type and a second child table including a second set of the plurality of columns having the second type.

18. The system of claim 12 , the memory further storing instructions that, when executed, cause the system to:

receive a relational query from a driver;

retrieve the normalized, relational model of the column-oriented, non-relational database;

map the relational query to associated fields and query language for the column-oriented, non-relational database using the normalized, relational model of the column-oriented, non-relational database;

generate a non-relational query; and

send the non-relational query to the column-oriented, non-relational database.

19. The system of claim 12 , the memory further storing instructions that, when executed, cause the system to:

receive a non-relational response from the column-oriented, non-relational database;

retrieve the normalized, relational model of the column-oriented, non-relational database;

map the non-relational response to associated fields and query language for a driver that uses a relational query language using the normalized, relational model of the column-oriented, non-relational database;

generate a relational response; and

send the relational response to the driver that uses the relational language.

20. The system of claim 12 , wherein the system includes one of a Java Database Connectivity driver and an Open Database Connectivity driver.