Summary: | 碩士 === 國立中正大學 === 資訊工程所 === 98 === As the amount of information grows exponentially in the information, it becomes more crucial for the users to have good DBMS tools to organize and manage their information more efficiently. The standardization of the SQL (Structured Query Language) allows the users to use a standard query language to access their data in different database systems, regardless of the difference of physical operation among the database systems.
GAISDB is a database management system using a set of DB managing tools. It’s light weight, flexible and easy to use and is suitable for small scale DB applications. However, GAISDB does not support SQL and is not compatible with other DBMS. In this thesis, we develop a SQL processor for GAISDB system. By parsing the SQL query and translating it into a set of GAISDB commands, it obtains the intermediate result from the execution of the GAISDB tools, and then processes it to get the final result. We provide GAIS record format as well as XML format in the result output. We enhance the GAISDB tools to be able to import DB data in XML format from other DBMS systems. We also enhance the GAISDB query processing tool to allow for multiple-fields matching mode, and add a new tool to update specific fields in GAISDB records.
|