Schema Definition Tool

摘要

Methods, systems, computer-readable media, and apparatuses for providing schema definition generation and management to enable a relational query tool to access data in a non-relational database. The schema definition tool may sample a non-relational database to produce a sample set of a table of the non-relational database and may generate multiple linked virtual tables to represent arrays in the sample set as scalar values. The schema definition tool may then automatically generate a table definition for each real and virtual table of the non-relational database to produce a schema definition representing the structure of the non-relational database. A relational query tool may now use the schema definition to format relational queries or commands to access data residing in the non-relational database.

主权项

1. A system comprising:
a non-relational database; a first server communicatively coupled to the non-relational database; and a computing device communicatively coupled to the first server, wherein the computing device comprises a processor and a computer readable medium storing instructions that, when executed by the processor, cause the computing device to: transmit, from the computing device to the first server, instructions to sample and filter one or more tables residing in the non-relational database; receive, from the first server, a sample set of the one or more tables that meets constraints provided in the instructions; determine that a cell of a first table, of the one or more tables, includes an array; determine a number of elements in the array; generate a virtual table that duplicates the first table; replace a column of the virtual table that includes the array with a column representing the number of elements in the array; and generate a schema definition for the non-relational database that includes a table definition of the virtual table.