公开(公告)号：US10936592B2

公开(公告)日：2021-03-02

申请号：US15565521

申请日：2015-04-30

Applicant: ENTIT Software LLC

Inventor： Qiming Chen ,  Rui Liu ,  Meichun Hsu

IPC: G06F16/00 ,  G06F16/2455 ,  G06F16/21 ,  G06F16/242

Abstract: According to an example, dynamic function invocation may include ascertaining a query for a database management system (DBMS). Dynamic function invocation may further include implementing a dynamic function as a meta user defined function to invoke a plurality of different coded functions including a coded function that is to be invoked by the query to perform an operation related to the DBMS, and executing the dynamic function by the query to load and invoke the coded function to perform the operation related to the DBMS.

公开(公告)号：US11106672B2

公开(公告)日：2021-08-31

申请号：US15762586

申请日：2015-09-25

Applicant: ENTIT Software LLC

Inventor： Rui Liu ,  Qiming Chen ,  Jeff Lefevre ,  Malu G. Castellanos ,  Meichun Hsu

IPC: G06F16/24 ,  G06F16/2453 ,  G06F16/27 ,  G06F16/22 ,  G06F16/2458 ,  G06F16/25

Abstract: A system includes a database client, and a distributed database comprising database nodes. The distributed database may receive a database query from the client, determine that the query comprises a range of hash values of a table partition stored by a node of the distributed database, and determine that the range of hash values is not stored by other nodes of the distributed database. Responsive to determining that the range of hash values of the query is stored by the node and not by the other nodes, the database may generate an optimized distributed execution plan that includes the node that stores the range of hash values and excludes the nodes that do not include the range of hash values.

公开(公告)号：US10547536B2

公开(公告)日：2020-01-28

申请号：US15750630

申请日：2015-08-07

Applicant: ENTIT Software LLC

Inventor： Qiming Chen ,  Rui Liu ,  Meichun Hsu

IPC: H04L12/733 ,  H04L12/721 ,  H04L12/751 ,  H04L12/741

Abstract: Examples relate to identifying shortest paths. In one example, a computing device may: access an edge table that specifies, for each edge of a graph, an edge source, an edge destination, and an edge distance value; access a current path table that specifies paths between nodes of the graph and, for each path, a source node, a destination node, a distance, and a node path; identify each path included in the current path table as a shortest known path; and for each path having a destination node that matches an edge source node, add a new path to the current path table, the new path specifying: the source node as a new source; the edge destination as a new destination; a sum of the edge value and the path distance as a new distance; and the edge destination appended to the node path as a new node path.

公开(公告)号：US20180322150A1

公开(公告)日：2018-11-08

申请号：US15773348

申请日：2015-11-04

Applicant: ENTIT SOFTWARE LLC

Inventor： Qiming Chen ,  Rui Liu ,  Meichun Hsu

IPC: G06F17/30

CPC classification number: G06F17/30297 ,  G06F17/30448 ,  G06F17/30569

Abstract: In one example in accordance with the present disclosure, a method for dynamic schema typing may include receiving a host query with a function defining data to be retrieved. The function may include a dynamically definable schema. The method may also include receiving, at function invocation time, a data type schema defining a type of the data to be retrieved and generating a query using the data type schema as a value for the dynamically definable schema. The method may also include retrieving the data, converting the retrieved data into a form defined by the data type schema and providing the transformed data to the host query.

公开(公告)号：US20180089273A1

公开(公告)日：2018-03-29

申请号：US15565521

申请日：2015-04-30

Applicant: ENTIT Software LLC

Inventor： Qiming Chen ,  Rui Liu ,  Meichun Hsu

IPC: G06F17/30

CPC classification number: G06F16/2455 ,  G06F16/21 ,  G06F16/2433

Abstract: According to an example, dynamic function invocation may include ascertaining a query for a database management system (DBMS). Dynamic function invocation may further include implementing a dynamic function as a meta user defined function to invoke a plurality of different coded functions including a coded function that is to be invoked by the query to perform an operation related to the DBMS, and executing the dynamic function by the query to load and invoke the coded function to perform the operation related to the DBMS.

公开(公告)号：US10789235B2

公开(公告)日：2020-09-29

申请号：US15555634

申请日：2015-03-20

Applicant: ENTIT Software LLC

Inventor： Qiming Chen ,  Meichun Hsu ,  Rui Liu ,  Maria Guadalupe Castellanos

IPC: G06F16/30 ,  G06F16/22 ,  G06F16/245

Abstract: Methods, devices, and techniques for base user defined functions in a database management system are discussed herein. For example, in one aspect, a query request is received from a computer device. The query request may include a query operator representing a specialized user defined function (SUDF). The SUDF may then be executed. Executing the SUDF may include executing a base operation of a base user defined function (BUDF). The base operation may interact with an application programming interface (API) of the query engine to obtain a tuple stored in the database. Executing the SUDF may further include executing a specialized operation that processes the tuple according to an analytics function. The specialized operation may generate a result. Then, a query result may be returned to the computer device. The query result can include the result.