×

Dynamic data management

  • US 9,569,511 B2
  • Filed: 07/26/2012
  • Issued: 02/14/2017
  • Est. Priority Date: 08/25/2011
  • Status: Active Grant
First Claim
Patent Images

1. A method for accessing data, the method comprising:

  • receiving, with a server having one or more processors, a user query formatted according to a relational database query language utilized for a first database of a first database format, wherein the user query is utilized against unstructured data and structured data in the first database, wherein the unstructured data is stored in a second database of distributed, non-relational, semi-structured database format and utilizes a different query language than the first database and the user query;

    requesting, with the one or more processors and in response to the user query, the structured data from the first database;

    receiving, from the first database and with the one or more processors, in response to the requesting, the structured data from the first database;

    requesting, with the one or more processors and in response to the user query, the unstructured data from the second database using a unstructured data request created from the user query, wherein the unstructured data request is formatted according to the different query language;

    receiving, from the second database, with the one or more processors, in response to the requesting, the unstructured data including at least a set of data groups, each data group having a set of one or more values, each value of a respective data group being associated with a different tag;

    determining, in response to receiving the unstructured data, with the one or more processors, a first number of data groups in the unstructured data;

    determining, in response to receiving the unstructured data, with the one or more processors, a second number of unique tags across the data groups of the unstructured data;

    creating, with the one or more processors, a table in the first database format, wherein the number of columns of the table is based on the second number of unique tags, and the number of rows of the table corresponds to the first number of data groups;

    generate a populated table by populating, with the one or more processors, each row of the table with the unstructured data of a respective data group by adding each value to the column corresponding to the associated tag;

    creating, with the one or more processors, a joined table comprising data of the populated table and the structured data from the first database;

    applying, with the one or more processors, the user query to the joined table to obtain a query result; and

    transmitting, with the one or more processors, the query result to the user device.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×