基于QUICK IMS的关系数据库管理

Managing Relational Databases Based on QUICK IMS

本文采用ＢＯＲＬＡＮＤＩＤＡＰＩ关系数据库集成技术，集成多种关系数据库系统，并用信息存储与检索软件ＱＵＩＣＫＩＭＳ进行管理，实现对关系数据库的全文检索。对基于ＰＣ和基于ＳＱＬ的关系数据库数据结构、数据访问方式、数据类型进行集成；对基本表和单库或多库查询的结果进行转移，生成ＱＵＩＣＫＩＭＳ的必要文件和索引；对关系数据库提供布尔检索、前方一致检索、字段限定检索、相邻检索和位置检索等检索方式。采用动态转换关系数据库数据。

It is useful and meaningful to provide full text search on the Relational DataBase (RDB) in development and construction of Management Information System.In this paper the relational database integration technology of IDAPI is adopted to integrate the popular relational database management systems,the RDB is managed using information storage & retrieval system QUICK IMS to provide retrieval mechanism suitable for the information retrieval field such as full text search.This paper integrates the database schema,data accessing mechanism,data type of the PC based and SQL based relational databases,transforms the primary table or the result set of single database or multi database query,creates the necessary files and indexes to provide retrieval methods such as boolean search,right truncation search,fielded search and full text search.The paper distributes the data and index thus occupying less disk space.