Analytical Views
Understanding and implementing analytical views.
The Analytical Views of Arcadia Enterprise are a semantic caching mechanism that allows users to pre-compute and cache results of expensive SQL operations, such as grouping and aggregation. Analytical views confer a number of significant performance benefits.
- Queries from apps are automatically routed to analytical views with matching SQL expressions.
- Predictable workloads (querying) can be optimized and completed within a few seconds.
- As the workload becomes more predictable, the implicit use of analytical views increases.
- Arcadia Engine incrementally refreshes analytical views that are well-partitioned
(and partitioned identically to the base tables). This leads to measurable
performance advantages. The same is true for analytical views defined on top of
logical views that reference a single base table.
Analytical Views topics include the following: