×

Specification of database table relationships for calculation

  • US 10,102,243 B2
  • Filed: 04/20/2016
  • Issued: 10/16/2018
  • Est. Priority Date: 06/16/2011
  • Status: Active Grant
First Claim
Patent Images

1. A method performed by a system comprising at least one processor coupled to a memory storing machine-executable instructions, which, when executed by the processor, controls the system to perform acts, comprising:

  • receiving a data analysis expression comprising a calculation and a relationship to use for the calculation from multiple relationships between data of two tables of a database;

    overriding a default relationship of the database with the relationship by setting the relationship as active and other relationships of the multiple relationships as inactive;

    retrieving data from the two tables for the calculation based on the active relationship;

    initiating execution of the calculation on the data, wherein execution of the calculation comprises evaluating an expression specified by the calculation on the data retrieved from the two tables;

    restoring the default relationship after execution of the calculation is complete by setting the default relationship as active and other relationships of the multiple relationships as inactive; and

    returning a result of execution of the calculation.

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