High Performance Analytical Data Reconstructing Strategy in Data Warehouse

2005 ◽  
pp. 527-531
Author(s):  
Xiufeng Xia ◽  
Qing Li ◽  
Lingyu Xu ◽  
Weidong Sun ◽  
Suixiang Shi ◽  
...  
Keyword(s):  
Data Warehouse ◽  
High Performance ◽  
Analytical Data

scholarly journals Analytical quality by design methodology for botanical raw material analysis: a case study of flavonoids in Genkwa Flos

2021 ◽  
Vol 11 (1) ◽  
Author(s):  
Min Kyoung Kim ◽  
Sang Cheol Park ◽  
Geonha Park ◽  
Eunjung Choi ◽  
Yura Ji ◽  
...  
Keyword(s):  
High Performance ◽  
Quality By Design ◽  
Analytical Data ◽  
Gradient Elution ◽  
Raw Material ◽  
Analytical Quality ◽  
Factor Screening ◽  
Column Temperature ◽  
Relative Standard ◽  
Critical Method

AbstractThe present study introduces a systematic approach using analytical quality by design (AQbD) methodology for the development of a qualified liquid chromatographic analytical method, which is a challenge in herbal medicinal products due to the intrinsic complex components of botanical sources. The ultra-high-performance liquid chromatography-photodiode array-mass spectrometry (UHPLC-PDA-MS) technique for 11 flavonoids in Genkwa Flos was utilized through the entire analytical processes, from the risk assessment study to the factor screening test, and finally in method optimization employing central composite design (CCD). In this approach, column temperature and mobile solvent slope were found to be critical method parameters (CMPs) and each of the eleven flavonoid peaks’ resolution values were used as critical method attributes (CMAs) through data mining conversion formulas. An optimum chromatographic method in the design space was calculated by mathematical and response surface methodology (RSM). The established chromatographic condition is as follows: acetonitrile and 0.1% formic acid gradient elution (0–13 min, 10–45%; 13–13.5 min, 45–100%; 13.5–14 min, 100–10%; 14–15 min, 10% acetonitrile), column temperature 28℃, detection wavelength 335 nm, and flow rate 0.35 mL/min using C18 (50 × 2.1 mm, 1.7 μm) column. A validation study was also performed successfully for apigenin 7-O-glucuronide, apigenin, and genkwanin. A few important validation results were as follows: linearity over 0.999 coefficient of correlation, detection limit of 2.87–22.41, quantitation limit of 8.70–67.92, relative standard deviation of precision less than 0.22%, and accuracy between 100.13 and 102.49% for apigenin, genkwanin, and apigenin 7-O-glucuronide. In conclusion, the present design-based approach provide a systematic platform that can be effectively applied to ensure pharmaceutically qualified analytical data from complex natural products based botanical drug.

scholarly journals Data Analytical Processing in Data Warehouses

2010 ◽  
Vol 2 (1) ◽  
pp. 99-116
Author(s):  
Katarzyna Rostek
Keyword(s):  
Data Processing ◽  
Data Warehouse ◽  
Analytical Data ◽  
Data Warehouses ◽  
Practical Guidelines ◽  
Processing Information ◽  
Scope Of Application ◽  
Analytical Processing ◽  
Effective Use

Data Analytical Processing in Data Warehouses The article presents issues connected with processing information from data warehouses (the analytical enterprise databases) and two basic types of analytical data processing in data warehouse. The genesis, main definitions, scope of application and real examples from business implementations will be described for each type of analysis. There will be presented copyrighted method of knowledge discovering in databases, together with practical guidelines for its proper and effective use in the enterprise.

scholarly journals The comparative analysis of modern ETL tools

2021 ◽  
Vol 19 ◽  
pp. 126-131
Author(s):  
Vitalii Mayuk ◽  
Ivan Falchuk ◽  
Piotr Muryjas
Keyword(s):  
Comparative Analysis ◽  
Data Warehouse ◽  
Execution Time ◽  
Analytical Data ◽  
Time Efficiency ◽  
Transactional Data ◽  
Research Efficiency

Each data warehouse requires loading properly processed transactional data. The process that performs this task is known as extract-transform-load (ETL). The efficiency of its implementation affects how quickly the user will have the access to the current analytical data. The paper presents the results of research efficiency of ETL performance of its stage with the use of Azure Synapse (AS) and Azure Data Factory (ADF). The research included selection, sorting and aggregating data, joining tables, and loading data into target tables. To evaluate the efficiency of these operations, the criterion of their execution time has been used. The obtained results indicate that the ADF tool provides a much higher time efficiency of loading transactional data into the data warehouse comparing to AS.

High Performance Historical Available Data Backup Strategy in Data Warehouse

2005 ◽  
pp. 533-537
Author(s):  
Xiufeng Xia ◽  
Lingyu Xu ◽  
Qing Li ◽  
Weidong Sun ◽  
Suixiang Shi ◽  
...  
Keyword(s):  
Data Warehouse ◽  
High Performance ◽  
Data Backup

