Abstract：
:Entity-Attribute-Value (EAV) data, as present in repositories of clinical patient data, must be transformed (pivoted) into one-column-per-parameter format before it can be used by a variety of analytical programs. Pivoting approaches have not been described in depth in the literature, and existing descriptions are dated. We describe and benchmark three alternative algorithms to perform pivoting of clinical data in the context of a clinical study data management system. We conclude that when the number of attributes to be returned is not too large, it is feasible to use static SQL as the basis for views on the data. An alternative but more complex approach that utilizes hash tables and the presence of abundant random-access-memory can achieve improved performance by reducing the load on the database server.
journal_name
Comput Methods Programs Biomedjournal_title
Computer methods and programs in biomedicineauthors
Dinu V,Nadkarni P,Brandt Cdoi
10.1016/j.cmpb.2006.02.001subject
Has Abstractpub_date
2006-04-01 00:00:00pages
38-43issue
1eissn
0169-2607issn
1872-7565pii
S0169-2607(06)00028-9journal_volume
82pub_type
杂志文章abstract：:ENDO-LAB is an IBM PC-based system which performs calculations and record-keeping for the Vanderbilt University Medical Center Endocrinology Laboratory. It manages maintenance and quality control, and prints reports for regulatory agencies. The system was designed to minimize paperwork without changing laboratory proc...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章
doi：10.1016/0169-2607(88)90088-0
更新日期：1988-11-01 00:00:00
abstract：:A flexible program for the IBM PC performing a number of calculations of relevance for the prescription of hemodialysis treatment has been developed. The program has a 'spreadsheet'-like user-friendly interface, and results may be presented graphically. The present implementation covers 89 algorithms/equations, all ba...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章
doi：10.1016/0169-2607(90)90009-x
更新日期：1990-03-01 00:00:00
abstract：BACKGROUND:The breast dense tissue percentage on digital mammograms is one of the most commonly used markers for breast cancer risk estimation. Geometric features of dense tissue over the breast and the presence of texture structures contained in sliding windows that scan the mammograms may improve the predictive abili...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章
doi：10.1016/j.cmpb.2019.05.022
更新日期：2019-08-01 00:00:00
abstract：BACKGROUND AND OBJECTIVE:For cancer detection from microscopic biopsy images, image segmentation step used for segmentation of cells and nuclei play an important role. Accuracy of segmentation approach dominate the final results. Also the microscopic biopsy images have intrinsic Poisson noise and if it is present in th...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章
doi：10.1016/j.cmpb.2017.05.003
更新日期：2017-07-01 00:00:00
abstract：BACKGROUND AND OBJECTIVE:In this paper an information theory based multiscale singular value decomposition (SVD) is proposed for multilead electrocardiogram (ECG) signal processing. The shrinkage of singular values for different multivariate multiscale matrices at wavelet scales is based on information content. It aims...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章
doi：10.1016/j.cmpb.2016.01.010
更新日期：2016-06-01 00:00:00
abstract：:The GALEN project is developing language independent concept representation systems as the foundations for the next generation of multilingual coding systems. It aims to support the flexibility required to cope with the diversity amongst medical applications, while ensuring the coherence necessary for integration and ...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章
doi：10.1016/0169-2607(94)90020-5
更新日期：1994-10-01 00:00:00
abstract：BACKGROUND AND OBJECTIVE:Accurate, reliable, efficient, and precise measurements of the lumen geometry of the common carotid artery (CCA) are important for (a) managing the progression/regression of atherosclerotic build-up and (b) the risk of stroke. The image-based degree of stenosis in the carotid artery and the pla...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章,评审
doi：10.1016/j.cmpb.2018.05.015
更新日期：2018-09-01 00:00:00
abstract：:In this study, an attempt has been made to find the correlation between diffusion tensor imaging (DTI) indices of white matter (WM) regions and mini mental state examination (MMSE) score of Alzheimer patients. Diffusion weighted images are obtained from the ADNI database. These are preprocessed for eddy current correc...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章
doi：10.1016/j.cmpb.2014.06.004
更新日期：2014-10-01 00:00:00
abstract：:The development of functions for MATLAB and S-PLUS that can be used for the evaluation of specific population pharmacokinetic designs has been described recently. These functions are based on the evaluation of an approximation of the population Fisher information matrix. Optimisation of the design of the population ex...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章
doi：10.1016/s0169-2607(01)00178-x
更新日期：2002-07-01 00:00:00
abstract：:Following the paper publication of practice guidelines for the management of febrile patients returning from the tropics, we constructed a consultation website that comprises a decision chart and specific diagnostic features providing medical diagnostic assistance to primary care physicians. We then integrated a resea...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章
doi：10.1016/j.cmpb.2006.09.004
更新日期：2007-01-01 00:00:00
abstract：:A microcomputer program in BASIC for predicting percentage of occurrence of electroshock-induced convulsion in mice was designed. A formula published by the author to express the mathematical relationship among the drug dose, the time, and the biological response was used in this program. Analysis of the actual, and t...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章
doi：10.1016/0169-2607(89)90177-6
更新日期：1989-01-01 00:00:00
abstract：:As we continue to strive to apply the findings of in vitro and animal studies to human disease and transition from genomics to proteomics, we will experience an ever-increasing need for human tissues. A web based system that provides access to tissues repositories and associated data will best facilitate the access to...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章,评审
doi：10.1016/s0169-2607(02)00002-0
更新日期：2003-02-01 00:00:00
abstract：:Tools for calculating Gaussian parametric statistics are widely available in hand-held calculators and program packages for desktop as well as mainframe computers. The standard deviation calculated from non-Gaussian data may, however, be meaningless or even absurd. Furthermore, the standard error of the mean is freque...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章
doi：10.1016/0169-2607(88)90046-6
更新日期：1988-03-01 00:00:00
abstract：BACKGROUND AND OBJECTIVE:Fraction of Inspired Oxygen is one of the arbitrary set ventilator parameters which has critical influence on the concentration of blood oxygen. Normally mechanical ventilators providing respiratory assistance are tuned manually to supply required inspired oxygen to keep the oxygen saturation a...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章
doi：10.1016/j.cmpb.2019.04.014
更新日期：2019-07-01 00:00:00
abstract：:Vascular catheterization is a common procedure in clinical medicine. It is normally performed by a specialist using an X-ray fluoroscopic guide and contrast-media. In the present paper, an image-guided navigation system which indicates a path providing guidance to the desired target inside the vascular tree is describ...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章
doi：10.1016/j.cmpb.2007.07.009
更新日期：2007-11-01 00:00:00
abstract：BACKGROUND AND OBJECTIVES:Surface rendering and physical models with constant parameters are often employed for cutting procedures in conventional surgical simulators. As a consequence, the internal structures of soft tissues cannot be rendered properly and haptic interaction is unrealistic. In order to improve both th...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章
doi：10.1016/j.cmpb.2019.105270
更新日期：2020-02-01 00:00:00
abstract：:Influence diagrams have been widely used as knowledge bases in medical informatics and many applied domains. In conventional influence diagrams, the numerical models of uncertainty are probability distributions associated with chance nodes and value tables for value nodes. However, when incomplete knowledge or linguis...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章
doi：10.1016/j.cmpb.2007.11.009
更新日期：2008-04-01 00:00:00
abstract：:Both sample entropy and approximate entropy are measurements of complexity. The two methods have received a great deal of attention in the last few years, and have been successfully verified and applied to biomedical applications and many others. However, the algorithms proposed in the literature require O(N(2)) execu...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章
doi：10.1016/j.cmpb.2010.12.003
更新日期：2011-12-01 00:00:00
abstract：BACKGROUND AND OBJECTIVE:Several studies have evaluated the reproducibility of the Cobb angle for measuring the degree of scoliotic deformities from X-ray spine images, and proposed different geometric models for describing the spinal curvature. The ellipse was shown to be an adequate geometric form, but was not yet ap...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章
doi：10.1016/j.cmpb.2018.04.015
更新日期：2018-07-01 00:00:00
abstract：BACKGROUND AND OBJECTIVE:For diagnosis of arrhythmic heart problems, electrocardiogram (ECG) signals should be recorded and monitored. The long-term signal records obtained are analyzed by expert cardiologists. Devices such as the Holter monitor have limited hardware capabilities. For improved diagnostic capacity, it w...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章
doi：10.1016/j.cmpb.2019.05.004
更新日期：2019-07-01 00:00:00
abstract：:For the first time compressed sampling (CS) has been applied to heart rate (HR) measurements. The signals can be reconstructed from samples far below the Nyquist rate with negligible small errors, a sampling reduction of 8 has been demonstrated in the paper. As a result, the bitrate of the CS sampler is half when comp...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章
doi：10.1016/j.cmpb.2012.06.002
更新日期：2012-12-01 00:00:00
abstract：:The assessment of sample size in clinical trials comparing means requires a variance estimate of the main efficacy variable. If no reliable information about the variance of the key response is available at the beginning of a clinical trial, the use of data from the first 'few' patients entered in the trial ('internal...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章
doi：10.1016/s0169-2607(00)00119-x
更新日期：2001-06-01 00:00:00
abstract：:A convolution program (CONV) solving responses to a collimated finite diameter photon beam perpendicularly incident on a multi-layered tissue has been coded in ANSI Standard C, hence, the program can be executed on various computers. The program, employing an extended trapezoidal rule for integration, convolves the re...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章
doi：10.1016/s0169-2607(97)00021-7
更新日期：1997-11-01 00:00:00
abstract：:DIMSUM, an acronym for DIMension of a SUM of exponentials, is a highly automated expert system for fitting multiexponential models of increasing dimension to time series data. Up to now, a researcher has needed an individual copy of DIMSUM on his or her own computer as well as support to learn how to use it. W3DIMSUM,...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章
doi：10.1016/j.cmpb.2005.03.008
更新日期：2005-08-01 00:00:00
abstract：BACKGROUND AND OBJECTIVE:This contribution presents a rapid computational framework to mechanically simulate the insertion of a slender medical instrument in a tubular structure such as an artery, the cochlea or another slender instrument. METHODS:Beams are employed to rapidly simulate the mechanical behaviour of the ...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章
doi：10.1016/j.cmpb.2020.105527
更新日期：2020-11-01 00:00:00
abstract：:We have developed a reference management system, MacRefer, using HyperTalk on Macintosh personal computers. Using this program, one can automatically acquire data from databases created by EndNote Plus and from OVID- or Medlar-formatted records downloaded via an online use of Medline. The MacRefer's capability of form...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章
doi：10.1016/0169-2607(96)01731-2
更新日期：1996-06-01 00:00:00
abstract：:The use of well characterized laboratory animals in biomedical research is of importance for quality securing and reproducibility of animal experiments. Therefore, breeders should not only have in mind the reproduction of their animal stocks, but they should also be interested to achieve an optimal resemblance of the ...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章
doi：10.1016/0169-2607(92)90076-j
更新日期：1992-06-01 00:00:00
abstract：BACKGROUND AND OBJECTIVE:Diabetic disease is typically composed because of higher than normal blood sugar levels. Instead the production of insulin may be regarded insufficient. It has been noted in recent days that the percentage of diabetes-affected patients have grown to a larger extent throughout the world. Evident...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章
doi：10.1016/j.cmpb.2020.105659
更新日期：2020-11-01 00:00:00
abstract：:A set of programs is described by which a consistent morphometry of bone sections can be performed. The programs are written in FORTRAN IV in a PDP 11/10 minicomputer, under the RT-11 operating system. The bone sections are run through the field of vision of the microscope using a scanning stage in one of several pres...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章
doi：10.1016/0169-2607(85)90003-3
更新日期：1985-12-01 00:00:00
abstract：:The paper describes a software method to extend ITK (Insight ToolKit, supported by the National Library of Medicine), leading to ITK++. This method, which is based on the extension of the iterator design pattern, allows the processing of regions of interest with arbitrary shapes, without modifying the existing ITK cod...
journal_title：Computer methods and programs in biomedicine
pub_type： 杂志文章
doi：10.1016/j.cmpb.2005.09.006
更新日期：2006-01-01 00:00:00
