• Title/Summary/Keyword: column storage

Search Result 168, Processing Time 0.022 seconds

Column-aware Polarization Scheme for High-Speed Database Systems (고속 데이터베이스 시스템을 위한 컬럼-인지 양분화 기법)

  • Byun, Si-Woo
    • Journal of Internet Computing and Services
    • /
    • v.13 no.3
    • /
    • pp.83-91
    • /
    • 2012
  • Recently, column-oriented storage has become a progressive model for high-speed database systems because of its superior I/O performance. In this paper, we analysis traditional raw-oriented storage model and then propose a new column-aware storage management model using flash memory drive and assist drive to improve the effective performance of the high-speed column-oriented database system. Our storage management scheme called column-aware polarization improves the performance of update operation by dividing and compressing table columns into active-columns or inactive-columns, and balancing congested update operations using a assist drive in high workload periods. The results obtained from experimental tests show that our scheme improves the update throughput of column-oriented storage by 19 percent, and the response time by up to 49 percent.

Column cleaning, regeneration and storage of silica-based columns (실리카 기반 컬럼의 세척, 재생 및 보관 가이드)

  • Matt James;Mark Fever
    • FOCUS: LIFE SCIENCE
    • /
    • no.1
    • /
    • pp.1.1-1.4
    • /
    • 2024
  • This article provides comprehensive guidance on the maintenance, cleaning, regeneration, and storage of silica-based HPLC (High-Performance Liquid Chromatography) columns. The general considerations emphasize the importance of using in-line filters and guard cartridges to protect columns from blockage and irreversible sample adsorption. While these measures help, contamination by strongly adsorbed sample components can still occur over time, leading to an increase in back pressure, loss of efficiency, and other issues. To maximize column lifetime, especially with UHPLC (Ultra-High Performance Liquid Chromatography) columns, it is advisable to use ultra-pure solvents, freshly prepared aqueous mobile phases, and to filter all samples, standards, and mobile phases. Additionally, an in-line filter system and sample clean-up on dirty samples are recommended. However, in cases of irreversible compound adsorption or column voiding, regeneration may not be possible. The document also provides specific recommendations for column cleaning procedures, including the flushing procedures for various types of columns such as reversed phase, unbonded silica, bonded normal phase, anion exchange, cation exchange, and size exclusion columns for proteins. The flushing procedures involve using specific solvents in a series to clean and regenerate the columns. It is emphasized that the flow rate during flushing should not exceed the specified limit for the particular column, and the last solvent used should be compatible with the mobile phase. Furthermore, the article outlines the storage conditions for silica based HPLC columns, highlighting the impact of storage conditions on the column's lifetime. It is recommended to flush all buffers, salts, and ion-pairing reagents from the column before storage. The storage solvent should ideally match the one used in the initial column test chromatogram provided by the manufacturer, and column end plugs should be fitted to prevent solvent evaporation and drying out of the packing bed.

  • PDF

Cross Compressed Replication Scheme for Large-Volume Column Storages (대용량 컬럼 저장소를 위한 교차 압축 이중화 기법)

  • Byun, Siwoo
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.14 no.5
    • /
    • pp.2449-2456
    • /
    • 2013
  • The column-oriented database storage is a very advanced model for large-volume data analysis systems because of its superior I/O performance. Traditional data storages exploit row-oriented storage where the attributes of a record are placed contiguously in hard disk for fast write operations. However, for search-mostly datawarehouse systems, column-oriented storage has become a more proper model because of its superior read performance. Recently, solid state drive using MLC flash memory is largely recognized as the preferred storage media for high-speed data analysis systems. In this paper, we introduce fast column-oriented data storage model and then propose a new storage management scheme using a cross compressed replication for the high-speed column-oriented datawarehouse system. Our storage management scheme which is based on two MLC SSD achieves superior performance and reliability by the cross replication of the uncompressed segment and the compressed segment under high workloads of CPU and I/O. Based on the results of the performance evaluation, we conclude that our storage management scheme outperforms the traditional scheme in the respect of update throughput and response time of the column segments.

