From: Peter Brawley
Date: February 1 2008 3:50am
Subject: Re: Decimal - Maximum is 30
List-Archive: http://lists.mysql.com/mysql/211188
Message-Id: <47A2971A.5040404@earthlink.net>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="------------050401050906010904060309"

--------------050401050906010904060309
Content-Type: text/plain; charset=windows-1250; format=flowed
Content-Transfer-Encoding: 7bit

>Postgres has PostGIS
>Oracle has OracleSpatial
>MySQL has ?

OpenGis.

PB

Martin Gainty wrote:
> Michael-
>
> I can certainly understand the upgrade based on the performance advantages
> of MySQL
> What would NASA use for its mapping GIS/Mapping software?
> Postgres has PostGIS
> Oracle has OracleSpatial
> MySQL has ?
>
> Many Thanks for the link
> Martin--
> ----- Original Message -----
> From: "Michael Cole" <colemichae@stripped>
> To: <mysql@stripped>
> Sent: Thursday, January 31, 2008 8:45 PM
> Subject: Re: Decimal - Maximum is 30
>
>
> On Friday 01 February 2008 7:32:33 am Warren Young wrote:
>   
>> The average grain of sand is a bit smaller than a millimeter. There are
>> a million millimeters per kilometer.
>>
>> 10^11 * 10^13 * 10^6 = 10^30
>>
>> In other words, the current system is sufficient for establishing the
>> location of every grain of sand in the universe at this scale. If we
>> rescale by making use of the digits we're allowed to the left of the
>> decimal point, we can probably describe the location of every atom in
>> the universe instead. You must be working on something absolutely
>> mind-blowing for this amount of precision to be insufficient.
>>     
> I think you missed something in your formula,
>
> You just have a 1 dimension dealt with here.
>
> That would be every grain in that line.
>
> But when i first read the statement before i had the same conclusion that
> 10^30 would normally be enough for anyone, I noticed years ago Nasa used
> MYSQL -2000 to be exact..
>
> NASA switches from Oracle to MySQL
> In November a team at NASA's Marshall Space Flight Center finished the
> transition of the NASA Acquisition Internet Service (NAIS) from Oracle to
> MySQL. NAIS sends e-mail notifications to users based on specified interests
> and enables users to query the Web site (nais.nasa.gov) for updated
> opportunities.
> Dwight Clark, project leader of NAIS, claims to have noticed an increase in
> speed of performance without experiencing any problems.
> The switch to Open Source software was primarily driven by costs, and MySQL
> was found to be the most robust product available. The President's
> Information Technology Advisory Committee recommended in September that the
> federal government encourage open-source software as an alternative for
> software development for high-end computing and allow open-source
> development
> efforts to compete on a "level playing field" with proprietary solutions in
> government procurements.
> Read the whole story at Federal Computer Week:
> http://www.fcw.com/fcw/articles/2000/1204/pol-nasa-12-04-00.asp
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=mgainty@stripped
>
>
>
>   

--------------050401050906010904060309--