摘要 |
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:
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. |