Database function-based rule implementation and application method and device

Abstract

The embodiment of the invention discloses a database function-based rule implementation and application method and a database function-based rule implementation and application device. The method comprises the following steps of: establishing a business rule model comprising one or more rule key elements according to rule application requirements; establishing a plurality of rules which conform to the business rule model; converting the rules into rule description language and saving in a rule base; implementing the rules in the rule base as corresponding database functions; configuring incidence relation of source data and the applied rule according to application requirements; and acquiring values of the key elements in the configured rule input by a user, executing the rule by calling the database function associated with the rule, and returning an execution result. By using the method or the device provided by the embodiment of the invention, the implementation of a complex algorithm is realized by means of a simple database function based on the implementation result of a rule engine implemented by the database function, the development difficulty of the rule engine is reduced, the cost is saved, and the rule processing efficiency is increased.

Description

technical field [0001] The invention relates to the technical field of database data processing, in particular to a method and device for implementing and applying rules based on database functions. Background technique [0002] The rule engine is a component embedded in the application program. It is developed from the reasoning engine. The rule engine accepts data input, reads business rules, and obtains business decisions that conform to the business rules through reasoning. Using a rules engine reduces the complexity of implementing complex business logic components and lowers the scalability cost of your application. There are several rule engines available for running applications, the most common of which include commercial rule engines and open source rule engines. Business rule engines typically allow rules to be expressed in a dedicated English-like language, and others allow rules to be written in a scripting language. [0003] The existing JAVA rule engine perf...

AI Technical Summary

Problems solved by technology

However, as an open source product, Drools focuses on the implementation of the rule engine and the extension of the rule language, and has not done very in-depth research on the rule configurator.

Currently, the configurator embedded in Eclipse provided by Drools is only a tool designed and developed for programmers; in addition, since Drools is based on the rete algorithm, it is necessary to learn the rete algorithm and the rule description language before understanding and configuring rules. The rete algorithm is more difficult to learn and understand for general programmers.

[0004] Existing commercial engines usually allow the use of a dedicated English-like language to express rules, but commercial engines require high personnel capabilities and are usually relatively expensive. For small and medium-scale software integration, especially for relatively simple rule logic Processing applications, introducing a complex and expensive rule engine is a bit overkill, and the gain outweighs the gain

[0005] It can be seen that although the existing rule engines have independent frameworks and grammars, they can be applied to complex calculation rules for various massive data, but the implementation is relatively complicated, resulting in high development and secondary development costs and difficulty in integration. At the same time, it also has high requirements on the development level of developers. For example, the existing JAVA rule engine needs to write Java code to realize it, and Drools, although it has its own grammar rules, has high requirements on the ability of developers. , you need to be familiar with all the grammar rules and understand its underlying structure, and then do secondary development and application on the basis of it; commercial engines are expensive

[0006] At the same time, due to the complex implementation of existing rule engines, relatively simple rule logic requirements will present cumbersome and complex shortcomings when processing data based on complex rule engines. When the above method processes external objects or internal data, it will affect the speed of the computer's responsiveness and reduce the processing performance of the computer to process data.

Images