• Title/Summary/Keyword: transaction records

Search Result 71, Processing Time 0.026 seconds

Performance Evaluation of Conflict Detection Schemes for Concurrent Temporal Tranactions (시간지원 크랙잭션을 위한 충돌 검출 기법의 성능평가)

  • 구경이;하봉옥;김유성
    • Journal of KIISE:Software and Applications
    • /
    • v.26 no.1
    • /
    • pp.80-80
    • /
    • 1999
  • As Temporal DataBase Systems(TDBSs) manages both the historical versions and the current version of each data item, a temporal transaction may access more data records than atransaction in traditional database systems. Hence, the concurrency control subsystem of temporaldatabase management system should be able to correctly and efficiently detect actual conflicts amongconcurrent temporal transactions while the cost of detecting conflicts is maintained in low levelwithout detecting false conflicts which cause severe degradation of system throughput.In this paper, Two-Level Conflict Detection(TLCD) scheme is proposed for efficient conflictdetection between concurrent temporal transactions in TDBs. In the proposed TLCD scheme, sincechecking conflict between concurrent temporal transactions is performed at two levels, i, e., logicallevel and physical level, conflicts between concurrent temporal transactions are efficiently and correctlydetected,Furthermore, we also evaluate the performance of the proposed TLCD scheme with those oftraditional conflict detection schemes, logical-level conflict detection scheme and physical-level conflictdetection scheme by simulation approach, The result of the simulation study shows that the proposedTLCD scheme outperforms the previous conflict detection schemes with respect to the averageresponse time.

A Implementation of Blockchain based Manufacturing Supply Chain Tracking System (블록체인 기반 제조 공급망 추적 시스템 구현)

  • Lee, Jae-Ho;Nam, Ho-Ki
    • Journal of the Korea Safety Management & Science
    • /
    • v.19 no.4
    • /
    • pp.183-188
    • /
    • 2017
  • Block Chain is a technology that records and shares distributed ledgers without a central authority, providing a decentralized platform for transparent transactions in the business and enhancing transparency and traceability in all transactions to ensure trust in the transaction. Despite initial doubts about this technology, it is committed to adopting, adapting and improving the technology in a wide range of industries, including finance, government, security, logistics, food, medical, legal, and real estate. This study examines this technology, its applicability and potential benefits to the manufacturing supply chain. A tracking system of manufacturing supply chain to visualize transparency and traceability is implemented, and the conditions for adopting the technology in the manufacturing supply chain and the issues to be addressed are discussed.

The Relationship between Credit Accessibility and Job Creation: Empirical Evidence from Tra Vinh Province, Vietnam

  • NGUYEN, Ha Hong
    • The Journal of Asian Finance, Economics and Business
    • /
    • v.9 no.3
    • /
    • pp.303-309
    • /
    • 2022
  • The goal of this research is to examine how credit (loan) can help rural households in Tra Vinh province create jobs in the wake of the COVID-19 outbreak in Vietnam over the last two years. The authors performed a direct survey, using a questionnaire, with 300 customers who had loan records at the Tra Vinh VBSP branch under the loan programs. From January to April 2021, jobs will be available at 07 transaction offices in districts and cities (Cau Ngang; Duyen Hai, Tieu Can, Cang Long, Tra Vinh City, Chau Thanh, Tra Cu). Using the multivariate regression method, the research has found 12 factors affecting the ability to access the employment loan program: Age, Educational Level, Occupation of households, Income, Household land area, Asset, Loan, Interest rates, Loan procedures, Loan purpose, Credit relations. From the above research results, the authors have proposed solutions to improve the ability to access credit to create jobs for each subject group at Viet Nam Bank for Social Policies, Tra Vinh Province in the future.

Empirical Comparison of the Effects of Online and Offline Recommendation Duration on Purchasing Decisions: Case of Korea Food E-commerce Company

  • Qinglong Li;Jaeho Jeong;Dongeon Kim;Xinzhe Li;Ilyoung Choi;Jaekyeong Kim
    • Asia pacific journal of information systems
    • /
    • v.34 no.1
    • /
    • pp.226-247
    • /
    • 2024
  • Most studies on recommender systems to evaluate recommendation performances focus on offline evaluation methods utilizing past customer transaction records. However, evaluating recommendation performance through real-world stimulation becomes challenging. Moreover, such methods cannot evaluate the duration of the recommendation effect. This study measures the personalized recommendation (stimulus) effect when the product recommendation to customers leads to actual purchases and evaluates the duration of the stimulus personalized recommendation effect leading to purchases. The results revealed a 4.58% improvement in recommendation performance in the online environment compared with that in the offline environment. Furthermore, there is little difference in recommendation performance in offline experiments by period, whereas the recommendation performance declines with time in online experiments.

