×

Schema tool for non-relational databases

  • US 10,489,355 B1
  • Filed: 11/20/2013
  • Issued: 11/26/2019
  • Est. Priority Date: 11/20/2013
  • Status: Active Grant
First Claim
Patent Images

1. A computer-implemented method comprising:

  • identifying, using one or more processors, a non-relational database including a nested object;

    obtaining, using the one or more processors, a data structure of the non-relational database, wherein the non-relation database is semi-structured in that it lacks consistency ensured by a logical schema;

    obtaining, using the one or more processors, a selection of the nested object by a user;

    generating, using the one or more processors, a virtual, relational schema that includes a first virtual, relational table and a second virtual, relational table and, at least partially, normalizes the nested object to the second virtual, relational table, andwherein generating the virtual, relational schema includes;

    generating a mapping of the data structure of the non-relational database to the first virtual, relational table and the second virtual, relational table, anddefining a relation between the first virtual, relational table and the second virtual, relational table so that the virtual, relational schema is usable to obtain data, stored in the non-relational database, from the non-relational database responsive to a relational query;

    receiving the relational query, the relational query using a relational language;

    translating, using the virtual, relational schema, the relational query into a non-relational query for the non-relational database;

    receiving a first result from the non-relational database responsive to the non-relational query;

    translating, using the virtual, relational schema, the first result from the non-relational database into a second result, the second result using the relational language; and

    transmitting the second result in response to the relational query.

View all claims
  • 6 Assignments
Timeline View
Assignment View
    ×
    ×