mysql数据库业务逻辑,将业务逻辑存储在数据库中

We want to write some business logic rules that work on top of certain data to build reports. Not sure which is the best to store them in the database MySQL.

It can have a chain of the rules and then a statement for the result as shown above.

解决方案

For building reports you can convert business logic in any programming language. And use database data for generating reports.

Against of business logic stored in database

I place a high value on the power of expression, and I don't find the

SQL space to be all that expressive. Use the best tools you have on

hand for the most appropriate tasks. Fiddling with logic and higher

order concepts is best done at the highest level. Consequently,

storage and mass data manipulation is best done at the server level,

probably in stored procedures.

But it depends. If you have multiple applications interacting with one

storage mechanism and you want to make sure it maintains its integrity

and workflow, then you should offload all of the logic into the

database server. Or, be prepared to manage concurrent development in

multiple applications.

See also: