Skip to main content

Integrating RDMS and Data Mining Capabilities Using Rough Sets

  • Chapter
Knowledge Management in Fuzzy Databases

Abstract

Mining information from large databases has been recognized as a key research topic in database systems. The explosive growth of databases has made neccesary to discover techniques and tools to transform the huge amount of stored data, into useful information. Rough Set Theory [17] has been applied since its very beginning to different application areas. This chapter presents an integration of Relational DataBase Management technology with Rough Sets Theory to show how the algorithms can be successfully translated into SQL and used as a powerful tool for knowledge discovery.

As a consecuence, a system has been designed and implemented in our research, called RSDM (Rough Set Data Miner), its architecture as well as its main properties will be further described in this chapter.

This work is supported by the Spanish Ministry of Education under project PB950301

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

Access this chapter

Subscribe and save

Springer+ Basic
$34.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or eBook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

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.

Similar content being viewed by others

References

  1. R. Agrawal, Mining Association Rules Between Sets of Items in Large Databases, In Prooceedings of ACM SIGMOD International Conference on Management of data, Washington DC, pp. 207–216, 1993.

    Google Scholar 

  2. R. Agrawal et al., The Quest Data Mining System, In Proceedings The Second International Conference on Knowledge discovery and Data Mining, pp. 244–249, August 1996.

    Google Scholar 

  3. R. Agrawal, T. Imielinski, A. Swami, Mining Association Rules Between Sets of Item in Large Databases, In Proceedings of ACM SIGMOD, pp. 207–216, May 1993.

    Google Scholar 

  4. R. Agrawal, K. Shim, Developing Tightly-Coupled Data Mining Applications on a Relational Database System, In Prooceedings of KDD’96, Orlando, pp. 287–291, July 1996.

    Google Scholar 

  5. E.F. Codd, A Relational Model of Data for Large Shared Data Banks, Comm. ACM 13 (6), pp. 377–387, 1970.

    Article  Google Scholar 

  6. M. Fernandez Baizan et al., Integrating RDMS and Data Mining Capabilities Using Rough Sets, In Proceedings, IPMU’96, Granada ( Spain ), July 1996.

    Google Scholar 

  7. M. Fernandez Baizan et al., Rough Sets as a Foundation to Add Data Mining Capabilities to a RDMS, In Proceedings, CESA’96, Lille (France), pp. 764–779, July 1996.

    Google Scholar 

  8. C. Fernandez-Baizan, E. Menasalvas, J. Pena A new approach for the efficient calculation of reducts in large databases In Proccedings os JICS’97, North Carolina, vol.3 pp 350–354

    Google Scholar 

  9. D. Fudger, H. Hamilton A Heuristic for evaluating Databases for Knowledge Discovery with DBLEARN Rough Sets, Fuzzy Sets and knowledge Discovery. W. Ziarko ed. pp. 45–51

    Google Scholar 

  10. J. Grzymala-Busse, LERS - a system for learning from examples based on Rough Sets,In Intelligence Decision Support. Handbook of Applications and Advances of the Rough Sets Theory, 3. Kluwer Academic Publishers.

    Google Scholar 

  11. M. Hadjimichael, Discovering Fuzzy Relationships from Databases, In Proceedings, CESA’96, Lille, pp. 936–941, July 1996.

    Google Scholar 

  12. J. Han et al., DBMiner: A System for Mining Knowledge in Large Relational Databases, In Proceedings The Second International Conference on Knowledge discovery and Data Mining, pp. 250–255, August 1996.

    Google Scholar 

  13. T. Imielinski et al., DataMine: Application Programming Interface and Query Language for Database Mining, In Proceedings The Second International Conference on Knowledge Discovery and Data Mining, pp. 256–261, August 1996.

    Google Scholar 

  14. J.D. Katzberg, W. Ziarko, Variable Precision Rough Sets with Asymetric Bounds, Rough Sets, Fuzzy Sets and Knowledge Discovery, pp. 167–178, 1994.

    Google Scholar 

  15. T.Y. Lin, Rayne Chen. Finding Reduct in very large databases, Proccedings os JICS’97, North Carolina, vol. 3 pp 350–354

    Google Scholar 

  16. T.Y. Lin, Rough Set Theory in Very Large Databases,In Proceedings, CESA’96, Lille, July-96, pp. 936–941.

    Google Scholar 

  17. Z. Pawlak, Rough Sets - Theoretical Aspects of Reasoning about Data, Kluwer, 1991.

    Google Scholar 

  18. Z. Pawlak, Information Systems-Theoretical Foundations, Information systems, 6, No. 4, pp. 299–297, 1993.

    Google Scholar 

  19. G. Piatesky-Shaphiro, An Overview of Knowledge Discovery in Databases: Recent Progress and Challenges, Rough Sets, Fuzzy Sets and Knowledge Discovery, pp. 1–11, 1994.

    Google Scholar 

  20. E. Simoudis, Integrating Inductive and Deductive Reasoning for Data Mining,Advances in Knowledge discovery and Data Mining, Usama Fayyad et al. editors. AAAI/MIT Press pp. 353–373.

    Google Scholar 

  21. A. Skowron, The Discernibility Matrices and Functions in Information Systems, Decision Support by Experience, R. Slowinski (ed.) Kluwer Academic Publishers, 1992.

    Google Scholar 

  22. A. Skowron, C. Rauszer, The Discernibility matrices and Functions in Information System, ICS PAS Report 1/91, Technical University of Warsaw, pp. 1–44, 1991

    Google Scholar 

  23. K. Slowinski, Rough Sets Approach to Analysis of Data from Peritoneal Lavage in Acute Pancratitis, Medical Informatics. 13, no. 3, PP. 143–159, 1988.

    Article  Google Scholar 

  24. S. Tsumoto, Incremental Learning of Probabilistic Rules from Clinical Databases Based on Rough Sets Theory, In Proceedings IPMU’96 vol. 3, pp. 1457–1462, Granada 1996.

    Google Scholar 

  25. A. Walkulicz-Deja et al., Applying Rough Sets to Diagnose in Children’s Neurology, In Proceedings IPMU’96 vol. 3, pp. 1463–1467, Granada 1996.

    Google Scholar 

  26. W. Ziarko, Variable Precision Rough Sets Model Journal of Computer and System Sciences, vol. 46. 1993, 39–59

    Article  Google Scholar 

  27. W. Ziarko, Discovering Classification Knowledge in Databases Using Rough Sets, In Prooceedings of the Second International Conference on Kwnoledge Discovery and Data Mining, pp. 271–274, 1996.

    Google Scholar 

  28. W. Ziarko, Data-Based Acquisition and Incremental Modification of Classification Rules, Computational Intelligence, pp. 357–370, 1995.

    Google Scholar 

  29. W. Ziarko, R. Golan, D. Edwards, An Application of Datalogic/R Knowledge Discovery Tool to Identify Strong Predictive Rules in Stock Market Data, Proceedings of AAAI Workshop on Knowledge Discovery in Databases, pp 89–100, 1993.

    Google Scholar 

  30. W. Ziarko, N. Shan, KDD-R: A Comprehensive System for Knowledge Discovery in Databases Using Rough Sets, In Proceedings of the International Workshop on Rough Sets and Soft Computing RSSC’94, pp. 164–173.

    Google Scholar 

  31. W. Ziarko, N. Shan, On Discovery of Attribute Interactions and Domain Classificactions, CSC’95 23 Annual Computer Science Conference on Rough Sets and Data Mining.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2000 Springer-Verlag Berlin Heidelberg

About this chapter

Cite this chapter

Fernandez-Baizán, M.C., Menasalvas Ruiz, E., Peña Sánchez, J.M. (2000). Integrating RDMS and Data Mining Capabilities Using Rough Sets. In: Pons, O., Vila, M.A., Kacprzyk, J. (eds) Knowledge Management in Fuzzy Databases. Studies in Fuzziness and Soft Computing, vol 39. Physica, Heidelberg. https://doi.org/10.1007/978-3-7908-1865-9_22

Download citation

  • DOI: https://doi.org/10.1007/978-3-7908-1865-9_22

  • Publisher Name: Physica, Heidelberg

  • Print ISBN: 978-3-7908-2467-4

  • Online ISBN: 978-3-7908-1865-9

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics