Analytical Views
The Analytical Views of Arcadia Enterprise are a semantic caching mechanism that
allows users to 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.
This section includes the following topics: