Related Experiment Video
Updated: Sep 10, 2026

Executing Complexity-Increasing Queries in Relational (MySQL) and NoSQL (MongoDB and EXist) Size-Growing ISO/EN 13606 Standardized EHR Databases
Published on: March 19, 2018
Extended relational operators for statistical data manipulations in medical databases
1Department of Computer Engineering and Science, Case Western Reserve University, Cleveland, Ohio 44106.
Abstract:
Conventional relational database management systems fail to address three features of statistical data management in a biomedical/clinical database, namely, that (1) statistical and medical data (SMD) require a great deal of space and need to be stored in a reduced form with minimal duplication; indeed, SMD have many derived/calculated and summary statistics that make the number of attributes in a relation (i.e., a set of records) grow rapidly and dynamically; (2) most SMD have hierarchical structures that are difficult to manage using the relational data model since SMD are stored in separate relations for duplication and space considerations; and (3) the management of SMD is made easier if it is possible to reorganize relations or group data, a capability lacking in conventional relational database management systems. In this paper, we (1) introduce five extended relational operators, (lattice) NEST, (lattice) UNNEST, MERGE, SPREAD, and GEN, to reorganize relations; (2) integrate the extended operators with conventional relational algebra and introduce the concept of the lattice relational model; and (3) give applications of the extended relational operators and the lattice relational model in solving the problems of statistical data manipulation in medical databases.
More Related Videos
06:55Inverse Probability of Treatment Weighting (Propensity Score) using the Military Health System Data Repository and National Death Index
Published on: January 8, 2020
09:43Databases to Efficiently Manage Medium Sized, Low Velocity, Multidimensional Data in Tissue Engineering
Published on: November 22, 2019
Related Concept Videos
Biostatistics: Overview
Discrete variables are...
Statistical Methods for Analyzing Epidemiological Data
Introduction To Survival Analysis
The primary goal of survival analysis is to estimate survival time—the time until a...
Comparing the Survival Analysis of Two or More Groups
Statistical Software for Data Analysis and Clinical Trials
Statistical Analysis System (SAS)
Applications: SAS finds applications in numerous fields, including healthcare for clinical trial analysis, finance for risk assessment, marketing for customer data analysis, and...