Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!mailrus!cs.utexas.edu!samsung!uunet!dev!dgis!jkrueger
From: jkrueger@dgis.dtic.dla.mil (Jon)
Newsgroups: comp.databases
Subject: Re: Client/Server processes and implementations
Keywords: Client Server Processes
Message-ID: <671@dgis.dtic.dla.mil>
Date: 23 Nov 89 05:19:24 GMT
References: <7114@sybase.sybase.com> <6895@sybase.sybase.com> <2184@kodak.UUCP> <375@xyzzy.UUCP> <510@xyzzy.UUCP> <7185@sybase.sybase.com> <7189@sybase.sybase.com>
Organization: Defense Technical Information Center (DTIC), Alexandria VA
Lines: 36

coop@phobos.sybase.com (John Cooper) writes:

>I believe Sybase is the only RDBMS that has stored procedures.

You believe wrong, mister :-)
INGRES has them now.  I wouldn't be surprised if others did too.

Is this a good thing?  It's a key to getting good TP benchmarks.
Vendors respond to them, because we (generic customers) respond to
them.  Should we?  If one's applications consist mostly of repeated
execution of the same short, simple queries, then yes.  Otherwise,
TP numbers predict relative performance poorly, or not at all, or
even opposite to fact.

>   Stored procedures are batches of SQL code which can be created and stored in
>a database.  Like a 3GL program, they can contain variables, have sophisticated
>capabilities such as loops and recursion, accept input arguments which can be
                                ^^^^^^^^^

Tell us more.  What would the Sybase procedure look like that maintains
the integrity in this table

	+--------+
	| people | parent   child
	+--------+--------+-------+
                 |   Jim  |   Jon |
                 | Jesse  |   Jim |
                 +--------+-------+

that no person can be his or her own ancestor or descendent?

-- Jon (not my own grandpa) Krueger
-- 
Jonathan Krueger    jkrueger@dtic.dla.mil   uunet!dgis!jkrueger
Isn't it interesting that the first thing you do with your
color bitmapped window system on a network is emulate an ASR33?