Oracle 10g Standard

[sathishpsk9]

Hi every one,
                  can use oracle 10g standard instead of oracle spatial with mapguide os?
If yes ,can any one expalain how it can be done ?

Thanks
Satish

[zspitzer]

spatial is in all oracle 10g db's, unless you choose not to install it

On Thu, Oct 29, 2009 at 7:25 PM, sathishpsk9 <[hidden email]> wrote:

Hi every one,
                 can use oracle 10g standard instead of oracle spatial with
mapguide os?
If yes ,can any one expalain how it can be done ?

Thanks
Satish
--
View this message in context: http://n2.nabble.com/Oracle-10g-Standard-tp3910485p3910485.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

--
Zac Spitzer -
http://zacster.blogspot.com
[phone]

_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

[Dejan Gregor]

Dear Satish,

Oracle Standard is the license level of the Oracle DBMS you install (Personal, Standard, Enterprise). As Zac mentioned, Oracle Spatial is a module you just 'thick'/choose to add during your installation.

However, you should be aware that Oracle Standard vs. Enterprise edition contributes different functionalities in:

- support for 3D geometry storage
- jobs (versioning)
- ...

You can download different levels of Oracle at
http://www.oracle.com/technology/software/products/database/index.html

Cheers,
Dejan

sathishpsk9 wrote:

Hi every one,
                  can use oracle 10g standard instead of oracle spatial with mapguide os?
If yes ,can any one expalain how it can be done ?

Thanks
Satish

[JamesDudden]

Hi,
Sorry to chip in to this thread but I have just installed Oracle 10g Express in the hope of storing spatial data that can be added as a datasource in MGOS.
Does anybody know if this is possible?
If so could you give me some pointers on how to store the data in Orcale and create a layer in MG.

Any help or advice is welcome

Regards
JD

[Dejan Gregor]

James,

I have to inform you that it is no possible to add Oracle Spatial module to the Oracle Express editions (10g or  11g).

You can always store data as BLOB data types or XML objects into an Oracle DBMS, but this connectivity with MGOS is not out of the box - you would need to develop it.

I advise you to try tih Oracle DBMS 10 or 11g (Enterprise Edition).

Good luck!

Dejan

JamesDudden wrote:

Hi,
Sorry to chip in to this thread but I have just installed Oracle 10g Express in the hope of storing spatial data that can be added as a datasource in MGOS.
Does anybody know if this is possible?
If so could you give me some pointers on how to store the data in Orcale and create a layer in MG.

Any help or advice is welcome

Regards
JD

[JamesDudden]

Dejan,
Is there a free database that I could use to store spatial data in order to create a layer of polygons in MGOS?

Regards
JD

[Dejan Gregor]

Hi James,

 

there is a PostGIS module of PostGreSQL 8.x out there that 'should' be able ti communicate with MGOS. However, I was not able to connect MGOS with the FDO provider of PostGIS or OGR successfully on a Windows machine. I would not like to be offensive to the OSGEO team that worked on the PostGIS provider, but I very much doubt that it works as expected currently at MGOS 2.0.2 / 2.1 beta.

 

I suggest you to stick with the file based database like SHP and MySQL that has shown a proven track of working properly with MGE and MGOS implementations.

Good luck!

Dejan

On Thu, Oct 29, 2009 at 11:02, JamesDudden <[hidden email]> wrote:

Dejan,
Is there a free database that I could use to store spatial data in order to
create a layer of polygons in MGOS?

Regards
JD

-----
http://www.software-matters.co.uk Software Matters  -
http://www.software-matters.co.uk/bespoke-database-design.html Bespoke
Database  and Software Solutions
--
View this message in context: http://n2.nabble.com/Oracle-10g-Standard-tp3910485p3910892.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

[djonio]

James,
This is relevant to 10g and 11g. There is much misunderstanding
concerning Oracle's support of GIS. Oracle Locator is a subset of Oracle
Spatial functionality within ALL of the Oracle database products
including Oracle Express. Yes, you may optionally not install it w/in
Standard and Enterprise. (I am not sure if you even have the option of
not installing if you are using Oracle Express.) Because Oracle Express
does not come with the built in java engine some WKT/WKB functionality
is not there.
I would recommend using SL King Oracle FDO provider. I works very well.
Oracle Express 10g is free and works very well.
I have found absolutely no need for the additional functionality that
comes with the purchase of Oracle Spatial. FREE Oracle Locator provides
ample support for our needs at the moment.

I put this together some time ago. Check it out:
http://code.google.com/p/tf-net/wiki/OracleXeLicensedFunctionality

