MySQL Forums
Forum List  »  Performance

Re: Pre-DML trigger vs Foreign keys
Posted by: Peter Brawley
Date: July 01, 2012 11:13PM

Anushka,

A MySQL database is a particular kind of data store, a relational database; as such, business rules are integral to it . There's a huge, coherent and very helpful body of database theory & practice for implementing biz rules in the database layer.

Whether you implement biz rules (or which ones you implement) in the app or DB layer depends mostly on the architecture of you app and on whether the RDBMS you are using is a full & robust enough implementation of SQL to do the job well.

PB

Options: ReplyQuote


Subject
Views
Written By
Posted
1053
June 23, 2012 01:56PM
1117
June 23, 2012 05:18PM
Re: Pre-DML trigger vs Foreign keys
1059
July 01, 2012 11:13PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.