# US 2016/0259626 A1 · Systems and methods for generating data visualization applications

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2016/0259626 A1
- Document ID: US20160259626A1
- Status: Published application
- Kind: A1
- Application number: 15/052,449
- Filed: 2016-02-24
- Published: 2016-09-08
- Earliest claimed: 2015-03-06
- Assignees: Saggezza Inc.
- Applicants: Saggezza Inc.
- Inventors: BALAJI T. THATTAI; Karthikeyan Shanmugam; Chi Yao; Yee Lang Lau
- Web page: https://patentgrep.com/patent/US20160259626A1

## CPC

- G06F 8/10: Requirements analysis; Specification techniques
- G06F 8/34: Graphical or visual programming
- G06F 16/212: {with details for data modelling support}
- G06F 16/214: {Database migration support}
- G06F 16/25: Integrating or interfacing systems involving database management systems
- G06Q 10/06: Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q 10/103: {Workflow collaboration or project management}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- G06Q: INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR

## 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

### Claim 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.

### Claim 2 (depends on 1)

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.

### Claim 3 (depends on 1)

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

### Claim 4 (depends on 3)

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.

### Claim 5 (depends on 1)

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.

### Claim 6 (depends on 5)

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.

### Claim 7 (depends on 6)

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.

### Claim 8 (depends on 7)

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.

### Claim 9 (depends on 7)

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

### Claim 10 (depends on 1)

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.

### Claim 11 (depends on 10)

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.

### Claim 12 (depends on 11)

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.

### Claim 13 (depends on 12)

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.

### Claim 14 (depends on 13)

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.

### Claim 15 (depends on 14)

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

### Claim 16 (depends on 15)

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

### Claim 17 (depends on 16)

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.

### Claim 18 (depends on 17)

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.

### Claim 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.
