专利名称：Method and system for generating SQL joins
to optimize performance
发明人：Robyn Lee Focazio,Kumar Marappan,Fabian
F. Morgan,Brent Russel Phillips
申请号：US10692166
申请日：20031023
公开号：US07539660B2
公开日：
20090526
专利内容由知识产权出版社提供
专利附图：
摘要：An automated method for creating only the necessary joins in a SQL query. The present invention comprises a Query Program (QP), a Query Generation Program (QGP),
and a Clause Generation Program (CGP). The QP accepts the query fields, filters, and sort criteria from the user, generates the query, sends the query to the database, and displays the query results. The QGP creates the query clause strings and inserts the strings into the SQL template. The QGP generates the SELECT, (filter) WHERE, and ORDER BY clauses. The QGP analyzes each parameter in a parameter list to determine if the parameter is on the added aliases list. If the parameter is not on the added aliases list, the QGP runs the CGP for the parameter. The CGP generates the FROM, JOIN, and (join) WHERE clauses and adds the clauses to the appropriate clause strings.
申请人：Robyn Lee Focazio,Kumar Marappan,Fabian F. Morgan,Brent Russel Phillips 地址：Round Rock TX US,Round Rock TX US,Austin TX US,Austin TX US
queryselectorall用法国籍：US,US,US,US
代理机构：Yee & Associates, P.C.
代理人：William H. Steinberg,Rudolf O. Siegesmund
更多信息请下载全文后查看

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。