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

An Implementation Scheme of Relational Tables Based on History Offset Method and Its Evaluation

Research Project

Project/Area Number 17500065
Research Category

Grant-in-Aid for Scientific Research (C)

Allocation TypeSingle-year Grants
Section一般
Research Field Media informatics/Database
Research InstitutionUniversity of Fukui

Principal Investigator

TSUJI Tatsuo  University of Fukui, Graduate School of Engineering, Professor, 工学研究科, 教授 (80115302)

Co-Investigator(Kenkyū-buntansha) HIGUCHI Ken  University of Fukui, Graduate School of Engineering, Associate Professor, 工学研究科, 助教授 (50293410)
Project Period (FY) 2005 – 2006
Project Status Completed (Fiscal Year 2006)
Budget Amount *help
¥3,000,000 (Direct Cost: ¥3,000,000)
Fiscal Year 2006: ¥1,500,000 (Direct Cost: ¥1,500,000)
Fiscal Year 2005: ¥1,500,000 (Direct Cost: ¥1,500,000)
KeywordsMultidimensional Array / Extendible Array / Relational Table / Record Encoding / MOLAP
Research Abstract

In this year, based on the relational database kernel implemented by history offset method called HORT developed in the last year, schemes of higher level subsystems of relational database system have been designed, implemented and evaluated. These schemes include: 1. Processing scheme of range key queries, 2. Parallel processing scheme, 3. design and implementation of SQL processors, 4. Design of complex objects.
1. In our proposed scheme, since a record can be mapped to an element of a multidimensional extendible array and the element position is mapped to linear address space, dimension dependency problem would be caused in a range key retrieval. This problem has been alleviated by designing a scheme considering the characteristics of HORT data structure. Using the implemented prototype system, the performance of range key queries has been measured and evaluated.
2. An extendible array, which is the underlying data structure in HORT, is suited to parallel processing. Focusing on this good property of HORT, we have designed and implemented a load balancing scheme and synchronizing scheme of collecting retrieval results. Using the implemented prototype system, the performance of parallel retrieval scheme has been measured.
3. We are now under construction of SQL processor incorporating the range key query processing scheme in 1. Especially an efficient scheme of processing table join operation is being designed and implemented.
4. A complex object has an object ID of another object as its reference attribute. We have proposed an efficient handling scheme of complex objects set by introducing the notion of record ID into the original HORT data structure.

Report

(3 results)
  • 2006 Annual Research Report   Final Research Report Summary
  • 2005 Annual Research Report
  • Research Products

    (24 results)

All 2007 2006 2005

