Managing Attribute-Value Clinical Trials Data Using the ACT/DB Client-Server Database System
P. Nadkarni, Cynthia Brandt, Sandra J. Frawley et al. · Journal of the American Medical Informatics Association · 1998
ACT/DB is a client-server database application for storing clinical trials and outcomes data, which is currently undergoing initial pilot use. It stores most of its data in entity-attribute-value form. Such data are segregated according to data type to allow indexing by value when possible, and binary large object data are managed in the same way as other data. ACT/DB lets an investigator design a study rapidly by defining the parameters (or attributes) that are to be gathered, as well as their logical grouping for purposes of display and data entry. ACT/DB generates customizable data entry. The data can be viewed through several standard reports as well as exported as text to external analysis programs. ACT/DB is designed to encourage reuse of parameters across multiple studies and has facilities for dictionary search and maintenance. It uses a Microsoft Access client running on Windows 95 machines, which communicates with an Oracle server running on a UNIX platform. ACT/DB is being used to manage the data for seven studies in its initial deployment.
Cited by 98 works. doi:10.1136/jamia.1998.0050139 Open-access PDF
Authors
- P. Nadkarni
- Cynthia Brandt
- Sandra J. Frawley
- Frederick G. Sayward
- R. Einbinder
- Daniel A. Zelterman
- Lee Schacter
- Perry L. Miller
References
- SQLGEN: A framework for rapid client-server database application development
- Understanding the New SQL: A Complete Guide
- Multi-table joins through bitmapped join indices
- Large Trials vs Meta-analysis of Smaller Trials
- Knowledge-based Approaches to the Maintenance of a Large Controlled Medical Terminology
- A Generalized Relational Schema for an Integrated Clinical Patient Database
- A Logical Foundation for Representation of Clinical Data
- HELP the next generation: a new client-server architecture.
- Using Metadata to Integrate Medical Knowledge in a Clinical Information System
- TSQL2 language specification