Job authoring with data preview

Patent metadata

Field	Value
Publication number	US-2016117371-A1
Application number	US-201414521465-A
Country	US
Kind code	A1
Filing date	Oct 23, 2014
Priority date	Oct 23, 2014
Publication date	Apr 28, 2016
Grant date	—

Abstract

Jobs can be authored in conjunction with a visual workspace. Upon selection of representation of a data source in the workspace, a preview of the data source can be generated within context of the visual workspace. Further, representations of one or more data transformation operations can be provided with the preview. Selection of a transformation operation results in an updated preview reflecting application of the operation as well as generation of backend code to perform the operation. Furthermore, a job comprising one or more transformation operations can be added to the workspace automatically.

First claim

What is claimed is:

1 . In a computer configured to provide a graphical user interface on a display, a method comprising:
presenting on the display in a first portion of the interface a representation of a data source on a workspace configured to enable diagrammatic job authoring; and presenting on the display in a second portion of the interface a data preview based on at least a subset of data acquired from the data source and one or more visual representations of transformation operations in response to selection of the data source.

2 . The method of claim 1 further comprises updating the data preview to reflect application of a transformation operation after selection of the transformation operation.

3 . The method of claim 1 further comprises presenting on the display in third portion of the interface a sequence of one or more selected transformation operations.

4 . The method of claim 1 further comprises presenting on the display in a third portion of the interface code that implements one or more selected transformation operations.

5 . The method of claim 1 further comprises automatically adding a visual representation of a job comprising one or more selected transformation operations to the workspace.

6 . The method of claim 1 further comprises presenting on the display in the second portion of the interface the data preview comprising two or more segments of data.

7 . The method of claim 1 further comprises presenting on the display in the second portion of the interface a graph associated with the at least the subset of data.

8 . A method of facilitating job authoring, comprising:
employing at least one processor configured to execute computer-executable instructions stored in a memory to perform the following acts: generating a query over a data source for at least a subset of data in response to selection of a representation of the data source in a diagram of a visual workspace; and presenting a preview of the data source within context of the workspace based on query execution results.

9 . The method of claim 8 further comprises presenting visual representations of one or more data transformation operations within context of the preview.

10 . The method of claim 9 further comprises:
generating an updated query in response to selection of a transformation operation from the one or more data transformation operations, the updated query captures the selected transformation operation; and
updating the preview based on updated query execution results.

11 . The method of claim 10 further comprises automatically adding a representation of a job to the workspace comprising the selected transformation operation.

12 . The method of claim 10 further comprising generating code configured to perform the selected transformation operation.

13 . The method of claim 12 further comprises visually presenting the code within context of the workspace.

14 . The method of claim 8 further comprises presenting the preview with a selected visualization.

15 . A system that facilitates job authoring, comprising:
a processor coupled to a memory, the processor configured to execute the following computer-executable components stored in the memory: a first component configured to present a visual workspace for authoring jobs diagrammatically; and a second component configured to present a preview of a data source represented on the workspace concurrently with the workspace upon selection of the data source, the preview is generated from least a subset of data acquired from the data source based on results of execution of a generated query specifying the data.

16 . The system of claim 15 further comprises a third component configured to present a visual representation of one or more transformation operations in conjunction with the preview.

17 . The system of claim 16 further comprises a fourth component configured to update the preview to reflect application of one or more selected transformation operations.

18 . The system of claim 16 further comprises a third component configured to generate code associated with one or more selected transformation operations.

19 . The system of claim 16 further comprising a third component configured to add a job comprising one or more selected transformation operations to the workspace.

20 . The system of claim 16 , the preview comprises a random or pseudorandom sampling of data from the data source.

Assignees

• Microsoft Corp

Inventors

• Couris Cheryl
• Storm Christina
• Peacock Andrew J
• Netz Amir
• Cheung Chiu Ying
• Flasko Michael J
• Grealish Kevin
• Della-Libera Giovanni M
• Carlson Sonia P
• Heninger Mark W
• Bach Paula M
• Jones Taurean A

Classifications

• G06F9/44 Primary

  Arrangements for executing specific programs · CPC title

• G06F17/30589

  Physics · mapped topic

• G06F17/30383

  Physics · mapped topic

• G06F17/30563 Primary

  Physics · mapped topic

• G06F16/254 Primary

  Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses · CPC title