AUTOMATIC GENERATING METHOD FOR DATABASE QUERY STATEMENT, AND DATA TABLE STRUCTURE

摘要

PROBLEM TO BE SOLVED: To provide the table structure of a general relational database which does not depend upon application data, and an automatic preparation method for a database query statement using the structure.;SOLUTION: The automatic preparing method for the database query statement (SQL statement) has a step of generalizing the table structure of the relational database, a step of defining the mapping between data in the relational database generated according to the generalized table structure and application data, and a step of generating the SQL statement by making the syntax of the mapping definition correspond to SQL syntax. Here, the table structure is generalized by providing a parent field 11 showing an item of a master record as a field prescribing the parental relation between records.;COPYRIGHT: (C)2002,JPO