Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2007-05-09
2010-02-23
Jalil, Neveen Abel (Department: 2165)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000
Reexamination Certificate
active
07668818
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.
REFERENCES:
patent: 6182060 (2001-01-01), Hedgcock et al.
patent: 2004/0073546 (2004-04-01), Forster et al.
patent: 2004/0158560 (2004-08-01), Wen et al.
patent: 2004/0249808 (2004-12-01), Azzam et al.
patent: 2004/0260691 (2004-12-01), Desai et al.
Ganski, Richard; Optimization of Nested SQL Queries Revisted, 1987; ACM; 1-11.
Hou Xue Qiao
Hu Gang
Liu Tao
Qian Qian
Abel Jalil Neveen
Gibb I.P. Law Firm LLC
International Business Machines - Corporation
Mincey Jermaine
LandOfFree
Database query language transformation method,... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Database query language transformation method,..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Database query language transformation method,... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4198721