Re: How to link 2 Web DB servers ?

RMO wrote:
>
> We are planning to build a an online database
> (probably be MS SQLSErver or Oracle) that will be accessible to our
> users on the web.
>
> We've got about 5000 users 50% of wich are in the states and 50% in
> Europe,
> and They will be both querying and modifying the database..
>
> The OS will be Windows NT and the database Oracle or SQLServer
>
> So the solution I was thinking about to give the best response time is 2
> servers (one in each continent)
> each one with the complete database and a replication mechanism between
> them.
>
> Now here's my question :
> Does anyone think aout an other solution ?
> Is it possible to have avoid this replication stuff (rather complicated
> to set up
> and administrate) ?
>
> I started to think about an solution whith
> US Server : Database+HTTP server+ application
> Europe SErver : HTTP server
> And a big pipe between them but my network knowledge prevented me to go
> further.
>
> Thanks in advance

A JAVA applet can only connect back to a a machine that the applet was download from. This restriction is in place for security reason.

However, it you use the VORTEXjava and VORTEXjdbc products from Trifox, you can get around this restriction. We have the ability to relay calls from the backend server (where the applet came from) to another backend server on another machine!

  Client <-----> Server A <-----> Server B

 NETSCAPE                  HTTPD                 Oracle 
    or                  MS SQL Server         VORTEXserver
  MS IE                 VORTEXserver
      

In the example above the Browser above, can reference an HTML pages whic has APPLET A, which gets download to the client machine an connects to the VORTEX server on Server A. The URL specified in APPLET A tells the VORTEX server on Server A to connect to the VORTEX server on Server B. The VORTEX server on Server B then connects to Oracle on Server B.

We currently use this type of access to allow users on the Internet to gain access to a RDBMS running on a machine inside our Firewall.

If you demonstation of this, you can down evaulation copies of VORTEXserver at http://www.trifox.com/products/eval_server.html

VORTEXjdbc provides a JDBC-compliant driver written in pure Java for Java applications to access all leading relational and legacy databases via the VORTEX database access and performance boosters, like VORTEXaccelerator, the industry-leading high performance transaction process monitor.

You can obtain an evaluation copy of VORTEXjdbc from our WEB site at http://www.trifox.com/vortex/vtxjdbc.html

VORTEXJava(tm) Edition provides a pure Java connection for Java (1.0 AND 1.1) applications to access all leading relational and legacy databases via the VORTEX database access and performance boosters, like VORTEXaccelerator, the industry-leading high performance transaction process monitor.

You can obtain an evaluation copy of VORTEXjava from our WEB site at http://www.trifox.com/vortex/vtxjava.html

Regards,

Bob Eisner
408 369-2392 Received on Sat Jun 07 1997 - 00:00:00 CDT