Patent ID: 9558231
Date: 2017-01-31
CPC Classifications: G06F,G06Q

Claim:
1. A non-transitory computer-readable medium storing computer-executable instructions that when executed by a computer cause the computer to: generate and store one or more denormalized summary tables that are denormalized versions of one or more normalized transactional tables, wherein the one or more normalized transactional data tables store a plurality of records corresponding to case report forms (CRFs) stored by a CRF processing server that processes CRF data; receive a request from a user to view case report form (CRF) data that is summarized; construct a view query based, at least in part, on the request; execute the view query on the one or more denormalized summary tables to construct a summary table view that includes denormalized data from the one or more denormalized summary tables; render the summary table view for display to the user in a first user interface display; provide access to the one or more normalized transactional data tables via the first user interface display, wherein both the display of the summary table view including the denormalized data and the access to the normalized transactional data tables occur in the same first user interface display; in response to receiving via the first user interface display an access request including a form action command that specifies at least one form action and a target CRF: