Activity

30 days up to

User

Activity

From 09/12/2006 to 10/11/2006

09/28/2006

02:21 PM Revision 3054 (metacat): Fixed geometry logic to swap north and south if n < s: perry
10:04 AM Bug #2155: Metacat Performace: Rewrite the xml_nodes queries: Following query can be used to replace the first IN clause
select distinct a.docid, a.docname, a.doctype, a.date_cr... Saurabh Garg
08:51 AM Bug #2155: Metacat Performace: Rewrite the xml_nodes queries: Just changing the 'LIKE' operator to the '=' operator allows the optimizer to use indices if they exist. Unfortunate... Matt Jones
09:11 AM Bug #2557 (Resolved): Metacat Performace: Rewrite the xml_access part of the query: The subpart of metacat search queries that does an access control check is inefficient. It first checks the user_owne... Matt Jones
08:40 AM Bug #1879: Metacat Performance: Summary: The growth of Metacat's document store has eroded the performance gains we made previously. We are now back to havin... Matt Jones
01:13 AM Revision 3053 (metacat): 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... Matt Jones

09/27/2006

04:21 PM Revision 3052 (metacat): 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... Matt Jones
10:08 AM Bug #192: create a dtd for result sets: CLOSED. Matt Jones
10:08 AM Bug #192: create a dtd for result sets: Closing because we do not intend to provide a resultset DTD -- we will be slowly moving to the more expressive and be... Matt Jones
08:27 AM Bug #2228: Use method other than metadata string filters for determining the organizations affiliationed with a data package: (In reply to comment #2)
> Another possible solution is to specify an attribute in the organization tag
> which speci... Will Tyburczy
07:21 AM Bug #2228: Use method other than metadata string filters for determining the organizations affiliationed with a data package: Another possible solution is to specify an attribute in the organization tag which specifies if the document belongs... Saurabh Garg
08:12 AM Bug #1296: Registry: Need to login before the form is filled: This functionality is already implemented for ESA skin and should be extended to all the other skins. So these are m... Saurabh Garg
08:01 AM Bug #2495: Charset bug: Internationalization: The new relase has broken the code incorporated by the team of Mr. Chau Chin Lin. I have told them that they are welc... Saurabh Garg
07:31 AM Bug #2310: Advanced search functionality has to be integrated into various skins.: there is some advanced search capabilities in lter skin also. those are a potential candidate for advanced functiona... Saurabh Garg
07:28 AM Bug #2229: Allowing web registry pull-down menu for "Station Name" to select multiple stations: This has been discussed before. We can have two drop down boxes with add and remove buttons in between. So the user ... Saurabh Garg
06:55 AM Bug #2159: Metacat Performance: Divide xml_nodes based on the doctype: This approach might be worth considering but I think it will only give short term benefits if at all any benefits. T... Saurabh Garg
06:50 AM Bug #2157: Metacat Performance: Optimize Postgres and Tomcat...: The current RAM specified for Tomat and Postgres in KNB:
Tomcat: 500 MB
Postgres: 760 MB
Saurabh Garg
06:49 AM Bug #2155: Metacat Performace: Rewrite the xml_nodes queries: IN clause is not so efficient. I was able to improve performance by using outer joins instead of IN to improve perfo... Saurabh Garg
06:40 AM Bug #1980: Duplication when displaying catalog of data packages: Not able to reproduce this bug. Might already be fixed. Saurabh Garg
06:35 AM Bug #1674: Access control for eml-2.1.0 documents: Eml210SAXHandler.java is a copy of Eml200SAXHandler.java and this is the file which needs to be modified. I think cod... Saurabh Garg
06:34 AM Bug #1601: Metacat will add default value for optional parameter into eml 2 document: We need to checkout the newer versions of Xerces and see if the newer version provides an option to avoid entering o... Saurabh Garg
06:16 AM Bug #2380: returnfield system needs to implement more xpath: If I understand the bug correctly, then this functionality is already present in
src/edu/ucsb/nceas/metacat/QuerySpe... Saurabh Garg
05:54 AM Bug #2153: Metacat Performace: Add/drop indices on key columns: For each of the queries, EXPLAIN needs to be done. I have noticed that for some of the queries, full table scan is b... Saurabh Garg
05:50 AM Bug #1542: SQL Server support broken: Here are the files which need to be updated:
1. src/xmltables-sqlserver.sql
2. src/upgrade-db-to-1.2.sql
3. src/upgr... Saurabh Garg

09/18/2006

04:49 PM Bug #2550: Dateline and polar handling for points: revision 1.4 on SpatialDocument should fix this. Centroids are now calculated correctly for these cases. Matthew Perry
04:47 PM Revision 3051 (metacat): fixed point centroid calculation to reflect bboxs that cross the dateline: perry
04:45 PM Revision 3050 (metacat): fixed point centroid calculation to reflect bboxs that cross the dateline: perry
01:01 PM Revision 3049 (metacat): Fixed up some hardcoded paths in html map templates.: perry
12:07 PM Revision 3048 (metacat): 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: perry
11:21 AM Revision 3047 (metacat): 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: perry
10:18 AM Revision 3046 (metacat): updated SpecNet Home link to http://www.specnet.info: bowdish

09/15/2006

11:27 AM Bug #1232: cookie needs to be written after knb page login: The session information is not maintained by the skin for some reason. So the JSP part knows that is in session but ... Saurabh Garg
11:24 AM Bug #129: Metacat Performance: paged Query Returns: The query will probably to be stored on per session basis. Maybe the docids found can be stored in a ordered data st... Saurabh Garg

09/13/2006

05:09 PM Bug #2549: Limit spatial cache to public documents: Changed severity to 'major' .. mostly because its already fixed and I don't like seeing bold red text in my bug list! Matthew Perry
12:23 PM Bug #2549: Limit spatial cache to public documents: Updated SpatialHarvester.queryAllDocids(). Now uses the xml_access table to generate a list of public-readable docids... Matthew Perry
05:07 PM Bug #2553: squery needs to handle spatial query: Oops that should be assigned to me. Sorry sid :-p
The performance issue discussed in the comments of bug 2552 shoul... Matthew Perry
05:03 PM Bug #2552: Spatial query class to use geotools against the spatial cache: Added a edu.ucsb.nceas.metacat.spatial.SpatialQuery class to handle this. Given a spatial query (4 bounding cooordina... Matthew Perry
04:46 PM Revision 3045 (metacat): Updated spatial query to also look at point spatial cache as some documents may only be represented as a single point.: perry
04:10 PM Revision 3044 (metacat): Rewrote spatial query handler to use geotools directly against the spatial cache.: perry
12:33 PM Bug #2554 (Resolved): Store the spatial data cache outside servlet context: Currently the spatial data cache is stored within the servlet context. Geoserver's configuration hardcodes the shapef... Matthew Perry
12:24 PM Revision 3043 (metacat): Allow only public readable docs in the spatial cache: perry
11:20 AM Revision 3042 (metacat): Remove geoserver error pages from web.xml and allow exceptions to pass through: perry

Also available in: Atom

Project

General

Profile

Metacat

Activity

Activity

10/10/2006

10/05/2006

10/04/2006

09/28/2006

09/27/2006

09/18/2006

09/15/2006

09/13/2006