×

System and method for dynamic attribute table

  • US 10,346,769 B1
  • Filed: 03/14/2014
  • Issued: 07/09/2019
  • Est. Priority Date: 03/14/2014
  • Status: Active Grant
First Claim
Patent Images

1. A computer-implemented method for generating attribute tables for holding attributes while a corresponding business plan is in an approval process over a computer network comprising:

  • storing a plurality of records in a distributed memory, the distributed memory comprising a plurality of nodes, each node comprising a local memory configured to store a local portion of the plurality of records, and a processor configured to perform an operation using the local portion of the plurality of records upon request;

    receiving a request over a network to generate an attribute table corresponding to a business plan, wherein the business plan comprises at least one user input that describes a feature of the business plan;

    generating at least one attribute corresponding to the at least one user input;

    automatically generating an attribute table for storing attribute data therein that corresponds to the at least one attribute, the attribute table defined by a record column file including a data placement structure determining how the attribute table will be stored on the plurality of nodes;

    transmitting a node-specific request to each node of the plurality of nodes, the node-specific request instructing the node to return attribute data corresponding to the fields of the attribute table based on the local portion of the plurality of records stored in the node in order to reduce the amount of network traffic and prevent unnecessary data transfer;

    appending the record column file while at least one node is performing an operation to respond to the node-specific request with at least one Hive record columnar variable that was uncaptured by a schedule coordinator previously executing at least one Hive Query Language query, thereby changing the resulting attribute data to include the at least one previously uncaptured Hive record columnar variable;

    concurrent with the appending of the record column file, automatically amending metadata associated with the at least one previously uncaptured Hive record columnar variable to reflect the changed attribute data, the metadata being available for a subsequent header read;

    automatically aggregating the requested attribute data from the database;

    automatically populating the fields within the table with the aggregated attribute data; and

    generating a report conveying aggregated attribute information corresponding to the business plan.

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