IP Library Patent Application 15773348
Patent Application
App. No. 15/773,348

DYNAMIC SCHEMA TYPING

Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US None
App. No.
15/773,348
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.

Claims (38)

1 . A method for dynamic schema typing, the method comprising:

receiving a host query with a function defining data to be retrieved, wherein the function includes a dynamically definable schema;

receiving, at a function invocation time, a data type schema defining a type of the data to be retrieved;

generating a query using the data type schema as a value for the dynamically definable schema;

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.

2 . The method of claim 1 , wherein the dynamically definable schema is initially set to a null value.

3 . The method of claim 1 , further comprising:

performing an SQL query including the function and the data type schema.

4 . The method of claim 1 , further comprising:

receiving a second data type schema defining a second type of the data to be retrieved, wherein the data type schema and the second data type schema are different; and

generating a second query using the second data type schema as a value for the dynamically definable schema.

5 . The method of claim 1 , further comprising:

retrieving the data from an unstructured data source.

6 . The method of claim 1 , wherein the function is created by a User Defined Transformation Factory.

7 . The method of claim 1 , wherein the data type schema further defines a first node in a cluster, the method further comprising;

receiving, at the function invocation time, a second data type schema, wherein the second data type schema defines a second type of data to be retrieved from a second node in the cluster; and

retrieving, in parallel, the first type of data from the first node in the cluster and second type of data from the second node in the cluster.

8 . A system for dynamic schema typing, the method comprising:

a function receiver to receive a function with a schema variable, wherein the function is created by a function factory;

a value receiver to receive, at run time, a type value for the schema variable, wherein the type value defines a type of data;

a query generator to dynamically generate an SQL query using the type value as the schema variable for the function; and

a function performer to perform the function using the type value.

9 . The system of claim 8 , wherein the function factory is registered before the function is invoked.

10 . The system of claim 8 , wherein the type value further defines a property of the data.

11 . The system of claim 8 , wherein the dynamically definable schema is initially set to a null value.

12 . A non-transitory machine-readable storage medium comprising instructions executable by a processor of a computing device for dynamic schema typing, the machine-readable storage medium comprising instructions to:

generate a signature including an object for a schema, wherein the object is initially set to a null value;

receive a value for the object, wherein the value defines a type of data;

determine that the object in the signature is set to the null value; and

generate, dynamically at invocation time, a query using the value for the object in the signature.

13 . The non-transitory machine-readable storage medium of claim 12 further comprising instructions to:

receive a second value defining a second type of the data to be retrieved, wherein the data type schema and the second data type schema are different; and

generating a second query using the second data type schema as a value for the dynamically definable schema.

14 . The non-transitory machine-readable storage medium of claim 12 further comprising instructions to:

retrieve the data from an unstructured data source.

15 . The non-transitory machine-readable storage medium of claim 12 , wherein the signature is created by a function factory.

Assignments (7)
RELEASE OF SECURITY INTEREST REEL/FRAME 052295/0041 Recorded Feb 2, 2023
From: JPMORGAN CHASE BANK, N.A.
To: MICRO FOCUS LLC; MICRO FOCUS SOFTWARE INC. (F/K/A NOVELL, INC.); NETIQ CORPORATION
Reel/Frame 062625/0754 →
RELEASE OF SECURITY INTEREST REEL/FRAME 052294/0522 Recorded Feb 2, 2023
From: JPMORGAN CHASE BANK, N.A.
To: MICRO FOCUS LLC; MICRO FOCUS SOFTWARE INC. (F/K/A NOVELL, INC.); NETIQ CORPORATION
Reel/Frame 062624/0449 →
SECURITY AGREEMENT Recorded Apr 2, 2020
From: MICRO FOCUS LLC; BORLAND SOFTWARE CORPORATION; MICRO FOCUS SOFTWARE INC.; NETIQ CORPORATION; MICRO FOCUS (US), INC.
To: JPMORGAN CHASE BANK, N.A.
Reel/Frame 052295/0041 →
SECURITY AGREEMENT Recorded Apr 2, 2020
From: MICRO FOCUS LLC; BORLAND SOFTWARE CORPORATION; MICRO FOCUS SOFTWARE INC.; NETIQ CORPORATION; MICRO FOCUS (US), INC.
To: JPMORGAN CHASE BANK, N.A.
Reel/Frame 052294/0522 →
CHANGE OF NAME Recorded Aug 8, 2019
From: ENTIT SOFTWARE LLC
To: MICRO FOCUS LLC
Reel/Frame 050004/0001 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jan 25, 2019
From: CHEN, QIMING; LIU, RUI; HSU, MEICHUN
To: HEWLETT PACKARD ENTERPRISE DEVELOPMENT LP
Reel/Frame 048138/0109 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jan 25, 2019
From: HEWLETT PACKARD ENTERPRISE DEVELOPMENT LP
To: ENTIT SOFTWARE LLC
Reel/Frame 048142/0565 →