Skip to main content
SpringerLink
Log in

Enhancing Data Warehousing with Fuzzy Technology

  • Conference paper
  • First Online:
Database and Expert Systems Applications (DEXA 1999)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 1677))

Included in the following conference series:

Abstract

A data warehouse integrates large amounts of extracted and summarized data from multiple sources for direct querying and analysis. While it provides decision makers with easy access to such historical and aggregate data, the real meaning of the data has been ignored. For example, “Whether a total sales amount 1000 items indicates a good or bad sales performance is still unclear.” From the decision makers’ point of view, the semantics rather than raw numbers which convey the meaning of the data is very important. In this paper, we explore fuzzy technology to provide this semantics for the summarizations and aggregates developed in data warehousing systems. A three-layered data summarization architecture, namely, quantitative (numerical) summarization, qualitative (categorical) summarization, and quantifier summarization, is proposed. To facilitate the construction of these three summarization levels, two operators are introduced. We provide query capabilities against such enhanced data warehouses by extensions of SQL.

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

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 84.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 109.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. S. Agarwal, R. Agrawal, P. Deshpande, A. Gupta, J.F. Naughton, R. Ramakrishnan, and S. Sarawagi. On the computation of multidimensional aggregates. In Proc. 22th Intl. Conf. Very Large Data Bases, Mumbai, India, September 1996.

    Google Scholar 

  2. P. Bosc. Some approaches for processing SQLf nested queries. Intelligent Systems, 11(9):65–74, September 1996.

    Google Scholar 

  3. L. Cabibbo and R. Torlone. From a procedural to a visual query language for OLAP. In Proc. IEEE Intl. Conf. Very Large Data Bases, Bombay, India, 1996.

    Google Scholar 

  4. S. Chaudhuri and U. Dayal. An overview of data warehousing and OLAP technology. SIGMOD Record, 26(1):65–74, 1997.

    Article  Google Scholar 

  5. Earl Cox. The Fuzzy Systems Handbook. Academic Press, Inc., 1994.

    Google Scholar 

  6. P. Deshpande, K. Ramasamy, A. Shukla, and J.F. Naughton. Caching multidimensional queries using chunks. In Proc. ACM SIGMOD Intl. Conf. Management of Data, pages 271–282, 1998.

    Google Scholar 

  7. D. Dubois, F. Esteva, P. Garcia, L. Godo, D.M.R. Lopez, and H. Prade. Fuzzy set modelling in case-based reasoning. Intelligent Systems, 13:301–374, 1996.

    Google Scholar 

  8. H. Garcia-Molina, W. Labio, and J. Yang. Expiring data in a warehouse. In Proc. 23th Intl. Conf. Very Large Data Bases, New York, USA, August 1998.

    Google Scholar 

  9. H. Gupta. Selection of views to materialize in a data warehouse. In Proc. 23th Intl. Conf. Very Large Data Bases, Athens, Greece, 1997.

    Google Scholar 

  10. R. Jang. ANFIS: adaptive-network-based fuzzy inference system. IEEE Transactions on Systems, Man, and Cybernetics, 23(3):665–685, 1993.

    Article  MathSciNet  Google Scholar 

  11. T. Johnson and D. Shasha. Some approaches to index design for cube forests. IEEE Data Engineering Bulletin, 20(1):27–35, March 1997.

    Google Scholar 

  12. G.J. Klir and T.A. Folger. Fuzzy Sets, Uncertainty and Information. Prentice Hall, Inc., 1988.

    Google Scholar 

  13. S. Smith and D. Comer. Automated calibration of a fuzzy logic controller using a cell state space algorithm. IEEE Control Sytems Magazine, pages 18–28, 1991.

    Google Scholar 

  14. T. Takagi and M. Sugeuo. Fuzzy identification of systems and its applications to modelling and control. IEEE Transactions on Systems, Man, and Cybernetics, 15(1):116–131, 1985.

    MATH  Google Scholar 

  15. J. Widom. Research problems in data warehousing. In Proc. Intl. Conf. Information and Knowledge Management, 1995.

    Google Scholar 

  16. M.C. Wu and A.P. Buchmann. Encoded bitmap indexing for data warehouses. In Proc. Intl. Conf. Data Engineering, pages 220–230, 1998.

    Google Scholar 

  17. R.R. Yager. Quantifiers in the formulation of multiple objective decision functions. Information Science, 31:107–139, 1983.

    Article  MATH  MathSciNet  Google Scholar 

  18. R.R. Yager. Connectives and quantifiers in fuzzy sets. Fuzzy Sets Systems, 40:39–76, 1991.

    Article  MATH  MathSciNet  Google Scholar 

  19. R.R. Yager. Database discovery using fuzzy sets. Intelligent Systems, 11(9):691–712, September 1996.

    Article  Google Scholar 

  20. L.A. Zadeh. Fuzzy sets. Information and Control, 8:338–353, 1965.

    Article  MATH  MathSciNet  Google Scholar 

  21. L.A. Zadeh. Outline of a new approach to the analysis of complex systems and decision processes. IEEE Transactions on Systems, Man, and Cybernetics, 3(1), 1973.

    Google Scholar 

  22. L.A. Zadeh. A computational approach to fuzzy quantifiers in natural languages. Comput. Math. Appl., 9:149–184, 1983.

    Article  MATH  MathSciNet  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Hong Kong Polytechnic University, Hong Kong

    Ling Feng & Tharam Dillon

Authors
  1. Ling Feng
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Tharam Dillon
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Department of Computer Science, University of Liverpool, P.O. Box 147, Liverpool, L49 3BX, UK

    Trevor J.M. Bench-Capon

  2. Department of Systems and Computers, University of Florence, Via S. Marta, 3, I-50139, Florence, Italy

    Giovanni Soda

  3. IFS, Technical University of Vienna, Resselgasse 3, A-1040, Vienna, Austria

    A Min Tjoa

Rights and permissions

Reprints and permissions

Copyright information

© 1999 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Feng, L., Dillon, T. (1999). Enhancing Data Warehousing with Fuzzy Technology. In: Bench-Capon, T.J., Soda, G., Tjoa, A.M. (eds) Database and Expert Systems Applications. DEXA 1999. Lecture Notes in Computer Science, vol 1677. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-48309-8_82

Download citation

  • DOI: https://doi.org/10.1007/3-540-48309-8_82

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-66448-2

  • Online ISBN: 978-3-540-48309-0

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation