SearchDatabase.com just posted an editorial on databases and object abstractions, stating quite emphatically that object design should not be mapped to database design (I agree). The author also lists three rules (all of which I agree with); keep your business rules in the database, use the proprietary features of your particular DBMS, and control your own SQL. This is not a ColdFusion article (actually, it is intended to be a Java Data Objects article, ColdFusion is mentioned in passing as one of several presentation layer options), but it is worth the read. See http://searchdatabase.techtarget.com/originalContent/0,289142,sid13_gci942025,00.html.
Leave a Reply