Method and system for mapping shelf space

• US 20030033217A1
• Filed: 05/18/2001
• Published: 02/13/2003
• Est. Priority Date: 05/18/2001
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Cutlip, Robert R.
• Application Number:
  US09/860,201
• Publication Number:
  US 20030033217A1
• Time in Patent Office: Days
• US Class Current: 705/27
• CPC Class Codes: G06F 16/29 Geographical information databases
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 30/0601 Electronic shopping [e-shopping]

Abstract

A system for implementing a method for mapping a shelf is disclosed. The system comprises a relational database management system including spatial data types whereby the shelf is established as a geographical entity in terms of a location of the shelf within an isle, a location of the isle within a structure, and a duration of any product on the shelf. The system further comprises a spatial extender access module including user defined functions for accessing the geographical entity.

Claims

1. A method for mapping a product located on a shelf within an isle contained within a structure, said method comprising:

establishing a spatial reference system encompassing the shelf based upon a coordinate reference system encompassing an interior of the structure; and

establishing the shelf as a geographical entity within the spatial reference system in terms of a position of the shelf within the isle, a location of the isle within the structure, and a duration of the product on the shelf.

2. The method of claim 1, further comprising:

establishing a spatial column for storing a set of spatial data corresponding to the geographical entity.

3. The method of claim 2, further comprising:

establishing an attribute column for storing attribute data corresponding to the product located on the shelf.

4. The method of claim 1, further comprising:

establishing a first spatial column for storing a first set of spatial data corresponding to the position of the shelf within the isle and the location of the isle within the structure;

establishing a second spatial column for storing a second set of spatial data corresponding to a duration of the product on the shelf.

5. The method of claim 4, further comprising:

establishing an attribute column for storing attribute data corresponding to the product located on the shelf.

6. A system for mapping a product located on a shelf within an isle contained within a structure, said method comprising:

a computer operable to control an establishment of a spatial reference system encompassing the shelf based upon a coordinate reference system encompassing an interior of the structure, said computer further operable to control an establishment of the shelf as a geographical entity within the spatial reference system in terms of a position of the shelf within the isle, a location of the isle within the structure, and a duration of a product on the shelf; and

a relational database operable to store spatial data corresponding to the geographical entity.

7. The system of claim 6, wherein

said computer is further operable to control an establishment of a spatial column within the relational database for storing the spatial data corresponding to the geographical entity.

8. The system of claim 7, wherein

said computer is further operable to control an establishment of an attribute column within the relational database for storing attribute data corresponding to the product located on the shelf.

9. The system of claim 6, wherein

said computer is further operable to control an establishment of a first spatial column within the relational database for storing a first set of spatial data corresponding to the position of the shelf within the isle and the location of the isle within the structure;

and

said computer is further operable to control an establishment of a second spatial column within the relational database for storing a third set of spatial data corresponding to a duration of any product on the shelf.

10. The system of claim 9, wherein

said computer is further operable to control an establishment of an attribute column within the relational database for storing attribute data corresponding to the product located on the shelf.

11. A computer program product in a computer readable medium for mapping a product located on a shelf within an isle contained within a structure, said computer program product comprising:

computer readable code for establishing a spatial reference system encompassing the shelf based upon a coordinate reference system encompassing an interior of the structure; and

computer readable code for establishing the shelf as a geographical entity within the spatial reference system in terms of a position of the shelf within the isle, a location of the isle within the structure, and a duration of a product on the shelf.

12. The computer program product of claim 11, further comprising:

computer readable code for establishing a spatial column for storing spatial data corresponding to the geographical entity.

13. The computer program product of claim 12, further comprising:

computer readable code for establishing an attribute column within the relational database for storing attribute data corresponding to the product located on the shelf.

14. The computer program product of claim 11, further comprising:

computer readable code for establishing a first spatial column for storing a first set of spatial data corresponding to the position of the shelf within the isle and the location of the isle within the structure; and

computer readable code for establishing a second spatial column for storing a second set of spatial data corresponding to a duration of any product on the shelf.

15. The computer program product of claim 14, further comprising:

computer readable code for establishing an attribute column within the relational database for storing attribute data corresponding to the product located on the shelf.

16. A method for mapping a shelf within an isle contained within a structure, said method comprising:

establishing a spatial reference system encompassing the shelf based upon a coordinate reference system encompassing an interior of the structure; and

establishing the shelf as a geographical entity within the spatial reference system in terms of a position of the shelf within the isle, and a location of the isle within the structure.

17. The method of claim 16, further comprising:

establishing a spatial column for storing a set of spatial data corresponding to the geographical entity.

18. The method of claim 16, further comprising:

establishing a first spatial column for storing a first set of spatial data corresponding to the position of the shelf within the isle and the location of the isle within the structure;

establishing a second spatial column for storing a second set of spatial data corresponding to a duration of the product on the shelf.

19. A system for mapping a shelf within an isle contained within a structure, said method comprising:

a computer operable to control an establishment of a spatial reference system encompassing the shelf based upon a coordinate reference system encompassing an interior of the structure, said computer further operable to control an establishment of the shelf as a geographical entity within the spatial reference system in terms of a position of the shelf within the isle and a location of the isle within the structure; and

a relational database operable to store spatial data corresponding to the geographical entity.

20. The system of claim 19, wherein

said computer is further operable to control an establishment of a spatial column within the relational database for storing the spatial data corresponding to the geographical entity.

21. The system of claim 19, wherein

said computer is further operable to control an establishment of a first spatial column within the relational database for storing a first set of spatial data corresponding to the position of the shelf within the isle and the location of the isle within the structure;

and

said computer is further operable to control an establishment of a second spatial column within the relational database for storing a third set of spatial data corresponding to a duration of any product on the shelf.

22. A computer program product in a computer readable medium for mapping a shelf within an isle contained within a structure, said computer program product comprising:

computer readable code for establishing a spatial reference system encompassing the shelf based upon a coordinate reference system encompassing an interior of the structure; and

computer readable code for establishing the shelf as a geographical entity within the spatial reference system in terms of a position of the shelf within the isle and a location of the isle within the structure.

23. The computer program product of claim 22, further comprising:

computer readable code for establishing a spatial column for storing spatial data corresponding to the geographical entity.

24. The computer program product of claim 22, further comprising:

computer readable code for establishing a first spatial column for storing a first set of spatial data corresponding to the position of the shelf within the isle and the location of the isle within the structure; and

computer readable code for establishing a second spatial column for storing a second set of spatial data corresponding to a duration of any product on the shelf.