Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!wn14feed!worldnet.att.net!204.127.198.203!attbi_feed3!attbi.com!attbi_s52.POSTED!not-for-mail From: "Marshall Spight" Newsgroups: comp.databases.theory References: <1efdad5b.0309260259.393522ae@posting.google.com> <6db906b2.0310091242.1a34e83@posting.google.com> <6db906b2.0310102134.6801804c@posting.google.com> <51d64140.0310140216.4cc2f1be@posting.google.com> <1b0b566c.0310141502.3e966ae6@posting.google.com> <25qtovc9dqvnhdfr7mpmorm7uk3277t25a@4ax.com> <1b0b566c.0310161512.7cd36678@posting.google.com> Subject: Re: foundations of relational theory? Lines: 23 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Message-ID: NNTP-Posting-Host: 12.236.48.146 X-Complaints-To: abuse@comcast.net X-Trace: attbi_s52 1066900213 12.236.48.146 (Thu, 23 Oct 2003 09:10:13 GMT) NNTP-Posting-Date: Thu, 23 Oct 2003 09:10:13 GMT Organization: Comcast Online Date: Thu, 23 Oct 2003 09:10:13 GMT Xref: newssvr20.news.prodigy.com comp.databases.theory:21939 "Mike Preece" wrote in message news:1b0b566c.0310161512.7cd36678@posting.google.com... > OK. Now turn it around and insert a layer. Call a business rules > module that in turn accesses the database (which can also have > business rules in the form of triggers and bridge correlatives etc). > If I want the cost and price for 20 widgets with sub-assemblies I > simply call a business rule module telling it what I want. No need to > directly access the database. This will work if: 1) It works with all necessary application languages 2) There's no way for applications to sneak past it 3) You can still do any necessary ad-hoc queries The cost is that an application programmer now needs to learn your API, as well as the schema. Marshall