Platform for integrating back-end data analysis tools using schema

1 . A computer-implemented method, comprising:

receiving, through a graphical user interface, a selection of a function for operation on retail-specific datasets from a plurality of back-end tools;

translating the selected function into a set of pre-configured commands configured to expose the retail-specific datasets and exclude from exposure operational information of the plurality of back-end tools and is not retail-specific, wherein the pre-configured commands are specific to the plurality of back-end tools;

executing the set of pre-configured commands to create SQL synonyms for data fields of the retail-specific datasets in a workspace schema associated with the graphical user interface; and

executing the selected function on the SQL synonyms in the workspace schema to generate a result from the retail-specific datasets.

2 . The computer-implemented method of claim 1 , wherein the set of pre-configured commands includes, for each back-end tool of the plurality of back-end tools, a command to the back-end tool to expose a portion of the retail-specific datasets that is in the back-end tool, wherein the command is written in a format compatible with the back-end tool.

3 . The computer-implemented method of claim 1 , wherein translating the selected function comprises:

identifying a mapping between the selected function and the set of pre-configured commands; and

retrieving the set of pre-configured commands based on the mapping.

4 . The computer-implemented method of claim 1 , wherein the retail-specific datasets include intermediate results from execution of at least one back-end tool of the plurality of back-end tools, wherein the intermediate results are hidden from access outside of the back-end tool.

5 . The computer-implemented method of claim 1 , wherein in response to receiving a further selection of an additional function for operation on a further retail-specific dataset, the method further comprises executing additional pre-configured commands associated with the additional function to create additional synonyms for the further retail-specific dataset in the workspace schema.

6 . The computer-implemented method of claim 1 , further comprising receiving, through the graphical user interface, a series of user selections that assemble an application that includes the selected function.

7 . The computer-implemented method of claim 6 , wherein the application operates to display affinities between products in a basket as a graph.

8 . One or more non-transitory computer-readable media storing computer-executable instructions that, when executed by at least one processor of a computer, cause the computer to:

receive, through a graphical user interface, a selection of a function for operation on retail-specific datasets from a plurality of back-end tools;

translate the selected function into a set of pre-configured commands configured to expose the retail-specific datasets and exclude from exposure operational information of the plurality of back-end tools and is not retail-specific, wherein the pre-configured commands are specific to the plurality of back-end tools;

execute the set of pre-configured commands to create SQL synonyms for data fields of the retail-specific datasets in a workspace schema associated with the graphical user interface; and

execute the selected function on the SQL synonyms in the workspace schema to generate a result from the retail-specific datasets.

9 . The non-transitory computer-readable media of claim 8 , wherein the set of pre-configured commands includes, for each back-end tool of the plurality of back-end tools, a command to the back-end tool to expose a portion of the retail-specific datasets that is in the back-end tool, wherein the command is written in a format compatible with the back-end tool.

10 . The non-transitory computer-readable media of claim 8 , wherein the computer-executable instructions to translate the selected function further cause the computer to:

identify a mapping between the selected function and the set of pre-configured commands; and

retrieve the set of pre-configured commands based on the mapping.

11 . The non-transitory computer-readable media of claim 8 , wherein the retail-specific datasets include intermediate results from execution of at least one back-end tool of the plurality of back-end tools, wherein the intermediate results are hidden from access outside of the back-end tool.

12 . The non-transitory computer-readable media of claim 8 , wherein the computer-executable instructions further cause the computer to:

receive a further selection of an additional function for operation on a second retail-specific dataset; and

execute additional pre-configured commands associated with the additional function to create additional synonyms for the second retail-specific dataset in the workspace schema; and

wherein the result is generated from the second retail-specific dataset in addition to the retail-specific datasets.

13 . The non-transitory computer-readable media of claim 8 , wherein the computer-executable instructions further cause the computer to share the result to other processes through a restful service.

14 . The non-transitory computer-readable media of claim 8 , wherein the function is a code notebook function.

15 . A computing system comprising:

a processor;

a memory operably connected to the processor; and

one or more non-transitory computer-readable media operably connected to the processor and storing computer-executable instructions that, when executed by at least the processor accessing the memory, cause the computing system to:

receive, through a graphical user interface, a selection of a function for operation on retail-specific datasets from a plurality of back-end tools;

translate the selected function into a set of pre-configured commands specific to the back-end tools configured to expose the retail-specific datasets and exclude from exposure operational information of the plurality of back-end tools and is not retail-specific, wherein the pre-configured commands are specific to the plurality of back-end tools;

execute the set of pre-configured commands to create SQL synonyms for data fields of the retail-specific datasets in a workspace schema associated with the graphical user interface; and

execute the selected function on the SQL synonyms in the workspace schema to generate a result from the retail-specific datasets.

16 . The computing system of claim 15 , wherein the set of pre-configured commands includes, for each back-end tool of the plurality of back-end tools, a command to the back-end tool to expose a portion of the retail-specific datasets that is in the back-end tool, wherein the command is written in a format compatible with the back-end tool.

17 . The computing system of claim 15 , wherein the computer-executable instructions to translate the selected function further cause the computing system to:

identify a mapping between the selected function and the set of pre-configured commands; and

retrieve the set of pre-configured commands based on the mapping.

18 . The computing system of claim 15 , wherein the retail-specific datasets include intermediate results from execution of at least one back-end tool of the plurality of back-end tools, wherein the intermediate results are hidden from access outside of the back-end tool.

19 . The computing system of claim 15 , wherein the retail-specific datasets include first dataset includes data for at least one back-end tool of the plurality of back-end tools that is forbidden from access outside of the back-end tool, and wherein the set of pre-configured commands grants privileges to access the data outside of the back-end tool.

20 . The computing system of claim 15 , wherein the computer-executable instructions further cause the computing systemto:

receive, through the graphical user interface, a series of user selections that assemble an application that includes the selected function and an additional function, wherein the additional function operates on an additional dataset in addition to the retail-specific datasets;

execute additional pre-configured commands associated with the additional function to create additional synonyms for the additional dataset in the workspace schema; and

execute the additional function on the at least the additional synonyms to generate an updated result.