Export Analysis Utility

From CaisisWiki

(Difference between revisions)
Jump to: navigation, search
(Features)
(Features)
Line 20: Line 20:
* Splash Screen. This form opens automatically when you open the Export Analysis Utility. It displays the location of the MDB file and the database your tables are linked to, and it provides buttons to launch each of the following features.
* Splash Screen. This form opens automatically when you open the Export Analysis Utility. It displays the location of the MDB file and the database your tables are linked to, and it provides buttons to launch each of the following features.
* Data Integrity tool. This form is also available in Caisis system admin (Administer the Syste, System Config, Data Integrity). It allows users to browse contents of every table and every field in the MDB file or the linked SQL Server tables in the warehouse. It also allow the user to view lookup codes associated with each field in the database (through Metadata tables) The recode feature is exclusively available through the Caisis system admin tool.
* Data Integrity tool. This form is also available in Caisis system admin (Administer the Syste, System Config, Data Integrity). It allows users to browse contents of every table and every field in the MDB file or the linked SQL Server tables in the warehouse. It also allow the user to view lookup codes associated with each field in the database (through Metadata tables) The recode feature is exclusively available through the Caisis system admin tool.
-
* Nomograms. Links to [http://nomograms.org web nomograms] on [http://www.mskcc.org MSKCC web site]. Also includes functions for calling nomogram library to calculate nomogram predictions for sets of patients in a tables or spreadsheet.
+
* [[Nomograms]]. Links to [http://nomograms.org web nomograms] on [http://www.mskcc.org MSKCC web site]. Also includes functions for calling nomogram library to calculate nomogram predictions for sets of patients in a tables or spreadsheet.
* Tables
* Tables

Revision as of 19:49, 20 December 2007

Translations: italiano


The Export Analysis Utility is a Microsoft Access 2000 (convert to 2003 format?) database that contains many add-on features for Caisis, including.

  • Algorithms for generating analysis datasets for prostate cancer research
  • Longitudinal follow-up process wizard for semi-automated mailouts
  • Data Integrity Tool, a simple browser for looking into every table and field in the database
  • Nomograms, a way to run nomograms on sets of patients
  • Reports, quality assurance, operations and common research reports

Setup Instructions

  • Create a warehouse copy of Caisis on SQL Server
  • Create a Windows security group with permissions to read data on your Caisis SQL Server warehouse
  • Create a secure network folder with read/write permissions for ONLY the few people who will be gatekeepers for the data. These users will be responsible for ensuring that all data requests meet IRB and privacy board requirements and will work with users to generate datasets.
  • Place the Microsoft Access file (MDB file) for the Export Analysis Utility in this secure network folder.
  • From Export Analysis Utility, open the Linked Table Manager (Tools, Database Utilities, Linked Table Manager) to link all tables to the warehouse copy of Caisis on SQL Server.

Features

  • Splash Screen. This form opens automatically when you open the Export Analysis Utility. It displays the location of the MDB file and the database your tables are linked to, and it provides buttons to launch each of the following features.
  • Data Integrity tool. This form is also available in Caisis system admin (Administer the Syste, System Config, Data Integrity). It allows users to browse contents of every table and every field in the MDB file or the linked SQL Server tables in the warehouse. It also allow the user to view lookup codes associated with each field in the database (through Metadata tables) The recode feature is exclusively available through the Caisis system admin tool.
  • Nomograms. Links to web nomograms on MSKCC web site. Also includes functions for calling nomogram library to calculate nomogram predictions for sets of patients in a tables or spreadsheet.
  • Tables
    • DistributableObjects. A list of tables, queries, forms, etc that can be publically distributed. Used when preparing a copy of the Export Analysis Utility to post here on Caisis.org. Does not include user-defined or temporary tables, queries and reports.

TO DO

This is a list of tasks we need to do to prepare the most current version of the Export Analysis Utility for public distribution

  • Data Integrity Tool - compare with colorectal database version
  • Integrate all differences in follow-up process MDB file (UroShared\_CaisisDB\follow up project\CaisisDB.mdb) into Export Analysis Utility
  • With fresh install of Caisis 4.0 from caisis.org download, test setup to be sure no linked tables or steps are MSK-specific.
  • Remove Nomograms code and provide DLL and instructions for using library
    • LifeExpectancies
    • NomogramScores
    • PartinScores_2001
  • Remove Segments code and replace with DLL and instructions?
  • Create feature to export and import algorithm settings so that different users and sites can reproduce analysis datasets using same settings on their own Caisis datasets.
  • Create easy to use feature to export and import user defined queries and reports
Personal tools