# US 2017/0286506 A1 · Reporting system for transaction server using cluster stored and processed data

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

- Number: US 2017/0286506 A1
- Document ID: US20170286506A1
- Status: Published application
- Kind: A1
- Application number: 15/085,880
- Filed: 2016-03-30
- Published: 2017-10-05
- Earliest claimed: 2016-03-30
- Assignees: Workday, Inc.
- Applicants: Workday, Inc.
- Inventors: Nianlong Yin; Jian Ping Chen; Anil Malkani; Manoj Samel; Aleksandar Ivanov
- Web page: https://patentgrep.com/patent/US20170286506A1

## CPC

- G06F 16/254: {Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A system for reporting for a transaction server using cluster stored and processed data. The system comprises a processor and an interface. The processor is to cause ingestion of data from an ingestion source on a cluster system and store a security definition and a transformation definition for one or more data sources that are derived from the data from the ingestion source. The security definition includes a tenant associated with each data source of the one or more data sources. The processor is further to cause execution of cluster processing associated with a report using the one or more data sources and based at least in part on a determination of authorization using the security definitions to produce an output of the cluster processing and generate a report using a transaction server process and the output of the cluster processing. The interface is to provide the report.

## Claims

### Claim 1

A system for managing data, comprising:
a processor to:
cause ingestion of data from an ingestion source on a cluster system;
store a security definition and a transformation definition for one or more data sources that are derived from the data from the ingestion source, wherein the security definition includes a tenant associated with each data source of the one or more data sources;
cause execution of cluster processing associated with a report using the one or more data sources and based at least in part on a determination of authorization using the security definitions to produce an output of the cluster processing; and
generate a report using a transaction server process and the output of the cluster processing; and
an interface to:
provide the report.

### Claim 2 (depends on 1)

The system of claim 1, wherein the data from the ingestion source is stored on the cluster system.

### Claim 3 (depends on 2)

The system of claim 2, wherein a location of the data is stored in an index.

### Claim 4 (depends on 2)

The system of claim 2, wherein a location of the data is stored in a data structure on a transaction database.

### Claim 5 (depends on 2)

The system of claim 2, wherein a location of the data is stored in a reference location of an object stored in a transaction database.

### Claim 6 (depends on 1)

The system of claim 1, wherein the data is converted after ingestion.

### Claim 7 (depends on 6)

The system of claim 6, wherein the data conversion includes fitting data into a data structure.

### Claim 8 (depends on 1)

The system of claim 1, wherein the ingestion source is one of a plurality of ingestion sources.

### Claim 9 (depends on 1)

The system of claim 1, wherein the security definition and the transformation definition are stored on the transaction server.

### Claim 10 (depends on 1)

The system of claim 1, wherein the cluster processing comprises a data transform of the transformation definition.

### Claim 11 (depends on 10)

The system of claim 10, wherein the data transform comprises one or more of the following: selecting a column, filtering rows, grouping data, subsetting data, joining data, or chaining data.

### Claim 12 (depends on 1)

The system of claim 1, wherein the processor is further to receive an indication to ingest the data set.

### Claim 13 (depends on 12)

The system of claim 12, wherein the indication to ingest data comprises an indication to schedule data ingestion.

### Claim 14 (depends on 12)

The system of claim 12, wherein the indication to ingest data comprises authentication information.

### Claim 15 (depends on 1)

The system of claim 1, wherein the interface is further to provide a data structure associated with the ingested the data set to the cluster system.

### Claim 16 (depends on 1)

The system of claim 1, wherein the determination of authorization comprises determining whether the cluster processing and the one or more data sources are both associated with the tenant.

### Claim 17 (depends on 1)

The system of claim 1, wherein determination of authorization comprises determining whether a user requesting a report associated with the cluster processing is associated with the tenant.

### Claim 18

A method for managing data, comprising:
causing, using a processor, ingestion of data from ingestion source on a cluster system;
storing a security definition and a transformation definition for one or more data sources that are derived from the data from the ingestion source, wherein the security definition includes a tenant associated with each data source of the one or more data sources;
causing execution of cluster processing associated with a report using the one or more data sources and based at least in part on a determination of authorization using the security definitions to produce an output of the cluster processing;
generating a report using a transaction server process and the output of the cluster processing; and
providing the report.

### Claim 19

A computer program product for managing data, the computer program product being embodied in a non-transitory computer readable storage medium and comprising computer instructions for:
causing, using a processor, ingestion of data from ingestion source on a cluster system;
storing a security definition and a transformation definition for one or more data sources that are derived from the data from the ingestion source, wherein the security definition includes a tenant associated with each data source of the one or more data sources;
causing execution of cluster processing associated with a report using the one or more data sources and based at least in part on a determination of authorization using the security definitions to produce an output of the cluster processing;
generating a report using a transaction server process and the output of the cluster processing; and
providing the report.
