Pivoting approaches for bulk extraction of Entity-Attribute-Value data

Valentin Dinu1, Prakash Nadkarni, Cynthia Brandt

  • 1Center for Medical Informatics, Yale University School of Medicine, PO Box 208009, New Haven, CT 06520-8009, USA. Valentin.Dinu@yale.edu

Related Concept Videos

ER Retrieval Pathway01:45

ER Retrieval Pathway

In the secretory pathway, vesicles transport proteins from one cellular compartment to another in forward transport to deliver the protein to its correct location. Occasionally, misfolded proteins and incorrect proteins escape their original compartments, and a retrieval pathway is used to return the escaped proteins to their original compartment.
The ER uses many checkpoints to prevent the entry of incorrectly folded or a resident protein as cargo onto a transport vesicle. These mechanisms...
Extraction: Partition and Distribution Coefficients01:14

Extraction: Partition and Distribution Coefficients

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 organic...
Pivot Bearings01:23

Pivot Bearings

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...
Extraction: Advanced Methods00:56

Extraction: Advanced Methods

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 formed in...
Bulk Density of Aggregate01:22

Bulk Density of Aggregate

Bulk density refers to the mass of aggregate particles that would fill a unit volume. The concept of bulk density originates from the inability to pack aggregate particles in a manner that completely eliminates void spaces. Hence, the term bulk refers to the volume that encompasses both the aggregates and the voids. This measurement is crucial when aggregates are batched by volume and is used to convert quantities by mass to volume.
Most natural mineral aggregates, like sand and gravel,...
Maximum Size of Aggregate01:12

Maximum Size of Aggregate

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 result...