SYSTEMS AND METHODS FOR GENERATING DATA VISUALIZATION APPLICATIONS

• US 20160259626A1
• Filed: 02/24/2016
• Published: 09/08/2016
• Est. Priority Date: 03/06/2015
• Status: Active Application

• Current Assignee: Cisco Technology, Inc. (Cisco Systems, Inc.)
• Original Assignee: Saggezza, Inc.
• Inventors: THATTAI, BALAJI T., Shanmugam, Karthikeyan, Lau, Yee Lang, Yao, Chi
• Granted Patent: US 10,275,221 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/212 with details for data modelling support
• CPC Class Codes: G06F 16/214 Database migration support
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 8/10 Requirements analysis; Specification techniques
• CPC Class Codes: G06F 8/34 Graphical or visual programming
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/103 Workflow collaboration or project management

Abstract

A system provides a high-level visual programming language input through a GUI. User inputs specify a data source, a workflow, processing logic, and a data store. Multiple instances of these primitives may be combined to generate multi-dimensional domain applications. The workflow and processing logic may be specified in a graphical user interface wherein nodes representing workflow actions or processing functions are picked from a palette and placed on a diagram. Interconnections between nodes are received in the interface and represent data flows or dependencies between nodes. The high-level visual programming inputs are the translated into low-level database commands and executed within an execution framework.

Claims

1. A method for generating data applications, the method comprising:

receiving, by a server system, a data model defining one or more data types and one or more data structure.

receiving, by the server system, a workflow, the workflow describing coordination of concurrent data processing work with respect to job dependency and precedence;

receiving, by the server system, data processing logic, the data processing logic specifying transformation of one or more input data sets into one or more output data sets and a data type of the one or more data types of the one or more output data sets to be performed during execution of the workflow;

receive, by the server system, specification of a data source to input to the workflow;

receive, by the server system, specification of a data store to store an output of the workflow; and

executing, by the server system, the workflow.

2. The method of claim 1, wherein the data source is universally addressable and is configured to receive queries including property arguments and is configured to receive assignment of input data or to be loaded with the input data.

3. The method of claim 1, wherein the data store defines a data store model describing data elements stored in the data store.

4. The method of claim 3, further comprising:

receiving, by the data store, a query;

obtaining, by the data store, a result of the query;

transforming, by the data store, the result of the query into a transformed result having a different data model that the data store model; and

returning, by the data store, the transformed result.

5. The method of claim 1, further comprising:

managing, by the server system, the creating of one or more additional data models, one or more additional workflows, and one or more additional data flows.

6. The method of claim 5, where creating the one or more additional data models, the one or more additional workflows, the one or more additional data store comprises including in at least one of the one or more additional data models, the one or more additional workflows, the one or more additional data flows references to the data model, the workflow, and the data store.

7. The method of claim 6, further comprising:

combining the one or more additional data models, the one or more additional workflows, the one or more additional data store comprises including in at least one of the one or more additional data models, the one or more additional workflows, the one or more additional data flows with the data model, the workflow, and the data store effective to generate a multi-dimensional domain application.

8. The method of claim 7, wherein executing the workflow comprises executing the workflow within an execution framework, the execution framework comprising a plurality of service engines, the service engines comprising:

a raw data repository, the data source referencing the raw data repository;

a workflow engine configured to execute the workflow;

a data engine configured to execute the data processing logic;

a data store manager configure to manage storage of data within the data store; and

a data consumption service configured to retrieve data from the raw data repository for consumption by the workflow engine.

9. The method of claim 7, further comprising executing multiple multi-dimensional domain applications including the multi-dimensional domain application simultaneously by the execution framework.

10. The method of claim 1, wherein receiving, by the server system, the specification of the data source comprises receiving, in a graphical user interface, a selection of the data source and at least one property from a graphical representation of a data source repository.

11. The method of claim 10, wherein receiving the data model comprises receiving, by the server system through the graphical user interface, a description of the data model with respect to a data hierarchy and one or more primitive data types.

12. The method of claim 11, wherein receiving the workflow comprises receiving, by the server system through the graphical user interface, placement of nodes and linking of nodes, wherein each nodes represents a sequence of commands and each link represents an execution dependency between nodes connected by the each link.

13. The method of claim 12, wherein receiving the specification of the data store comprises receiving, by the server system through the graphical user interface, selection of a data destination.

14. The method of claim 13, wherein receiving the data processing logic comprises receiving, by the server system through the graphical user interface, placement of graphical elements, each graphical element representing a primitive logic function from a library of transformation commands.

15. The method of claim 14, wherein receiving the data processing logic further comprises receiving run-time scripts through the graphical user interface.

16. The method of claim 15, wherein receiving the data model further comprises receiving definitions of derived attributes representing aggregated data values from raw data.

17. The method of claim 16, wherein receiving the data model further comprises defining named filtering logic and applying the named filtering logic to a dimension of the plurality of dimensions according to a query criteria.

18. The method of claim 17, further comprising:

receiving a custom data representation mapped to a query pattern;

aggregating data in the data store according to the custom data representation prior to receiving a query according to the query pattern.

19. A method comprising:

receiving, by a computer system, one or more dimensions and hierarchical attributes for one or more data members; and

automatically generating, by the computer system, a multidimensional data model according to the one or more dimensions and the hierarchical attributes.