Systems, methods, and other embodiments associated with a data view for clinical data are described. In one embodiment, a method includes receiving a request from a user to view summarized case report form (CRF) data, where the CRF data corresponds to a plurality case report forms (CRFs) stored in one or more normalized transactional tables. A view query is constructed based, at least in part, on the request and executed on one or more denormalized summary tables to construct a view. The denormalized summary tables store selected CRF data from the normalized transactional tables and are updated concurrently with each update to the transactional tables. The method includes rendering the view for display.
展开▼