An Efficient Scheme of Performing Pending Actions for the Removal of Datavase Files (데이터베이스 파일의 삭제를 위한 미처리 연산의 효율적 수행 기법)

  • Park, Jun-Hyun;Park, Young-Chul
    • Journal of KIISE:Databases
    • /
    • v.28 no.3
    • /
    • pp.494-511
    • /
    • 2001
  • In the environment that database management systems manage disk spaces for storing databases directly, this paper proposes a correct and efficient scheme of performing pending actions for the removal of database files. As for performing pending actions, upon performing recovery, the recovery process must identify unperformed pending actions of not-yet-terminated transactions and then perform those actions completely. Making the recovery process identify those actions through the analysis of log records in the log file is the basic idea of this paper. This scheme, as an extension of the execution of transactions, fuzzy checkpoint, and recovery of ARIES, uses the following methods: First, to identify not-yet-terminated transactions during recovery, transactions perform pending actions after writing 'pa_start'log records that signify both the commit of transactions and the start of executing pending actions, and then write 'eng'log records. Second, to restore pending-actions-lists of not-yet-terminated transactions during recovery, each transaction records its pending-actions-list in 'pa_start'log record and the checkpoint process records pending-actions-lists of transactions that are decided to be committed in 'end_chkpt'log record. Third, to identify the next pending action to perform during recovery, whenever a page is updated during the execution of pending actions, transactions record the information that identifies the next pending action to perform in the log record that has the redo information against the page.

  • PDF

Issues of IPR Database Construction through Interdisciplinary Research (학제간 연구를 통한 IPR 데이터베이스 구축의 쟁점)

  • Kim, Dong Yong;Park, Young Chul
    • Journal of the Korea Convergence Society
    • /
    • v.8 no.8
    • /
    • pp.59-69
    • /
    • 2017
  • Humanities and social sciences researchers and database experts have teamed up to build a database of IPR materials prepared by the Institute of Pacific Relations (IPR). This paper presents the issues and solutions inherent in the database construction for ensuring the quality of IPR materials. For the accessibility of the database, we maintain the database on the Web so that researchers can access it via web browsers; for the convenience of the database construction, we provide an integrated interface that allows researchers to perform all tasks in it; for the completeness of IPR materials constructed, we support the responsible input and the responsible approval that identify responsibilities of each IPR material entered; and for the immediacy of the approval, we support an interactive approval process facilitating the input of researchers. We also use database design, query processing, transaction management, and search and sorting techniques to ensure the correctness of IPR materials entered. In particular, through concurrency control using existence dependency relationships between records, we ensure the correctness between the operating system files and their paths. Our future studies include content search, database download and upload, and copyright related work on IPR materials.

Research on Development of Support Tools for Local Government Business Transaction Operation Using Big Data Analysis Methodology (빅데이터 분석 방법론을 활용한 지방자치단체 단위과제 운영 지원도구 개발 연구)

  • Kim, Dabeen;Lee, Eunjung;Ryu, Hanjo
    • The Korean Journal of Archival Studies
    • /
    • no.70
    • /
    • pp.85-117
    • /
    • 2021
  • The purpose of this study is to investigate and analyze the current status of unit tasks, unit task operation, and record management problems used by local governments, and to present improvement measures using text-based big data technology based on the implications derived from the process. Local governments are in a serious state of record management operation due to errors in preservation period due to misclassification of unit tasks, inability to identify types of overcommon and institutional affairs, errors in unit tasks, errors in name, referenceable standards, and tools. However, the number of unit tasks is about 720,000, which cannot be effectively controlled due to excessive quantities, and thus strict and controllable tools and standards are needed. In order to solve these problems, this study developed a system that applies text-based analysis tools such as corpus and tokenization technology during big data analysis, and applied them to the names and construction terms constituting the record management standard. These unit task operation support tools are expected to contribute significantly to record management tasks as they can support standard operability such as uniform preservation period, identification of delegated office records, control of duplicate and similar unit task creation, and common tasks. Therefore, if the big data analysis methodology can be linked to BRM and RMS in the future, it is expected that the quality of the record management standard work will increase.

A Recovery Scheme of SSD-based Databases using Snapshot Log (스냅샷 로그를 사용한 SSD 기반 데이터베이스 복구 기법)

  • Lim, Seong-Chae
    • The Journal of the Institute of Internet, Broadcasting and Communication
    • /
    • v.19 no.4
    • /
    • pp.85-91
    • /
    • 2019
  • In this paper, we propose a new logging and recovery scheme that is suited for the high-performance transaction processing system base on flash memory storage. The proposed scheme is designed by considering flash's I/O characteristic of asymmetric costs between page update/read operations. That is, we substitute the costly update operation with writing and real-time usage of snapshot log, which is for the page-level physical redo. From this, we can avoid costly rewriting of a dirty page when it is evicted form a buffering pool. while supporting efficient revery procedure. The proposed scheme would be not lucrative in the case of HDD-based system. However, the proposed scheme offers the performance advance sush as a reduced number of updates and the fast system recovery time, in the case of flash storage such as SSD (solid state drive). Because the proposed scheme can easily be applied to existing systems by saving our snapshot records and ordinary log records together, our scheme can be used for improving the performance of upcoming SSD-based database systems through a tiny modification to existing REDO algorithms.

A Theoretical Study on the Implication of Substantial Harmonization between the eUCP and UCP (eUCP 적용원리의 규명과 신용장거래질서 확대 개편방안의 모색)

  • Kim, Ki-Sun
    • THE INTERNATIONAL COMMERCE & LAW REVIEW
    • /
    • v.25
    • /
    • pp.75-98
    • /
    • 2005
  • With the advent of new customs and practice of electronic records, the eUCP provides some useful guidance to accommodate the presentation of the paper documents electronically and also provides necessary rules to allow the UCP and eUCP to work together. There is no denying the fact that many of the UCP articles are not impacted by the presentation of electronic equivalent of paper documents, so the integrated application of the UCP and eUCP will be broad enough to allow for developing practice in this area. This study discusses some theoretical implication for efficient utilization of the global usages of letter of credit through the finding of optimal solution in the state of uncertainty caused by the electronic presentation of documents. This study suggest that the decision rules be developed to show how individuals choose optimal portfolio between the eUCP and the UCP that maximize their expected utility in letter of credit transaction, and also suggest that the optimal portfolio be determined at the point of tangency between the efficient trading line and the highest indifference curve in the mean-variance plane. This study finally recommends three rebuttable doctrines with regard to the relationship between the eUCP and UCP such as linkage characteristics, generation lap propensity, and homothetic application rule, which may be the critical standards for understanding of the integrated usages of the eUCP and UCP.

  • PDF

Big Data Analytics Case Study from the Marketing Perspective : Emphasis on Banking Industry (마케팅 관점으로 본 빅 데이터 분석 사례연구 : 은행업을 중심으로)

  • Park, Sung Soo;Lee, Kun Chang
    • Journal of Information Technology Services
    • /
    • v.17 no.2
    • /
    • pp.207-218
    • /
    • 2018
  • Recently, it becomes a big trend in the banking industry to apply a big data analytics technique to extract essential knowledge from their customer database. Such a trend is based on the capability to analyze the big data with powerful analytics software and recognize the value of big data analysis results. However, there exits still a need for more systematic theory and mechanism about how to adopt a big data analytics approach in the banking industry. Especially, there is no study proposing a practical case study in which big data analytics is successfully accomplished from the marketing perspective. Therefore, this study aims to analyze a target marketing case in the banking industry from the view of big data analytics. Target database is a big data in which about 3.5 million customers and their transaction records have been stored for 3 years. Practical implications are derived from the marketing perspective. We address detailed processes and related field test results. It proved critical for the big data analysts to consider a sense of Veracity and Value, in addition to traditional Big Data's 3V (Volume, Velocity, and Variety), so that more significant business meanings may be extracted from the big data results.