Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  pipeline 13074 almost 11 years Aaron Marcuse-Kubitza validation/aggregating/pipeline/validations_on_...
  plots 13061 almost 11 years Aaron Marcuse-Kubitza validation/aggregating/**.sql output queries: u...
  specimens 13083 almost 11 years Aaron Marcuse-Kubitza validation/aggregating/specimens/qualitative_va...
  traits 13061 almost 11 years Aaron Marcuse-Kubitza validation/aggregating/**.sql output queries: u...

Latest revisions

# Date Author Comment
13083 04/09/2014 02:48 PM Aaron Marcuse-Kubitza

validation/aggregating/specimens/qualitative_validations_specimens.sql: removed `public.` prefix to avoid cluttering up the SQL

13082 04/09/2014 02:46 PM Aaron Marcuse-Kubitza

bugfix: schemas/vegbien.sql, validation/aggregating/specimens/qualitative_validations_specimens.sql: _specimens_10_count_number_of_records_by_institution: need to dereference specimenreplicate.duplicate_institutions_sourcelist_id to the corresponding sourcelist.name

13080 04/09/2014 02:25 PM Aaron Marcuse-Kubitza

validation/aggregating/specimens/qualitative_validations_specimens.sql: synced to schemas/vegbien.sql so that it can be diffed with it to sync qualitative_validations_specimens.sql to the DB

13074 04/08/2014 02:55 PM Aaron Marcuse-Kubitza

validation/aggregating/pipeline/validations_on_sparse_datasources.odg: not applicable "✓": increased font size so the size of the character matches the surrounding text

13073 04/08/2014 02:52 PM Aaron Marcuse-Kubitza

validation/aggregating/pipeline/validations_on_sparse_datasources.odg: removed = lines for each input query, because they clutter up the diagram and the "same, so don't need to rewrite" message now shows this as well

13072 04/08/2014 02:50 PM Aaron Marcuse-Kubitza

validation/aggregating/pipeline/validations_on_sparse_datasources.odg: added the denormalized VegCore schema approach for comparison, as requested by Mark

13064 04/07/2014 06:09 PM Aaron Marcuse-Kubitza

validation/aggregating/specimens/qualitative_validations_specimens.sql: removed DDL statements, using the steps at wiki.vegpath.org/Aggregating_validations_refactoring#remove-DDL-statements

13062 04/07/2014 05:51 PM Aaron Marcuse-Kubitza

validation/aggregating/specimens/qualitative_validations_specimens.sql: parameterize queries by datasource

13061 04/07/2014 05:35 PM Aaron Marcuse-Kubitza

validation/aggregating/**.sql output queries: use `SET join_collapse_limit = 1;` to match public_validations.rematerialize_out_view()

13059 04/07/2014 04:35 PM Aaron Marcuse-Kubitza

validation/aggregating/specimens/qualitative_validations_specimens.sql: _specimens_12_distinct_collector_name_collect_num_date_w_count: turn off join_collapse_limit instead of enable_mergejoin/enable_hashjoin, because join_collapse_limit is something that we will eventually want to turn off for all queries, which would avoid this query needing special handling. (on the other hand, enable_mergejoin/enable_hashjoin may be necessary for some queries and we probably won't turn them off for all queries.)

View revisions

Also available in: Atom