r,
dennis
_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

[Dejan Gregor]

Dear Denis,

 

you are right about the locatior in the Express edition. Never decided to install that one.

 

Dejan

On Thu, Oct 29, 2009 at 11:10, Jonio, Dennis (Aviation) <[hidden email]> wrote:

James,
This is relevant to 10g and 11g. There is much misunderstanding
concerning Oracle's support of GIS. Oracle Locator is a subset of Oracle
Spatial functionality within ALL of the Oracle database products
including Oracle Express. Yes, you may optionally not install it w/in
Standard and Enterprise. (I am not sure if you even have the option of
not installing if you are using Oracle Express.) Because Oracle Express
does not come with the built in java engine some WKT/WKB functionality
is not there.
I would recommend using SL King Oracle FDO provider. I works very well.
Oracle Express 10g is free and works very well.
I have found absolutely no need for the additional functionality that
comes with the purchase of Oracle Spatial. FREE Oracle Locator provides
ample support for our needs at the moment.

I put this together some time ago. Check it out:
http://code.google.com/p/tf-net/wiki/OracleXeLicensedFunctionality

r,
dennis

_______________________________________________
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

[JamesDudden]

Dejan,
Thank you for your helpful responses.

Just to confirm then - when I talk about spatial data I mean storing X,Y coordinates. I have successfully added layers of points from an Access db with X,Y coordinates stored in a table. But if I wanted to store multiple X,Y coordinates to create a layer of polygons I should get Oracle Enterprise or can I do this in MySQL?

Thanks again JD

[JamesDudden]

Sorry I posted this before I saw Dennis' response.

JamesDudden wrote:

Dejan,
Thank you for your helpful responses.

Just to confirm then - when I talk about spatial data I mean storing X,Y coordinates. I have successfully added layers of points from an Access db with X,Y coordinates stored in a table. But if I wanted to store multiple X,Y coordinates to create a layer of polygons I should get Oracle Enterprise or can I do this in MySQL?

Thanks again JD

[Martin Morrison]

MS SQL Server Express 2008 is also worth a look.  Free and fast.



-----Original Message-----
From: [hidden email] [mailto:[hidden email]] On Behalf Of JamesDudden
Sent: Thursday, October 29, 2009 6:02 AM
To: [hidden email]
Subject: Re: [mapguide-users] Oracle 10g Standard


Dejan,
Is there a free database that I could use to store spatial data in order to
create a layer of polygons in MGOS?

Regards
JD

-----
http://www.software-matters.co.uk Software Matters  -
http://www.software-matters.co.uk/bespoke-database-design.html Bespoke
Database  and Software Solutions
--
View this message in context: http://n2.nabble.com/Oracle-10g-Standard-tp3910485p3910892.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

[Dejan Gregor]

Dear James,

 

I agree with Martin. But you should check on the FDO support for your MGOS version for the SQL Server 2008 Express edition.

 

Dejan

On Thu, Oct 29, 2009 at 13:22, Martin Morrison <[hidden email]> wrote:

MS SQL Server Express 2008 is also worth a look.  Free and fast.



-----Original Message-----
From: [hidden email] [mailto:[hidden email]] On Behalf Of JamesDudden
Sent: Thursday, October 29, 2009 6:02 AM
To: [hidden email]
Subject: Re: [mapguide-users] Oracle 10g Standard


Dejan,
Is there a free database that I could use to store spatial data in order to
create a layer of polygons in MGOS?

Regards
JD

-----
http://www.software-matters.co.uk Software Matters  -
http://www.software-matters.co.uk/bespoke-database-design.html Bespoke
Database  and Software Solutions
--
View this message in context: http://n2.nabble.com/Oracle-10g-Standard-tp3910485p3910892.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

_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

[JamesDudden]

Thanks for all the comments so far.

Has anybody actually created a layer in MGOS that contains polygons that are made up of x,y coordinates that are stored in either Oracle 10g Express or SQL Server 2008 Express edition?

The reason I ask is I am trying to decide which one to use and it would comfort me to know there was somebody who has already achieved what I need. Also I would then like to ask them for help in the future to get it working for me.

Regards
JD

[Martin Morrison]

Yes.

http://gis.edsi.com/mecklenburgmain.php

Send me a note privately if you wish to discuss help with your specific project.

Martin

-----Original Message-----
From: [hidden email] [mailto:[hidden email]] On Behalf Of JamesDudden
Sent: Thursday, October 29, 2009 10:00 AM
To: [hidden email]
Subject: Re: [mapguide-users] Oracle 10g Standard


