Release Management
Space shortcuts
Space Tools

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Community-Contributed Features

Contribution

Contributor


ACT Ontology

ACT Technology and Data Harmonization Team

University of Pittsburgh

Easier-to-read counts

Nick Brown and Griffin Weber

Beth Israel Deaconess Medical Center

Extended query-by-value flags

Robert Bradford

University of North Carolina

Totalnum in find terms

Mauro Bucalo

University of Pavia

Visual Design of new Find Terms

Leaf Team

University of Washington

Totalnum Counter for Postgres

Dan Vianello

Center for Biomedical Informatics, Washington University in St. Louis

(Part of overall totalnum scripts in this release.)

...

  1. In the Release_1-7/NewInstall/Metadata/ run the ant script to create the stored procedures.
    1. POSTGRESQL : ant -f data_build.xml db_metadata_run_total_count_postgresql
    2. ORACLE : ant -f data_build.xml db_metadata_run_total_count_oracle
    3. SQL SERVER : ant -f data_build.xml db_metadata_run_total_count_sqlserver
  2. Execute the RunTotalNum stored procedure on your database. This can take several hours.
  3. When finished, verify it is complete by checking that c_totalnum columns in your ontology tables contain numbers (not nulls). These total counts will be visible in the ontology browser in the web client.

ACT Ontology Setup
Anchor
act-

...

ontolog
act-

...

ontolog

  1. In the Release_1-7/NewInstall/Metadata/db.properties file change the db.project from demo to act.
  2. Run the ant script against create_metadata_tables_release_1-7 and db_metadata_load_data

...