The data warehouse includes aggregated data that is calculated using the data stored in the data warehouse tables. Components running on the data warehouse loader server refresh the calculated data at regular intervals so that it is available for reports. Performing intensive calculations before they are needed improves the speed of the queries that use the calculated data.
In Oracle database schemas, the aggregated data calculations are presented as virtual tables using materialized views. Other supported database products provide views or other comparable functions to make aggregated data available.
The virtual tables used for search reporting are:
ARF_SEARCH_MV_TYPE -- Aggregates search information based on search type, language, site, and date.
ARF_SEARCH_MV_HOUR -- Aggregates search information based on date and time, search type, site, and language.
ARF_SEARCH_MV_VISIT -- Aggregates information about the average number of search requests per site visit.
ARF_SEARCH_MV_SEARCH_TERM -- Aggregates search information based on search term, search type, site, and language.
ARF_SEARCH_MV_FACET_GROUP -- Aggregates search information based on facet group, search type, language, and site.
