Rough set-based rule generation and Apriori-based rule generation from table data sets II: SQL-based environment for rule generation and decision support

• Main Authors: Hiroshi Sakai, Zhiwen Jian
• Format: Article
• Language: English
• Published: Wiley 2019-07-01
• Series: CAAI Transactions on Intelligence Technology
• Subjects: rough set theory; sql; data mining; decision support systems; apriori-based rule generation; sql-based environment; decision support; table data sets; rule generator; rough set-based rule generation
• Online Access: https://digital-library.theiet.org/content/journals/10.1049/trit.2019.0016

This study follows the previous study entitled ‘Rough set-based rule generation and Apriori-based rule generation from table data sets: A survey and a combination’, and this is the second study on ‘Rough set-based rule generation and Apriori-based rule generation from table data sets’. The theoretical aspects are described in the previous study, and here the aspects of application, an SQL-based environment for rule generation and decision support, are described. At first, the implementation of rule generator defined in the previous study is explained, then the application of the obtained rules to decision support is considered. Especially, the following two issues are focused on, (i) Rule generator from table data sets with uncertainty in SQL, (ii) The manipulation in decision support below: (ii-a) In the case that an obtained rule matches the condition, (ii-b) In the case that any obtained rule does not match the condition. The authors connect such cases with decision support and realised an effective decision support environment in SQL.