Synchronization of diagrams and associated structured data

Patent metadata

Field	Value
Publication number	US-10657152-B2
Application number	US-201715609527-A
Country	US
Kind code	B2
Filing date	May 31, 2017
Priority date	May 31, 2017
Publication date	May 19, 2020
Grant date	May 19, 2020

Abstract

Methods and systems for generating a diagram from structured data and synchronizing modifications between the diagram and the structured data. One system includes at least one processor configured to receive a plurality of transformation settings for the structured data and generate and store a plurality of first expressions and a plurality of second expressions based on the structured data and the plurality of transformation settings. The processor is further configured to generate and organize a plurality of visual structures based on the plurality of first expressions and the plurality of second expressions and generate and output a diagram for display through a user interface including the plurality of visual structures. In addition, the processor is configured to receive a modification to the diagram through the user interface, and modify the structured data based on the modification, the plurality of first expressions, and the plurality of second expressions.

First claim

What is claimed is:

1. A system for generating a diagram from structured data and synchronizing modifications between the diagram and the structured data, the system comprising:
at least one processor configured to:
access a structured data representation, the structured data representation including a plurality of data records,
receive a plurality of transformation settings for the structured data representation,
generate and store a plurality of first expressions based on the structured data representation and the plurality of transformation settings, each of the plurality of first expressions mapping one of the plurality of data records to a visual structure,
generate and store a plurality of second expressions based on the structured data representation and the plurality of transformation settings, each of the plurality of second expressions transforming data included in one of the plurality of data records into a property of a visual structure,
generate and organize a plurality of visual structures based on the plurality of first expressions and the plurality of second expressions, the plurality of visual structures includes at least one shape and at least one connector,
generate and output the diagram for display through a user interface, the diagram including the plurality of visual structures,
receive a modification to the diagram through the user interface, wherein the modification is a modification to a shape of a visual structure of the plurality of visual structures, and
modify the structured data representation based on the modification, the plurality of first expressions, and the plurality of second expressions.

2. The system of claim 1 , wherein the at least one processor is further configured to validate the modification based on at least one constraint, wherein the at least one processor is configured to modify the structured data representation in response to the modification being validated, and wherein the at least one processor is further configured to reject the modification in response to the modification not being validated.

3. The system of claim 1 , wherein the at least one processor is configured to modify the structured data representation by modifying at least one of a locally-stored copy of the structured data representation and an original version of the structured data representation stored in at least one data source.

4. The system of claim 1 , wherein the at least one processor is further configured to receive a second modification to the structured data representation and modify the diagram based on the second modification to the structured data representation, the plurality of first expressions, and the plurality of second expressions.

5. The system of claim 1 , wherein the structured data representation includes at least one selected from a group consisting of a tabular data representation, a hierarchical data representation, and a graph data representation.

6. The system of claim 1 , wherein the at least one processor is configured to access the structured data representation by accessing at least one selected from a group consisting of a mark-up language file and an object notation file.

7. The system of claim 1 , wherein the at least one processor is configured to receive the plurality of transformation settings by receiving the plurality of transformation settings through at least one user interface.

8. The system of claim 1 , wherein the at least one processor is further configured to generate and store a template based on the plurality of transformation settings and transmit the template for use with a second structured data representation.

9. The system of claim 1 , wherein the at least one processor is configured to receive the plurality of transformation settings by accessing a template.

10. A method of generating a diagram from structured data and synchronizing modifications between the diagram and the structured data, the method comprising:
accessing a structured data representation, the structured data representation including a plurality of data records;
receiving a plurality of transformation settings for the structured data representation;
generating and storing a plurality of first expressions based on the structured data representation and the plurality of transformation settings, each of the plurality of first expressions mapping one of the plurality of data records to a visual structure;
generating and storing a plurality of second expressions based on the structured data representation and the plurality of transformation settings, each of the plurality of second expressions transforming data included in one of the plurality of data records into a property of a visual structure;
generating and organizing, with a processor, a plurality of visual structures based on the plurality of first expressions and the plurality of second expressions, the plurality of visual structures includes at least one shape and at least one connector;
generating and outputting, with the processor, the diagram for display through a user interface, the diagram including the plurality of visual structures;
receiving, with the processor, a modification to the diagram through the user interface wherein the modification is a modification to a shape of a visual structure of the plurality of visual structures;
validating, with the processor, the modification; and
in response to validating the modification, modifying, with the processor, the structured data representation based on the modification, the plurality of first expressions, and the plurality of second expressions.

11. The method of claim 10 , wherein receiving the plurality of transformation settings includes receiving at least one selected from a group consisting of a diagram type, a mapping between a category of data records within the structured data representation and a diagram field, and a mapping between a category of data records within the structured data representation and a shape type, and a mapping between a category of data records within the structured data representation and an identifier of a previous visual structure or a next visual structure.

12. The method of claim 10 , wherein generating and outputting the diagram includes generating and outputting at least one selected from a group consisting of a flowchart, a cross-functionality flowchart, and an organization chart.

13. The method of claim 10 , further comprising filtering the plurality of visual structures included in the diagram based on a visual filtering setting.

14. The method of claim 13 , wherein filtering the plurality of visual structures includes marking at least one of the plurality of visual structures satisfying the visual filtering setting, wherein marking the at least one of the plurality of visual structures includes removing the at least one of the plurality of visual structures or modifying the at least one of the plurality of visual structures.

15. The method of claim 10 , further comprising animating at least one of the plurality of visual structures to represent a change in a data record associated with the at least one of the plurality of visual structures represented within the structured data representation.

16. A non-transitory, computer-readable medium storing instructions that, when executed by a processor, perform a set of functions, the set of functions comprising:
receiving a plurality of transformation settings for a structured data representation;
generating and storing a plurality of expressions based on the structured data representation and the plurality of transformation settings;
generating and

Assignees

• Microsoft Technology Licensing Llc

Inventors

• Bhoovaraghavan Mukundan
• Srivastava Sandeep Kumar
• Joshi Amit
• Jain Salony
• Bothra Manjeet
• Gandhi Shashank
• Tripathi Ashutosh

Classifications

• G06F16/26

  Visual data mining; Browsing structured data · CPC title

• G06F16/248

  Presentation of query results · CPC title

• G06F16/275 Primary

  Synchronous replication · CPC title

• G06F16/2282

  Tablespace storage structures; Management thereof · CPC title

• G06F40/18

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