Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsWhite Papers
Discussion GroupsFirst AidDatabasesJavaBeansGUIJava 3DVirtual MachineCORBASecurityToolsGeneral
Java DirectoryOpen Source ProjectsSample Book ChaptersUser GroupsWeb Resources
Related Topics
Databases.NETMore Topics ...

Java Forum / General / March 2006

Tip: Looking for answers? Try searching our database.

Design for data transfer functionality

Thread view: 
Digital Puer - 12 Mar 2006 22:43 GMT
This is a bit of a distributed systems design issue question. This is
my current set-up:

Server A (Win): SQL database
Server B (Linux): computation engine (C++ that reads proprietary
format)

Currently, we have a JDBC client on server A which extracts data
from the SQL database and writes it to a proprietary data format
and zipped, all in the Java client. The data is then scp'ed over to
Server B, where we unzip the file by hand so it can be read by
the C++ application.

I would like to bypass the file I/O on server A. I'm thinking of
creating a client-server pair on Server A and B. Our Java process
on A still uses JDBC to get SQL data. However, instead
of writing to disk, it serializes the data into objects, which are
then shipped over secure sockets to Server B,  where a
complementary process deserializes the data and writes it to file.

Many files need to be transferred between A and B, on the order
of thousands of files, each about 50K to 100K each.

What do you make of this?
tom fredriksen - 13 Mar 2006 23:35 GMT
> This is a bit of a distributed systems design issue question. This is
> my current set-up:
>
> Server A (Win): SQL database
> Server B (Linux): computation engine (C++ that reads proprietary
> format)

Why cant the db client be running on server B instead of on server A?
Its easy enough to set up the db connection to be encrypted. That would
simplify your system layout somewhat and you would not need to implement
anything new.

/tom


Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.