RE: Database programming standards
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 3 Jun 2004 17:53:22 -0400
Larger reason for having the business logic in the database server is that
folks use other tools to manipulate the data. SOmetimes for good reason &
other times not. Having the business logic in the database makes sure that no
matter how the data gets there the same rules apply.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Jared.Still@xxxxxxxxxxx [mailto:Jared.Still@xxxxxxxxxxx]
Sent: Thursday, June 03, 2004 5:45 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Database programming standards
> Many developers dislike storing business logic in the database for a number
> of reasons
> - Application servers can be scaled out more easily than can database
> servers. Throwing an extra machine or two in the application server cluster
> is a relatively simple operation. Throwing an extra machine into a database
> server cluster, particularly if you're not using RAC everywhere, is much
> more complicated. Realistically, very few applications need this sort of
> scale out, but there are a few.
Of course, if the business logic is in the database, there will be far less
need for more app servers.
Conversely, adding app servers is going to enventually require scaling on
the database end as well, as the database will be acting more like a
data gofer, and more app servers will require more singleton data accesses.
Jared
Other related posts:
