Oracle NG

[Ugo Taddei]

Hello,

we're putting the oracle ng to work with udig. It finds the DB all
right, and almost lists the feature types ok. But I'm running into
warnings like

WARNING: No primary key or unique index found for MY_TABLE.
10-Sep-2009 10:10:14 org.geotools.jdbc.JDBCDataStore getPrimaryKey
INFO: No primary key found for SOME_OTHER_TABLE

and seeing that udig is blocked.

Are the infos and warnings such as above OK?

One of the tables has around 20 M records. Apparently udig (or
geotools?)  is taking to long to count something. I've seen it iterating
over features to calculate a bbox, but this time I'm not sure it's the
new datastore. Has the oracle ng been tested with large tables? Does
anyone have a hint where to start looking?

Mind you, I've been told the tables have indices and a basic test class
(using the oracle ng) lists me my tables without any performance problem.

Thanks in advance!

Ugo

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Geotools-gt2-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users

[aaime]

Ugo Taddei ha scritto:

> Hello,
>
> we're putting the oracle ng to work with udig. It finds the DB all
> right, and almost lists the feature types ok. But I'm running into
> warnings like
>
> WARNING: No primary key or unique index found for MY_TABLE.
> 10-Sep-2009 10:10:14 org.geotools.jdbc.JDBCDataStore getPrimaryKey
> INFO: No primary key found for SOME_OTHER_TABLE
>
> and seeing that udig is blocked.
>
> Are the infos and warnings such as above OK?
>
> One of the tables has around 20 M records. Apparently udig (or
> geotools?)  is taking to long to count something. I've seen it iterating
> over features to calculate a bbox, but this time I'm not sure it's the
> new datastore. Has the oracle ng been tested with large tables? Does
> anyone have a hint where to start looking?
>
> Mind you, I've been told the tables have indices and a basic test class
> (using the oracle ng) lists me my tables without any performance problem.

GeoServer + Oracle NG has been tested over tables with 50 million
polygons with no issues. Well, besides the time it takes to compute
the bbox if you initiate such a computation (took various minutes), but
in GeoServer that is something manual.

If uDig is assuming computing the bbox is quick and easy, well, sorry,
wrong assumption, it should let the user input a bbox manually as well.
Oracle simply does not provide any way to compute the bbox quickly.
(and to be fair, try to stick 20M records in postgis without enabling
  the fast bbox computation and you'll be staring at a locked UI
  for a while there too)

Cheers
Andrea

--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Geotools-gt2-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users

[Ugo Taddei]

Hello Andrea,

Andrea Aime wrote:

> Ugo Taddei ha scritto:
>> Hello,
>>
>> we're putting the oracle ng to work with udig. It finds the DB all
>> right, and almost lists the feature types ok. But I'm running into
>> warnings like
>>
>> WARNING: No primary key or unique index found for MY_TABLE.
>> 10-Sep-2009 10:10:14 org.geotools.jdbc.JDBCDataStore getPrimaryKey
>> INFO: No primary key found for SOME_OTHER_TABLE
>>
>> and seeing that udig is blocked.
>>
>> Are the infos and warnings such as above OK?
>>
>> One of the tables has around 20 M records. Apparently udig (or
>> geotools?)  is taking to long to count something. I've seen it
>> iterating over features to calculate a bbox, but this time I'm not
>> sure it's the new datastore. Has the oracle ng been tested with large
>> tables? Does anyone have a hint where to start looking?
>>
>> Mind you, I've been told the tables have indices and a basic test
>> class (using the oracle ng) lists me my tables without any performance
>> problem.
>
> GeoServer + Oracle NG has been tested over tables with 50 million
> polygons with no issues. Well, besides the time it takes to compute
> the bbox if you initiate such a computation (took various minutes), but
> in GeoServer that is something manual.
>
> If uDig is assuming computing the bbox is quick and easy, well, sorry,
> wrong assumption, it should let the user input a bbox manually as well.
> Oracle simply does not provide any way to compute the bbox quickly.

It does provide a metadata table where the bbox may be found (and also,
may be wrongly set). You're right, udig assumes quick bbox calculations
(and gets slow). But I've got that code commented out, so the troubkle
is somewhere else in udig.

BTW, am I right to assume that passing a schema to my data store factory
will only list my tables, whereas passing no schema will allow me to
look up every table in the db? (Again, I specifically mean the Oracle DS.)

Thanks for answering.

Ugo

> (and to be fair, try to stick 20M records in postgis without enabling
>  the fast bbox computation and you'll be staring at a locked UI
>  for a while there too)
>
> Cheers
> Andrea
>

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Geotools-gt2-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users

[aaime]

Ugo Taddei ha scritto:

>> GeoServer + Oracle NG has been tested over tables with 50 million
>> polygons with no issues. Well, besides the time it takes to compute
>> the bbox if you initiate such a computation (took various minutes), but
>> in GeoServer that is something manual.
>>
>> If uDig is assuming computing the bbox is quick and easy, well, sorry,
>> wrong assumption, it should let the user input a bbox manually as well.
>> Oracle simply does not provide any way to compute the bbox quickly.
>
> It does provide a metadata table where the bbox may be found (and also,
> may be wrongly set). You're right, udig assumes quick bbox calculations
> (and gets slow). But I've got that code commented out, so the troubkle
> is somewhere else in udig.

Ugo, there is no such metadata table. What Jody is referring to is
the index metadata, which contains some hints for structuring the index.
I've never stumbled into a real world setup that has valid bbox
information in that.

In theory we could add a flag to the datastore factory that tells
the datastore to trust that information, but first we lack the
machinery discussed here:
http://jira.codehaus.org/browse/GEOT-2572

Once that is setup I'll gladly accept patches for Oracle NG in that
direction.

> BTW, am I right to assume that passing a schema to my data store factory
> will only list my tables, whereas passing no schema will allow me to
> look up every table in the db? (Again, I specifically mean the Oracle DS.)

Correct, thought without a schema there will be troubles if you have
two tables with the same name around.

Cheers
Andrea


--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Geotools-gt2-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users

[Ugo Taddei]

Hi,

Andrea Aime wrote:
> Ugo Taddei ha scritto:

> Ugo, there is no such metadata table. What Jody is referring to is
> the index metadata, which contains some hints for structuring the index.
> I've never stumbled into a real world setup that has valid bbox
> information in that.

I mean the SDO_GEOM_METADATA table (col. DIMINFO). (Oh, I'm reading the
issue 2572. Looks like it's not always possible to use it.)

>
> In theory we could add a flag to the datastore factory that tells
> the datastore to trust that information, but first we lack the
> machinery discussed here:
> http://jira.codehaus.org/browse/GEOT-2572

Thanks. But first I have to read the document, and then understand it!
Sorry, I'm not db expert (let alone an oracle one).

>
> Once that is setup I'll gladly accept patches for Oracle NG in that
> direction.
>
>> BTW, am I right to assume that passing a schema to my data store
>> factory will only list my tables, whereas passing no schema will allow
>> me to look up every table in the db? (Again, I specifically mean the
>> Oracle DS.)
>
> Correct, thought without a schema there will be troubles if you have
> two tables with the same name around.

Thanks for the info. udig is/was not passing the schema to the factory.

>
> Cheers
> Andrea
>
>

Cheers,

Ugo

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Geotools-gt2-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users