Users of InetSoft's reporting software can greatly improve the performance of reports by allowing users to
distribute materialized report views that vastly improve report run-time. View the information below to learn
more about the Style Intelligence solution.
A materialized view is a construct in which data is pre-aggregated and cached, enabling Viewsheet results to
be more quickly computed at runtime. When a materialized view exists, the report engine attempts to query the
cached view rather than the original database tables, which may significantly reduce the run time for certain
queries.
Only Viewsheets that contain aggregated data can be considered candidates for materialized views. For best
performance, aggregation should generally be performed in the worksheet rather than in the Viewsheet. To
improve performance, you can distribute a materialized view across multiple machines. Materialized views are
available only for Viewsheets.
Materialized views can be managed from the 'Repository' > 'Materialized View' node under the Server tab.
The following sections provide more information about management.
You can manage existing materialized views from the 'Materialized View' page under the 'Repository' node of
the Server tab. The 'Delete' button deletes the selected materialized view, which may be useful if changes
have been made to the underlying database schemas.
You can improve Viewsheet performance substantially by distributing materialized views across multiple
machines or nodes. In this case, the materialized dataset that Enterprise Manager generates for the Viewsheet
is saved in its entirety on each individual node. This allows the Viewsheet server to pull small blocks of
data from each of the nodes, minimizing the input-output demands (hard disk access) on a particular machine.
The reduced input-output load allows the Viewsheet to be generated and updated much more quickly. For this
reason also, best performance is achieved by using a large number of average machines, rather than a small
number of very powerful machines.
More Articles About Reporting
Better Than ClicData - So how does InetSoft's Style Intelligence weigh against ClicData? From the latest G2 crowd ratings, it is pretty impressive. InetSoft has received rave reviews from a majority of its users and beats ClicData in various categories across the board. Style Intelligence has been lauded for its robustness and described as a complete and powerful go-to tool for data analysis. To begin with, InetSoft has done extremely well in general usage ratings, winning over ClicData in Meets Requirements, Quality of Support and Ease of Doing business with...
Evaluate InetSoft's Solution for Analytical Performance Management - Are you looking for a good a good solution for analytical performance management? InetSoft's pioneering dashboard analytics application maximizes self-service for all types of users, from data scientists to business managers. Get cloud-flexibility for your deployment. Minimize costs with a small-footprint solution. No dedicated BI developer required. View a demo and try interactive examples...
Machine Learning Applications for Better Marketing - Now is a great time to work in the marketing department, as in the modern information world, marketing is becoming increasingly important in most organizations. But it also means that the life of the marketer has become more complicated, despite all the tools at his disposal. Marketing specialists have to solve many problems: how to get ahead in the conditions of fierce competition; how to increase customer loyalty; reorientation of a business from a product to a client; the saturation of social networks, where everyone is now a content provider...
ML Can Recognize Anomalies - Another example is recognizing anomalies. For instance, an unusual sequence of credit card transactions will be an anomaly. Another example of an anomaly would be an unusual pattern of sensor readings in a nuclear power plant, and you wouldn't really want to have to deal with those anomaly detection analyses by doing supervised learning, which is where you look at the cases that led to an accident and see what caused them to blow up. You'd really like to recognize that something funny is happening without having any supervision signal. You want to know when the system is just not behaving in its normal way...
Replacing Tableau's Reporting Tool - Many of InetSoft's customers have switched from Tableau. Reasons for their choice include more flexible pricing for scaling up users or for embedding in a cloud-based solution and for more powerful data mashup and manipulation. In addition, InetSoft's reporting solution has more mature enterprise reporting capabilities such as generating pixel-perfect production reports and delivering interactive reports in a zero-client, web environment. At its foundation is a data intelligence platform which solves data management challenges such as connecting to and transforming data from disparate sources...