|
|
| GeoCommunity Mailing List |
| |
| Mailing List Archives |
| Subject: | RE: [gislist] help with the database and server question. |
| Date: |
03/10/2004 03:50:02 PM |
| From: |
Viktoras Didziulis |
|
|
Hi Jim!
The OS/Server combination you've described here is probably the most
expensive of all !
If you are asking about alternatives (any alternative would be cheaper in
your case :-) ) that would suit to share your databases on-line then you
have many possibilities indeed.
Lets start with OS/server combinations:
Windows NT/2000/XP and Ms IIS - probably the easiest way to go...
All other alternatives would require more knowledge and experience in IT.
And if this experience is readilly available then the most productive,
efficient and safe combinations would include any of Unix/Linux/Solaris
8/freeBSD/ or Windows NT/2000/XP operation systems and Apache 2 web server.
High productivity servers usualy run combination of Apache 2 web server on
Solaris 8. As you probably know Apache, Linux, free BSD are free (open
source).
Now in order to serve your databases in a proffessional manner some more
additional tools are needed. At first you may need additional server to give
access to your relational databases. MySQL, Postgress are available for any
OS for free or low price. Oracle technologies are known probably as the
most expensive. Microsoft also has it's SQL server.
Next you will need to select scripting language/technology that will let you
use all the power of rellational or any other databases. Here you can select
among ASP(Microsoft)/Perl/PHP 4/Cold fusion. All these can be obtained for
free, although authoring tools (unless you feel comfortably with a
programmer's text editor or notepad) usualy are not free... All those
technologies are available for both Microsoft server or Apache. Performance
of PHP today gets the highest scores worldwide. But similar performance for
Perl can be reached by installing mod_perl module to Apache server.
My conclusions would be: if you or your staff are familiar with unix-like
systems and have an insight for all the IT things, then you may get an
extremely efficient system for almost for free. However if you are not so
confident in IT domain, you would need to hire someone and this would
increase your costs much. In this case use Microsoft's products. But even
then you will need someone to do all the programming/scripting job for you
(or just learn some PHP - it's realy not too difficult) to end with an
efficent and proffessionaly designed system.
Besat regards
Viktoras
>From: James Coss <jcoss@utnet.utoledo.edu>
>To: gislist@lists.geocomm.com
>Subject: [gislist] help with the database and server question. Date: Tue, 9
>Mar 2004 12:33:22 -0500
>
>hello all,
>
>I have a query that I think some of you could really help me with. I
>appreciate any time and thoughts you could afford me. I work at the Lake
>Erie Research Center in Toledo Oh. I have been tasked with gathering some
>information about data base and server combinations that are being used
>successfully in fields similar to ours. We are an environmental research
>center on the southern shore of Lake Erie we gather and house a variety of
>information. We have in anticipation of database and hosting needs
>purchased an HP server running Unix, and Oracle 9i. The maintenance
>contracts for the 2 items are, well, pricey to put in mildly. we are
>considering alternatives to both the server and the database. But I have
>been tasked to test the waters and see what others are using and eliciting
>any comments or ideas from users. I have my own ideas about what would work
>out here. I say out here we are some distance from main campus, and thus
>separate physically from the IT department--which isn't necessarily a bad
>thing. There is an on-your-own feel to the tech needs of this center. Any
>way any thoughts, ideas or comments would be greatly appreciated.
>Thanks so much for your time. have a great week
>
>JIM
>
>
>James Coss M.A.
>Image Science Geographer
>Geographic Imaging Lake Erie Center
>6200 Bayshore Rd. Oregon, Oh.
>
>419-530-8374
>419-630-8360
>
>_______________________________________________
>gislist mailing list
>gislist@lists.geocomm.com
>http://lists.geocomm.com/mailman/listinfo/gislist
>
>_________________________________
>This list is brought to you by
>The GeoCommunity
>http://www.geocomm.com/
>
>Get Access to the latest GIS & Geospatial Industry RFPs and bids
>http://www.geobids.com
_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*
http://join.msn.com/?page=features/virus
_______________________________________________
gislist mailing list
gislist@lists.geocomm.com
http://lists.geocomm.com/mailman/listinfo/gislist
_________________________________
This list is brought to you by
The GeoCommunity
http://www.geocomm.com/
Get Access to the latest GIS & Geospat
|
|
Sponsored by:
For information
regarding
advertising rates
Click Here!
|
