• Search Research Projects
  • Search Researchers
  • How to Use
  1. Back to previous page

Study of database lump-sum update method during online processing

Research Project

Project/Area Number 24500132
Research Category

Grant-in-Aid for Scientific Research (C)

Allocation TypeMulti-year Fund
Section一般
Research Field Media informatics/Database
Research InstitutionShizuoka Institute of Science and Technology

Principal Investigator

KUDO Tsukasa  静岡理工科大学, 総合情報学部, 教授 (90583782)

Research Collaborator IWATA Chikara  
ARAI Kazuya  
HARADA Kengo  
YOSHINAGA Yutaka  
Project Period (FY) 2012-04-01 – 2015-03-31
Project Status Completed (Fiscal Year 2014)
Budget Amount *help
¥5,200,000 (Direct Cost: ¥4,000,000、Indirect Cost: ¥1,200,000)
Fiscal Year 2014: ¥1,040,000 (Direct Cost: ¥800,000、Indirect Cost: ¥240,000)
Fiscal Year 2013: ¥2,340,000 (Direct Cost: ¥1,800,000、Indirect Cost: ¥540,000)
Fiscal Year 2012: ¥1,820,000 (Direct Cost: ¥1,400,000、Indirect Cost: ¥420,000)
Keywordsデータベース / トランザクション / 同時実行制御 / バッチ処理 / 計算機システム / データストレージ / データベース(DBMS) / 情報システム / 並列処理・分散処理
Outline of Final Research Achievements

There was the problem that the lump-sum update to a large amount of data in the database could not be executed as a transaction in the case where the entries from online terminals were executed concurrently with it. In this study, we proposed an update method: it utilized the concept of the time that the fact had existed in the database, and we expanded the time into the future for this method. And, based on this concept, the update from the online terminal is executed to the data of the current time; the lump-sum update queries the data of the past time and stores its update results into the future time. Therefore, the conflicts between the both can be avoided. Furthermore, we composed the prototypes implementing this method and confirmed the validity of it by the experiments.

Report

(4 results)
  • 2014 Annual Research Report   Final Research Report ( PDF )
  • 2013 Research-status Report
  • 2012 Research-status Report
  • Research Products

    (19 results)

All 2015 2014 2013 2012 Other

