Re: choices regarding where to place code - in the database or middle tier

From: Joe (joelax_at_dbdirections.com)
Date: 01/23/04


Date: Fri, 23 Jan 2004 17:29:27 GMT

Well Momma always told me to try to be as polite as possible to those
prickly Oracle people, hence I tried to use complimentary terms as possible.
Yes, I'm aware of PL/SQL, and I've posted another message to the group
explaining my issues in more detail. But for your own information, since you
seem to interested, fifteen years ago I was coding in Btrieve and life way
simpler then. <g>

Joe

"Noons" <wizofoz2k@yahoo.com.au> wrote in message
news:73e20c6c.0401202340.70ffcb6f@posting.google.com...
> "Joe" <joelax@dbdirections.com> wrote in message
news:<Y7IOb.20178$ko5.19870@nwrddc01.gnilink.net>...
>
> > Over the last several versions of Oracle, developers have been provided
with
> > a pretty revolutionary idea for a database product - namely the ability
to
> > write code that used to belong in the middle tier and store it in the
> > database. I'm referring here to the ability to write stored procedures
in
> > Java.
>
> You gotta be joking! A "revolutionary idea"? Where the heck have
> you been in the last 15 years??? It's only been possible in Oracle
> since about 1990 or thereabouts... Oh yes, Java is NOT the only way
> to code, in case you haven't noticed.
>
> For starters: there is NO such thing as "code that used to belong
> in the middle tier"! That is an invention of middle tier vendors
> that has NEVER been proven as valid in real application. Code NEVER
> belonged in the middle tier until the concept of multi tier was invented,
> about 6 or 7 years ago.
>
>
> > Now of course, Microsoft with their SQL Server product is doing the same
> > thing. The next version of SQL Server will allow programmers to write
> > stored procedures in any of the .NET languages.
>
> Amazing! Must be breakneck technology. Pity it's been done by just
> about any other serious database vendor for the last 10 years...
> But I'm quite sure now that M$ is jumping on the bandwagon, it will
> suddenly become a credible "industry standard" to store code in the
> database. Oh yeah, they've been able to do so with Transact-SQL
> for ages but what the hey...
>
>
> > I'm interested in looking at the increased choices developers now have
> > because of these new features in more depth ,developing some best
practices
> > on the subject, and possibly publishing an article on the topic.
>
> Do a search on comp.databases.oracle.server for "design" and "J2EE".
> Then read.
>
>
> > I personally am more experienced with SQL Server than with Oracle. I am
> > therefore looking for someone who has been involved with making these
> > choices in the Oracle environment who would like to collaborate with me
on
> > the subject.
>
> Like I said: search on c.d.o.s.
>
> Cheers
> Nuno Souto
> wizofoz2k@yahoo.com.au.nospam



Relevant Pages

  • Re: choices regarding where to place code - in the database or middle tier
    ... Before Oracle decided to allow you to write stored procedures in Java, ... Even without Java existing, let alone being hosted in the database, you ... of languages that they developed for the middle tier, ... the .NET developers out there will be faced with this choice. ...
    (comp.lang.java.databases)
  • Re: choices regarding where to place code - in the database or middle tier
    ... Before Oracle decided to allow you to write stored procedures in Java, ... Even without Java existing, let alone being hosted in the database, you ... of languages that they developed for the middle tier, ... the .NET developers out there will be faced with this choice. ...
    (comp.lang.java.programmer)
  • Re: choices regarding where to place code - in the database or middle tier
    ... prickly Oracle people, hence I tried to use complimentary terms as possible. ... >> write code that used to belong in the middle tier and store it in the ... The next version of SQL Server will allow programmers to write ... >> I'm interested in looking at the increased choices developers now have ...
    (comp.lang.java.programmer)
  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... were pretty consistent no matter how big the table (this transaction ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... Oracle provides read consistency and SQL Server ...
    (comp.databases.oracle.misc)
  • Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
    ... "Writers block readers and readers block writers in SQLServer. ... getting around this fundamental issue and because of it SQL Server ... admitted they can happen in Oracle, I guess Oracle should never been used ... isolation level but you will always disagree because you follow doctorine ...
    (comp.databases.oracle.server)