[mapguide-dev] Enhanced Join Support RFC

[Jason Birch]

It is also useful in cases with RDBMS where you don't have control over the schema.  For instance, in the case of a third-party land information system where your support contract does not allow you to make changes.
 
There is also the case where you are joining across RDBMS providers, for instance between my parcels which are stored in Oracle SE, and my land data which is stored in MS SQL.  In some cases, these might even be two Oracle instances/schemas where I don't have rights to link the two or create cross-schema joins.  More commonly, there might be a SHP or SDF file that needs to be linked to an external RDBMS (which seems to be the primary case that Studio was designed for) or another file-based source.
 
I do like the idea of seeing this implemented at the FDO level, as it will likely be more efficient, and will be usable by all clients without having to re-implement.  It's about data after all.
 
In either case, it sounds like a bit of a UI nightmare...
 
Jason
 

________________________________

From: Haris Kurtagic [mailto:haris at sl-king.com]
Sent: Fri 2006-11-03 3:34 PM
To: dev at mapguide.osgeo.org
Subject: RE: [mapguide-dev] Enhanced Join Support RFC


I suppose Join is most interesting for file based data sources ?
 
It looks to me that for rdbms data sources this is "natural" stuff to do.
 
In that context, I have a feeling that this could be something for FDO level not MG.
 
One of advantages would be that join functionality wouldn't be just to MG but other clients also.
 
Perhaps little crazy idea but I also could imagine having a "join fdo provider" which will do the work for join for classes across providers.
 
Haris

________________________________

From: Ronnie Louie [mailto:ronnie.louie at autodesk.com] 
Sent: Friday, November 03, 2006 11:48 PM
To: dev at mapguide.osgeo.org
Subject: [mapguide-dev] Enhanced Join Support RFC



Hi All,

 

A first draft of Enhanced Join Support RFC for MGOS is posted at http://wiki.osgeo.org/index.php/MapGuide_RFC_5_-_Enhanced_Join_Support.

 

Please have a look and post your feedback to this group.

 

Thanks

Ronnie Louie

 

 

 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 6885 bytes
Desc: not available
Url : http://lists.osgeo.org/pipermail/mapguide-internals/attachments/20061103/450202ee/attachment.bin