业务逻辑:数据库或应用层
古老的问题.您应该将业务逻辑作为存储过程(或包)放置在数据库中还是应用程序/中间层中?更重要的是，为什么?
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.
相关文章