Skip to main content

QUARRY: A Graph Model for Queryable Association Rules

  • Conference paper
  • First Online:
AI 2022: Advances in Artificial Intelligence (AI 2022)

Part of the book series: Lecture Notes in Computer Science ((LNAI,volume 13728))

Included in the following conference series:

  • 1478 Accesses

Abstract

Association rule mining is a pivotal technique for knowledge discovery, but often involves time-intensive manual labour when performed on large datasets. In this paper we propose a solution for this problem: QUARRY, a graph model that enables consumable and queryable insights from association rules. In contrast to existing systems which take a list of rules and display them in a purpose-built visualisation, our graph-based model enables association rules to be queried directly via graph queries. Through a case study on maintenance data we show how this model enhances knowledge discovery by eliminating the need for domain experts to trawl through large lists of rules to find useful information. QUARRY, which is designed for compatibility with existing knowledge graphs, provides users with the means to easily search for rules pertaining to specific items as well as roll up and drill down on their searches using the concept hierarchy. Domain experts may also query for association rules based on transaction properties such as costs and dates, enabling critical insights into their 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 89.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 119.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

Notes

  1. 1.

    The dataset and source code of QUARRY is available on GitHub.

  2. 2.

    https://neo4j.com.

  3. 3.

    https://neo4j.com/docs/cypher-manual/current/.

