Skip to content
Advertisement

Tag: mapping

SQL Join on table with revision dates

I am about to begin working on a solution for my company in SQL that requires me to link product category mappings based on a SKU number. The problem is that the category mappings can change, and they will have a date associated with the change. For example: Product 1 is currently mapped to category A. User realizes it was

Ideal database for geo (map) data

I’m looking for suggestions for an ideal database or data structure for storing a map. Essentially, the map consists of “ways” which are like roads, paths, etc. Ways contain nodes (which have a latitude and longitude coordinate, and sometimes an altitude.) Any such database or structure: should be able to locate all the nodes in a bounding box quickly (milliseconds)

Advertisement