US 11,899,631 B1
Schema tool for non-relational databases
Broderick Messmer, Raleigh, NC (US); Justin Moore, Clayton, NC (US); and Philip Prudich, Cary, NC (US)
Assigned to PROGRESS SOFTWARE CORPORATION, Burlington, MA (US)
Filed by Progress Software Corporation, Burlington, MA (US)
Filed on Jul. 25, 2022, as Appl. No. 17/873,004.
Application 17/873,004 is a continuation of application No. 16/691,155, filed on Nov. 21, 2019, granted, now 11,397,710.
Application 16/691,155 is a continuation of application No. 14/085,557, filed on Nov. 20, 2013, granted, now 10,489,355, issued on Nov. 26, 2016.
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/00 (2019.01); G06F 16/21 (2019.01)
CPC G06F 16/211 (2019.01) 15 Claims
OG exemplary drawing
 
1. 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.