RE: DBIx::Recordset and Oracle

At 11:05 AM -0700 7/26/05, Drozdowski, Catharine wrote: 
Hi Folks,
First of all, I want to second the database independence comment. As an
Oracle DBA who has watched application vendors try to create
applications which "run on all databases" I have seen anything from an
ISAM format kludged into a relational model which ran slower than a dead
dog no matter what hardware the mgnt threw at it.... To modern
applications, no names here, who literally waste the oracle database
because they do not use any of its features and dump all the stuff which
would fly on a database server down the the client / application tier
where is also like a very bloated dead dog.... My 2cents....

What you describe isn't intrinsic to database independence in principle. Rather, it describes certain implementations that chose to work to the least common denominator for native database feature use, and re-implemented the rest themselves. By contrast, 'Rosetta' will exploit Oracle's and other powerful database's native capabilities to the fullest, so all the work is still done by them that should be. I very much believe in not wasting resources.

While not meaning this next comment in a personal manner, in my very
humble opinion, we need to be aware of dumbing down the DBI and
providing new perl users with little incentive to be come experts at the
ins and outs of their database of choice...knowing the sql words does
not a database expert make...On the other hand in our modern
say,learn,know in a day world, perhaps being an expert is an outdated
concept....

I agree. A user should know about at least the main distinctions between different database products. Regardless of any portability of their code, they still have to make a decision for which one to use, so they have to know which will serve their needs best to make that decision.

-- Darren Duncan
.

Relevant Pages

  • Re: polymorphism (was: Poly Couples)
    ... but this is not really "business software"... ... Most of such applications are built as a combination of ... database with flat files or a different RDBMS vendor?" ... couldn't care less if I do it in using structured programming or OOP ...
    (comp.object)
  • Re: Unisys OS/2200 DMS / TIP / COBOL Migration
    ... support the legacy system api's that the application is using. ... differences in COBOL compiler dialects. ... What DBI does is to provide legacy database (DMS) ... the legacy database to the COBOL applications. ...
    (comp.sys.unisys)
  • Re: Database set up help
    ... let's see...I choose the y/n data type because I am using ... User opens up form and enters Employee Information in the fields ... 2 of the 38 options in my main menu are BPCS Applications ... I set up a database with this so far: ...
    (microsoft.public.access.gettingstarted)
  • Re: Advice needed for a growing Access 2000 project
    ... However, it turned out that quite a few of those were "leftovers" from previous releases, no longer accessible from anywhere but the database window, and, thus, no longer used. ... But that certainly isn't the _norm_ -- without any 'heroic' measures, there are routine reports of split Access DBs ... Finally, in my opinion, for "Windows apps", that is, individual-user applications, modest-sized multiuser applications, and client-server applications of any size, Dot Net does NOT "help along" any of these issues. ... The post I reference was in reference its self to the MS Access Help file under "Microsoft Access database general specifications" ...
    (comp.databases.ms-access)
  • Re: POD speed
    ... But I do think that there are costs to making a design decision ... > an OO data persistence layer that happens to use a relational database ... Would you see it as reasonable that two applications accessing the same database tables ... > what a business software system will be like years from now. ...
    (comp.lang.java.databases)