Informix, SQL Server or Oracle
Not a bug report but a product-selection question: the poster needed to pick an RDBMS (SQL Server, Informix or Oracle) for a GIS on Linux or NT/Intel holding 10-15 GB of large objects such as satellite images and digitised maps. Replies recommended Informix IDS.2000 with geospatial and image DataBlades so the data can be queried via SQL; an Oracle advocate pitched Oracle8i Standard Edition with its built-in interMedia location/image features; another poster gave a feature-by-feature ranking (Informix generally ahead on speed, BLOBs and administration, Oracle on security/auditing), and someone who had built GIS systems on both favoured Informix. No decision or outcome from the original poster is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello: I'm looking for arguments to take a decission about what RDMBS to use for a GIS (Geographic Information System). Database has to store large objects like images, satellite photograph, digitalized maps... I estimate data volume will be about 10-15 Gbytes. Security and stability are important but not critical, we plan to use Linux or Win NT on Intel as platform. RAID controllers, etc... We are in doubt for SQL Server, Informix or Oracle. Thanks in advance. Daniel Paz,,
In the year of Our Lord Fri, 26 Jan 2001 18:12:01 +0100, "Daniel Paz Cornes" <cornes@navegalia.com> spake, saying: >Hello: > >I'm looking for arguments to take a decission about what RDMBS to use for a >GIS (Geographic Information System). Database has to store large objects >like >images, satellite photograph, digitalized maps... >I estimate data volume will be about 10-15 Gbytes. >Security and stability are important but not critical, we plan to use Linux >or Win NT >on Intel as platform. RAID controllers, etc... > >We are in doubt for SQL Server, Informix or Oracle. Guess what I'm going to recommend? Informix IDS.2000, with a geospatial datablade and and image datablade. You can then access and query all your data with "built-in" SQL functions
Hi I am working in a organization using 3 database environment namely Oracle, Informix and SQL Server. I am familiar with these 3 database environment. What I found is (In order of 1st, 2nd, 3rd ) 1) Fastest Implementation is 1) Informix ,2) SQL Server, 3) Oracle 2) Transferring of Data (or Migration) between Different Databases - 1) Informix 2) SQL Sever 3) Oracle 3) Data Retrieval - 1)Informix 2) SQL Server and Oracle Almost Same 4) Implementation of Blob Objects - 1) Informix 2) SQL Server and 3) Oracle (Storing of Graphical object like Photos, Scanned Images etc.) 5) Security - 1) Oracle 8i 2) SQL Server and Informix Almost Same 6) Auditing - 1) Oracle 8i 2) SQL Server 3) Informix 7) Easy Database Administration - 1) Informix 2) SQL Server 3) Oracle 8) Easiest tools Available at the Time of Database Structure Creation - 1) SQL Server 2) Informix 3) Oracle 9) *RAW Hard disk Partition Utilization - 1) Informix 2) Oracle and Easy Implementation * RAW Disk Partition Will be managed by the Database Server Itself , Not by the Operating System will enhance the Speed of Data Retrieval) 10) Platform Availability - SQL SERVER IS NOT AVAILABLE OTHER THAN NT/ALPHA Regards GIGI M John Daniel Paz Cornes <cornes@navegalia.com> wrote in message news:3a71afc1@news... > Hello: > > I'm looking for arguments to take a decission about what RDMBS to use for a > GIS (Geographic Information System). Database has to store large objects > like > images, satellite photograph, digitalized maps... > I estimate data volume will be about 10-15 Gbytes. > Security and stability are important but not critical, we plan to use Linux > or Win NT > on Intel as platform. RAID controllers, etc... > > We are in doubt for SQL Server, Informix or Oracle. > > Thanks in advance. > > Daniel Paz,, > > >
As an entry point try Oracle8i Standard Edition - it's cheap, available on NT and Linux, the location ( http://otn.oracle.com/products/intermedia/pdf/loc_twp.pdf ) and image ( http://otn.oracle.com/products/intermedia/pdf/imed_twp.pdf ) capabilities don't require additional licencing, and don't come from third parties, eliminating the finger pointing between different support organizations. Download before you buy http://otn.oracle.com/software/products/oracle8i/software_index.htm Note the above links will require a subscription to the Oracle Technical Network, but it's free. > From: obnoxio@hotmail.com (Obnoxio The Clown) > Organization: The Local Circus > Newsgroups: comp.databases.informix > Date: Fri, 26 Jan 2001 18:11:58 GMT > Subject: Re: Informix, SQL Server or Oracle > > In the year of Our Lord Fri, 26 Jan 2001 18:12:01 +0100, "Daniel Paz Cornes" > <cornes@navegalia.com> spake, saying: > >> Hello: >> >> I'm looking for arguments to take a decission about what RDMBS to use for a >> GIS (Geographic Information System). Database has to store large objects >> like >> images, satellite photograph, digitalized maps... >> I estimate data volume will be about 10-15 Gbytes. >> Security and stability are important but not critical, we plan to use Linux >> or Win NT >> on Intel as platform. RAID controllers, etc... >> >> We are in doubt for SQL Server, Informix or Oracle. > > Guess what I'm going to recommend? Informix IDS.2000, with a geospatial > datablade and and image datablade. You can then access and query all your data > with "built-in" SQL functions >
In the year of Our Lord Sat, 27 Jan 2001 02:28:39 GMT, Mark Townsend <markbtownsend@home.com> spake, saying: >As an entry point try Oracle8i Standard Edition - it's cheap, available on >NT and Linux, the location ( >http://otn.orable.com/products/intermedia/pdf/loc_twp.pdf ) and image ( >http://otn.orable.com/products/intermedia/pdf/imed_twp.pdf ) capabilities >don't require additional licencing, and don't come from third parties, >eliminating the finger pointing between different support organizations. Which capabilities are these then? :-> >Download before you buy >http://otn.orable.com/software/products/orable8i/software_index.htm > >Note the above links will require a subscription to the Oracle Technical >Network, but it's free. > >> From: obnoxio@hotmail.com (Obnoxio The Clown) >> >> In the year of Our Lord Fri, 26 Jan 2001 18:12:01 +0100, "Daniel Paz Cornes" >> <cornes@navegalia.com> spake, saying: >> >>> Hello: >>> >>> I'm looking for arguments to take a decission about what RDMBS to use for a >>> GIS (Geographic Information System). Database has to store large objects >>> like >>> images, satellite photograph, digitalized maps... >>> I estimate data volume will be about 10-15 Gbytes. >>> Security and stability are important but not critical, we plan to use Linux >>> or Win NT >>> on Intel as platform. RAID controllers, etc... >>> >>> We are in doubt for SQL Server, Informix or Oracle. >> >> Guess what I'm going to recommend? Informix IDS.2000, with a geospatial >> datablade and and image datablade. You can then access and query all your data >> with "built-in" SQL functions >> >
Having implemented a GIS both on Informix and Oracle, I would choose Informix every time. The ease of configuration, loading data and the speed of GIS queries, Informix won every time. We used the GIS for mapping and 3D modelling of our ore bodies. Cheers Hans Gigi M John <gigijohn@omantel.net.om> wrote in message news:94sfl5$dqb1@OM9.omantel.net.om... > Hi > I am working in a organization using 3 database environment namely > Oracle, Informix and SQL Server. > I am familiar with these 3 database environment. What I found is > (In order of 1st, 2nd, 3rd ) > > 1) Fastest Implementation is > 1) Informix ,2) SQL Server, 3) Oracle > 2) Transferring of Data (or Migration) between Different > Databases - 1) Informix 2) SQL Sever 3) Oracle > 3) Data Retrieval > - 1)Informix 2) SQL Server and Oracle Almost Same > 4) Implementation of Blob Objects - 1) Informix 2) > SQL Server and 3) Oracle > (Storing of Graphical object like Photos, Scanned > Images etc.) > 5) Security - 1) > Oracle 8i 2) SQL Server and Informix Almost Same > 6) Auditing - 1) > Oracle 8i 2) SQL Server 3) Informix > 7) Easy Database Administration - 1) Informix 2) > SQL Server 3) Oracle > 8) Easiest tools Available at the Time of Database > Structure Creation - 1) SQL Server 2) Informix 3) Oracle > 9) *RAW Hard disk Partition Utilization - 1) > Informix 2) Oracle > and Easy Implementation > * RAW Disk Partition Will be managed by the Database > Server Itself , Not by the Operating System will enhance the > Speed of Data Retrieval) > 10) Platform Availability - SQL > SERVER IS NOT AVAILABLE OTHER THAN NT/ALPHA > > Regards > > GIGI M John > > Daniel Paz Cornes <cornes@navegalia.com> wrote in message > news:3a71afc1@news... > > Hello: > > > > I'm looking for arguments to take a decission about what RDMBS to use for > a > > GIS (Geographic Information System). Database has to store large objects > > like > > images, satellite photograph, digitalized maps... > > I estimate data volume will be about 10-15 Gbytes. > > Security and stability are important but not critical, we plan to use > Linux > > or Win NT > > on Intel as platform. RAID controllers, etc... > > > > We are in doubt for SQL Server, Informix or Oracle. > > > > Thanks in advance. > > > > Daniel Paz,, > > > > > > >
At last, someone with more light than heat. Thks. Rudy Gigi M John <gigijohn@omantel.net.om> wrote in message news:94sfl5$dqb1@OM9.omantel.net.om... > Hi > I am working in a organization using 3 database environment namely > Oracle, Informix and SQL Server. > I am familiar with these 3 database environment. What I found is > (In order of 1st, 2nd, 3rd ) ...