Re: Database Server based on SQL database

Maybe I do not understand. Or maybe my question was not clear. The server
is a socket server. ie you communicate with server via sockets. There is a
product from BMC software called Remedy which works in this way. Data
storage is a SQL server. But clients don't talk directly to database -
communication is via socket server.

ie the client doesn't have OLE DB, ADO, DAO or whatever installed - they
communicate via sockets - and some sort of protocol. That is what I am
trying to design.

Angus



"Vadym Stetsyak" <vadym_s@xxxxxxx> wrote in message
news:O2R9a6lCHHA.4740@xxxxxxxxxxxxxxxxxxxxxxx
Hello, Angus!

What does it mean "based ib SQL database"?

Have you seen DB servers like mySQL?
Its open source, so you can investigate its design.
Have a look at it ( http://www.mysql.org/ )

Also there are a lot of technical papers on MS SQL Server. From these
papers
you can obtain the picture of DB server parts and architecture...

A> I want to build a socket based database server. How should the
A> client
A> communicate with the server? Should I create SQL syntax at the
A> client and
A> let the server pass this onto the database? Does this work? Would
A> creating
A> a totally new custom protocol for the database communication be
A> better?

A> I intuitively feel that that re-inventing the wheel is probably not
A> very
A> clever. And if the client can create the SQL strings that should
A> work ok.
A> But would be interested to hear from anyone who has also written or
A> is
A> writing a database server.

A> Another issue I suppose is buffering. Should the server store the
A> retrieved
A> SQL searches in memory and just pass to client the record they are
A> viewing?
A> Suppose makes sense.

A> Any comments would be greatly appreciated.

A> Angus



--
Regards, Vadym Stetsyak
www: http://vadmyst.blogspot.com


.

Relevant Pages

  • Re: How to terminate a socket in CLOSE_WAIT state
    ... FTP Server fixed for certain FTP clients who use both passive ... This was causing a PASSIVE opened socket to be left ... but instead expect the "half close" from the receiver. ... this sends a TCP/IP FIN packet to the ...
    (microsoft.public.win32.programmer.kernel)
  • Re: Socket switch delay
    ... both at the client and at the server (and why ... would you set the send buffer size to zero on a non-overlapped ... One glaring error is your client does ... So when you use a single socket, ...
    (microsoft.public.win32.programmer.networks)
  • Re: Applet Hangs when submitting data to servlet
    ... to put a time limit on my socket connections and socket reads. ... public void setTimeoutthrows UnknownHostException, ... on our web server. ... private JButton theSubmitButton_, theClearButton_; ...
    (comp.lang.java.programmer)
  • Re: Problem with writing fast UDP server
    ... UDP packets per second. ... socket and threads. ... I wrote a simple case test: client and server. ... The maximum theoretical limit is 14,880 frames per ...
    (comp.lang.python)
  • Re: Socket Exception
    ... In this case the server most likely rejected your ... connection. ... Each command is a new socket connection that is opened and closed ... /// Required designer variable. ...
    (microsoft.public.win32.programmer.networks)
Loading