Re: Transaction Oriented Architecture (TOA)

topmind wrote:
<snip>

I am still not understanding your scenario and why or why not it would
require an app change. Since I don't use classes, if a DB change does
not affect a field that an app or module uses, I don't have anything to
change. Perhaps Classes are your problem, not databases. blOOt at work.
If your classes have to mirror the DB out of OOP purity or obsession
with compile-time checking, then you have committed yourself to a
wasteful dance. My app usually does not change if it does not actually
*use* a given field.

Your DB has an account table with (accountNumber, balanceAmount, and other fields) and a transaction table showing every change to accountNumber and balanceAmount. To speed queries using account balances from any day since its opening you create a dailyAccountBalance table with (endingDate, accountNumber, balanceAmount). Realizing balanceAmount is needlessly redundant between the account and dailyAccountBalance tables you decide to remove account.balanceAmount and replace it with a join to the dailyAccountBalance table where endingDate = TODAY.

Every select from your account table is now broken.

Now, some people may think the change unwarranted or not worth the cost of updating the applications's SQL. Of course, if everything were behind a stored procedure it wouldn't be a problem cause an procedure's implementation can change without changing its interface (calling parameters or result columns)

Others may think a view is just as handy--which is almost true. Except that if I want to record what everyone does in a transaction history table I need to do other MACRO things a view doesn't allow for. Which is fine 'cause I can use stored procedures.

--
Visit <http://blogs.instreamfinancial.com/anything.php> to read my rants on technology and the finance industry.
.

Relevant Pages

  • Re: Application Flow / security issues
    ... You won't need a special service account. ... If the use case of the app is basically to have a user log in and then loop ... I just checked with corp. and if I want to do delegation I have to ask ... - You are using integrated windows auth in your web app ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: How good is Comodo Internet Security?
    ... Admin account + web browser + LUA token ... admin account opposed of running as iam now, which is JUST PURE admin level? ... While LUA gives added security, ... payload delivered by a buffer overrun (assuming the app was allowed to ...
    (comp.security.firewalls)
  • RE: POP3 Connector
    ... SBS server that you created during setup. ... Directory Users/Computer app, it will list the domain as one of the ... listed under the "email address" tab in the user container. ... > administrator account. ...
    (microsoft.public.windows.server.sbs)
  • Re: User Account Running at Application_end
    ... My app is running under 1.1. ... They will not give either account full permissions for 'security' reasons. ... Am I the only one who desires to compact a database periodically?? ... This routine works fine on another shared host. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Service Principal Name in Kerberos
    ... specific account with enabled 'Account is trusted for delegation', ... opens IE and accesses the Client App on IIS that then accesses the Server ... Windows Server 2003 or Windows Vista ... Microsoft Online Community Support ...
    (microsoft.public.platformsdk.security)