Sunday, July 27, 2008

What are those guys in Bangalore and Beijing upto?

With globalization time is not the only constraint and we need to contend with space (location, fortunatlely on earth). Storing Spatial information has become very important to know what those guys are doing in Bangalore or Beijing.

SQL Server 2008 can handle this very well. If you believe the earth is flat you can use the 'Geometric' data, on the other hand if you believe the earth is not flat but round (or oval) you cannot just use coordinates but you use longitudes and latitudes, in other words the geographic representation. SQL Server 2008 handles both of them well.

This time around Microsoft is doing it properly, I mean, adhering to well known standards. Open Geospatial Consortium (OGC) Simple Features for SQL Specification version 1.1.0 in the case of Geometric data and uses well known GPS latitude and longitude coordinates for geographic representation.

I will be back next time with more on this.

No comments: Protection Status