Thanks for all the comments so far.

Has anybody actually created a layer in MGOS that contains polygons that are
made up of x,y coordinates that are stored in either Oracle 10g Express or
SQL Server 2008 Express edition?

The reason I ask is I am trying to decide which one to use and it would
comfort me to know there was somebody who has already achieved what I need.
Also I would then like to ask them for help in the future to get it working
for me.

Regards
JD

-----
http://www.software-matters.co.uk Software Matters  -
http://www.software-matters.co.uk/bespoke-database-design.html Bespoke
Database  and Software Solutions
--
View this message in context: http://n2.nabble.com/Oracle-10g-Standard-tp3910485p3912622.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

JamesDudden wrote:

Has anybody actually created a layer in MGOS that contains polygons that are made up of x,y coordinates that are stored in either Oracle 10g Express or SQL Server 2008 Express edition?

I was using MGOS (and Autodesk MapGuide Enterprise 2009/2010) since version 1.0.2 till 2.1 beta today.
Had no problems with any version connecting to Oracle XE, 10g and/or 11g with King.Oracle FDO provider.
For more detailed info feel free to contact me via private e-mail.

[Dejan Gregor]

Dear Martin,

 

I would like to know more about your implementation on the link privided below (Macklenburg). Did you use SQL Server 2000 Express?

 

Cheers,

Dejan

On Thu, Oct 29, 2009 at 15:04, Martin Morrison <[hidden email]> wrote:

Yes.

http://gis.edsi.com/mecklenburgmain.php

Send me a note privately if you wish to discuss help with your specific project.

Martin

_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

[Martin Morrison]

Some javascript/style in this post has been disabled (why?)

Dejan,

 

On the production website we have full blown SQL Server 2008.  However, for the people editing the data and for our demo use, we use SQL Server Express 2008.  Both work well.  Please note the version number, you stated 2000 below.  The Spatial technology did not get added to SQL Server until the 2008 version.

 

Martin

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Dejan Gregor
Sent: Thursday, October 29, 2009 10:55 AM
To: MapGuide Users Mail List
Subject: Re: [mapguide-users] Oracle 10g Standard

 

Dear Martin,

 

I would like to know more about your implementation on the link privided below (Macklenburg). Did you use SQL Server 2000 Express?

 

Cheers,

Dejan

On Thu, Oct 29, 2009 at 15:04, Martin Morrison <[hidden email]> wrote:

Yes.

http://gis.edsi.com/mecklenburgmain.php

Send me a note privately if you wish to discuss help with your specific project.

Martin

_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

[Dejan Gregor]

Dear Martin,

 

just two more questions. Which version of MapGuide Open Source did you use for the production (2.0.2 or 2.1 beta)? I am concerned about the quality of the FDO for MS SQL Server 2008.

 

Also, whcih type of geometry storage type did you use (GEOGRAPHY) and did you migrate the data with any open source tools?

 

Thanks!

 

Dejan

On Thu, Oct 29, 2009 at 16:03, Martin Morrison <[hidden email]> wrote:

Dejan,

 

On the production website we have full blown SQL Server 2008.  However, for the people editing the data and for our demo use, we use SQL Server Express 2008.  Both work well.  Please note the version number, you stated 2000 below.  The Spatial technology did not get added to SQL Server until the 2008 version.

 

Martin

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Dejan Gregor
Sent: Thursday, October 29, 2009 10:55 AM
To: MapGuide Users Mail List

Subject: Re: [mapguide-users] Oracle 10g Standard

 

Dear Martin,

 

I would like to know more about your implementation on the link privided below (Macklenburg). Did you use SQL Server 2000 Express?

 

Cheers,

Dejan

On Thu, Oct 29, 2009 at 15:04, Martin Morrison <[hidden email]> wrote:

Yes.

http://gis.edsi.com/mecklenburgmain.php

Send me a note privately if you wish to discuss help with your specific project.

Martin

_______________________________________________
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

[djonio]

James,

We have used Oracle XE 10g and Oracle Enterprise 10.2.0.3 for a couple years now with good success.
About two million geometry objects. Oracle works well as does the .8 versions of SL King Oracle FDO Provider. (There was some bleeding prior to the .8 versions of SL King ... ;-)
We use Oracle's SDO_GEOMETRY object for all. Since Oracle's implementaion has been around for a lomg long time there is very good forum and other support. IMHO, if you spend the time to learn and use Oracle and the Oracle geometry objects you will be set. Your datastore, compatability and expandability will never again be an issue.

r,
dennis