New answers tagged

5

The difference is between CLR static methods (type_name::method()) and instance methods (instance.method()) Static methods are defined on the type itself and are generally utility methods that get everything they need to operate passed in as method parameters. Instance methods operate on an object of a particular datatype and are able to access the ...


0

Are you referring to calling SQL objects from .NET code (such as C#, VB, C++)? Or are you referring to calling .NET methods from SQL Objects? The syntax you are using is not valid MS SQL syntax. Common MS SQL Syntax is: Database.schema.Column Database.schema.Function(arg) OR schema.function Database.schema.StoredProcedure(arg/param) OR schema....


4

You could shard by location. Partition the globe into a grid and have each square in that grid on one server. Since you mentioned cloud, that would be well suited to cloud. Of course your will need to manually merge the results from multiple servers. That way you can use any database solution your like. It does not need to be scalable on its own. The ...


3

It sounds like there are two classes of query - one to understand which locations lie within the current view window and a second to deliver the desired statistic for those points. My suggestion is to use separate, specialised tools for each. I'm assuming all measurements relate to the same set of 75Bn points. These lat/longs, once established, are ...


8

How up-do-date do your read queries need to be? You could partition the database by time if the map just needs to show the most recent measurement. This would reduce your query load for the map. For the history of a given point, you could hold a second store by x and y showing the history. This could be done with a nightly refresh/update as the the ...



Top 50 recent answers are included