You can actually do really fun (and fast!) things with dates by mapping them to geospatial types. For an example see: http://explainextended.com/2009/08/11/eff

You can actually do really fun (and fast!) things with dates by mapping them to geospatial types. For an example see: http://explainextended.com/2009/08/11/efficient-date-range-query-sql-server/ http://explainextended.com/2009/08/11/efficient-date-range-q... You can easily extend this map into more dimensions depending in your common use cases and the capability of your DB's spatial library.