Browse Prior Art Database

Method for Relating Retails Sales based on Customer Traffic Patterns. Disclosure Number: IPCOM000015313D
Original Publication Date: 2002-Jan-29
Included in the Prior Art Database: 2003-Jun-20

Publishing Venue



Disclosed is an approach for relating product proximity to product sales within retail environments using extension to DB2* Spatial Extenders. It adds new complex data type to O-R spatial extensions to include time as an attribute. The focus or novelty of this approach is the use of Spatial UDF and a retail spatial reference system to relate product sales to position. We leverage the native Spatial Extender UDFs, as well as, the Spatial mapping of the retail space to allowing clustering and time slicing. Time slicing can be by any use measure of time, day, week(s), months, etc. Clustering can be via an isle, within an isle or including proximal or continuous isles. All of the objects defined can be thought of geometric objects including the time slices, Isle and subIsle geometry as well as the products represented as points. Using this approach one can; (1) Increase product sales by locating co-selling products or clusters of products,