Demonstration and Review of Metaclinic System

Basis Software

Oracle, Apache, nod_perl (increases speed by maintaining Perl in memory), Javascript

Features and Pros

  • Metaclinic is organized around applications, forms, sections, data elements. The major tools included are Design, admin, import/export, access control tools. Access control to individual forms. The system is strong on repeating data types.
  • Oracle Enterprise Manager is used to add users and change their permissions and other information.
  • The database is populated with many meta tables including a table for system defaults.
  • Dynamic html generated by Perl. There is a large table of default field formats. To change field characteristics, use Admin Tool to edit a table containing header, display attributes, order, etc., for form sections. Generates nice default html for data entry, and generates SQL field instantiations.
  • Metadata for field form entry characteristics can include any html markups and Javascript functions to invoke
  • Easy to edit field and value label presentation order, default values
  • Save an old table and edit to create a new table, easy to compare field characteristics for comparing table structures, to catch errors. Nice table layout for code levels with a column specifying which level is the default, and a column with the display order.
  • Point and click report generation with hyperlinks from output back to source data.
  • Uses generic SQL, handles date strings, etc. in Perl for generality (as of now implements Oracle and Access back ends)
  • Javascript can make read-only fields e.g. age once birthdate entered. Javascript can catch errors as they are entered. Summary at bottom of forms showing who, when record was entered.
  • Easy deletion of elements of repeated fields after data entry (by blanking out a required field)
  • Value labels can be re-used by other fields
  • As all metadata are in standard SQL tables, export of metadata for annotating analysis files is straightforward


  • Each configuration has to have a unique configuration; need to edit Apache config files
  • A GUI admin tool similar to phpmysqladmin would make administration of the system more user-friendly.
  • No audit trail other than original person who entered and last person who updated a record
  • No separate units of measurement attribute for numeric fields
  • Can use sections of forms from other projects but these must be semi-manually copied; there is no sections repository as in Oncore
  • Coded fields use internal numeric coding that is a function of other fields' codings, so you can't query coded fields across different databases
  • Code lists (value labels) can be exported though not in a single table


Metaclinic has a very well laid-out modular design with excellent response time. Hierarchical organization of forms, subforms, and data elements in metadata is very logical. The system is expected to function well when users are coupled with high-level database administrators. The system currently is not easy enough to use by mid-level database managers (e.g. research nurses with clinical data management experience) to allow them full access for defining or changing the structure of the database (consideration could be given to developing a team for new projects that includes at least one high-level data manager per group of projects). The metadata behind the system is well organized and clear. Consideration should be given to whether a scripting language could generate the metadata faster than entering it into tables, especially when hundreds of fields need to be defined for a new project.
Edit | Attach | Print version | History: r3 < r2 < r1 | Backlinks | View wiki text | Edit WikiText | More topic actions...
Topic revision: r1 - 29 Apr 2004, FrankHarrell

This site is powered by FoswikiCopyright © 2013-2022 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding Vanderbilt Biostatistics Wiki? Send feedback