{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,10,12]],"date-time":"2025-10-12T03:25:18Z","timestamp":1760239518991,"version":"build-2065373602"},"reference-count":23,"publisher":"MDPI AG","issue":"12","license":[{"start":{"date-parts":[[2020,11,27]],"date-time":"2020-11-27T00:00:00Z","timestamp":1606435200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Future Internet"],"abstract":"<jats:p>One of the developmental directions of Future Internet technologies is the implementation of artificial intelligence systems for manipulating data and the surrounding world in a more complex way. Rule-based systems, very accessible for people\u2019s decision-making, play an important role in the family of computational intelligence methods. The use of decision-making rules along with decision trees are one of the simplest forms of presenting complex decision-making processes. Decision support systems, according to the cross-industry standard process for data mining (CRISP-DM) framework, require final embedding of the learned model in a given computer infrastructure, integrated circuits, etc. In this work, we deal with the topic concerning placing the learned rule-based model of decision support in the database environment-exactly in the SQL database tables. Our main goal is to place the previously trained model in the database and apply it by means of single queries. In our work we assume that the decision-making rules applied are mutually consistent and additionally the Minimal Description Length (MDL) rule is introduced. We propose a universal solution for any IF THEN rule induction algorithm.<\/jats:p>","DOI":"10.3390\/fi12120212","type":"journal-article","created":{"date-parts":[[2020,11,26]],"date-time":"2020-11-26T22:00:33Z","timestamp":1606428033000},"page":"212","update-policy":"https:\/\/doi.org\/10.3390\/mdpi_crossmark_policy","source":"Crossref","is-referenced-by-count":3,"title":["About Rule-Based Systems: Single Database Queries for Decision Making"],"prefix":"10.3390","volume":"12","author":[{"ORCID":"https:\/\/orcid.org\/0000-0001-5508-9856","authenticated-orcid":false,"given":"Piotr","family":"Artiemjew","sequence":"first","affiliation":[{"name":"Faculty of Mathematics and Computer Science, University of Warmia and Mazury in Olsztyn, 10-710 Olsztyn, Poland"}]},{"given":"Lada","family":"Rudikova","sequence":"additional","affiliation":[{"name":"Faculty of Mathematics and Computer Science, Grodno State Yanka Kupala University, Street. Ozheshko 22, 230023 Grodno, Belarus"}]},{"given":"Oleg","family":"Myslivets","sequence":"additional","affiliation":[{"name":"Faculty of Mathematics and Computer Science, Grodno State Yanka Kupala University, Street. Ozheshko 22, 230023 Grodno, Belarus"}]}],"member":"1968","published-online":{"date-parts":[[2020,11,27]]},"reference":[{"key":"ref_1","first-page":"13","article-title":"The CRISP-DM model: The new blueprint for data mining","volume":"5","author":"Shearer","year":"2000","journal-title":"J. Data Warehous."},{"key":"ref_2","doi-asserted-by":"crossref","first-page":"445","DOI":"10.1016\/0005-1098(78)90005-5","article-title":"Modeling by shortest data description","volume":"14","author":"Rissanen","year":"1978","journal-title":"Automatica"},{"unstructured":"(2020, August 02). UCI (University of California at Irvine) Repository. Available online: http:\/\/archive.ics.uci.edu.\/ml\/.","key":"ref_3"},{"key":"ref_4","doi-asserted-by":"crossref","first-page":"341","DOI":"10.1007\/BF01001956","article-title":"Rough sets","volume":"11","author":"Pawlak","year":"1982","journal-title":"Int. J. Comput. Inf. Sci."},{"unstructured":"(2014, April 01). RSES. Available online: http:\/\/mimuw.edu.pl\/logic\/~rses\/.","key":"ref_5"},{"key":"ref_6","first-page":"295","article-title":"Boolean reasoning for decision rules generation","volume":"Volume 689","author":"Skowron","year":"1993","journal-title":"Proceedings of the ISMIS\u201993. Lecture Notes in Artificial Intelligence"},{"doi-asserted-by":"crossref","unstructured":"S\u0142owi\u0144ski, R. (1992). LERS\u2013A system for learning from examples based on rough sets. Intelligent Decision Support: Handbook of Advances and Applications of the Rough Sets Theory, Kluwer Academic Publishers.","key":"ref_7","DOI":"10.1007\/978-94-015-7975-9"},{"unstructured":"Skarek, P., and L\u00e1szl\u00f3, Z.V. (1996, January 21\u201322). Rule-Based Knowledge Representation Using a Database. Proceedings of the Conference on Artificial Intelligence Applications, Paris, France.","key":"ref_8"},{"key":"ref_9","doi-asserted-by":"crossref","first-page":"313","DOI":"10.1016\/S0169-023X(98)00048-2","article-title":"Time-evolving rule-based knowledge bases","volume":"29","author":"Lorentzos","year":"1999","journal-title":"Data Knowl. Eng."},{"doi-asserted-by":"crossref","unstructured":"Abdullah, U., Sawar, M.J., and Ahmed, A. (2009, January 12\u201314). Design of a Rule Based System Using Structured Query Language. Proceedings of the 2009 Eighth IEEE International Conference on Dependable, Autonomic and Secure Computing, Chengdu, China.","key":"ref_10","DOI":"10.1109\/DASC.2009.78"},{"unstructured":"Spits Warnars, H.L.H. (2010). Classification Rule with Simple Select SQL Statement, University of Budi Luhur.","key":"ref_11"},{"doi-asserted-by":"crossref","unstructured":"Liu, C., Sakai, H., Zhu, X., and Nakata, M. (2016, January 25\u201328). On Apriori-Based Rule Generation in SQL\u2014A Case of the Deterministic Information System. Proceedings of the 2016 Joint 8th International Conference on Soft Computing and Intelligent Systems (SCIS) and 17th International Symposium on Advanced Intelligent Systems (ISIS), Sapporo, Japan.","key":"ref_12","DOI":"10.1109\/SCIS-ISIS.2016.0047"},{"doi-asserted-by":"crossref","unstructured":"Miftakul Amin, M., Andino, M., Shankar, K., Eswaran Perumal, R., Vidhyavathi, M., and Lakshmanaprabu, S.K. (2018). Active Database System Approach and Rule Based in the Development of Academic Information System. Int. J. Eng. Technol., 95\u2013101.","key":"ref_13","DOI":"10.14419\/ijet.v7i2.26.14361"},{"doi-asserted-by":"crossref","unstructured":"Salzberg, S.L. (1993). C4.5: Programs for Machine Learning by J. Ross Quinlan, Morgan Kaufmann Publishers. Mach Learn 16, 235\u2013240 (1994).","key":"ref_14","DOI":"10.1007\/BF00993309"},{"unstructured":"Artiemjew, P. (2009). On Strategies of Knowledge Granulation with Applications to Decision Systems. [Ph.D. Thesis, Polish\u2013Japanese Institute of Information Technology].","key":"ref_15"},{"unstructured":"Mitchell, T. (1997). Machine Learning, McGraw-Hill.","key":"ref_16"},{"key":"ref_17","first-page":"185","article-title":"On the two local inductive algorithms: PRISM and LEM2","volume":"19","author":"Chan","year":"1994","journal-title":"Found. Comput. Decis. Sci."},{"unstructured":"Grzymala-Busse, J.W., and Lakshmanan, A. (1996). LEM2 with interval extension: An induction algorithm for numerical attributes. Proceedings of the Fourth International Workshop on Rough Sets, Fuzzy Sets, and Machine Discovery (RSFD\u201996), The University of Tokyo.","key":"ref_18"},{"unstructured":"Michalski, R.S., Mozetic, I., Hong, J., and Lavrac, N. (1986). The multi\u2013purpose incremental learning system AQ15 and its testing to three medical domains. Proceedings of AAAI-86, Morgan Kaufmann.","key":"ref_19"},{"key":"ref_20","doi-asserted-by":"crossref","first-page":"261","DOI":"10.1007\/BF00116835","article-title":"The CN2 induction algorithm","volume":"3","author":"Clark","year":"1989","journal-title":"Mach. Learn."},{"key":"ref_21","doi-asserted-by":"crossref","first-page":"349","DOI":"10.1016\/S0020-7373(87)80003-2","article-title":"PRISM, an algorithm for inducing modular rules","volume":"27","author":"Cendrowska","year":"1987","journal-title":"Int. J. Man Mach. Stud."},{"key":"ref_22","doi-asserted-by":"crossref","first-page":"221","DOI":"10.1007\/978-3-540-79721-0_33","article-title":"On clasification of data by means of rough mereological granules of objects and rules","volume":"Volume 5009","author":"Artiemjew","year":"2008","journal-title":"Proceedings of the International Conference on Rough Set and Knowledge Technology RSKT\u201908"},{"doi-asserted-by":"crossref","unstructured":"Polkowski, L., and Artiemjew, P. (2015). Granular Computing in Decision Approximation, An Application of Rough Mereology. Series: Intelligent Systems Reference Library, Springer.","key":"ref_23","DOI":"10.1007\/978-3-319-12880-1"}],"container-title":["Future Internet"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.mdpi.com\/1999-5903\/12\/12\/212\/pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,10,11]],"date-time":"2025-10-11T10:38:03Z","timestamp":1760179083000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.mdpi.com\/1999-5903\/12\/12\/212"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2020,11,27]]},"references-count":23,"journal-issue":{"issue":"12","published-online":{"date-parts":[[2020,12]]}},"alternative-id":["fi12120212"],"URL":"https:\/\/doi.org\/10.3390\/fi12120212","relation":{},"ISSN":["1999-5903"],"issn-type":[{"type":"electronic","value":"1999-5903"}],"subject":[],"published":{"date-parts":[[2020,11,27]]}}}