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.
• Analytical views that are well-partitioned (and partitioned identically to the base tables), enable incremental refresh and lead to measurable performance advantages.