Re: Cross-Database query engine?

On Tue, 2007-07-24 at 21:36 -0700, Darren Duncan wrote:

At 10:44 PM -0500 7/24/07, David Nicol wrote:
So you're saying that Access abstracts the handles to the multiple databases
in such a way that they appear to you as a single database, and you
can use the
tools the way you would use on a single database on the combination of the
multiple databases.

If that's the case, making several dbs look like one, then some DBMS
can already do that internally. At the very least, Oracle, MySQL,
and SQLite can all do that, afaik.

Since MySQL is what you say you want to use, I recommend looking into
the "Federated" storage engine that MySQL offers, which is in the
current 5.0.x series and later; tables of that engine are proxies for
tables under some other server. Not all SQL features are supported
with them, but the ones that are may be enough.

http://dev.mysql.com/tech-resources/articles/mysql-federated-storage.html

-- Darren Duncan

Thanks for the link.

Unfortunately MySQL can only connect to other MySQL servers ( ie not
other database servers ).

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@xxxxxxxxxxxxxxxxxxxx
website: http://www.nusconsulting.com.au

.

Relevant Pages

  • Re: Cross-Database query engine?
    ... David Nicol wrote: ... in such a way that they appear to you as a single database, ... Since MySQL is what you say you want to use, I recommend looking into the "Federated" storage engine that MySQL offers, which is in the current 5.0.x series and later; tables of that engine are proxies for tables under some other server. ...
    (perl.dbi.users)
  • Re: .Net project failures
    ... me, single database server!!! ... How application servers in the farm? ... to be able to handle 100,000 secure 'business transactions' an hour ...
    (microsoft.public.cert.exam.mcsd)