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.
Claims18
A computer-implemented method comprising:
- generating, using one or more processors, a virtual, relational schema based on a non-relational database, wherein the non-relational database includes a nested object, wherein the virtual, relational schema:
- includes a first virtual, relational table and a second virtual, relational table;
- normalizes at least a portion of the nested object to the second virtual, relational table;
- and
- is useable to obtain data from the non-relational database responsive to a relational query.
A system comprising:
- a processor;
- a memory storing instructions that, when executed, cause the system to:
- generate a virtual, relational schema based on a non-relational database, wherein the non-relational database includes a nested object, wherein the virtual, relational schema:
- includes a first virtual, relational table and a second virtual, relational table;
- normalizes at least a portion of the nested object to the second virtual, relational table;
- and
- is useable to obtain data from the non-relational database responsive to a relational query.
Dependencies are inferred from the claim text.