• Title/Summary/Keyword: Pre-Commit

Search Result 8, Processing Time 0.029 seconds

A Disk Group Commit Protocol for Main-Memory Database Systems (주기억 장치 데이타베이스 시스템을 위한 디스크 그룹 완료 프로토콜)

  • 이인선;염헌영
    • Journal of KIISE:Databases
    • /
    • v.31 no.5
    • /
    • pp.516-526
    • /
    • 2004
  • Main-Memory DataBase(MMDB) system where all the data reside on the main memory shows tremendous performance boost since it does not need any disk access during the transaction processing. Since MMDB still needs disk logging for transaction commit, it has become another bottleneck for the transaction throughput and the commit protocol should be examined carefully. There have been several attempts to reduce the logging overhead. The pre-commit and group commit are two well known techniques which do not require additional hardware. However, there has not been any research to analyze their effect on MMDB system. In this paper, we identify the possibility of deadlock resulting from the group commit and propose the disk group commit protocol which can be readily deployed. Using extensive simulation, we have shown that the group commit is effective on improving the MMDB transaction performance and the proposed disk group commit almost always outperform carefully tuned group commit. Also, we note that the pre-commit does not have any effect when used alone but shows some improvement if used in conjunction with the group commit.

A Study of Group Commit Policy in main Memory Database System (메인 메모리 데이터베이스 시스템에서의 그룹 완료 방식에 관한 연구)

  • 이인선
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 2001.04b
    • /
    • pp.40-42
    • /
    • 2001
  • 트랜잭션 로그 정보를 안전한 저장장치에 저장하는 것은 트랜잭션의 완료를 위한 필수 불가결한 요소이지만 시스템 성능에 커다란 저해 요인이 되고 있다. 이에 대한 개선책으로 선-완료(pre-commit), 그룹 완료(group commit)와 같은 방식들의 제안이 있었으나, 이 방식들을 시스템에 적용했을 경우, 특히 로깅이 평상시 트랜잭션 수행시간의 거의 대부분을 차지하는 메인 메모리 데이터베이스(MMDB) 시스템과 같은 환경에서의 구체적이고 다양한 논의가 아직 이루어지지 안고 있다. 본 논문에서는 MMDB시스템에 그를 완료를 적용할 때 발생할 수 있는 교착 상태에 대한 설명과 해결책을 제시하였고, 다각적인 모의실험을 실시하여 이전 논문들의 우려와는 달리 그룹 완료 방식이 전체 시 9853;메 성능뿐만 아니라 트랜잭션 수행시간 단축을 위해서도 매우 우수한 해결 방식이며, 선-완료 방식은 예상과 달리 그룹 완료 방식의 보조수단으로 병행될 때에만 시스템 성능에 추가적인 도움을 준다는 것을 보였다.다.

  • PDF

Proposal of Git's commit message classification model using GPT (GPT를 이용한 Git의 커밋메시지 분류모델 제안)

  • Ji-Hoon Choi;Jae-Woong Kim;Youn-Yeoul Lee;Yi-Geun Chae;Hyeon-Ho Seo
    • Proceedings of the Korean Society of Computer Information Conference
    • /
    • 2023.07a
    • /
    • pp.81-83
    • /
    • 2023
  • GIT의 커밋 메시지를 소프트웨어 유지보수 활동 세 가지로 분류하는 연구를 분석하고 정확도를 높일 수 있는 모델들을 분석하였고 관련 모델 중 커밋메시지와 변경된 소스를 같이 활용하는 연구들은 변경된 소스를 분석하기 위해 도구들을 대부분 활용하는데 대부분 특정 언어만 분류할 수 있는 한계가 있다. 본 논문에서는 소스 변경 데이터를 추출할 때 언어의 제약을 없애기 위해 GPT를 이용해 변경된 소스의 요약을 추출하는 과정을 추가함으로써 언어 제약의 한계를 극복할 수 있는 개선된 모델에 관한 연구를 진행하였다. 향후 본 연구 모델의 구현 및 검증을 진행하고 이를 이용해 프로젝트 진행에 활용할 수 있는 솔루션 개발 연구까지 확정해 나갈 예정이다.

  • PDF

An Efficient Recovery System for Spatial Main Memory DBMS (공간 메인 메모리 DBMS를 위한 효율적인 회복 시스템)

  • Kim, Joung-Joon;Ju, Sung-Wan;Kang, Hong-Koo;Hong, Dong-Sook;Han, Ki-Joon
    • Journal of Korea Spatial Information System Society
    • /
    • v.8 no.3
    • /
    • pp.1-14
    • /
    • 2006
  • Recently, to efficiently support the real-time requirements of LBS and Telematics services, interest in the spatial main memory DBMS is rising. In the spatial main memory DBMS, because all spatial data can be lost when the system failure happens, the recovery system is very important for the stability of the database. Especially, disk I/O in executing the log and the checkpoint becomes the bottleneck of letting down the total system performance. Therefore, it is urgently necessary to research about the recovery system to reduce disk I/O in the spatial main memory DBMS. In this paper, we study an efficient recovery system for the spatial main memory DBMS. First, the pre-commit log method is used for the decrement of disk I/O and the improvement of transaction concurrency. In addition, we propose the fuzzy-shadow checkpoint method for the recovery system of the spatial main memory DBMS. This method can solve the problem of duplicated disk I/O on the same page of the existing fuzzy-pingpong checkpoint method for the improvement of the whole system performance. Finally, we also report the experimental results confirming the benefit of the proposed recovery system.

  • PDF

