Multi RDBMS queries...

From: Tim Howell (tim_at_fefcful.org)
Date: 07/29/04 

To: dbi-users@perl.org
Date: Thu, 29 Jul 2004 12:23:03 -0700

Does anyone know of a module that allows queries to be executed across
databases running on multiple RDBMSs? It's not terribly elegant, but I
have situations where I need to run a query that pulls information from
a people table, and then grabs addresses and stuff either from MySQL or
MSSQL Server depending on the id of the record from the people table.
I realize that a multi- system query wouldn't enjoy most of the
optimization that should be handled by the DBMS, but I'm thinking of
what would make things cleaner conceptually when performing these kind
of queries.

One option I've thought of is to do really simple parsing of the SQL,
and then building a temporary DB in memory on one of the DBMSs, then
running the query, unmodified, against that DB.

Are there as many reasons that this won't work as I imagine there might
be?

Thanks! =)

--TWH

Relevant Pages

  • RE: Dynamically referencing a recordset?
    ... through that recordset to set the query parameters in VBA. ... to be the one who had to modify 1440 queries if there is a change in the ... different table schema, then you need 3, one for each record type. ... This is a database that tracks the production on records in another ...
    (microsoft.public.access.modulesdaovba)
  • Re: Was: what does "serialization" mean?
    ... > the specific queries up front. ... that the NEXT time the query is run the query is fast, ... data base, don't know squat" when in fact the Donald clone doesn't ... >> WHATEVER would probably be a separate query to summarize total sales. ...
    (comp.programming)
  • Re: Official Status of SQLServer 2005 ADP
    ... I have said that the support for SQL passthrough ... queries under MDB was bad and worst than the one offered by ADP while you ... > attempt to "pass through" every Access query against a linked ODBC ...
    (microsoft.public.access.adp.sqlserver)
  • Re: "Query Too Complex" Errors
    ... few dozens of queries, in the middle of which there's a long chain of ... we've been having a lot of those "Query Too ... some of the complexity in the SQL ... SQL statement you are working on. ...
    (microsoft.public.access.forms)
  • Re: Cluster synchronize
    ... queries per unit time. ... CPU is the ONLY bottleneck. ... increase in query capacity. ... queries that perform sequential I/O or queries performing random I/O. ...
    (microsoft.public.sqlserver.clustering)