发明名称 System and method for query by category
摘要 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.
申请公布号 US6598042(B1) 申请公布日期 2003.07.22
申请号 US20000677084 申请日期 2000.09.29
申请人 INTERNATIONAL BUSINESS MACHINES CORPORATION 发明人 KIENAN GERALD GEORGE
分类号 G06F17/30;(IPC1-7):G06F17/30 主分类号 G06F17/30
代理机构 代理人
主权项
地址