Related Experiment Video
Updated: Jul 25, 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
Large scale database scrubbing using object oriented software components
1Department of Health Management and Informatics, University of Missouri-Columbia School of Medicine, USA.
Abstract:
Now that case managers, quality improvement teams, and researchers use medical databases extensively, the ability to share and disseminate such databases while maintaining patient confidentiality is paramount. A process called scrubbing addresses this problem by removing personally identifying information while keeping the integrity of the medical information intact. Scrubbing entire databases, containing multiple tables, requires that the implicit relationships between data elements in different tables of the database be maintained. To address this issue we developed DBScrub, a Java program that interfaces with any JDBC compliant database and scrubs the database while maintaining the implicit relationships within it. DBScrub uses a small number of highly configurable object-oriented software components to carry out the scrubbing. We describe the structure of these software components and how they maintain the implicit relationships within the database.
Related Concept Videos
Cleaning, Sterilization, and Disinfection
Cleaning
The cleaning process usually involves using water with detergents or enzymatic cleaner and removing foreign material from objects and surfaces, including organic material such as body fluids or inorganic material like soil. Cleaning is performed before high-level disinfection and sterilization because foreign materials on the cover of the devices interfere with process...
Methods of Documentation I: Source-Oriented Records
In an SOR, each discipline involved in patient care maintains a separate medical record section. This record-keeping method enables easy tracking of patient progress and ensures healthcare staff have access to up-to-date information.
Key Attributes include the following:
Deleterious Substances in Aggregate
Another type of impurity is clay and fine material that...
Design Example: Designing a Residential Plumbing System
Impact of Schemas

