GUlベース連邦型データベースの開発と農業情報データの空間的・時間的統合への適用

Translated title of the contribution: Integration of Heterogeneous Agricultural Information using GUI based Federated DBMS

保田 正則, 南石 晃明

Research output: Contribution to journalArticle

Abstract

FDBMS (Federated Database Management System), a new trend of DBMS, are capable of integrating several heterogeneous databases, which are managed by their respective rules, for search and queries. FDBMS integrate databases without any changes to the individual databases nor any need to treate another database. Only a few FDBMS, among those recently proposed in the information science field, support heterogeneous attributes.<br>We have developed a new FDBMS applicable to relational databases, that supports conversions of both schemas and attribute values and thus creation of a global schema, an integration of schemas of individual databases. This FDBMS consists of a GUI support system and a query processor system. The GUI system helps the user produce a global schema. The query processor accepts an SQL statement querying the global schema, converts into several SQL statements querying local tables, and reports the results. This FDBMS trialed in two cases, and its validity has been proved.<br>Case 1:<br>"Vegetable and fruit market information databases covering different time periods" The databases have different identification code systems, since they relate to different time periods, and the data structures have also evolved. We performed integrated queries which involved DBs from several time periods.<br>Case 2:<br>"Farming System Databases from Different Prefectures" Again, the databases do not share the same schema, rather each has its own rules. We performed integrated queries for information commonly found in these databases without intruding on each DBs control of its local autonomy.
Original languageJapanese
Pages (from-to)37-52
Number of pages16
Journal農業情報研究
Volume10
Issue number1
DOIs
Publication statusPublished - May 31 2001

Fingerprint

Graphical user interfaces
Information science
Vegetables
Fruits

Cite this

GUlベース連邦型データベースの開発と農業情報データの空間的・時間的統合への適用. / 保田正則; 南石晃明.

In: 農業情報研究, Vol. 10, No. 1, 31.05.2001, p. 37-52.

Research output: Contribution to journalArticle

@article{cdf328c7cfd349779077e041ae7b10c5,
title = "GUlベース連邦型データベースの開発と農業情報データの空間的・時間的統合への適用",
abstract = "FDBMS (Federated Database Management System), a new trend of DBMS, are capable of integrating several heterogeneous databases, which are managed by their respective rules, for search and queries. FDBMS integrate databases without any changes to the individual databases nor any need to treate another database. Only a few FDBMS, among those recently proposed in the information science field, support heterogeneous attributes.We have developed a new FDBMS applicable to relational databases, that supports conversions of both schemas and attribute values and thus creation of a global schema, an integration of schemas of individual databases. This FDBMS consists of a GUI support system and a query processor system. The GUI system helps the user produce a global schema. The query processor accepts an SQL statement querying the global schema, converts into several SQL statements querying local tables, and reports the results. This FDBMS trialed in two cases, and its validity has been proved.Case 1:{"}Vegetable and fruit market information databases covering different time periods{"} The databases have different identification code systems, since they relate to different time periods, and the data structures have also evolved. We performed integrated queries which involved DBs from several time periods.Case 2:{"}Farming System Databases from Different Prefectures{"} Again, the databases do not share the same schema, rather each has its own rules. We performed integrated queries for information commonly found in these databases without intruding on each DBs control of its local autonomy.",
author = "正則 保田 and 晃明 南石",
year = "2001",
month = "5",
day = "31",
doi = "10.3173/air.10.37",
language = "Japanese",
volume = "10",
pages = "37--52",
journal = "農業情報研究",
issn = "0916-9482",
publisher = "農業情報学会",
number = "1",

}

TY - JOUR

T1 - GUlベース連邦型データベースの開発と農業情報データの空間的・時間的統合への適用

AU - 保田, 正則

AU - 南石, 晃明

PY - 2001/5/31

Y1 - 2001/5/31

N2 - FDBMS (Federated Database Management System), a new trend of DBMS, are capable of integrating several heterogeneous databases, which are managed by their respective rules, for search and queries. FDBMS integrate databases without any changes to the individual databases nor any need to treate another database. Only a few FDBMS, among those recently proposed in the information science field, support heterogeneous attributes.We have developed a new FDBMS applicable to relational databases, that supports conversions of both schemas and attribute values and thus creation of a global schema, an integration of schemas of individual databases. This FDBMS consists of a GUI support system and a query processor system. The GUI system helps the user produce a global schema. The query processor accepts an SQL statement querying the global schema, converts into several SQL statements querying local tables, and reports the results. This FDBMS trialed in two cases, and its validity has been proved.Case 1:"Vegetable and fruit market information databases covering different time periods" The databases have different identification code systems, since they relate to different time periods, and the data structures have also evolved. We performed integrated queries which involved DBs from several time periods.Case 2:"Farming System Databases from Different Prefectures" Again, the databases do not share the same schema, rather each has its own rules. We performed integrated queries for information commonly found in these databases without intruding on each DBs control of its local autonomy.

AB - FDBMS (Federated Database Management System), a new trend of DBMS, are capable of integrating several heterogeneous databases, which are managed by their respective rules, for search and queries. FDBMS integrate databases without any changes to the individual databases nor any need to treate another database. Only a few FDBMS, among those recently proposed in the information science field, support heterogeneous attributes.We have developed a new FDBMS applicable to relational databases, that supports conversions of both schemas and attribute values and thus creation of a global schema, an integration of schemas of individual databases. This FDBMS consists of a GUI support system and a query processor system. The GUI system helps the user produce a global schema. The query processor accepts an SQL statement querying the global schema, converts into several SQL statements querying local tables, and reports the results. This FDBMS trialed in two cases, and its validity has been proved.Case 1:"Vegetable and fruit market information databases covering different time periods" The databases have different identification code systems, since they relate to different time periods, and the data structures have also evolved. We performed integrated queries which involved DBs from several time periods.Case 2:"Farming System Databases from Different Prefectures" Again, the databases do not share the same schema, rather each has its own rules. We performed integrated queries for information commonly found in these databases without intruding on each DBs control of its local autonomy.

U2 - 10.3173/air.10.37

DO - 10.3173/air.10.37

M3 - 記事

VL - 10

SP - 37

EP - 52

JO - 農業情報研究

JF - 農業情報研究

SN - 0916-9482

IS - 1

ER -