Jove
Visualize
Contact Us
JoVE
x logofacebook logolinkedin logoyoutube logo
ABOUT JoVE
OverviewLeadershipBlogJoVE Help Center
AUTHORS
Publishing ProcessEditorial BoardScope & PoliciesPeer ReviewFAQSubmit
LIBRARIANS
TestimonialsSubscriptionsAccessResourcesLibrary Advisory BoardFAQ
RESEARCH
JoVE JournalMethods CollectionsJoVE Encyclopedia of ExperimentsArchive
EDUCATION
JoVE CoreJoVE BusinessJoVE Science EducationJoVE Lab ManualFaculty Resource CenterFaculty Site
Terms & Conditions of Use
Privacy Policy
Policies

Related Concept Videos

Extraction: Advanced Methods00:56

Extraction: Advanced Methods

1.3K
Metal ions can be separated from one another by complexation with organic ligands–the chelating agent– to form uncharged chelates. Here, the chelating agent must contain hydrophobic groups and behave as a weak acid, losing a proton to bind with the metal. Since most organic ligands used in this process are insoluble or undergo oxidation in the aqueous phase, the chelating agent is initially added to the organic phase and extracted into the aqueous phase. The metal-ligand complex is...
1.3K
Column Efficiency: Plate Theory01:10

Column Efficiency: Plate Theory

2.9K
Band broadening in a chromatography column is measured by its efficiency. This is determined by the number of theoretical plates (N). Theoretical plate theory states that a separation column consists of a continuous series of imaginary plates where solute equilibration occurs between stationary and mobile phases.
A higher number of theoretical plates signifies better column efficiency and improved separation capabilities. Plate height affects bandwidth and separation quality; it is inversely...
2.9K
Maximum Size of Aggregate01:12

Maximum Size of Aggregate

1.1K
The maximum size of aggregate is defined as the aperture of the sieve retaining 15 percent or more of the particles present in the aggregate sample. The aggregate's maximum size impacts the concrete's water requirement, workability, and strength. Larger aggregates reduce the surface area needing cement paste coverage, which can lower water needs, thereby allowing a decrease in the water-to-cement ratio when the desired workability and richness of the mix are to be maintained, which can...
1.1K
Column Efficiency: Rate Theory01:12

Column Efficiency: Rate Theory

1.3K
The rate theory of chromatography provides quantitative insight into the shapes and widths of elution bands. These bands are based on the random-walk mechanism governing molecular migration within a column. The Gaussian profile of chromatographic bands arises from the cumulative effect of random molecular motions as they progress through the column.
During elution, a solute molecule experiences numerous transitions between stationary and mobile phases, exhibiting irregular residence times in...
1.3K
Extraction: Partition and Distribution Coefficients01:14

Extraction: Partition and Distribution Coefficients

5.6K
The distribution law or Nernst's distribution law is the law that governs the distribution of a solute between two immiscible solvents. This law, also known as the partition law, states that if a solute is added to the mixture of two immiscible solvents at a constant temperature, the solute is distributed between the two solvents in such a way that the ratio of solute concentrations in the solvents remains constant at equilibrium.
For extracting a solute from an aqueous phase into an...
5.6K
Pivot Bearings01:23

Pivot Bearings

2.5K
In mechanical systems, bearings are crucial in facilitating relative motion between two components while minimizing friction and wear. They help distribute various loads (radial, axial or a combination of both loads) across machinery parts, ensuring smooth and efficient operation.
A pivot bearing is a specialized type of bearing designed to support axial loads on a rotating shaft. The bearing surface, or the pivot, is positioned at the end of a shaft to support the axial thrust. The pivot may...
2.5K

You might also read

Related Articles

Articles linked to this work by shared authors, journal, and citation graph.

Sort by
Same author

Cuproptosis-Related Ferroptosis genes for Predicting Prognosis in kidney renal clear cell carcinoma.

European journal of medical research·2023
Same author

Microbial insights towards understanding the role of hydrochar in enhancing phenol degradation in anaerobic digestion.

Environmental pollution (Barking, Essex : 1987)·2023
Same author

Clinical effect of Danshen decoction in patients with heart failure: A systematic review and meta-analysis of randomized controlled trials.

