Georaster physical data model for storing georeferenced raster data

• US 7,177,882 B2
• Filed: 03/16/2004
• Issued: 02/13/2007
• Est. Priority Date: 09/05/2003
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation), Whirlpool Corporation
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Ravada, Siva, Xu, Weisheng, Xie, Qingyun
• Primary Examiner(s): Cottingham; John
• Assistant Examiner(s): Lu; Kuen S.
• Application Number:
  US10/800,739
• Publication Number:
  US 20050055376A1
• Time in Patent Office: 1,064 Days
• Field of Search: 707/104.1, 707/102
• US Class Current: 1/1
• CPC Class Codes: G06F 16/29 Geographical information databases
• CPC Class Codes: G06F 16/50 of still image data
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

Abstract

In one embodiment of the present invention, in a database management system, a system for handling geographic raster data comprises a first data table including a plurality of GeoRaster objects, each GeoRaster object including a spatial extent geometry and associated metadata, the spatial extent geometry identifying a footprint of a geographic raster data object and associated with at least one block of raster data, a second data table including a plurality of raster objects, each raster object associated with one block of raster data of a GeoRaster object and including information indicating a spatial extent of the block of raster data and information relating to the block of raster data, a first spatial index built on the first data table based on the spatial extent geometry of each of the plurality of GeoRaster objects, the first spatial index operable to retrieve a GeoRaster object from the first data table based on a relative spatial location of the GeoRaster object, and a primary key index built on the second data table based on the information relating to the block of raster data, the index operable to retrieve a raster object from the second data table based on the information relating to the block of raster data associated with the retrieved raster object.

Claims

1. In a database management system, a system for handling geographic raster data comprising:

a first data table including a plurality of GeoRaster objects, each GeoRaster object including a spatial extent geometry and associated metadata, the spatial extent geometry identifying a footprint of a geographic raster data object and associated with at least one block of raster data;

a second data table including a plurality of raster objects, each raster object associated with one block of raster data of a GeoRaster object and including information indicating a spatial extent of the block of raster data and information relating to the block of raster data;

a first spatial index built on the first data table based on the spatial extent geometry of each of the plurality of GeoRaster objects, the first spatial index operable to retrieve a GeoRaster object from the first data table based on a relative spatial location of the GeoRaster object;

a primary key index built on the second data table based on the information relating to the block of raster data, the index operable to retrieve a raster object from the second data table based on the information relating to the block of raster data associated with the retrieved raster object; and

a viewer operable to display at least a GeoRaster object.

2. The system of claim 1, wherein each GeoRaster object further comprises raster type information indicating a number of spatial dimensions of the GeoRaster object and band or layer information of the GeoRaster object.

3. The system of claim 2, wherein each GeoRaster object further comprises information identifying the second data table for each block of raster data in the GeoRaster object.

4. The system of claim 3, wherein each GeoRaster object further comprises information identifying a raster object in the second data table for each block of raster data in the GeoRaster object.

5. The system of claim 4, wherein each raster object further comprises information matching information identifying a raster object in the second data table in a GeoRaster object.

6. The system of claim 5, wherein each raster object further comprises information indicating a resolution of raster data associated with the raster object.

7. The system of claim 6, wherein each raster object further comprises information identifying a block of raster data associated with the raster object.

8. The system of claim 7, wherein the associated metadata comprises object metadata including object description information and object version information, raster metadata including cell depth information, dimensionality information, blocking information, and interleaving information.

9. The system of claim 8, wherein the associated metadata further comprises spatial reference system information relating to a polynomial transformation for georeferencing.

10. The system of claim 9, wherein the polynomial transformation is an affine transformation.

11. The system of claim 10, wherein the associated metadata further comprises information relating to layers in a GeoRaster object.

12. The system of claim 11, wherein the associated metadata further comprises image/cell attribution information, scaling factor information, color related information, and layer-based attribute information for each layer.

13. The system of claim 12, wherein the first spatial index comprises an R-Tree index.

14. The system of claim 13, wherein the second index comprises a B-Tree index.

15. The system of claim 1, further comprising:

