Re: PL/SQL or SQL in the middle tier?



Andrew M wrote:
On Feb 20, 3:25 pm, The House Dawg <mhous...@xxxxxxxxxxxxx> wrote:

Oops, I left out the proposed refactoring - the software engineers
would translate the PL/SQL into SQL that would be embedded into
our .Net (C#) middle tier. The database layer would just be a set of
tables that the middle tier would manipulate with SQL.


If your company is staying with Oracle, then they will be paying a lot
of money for something that mySql could likely do, just storing data
in tables.

Assuming they've no need for security, compliance, auditing, and they
are not subject to any governmenatal or industry standards.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.



Relevant Pages

  • Re: PL/SQL or SQL in the middle tier?
    ... would translate the PL/SQL into SQL that would be embedded into ... The database layer would just be a set of ... tables that the middle tier would manipulate with SQL. ...
    (comp.databases.oracle.server)
  • Re: Limit of 1050 columns for ANSI joins
    ... comprehensive than Oracle SQL. ... I'm trying not to have any auto-generated SQL on my system, ... Index your schema properly and think about the proper design. ...
    (comp.databases.oracle.server)
  • Re: I cant find a SETUP.EXE in the SQL Plus Client ??
    ... someone else's server for testing some SELECT statements I'm ... free client because I don't own the Oracle license. ... SQL statements. ... There is no documentation with that download. ...
    (comp.databases.oracle.tools)
  • Re: How to convince my customer to use SQL2005 instaed of Oracle10g
    ... the old Sql versus Oracle debate. ... If I were you I would focus one SQL Server 2005 clearest advantages ... You mentioned Availability, so I assume your looking into HA (high ...
    (microsoft.public.sqlserver)
  • Re: How to convince my customer to use SQL2005 instaed of Oracle10g
    ... migration to Sql 2005 would be direct & straight forward, quick, and ... If I were you I would focus one SQL Server 2005 clearest advantages ... would need a 4 processor license but for Oracle you would need a 16 ... You mentioned Availability, so I assume your looking into HA (high ...
    (microsoft.public.sqlserver)