All Journal Article (2 results) (of which Peer Reviewed: 2 results,  Open Access: 1 results,  Acknowledgement Compliant: 1 results) Presentation (12 results) Book (1 results) Remarks (4 results)

  • [Journal Article] Application of a Lump-sum Update Method to Distributed Database2014

    • Author(s)
      Tsukasa Kudo et al.
    • Journal Title

      International Journal of Informatics Society

      Volume: Vol. 6, No. 1 Pages: 11-18

    • Related Report
      2014 Annual Research Report
    • Peer Reviewed / Open Access / Acknowledgement Compliant
  • [Journal Article] Evaluation of Lump-sum Update Methods for Nonstop Service System2013

    • Author(s)
      Tsukasa Kudo et al.
    • Journal Title

      International Journal of Informatics Society

      Volume: Vol. 5, No. 1 Pages: 21-28

    • Related Report
      2013 Research-status Report
    • Peer Reviewed
  • [Presentation] 人間の経験知を反映した輸送運賃計算システムの構築と評価2015

    • Author(s)
      岩田力
    • Organizer
      情報処理学会第77 回全国大会
    • Place of Presentation
      京都大学(京都)
    • Year and Date
      2015-03-17 – 2015-03-19
    • Related Report
      2014 Annual Research Report
  • [Presentation] ビッグデータを活用した所要量計算システムの提案2015

    • Author(s)
      新井一也
    • Organizer
      情報処理学会第77 回全国大会
    • Place of Presentation
      京都大学(京都)
    • Year and Date
      2015-03-17 – 2015-03-19
    • Related Report
      2014 Annual Research Report
  • [Presentation] An implementation of concurrency control between batch update and online entries2014

    • Author(s)
      Tsukasa Kudo
    • Organizer
      Knowledge-Based and Intelligent Information & Engineering Systems 18th Annual Conference, KES-2014
    • Place of Presentation
      グディニャ(ポーランド)
    • Year and Date
      2014-09-15 – 2014-09-17
    • Related Report
      2014 Annual Research Report
  • [Presentation] Implementation and Evaluations of Recovery Method for Batch Update2014

    • Author(s)
      Tsukasa Kudo
    • Organizer
      International Workshop on Informatics (IWIN2014)
    • Place of Presentation
      プラハ(チェコ)
    • Year and Date
      2014-09-10 – 2014-09-12
    • Related Report
      2014 Annual Research Report
  • [Presentation] バッチ更新とオンライン入力の同時実行制御方式 ~実装と評価~2014

    • Author(s)
      工藤司
    • Organizer
      電子情報通信学会ソフトウェアインタプライズモデリング研究会
    • Place of Presentation
      機会振興会館(東京)
    • Year and Date
      2014-05-23
    • Related Report
      2014 Annual Research Report
  • [Presentation] Application of a Lump-sum Update Method to Distributed Database2013

    • Author(s)
      Tsukasa Kudo
    • Organizer
      International Workshop on Informatics (IWIN2013)
    • Place of Presentation
      ストックホルム(スウェーデン)
    • Related Report
      2013 Research-status Report
  • [Presentation] A Study of Long Time Transaction2013

    • Author(s)
      Tsukasa Kudo
    • Organizer
      Symposium on Advanced Information Systems (SAIS2013)
    • Place of Presentation
      コペンハーゲン(デンマーク)
    • Related Report
      2013 Research-status Report
  • [Presentation] A Mass Data Update Method in Distributed Systems2013

    • Author(s)
      Tsukasa Kudo
    • Organizer
      17th International Conference in Knowledge Based and Intelligent Information and Engineering Systems - KES2013
    • Place of Presentation
      北九州
    • Related Report
      2013 Research-status Report
  • [Presentation] 履歴に基づく当選確率を採用した即時抽選システムの提案2013

    • Author(s)
      原田健吾
    • Organizer
      情報処理学会
    • Place of Presentation
      東北大学 (仙台)
    • Related Report
      2012 Research-status Report
  • [Presentation] ノンストップサービス・システムにおける移行方式の提案2013

    • Author(s)
      吉永豊
    • Organizer
      情報処理学会
    • Place of Presentation
      東北大学 (仙台)
    • Related Report
      2012 Research-status Report
  • [Presentation] Evaluation of Lump-sum Update Methods for Nonstop Service System2012

    • Author(s)
      Tsukasa Kudo
    • Organizer
      Informatics Society
    • Place of Presentation
      シャモニ (フランス)
    • Related Report
      2012 Research-status Report
  • [Presentation] A batch Update Method of Database for Mass Data during Online Entry2012

    • Author(s)
      Tsukasa Kudo
    • Organizer
      KES International
    • Place of Presentation
      サン・セバスチャン (スペイン)
    • Related Report
      2012 Research-status Report
  • [Book] Advances in Knowledge-Based and Intelligent Information and Engineering Systems2012

    • Author(s)
      (Editor) Manuel Grana, Carlos Toro, Jorge Posada, Robert J. Howlett, Lakhmi C. Jain
    • Total Pages
      2273
    • Publisher
      Ios Press Inc.
    • Related Report
      2012 Research-status Report
  • [Remarks] 経営情報システム研究室

    • URL

      http://matsudalab.office-server.co.jp/sist_ci/index.html#slide14

    • Related Report
      2014 Annual Research Report
  • [Remarks] 経営情報システム研究室

    • URL

      http://matsudalab.office-server.co.jp/sist_ci/index.html#slide14

    • Related Report
      2013 Research-status Report
  • [Remarks] 履歴に基づく当選確率を採用した即時抽選システムの提案

    • URL

      http://www.sist.ac.jp/~kudo/graduate/2013/harada.pdf

    • Related Report
      2012 Research-status Report
  • [Remarks] ノンストップサービス・システムにおける移行方式の提案

    • URL

      http://www.sist.ac.jp/~kudo/graduate/2013/yoshinaga.pdf

    • Related Report
      2012 Research-status Report

URL: 

Published: 2013-05-31   Modified: 2019-07-29  

Information User Guide FAQ News Terms of Use Attribution of KAKENHI

Powered by NII kakenhi