GUlベース連邦型データベースの開発と農業情報データの空間的・時間的統合への適用 [in Japanese] Integration of Heterogeneous Agricultural Information using GUI based Federated DBMS [in Japanese]
Access this Article
Search this Article
連邦型データベース（Federated Database Management System, 以下FDBMSと呼ぶ）は，自治的に管理された複数の異なるデータベースを統合するDBMSである．FDBMSは，情報科学分野でいくつか提案されているが，我々は，RDBのスキーマと属性値の変換をサポートすることにより異なるデータベースを統合するシステムを開発し，これを，時系列で仕様の異なる青果物市況データの統合及び，県によりスキーマの異なる農業技術体系データの統合に適用し，その実用性を確認した．
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.
- Agricultural Information Research
Agricultural Information Research 10(1), 37-52, 2001-05-31
Japanese Society of Agricultural Informatics