首页>
外国专利>
System and method for improved processing of an SQL query made against a relational database
System and method for improved processing of an SQL query made against a relational database
展开▼
机译:用于改进对关系数据库的SQL查询的处理的系统和方法
展开▼
页面导航
摘要
著录项
相似文献
摘要
A system and method for improved processing of an SQL query made against a relational database is disclosed. In one example embodiment, the method includes parsing the SQL query, received against the relational database, to obtain each operator and associated one or more operands and sequence of execution of the operators. Further, it is determined whether all needed closure-friendly operators exist. Furthermore, any available closure-friendly operators are obtained from a pattern repository if all needed closure-friendly operators do not exist. In addition, remaining or all non-available closure-friendly operators are dynamically generated. Moreover, the available closure-friendly operators and the dynamically generated closure-friendly operators are grouped into one or more patterns and impact of each pattern on a queried relational database and a database schema is classified. Also, the SQL query is executed using the one or more patterns based on sequence of the execution of the operators.
展开▼