All Journal Article (23 results) Patent(Industrial Property Rights) (1 results)

  • [Journal Article] チャンク化拡張可能配列による関係テーブルの実装と評価2007

    • Author(s)
      相羽洋平
    • Journal Title

      電子情報通信学会データ工学ワークショップ論文集 A2-5

    • Description
      「研究成果報告書概要(和文)」より
    • Related Report
      2006 Annual Research Report 2006 Final Research Report Summary
  • [Journal Article] Implementation and Evaluation of Relational Tables Based on Chunked Extendible Arrays Proceedings of the 22nd International Conference on2007

    • Author(s)
      Yohei Aiba
    • Journal Title

      IEICE Data Engineering Workshop

    • Description
      「研究成果報告書概要(欧文)」より
    • Related Report
      2006 Final Research Report Summary
  • [Journal Article] Flexibly resizable multidimensional arrays2006

    • Author(s)
      Masakazu Kumakiri
    • Journal Title

      Proceedings of the 22nd International Conference on Data Engineering Workshops

      Pages: 83-88

    • Description
      「研究成果報告書概要(和文)」より
    • Related Report
      2006 Annual Research Report 2006 Final Research Report Summary
  • [Journal Article] An extendible multidimensional array system for MOLAP2006

    • Author(s)
      Tatsuo Tsuji
    • Journal Title

      Proceedings of ACM Applied Computing

      Pages: 503-510

    • Description
      「研究成果報告書概要(和文)」より
    • Related Report
      2006 Annual Research Report 2006 Final Research Report Summary
  • [Journal Article] 挿入拡張・中抜き縮小可能な多次元配列2006

    • Author(s)
      熊切正和
    • Journal Title

      日本データベース学会Letters 5-1

      Pages: 61-64

    • Description
      「研究成果報告書概要(和文)」より
    • Related Report
      2006 Annual Research Report 2006 Final Research Report Summary
  • [Journal Article] Containerization algorithms for multidimensional arrays2006

    • Author(s)
      Teppei Shimada
    • Journal Title

      Proceedings of Asian Simulation Conference

      Pages: 228-232

    • Description
      「研究成果報告書概要(和文)」より
    • Related Report
      2006 Annual Research Report 2006 Final Research Report Summary
  • [Journal Article] A parallel implementation scheme of relational tables based on multidimensional extendible arrays2006

    • Author(s)
      K.M.A.Hasan
    • Journal Title

      International Journal of Data Warehousing and Mining 2-4

      Pages: 66-85

    • Description
      「研究成果報告書概要(和文)」より
    • Related Report
      2006 Final Research Report Summary
  • [Journal Article] Flexibly resizable multidimensional arrays2006

    • Author(s)
      Masakazu Kumakiri
    • Journal Title

      Data Engineering Workshops

      Pages: 83-88

    • Description
      「研究成果報告書概要(欧文)」より
    • Related Report
      2006 Final Research Report Summary
  • [Journal Article] Multidimensional Arrays Enabling Insert Extensions and Delete Reductions2006

    • Author(s)
      Masakazu Kumakiri
    • Journal Title

      DBSJ Letters Vol. 5, No. 1

      Pages: 61-64

    • Description
      「研究成果報告書概要(欧文)」より
    • Related Report
      2006 Final Research Report Summary
  • [Journal Article] Containerization algorithms for multi- dimensional arrays2006

    • Author(s)
      Teppei Shimada
    • Journal Title

      Proceedings of Asian Simulation Conference

      Pages: 228-232

    • Description
      「研究成果報告書概要(欧文)」より
    • Related Report
      2006 Final Research Report Summary
  • [Journal Article] A parallel implementation scheme of relational tables based on multidimensional extendible arrays2006

    • Author(s)
      K.M.A.Hasan
    • Journal Title

      International Journal of Data Warehousing and Mining

      Pages: 66-85

    • Description
      「研究成果報告書概要(欧文)」より
    • Related Report
      2006 Final Research Report Summary
  • [Journal Article] A parallel implementation scheme of relational tables based on multidimensional extendible a2006

    • Author(s)
      K.M.A.Hasan
    • Journal Title

      International Journal Journal of Data Warehousing and Mining 2-4

      Pages: 66-85

    • Related Report
      2006 Annual Research Report
  • [Journal Article] 挿入拡張,中抜き縮小可能な多次元配列2006

    • Author(s)
      熊切正和
    • Journal Title

      電子情報通信学会データ工学ワークショップ論文集 3C-o1

    • Related Report
      2005 Annual Research Report
  • [Journal Article] チャンク化拡張可能配列による関係テーブルの実装2006

    • Author(s)
      黒田雅之
    • Journal Title

      電子情報通信学会データ工学ワークショップ論文集 3C-i6

    • Related Report
      2005 Annual Research Report
  • [Journal Article] An Implementation Scheme of Relational Tables2005

    • Author(s)
      Masayuki Kuroda
    • Journal Title

      Proc.of International Conference of Data Engineering Workshops 1244

    • Related Report
      2005 Annual Research Report
  • [Journal Article] An Efficient Parallel Retrieval for Complex Object Index2005

    • Author(s)
      Takeshi Horie
    • Journal Title

      Proc.of International Conference of Data Engineering Workshops 1268

    • Related Report
      2005 Annual Research Report
  • [Journal Article] A Distributed Object-Oriented Programming System with Dynamic Reconfiguration Capability2005

    • Author(s)
      Takeshi Horie
    • Journal Title

      International Journal of Computers and Applications 27・2

      Pages: 63-71

    • Related Report
      2005 Annual Research Report
  • [Journal Article] An Extendible Array Based Implementation of Relational Tables for Multidimensional Databases2005

    • Author(s)
      K.M.A.Hasan
    • Journal Title

      Proc.of International Conference on Data Warehousing and Knowledge Discovery

      Pages: 233-242

    • Related Report
      2005 Annual Research Report
  • [Journal Article] 柔軟にサイズ変更可能な多次元配列2005

    • Author(s)
      熊切正和
    • Journal Title

      電子情報通信学会技術研究報告 COMP2005-49

    • Related Report
      2005 Annual Research Report
  • [Journal Article] 経歴・オフセット法による関係テーブルの実装方式2005

    • Author(s)
      黒田雅之
    • Journal Title

      平成17年度電気関係学会北陸支部連合大会講演論文集 E-69

    • Related Report
      2005 Annual Research Report
  • [Journal Article] 経歴・オフセット法による複合オブジェクトの実装方式2005

    • Author(s)
      元井亮介
    • Journal Title

      平成17年度電気関係学会北陸支部連合大会講演論文集 E-71

    • Related Report
      2005 Annual Research Report
  • [Journal Article] MOLAPのための多次元配列システムの実装と評価2005

    • Author(s)
      嶋田鉄兵
    • Journal Title

      平成17年度電気関係学会北陸支部連合大会講演論文集 E-68

    • Related Report
      2005 Annual Research Report
  • [Journal Article] 経歴・オフセット法により実装された関係テーブルの分割管理2005

    • Author(s)
      相羽洋平
    • Journal Title

      平成17年度電気関係学会北陸支部連合大会講演論文集 E-70

    • Related Report
      2005 Annual Research Report
  • [Patent(Industrial Property Rights)] データベース装置,データベースの管理方法,データベースのデータ構造,データベースの管理プログラムおよびそれを記録したコンピュータ読み取り可能な記録媒体2005

    • Inventor(s)
      都司 達夫
    • Industrial Property Rights Holder
      福井大学
    • Filing Date
      2005-10-28
    • Related Report
      2005 Annual Research Report

URL: 

Published: 2005-04-01   Modified: 2016-04-21  

Information User Guide FAQ News Terms of Use Attribution of KAKENHI

Powered by NII kakenhi