An OLAP-Based Approach to Modeling and Querying Granular Temporal Trends

  • Alberto Sabaini
  • Esteban Zimányi
  • Carlo Combi
Part of the Lecture Notes in Computer Science book series (LNCS, volume 8646)


Data warehouses contain valuable information for decision-making purposes, they can be queried and visualised with Online Analytical Processing (OLAP) tools. They contain time-related information and thus representing and reasoning on temporal data is important both to guarantee the efficacy and the quality of decision-making processes, and to detect any emergency situation as soon as possible. Several proposals deal with temporal data models and query languages for data warehouses, allowing one to use different time granularities both when storing and when querying data. In this paper we focus on two aspects pertaining to temporal data in data warehouses, namely, temporal patterns and temporal granularities. We first motivate the need for discovering granular trends in an OLAP context. Then, we propose a model for analyzing granular temporal trends in time series by taking advantage of the hierarchical structure of the time dimension.


Query Language Data Warehouse Multidimensional Model City Level Time Granularity 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Combi, C., Pozzi, G., Rossato, R.: Querying temporal clinical databases on granular trends. Journal of Biomedical Informatics 45(2), 273–291 (2012)CrossRefGoogle Scholar
  2. 2.
    Eder, J., Koncilia, C., Morzy, T.: The COMET metamodel for temporal data warehouses. In: Pidduck, A.B., Mylopoulos, J., Woo, C.C., Ozsu, M.T. (eds.) CAiSE 2002. LNCS, vol. 2348, pp. 83–99. Springer, Heidelberg (2002)CrossRefGoogle Scholar
  3. 3.
    Golfarelli, M., Maio, D., Rizzi, S.: The dimensional fact model: A conceptual model for data warehouses. Int. J. Cooperative Inf. Syst. 7(2-3), 215–247 (1998)CrossRefGoogle Scholar
  4. 4.
    Kaikhah, K., Doddameti, S.: Discovering trends in large datasets using neural networks. Appl. Intell. 24(1), 51–60 (2006)CrossRefGoogle Scholar
  5. 5.
    Khatri, V., Ram, S., Snodgrass, R.T., Terenziani, P.: Capturing telic/atelic temporal data semantics: Generalizing conventional conceptual models. IEEE Trans. Knowl. Data Eng. 26(3), 528–548 (2014)CrossRefGoogle Scholar
  6. 6.
    Lee, J.Y., Elmasri, R.: An EER-based conceptual model and query language for time-series data. In: Ling, T.-W., Ram, S., Li Lee, M. (eds.) ER 1998. LNCS, vol. 1507, pp. 21–34. Springer, Heidelberg (1998)CrossRefGoogle Scholar
  7. 7.
    Malinowski, E., Zimányi, E.: A conceptual model for temporal data warehouses and its transformation to the ER and the object-relational models. Data Knowl. Eng. 64(1), 101–133 (2008)CrossRefGoogle Scholar
  8. 8.
    Wijsen, J.: Reasoning about qualitative trends in databases. Inf. Syst. 23(7), 463–487 (1998)CrossRefGoogle Scholar

Copyright information

© Springer International Publishing Switzerland 2014

Authors and Affiliations

  • Alberto Sabaini
    • 1
  • Esteban Zimányi
    • 2
  • Carlo Combi
    • 1
  1. 1.Department of Computer ScienceUniversity of VeronaItaly
  2. 2.Department of Computer and Decision EngineeringUniversité Libre de BruxellesBelgium

Personalised recommendations