摘要 |
A system and method for automatically generating an SQL query without requiring a user to know SQL. A category hierarchy representing a relational database system is presented to the user, and the user can navigate through the hierarchy, combine categories, and restructure the hierarchy to identify a category of interest to the user. The user then selects the category and indicates that a query should be generated based thereon. Query predicates are first generated, based on the type of category selected, and then a "from" query clause and "select" query clause are generated.
|