Same situation in DB2. Since version 10.x. DB2 has temporal support and I
am using it for a customer. Temporal support is a really cool feature.
For DB2 I can set a special register for a connection
set current business_time = ""
After this statement, all read requests work as expected. (DB2 includes
"for business_time as of" for each statement automatically).
Unfortunately, this may cause problems concerning connection pooling.
+1 for integrating temporal support, but as always, its a matter of time
and funding.
Cheers
Chrsitan
On Sat, Nov 16, 2013 at 1:06 AM, Martin Davis <mtncl...@gmail.com> wrote:
> We're looking at using GeoServer with data stored in Oracle 12c modelled
> using its new valid time capability [1]. (Actually the data is modelled
> using the Flashback Archive support for transaction time as well, making it
> bitemporal. But the valid time dimension is of most interesting for
> mapping).
>
> Has anyone had experience of using 12c valid time queries through
> GeoServer?
>
> It would be great if the WMS TIME dimension worked with 12c, but that
> seems like it might require some enhancements. (Any estimate of level of
> difficulty for this?)
>
> The use of SQLViews also comes to mind, but this seems to have two issues:
> - it would be necessary to supply a fairly complex substitution parameter
> value (e.g. "AS OF PERIOD FOR etc"
> - this would have to be supplied for each temporal layer in a WMS query
> But possibly this is doable, via some smarts in the client (or even a
> proxy which adds the time filter to the request)
>
> In the bigger picture, with SQL:2011 temporal features [2] slowly making
> their way into database implementations, this kind of capability might be
> worth addressing in GeoServer at a deeper level.
>
> [1]
> http://docs.oracle.com/cd/E16655_01/appdev.121/e17620/adfns_design.htm#ADFNS967
> [2] http://en.wikipedia.org/wiki/SQL:2011#Temporal_support
>
>
> ------------------------------------------------------------------------------
> DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
> OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
> Free app hosting. Or install the open source package on any LAMP server.
> Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
> http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
--
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
------------------------------------------------------------------------------
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