GC Capillary Column Installation (가스 크로마토그래피 캐필러리 컬럼 설치 가이드)

  • Matt James;Kirsty Ford
    • FOCUS: LIFE SCIENCE
    • /
    • no.1
    • /
    • pp.2.1-2.6
    • /
    • 2024
  • This article provides detailed instructions for the correct installation, maintenance, and troubleshooting of capillary gas chromatography (GC) columns. It emphasizes the importance of proper installation to ensure optimal performance and longevity of the column. The document covers various aspects such as column trimming, installation, conditioning, testing, storage, and ferrule selection. The installation process involves ensuring that the heated zones of the GC are cool before placing the column cage in the column oven. It is essential to avoid sharp bends or stress on the capillary column during installation and to connect the front end of the column into the GC inlet at the recommended insertion distance. The document also provides guidance on trimming the column, including the use of a ceramic wafer or capillary column cutter to achieve a clean, burr-free cut. For previously used columns, it recommends removing any capillary caps, positioning the nut and ferrule, and trimming 1-2 cm from the column. After installation, the column should be purged with carrier gas to remove any oxygen and avoid oxidizing the column. Conditioning the column involves ramping to the upper isothermal temperature limit and maintaining this temperature for a specified duration. It is crucial to maintain carrier gas flow during conditioning and not exceed the upper temperature limit of the column to avoid phase damage. The document also discusses testing column performance using a suitable method and performing a test injection to assess performance. It provides recommendations for column storage, including flame-sealing the capillary ends or using retention gaps for long-term storage. Additionally, it emphasizes the importance of routine maintenance and replacement of GC consumables to extend the column's lifetime. Ferrule selection is another important aspect covered in the article, with a variety of ferrule materials available for different applications. The characteristics of common ferrule options are presented in a table, including temperature limits, reusability, and suitability for specific detector types.

  • PDF

Storage Lifetime Improvement of Zr-Ni K1 Delay System (Zr-Ni계 지연관 결합체(K1) 저장수명 향상)

  • Chang, Il-Ho;Back, Seung-Jun;Jung, Eun-Jin;Son, Young-Kap
    • Journal of the Korea Institute of Military Science and Technology
    • /
    • v.13 no.2
    • /
    • pp.336-341
    • /
    • 2010
  • The burning interruption between the initiator and the delay column in a Zr-Ni K1 delay system used for a K510 fuze occurs with long-time storage. About 10 % failure probability of 15-years stored delay systems shows the failure mode in open literature. This paper shows storage lifetime improvement results for the delay system through changing the single-base delay column into double-base ones and controlling the manufacturing processes especially the initial inclusion of humidity. The double-base delay columns was implemented by inserting one delay column of fast burning rates between the initiator and the previous delay column of slow burning rates. Accelerated aging tests of the delay systems with double-base columns, and then the firing tests were performed to evaluate the improved lifetime. The double-base delay columns shows improved storage lifetime of the delay system through preventing the failure mode.

A Column-Aware Index Management Using Flash Memory for Read-Intensive Databases

  • Byun, Si-Woo;Jang, Seok-Woo
    • Journal of Information Processing Systems
    • /
    • v.11 no.3
    • /
    • pp.389-405
    • /
    • 2015
  • Most traditional database systems exploit a record-oriented model where the attributes of a record are placed contiguously in a hard disk to achieve high performance writes. However, for read-mostly data warehouse systems, the column-oriented database has become a proper model because of its superior read performance. Today, flash memory is largely recognized as the preferred storage media for high-speed database systems. In this paper, we introduce a column-oriented database model based on flash memory and then propose a new column-aware flash indexing scheme for the high-speed column-oriented data warehouse systems. Our index management scheme, which uses an enhanced $B^+$-Tree, achieves superior search performance by indexing an embedded segment and packing an unused space in internal and leaf nodes. Based on the performance results of two test databases, we concluded that the column-aware flash index management outperforms the traditional scheme in the respect of the mixed operation throughput and its response time.

Free vibration analysis of steel liquid storage tank with functionally graded column based on modified continuum mechanics

  • Cavus, Yakup Harun;Kupeli, Togay;Yayli, Mustafa Ozgur
    • Coupled systems mechanics
    • /
    • v.11 no.4
    • /
    • pp.335-355
    • /
    • 2022
  • It's important to note that the number of studies on the lateral vibration of steel liquid storage tanks has been quite modest in the past. The aim of this research has to look at the variables that affect vibration of storage tanks and to highlight the characteristics of a construction that hasn't received much attention in the literature. The storage tank has pre-sized in the study, and aluminum and steel have chosen as components. The specified material qualities and the factors utilized in the investigation has used to calculate vibration frequency values. The resulting calculations are backed up by tables and graphs, and it's an important to look into the parameters that affect the vibration frequencies that will occur on the designed storage tank vary. In the literature, water tanks are usually modelled as lumped masses. The horizontal stiffness of the column on which it is placed is assumed to be constant throughout. This is an approximation method of solving this problem. The column is handled in this study with a more realistic approach that fits the continuum mechanics in the analysis. The reservoir part is incorporated directly into the problem as the boundary condition.