References

  1. Agrawal, R., Imieliński, T., Swami, A.: Mining association rules between sets of items in large databases. In: Proceedings of the 1993 ACM SIGMOD International Conference on Management of Data, pp. 207–216 (1993)

    Google Scholar 

  2. Agrawal, R., Srikant, R., et al.: Fast algorithms for mining association rules. In: Proceedings 20th International Conference Very Large Data Bases, VLDB, vol. 1215, pp. 487–499. Citeseer (1994)

    Google Scholar 

  3. Angles, R.: The property graph database model. In: AMW (2018)

    Google Scholar 

  4. Brundage, M.P., Sexton, T., Hodkiewicz, M., Dima, A., Lukens, S.: Technical language processing: unlocking maintenance knowledge. Manuf. Lett. 27, 42–46 (2021)

    Article  Google Scholar 

  5. Fan, W., Fu, W., Jin, R., Lu, P., Tian, C.: Discovering association rules from big graphs. Proc. VLDB Endow. 15(7), 1479–1492 (2022)

    Article  Google Scholar 

  6. Fernandez-Basso, C., Ruiz, M.D., Delgado, M., Martin-Bautista, M.J.: A comparative analysis of tools for visualizing association rules: a proposal for visualising fuzzy association rules. In: 11th Conference of the European Society for Fuzzy Logic and Technology (EUSFLAT 2019), pp. 520–527. Atlantis Press (2019)

    Google Scholar 

  7. García, E., Romero, C., Ventura, S., De Castro, C.: A collaborative educational association rule mining tool. Internet High. Educ. 14(2), 77–88 (2011)

    Article  Google Scholar 

  8. Hahsler, M., Chelluboina, S.: Visualizing association rules: introduction to the r-extension package arulesviz. R Proj. Module 6, 223–238 (2011)

    Google Scholar 

  9. Hahsler, M., Karpienko, R.: Visualizing association rules in hierarchical groups. J. Bus. Econ. 87(3), 317–335 (2017)

    Google Scholar 

  10. Han, J., Pei, J., Tong, H.: Data Mining: Concepts and Techniques. Morgan kaufmann, Burlington (2022)

    Google Scholar 

  11. Han, J., Pei, J., Yin, Y.: Mining frequent patterns without candidate generation. ACM Sigmod Rec. 29(2), 1–12 (2000)

    Article  Google Scholar 

  12. Ho, M.: A shared reliability database for mobile mining equipment. Ph.D. thesis, University of Western Australia (2015)

    Google Scholar 

  13. Kertkeidkachorn, N., Ichise, R.: T2kg: an end-to-end system for creating knowledge graph from unstructured text. In: Workshops at the Thirty-First AAAI Conference on Artificial Intelligence (2017)

    Google Scholar 

  14. Kuok, C.M., Fu, A., Wong, M.H.: Mining fuzzy association rules in databases. ACM Sigmod Rec. 27(1), 41–46 (1998)

    Article  Google Scholar 

  15. Leal, D.: ISO 15926 “Life cycle data for process plant’’: an overview. Oil & Gas Sci. Technol. 60(4), 629–637 (2005)

    Article  Google Scholar 

  16. Leung, C.K.S., Irani, P.P., Carmichael, C.L.: Wifisviz: effective visualization of frequent itemsets. In: 2008 Eighth IEEE International Conference on Data Mining, pp. 875–880. IEEE (2008)

    Google Scholar 

  17. Leung, C.K.-S., Jiang, F.: RadialViz: an orientation-free frequent pattern visualizer. In: Tan, P.-N., Chawla, S., Ho, C.K., Bailey, J. (eds.) PAKDD 2012. LNCS (LNAI), vol. 7302, pp. 322–334. Springer, Heidelberg (2012). https://doi.org/10.1007/978-3-642-30220-6_27

    Chapter  Google Scholar 

  18. Nettleton, D.F.: Data mining of social networks represented as graphs. Comput. Sci. Rev. 7, 1–34 (2013)

    Article  MATH  Google Scholar 

  19. Stewart, M., Hodkiewicz, M., Liu, W., French, T.: Mwo2kg and echidna: constructing and exploring knowledge graphs from maintenance data. Proc. Inst. Mech. Engineers, Part O: J. Risk Reliabil. (2022)

    Google Scholar 

  20. Stewart, M., Liu, W.: Seq2kg: an end-to-end neural model for domain agnostic knowledge graph (not text graph) construction from text. In: Proceedings of the International Conference on Principles of Knowledge Representation and Reasoning, vol. 17, pp. 748–757 (2020)

    Google Scholar 

  21. Stewart, M., Liu, W., Cardell-Oliver, R., Griffin, M.: An interactive web-based toolset for knowledge discovery from short text log data. In: Cong, G., Peng, W.-C., Zhang, W.E., Li, C., Sun, A. (eds.) ADMA 2017. LNCS (LNAI), vol. 10604, pp. 853–858. Springer, Cham (2017). https://doi.org/10.1007/978-3-319-69179-4_61

    Chapter  Google Scholar 

  22. Techapichetvanich, K., Datta, A.: VisAR : a new technique for visualizing mined association rules. In: Li, X., Wang, S., Dong, Z.Y. (eds.) ADMA 2005. LNCS (LNAI), vol. 3584, pp. 88–95. Springer, Heidelberg (2005). https://doi.org/10.1007/11527503_12

    Chapter  Google Scholar 

  23. Tiwari, V., Tiwari, V., Gupta, S., Tiwari, R.: Association rule mining: a graph based approach for mining frequent itemsets. In: 2010 International Conference on Networking and Information Technology, pp. 309–313. IEEE (2010)

    Google Scholar 

  24. Wang, X., Xu, Y., Zhan, H.: Extending association rules with graph patterns. Expert Syst. Appl. 141, 112897 (2020)

    Article  Google Scholar 

  25. Yen, S.J., Chen, A.L.P.: A graph-based approach for discovering various types of association rules. IEEE Trans. Knowl. Data Eng. 13(5), 839–845 (2001)

    Article  Google Scholar 

Download references

Acknowledgments

This research is supported by the Australian Research Council through the Centre for Transforming Maintenance through Data Science (grant number IC180100030), funded by the Australian Government.

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Michael Stewart .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2022 The Author(s), under exclusive license to Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Stewart, M. (2022). QUARRY: A Graph Model for Queryable Association Rules. In: Aziz, H., Corrêa, D., French, T. (eds) AI 2022: Advances in Artificial Intelligence. AI 2022. Lecture Notes in Computer Science(), vol 13728. Springer, Cham. https://doi.org/10.1007/978-3-031-22695-3_22

Download citation

  • DOI: https://doi.org/10.1007/978-3-031-22695-3_22

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-031-22694-6

  • Online ISBN: 978-3-031-22695-3

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics