Author: mattmann
Date: Sun Jun 5 04:13:54 2011
New Revision: 1131651
URL: http://svn.apache.org/viewvc?rev=1131651&view=rev
Log:
- fix for OODT-162 Parametric Data Model File Manager Catalog
Added:
oodt/trunk/filemgr/src/main/resources/sdschema.sql
Modified:
oodt/trunk/filemgr/src/main/resources/filemgr.properties
Modified: oodt/trunk/filemgr/src/main/resources/filemgr.properties
URL:
http://svn.apache.org/viewvc/oodt/trunk/filemgr/src/main/resources/filemgr.properties?rev=1131651&r1=1131650&r2=1131651&view=diff
==============================================================================
--- oodt/trunk/filemgr/src/main/resources/filemgr.properties (original)
+++ oodt/trunk/filemgr/src/main/resources/filemgr.properties Sun Jun 5
04:13:54 2011
@@ -45,6 +45,12 @@ org.apache.oodt.cas.filemgr.catalog.data
# mapped data source catalog configuration
org.apache.oodt.cas.filemgr.catalog.mappeddatasource.mapFile=/path/to/ops.catalog.typemap.properties
+# science data catalog configuration
+org.apache.oodt.cas.filemgr.catalog.science.jdbc.url=some_jdbc_url
+org.apache.oodt.cas.filemgr.catalog.science.jdbc.user=user
+org.apache.oodt.cas.filemgr.catalog.science.jdbc.pass=pass
+org.apache.oodt.cas.filemgr.catalog.science.jdbc.driver=driver.class.name
+
# lucene catalog configuration
org.apache.oodt.cas.filemgr.catalog.lucene.idxPath=/path/to/your/lucene/index
org.apache.oodt.cas.filemgr.catalog.lucene.pageSize=20
@@ -58,6 +64,12 @@ org.apache.oodt.cas.filemgr.repositorymg
org.apache.oodt.cas.filemgr.repositorymgr.datasource.jdbc.pass=pass
org.apache.oodt.cas.filemgr.repositorymgr.datasource.jdbc.driver=driver.class.name
+# science data repository manager configuration
+org.apache.oodt.cas.filemgr.repositorymgr.science.jdbc.url=some_jdbc_url
+org.apache.oodt.cas.filemgr.repositorymgr.science.jdbc.user=user
+org.apache.oodt.cas.filemgr.repositorymgr.science.jdbc.pass=pass
+org.apache.oodt.cas.filemgr.repositorymgr.science.jdbc.driver=driver.class.name
+
# XML repository manager configuration
org.apache.oodt.cas.filemgr.repositorymgr.dirs=file:///dir1,file:///dir2
@@ -71,6 +83,12 @@ org.apache.oodt.cas.filemgr.validation.d
org.apache.oodt.cas.filemgr.validation.datasource.jdbc.driver=driver.class.name
org.apache.oodt.cas.filemgr.validation.datasource.quoteFields=false
+# science data validation layer configuration
+org.apache.oodt.cas.filemgr.validation.science.jdbc.url=some_jdbc_url
+org.apache.oodt.cas.filemgr.validation.science.jdbc.user=user
+org.apache.oodt.cas.filemgr.validation.science.jdbc.pass=pass
+org.apache.oodt.cas.filemgr.validation.science.jdbc.driver=driver.class.name
+
# remote data transfer configuration
org.apache.oodt.cas.filemgr.datatransfer.remote.chunkSize=1024
Added: oodt/trunk/filemgr/src/main/resources/sdschema.sql
URL:
http://svn.apache.org/viewvc/oodt/trunk/filemgr/src/main/resources/sdschema.sql?rev=1131651&view=auto
==============================================================================
--- oodt/trunk/filemgr/src/main/resources/sdschema.sql (added)
+++ oodt/trunk/filemgr/src/main/resources/sdschema.sql Sun Jun 5 04:13:54 2011
@@ -0,0 +1,70 @@
+--
+-- Table structure for table `dataPoint`
+--
+
+CREATE TABLE `dataPoint` (
+ `dataPoint_id` int(10) unsigned NOT NULL auto_increment,
+ `granule_id` int(10) unsigned NOT NULL,
+ `dataset_id` int(10) unsigned NOT NULL,
+ `parameter_id` int(10) unsigned NOT NULL,
+ `time` datetime default NULL,
+ `latitude` double default NULL,
+ `longitude` double default NULL,
+ `vertical` double default NULL,
+ `value` double default NULL,
+ PRIMARY KEY (`dataPoint_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=1143297 DEFAULT CHARSET=latin1;
+
+--
+-- Table structure for table `dataset`
+--
+
+CREATE TABLE `dataset` (
+ `dataset_id` int(10) unsigned NOT NULL auto_increment,
+ `longName` varchar(120) default NULL,
+ `shortName` varchar(60) default NULL,
+ `description` text,
+ `source` varchar(255) default NULL,
+ `referenceURL` varchar(255) default NULL,
+ PRIMARY KEY (`dataset_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
+
+--
+-- Table structure for table `dpMap`
+--
+
+CREATE TABLE `dpMap` (
+ `dataset_id` int(10) unsigned NOT NULL,
+ `parameter_id` int(10) unsigned NOT NULL,
+ PRIMARY KEY (`dataset_id`,`parameter_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+--
+-- Table structure for table `granule`
+--
+CREATE TABLE `granule` (
+ `granule_id` int(10) unsigned NOT NULL auto_increment,
+ `dataset_id` int(10) unsigned default NULL,
+ `filename` varchar(255) NOT NULL,
+ PRIMARY KEY (`granule_id`),
+ KEY `dataset_id` (`dataset_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
+
+--
+-- Table structure for table `parameter`
+--
+
+CREATE TABLE `parameter` (
+ `parameter_id` int(10) unsigned NOT NULL auto_increment,
+ `longName` varchar(120) default NULL,
+ `shortName` varchar(60) default NULL,
+ `description` text,
+ `referenceURL` varchar(255) default NULL,
+ `cellMethod` text,
+ `missingDataFlag` float default NULL,
+ `units` varchar(60) default NULL,
+ `verticalUnits` varchar(120) default NULL,
+ `database` varchar(80) NOT NULL,
+ `dataset_id` int(10) unsigned NOT NULL,
+ PRIMARY KEY (`parameter_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;
