An HDFEOS Data Blade using Informixs Object Relational

An HDF-EOS Data. Blade using Informix’s Object. Relational Database Renu Chaudhry ECOlogic www. ecologic. net

Topics z What is an ORDBMS ? z INFORMIX-Universal Server Architecture z Data. Blade Architecture z HDFEOS Data. Blade Components z HDFEOS Data. Blade Benefits z User Scenario z Summary

What is an ORDBMS ? ORDBMS : Object-Relational Database Management System z OO features y complex data object y data behaviors (functions) y inheritance and overloading z RDBMS features y flexibility, security, transactions, recovery y Native SQL parsing, optimization y data access methods (use of R-tree & B-tree indexes)

INFORMIX-Universal Server Architecture Image Data. Blade Mod ule Spatial Data. Blade API Text Web Extending the server by adding Data. Blades Extensible OR Engine Scaleable Data Manager INFORMIX-Universal Server

Data. Blade Architecture z Routines that act upon the new data types Types Routines z Tables containing new data types Tables z Fast indexing and access for new data types Access Methods z Client API Client Code Data. Blade Module z Data Types to define new information or data structures

HDFEOS Datablade HDF-EOS Datablade components will include: data types: Grid, Swath, Point z. Routines: data inquiry functions, subsetting functions as referred in HDFEOS library Routines z. HDFEOS Tables indexing methods for sorting and storing data z. Tables containing HDF-EOS metadata and data z. Client Access Methods oriented code for data processing Client Code Data. Blade Module z. New Types

HDFEOS Data. Blade Benefits y Access cross granule information via SQL y Easy browsing y Improved performance with use of built-in index y Portability - data and functions packaged inside database server y Ease of integration with other data types INFORMIX-Universal Server Queries Results

HDFEOS User Scenario A user wishes to perform a correlation study between different physical parameters for a specific geographical area. example: Correlation between cloud amount and precipitation z User issues query to view all grid data objects that covers Bermuda. y The query returns all granule names, grid information (names, dimensions, projection, fields etc. ) matching the criteria. z User issues query to retrieve data of interest. y Query returns data of interest

Sample Scenario select Grd. filename, Grd. projection, Grd. dimensions, Fld. fieldname from HEOSgrid Grd, HEOSgdfield Fld where ((Grd. filename = Fld. filename and Grd. objid = Fld. gridid) and Contains(Grd, '(32, 70, 42, 60)');

User Scenario cont’d z Query to retrieve subset of data (“Precip” field) select Lat. Lon. Subset(Fld, '(32, 70, 42, 60)') from HEOSgdfield Fld where Fld. filename = 'pathfinder_flat_month. 8708. psg. hdfeos' and Fld. gridname = ’SSMI' and Fld. fieldname = ’Precip'; z Query to retrieve entire granule y execute HEOSretrv((granulename, outfile , location);

HDFEOS Datablade Summary z Easy access and manipulation of HDF-EOS grid, swath, point data types via SQL 3 z Data and the functions reside inside database for better performance z Structural metadata search across granules by simple SQL z Only SQL knowledge required by novice USERS to access HDFEOS data z Database provides data reliability, security, portability, extensibility, transaction, performance z Datablade provides flexibility to incorporate HDF data objects

HDFEOS User Scenario A user wishes to perform a correlation study between different physical parameters for a specific geographical area. example: Correlation between cloud amount and precipitation z User issues query to view all grid data objects that covers Bermuda. y The query returns all granule names, grid information (names, dimensions, projection, etc. ) matching the criteria. z User issues query to view fieldnames from granules/grids of interest y Query returns fieldnames contained in the grid z User issues query to retrieve data of interest. y Query returns data of interest

Sample Scenario select * from HEOSgrid Grd where Contains(Grd, '(32, 70, 42, 60)');

Scenario - select fields z Query to list all fieldnames contained in the specified grid objects select filename, gridname, fieldname from HEOSgdfield where ((gridname = ‘SSMI’ and filename = ‘xxxx’) and (gridname = ‘Cloud. Amt’ and filename = ‘yyyy’)); OR select filename gridname fieldname

HDF-EOS search queries z To get summary of all filenames, their size and the number of objects in each data file residing in the database: y select orgfile, size, numobj from HEOSfile; z. To retrieve core, product specific, or archive metadata from specific HDF-EOS data file: y select core-metadata, product-metadata from hdfeos where orgfile=‘toms_monthly_498. HEOSfile’;