A high-performance dimension hierarchy semantic cube in data warehouses

Author(s):  
Kongfa Hu ◽  
Zuopeng Liang
2020 ◽  
Vol 4 (s1) ◽  
pp. 46-47
Author(s):  
Brandon Joseph Sonn ◽  
Andrew Monte

OBJECTIVES/GOALS: Utilizing clinical electronic health record (eHR) data pulled en masse from data warehouses provides unique challenges when applying it to retrospective studies. Use of this data in conjunction with metabolomic and genomic results to predict response to lisinopril or ondansetron has been completed. METHODS/STUDY POPULATION: Study population consists of >2000 subjects recruited from the Emergency Medicine Specimen Bank at University of Colorado Denver (UCD). All patients presenting to the emergency department are approached to participate which significantly increases demographic diversity of our study populations. Clinical data is pulled from Health Data Compass (data warehouse at UCD that collects all electronic health record (EHR) data to be able to deliver de-identified). Effectiveness of lisinopril and ondansetron were investigated using metabolomic data collected via ultra-high performance liquid chromatography mass spectrometry and genomic data from Illumina chip technology to find relevant correlations. RESULTS/ANTICIPATED RESULTS: Obtaining retrospective clinical data from data warehouses comes with significant challenges to be addressed. Verifying all clinical variables from patient EHRs is a crucial step that requires extensive quality control steps. As well, ensuring data validity, appropriateness of data points pulled as relate to the study criteria and identifying alternate EHR data points is needed. Chart review is a critical step necessary to surmount these challenges. Additionally, use of retrospective EHR data often necessitates the development of novel definitions of clinical effectiveness that can be abstracted from the EHR– such as how to determine decrease in nausea without a visual analogue scale. DISCUSSION/SIGNIFICANCE OF IMPACT: Utilizing data warehouses to deliver EHR data provides a valuable tool for completing retrospective precision medicine projects. The validation of definitions for clinical outcomes identifiable retrospectively are necessary and provide novel guidance for future studies.


Author(s):  
A. V. Crewe ◽  
M. Isaacson ◽  
D. Johnson

A double focusing magnetic spectrometer has been constructed for use with a field emission electron gun scanning microscope in order to study the electron energy loss mechanism in thin specimens. It is of the uniform field sector type with curved pole pieces. The shape of the pole pieces is determined by requiring that all particles be focused to a point at the image slit (point 1). The resultant shape gives perfect focusing in the median plane (Fig. 1) and first order focusing in the vertical plane (Fig. 2).


Author(s):  
N. Yoshimura ◽  
K. Shirota ◽  
T. Etoh

One of the most important requirements for a high-performance EM, especially an analytical EM using a fine beam probe, is to prevent specimen contamination by providing a clean high vacuum in the vicinity of the specimen. However, in almost all commercial EMs, the pressure in the vicinity of the specimen under observation is usually more than ten times higher than the pressure measured at the punping line. The EM column inevitably requires the use of greased Viton O-rings for fine movement, and specimens and films need to be exchanged frequently and several attachments may also be exchanged. For these reasons, a high speed pumping system, as well as a clean vacuum system, is now required. A newly developed electron microscope, the JEM-100CX features clean high vacuum in the vicinity of the specimen, realized by the use of a CASCADE type diffusion pump system which has been essentially improved over its predeces- sorD employed on the JEM-100C.


Author(s):  
John W. Coleman

In the design engineering of high performance electromagnetic lenses, the direct conversion of electron optical design data into drawings for reliable hardware is oftentimes difficult, especially in terms of how to mount parts to each other, how to tolerance dimensions, and how to specify finishes. An answer to this is in the use of magnetostatic analytics, corresponding to boundary conditions for the optical design. With such models, the magnetostatic force on a test pole along the axis may be examined, and in this way one may obtain priority listings for holding dimensions, relieving stresses, etc..The development of magnetostatic models most easily proceeds from the derivation of scalar potentials of separate geometric elements. These potentials can then be conbined at will because of the superposition characteristic of conservative force fields.


Author(s):  
J W Steeds ◽  
R Vincent

We review the analytical powers which will become more widely available as medium voltage (200-300kV) TEMs with facilities for CBED on a nanometre scale come onto the market. Of course, high performance cold field emission STEMs have now been in operation for about twenty years, but it is only in relatively few laboratories that special modification has permitted the performance of CBED experiments. Most notable amongst these pioneering projects is the work in Arizona by Cowley and Spence and, more recently, that in Cambridge by Rodenburg and McMullan.There are a large number of potential advantages of a high intensity, small diameter, focussed probe. We discuss first the advantages for probes larger than the projected unit cell of the crystal under investigation. In this situation we are able to perform CBED on local regions of good crystallinity. Zone axis patterns often contain information which is very sensitive to thickness changes as small as 5nm. In conventional CBED, with a lOnm source, it is very likely that the information will be degraded by thickness averaging within the illuminated area.


Sign in / Sign up

Export Citation Format

Share Document