Schema tool for non-relational databases
AssigneeProgress Software Corporation
InventorsBroderick Messmer, Justin Moore, Philip Prudich
Life of this patent
Estimating the term…
Abstract
A system and method for defining a relational schema for a non-relational database are disclosed. In one embodiment, the system identifies a non-relational database; obtains a data structure of the non-relational database; determines a relational schema type; generates a relational schema based on the determined schema type; determines whether the relational schema includes a plurality of relational tables; and responsive to determining that the relational schema includes a plurality of relational tables, defines a relation between at least two of the relational tables in the relational schema.
Claims15
A computer-implemented method comprising:
- generating, using one or more processors, a mapping of a data structure of a non-relational database to a first virtual, relational table and a second virtual, relational table, wherein the data structure of the non-relational database includes a nested object that is at least partially normalized to the second, virtual relational table;
- and
- defining, using the one or more processors, a relation between the first virtual, relational table and the second virtual, relational table,
- wherein the first virtual, relational table, the second virtual, relational table, and the relation between the first virtual, relational table and the second virtual, relational table are included in a virtual, relational schema usable to obtain data from the non-relational database responsive to a relational query,
- wherein the nested object includes an array, and the nested object is at least partially normalized based on a characteristic of the array.
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:
- generate a mapping of a data structure of a non-relational database to a first virtual, relational table and a second virtual, relational table, wherein the data structure of the non-relational database includes a nested object that is at least partially normalized to the second, virtual relational table;
- and
- define a relation between the first virtual, relational table and the second virtual, relational table,
- wherein the first virtual, relational table, the second virtual, relational table, and the relation between the first virtual, relational table and the second virtual, relational table are included in a virtual, relational schema usable to obtain data from the non-relational database responsive to a relational query,
- wherein the nested object includes an array, and the nested object is at least partially normalized based on a characteristic of the array.
A system comprising:
- a processor;
- a memory storing instructions that, when executed, cause the system to:
- generate a mapping of a data structure of a non-relational database to a first virtual, relational table and a second virtual, relational table, wherein the data structure of the non-relational database includes a nested object that is at least partially normalized to the second, virtual relational table;
- and
- define a relation between the first virtual, relational table and the second virtual, relational table,
- wherein the first virtual, relational table, the second virtual, relational table, and the relation between the first virtual, relational table and the second virtual, relational table are included in a virtual, relational schema usable to obtain data from the non-relational database responsive to a relational query,
- wherein the nested object includes an array, and the nested object is at least partially normalized based on a characteristic of the array.
Dependencies are inferred from the claim text.