Orchestration of crud operations for a hierarchical web service data model in a spreadsheet

Patent metadata

Field	Value
Publication number	US-11556702-B2
Application number	US-202017008503-A
Country	US
Kind code	B2
Filing date	Aug 31, 2020
Priority date	Aug 31, 2020
Publication date	Jan 17, 2023
Grant date	Jan 17, 2023

Abstract

Example embodiments facilitate orchestrating changes of data made (and/or actions specified for execution) in a client-side program with changes of corresponding data made in one or more server-side data objects. An example method includes structuring one or more worksheet relationships between one or more worksheets of a client-side spreadsheet in accordance with one or more data object relationships of one or more data objects of a server-side data structure; determining that one or more operations have been selected for performing on data of one or more of the worksheets; detecting user input operative to initiate performance of the one or more operations; and initiating implementation of the one or more operations (e.g., CRUD (Create, Read, Update, Delete) operations) in accordance with the one or more worksheet relationships and the one or more data object relationships (e.g., hierarchical relationships). A spreadsheet add-in may issue request messages to web services tasked with completing the one or more operations.

First claim

We claim:

1. A tangible processor-readable medium including instructions executable by one or more processors, and when executed operable for:
automatically determining one or more characteristics of an organization of a data structure of a server-side data storage mechanism;
using the one or more characteristics for automatically constructing a client-side spreadsheet and generating client-side worksheets;
using the one or more characteristics to specify one or more relationships between the client-side worksheets of the client-side spreadsheet, such that the one or more relationships are specified in accordance with the organization of the data structure of the server-side data storage mechanism; and
employing the one or more relationships, that are between the client-side worksheets of the client-side spreadsheet, to facilitate one or more operations on data of the data structure via the client-side spreadsheet, wherein the data structure is of the server-side data storage mechanism and the data structure has the organization.

2. The tangible processor-readable medium of claim 1 , wherein employing further includes:
facilitating the one or more operations on data of the data structure responsive to user input provided via one or more User Interface (UI) controls of the client-side spreadsheet.

3. The tangible processor-readable medium of claim 2 , wherein the one or more UI controls include an Upload control.

4. The tangible processor-readable medium of claim 2 , wherein the one or more UI controls include a Download control.

5. The tangible processor-readable medium of claim 1 , wherein the one or more operations include one or more CRUD (Create, Read, Update, Delete) operations.

6. The tangible processor-readable medium of claim 5 , wherein the one or more operations include one or more custom actions.

7. The tangible processor-readable medium of claim 1 , wherein employing further includes:
using the one or more relationships to selectively synchronize data in the client-side worksheets with data of the data structure.

8. The tangible processor-readable medium of claim 1 , wherein the organization of the data structure includes a hierarchy of data objects; wherein the hierarchy of data objects includes a tree structure; and wherein the one or more relationships between the client-side worksheets are described, at least in part, by the tree structure or a portion thereof.

9. The tangible processor-readable medium of claim 8 , wherein the one or more relationships match one or more associations between one or more data objects of the data structure, such that the client-side worksheets are related as a hierarchy of worksheets, wherein the hierarchy of worksheets is based on the hierarchy of data objects.

10. The tangible processor-readable medium of claim 9 , wherein employing includes traversing the hierarchy of worksheets to selectively implement one or more actions specified in one or more of the worksheets to thereby perform actions specified in the one or more worksheets on corresponding data objects of the hierarchy of data objects.

11. A method for facilitating communications between a client-side spreadsheet and a server-side data storage mechanism, the method comprising:
automatically determining one or more characteristics of an organization of a data structure of a server-side data storage mechanism;
using the one or more characteristics for automatically constructing a client-side spreadsheet and generating client-side worksheets;
using the one or more characteristics to specify one or more relationships between the client-side worksheets of the client-side spreadsheet, such that the one or more relationships are specified in accordance with the organization of the data structure of the server-side data storage mechanism; and
employing the one or more relationships, that are between the client-side worksheets of the client-side spreadsheet, to facilitate one or more operations on data of the data structure via the client-side spreadsheet, wherein the data structure is of the server-side data storage mechanism and has the organization.

12. The method of claim 11 , wherein employing further includes:
facilitating the one or more operations on data of the data structure responsive to user input provided via one or more User Interface (UI) controls of the client-side spreadsheet.

13. The method of claim 12 , wherein the one or more UI controls include an Upload control.

14. The method of claim 12 , wherein the one or more UI controls include a Download control.

15. The method of claim 11 , wherein the one or more operations include one or more CRUD (Create, Read, Update, Delete) operations.

16. The method of claim 15 , wherein the one or more operations include one or more custom actions.

17. The method of claim 11 , wherein employing further includes:
using the one or more relationships to selectively synchronize data in the client-side worksheets with data of the data structure.

18. The method of claim 11 , wherein the organization of the data structure includes a hierarchy of data objects; wherein the hierarchy of data objects includes a tree structure; and wherein the one or more relationships between the client-side worksheets are described, at least in part, by the tree structure or a portion thereof.

19. The method of claim 18 , wherein the one or more relationships match one or more associations between one or more data objects of the data structure, such that the client-side worksheets are related as a hierarchy of worksheets, wherein the hierarchy of worksheets is based on the hierarchy of data objects, and wherein employing includes:
traversing the hierarchy of worksheets to selectively implement one or more actions specified in one or more of the worksheets to thereby perform actions specified in the one or more worksheets on corresponding data objects of the hierarchy of data objects.

20. An apparatus comprising:
one or more processors; and
logic encoded in one or more tangible media for execution by the one or more processors and when executed operable for:
automatically determining one or more characteristics of an organization of a data structure of a server-side data storage mechanism;
using the one or more characteristics for automatically constructing a client-side spreadsheet and generating client-side worksheets;
using the one or more characteristics to specify one or more relationships between the client-side worksheets of the client-side spreadsheet, such that the one or more relationships are specified in accordance with the organization of the data structure of the server-side data storage mechanism; and
employing the one or more relationships, that are between the client-side worksheets of the client-side spreadsheet, to facilitate one or more operations on data of the data structure via the client-side spreadsheet, wherein the data structure is of the server-side data storage mechanism and has the organization.

Assignees

• Oracle Int Corp

Inventors

• Logan Shaun
• Davis Edmund A
• Rowles Brian

Classifications

• G06F40/18 Primary

  of spreadsheets (form-filling G06F40/174) · CPC title

• G06F16/2379

  Updates performed during online database operations; commit processing · CPC title

• G06F40/14

  Tree-structured documents (parsing G06F40/205; validation G06F40/226) · CPC title

• G06F16/273

  Asynchronous replication or reconciliation · CPC title

• G06F3/0481

  based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance · CPC title