Shaking table test and horizontal torsional vibration response analysis of column-supported vertical silo group silo structure

  • Li, Xuesen;Ding, Yonggang;Xu, Qikeng
    • Advances in concrete construction
    • /
    • v.12 no.5
    • /
    • pp.377-389
    • /
    • 2021
  • Reinforced concrete vertical silos are universal structures that store large amounts of granular materials. Due to the asymmetric structure, heavy load, uneven storage material distribution, and the difference between the storage volume and the storage material bulk density, the corresponding earthquake is very complicated. Some scholars have proposed the calculation method of horizontal forces on reinforced concrete vertical silos under the action of earthquakes. Without considering the effect of torsional effect, this article aims to reveal the expansion factor of the silo group considering the torsional effect through experiments. Through two-way seismic simulation shaking table tests on reinforced concrete column-supported group silo structures, the basic dynamic characteristics of the structure under earthquake are obtained. Taking into account the torsional response, the structure has three types of storage: empty, half and full. A comprehensive analysis of the internal force conditions under the material conditions shows that: the different positions of the group bin model are different, the side bin displacement produces a displacement difference, and a torsional effect occurs; as the mass of the material increases, the structure's natural vibration frequency decreases and the damping ratio Increase; it shows that the storage material plays a role in reducing energy consumption of the model structure, and the contribution value is related to the stiffness difference in different directions of the model itself, providing data reference for other researchers; analyzing and calculating the model stiffness and calculating the internal force of the earthquake. As the horizontal side shift increases in the later period, the torsional effect of the group silo increases, and the shear force at the bottom of the column increases. It is recommended to consider the effect of the torsional effect, and the increase factor of the torsional effect is about 1.15. It can provide a reference for the structural safety design of column-supported silos.

Column-aware Transaction Management Scheme for Column-Oriented Databases (컬럼-지향 데이터베이스를 위한 컬럼-인지 트랜잭션 관리 기법)

  • Byun, Si-Woo
    • Journal of Internet Computing and Services
    • /
    • v.15 no.4
    • /
    • pp.125-133
    • /
    • 2014
  • The column-oriented database storage is a very advanced model for large-volume data analysis systems because of its superior I/O performance. Traditional data storages exploit row-oriented storage where the attributes of a record are placed contiguously in hard disk for fast write operations. However, for search-mostly datawarehouse systems, column-oriented storage has become a more proper model because of its superior read performance. Recently, solid state drive using MLC flash memory is largely recognized as the preferred storage media for high-speed data analysis systems. The features of non-volatility, low power consumption, and fast access time for read operations are sufficient grounds to support flash memory as major storage components of modern database servers. However, we need to improve traditional transaction management scheme due to the relatively slow characteristics of column compression and flash operation as compared to RAM memory. In this research, we propose a new scheme called Column-aware Multi-Version Locking (CaMVL) scheme for efficient transaction processing. CaMVL improves transaction performance by using compression lock and multi version reads for efficiently handling slow flash write/erase operation in lock management process. We also propose a simulation model to show the performance of CaMVL. Based on the results of the performance evaluation, we conclude that CaMVL scheme outperforms the traditional scheme.

Analysis of Behavior Characteristics According to The Foundations Fixing Conditions of Storage Racks (적재설비 기초 고정조건에 따른 거동특성 분석)

  • Park, Chae-Rin;Heo, Gwang-Hee;Kim, Chung-Gil;Park, Jin-Yong;Ko, Byeong-Chan
    • Journal of the Korea institute for structural maintenance and inspection
    • /
    • v.25 no.3
    • /
    • pp.68-76
    • /
    • 2021
  • Storage racks have suffered huge losses due to earthquakes, but related research and regulations are relatively insufficient non-structural elements compared to the structural elements. In this study, we tried to experimentally analyze the behavioral characteristics of storage racks due to external force according to the fixing conditions of the column-foundations connection of storage racks. In general, the column-foundations connection of storage racks is installed according to the user's convenience without installation standards and regulations. For this reason, this study conducted a behavior analysis test on four full-scale storage racks with the condition of column-foundations connection of four typical storage racks. The behavior characteristics analysis test was performed by two-direction of the shake table with El-Centro seismic wave. To confirm the behavior characteristics according to the magnitude of the seismic load, 50% ~ 150% of the seismic waves were increased by 50% for each test. In addition, a resonance search test was conducted to confirm the natural frequency of each storage racks foundations fixing condition. Among the data obtained through the test, the displacement of the top layer and the permanent displacement after the test were compared for each condition to analyze the behavior characteristics of the column-foundations fixed conditions of the storage racks. As a result, the change of natural frequency was small in storage racks due to the change of the conditions of the foundations, and the behavior characteristics were changed due to the difference of the restoring force due to the change of the storage racks foundations condition rather than the influence of the natural frequency of the input load.