首页>
外国专利>
Analytic enhancements to model clause in structured query language (SQL)
Analytic enhancements to model clause in structured query language (SQL)
展开▼
机译:对结构化查询语言(SQL)中的模型子句的分析增强
展开▼
页面导航
摘要
著录项
相似文献
摘要
A method for processing queries is provided. A database server receives and executes a query to generate a relation. The query comprises first one or more clauses and a model clause. The model clause comprises a rule that has a left-side expression and a right-side expression. In one embodiment, the right-side expression of the rule includes a window function, which specifies one or more partition columns. In an embodiment, the left-side expression comprises a for-loop predicate. The for-loop predicate is unfolded after the database server compiles the query. In one embodiment, the left-side expression of the rule comprises one or more existential predicates, where each existential predicate evaluates to a Boolean value.
展开▼