Modeling of a non-relational database as a relational database
A system and method are disclosed for modeling a non-relational database as a normalized relational database. In one embodiment, the system identifies a column having a first type in a column-oriented, non-relational database; determines whether the column-oriented, non-relational database includes at least one column having a second type and identifies the one or more columns having the second type; virtually divides the column-oriented, non-relational database based on column type; and generates a normalized, relational model 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, catalog information representing a child table, the parent table and child table both represented as relational tables.
1. A computer-implemented method comprising:
dividing, using one or more processors, a column-oriented, non-relational database based on column type, the column-oriented, non-relational database including a first column having a first type and a second column having a second type; and
generating, using the one or more processors, a relational model of the column-oriented, non-relational database based on the division of the column-oriented, non-relational database, wherein the relational model includes catalog information representing a parent table including the first column having the first type and catalogue information representing a child table including the second column having the second type, wherein the parent table and child table are both represented as relational tables.
2. The computer-implemented method of claim 1 , wherein the division of the column-oriented, non-relational database based on column type is a virtual division.
3. The computer-implemented method of claim 1 , wherein the relational model of the column-oriented, non-relational database is a normalized relational model.
4. The computer-implemented method of claim 3 , wherein one or more columns having the second type, including the second column, are represented as a separate child table in the relational model.
5. 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.
6. The computer-implemented method of claim 1 , wherein the column-oriented, non-relational database is a Cassandra database and uses a version of Cassandra Query Language.
7. The computer-implemented method of claim 1 , wherein the column-oriented, non-relational database table includes a plurality of columns having the second type and the relation model includes catalogue information representing two or more 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.
8. The computer-implemented method of claim 1 , further comprising:
receiving a relational query from a driver;
retrieving the relational model of the column-oriented, non-relational database;
mapping, using the relational model of the column-oriented, non-relational database, the relational query to associated fields and query language for the column-oriented, non-relational database;
generating a non-relational query; and
sending the non-relational query to the column-oriented, non-relational database.
9. The computer-implemented method of claim 8 , wherein the driver is one of a Java Database Connectivity driver and an Open Database Connectivity driver.
10. The computer-implemented method of claim 1 , further comprising:
receiving a non-relational response to a query from the column-oriented, non-relational database;
retrieving the relational model of the column-oriented, non-relational database;
mapping, using the relational model of the column-oriented, non-relational database, the non-relational response to associated fields and query language for a driver that uses a relational query language;
generating a relational response; and
sending the relational response to the driver that uses the relational language.
11. The computer-implemented method of claim 10 , wherein the driver that uses the relational language is one of a Java Database Connectivity driver and an Open Database Connectivity driver.
12. A system comprising:
a processor;
a memory storing instructions that, when executed, cause the system to:
divide a column-oriented, non-relational database based on column type, the column-oriented, non-relational database including a first column having a first type and a second column having a second type; and
generate a relational model of the column-oriented, non-relational database based on the division of the column-oriented, non-relational database, wherein the relational model includes catalog information representing a parent table including the first column having the first type and catalogue information representing a child table including the second column having the second type, wherein the parent table and child table are both represented as relational tables.
13. The system of claim 12 , wherein the division of the column-oriented, non-relational database based on column type is a virtual division.
14. 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.
15. The system of claim 12 , wherein the column-oriented, non-relational database is a Cassandra database and uses a version of Cassandra Query Language.
16. The system of claim 12 , wherein one or more identified columns having the second type, including the second column, are represented as a separate child table in the relational model, wherein the relational model is a normalized, relational model.
17. The system of claim 12 , wherein the column-oriented, 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 relational model of the column-oriented, non-relational database;
map, using the relational model of the column-oriented, non-relational database, the relational query to associated fields and query language for 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 to a query from the column-oriented, non-relational database;
retrieve the relational model of the column-oriented, non-relational database;
map, using the relational model of the column-oriented, non-relational database, the non-relational response to associated fields and query language for a driver that uses a relational query language;
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.