Ad-hoc graph definition

Patent metadata

Field	Value
Publication number	US-11449550-B2
Application number	US-202016793796-A
Country	US
Kind code	B2
Filing date	Feb 18, 2020
Priority date	Feb 18, 2020
Publication date	Sep 20, 2022
Grant date	Sep 20, 2022

Abstract

A method, a system, and a computer program product for generating graphs using a stored procedure. One or more graph data tables are generated. A procedure having a predetermined name is generated. One or more inputs to the generated procedure includes the generated one or more graph data tables. The generated procedure includes one or more graph objects. The graph data tables are configured to be input to the graph objects. The generated procedure is stored. The stored generated procedure is executed using one or more graph data stored in a graph database.

First claim

What is claimed:

1. A computer-implemented method, comprising:
generating one or more graph data tables;
generating a procedure having a predetermined name, wherein one or more inputs to the generated procedure includes the generated one or more graph data tables, the generated procedure including one or more graph objects, the one or more graph data tables being configured to be input to the one or more graph objects, wherein the generated procedure is generated using one or more reusable workspace objects;
storing the generated procedure; and
executing, using one or more graph data stored in a graph database, the stored generated procedure, wherein the executing including reusably executing the stored generated procedure using at least another graph data stored in the graph database.

2. The method according to claim 1 , wherein the executing further comprises
inserting the graph data stored in the graph database into the one or more generated graph tables; and
executing the stored generated procedure using the inserted graph data.

3. The method according to claim 1 , wherein the one or more graph data tables includes at least one of the following: one or more vertex tables, one or more edge tables, and any combination thereof.

4. The method according to claim 1 , wherein the executing further comprises calling the stored generated procedure using predetermined name.

5. The method according to claim 1 , further comprising executing, using one or more another graph data stored in the graph database, the stored generated procedure, wherein the one or more another graph data being different from the one or more graph data.

6. The method according to claim 1 , wherein the generated procedure is generated using one or more graph workspace objects.

7. The method according to claim 1 , wherein the graph data includes at least one of the following: one or more vertices, one or more edges, and any combination thereof.

8. The method according to claim 1 , further comprising executing one or more graph algorithms using the one or more graph data objects.

9. The method according to claim 8 , wherein the one or more graph algorithms include at least one of the following: a user-defined graph algorithm, a built-in graph algorithm, and any combination thereof.

10. A system comprising:
at least one programmable processor; and
a non-transitory machine-readable medium storing instructions that, when executed by the at least one programmable processor, cause the at least one programmable processor to perform operations comprising:
generating one or more graph data tables;
generating a procedure having a predetermined name, wherein one or more inputs to the generated procedure includes the generated one or more graph data tables, the generated procedure including one or more graph objects, the one or more graph data tables being configured to be input to the one or more graph objects, wherein the generated procedure is generated using one or more reusable workspace objects;
storing the generated procedure; and
executing, using one or more graph data stored in a graph database, the stored generated procedure, wherein the executing including reusably executing the stored generated procedure using at least another graph data stored in the graph database.

11. The system according to claim 10 , wherein the executing further comprises
inserting the graph data stored in the graph database into the one or more generated graph tables; and
executing the stored generated procedure using the inserted graph data.

12. The system according to claim 10 , wherein the one or more graph data tables includes at least one of the following: one or more vertex tables, one or more edge tables, and any combination thereof.

13. The system according to claim 10 , wherein the executing further comprises calling the stored generated procedure using predetermined name.

14. The system according to claim 10 , wherein the operations further comprise executing, using one or more another graph data stored in the graph database, the stored generated procedure, wherein the one or more another graph data being different from the one or more graph data.

15. The system according to claim 10 , wherein the generated procedure is generated using one or more graph workspace objects.

16. The system according to claim 10 , wherein the graph data includes at least one of the following: one or more vertices, one or more edges, and any combination thereof.

17. The system according to claim 10 , wherein the operations further comprise executing one or more graph algorithms using the one or more graph data objects.

18. The system according to claim 17 , wherein the one or more graph algorithms include at least one of the following: a user-defined graph algorithm, a built-in graph algorithm, and any combination thereof.

19. A computer program product comprising a non-transitory machine-readable medium storing instructions that, when executed by at least one programmable processor, cause the at least one programmable processor to perform operations comprising:
generating one or more graph data tables;
generating a procedure having a predetermined name, wherein one or more inputs to the generated procedure includes the generated one or more graph data tables, the generated procedure including one or more graph objects, the one or more graph data tables being configured to be input to the one or more graph objects, wherein the generated procedure is generated using one or more reusable workspace objects;
storing the generated procedure; and
executing, using one or more graph data stored in a graph database, the stored generated procedure, wherein the executing including reusably executing the stored generated procedure using at least another graph data stored in the graph database.

20. The computer program product according to claim 19 , wherein the executing further comprises
inserting the graph data stored in the graph database into the one or more generated graph tables; and
executing the stored generated procedure using the inserted graph data.

Assignees

• Sap Se

Inventors

• Kasperovics Romans
• Franz Gerald
• Erler Bastian
• Jakschitsch Hannes
• Sedler Roland
• Schimmel Florian

Classifications

• G06F16/22 Primary

  Indexing; Data structures therefor; Storage structures · CPC title

• G06Q10/06

  Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling · CPC title

• G06F16/2282

  Tablespace storage structures; Management thereof · CPC title

• G06F16/9024 Primary

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