# US 2014/0156588 A1 · Systems and methods for performing customized large-scale data analytics > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 2014/0156588 A1 - Document ID: US20140156588A1 - Status: Published application - Kind: A1 - Application number: 14/025,755 - Filed: 2013-09-12 - Published: 2014-06-05 - Earliest claimed: 2012-11-30 - Assignees: Symantec Corporation - Applicants: Symantec Corporation - Inventors: Shubhabrata Mohanty; Sujit Manolikar - Web page: https://patentgrep.com/patent/US20140156588A1 ## CPC - G06F 16/21: Design, administration or maintenance of databases - G06F 16/283: {Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP} - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) ## Abstract A computer-implemented method for performing customized large-scale data analytics may include (1) providing a logical-data-model user interface to enable modifying a logical data model of a relational multi-dimensional analytic database, (2) receiving, via the logical-data-model user interface, user input to modify the logical data model of the relational multi-dimensional analytic database, (3) modifying the logical data model of the relational multi-dimensional analytic database based on the user input, (4) providing a visualization user interface, based on the logical data model, to enable performing online analytical processing operations, and (5) receiving, via the visualization user interface, a request to perform an online analytical processing operation that provides a view of data stored within the relational multi-dimensional analytic database in accordance with the logical data model. Various other methods, systems, and computer-readable media are also disclosed. ## Claims ### Claim 1 A computer-implemented method for performing customized large-scale data analytics, at least a portion of the method being performed by a computing device comprising at least one processor, the method comprising: providing a logical-data-model user interface to enable modifying a logical data model of a relational multi-dimensional analytic database; receiving, via the logical-data-model user interface, user input to modify the logical data model of the relational multi-dimensional analytic database; modifying the logical data model of the relational multi-dimensional analytic database based on the user input by adding a dimension to the logical data model that corresponds to data stored within the relational multi-dimensional analytic database; providing a visualization user interface to enable performing online analytical processing operations on a multi-dimensional dataset defined by the logical data model, wherein the multi-dimensional dataset defined by the logical data model excludes at least one dimension corresponding to data stored within the relational multi-dimensional analytic database; receiving, via the visualization user interface, a request to perform an online analytical processing operation that provides a view of data stored within the relational multi-dimensional analytic database in accordance with the logical data model. ### Claim 2 (depends on 1) The computer-implemented method of claim 1, further comprising performing the online analytical processing operation. ### Claim 3 (depends on 2) The computer-implemented method of claim 2, wherein performing the online analytical processing operation comprises: generating a database query based on the request and the logical data model; performing the database query. ### Claim 4 (depends on 1) The computer-implemented method of claim 1, wherein the online analytical processing operation comprises at least one of: a roll-up operation that creates an aggregated view of data across a specified dimension; a drill-down operation that creates a differentiated view of data within a specified dimensional value; a slicing operation that creates a lower-dimensional view of data by limiting a specified dimension to a specified dimensional value; a dicing operation that creates a view that excludes at least one dimensional value of at least one dimension. ### Claim 5 (depends on 1) The computer-implemented method of claim 1, further comprising: retrieving new data from a plurality of data stores; normalizing the new data; populating the relational multi-dimensional analytic database with the new data. ### Claim 6 (depends on 5) The computer-implemented method of claim 5, wherein normalizing the new data comprises analyzing the new data by correlating data entries within the new data. ### Claim 7 (depends on 5) The computer-implemented method of claim 5, wherein normalizing the new data comprises analyzing the new data to identify at least one of: a security threat; a security vulnerability; a security risk; a security incident trend. ### Claim 8 (depends on 5) The computer-implemented method of claim 5, wherein: retrieving the new data from the plurality of data stores comprises retrieving the new data from the plurality of data stores in parallel; normalizing the new data comprises normalizing the new data from the plurality of data stores in parallel. ### Claim 9 (depends on 1) The computer-implemented method of claim 1, wherein modifying the logical data model of the relational multi-dimensional analytic database based on the user input comprises modifying at least one of: a dimension within the logical data model of the relational multi-dimensional analytic database; a measure within the logical data model of the relational multi-dimensional analytic database; a hierarchical dimension with the logical data model of the relational multi-dimensional analytic database; a cardinality within the logical data model of the relational multi-dimensional analytic database. ### Claim 10 A system for performing customized large-scale data analytics, the system comprising: a providing module that provides a logical-data-model user interface to enable modifying a logical data model of a relational multi-dimensional analytic database; a receiving module that receives, via the logical-data-model user interface, user input to modify the logical data model of the relational multi-dimensional analytic database; a modifying module that modifies the logical data model of the relational multi-dimensional analytic database based on the user input by adding a dimension to the logical data model that corresponds to data stored within the relational multi-dimensional analytic database; a visualization module that provides a visualization user interface to enable performing online analytical processing operations on a multi-dimensional dataset defined by the logical data model, wherein the multi-dimensional dataset defined by the logical data model excludes at least one dimension corresponding to data stored within the relational multi-dimensional analytic database; a request module that receives, via the visualization user interface, a request to perform an online analytical processing operation that provides a view of data stored within the relational multi-dimensional analytic database in accordance with the logical data model; at least one processor configured to execute the providing module, the receiving module, the modifying module, the visualization module, and the request module. ### Claim 11 (depends on 10) The system of claim 10, further comprising a performing module that performs the online analytical processing operation. ### Claim 12 (depends on 11) The system of claim 11, wherein the performing module performs the online analytical processing operation by: generating a database query based on the request and the logical data model; performing the database query. ### Claim 13 (depends on 10) The system of claim 10, wherein the online analytical processing operation comprises at least one of: a roll-up operation that creates an aggregated view of data across a specified dimension; a drill-down operation that creates a differentiated view of data within a specified dimensional value; a slicing operation that creates a lower-dimensional view of data by limiting a specified dimension to a specified dimensional value; a dicing operation that creates a view that excludes at least one dimensional value of at least one dimension. ### Claim 14 (depends on 10) The system of claim 10, further comprising a normalization module that: retrieves new data from a plurality of data stores; normalizes the new data; populates the relational multi-dimensional analytic database with the new data. ### Claim 15 (depends on 14) The system of claim 14, wherein the normalizing module normalizes the new data by analyzing the new data by correlating data entries within the new data. ### Claim 16 (depends on 14) The system of claim 14, wherein the normalizing module normalizes the new data by analyzing the new data to identify at least one of: a security threat; a security vulnerability; a security risk; a security incident trend. ### Claim 17 (depends on 14) The system of claim 14, wherein: the retrieving module retrieves the new data from the plurality of data stores by retrieving the new data from the plurality of data stores in parallel; the normalizing module normalizes the new data by normalizing the new data from the plurality of data stores in parallel. ### Claim 18 (depends on 10) The system of claim 10, wherein the modifying module modifies the logical data model of the relational multi-dimensional analytic database based on the user input by modifying at least one of: a dimension within the logical data model of the relational multi-dimensional analytic database; a measure within the logical data model of the relational multi-dimensional analytic database; a hierarchical dimension with the logical data model of the relational multi-dimensional analytic database; a cardinality within the logical data model of the relational multi-dimensional analytic database. ### Claim 19 A non-transitory computer-readable-storage medium comprising one or more computer-readable instructions that, when executed by at least one processor of a computing device, cause the computing device to: provide a logical-data-model user interface to enable modifying a logical data model of a relational multi-dimensional analytic database; receive, via the logical-data-model user interface, user input to modify the logical data model of the relational multi-dimensional analytic database; modify the logical data model of the relational multi-dimensional analytic database based on the user input by adding a dimension to the logical data model that corresponds to data stored within the relational multi-dimensional analytic database; provide a visualization user interface to enable performing online analytical processing operations on a multi-dimensional dataset defined by the logical data model, wherein the multi-dimensional dataset defined by the logical data model excludes at least one dimension corresponding to data stored within the relational multi-dimensional analytic database; receive, via the visualization user interface, a request to perform an online analytical processing operation that provides a view of data stored within the relational multi-dimensional analytic database in accordance with the logical data model. ### Claim 20 (depends on 19) The non-transitory computer-readable-storage medium of claim 19, wherein the one or more computer-readable instructions cause the computing device to perform the online analytical processing operation.