Stephen - if your Database is Talking to you - maybe its truly time for You to talk to a Shrink!!!
:-) All kidding aside. I know there is this whole argument about keep business rules away from the Database - even though, in many cases - people implement them within Stored Procedures. Which means the rules get tied to the data. But, I know this is a Very Intense argument that a lot of folks argue over. So - sorry if I am just adding to the flame war about Data vs. Program code... -K- -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Stephen Russell Sent: Wednesday, May 27, 2015 1:00 PM To: [email protected] Subject: Re: [NF] Interesting post about foreign keys in SQL On Wed, May 27, 2015 at 10:33 AM, < [email protected]> wrote: > I like taking full advantage of the database server and it's > enforcement to keep out bad data, but I also can appreciate the > perspective of having the RI logic in the data tier and just treating > the backend as "big dumb storage" so as to make your app much more > portable and not tied to any particular backend database. > > Like so many situations, I guess it all "depends" on your need. > > ----------- You make my db cry when you call it dumb storage. It says it is so much more with analytics involved that makes cubes for end user reporting real easy. Or dashboards for a variety of data needs across all aspects of our business. It also mentions the ability to cross reference data from other systems we have in house who all have different instances on the same DB server. My databse also said that living in a third normal form environment is faster than you think. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/80838f1ca795b14ea1af48659f35166f1b9...@drexch02.corp.globetax.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
