Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  com 2532 over 18 years sgarg renaming enum to catalogEnum to prevent compila...
  edu 3052 over 17 years Matt Jones Modifications to the table definitions to add i...
  perl 2994 almost 18 years sgarg added function to get list of projects for NCEA...
  query-client 2824 over 18 years tyburczy Unix port of transform.bat
  spatial 3034 over 17 years perry initial import of changes to metacat source and...
addforeignkeyfortable.sql 135 Bytes 1626 almost 21 years Jing Tao Create a foreign key for table accesssubtree.
alter-datafile-for-knbbackup.sql 1.66 KB 2662 over 18 years Jing Tao Add a new sql file to alter control file which ...
clear.sql 312 Bytes 704 about 23 years berkley added removal of relations
drop-postgres.sql 2.02 KB 2769 over 18 years Matt Jones New SQL tables and db upgrade scripts that defi...
loaddtd.sql 2.36 KB 979 almost 22 years Jing Tao Change every "http://@server@ to "@systemidserv...
loaddtdschema.sql 3.08 KB 3016 over 17 years sgarg Modified the sql commands such that eml-2.0.1 s...
loadschema.sql 476 Bytes 3016 over 17 years sgarg Modified the sql commands such that eml-2.0.1 s...
package-count.sql 373 Bytes 2283 over 19 years Matt Jones Added sql for counting packages.
showdoc.sql 340 Bytes 390 over 23 years Matt Jones Added new utility query to return all of the xm...
sqlcatlist.sql 253 Bytes 123 almost 24 years Matt Jones Modifying storage model to use DOM TEXT nodes
sqldoclist.sql 209 Bytes 531 over 23 years Matt Jones Changed utility query to include the user_owner...
sqlnodeslist.sql 94 Bytes 108 almost 24 years Matt Jones added utility files and queries
sqlnodesview.sql 358 Bytes 166 almost 24 years Matt Jones minor modifications to fix problems introduced ...
sqlrevisions.sql 205 Bytes 203 almost 24 years Matt Jones Merged in substantial changes to DBWriter and a...
upgrade-db-to-1.2-postgres.sql 637 Bytes 2276 over 19 years Matt Jones New schema changes, including upgrade scripts. ...
upgrade-db-to-1.2.sql 596 Bytes 1827 over 20 years Matt Jones Renamed the upgrade sql files to more understan...
upgrade-db-to-1.3-postgres.sql 2.56 KB 2276 over 19 years Matt Jones New schema changes, including upgrade scripts. ...
upgrade-db-to-1.3.sql 1.44 KB 1827 over 20 years Matt Jones Renamed the upgrade sql files to more understan...
upgrade-db-to-1.4-postgres.sql 5.11 KB 2314 over 19 years sgarg Added code that changes the node column size
upgrade-db-to-1.4.sql 4.44 KB 2279 over 19 years Matt Jones Added lines for updating xml_catalog in the upg...
upgrade-db-to-1.5-postgres.sql 6.13 KB 2504 almost 19 years sgarg Making changes in postgres db upgrade script su...
upgrade-db-to-1.5.sql 5.79 KB 2443 almost 19 years sgarg Removed the code which created triggers. Added ...
upgrade-db-to-1.6-postgres.sql 7.64 KB 2969 about 18 years sgarg Removing the comments from postgres upgrade scr...
upgrade-db-to-1.6.sql 9.37 KB 3016 over 17 years sgarg Modified the sql commands such that eml-2.0.1 s...
upgrade-db-to-1.7-postgres.sql 509 Bytes 3052 over 17 years Matt Jones Modifications to the table definitions to add i...
upgrade_db_to_1_5.java 4.83 KB 2504 almost 19 years sgarg Making changes in postgres db upgrade script su...
xmlpackage.sql 1.94 KB 439 over 23 years berkley sql file defining the table structure for eml-p...
xmltables-postgres.sql 17 KB 3052 over 17 years Matt Jones Modifications to the table definitions to add i...
xmltables-sqlserver.sql 11.8 KB 2359 about 19 years sgarg Modified database creation sql code so that in ...
xmltables.sql 19.4 KB 2769 over 18 years Matt Jones New SQL tables and db upgrade scripts that defi...

Latest revisions

# Date Author Comment
3052 09/27/2006 04:21 PM Matt Jones

Modifications to the table definitions to add indices that should be used
when searching the database. Added an upgrade script to create these
indices as well. Modified QueryTerm.java to use the '=' comparator rather
than 'LIKE' so that we can do index scans rather than table scans. This needs...

3051 09/18/2006 04:47 PM perry

fixed point centroid calculation to reflect bboxs that cross the dateline

3050 09/18/2006 04:45 PM perry

fixed point centroid calculation to reflect bboxs that cross the dateline

3048 09/18/2006 12:07 PM perry

Make spatial query more accurate by actually intersecting geometries in addition to a simple bbox filter. Important for testing intersection of irregular shaped objects or multi-geometries

3047 09/18/2006 11:21 AM perry

Added docid override mechanism to DBQuery. Bypasses the queryspec.printSQL method and creates an optimized docid query in cases (like the spatial query) where you know the docids a priori

3045 09/13/2006 04:46 PM perry

Updated spatial query to also look at point spatial cache as some documents may only be represented as a single point.

3044 09/13/2006 04:10 PM perry

Rewrote spatial query handler to use geotools directly against the spatial cache.

3043 09/13/2006 12:24 PM perry

Allow only public readable docs in the spatial cache

3040 09/11/2006 02:22 PM perry

Added javadoc comments for all new spatial classes. Optimized the title query in SpatialDocument.

3039 09/11/2006 12:58 PM perry

Removed old spatial classes

View revisions

Also available in: Atom