Abstract: In one embodiment, a system is provided. The system includes a memory device for storing templates; and a processing device, operatively coupled to the memory device, to select a template in view of user input. The template includes one or more embedded data fields associated with a study. A query comprises a tree of operators in view of the embedded data fields is derived. The set of operators being adapted to evaluate events data stored in a longitudinal database. Results corresponding to the query are generated by applying at least one operator of the tree of operators to the events data. The results including a time series of outcomes related to the events data. Thereafter, the template is populated with a least a portion of the results for presentation in connection with the study.

Abstract: In one embodiment, a method is provided. The method comprises receiving a query comprising a time period associated with events data stored in a longitudinal database. Using a processing system, a variable data structure is identified in view of the query. The variable data structure is used to identify attributes associated with the events data from the longitudinal database. A tree of operators is generated to evaluate the events data in view of the variable data structure and the time period. Thereupon, results corresponding to the query are provided by applying at least one operator of the tree of operators to the variable data structure. The results include a time series of outcomes related to the events data.

Abstract: In one embodiment, a method of assembling a longitudinal database is provided. The method comprises receiving, using a processor of a data storage unit, medical data streams from a plurality of sources. The medical data streams include patient data related to a plurality of medical events. A first date range that indicates a time span associated with the patient is identified in view of the patient data. The medical events are normalized into a plurality of linking keys based on the first date range. The keys are adapted to longitudinally link each medical event in a sequence of occurrence. Each key of comprises an offset from a start date of the first date range for a corresponding medical event. The medical events are compressed in view of the keys. The compressing generates a location index for each medical event associated with the keys based on a corresponding offset.