Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!tut.cis.ohio-state.edu!ucbvax!mtxinu!sybase!phobos!coop
From: coop@phobos.sybase.com (John Cooper)
Newsgroups: comp.databases
Subject: Re: Client/Server processes and implementations
Keywords: Client Server Processes
Message-ID: <7189@sybase.sybase.com>
Date: 22 Nov 89 19:08:25 GMT
References: <7114@sybase.sybase.com> <6895@sybase.sybase.com> <2184@kodak.UUCP> <375@xyzzy.UUCP> <510@xyzzy.UUCP> <7185@sybase.sybase.com>
Sender: news@sybase.sybase.com
Reply-To: coop@phobos.UUCP (John Cooper)
Organization: Sybase, Inc.
Lines: 28

In article <7185@sybase.sybase.com> forrest@sybase.com writes:
>Don't forget that our limitiation is only that one database can't
>be accessed by more than one server at a time. You can run any number
>of servers on one machine, as long as you have the resources to support
>the servers. Plus, given the fact that servers can talk to other servers
>by  using RPC's, the end effect isn't that much different than having
           ^^^^^
>multiple servers talking to the same database.

My colleague Jon Forrest neglected to mention what RPC's are.  For those not
familiar with Sybase this stands for Remote Procedure Calls.  As of version
4.0 of our SQL-Server, we offer the ability for a user in one server to call a
stored procedure remotely in another server.

I believe Sybase is the only RDBMS that has stored procedures.  For those who
aren't familiar with them in general:
   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
altered for return, and return status codes upon completion.  They are also
compiled so that their execution plans can be resident in cache; the compiled
code is stored in system tables as is the SQL source.

John Cooper                               | My opinions, may not be employer's.
sybase!coop@sun.com                       |
{sun,lll-tis,pyramid,pacbell}!sybase!coop | "If you don't like the news you can
6475 Christie Av.  Emeryville, CA 94608   | always go out and make some of your
415 596-3500                              | own."