业务逻辑:数据库或应用层 [英] Business Logic: Database or Application Layer

问题描述

古老的问题.您应该将业务逻辑作为存储过程(或包)放置在数据库中还是应用程序/中间层中?更重要的是，为什么?

The age old question. Where should you put your business logic, in the database as stored procedures ( or packages ), or in the application/middle tier? And more importantly, Why?

假设数据库独立性不是目标.

Assume database independence is not a goal.

推荐答案

在数据库中放入足够的业务逻辑，保证数据的一致性和正确性.

Put enough of the business logic in the database to ensure that the data is consistent and correct.

但不要害怕必须在另一个级别复制某些逻辑以增强用户体验.

But don't fear having to duplicate some of this logic at another level to enhance the user experience.

这篇关于业务逻辑:数据库或应用层的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！