Systems and methods for dynamic creation of schemas

Patent metadata

Field	Value
Publication number	US-11226978-B2
Application number	US-201916392260-A
Country	US
Kind code	B2
Filing date	Apr 23, 2019
Priority date	Apr 23, 2019
Publication date	Jan 18, 2022
Grant date	Jan 18, 2022

Abstract

A computing system includes a server. The server is communicatively coupled to a data repository and is configured to store a data in the data repository. The server is further configured to receive as input, via a server communicatively coupled to a data repository and configured to store a data in the data repository, a dynamic schema, the dynamic schema comprising a dynamic object, wherein the dynamic object is representative of information stored in at least one server object. The server is additionally configured to provide an application programming interface (API) to interface with the dynamic object based on the dynamic schema. The server is further configured to retrieve a result when the dynamic object is executed via a call to the API, wherein retrieving the result comprises loading the server object or a portion of the server object into a memory of the server only after the call to the API.

First claim

The invention claimed is:

1. A computing system, comprising:
a server implemented using a memory and a processor communicatively coupled to a data repository and configured to store a data in the data repository, wherein the server is configured to perform operations comprising:
loading a dynamic schema comprising one or more static objects and one or more dynamic schema providers, wherein the one or more dynamic schema providers provide support for one or more dynamic object types, and wherein one or more dynamic objects of the dynamic object types are representative of information stored in at least one server object;
providing an application programming interface (API) to interface with the one or more dynamic objects based on the dynamic schema, wherein the one or more dynamic objects comprise one or more fields representative of one or more columns of a database table;
receiving a call to the API, wherein the call comprises a query function call requesting data comprising values in a respective field of the database table associated with a dynamic object of the one or more dynamic objects;
determining, that the requested data corresponds to a dynamic data type and a corresponding dynamic schema provider of the one or more dynamic schema providers associated with the requested data based on the query function call;
retrieving a result when the dynamic object associated with the requested data is executed via the call to the API, wherein retrieving the result comprises loading the server object or a portion of the server object into the memory of the server only after the call to the API has been made; and
transmitting the result comprising the requested data to an additional device, wherein the result comprises one or more results corresponding to the field of the database table.

2. The computing system of claim 1 , wherein the dynamic schema is configured to retrieve the result by using a single endpoint.

3. The computing system of claim 1 , wherein the server object comprises the database table.

4. The computing system of claim 1 , wherein the dynamic schema comprises a graphical query language-based schema.

5. The computing system of claim 4 , wherein the dynamic schema includes one or more objects inheriting from a graphical query language class.

6. The computing system of claim 5 , wherein the one or more objects comprises a graphical query language dynamic schema object configured to provide the API to interface with the dynamic object.

7. The computing system of claim 6 , wherein the graphical query language dynamic schema object provides a listener interface configured to dynamically reload the dynamic object into the memory if the dynamic object has undergone a change in its structure.

8. The computing system of claim 1 , wherein the dynamic schema comprises a static or immutable object, and wherein the server is configured to load the static object into the memory upon startup.

9. The computing system of claim 1 , wherein the dynamic schema is configured to determine a provider for the dynamic object based on a type for the dynamic object and wherein the result is retrieved based on the provider.

10. The computing system of claim 1 , wherein retrieving the result when the dynamic object is executed via a call to the API comprises communicating a graphical query language-based query object via the API, and wherein the query object comprises one or more fields to be provided by the result.

11. A method, comprising:
loading a dynamic schema comprising one or more static objects and one or more dynamic schema providers, wherein the one or more dynamic schema providers provide support for one or more dynamic object types, wherein one or more dynamic objects of the dynamic object types are representative of information stored in at least one server object;
providing an application programming interface (API) to interface with the one or more dynamic objects based on the dynamic schema, wherein the one or more dynamic objects comprise one or more fields representative of one or more columns of a database table; and
receiving a call to the API, wherein the call comprises a query function call requesting data comprising values in a respective field of the database table associated with a dynamic object of the one or more dynamic objects;
determining, that the requested data is a dynamic data type and a corresponding dynamic schema provider of the one or more dynamic schema providers associated with the requested data based on the query function call; and
retrieving a result when the dynamic object associated with the requested data is executed via the call to the API, wherein retrieving the result comprises loading the server object or a portion of the server object into a memory of the server only after the call to the API has been made; and
transmitting the result comprising the requested data to an additional device, wherein the result comprises one or more results corresponding to the field of the database table.

12. The method of claim 11 , wherein the dynamic schema is configured to retrieve the result by using a single endpoint.

13. The method of claim 11 , wherein the at least one server object comprises the database table.

14. The method of claim 11 , wherein the dynamic schema comprises a graphical query language-based schema, and wherein the dynamic schema includes one or more objects inheriting from a graphical query language class.

15. The method of claim 14 , wherein the one or more objects comprises a graphical query language dynamic schema object configured to provide the API to interface with the dynamic object, and wherein the graphical query language dynamic schema object provides a listener interface configured to dynamically reload the dynamic object into the memory if the dynamic object has undergone a change in its structure.

16. A non-transitory, computer-readable medium storing instructions executable by a processor of a computing system, the instructions configured to:
loading a dynamic schema comprising one or more static objects and one or more dynamic schema providers, wherein the one or more dynamic schema providers provide support for one or more dynamic object types, and, wherein one or more dynamic objects of the dynamic object types are representative of information stored in at least one server object;
provide an application programming interface (API) to interface with the one or more dynamic objects based on the dynamic schema, wherein the one or more dynamic objects comprise one or more fields representative of one or more columns of a database table; and
receive a call to the API, wherein the call comprises a query function call requesting data comprising values in a respective field of the database table associated with a dynamic object of the one or more dynamic objects;
determining, that the requested data is a dynamic data type and a corresponding dynamic schema provider of the one or more dynamic schema providers associated with the requested data based on the query function call; and
retrieve a result when the dynamic object associated with the requested data is executed via the call to the API, wherein retrieving the result comprises loading the server object or a portion of the server object into a memory of the server only after the call to the API has been made; and
transmitting the result comprising the requested data to an additional device, wherein the result comprises one or more results corresponding to the field of the database table.

17. The computer-readable medium of claim 16 , wherein the dynamic schema

Assignees

• Servicenow Inc

Inventors

• Tamjidi David
• Mangione-Tran Carmine

Classifications

• G06F16/9024

  Graphs; Linked lists (G06F16/9027 takes precedence) · CPC title

• G06F16/252 Primary

  between a Database Management System and a front-end application · CPC title

• G06F16/211 Primary

  Schema design and management · CPC title

• G06F16/256

  in federated or virtual databases · CPC title

• G06F16/248

  Presentation of query results · CPC title