Re: Storing data periodically on remote server

Peter D. wrote:
On Oct 7, 6:25 am, carmelo <csa...@xxxxxxxxxx> wrote:
I have to develop a java application to send every 10 seconds a tuple,
made of 3-4 fields, to a remote server. I thought to proceed in this
way:
- server side: mysql dbms (for storing clients transmitted data)
- client side: java application which makes an odbc connection to the
remote mysql db

The expected workload is quite high, in fact, there will be about 100
clients, each of them send data on time interval of 10 seconds.

Do you think is it a good solution?

I don't know if connecting to the DB directly is a good idea. I would
recommend creating a web service to accept the data instead. The
client will connect to the web service and send the info. The server
side web service will then connect to the DB and do what it needs to
do.

With a web service you can even give your clients the option of coding
their own solutions with any language. Also, it gives you free reign
on your DB server since the web service will abstract it from the
users. If you want to change DBMS you just need to modify the web
service and not every single client.

The extra tier makes it easier to switch database and the use of
SOAP/HTTP as transport makes it possible to write clients in
other languages.

But are those features needed ?

If they are, then it is a good way.

But if they are not then it is just adding lots of
unnecessary complexity to the solution.

Arne
.

Relevant Pages

  • Re: How do Large Scale Web Service Applications Maintain Session State?
    ... cache these profiles on the server in order to increase performance. ... which is something different than stateful Web Service classes. ... We do pass a session token as ... Having systems deployed through web services allows clients to access via ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: interprocess comms in local network
    ... Server needs to be an application with buttons and menus as it will need to ... I also need to set up permissioning such that only clients that I've ... > ASP.NET provides support for implementing a web service. ... > If IIS was installed when you installed the .NET Framework, ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: Users Cant Access Documents on Server
    ... Thanks for using the SBS newsgroup. ... As well as we know, if a workstation would not access network shares, then ... Leave the Default Gateway of the internal NIC blank of the server box. ... Clients That Require SMB Signing ...
    (microsoft.public.windows.server.sbs)
  • Re: Users Cant Access Documents on Server
    ... my computer to the network on the server. ... Connection Wizard none of the computers were listed. ... The Mac clients can not communicate with the server box. ... > Error Messages When You Open or Copy Network Files on Windows XP SP1 ...
    (microsoft.public.windows.server.sbs)
  • Re: Storing data periodically on remote server
    ... made of 3-4 fields, to a remote server. ... clients, each of them send data on time interval of 10 seconds. ... recommend creating a web service to accept the data instead. ...
    (comp.lang.java.programmer)