Skip to main content

Fuzzy OLAP: A Formal Definition

  • Conference paper
Advances in Computational Intelligence

Part of the book series: Advances in Intelligent and Soft Computing ((AINSC,volume 116))

Abstract

Real world is pervaded of imprecision and uncertainty. These characteristics are well represented in computational systems by means of fuzzy logic. Some systems produce vital data that must be stored for its posterior analysis supporting decision making through OLAP. At present time this data may involve imprecision and uncertainty, therefore fuzzy OLAP operators must be provided. We do that in this paper in a formal way, giving a rigorous definition of fuzzy logic extended OLAP operators.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 429.00
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 549.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Fukami, S., Umano, M., Muzimoto, M., Tanaka, H.: Fuzzy Database Retrieval and Manipulation Language IEICE Technical Reports, vol. 78, pp. 65-72. AL-78-85 (Automata and Language) (1979)

    Google Scholar 

  2. Umano Freedom-O, M.: A Fuzzy Database System. In: Gupta-Sanchez (ed.) Fuzzy Information and Decision Processes. North-Holland Pub. Comp., Amsterdam (1982)

    Google Scholar 

  3. Galindo, J., Urrutia, A., Piattini, M.: Representation of Fuzzy Knowledge in Relational Databases. In: Proceedings of the 15th International Workshop on Databases and Expert Systems Applications, DEXA 2004, pp. 917–921 (2004)

    Google Scholar 

  4. Vassiliadis, P.: Modeling Multidimensional Databases, Cubes and Cube Operations. Statistical and Scientific Database Management, 53–62 (1998)

    Google Scholar 

  5. Feng, L., Dillon, T.S.: Using Fuzzy Linguistic Representations to Provide Explanatory Semantics for Data Warehouses. IEEE Transactions on Knowledge and Data Engineering 15(1), 86–102 (2003)

    Article  Google Scholar 

  6. Pavan Kumar, K.V.N.N., Radha Krishna, P., Kumar De, S.: Fuzzy OLAP cube for qualitative analysis. Intelligent Sensing and Information Processing, 290–295 (2005)

    Google Scholar 

  7. González, C., Mirisola, R., Tineo, L.J., Urrutia, A.: A model for fuzzy multidimensional spaces. In: Meersman, R., Tari, Z., Herrero, P. (eds.) OTM-WS 2007, Part I. LNCS, vol. 4805, pp. 21–22. Springer, Heidelberg (2007)

    Chapter  Google Scholar 

  8. Bosc, P., Pivert, O.: SQLf: A Relational Database Language for Fuzzy Querying. IEEE Trans. on Fuzzy Systems 3(1) (1995)

    Google Scholar 

  9. Fukami, S., Umano, M.: Fuzzy Relational Algebra for Possibility-Distribution-Fuzzy-Relational Model of Fuzzy Data. Journal of Intelligent Information System 3, 7–27 (1994)

    Article  Google Scholar 

  10. Galindo, J.: New Characteristics in FSQL, a Fuzzy SQL for Fuzzy Databases. WSEAS Transactions on Information Science and Applications 2 2, 161–169 (2005)

    Google Scholar 

  11. Galindo, J., Urrutia, A., Piattini, M.: Fuzzy Database Modeling, Design and Implementation. Idea Group Publishing (2006)

    Google Scholar 

  12. Kacpryzyk, J., Zadrozny, S.: Fuzzy Queries in Microsoft AccessTM v.2. In: Proceedings of Fuzzy IEEE 1995 Workshop on Fuzzy Database Systems and Information Retrieval, pp. 61–66 (1995)

    Google Scholar 

  13. Loo, G., Lee, K.: An interface to databases for flexible query answering: A fuzzy-set approach. In: Ibrahim, M., Küng, J., Revell, N. (eds.) DEXA 2000. LNCS, vol. 1873, p. 654. Springer, Heidelberg (2000)

    Chapter  Google Scholar 

  14. Ma, Z.M., Yan, L.: Generalization of Strategies for Fuzzy Query Translation in Classical Relational Databases. Information and Software Technology 49(2) (February 2007)

    Google Scholar 

  15. Medina, J., Vila, M.A., Pons, O.: GEFRED: A Generalized Model of Fuzzy Relational Databases. Informatizan Sciences (1993)

    Google Scholar 

  16. Nakajima, H., Sogoh, T., Arao, M.: Fuzzy Database Language and Library-Fuzzy Extension to SQL. In: Proceedings of Second IEEE International Conference on Fuzzy Systems, pp. 477–482 (1983)

    Google Scholar 

  17. Wong, M., Leung, K.: A fuzzy Database-Query Language. Information Systems 15(5), 583–590 (1990); Zadeh, L.A.: Fuzzy sets. Information and Control 8 (1965)

    Article  Google Scholar 

  18. Zadeh, L.A.: Fuzzy sets. Information and Control 8 (1965)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2009 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

González, C., Tineo, L., Urrutia, A. (2009). Fuzzy OLAP: A Formal Definition. In: Yu, W., Sanchez, E.N. (eds) Advances in Computational Intelligence. Advances in Intelligent and Soft Computing, vol 116. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-03156-4_19

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-03156-4_19

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-03155-7

  • Online ISBN: 978-3-642-03156-4

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics