DATABASE QUERY LANGUAGE TRANSFORMATION METHOD, TRANSFORMATION APPARATUS AND DATABASE QUERY SYSTEM
First Claim
1. A method for transforming a concept-based query into SQL query statements, comprising the steps of:
- transforming an inputted concept-based query into logic rules;
checking validity of said logic rules;
optimizing logic rules that are valid; and
translating optimized logic rules into SQL query statements.
1 Assignment
0 Petitions
Accused Products
Abstract
The present invention provides a method for transforming a concept-based query into SQL query statements, comprising the steps of: transforming inputted concept-based queries into logic rules; checking validity of the logic rules; optimizing the valid logic rules; and translating the logic rules into SQL query statements in accordance with the optimization result. The present invention further provides corresponding transformation engine, database query system and computer program product. The present invention facilitates people to use more descriptive query language to query data stored in relational database. Furthermore, the present invention can automatically generate the correct and efficient SQL query statements so that people'"'"'s efforts to deal with complex data model are saved significantly.
-
Citations
21 Claims
-
1. A method for transforming a concept-based query into SQL query statements, comprising the steps of:
-
transforming an inputted concept-based query into logic rules; checking validity of said logic rules; optimizing logic rules that are valid; and translating optimized logic rules into SQL query statements. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A transformation apparatus for transforming a concept-based query into SQL query statements, comprising:
-
a transformer for transforming an inputted concept-based query into logic rules; a checker for checking validity of the logic rules outputted from said transformer; an optimizer for optimizing the logic rules that have been checked to be valid by said checker; and a translator for translating optimized logic rules into SQL query statements. - View Dependent Claims (12, 13, 14, 15, 16, 17, 18, 19, 20)
-
-
21. A computer program product containing computer program codes for implementing a method further comprising:
-
transforming an inputted concept-based query into logic rules; checking validity of said logic rules; optimizing logic rules that are valid; and translating optimized logic rules into SQL query statements.
-
Specification