PloS one·2023
Same author

Using a smartphone app in the measurement of posture-related pupil center shift on centration during corneal refractive surgery.

Frontiers in cell and developmental biology·2023
Same author

Impact of Apps as Assistive Devices for Visually Impaired Persons.

Annual review of vision science·2023
Same author

Clustering-Fusion Feature Selection Method in Identifying Major Depressive Disorder Based on Resting State EEG Signals.

IEEE journal of biomedical and health informatics·2023

Related Experiment Video

Updated: Apr 18, 2026

Executing Complexity-Increasing Queries in Relational MySQL and NoSQL MongoDB and EXist Size-Growing ISO/EN 13606 Standardized EHR Databases
07:26

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

9.8K

Efficient Execution Methods of Pivoting for Bulk Extraction of Entity-Attribute-Value-Modeled Data.

Gang Luo, Lewis J Frey

    IEEE Journal of Biomedical and Health Informatics
    |January 22, 2015
    PubMed
    Summary

    Optimizing data transformation for electronic medical records (EMR) involves enhancing pivot operations. New techniques significantly improve efficiency in extracting data from Entity-Attribute-Value (EAV) tables for analysis.

    More Related Videos

    Heuristic Mining of Hierarchical Genotypes and Accessory Genome Loci in Bacterial Populations
    08:03

    Heuristic Mining of Hierarchical Genotypes and Accessory Genome Loci in Bacterial Populations

    Published on: December 7, 2021

    2.9K
    Databases to Efficiently Manage Medium Sized, Low Velocity, Multidimensional Data in Tissue Engineering
    09:43

    Databases to Efficiently Manage Medium Sized, Low Velocity, Multidimensional Data in Tissue Engineering

    Published on: November 22, 2019

    6.9K

    Related Experiment Videos

    Last Updated: Apr 18, 2026

    Executing Complexity-Increasing Queries in Relational MySQL and NoSQL MongoDB and EXist Size-Growing ISO/EN 13606 Standardized EHR Databases
    07:26

    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

    9.8K
    Heuristic Mining of Hierarchical Genotypes and Accessory Genome Loci in Bacterial Populations
    08:03

    Heuristic Mining of Hierarchical Genotypes and Accessory Genome Loci in Bacterial Populations

    Published on: December 7, 2021

    2.9K
    Databases to Efficiently Manage Medium Sized, Low Velocity, Multidimensional Data in Tissue Engineering
    09:43

    Databases to Efficiently Manage Medium Sized, Low Velocity, Multidimensional Data in Tissue Engineering

    Published on: November 22, 2019

    6.9K

    Area of Science:

    • Biomedical Informatics
    • Data Management
    • Database Systems

    Background:

    • Entity-Attribute-Value (EAV) tables are prevalent in electronic medical records (EMR) and clinical data management.
    • EAV data requires transformation into relational formats via pivot operations for analytical tasks like data mining and machine learning.
    • Current pivot operations are time-consuming and resource-intensive, often needing frequent repetition for data warehousing.

    Purpose of the Study:

    • To develop and present techniques for significantly improving the efficiency of pivot operations on EAV data.
    • To reduce the computational cost and time associated with transforming EAV data for analytical purposes.
    • To enhance data extraction from EAV tables in EMR and clinical study systems.

    Main Methods:

    • Implemented three novel techniques to optimize pivot operations: early filtering of irrelevant EAV tuples, support for pivoting across multiple EAV tables, and multi-query optimization.
    • Demonstrated the effectiveness of these techniques through practical implementation and performance evaluation.
    • Compared the optimized execution method against the standard, basic execution method for pivoting.

    Main Results:

    • The optimized execution method, incorporating the three presented techniques, significantly outperformed the current basic execution method.
    • Early filtering of EAV tuples reduced processing load by excluding unnecessary data points.
    • Pivoting across multiple tables and multi-query optimization further streamlined the data transformation process.

    Conclusions:

    • The proposed techniques offer a substantial improvement in the efficiency of pivot operations for EAV data.
    • These methods can be integrated into a data extraction tool to simplify data specification and accelerate extraction from EAV tables.
    • The optimized approach facilitates more efficient use of EMR and clinical study data for downstream analytical applications.