Managing Quality Properties in a ROLAP Environment

  • Adriana Marotta
  • Federico Piedrabuena
  • Alberto Abelló
Part of the Lecture Notes in Computer Science book series (LNCS, volume 4001)


In this work we propose, for an environment where multidimensional queries are made over multiple Data Marts, techniques for providing the user with quality information about the retrieved data. This meta-information behaves as an added value over the obtained information or as an additional element to take into account during the proposition of the queries. The quality properties considered are freshness, availability and accuracy. We provide a set of formulas that allow estimating or calculating the values of these properties, for the result of any multidimensional operation of a predefined basic set.


Measure Attribute Quality Property Relational Algebra Dimension Table Fact Table 
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.
    Naumann, F., Leser, U., Freytag, J.C.: Quality-driven Integration of Heterogenous Information Systems. In: VLDB 1999, pp. 447–458 (1999)Google Scholar
  2. 2.
    Marotta, A., Ruggia, R.: Quality Management in Muti-Source Information Systems. In: II Workshop de Bases de Datos, Jornadas Chilenas de Computación (JCC 2003), Chile (November 2003)Google Scholar
  3. 3.
    Marotta, A., Ruggia, R.: Managing Source Quality Changes in Data Integration Systems. In: Second International Workshop on Data and Information Quality (DIQ 2005) (in conjunction with CAISE), June 14, 2005, Porto, Portugal (2005) Google Scholar
  4. 4.
    Bach Pedersen, T., Shoshani, A., Gu, J., Jensen, C.: Extending OLAP Querying to External Object Databases. In: Int. Conf. on Information and Knowledge Management. CIKM 2000 (2000)Google Scholar
  5. 5.
    Pedersen, D., Riis, K., Bach Pedersen, T.: Query optimization for OLAP-XML federations. In: ACM Fifth International Workshop on Data Warehousing and OLAP, USA (November 2002)Google Scholar
  6. 6.
    Motro, A., Rakov, I.: Estimating the Quality of Databases. In: Andreasen, T., Christiansen, H., Larsen, H.L. (eds.) FQAS 1998. LNCS (LNAI), vol. 1495, pp. 298–307. Springer, Heidelberg (1998)CrossRefGoogle Scholar
  7. 7.
    Peralta, V., Ruggia, R., Kedad, Z., Bouzeghoub, M.: A Framework for Data Quality Evaluation in a Data Integration System. In: 19º Simposio Brasileiro de Banco de Dados (SBBD 2004), Brasil (October 2004)Google Scholar
  8. 8.
    Abelló, A., Samos, J., Saltor, F.: Implementing Operations to Navigate Semantic Star Schemas (© ACM). In: 6th International Workshop on Data Warehousing and OLAP (DOLAP 2003), New Orleans (USA) (November 2003)Google Scholar
  9. 9.
    Abelló, A., Samos, J., Saltor, F.: YAM2 (Yet Another Multidimensional Model): An Extension of UML. In: International Database Engineering & Applications Symposium, IDEAS 2002, Edmonton, Canada, July 17-19 (2002)Google Scholar
  10. 10.
    Romero, O., Abelló, A.: Improving automatic SQL translation for ROLAP tools. In: Thomson (eds.) Proceedings of Jornadas de Ingeniería del Software y Bases de Datos (JISBD 2005), Granada (Spain), pp. 123–130 (September 2005), ISBN 84-9732-434-XGoogle Scholar
  11. 11.
    Piedrabuena, F., Tercia, S., Vazquez, G.: Federation Ontology for Multi-Source Information Systems. Internal Report. Instituto de Computación, Facultad de Ingeniería, Uruguay (2005)Google Scholar
  12. 12.
    Lee, Y.W., Strong, D.M., Kahn, B.K., Wang, R.Y.: AIMQ: A Methodology for Information Quality Assessment. Information & Management. Elsevier Science, North Holland (accepted, 2001)Google Scholar
  13. 13.
    Theodoratos, D., Bouzeghoub, M.: Data Currency Quality Factors in Data Warehouse Design. In: Proc. of the Int. Workshop on Design and Management of Data Warehouses (DMDW 1999), Germany (1999)Google Scholar
  14. 14.
    Bouzeghoub, M., Peralta, V.: A Framework for Analysis of Data Freshness. In: 1st Int. Workshop on Information Quality in Information Systems (IQIS), Paris, France (June 2004)Google Scholar
  15. 15.
    Motro, A.: Accommodating Imprecision in Database Systems: Issues and Solutions. ACM SIGMOD Record (Special issue on directions for future DBMS research and development) 19(4), 69–74 (1990)Google Scholar
  16. 16.
    Strong, D.M., Lee, Y.W., Wang, R.Y.: Data Quality in Context. Communications of the ACM 40(5) (May 1997)Google Scholar
  17. 17.
    Availability (last accessed: (October 9, 2005)),

Copyright information

© Springer-Verlag Berlin Heidelberg 2006

Authors and Affiliations

  • Adriana Marotta
    • 1
  • Federico Piedrabuena
    • 1
  • Alberto Abelló
    • 2
  1. 1.Instituto de ComputaciónUniversidad de la RepúblicaMontevideoUruguay
  2. 2.Universitat Politècnica de CatalunyaBarcelonaEspaña

Personalised recommendations