SQL Anywhere database - Proxy Tables vs MobiLink

Author

Proxy Tables vs MobiLink

Chris Werner

2005-12-19, 9:23 am

Hi,

I've to decide about the usage of proxy tables versus
a MobiLink setup for a special purpose database (SPD)
which is in fact a certain subset of the business database
(BD). The BD is an Oracle 8 installation on a Linux
tier in a highly secure network. This network is'nt
reachable for clients working in some PHP enriched
webforms. The SPD is ASA 9 on the web server which
operates also under Linux. The content of the SPD is
a subset of the BD in different aspects:

- Tables: Only some tables from the BD go to the SPD
- Rows: Only certain rows from the needed tables go
to the SPD
- Authorization: Most tables in the SPD have to be
read only

I wonder if all aspects can be supported using an ASA
9 database with proxy tables instead of develop a whole
MobiLink setup.

Thanks in advance for every hint,

Chris Werner

Greg Fenton

2005-12-20, 3:23 am

Chris Werner wrote:
> I wonder if all aspects can be supported using an ASA
> 9 database with proxy tables instead of develop a whole
> MobiLink setup.
>

There are, as always, pros and cons to whichever solution you choose.

Personally, I would be going with a MobiLink configuration for a few
reasons:

- availability: no need to constant connection between SPD(ASA) and
BD(Oracle)
- security: only need to enable short, secure connection from dbmlsync
on SPD to ML server on BD
- flexibility in partitioning rules (synchronization scripts)

Should the network link between the two become severed or should your
network admins become leary of web apps hitting you BD, then under a ML
environment your website continues to run without issue.

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Chris Werner

2005-12-20, 3:23 am

Thank you very match Greg, this helps me and
I will go along your guess.

Thanks again,

Chris Werner

"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> schrieb im Newsbeitrag
news:43a7874a$1@foru
ms-2-dub...
> Chris Werner wrote:
>
> There are, as always, pros and cons to whichever solution you choose.
>
> Personally, I would be going with a MobiLink configuration for a few
> reasons:
>
> - availability: no need to constant connection between SPD(ASA) and
> BD(Oracle)
> - security: only need to enable short, secure connection from dbmlsync on
> SPD to ML server on BD
> - flexibility in partitioning rules (synchronization scripts)
>
> Should the network link between the two become severed or should your
> network admins become leary of web apps hitting you BD, then under a ML
> environment your website continues to run without issue.
>
> Hope this helps,
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/

Sponsored Links