[mapguide-users] King.Oracle provider - how to create join with table without geometry data?

[Bojan Franc at FER]

Seems like the table is too big for the provider to read it and it timed out.
Also, seems like I need a different aproach for my problem.

Was thinking of creating a SQL statement to fetch the data needed (SELECT ... FROM ... LEFT OUTER JOIN ... ON ... WHERE day = To_Date(...) ).
Then creating features of that data, inserting it in a new layer and adding it to an existing map.

My concern is, there could be up to 150 000 GPS locations per day and I think it's a bit too much to handle on the fly DB - PHP - MG.

  ----- Original Message ----- 
  From: Haris Kurtagic 
  To: MapGuide Users Mail List 
  Sent: Monday, January 25, 2010 3:37 PM
  Subject: Re: [mapguide-users] King.Oracle provider - how to create join with table without geometry data?


  That error looks more like networking problem then MG&King.Oracle.


  I guess googling for it would be first step ::)


  Haris


  On Mon, Jan 25, 2010 at 3:33 PM, BojanFranc at FER <bojan.franc at fer.hr> wrote:

    Thx for info, I can select it now.

    Now, another problem... 
    I created the JOIN, restarted MGOS just in case...
    In MG Studio I can edit the features, it lists the feature values (means it reads data from the new join) but the layer is empty (nothing shown on map).
    In FeatureSource editor in MG Studio I can preview my other tables and views, but when I try to preview (data and features) my JOIN I get an error...

    An exception occurred in FDO component. ORA-12520: TNS:listener could not find available handler for requested type of server 

    I am using MGOS 2.1 and King.Oracle version 0.8.8

      ----- Original Message ----- 
      From: [hidden email] 
      To: [hidden email] 
      Sent: Monday, January 25, 2010 2:19 PM
      Subject: Re: [mapguide-users] King.Oracle provider - how to create join with table without geometry data?


      If I am not mistaken you can use KingFdoClass metadata table to add non-geometry tables. 


      Haris


      On Mon, Jan 25, 2010 at 2:10 PM, [hidden email] <[hidden email]> wrote:


        Hi,

        I have a data warehouse with a FACT table containing a lot of points (GPS
        locations). And I have a DATE dimension table.
        I want to draw a layer containing all locations within 1 day (or a period of
        days).

        I was thinking of doing a JOIN with King.Oracle of that FACT and DIMENSION
        table, exporting it to XML and then in PHP editing the filter tag with "DATE
        = YYYY.MM.DD". After modifying the layer, I would insert the new layer into
        map and draw it.
        It should also work fast enough for users to be able to go BACK and FORWARD
        displaying maps for each day.

        The problem is, in King.Oracle provider, I see only tables and views with
        geometry fields. And I need to join my DATE dimension which has no geometry
        (logicaly).
        Is it possible?

        Also, has anyone a better solution for my problem?

        I have round 10 Mil GPS locations for every year.

        Thx!

        --
        View this message in context: http://n2.nabble.com/King-Oracle-provider-how-to-create-join-with-table-without-geometry-data-tp4453820p4453820.html
        Sent from the MapGuide Users mailing list archive at Nabble.com.
        _______________________________________________
        mapguide-users mailing list

        [hidden email]

        http://lists.osgeo.org/mailman/listinfo/mapguide-users




      _______________________________________________ 
      mapguide-users mailing list 
      [hidden email] 

      http://lists.osgeo.org/mailman/listinfo/mapguide-users



----------------------------------------------------------------------------
    View this message in context: Re: [mapguide-users] King.Oracle provider - how to create join with table without geometry data?

    Sent from the MapGuide Users mailing list archive at Nabble.com.


    _______________________________________________
    mapguide-users mailing list
    mapguide-users at lists.osgeo.org
    http://lists.osgeo.org/mailman/listinfo/mapguide-users






------------------------------------------------------------------------------


  _______________________________________________
  mapguide-users mailing list
  mapguide-users at lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/mapguide-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20100128/f8176af7/attachment.html