Re: Portable stored procedures
From: Robert Klemme (bob.news_at_gmx.net)
Date: 02/09/04
- Next message: John Casey: "XApool +multiple replicated nodes"
- Previous message: qazmlp: "HAT reports leaks due to JDBC calls"
- In reply to: Dennis: "Re: Portable stored procedures"
- Next in thread: Dennis: "Re: Portable stored procedures"
- Reply: Dennis: "Re: Portable stored procedures"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Mon, 9 Feb 2004 10:28:00 +0100
"Dennis" <df@tdc-broadband.dk> schrieb im Newsbeitrag
news:4025f667$0$1624$edfadb0f@dread14.news.tele.dk...
> JDatastore also uses java as the language for its stored procedures.
>
> http://info.borland.com/techpubs/jdatastore/
>
> from the above link, you can download the documentation for the
database.
>
> JDBC compliance is good, and the database itself is written in java.
>
> It also have a nice features that lets you write binary streams to it,
so in
> addition to the database, you get yourself a virtual file system.
Well, that's not really a surprising feature: nearly all db's you can get
today support BLOB's.
> The main thing it has going against itself is that it is not a
generational
> database like Interbase and i think oracle.
>
> Borland is about to release a new version, it is possible to download a
> trial to check it out.
>
> By the way - using java as the language for stored procedures is of
course
> extremely smart. They probably perform way better than other languages,
and
> you only have to develop the code once.
I haven't used Java stored procedures with databases but your statement is
only true, if all databases involved had the same API's and conventions
regarding stored procedure parameters, return values and exceptions.
Apart from that, Java stored procedures are not necessarily faster than
stored procedures written in some proprietary language.
I personally would not believe promises that claim portable stored
procedures. From my experience stored procedures is one of the fields
where databases differ most.
> Performance is comparable to other (even non-java) databases. Java keeps
on
> getting faster and faster.
That may be true as the main performance factor of a database is the
smartness of the algorithms and disk speed. Nevertheless I would not
expect a db implemented using Java to be as performant as any other native
compiled db. There are some obstacles to that (object creation
overerhead, memory size limits for JVM's on certain platforms etc.).
Kind regards
robert
>
> Dennis
>
>
> "Kenneth P. Turvey" <kt@squeakydolphin.com> wrote in message
> news:slrnc2bjpl.45h.kt@premium.geo.yahoo.akadns.net...
> > I was reading some Oracle documentation the other day on Java stored
> > procedures and found that I could write stored procedures that would
> > be database and platform independent. Is this really true? Does it
> > work out in practice?
> >
> > I would like to use a Java based database on my Linux box to test some
> > of this out at home with the hope of using it at work at a later
> > date if it is a "good idea". I've just installed hypersonicDB on my
> > laptop and I'm suitably impressed. Is this a reasonable platform on
> > which to try this out? Are there any better 100% Java databases with
> > which to work? I'm not looking for production systems, just a
> > test bed.
> >
> > TIA,
> >
> > --
> > Kenneth P. Turvey <kt@squeakydolphin.com>
> >
> > Artificial Intelligence Algorithms Wiki
> > http://ai.squeakydolphin.com
>
>
- Next message: John Casey: "XApool +multiple replicated nodes"
- Previous message: qazmlp: "HAT reports leaks due to JDBC calls"
- In reply to: Dennis: "Re: Portable stored procedures"
- Next in thread: Dennis: "Re: Portable stored procedures"
- Reply: Dennis: "Re: Portable stored procedures"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
