发明名称 Managing expressions in a database system
摘要 A method for managing expressions includes receiving a first query that includes a first conditional expression. The first expression is then represented as data in a column of a table. A second query is received that specifies a first set of criteria, and the second query is executed to select data based at least on whether expressions in the column satisfy the first set of criteria. In an embodiment, the second query further specifies a second set of criteria, wherein executing the second query includes selecting data based on whether data in columns other than the expression column satisfy the second criteria. A special index is defined, which can be created on the column that stores the expressions as data, to filter large sets of expressions efficiently. A method of evaluating an expression set stored as data in a table classifies each predicate from each expression, and filters the expression set based on the predicate classification.
申请公布号 US7127467(B2) 申请公布日期 2006.10.24
申请号 US20020254383 申请日期 2002.09.24
申请人 ORACLE INTERNATIONAL CORPORATION 发明人 YALAMANCHI ARAVIND;GAWLICK DIETER;SRINIVASAN JAGANNATHAN
分类号 G06F17/30 主分类号 G06F17/30
代理机构 代理人
主权项
地址