Project

General

Profile

Statistics
| Revision:

metacat/src @ 3061

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

Latest revisions

# Date Author Comment
3057 10/05/2006 04:47 PM perry

Correctly cache doc title in the spatial cache
3055 10/04/2006 02:44 PM perry

fix to docid overrides to handle an empty result set
3054 09/28/2006 02:21 PM perry

Fixed geometry logic to swap north and south if n < s
3053 09/28/2006 01:13 AM Matt Jones

Reverting to previous QueryTerm.java that uses 'LIKE' for comparisons. This
allows substring matching to work properly, but prevents the postgres index
from being used. As a result, full table scans are done on the tables, causing
a major performance hit. Need to determine how to eliminate the use of LIKE...
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.

View revisions

Also available in: Atom