Back to results
US 10,949,410 B2Granted
Multi-threaded data analytics
AssigneeSap SE
InventorJohn Alex William
Life of this patent
Estimating the term…
Abstract
Various embodiments of systems and methods to provide multi-threaded data analytics. In one aspect, a master view table is generated by retrieving data records corresponding to a plurality of entities from one or more data source tables. A plurality of aspects are determined from the generated master view table. Further, a plurality of aspect relational view tables are generated by comparing the plurality of aspects with one another based on relationship factors. At least one insight of the data records are determined by analyzing the plurality of aspect relational view tables and the master view table in multi-thread.
Claims17
A non-transitory computer-readable medium storing instructions, which when executed by a computer cause the computer to:
- generate a master view table by retrieving data records corresponding to a plurality of entities from one or more data source tables based on a master table view query;
- determine a plurality of aspects from the generated master view table based on the plurality of entities in the generated master view table, wherein each aspect is defined by a value formula based on at least one of a predefined function, a stored custom function on a data record, or a calculation on select queries of the plurality of entities using operators or conditional statements;
- determine, based on the determined plurality of aspects, a set of relationship factors between the determined plurality of aspects, wherein each of the set of relationship factors identify a predetermined comparison with or relation to two or more different aspects, and wherein the set of relationship factors comprise at least one of aggregation, progression, frequency and popularity;
- in response to determining the set of relationship factors, generate a plurality of aspect relational view tables by comparing a particular aspect of the determined plurality of aspects with each of the other aspects of the determined plurality of aspects based on the determined set of relationship factors;
- and
- determine at least one insight of the data records by analyzing the plurality of aspect relational view tables and the master view table in multi-thread, wherein determining the at least one insight of the data records by analyzing the plurality of generated aspect relationship view tables and the master view table in multi-thread comprises:
- generating a number of analytical analyzer threads corresponding to a number of generated aspect relational view tables;
- and
- generating insights, by each of the analytical analyzer threads, in parallel in different threads.
6 more elements
A computer implemented method to provide multi-threaded data analytics, comprising:
- generating a master view table by retrieving data records corresponding to a plurality of entities from one or more data source tables based on a master table view query;
- determining a plurality of aspects from the generated master view table based on the plurality of entities in the generated master view table, wherein each aspect is defined by a value formula based on at least one of a predefined function, a stored custom function on a data record, or a calculation on select queries of the plurality of entities using operators or conditional statements;
- determining, based on the determined plurality of aspects, a set of relationship factors between the determined plurality of aspects, wherein each of the set of relationship factors identify a predetermined comparison with or relation to two or more different aspects, and wherein the set of relationship factors comprise at least one of aggregation, progression, frequency and popularity;
- in response to determining the set of relationship factors, generating a plurality of aspect relational view tables by comparing a particular aspect of the determined plurality of aspects with each of the other aspects of the determined plurality of aspects based on the determined set of relationship factors;
- and
- determining at least one insight of the data records by analyzing the plurality of aspect relational view tables and the master view table in multi-thread, wherein determining the at least one insight of the data records by analyzing the plurality of generated aspect relationship view tables and the master view table in multi-thread comprises:
- generating a number of analytical analyzer threads corresponding to a number of generated aspect relational view tables;
- and
- generating insights, by each of the analytical analyzer threads, in parallel in different threads.
6 more elements
A computing system to provide multi-threaded data analytics, comprising:
- at least one processor;
- and
- one or more memory devices communicative with the at least one processor, wherein the one or more memory devices store instructions to:
- generate a master view table by retrieving data records corresponding to a plurality of entities from one or more data source tables based on a master table view query;
- determine a plurality of aspects from the generated master view table based on the plurality of entities in the generated master view table, wherein each aspect is defined by a value formula based on at least one of a predefined function, a stored custom function on a data record, or a calculation on select queries of the plurality of entities using operators or conditional statements;
- determine, based on the determined plurality of aspects, a set of relationship factors between the determined plurality of aspects, wherein each of the set of relationship factors identify a predetermined comparison with or relation to two or more different aspects, and wherein the set of relationship factors comprise at least one of aggregation, progression, frequency and popularity;
- in response to determining the set of relationship factors, generate a plurality of aspect relational view tables by comparing a particular aspect of the determined plurality of aspects with each of the other aspects of the determined plurality of aspects based on the determined set of relationship factors;
- and
- determine at least one insight of the data records by analyzing the plurality of aspect relational view tables and the master view table in multi-thread, wherein determining the at least one insight of the data records by analyzing the plurality of generated aspect relationship view tables and the master view table in multi-thread comprises:
- generating a number of analytical analyzer threads corresponding to a number of generated aspect relational view tables;
- and
- generating insights, by each of the analytical analyzer threads, in parallel in different threads.
9 more elements
Dependencies are inferred from the claim text.