Patents by Inventor Collin LeGault

Collin LeGault has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).

  • Storing and processing JSON documents in a SQL database table
    Patent number: 10691682
    Abstract: Embodiments for storing a JSON document tree in a single SQL database table by defining a schema to store JSON nodes in the table and converting each JSON document into a corresponding set of rows in the table using the schema to encode a hierarchical relationship of nodes and sub-nodes into a path that specifies a node path to a root node for each node. Embodiments further receiving a SQL query to retrieve a specific sub-document, responding to the query by returning all rows of the table belonging to the sub-document, and inflating the returned rows back into a JSON expression using the path to guide reconstruction of the original JSON document tree.
    Type: Grant
    Filed: October 4, 2017
    Date of Patent: June 23, 2020
    Assignee: EMC IP Holding Company LLC
    Inventors: Collin LeGault, Vinay Sawal, Bruce Amberden
  • STORING AND PROCESSING JSON DOCUMENTS IN A SQL DATABASE TABLE
    Publication number: 20190102389
    Abstract: Embodiments for storing a JSON document tree in a single SQL database table by defining a schema to store JSON nodes in the table and converting each JSON document into a corresponding set of rows in the table using the schema to encode a hierarchical relationship of nodes and sub-nodes into a path that specifies a node path to a root node for each node. Embodiments further receiving a SQL query to retrieve a specific sub-document, responding to the query by returning all rows of the table belonging to the sub-document, and inflating the returned rows back into a JSON expression using the path to guide reconstruction of the original JSON document tree.
    Type: Application
    Filed: October 4, 2017
    Publication date: April 4, 2019
    Inventors: Collin LeGault, Vinay Sawal, Bruce Amberden