On Sun, Oct 27, 2019 at 3:43 AM Colin Williams <colinwilliams007@xxxxxxxxx>
wrote:
One question I have is where do you want your business logic to live?
The term "business logic" may mean different things to different people. In
order to avoid ambiguity, I'd suggest that we infer that business logic
refers to database logic in the context of most IBM i applications. What
does database logic refer to? I'd suggest we infer that it refers to logic
that implements data validation, referential integrity constraints,
database I/O, and rules that rely on database I/O. Where should database
logic reside? I'd suggest that it reside in the same memory address space
in which the database management system resides. In the case of data
validation and referential integrity constraints, that logic should reside
in the DBMS as opposed to in "applications". In other words, people should
not be able to create applications to bypass that type of logic. In other
words, don't put database logic in Java, PHP, Node.js, or any other
language environment that runs in a separate address space. Keep your
database pure. Maintain its integrity. Protect it with logic. Control
access to it via logic. Let's not ever suggest that people move away from
native languages (RPG, C, etc.), especially in regard to the implementation
of database logic.
midrange.com
