Reporting system for transaction server using cluster stored and processed data

Patent metadata

Field	Value
Publication number	US-2017286506-A1
Application number	US-201615085880-A
Country	US
Kind code	A1
Filing date	Mar 30, 2016
Priority date	Mar 30, 2016
Publication date	Oct 5, 2017
Grant date	—

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.

First claim

What is claimed is:

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.

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

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

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

5 . 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.

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

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

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

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

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

11 . 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.

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

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

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

15 . 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.

16 . 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.

17 . 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.

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.

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.

Assignees

• Workday Inc

Inventors

• Yin Nianlong
• Chen Jian Ping
• Malkani Anil
• Samel Manoj
• Ivanov Aleksandar

Classifications

• G06F16/254 Primary

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

• G06F21/62

  Protecting access to data via a platform, e.g. using keys or access control rules · CPC title

• G06F17/30563 Primary

  Physics · mapped topic