Preliminary Identification of β-Carotene in the Vitreous Asteroid Bodies by Micro-Raman Spectroscopy and HPLC Analysis

2007 ◽  
Vol 13 (2) ◽  
pp. 128-132 ◽  
Author(s):  
Shan-Yang Lin ◽  
Ko-Hua Chen ◽  
Wen-Ting Cheng ◽  
Chi-Tien Ho ◽  
Shun-Li Wang
Keyword(s):  
High Performance ◽  
Hplc Analysis ◽  
Analytical Data ◽  
Raman Microspectroscopy ◽  
Blurred Vision ◽  
Preliminary Identification ◽  
Hplc Profile ◽  
Confocal Raman Microspectroscopy ◽  
Confocal Raman ◽  
Β Carotene

β-carotene was first identified from the vitreous asteroid bodies (ABs) excised from one patient with asteroid hyalosis (AH) by confocal Raman microspectroscopy and was also verified by high performance liquid chromatography (HPLC). Two patients had been diagnosed with AH and intervened by surgical vitrectomy due to blurred vision. The morphology and components of both AB specimens were observed by optical microscopy and determined by using confocal Raman microspectroscopy and HPLC analysis, respectively. Surprisingly, two unique peaks at 1528 and 1157 cm−1were found in the Raman spectrum for the AB specimen of patient 1 alone, which were in close agreement with that of the Raman peaks at 1525 and 1158 cm−1for β-carotene and/or lutein. However, HPLC analytical data clearly indicated that the retention time for the extracted sample from the AB specimen of patient 1 was observed at 13.685 min and just identical to that of β-carotene (13.759 min) rather than lutein (2.978 min). In addition, the lack of any peak in the HPLC profile for the AB specimen of patient 2 also confirmed the absence of Raman peaks at 1525 and 1158 cm−1. Thus this preliminary study strongly suggests that β-carotene as a unique component of ABs was specifically detected from the AB specimen of one AH patient by using confocal Raman microspectroscopy and HPLC analysis.

scholarly journals Occurrence of Tetrodotoxin in Bivalves and Gastropods from Harvesting Areas and Other Natural Spaces in Spain

Toxins ◽  
2019 ◽  
Vol 11 (6) ◽  
pp. 331 ◽  
Author(s):  
Lucía Blanco ◽  
Jorge Lago ◽  
Virginia González ◽  
Beatriz Paz ◽  
Maria Rambla-Alegre ◽  
...  
Keyword(s):  
Risk Evaluation ◽  
High Performance ◽  
Analytical Data ◽  
The European Union ◽  
Bivalve Molluscs ◽  
Chromatography Tandem Mass Spectrometry ◽  
Liquid Chromatography Tandem Mass ◽  
Fishery Products ◽  
Available Information ◽  
Positive Results

Tetrodotoxin (TTX) is a potent neurotoxin that is receiving increasing interest in the European Union because it has been found in different fishery products (fish, bivalves and gastropods) captured in European waters. Since available information is scarce, further analytical data regarding the incidence of this toxin in European fishery products is needed in order to perform an appropriate risk assessment devoted to protecting consumers’ health. Hence, samples of bivalves and gastropods were collected at different points of the Spanish coast and analyzed by high-performance hydrophilic interaction liquid chromatography-tandem mass spectrometry (HILIC-MS/MS) to evaluate the presence of TTX. None of the analyzed samples showed TTX above an internal threshold of 10 µg/kg or even showed a peak under it. Our results on TTX occurrence obtained in bivalve molluscs and gastropods did not show, at least in the studied areas, a risk for public health. However, taking into account previous positive results obtained by other research groups, and since we did not detect TTX in our samples, a more completed study increasing sampling frequency is needed to ensure proper risk evaluation towards the food safety of these products.

The use of microperforated materials as duct liners: Comparison with fibrous linings

2020 ◽  
Vol 68 (4) ◽  
pp. 269-282
Author(s):  
Hyunjun Shin ◽  
J. Stuart Bolton
Keyword(s):  
Finite Element ◽  
Finite Element Model ◽  
High Performance ◽  
Analytical Data ◽  
Element Model ◽  
Fibrous Materials ◽  
Frequency Range ◽  
Mental Work ◽  
Alternative Approach ◽  
Limited Frequency