A Split Synchronizable Mobile Transaction Processing Model for e-Business Applications in Ubiquitous Computing Environment (편재형 컴퓨팅 환경에서의 e-비즈니스 응용을 위한 분할 동기화 이동 트랜잭션 처리 모델)

  • Choi, Mi-Seon;Kim, Young-Kuk
    • The KIPS Transactions:PartD
    • /
    • v.11D no.4
    • /
    • pp.783-798
    • /
    • 2004
  • An e-business client application in ubiquitous mobile computing environment may become disconnected from the enterprise server due to broken communication connections caused by the limitation of mobile computing environments(limited battery life of the mobile device, low bandwidth communication, incomplete wireless communication infrastructure, etc). It Is even Possible that mobile client application Intentionally operates in disconnected mode to reduce communication cost and the power consumption of the mobile device. We use “data hoarding” as a means of providing local autonomy to allow transactions to be processed and committed on the mobile host despite of disconnection. The key problem to this approach is the synchronization problem that serialize potentially conflicting updates from disconnected clients on master objects of the server database. In this paper, we present a new transaction synchronizing method that splits a transaction into a set of independent component transactions and give the synchronization priority on each component taking the possibility of use and conflicts in the server into consideration. Synchronization is performed component by component based un synchronization priority. After the Preferred component of a no bile transaction succeeds in synchronization with the server, the mobile transaction can pre-commit at server. A pre-committed transaction's updated value is made visible at server before the final commit of the transaction. The synchronization of the component with low synchronization priority can be delayed in adaption to wireless bandwidth and computing resources. As a result, the availability of important data updated by mobile client is increased and it can maximize the utilization of the limited wireless bandwidth and computing resources.

The pre-hospital analysis of patients with suicide attempts in Gangwon-do (일개 도 지역 자살 시도 환자에 대한 병원전 단계 분석)

  • Kim, Gi Whan;Cho, Jun Hwi;Moon, Joong Bum;Park, Chan Woo;Shin, Myoung Cheol;Kim, Ka Eul;Lee, Joon Seok;Park, Yoon Soo;Ohk, Taek Geun
    • Journal of The Korean Society of Emergency Medicine
    • /
    • v.29 no.6
    • /
    • pp.687-698
    • /
    • 2018
  • Objective: This study examined the characteristics of suicidal attempters, including pre-hospital patients and those who visited the emergency department. Methods: Suicidal attempters who had been reported to the 119 call center were selected between July 2015 and June 2016. Sex, age, place, methods of suicidal attempt, season, time, and suicide success rate were reviewed in the fire center records. Results: A total 961 suicide attempters were enrolled. Among them, 53.6% were males who had an approximately 2.6 times higher mortality than that of females (9.2%). The most preferred place to commit suicide was the home in both sexes (68.0% in male, 82.8% in female) and the most preferred methods was drug intoxication, particularly pesticide. The method with the highest mortality was hanging and the lowest was self-harm. The season of the highest mortality was spring. The success of suicide and the time variation were similar. Most of the un-transferred patients also selected fatal suicide attempts compared to transfer patients. Conclusion: Unlike previous studies, this study includes information on un-transferred patients. Overall, the probability of death was highest as more than 50 years men chose hanging as a method, which had an influence on the un-transferred patients group.

Elementary School Teachers' Perceptions on the Use of Educational Programs in Science Museums (과학관 교육 프로그램 활용에 대한 초등학교 교사들의 인식)

  • Choi, Kyung-Hee;Chang, Hyun-Sook;Lee, Hyun-Ju
    • Journal of Korean Elementary Science Education
    • /
    • v.25 no.3
    • /
    • pp.331-337
    • /
    • 2006
  • This study examined the elementary school teachers' present utilization of science museums in teaching-learning and their perceptions of the educational programs in science museums. The results indicate that teachers have not utilized science museums as intimately as possible with formal instruction, therefore, the students' experiences of science museums are usually limited. The main reasons for lower than optimum usage of science museums in their teaching and learning is not because of its insignificant educational effects, but because of the lack of external and administrative support mechanisms. The elementary school teachers prefer to commit to programs in science museums such as science camps or experiment activities, and those exhibitions which have some kind of clear and discernable relation to the school curriculum. The results also indicate that most teachers want to participate in the various activities of science museums, such as developing and managing the programs or pre- and post activities for museum field trips, participating in the teachers' community in science museums, and so on.

  • PDF

Effect of Waste Transfer Stations on Collection Efficiency in Seoul (생활폐기물 적환장의 운영에 따른 수거효율성 분석)

  • Yoo, Kee-Young
    • Journal of the Korea Organic Resources Recycling Association
    • /
    • v.26 no.1
    • /
    • pp.13-19
    • /
    • 2018
  • 25 local districts in Seoul have been running Waste Transfer Stations(WTSs) to secure regional collection bases, to connect between collection systems and waste treatment systems, and to commit various pre-screening of mixed wastes. There were, however, few previous researches to define how much WTSs are beneficial to waste collection system at least in Korea. So this study analyzed costs of waste collection systems with varied haul distances from waste sources(WSs) to WTS or building types of WTSs. Major results showed that the closer WTS is to WS or the cheaper the construction cost of WTS is, the lower the cost of waste collection system is. There was an additional result that WTS system with more than 15 km of total haul distance might be useful in Seoul and encapsulation of WTS in building or underground will make effective total haul distances longer up to 35km.