a second spatial index built on the second data table based on the information indicating a spatial extent of the block of raster data of each of the plurality of raster data objects, the second spatial index operable to retrieve a raster object from the second data table based on a relative spatial location of a block of raster data associated with the retrieved raster object.

16. The system of claim 15, wherein the second spatial index comprises a R-Tree index.

17. The system of claim 15, further comprising a trigger operable to perform an action after a data manipulation language operation affecting a GeoRaster object.

18. The system of claim 17, wherein the data manipulation language operation comprises at least one of inserting a row, updating the GeoRaster object, and deleting a row.

19. The system of claim 15, further comprising a system data table operable to maintain a relationship between the first data table and the second data table.

20. The system of claim 19, further comprising a trigger operable to maintain the system data table and GeoRaster object integrity after a data definition language operation is performed on the first data table.

21. The system of claim 20, wherein the data definition language operation comprises at least one of a drop operation and a truncate operation.

22. In a database management system, a computer-implemented method of workflow for handling geographic raster data comprising the steps of:

creating, initializing, and validating a first data table including a plurality of GeoRaster objects, each GeoRaster object including a spatial extent geometry and associated metadata, the spatial extent geometry identifying a footprint of a geographic raster data object and associated with at least one block of raster data;

creating a second data table including a plurality of raster objects, each raster object associated with one block of raster data of a GeoRaster object and including information indicating a spatial extent of the block of raster data and information relating to the block of raster data;

creating a first spatial index built on the first data table based on the spatial extent geometry of each of the plurality of GeoRaster objects, the first spatial index operable to retrieve a GeoRaster object from the first data table based on a relative spatial location of the Geo Raster object;

creating a primary key index built on the second data table based on the information relating to the block of raster data, the index operable to retrieve a raster object from the second data table based on the information relating to the block of raster data associated with the retrieved raster object; and

displaying at least a GeoRaster object.

23. The method of claim 22, wherein each GeoRaster object further comprises raster type information indicating a number of spatial dimensions of the GeoRaster object and band or layer information of the GeoRaster object.

24. The method of claim 23, wherein each GeoRaster object further comprises information identifying the second data table for each block of raster data in the GeoRaster object.

25. The method of claim 24, wherein each GeoRaster object further comprises information identifying a raster object in the second data table for each block of raster data in the GeoRaster object.

26. The method of claim 25, wherein each raster object further comprises information matching information identifying a raster object in the second data table in a GeoRaster object.

27. The method of claim 26, wherein each raster object further comprises information indicating a resolution of raster data associated with the raster object.

28. The method of claim 27, wherein each raster object further comprises information identifying a block of raster data associated with the raster object.

29. The method of claim 28, further comprising the step of:

changing a format of the first data table.

30. The method of claim 28, further comprising the step of:

querying and/or updating metadata associated with a GeoRaster object.

31. The method of claim 28, further comprising the step of:

processing at least some of the plurality of GeoRaster objects.

32. The method of claim 28, further comprising the step of:

exporting at least some of the plurality of GeoRaster objects.

33. The method of claim 28, further comprising the step of:

viewing at least some of the plurality of GeoRaster objects.

34. The method of claim 24, further comprising the step of:

creating a second spatial index built on the second data table based on the information indicating a spatial extent of the block of raster data of each of the plurality of raster data objects, the second spatial index operable to retrieve a raster object from the second data table based on a relative spatial location of a block of raster data associated with the retrieved raster object.

35. The method of claim 34, wherein the second spatial index comprises a R-Tree index.

36. The method of claim 34, further comprising operating a trigger to perform an action after a data manipulation language operation affecting a GeoRaster object.

37. The method of claim 36, wherein the data manipulation language operation comprises at least one of inserting a row, updating the GeoRaster object, and deleting a row.

38. The method of claim 34, further comprising creating a system data table operable to maintain a relationship between the first data table and the second data table.

39. The method of claim 38, further comprising operating a trigger to maintain the system data table and GeoRaster object integrity after a data definition language operation is performed on the first data table.

40. The method of claim 39, wherein the data definition language operation comprises at least one of a drop operation and a truncate operation.