• Title/Summary/Keyword: Multi-Row Transaction

Search Result 3, Processing Time 0.017 seconds

Transaction Processing Method for NoSQL Based Column

  • Kim, Jeong-Joon
    • Journal of Information Processing Systems
    • /
    • v.13 no.6
    • /
    • pp.1575-1584
    • /
    • 2017
  • As interest in big data has increased recently, NoSQL, a solution for storing and processing big data, is getting attention. NoSQL supports high speed, high availability, and high scalability, but is limited in areas where data integrity is important because it does not support multiple row transactions. To overcome these drawbacks, many studies are underway to support multiple row transactions in NoSQL. However, existing studies have a disadvantage that the number of transactions that can be processed per unit of time is low and performance is degraded. Therefore, in this paper, we design and implement a multi-row transaction system for data integrity in big data environment based on HBase, a column-based NoSQL which is widely used recently. The multi-row transaction system efficiently performs multi-row transactions by adding columns to manage transaction information for every user table. In addition, it controls the execution, collision, and recovery of multiple row transactions through the transaction manager, and it communicates with HBase through the communication manager so that it can exchange information necessary for multiple row transactions. Finally, we performed a comparative performance evaluation with HAcid and Haeinsa, and verified the superiority of the multirow transaction system developed in this paper.

Estimation and Determinants on Residential Investment Profits in Seoul: A Focus on Housing Transaction Price from 2010 to 2018 (서울시 주택 예상투자이익 추정과 영향요인에 대한 시론적 분석 - 2010-2018년 주택 실거래가를 중심으로 -)

  • Ahn, Hye-Sung;Kang, Chang-Deok
    • Journal of the Korean Regional Science Association
    • /
    • v.36 no.1
    • /
    • pp.37-50
    • /
    • 2020
  • Estimating investment profits of real estate is critical to understand real estate markets and create relevant policy as real estate market and capital market combines closely. Thus, this study applied the concept of Tobin's Q to estimate investment profits for apartments as well as row-houses and multi-family homes in Seoul from 2010 to 2018. Investment profits were estimated by two approaches: subtracting the replacement cost from the transaction price and calculating ratio of the transaction price to the replacement cost, respectively. The spatio-temporal changes in investment profits were apparent in apartments compared with row-houses and multi-family homes. As a result of analyzing the spatial econometrics models, the investment profit was higher in the area with high density and new developments regardless of the housing types. The framework and key findings would be the effective reference to understand residential investment behavior, create relevant housing policy, introduce value capture of windfall, measure regional competitiveness, and estimate housing bubble.

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.