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" > To: > 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--