The acoustical performance of a microperforated duct liner and a fibrous lining was compared to confirm that a microperforated panel lining can be used to re- place a fibrous liner as a sound attenuator in a duct. Fibrous materials are often used to line ducts in order to attenuate HVAC noise, for example. These treatments are often primarily useful in a limited frequency range owing to the characteristics of non-planar wave propagation in ducts. At the same time, microperforated mate- rials backed by a finite-depth air space are effective in a limited frequency range owing to the nature of the reactive impedance of this combination. Here, it will be shown that microperforated materials may be used to create duct linings that produce attenuation comparable with that of fibrous materials in the latter's high- performance region. The characteristics of the microperforated panel were studied based on the Maa model. To compare the performance of these two linings, theoret- ical, numerical and experimental tools were used. In the various case studies, both extended reaction and locally reacting treatments were considered. For the analyti- cal approach, Morse's theory was applied in the local reaction case. On the other hand, Scott's analysis was used to study the extended reaction case. In the experi- mental work, the transmission losses of various liner configurations were measured in a square impedance tube. To tune the performance of a microperforated sheet to reproduce that of a fibrous material, the hole size, porosity, thickness, density, and air-backing depth were modified. To validate the experimental and analytical data and to handle situations that are not easily modeled using an analytical approach, a finite element model was also used for the calculations. For the finite element model analysis, COMET/VISION and SAFE were used. Since that software does not include explicit microperforated material models, an alternative approach was used. The alternative model was based on the Attala and Sgard model for perforated panels. This alternative approach in which the perforated panel is modeled as a thin porous layer was successfully implemented in finite element form. Finally, it was demonstrated that the microperforated panel can successfully reproduce the acous- tical performance of glass fiber as a duct lining material.

A New Architecture for Large Data Warehouse

2011 ◽  
Vol 55-57 ◽  
pp. 87-90
Author(s):  
Gang Li ◽  
Xing San Qian ◽  
Chun Ming Ye
Keyword(s):  
Decision Making ◽  
Data Warehouse ◽  
Business Intelligence ◽  
High Performance ◽  
Lower Cost ◽  
Large Data ◽  
Current Data

Data warehouse is playing a more and more important role in company’s decision making; it is the basis for a typical business intelligence solution. The paper points out the reasons why data warehouse projects failed and by analyzing the current data warehouse architectures, as well as technologies used in industry, a new data warehouse architecture is proposed which has many advantages over current ones, for example, it is extensible, reusable, flexible and with high performance and lower cost.

Qualitative and Quantitative Analysis of Tryptamines in the Poison of Incilius alvarius (Amphibia: Bufonidae)

2021 ◽  
Author(s):  
Hannes M Schwelm ◽  
Nicole Zimmermann ◽  
Tobias Scholl ◽  
Johannes Penner ◽  
Amy Autret ◽  
...  
Keyword(s):  
Sonoran Desert ◽  
High Performance ◽  
Analytical Data ◽  
Drug Market ◽  
Attenuated Total Reflection ◽  
Gas Chromatography Mass Spectrometry ◽  
Acetone Water ◽  
History Of ◽  
Trace Compounds ◽  
First Time

Abstract Rising numbers of psychoactive tryptamine derivatives have become available on the drug market over the last decade, making these naturally occurring or synthetically manufactured compounds highly relevant for forensic analyses. One of these compounds is 5-methoxy-N,N-dimethyltryptamine (5-MeO-DMT), a constituent of the dried poison of Incilius alvarius (Colorado River toad), which has a history of ritual and/or recreational use. Still, comprehensive and validated qualitative as well as quantitative analytical data on the psychoactive components of this poison are scarce. In this study, samples of the poison of Incilius alvarius were collected from live toads in the Sonoran Desert, Arizona (USA), and analyzed with a set of complementary methods. Acetone/water (70/30, v/v) proved to be the solvent of choice for the extraction of tryptamine derivatives. Trace compounds were enriched, and overload with 5-MeO-DMT was prevented by chromatographic separation of 5-MeO-DMT prior to qualitative analyses. The method for quantification was validated. Attenuated total reflection–Fourier transform infrared spectroscopy was suitable to identify 5-MeO-DMT as the main tryptamine in samples of the poison. The combined evaluation of analytical data gained from gas chromatography–mass spectrometry (GC–MS), high-performance liquid chromatography–quadrupole time-of-flight high-resolution MS (HPLC–qToF–HRMS) and HPLC–MS/MS confirmed the presence of 5-MeO-DMT, 5-MeO-N-methyltryptamine, 5-MeO-tryptamine, 5-MeO-tryptophol, 2-(5-methoxy-1H-indol-3-yl)-acetic-acid (5-MIAA), 5-HO-N-methyltryptamine, bufotenin, DMT and tryptophan. For the first time, 5-MeO-tryptamine and two positional isomers of hydroxylated MeO-DMT were detected in the poison of Incilius alvarius. The tryptamine present in the highest concentrations was 5-MeO-DMT (mean ± SD: 410,000 ± 30,000 mg/g). Mean concentrations of 5-MeO-tryptamine (490 ± 260 mg/g), 5-HO-N-methyltryptamine (270 ± 120 mg/g), bufotenin (2,800 ± 1,900 mg/g) and DMT (250 ± 80 mg/g) showed a relatively high variability between individual samples. The comprehensive analytical reference data of Incilius alvarius poison presented here might prove useful for forensic chemists.

Sign in / Sign up

Export Citation Format

Share Document