×

Systems, methods and techniques for polymorphic queries

  • US 10,496,641 B2
  • Filed: 07/09/2018
  • Issued: 12/03/2019
  • Est. Priority Date: 09/05/2012
  • Status: Active Grant
First Claim
Patent Images

1. A method for polymorphic selection of data from a database storing data on at least one memory device and managed by one or more hardware processors, the method comprising:

  • receiving, with the one or more processors, a request that has at least a database query comprising at least an expression using a polymorphic relationship and a SELECT clause;

    adding, with the one or more processors, a TYPEOF expression to the SELECT clause to function as a case expression to allow specification of fields of a related parent object that are to be selected based on the polymorphic relationship;

    processing the request utilizing the polymorphic relationship, with the one or more processors, by running the query against a portion of a set of data in the database; and

    transmitting, with the one or more processors, a result for the database query, where the result is defined by at least the polymorphic relationship, to a remote electronic device.

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