Trajectory Data Warehouses - Data Warehouse Systems: Design and Implementation - page 485

12.5 Querying the Northwind Trajectory Data
Warehouse in SQL
In order to address queries to the Northwind trajectory data warehouse, we
first translate the conceptual schema in Fig. 12.6 into a snowflake schema, as
showninFig. 12.9 . To express our queries, we use the temporal types and
their associated operations as defined in Sect. 12.3 .
Fig. 12.9 Relational representation of the Northwind trajectory data warehouse in
Fig. 12.6
We start with a conventional OLAP query.
Query 12.1. Total number of segments, by road, covered by Volvo trucks
in February 2012.