Skip to main content

Mining Fuzzy Association Rules in a Database Containing Relational and Transactional Data

  • Chapter
Data Mining and Computational Intelligence

Part of the book series: Studies in Fuzziness and Soft Computing ((STUDFUZZ,volume 68))

Abstract

Many effective algorithms have been developed to mine association rules in relational and transactional data separately. In this paper, we present a technique for the mining of such rules in databases containing both types of data. This technique, which we call Fuzzy Miner, performs its tasks by the use of fuzzy logic, a set of transformation functions, and by residual analysis. With the transformation functions, new attributes and new item types can be derived for either relational or transactional data. They also make it possible for association rules relating the two types of data to be discovered, e.g., the buying patterns related to the demographics of a group of customers. With fuzzy logic, Fuzzy Miner is not only able to discover Boolean and quantitative but also fuzzy association rules. This makes the patterns discovered more easily understandable by human users and more resilient to noise and missing data values. With residual analysis, Fuzzy Minder does not require any user-supplied thresholds that are often hard to determine. The Fuzzy Miner also discovers relationship between fuzzy and quantitative values and allows quantitative values to be inferred by the rules. With these features, Fuzzy Miner can be applied to real-life databases containing relational and transactional data.

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 129.00
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 169.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD 169.99
Price excludes VAT (USA)
  • Durable hardcover 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. R. Agrawal, T. Imielinski, and A. Swami, “Mining Association Rules between Sets of Items in Large Databases,” in Proc. of the ACM SIGMOD Int’l Conf on Management of Data, Washington D. C., May 1993, pp. 207–216.

    Google Scholar 

  2. W.-H. Au and K.C.C. Chan, “An Effective Algorithm for Discovering Fuzzy Rules in Relational Databases,” in Proc. of the 1998 IEEE Int’l Conf. on Fuzzy Systems, Anchorage, Alaska, May 1998, pp. 1314–1319.

    Google Scholar 

  3. W.-H. Au, and K.C.C. Chan, “FARM: A Data Mining System for Discovering Fuzzy Association Rules,” in Proc. of the 1999 IEEE Intl Conf. on Fuzzy Systems, Seoul, Korea, Aug. 1999.

    Google Scholar 

  4. K.C.C. Chan, and W.-H. Au, “Mining Fuzzy Association Rules,” in Proc. of the 6th ACM Int’l Conf. on Information and Knowledge Management, Las Vegas, Nevada, Nov. 1997, pp. 209–215.

    Google Scholar 

  5. K.C.C. Chan, and A.K.C. Wong, “APACS: A System for the Automatic Analysis and Classification of Conceptual Patterns,” Computational Intelligence, vol. 6, pp. 119–131, 1990.

    Article  Google Scholar 

  6. M.-S. Chen, J. Han, and P.S. Yu, “Data Mining: An Overview from A Database Perspective,” IEEE Trans. on Knowledge and Data Engineering, vol. 8, no. 6, pp. 866–883, Dec. 1996.

    Article  Google Scholar 

  7. V. Dhar and A. Tuzhilin, “Abstract-Driven Pattern Discovery in Databases,” IEEE Trans. Knowledge and Data Engineering, vol. 5, no. 6, pp. 926–938, 1993.

    Article  Google Scholar 

  8. U.M. Fayyad, G. Piatetsky-Shapiro, P. Smyth, and R. Uthurusamy (Eds.), Advances in Knowledge Discovery and Data Mining, AAAIIMIT Press, 1996.

    Google Scholar 

  9. J. Han and Y. Fu, “Discovery of Multiple-Level Association Rules from Large Databases,” in Proc. of the 21st VLDB Conf, Zurich, Switzerland, 1995, pp. 420–431.

    Google Scholar 

  10. D.H. Lee and M.H. Kim, “Database Summarization Using Fuzzy ISA Hierarchies,” IEEE Trans. on Systems, Man, and Cybernetics — Part B: Cybernetics, vol. 27, no. 4, pp. 671–680, Aug. 1997.

    Article  Google Scholar 

  11. W. Pedrycz, “Data Mining and Fuzzy Modeling,” in Proc. of 1996 Biennial Conf of the North American Fuzzy Information Processing Society, Berkeley, California, June 1996, pp. 263–267.

    Chapter  Google Scholar 

  12. G. Piatetsky-Shapiro and W.J. Frawley (Eds.), Knowledge Discovery in Databases, AAAI/MIT Press, 1991.

    Google Scholar 

  13. R. Srikant and R. Agrawal, “Mining Generalized Association Rules,” in Proc. of the 21st VLDB Conf., Zurich, Switzerland, 1995, pp. 407–419.

    Google Scholar 

  14. R. Srikant and R. Agrawal, “Mining Quantitative Association Rules in Large Relational Tables,” in Proc. of the ACM SIGMOD Int’l Conf. on Management of Data, Monreal, Canada, June 1996, pp. 1–12.

    Google Scholar 

  15. R.R. Yager, “On Linguistic Summaries of Data,” in [12], pp. 347–363.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2001 Springer-Verlag Berlin Heidelberg

About this chapter

Cite this chapter

Chan, K.C.C., Au, WH. (2001). Mining Fuzzy Association Rules in a Database Containing Relational and Transactional Data. In: Kandel, A., Last, M., Bunke, H. (eds) Data Mining and Computational Intelligence. Studies in Fuzziness and Soft Computing, vol 68. Physica, Heidelberg. https://doi.org/10.1007/978-3-7908-1825-3_4

Download citation

  • DOI: https://doi.org/10.1007/978-3-7908-1825-3_4

  • Publisher Name: Physica, Heidelberg

  • Print ISBN: 978-3-7908-2484-1

  • Online ISBN: 978-3-7908-1825-3

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics