公开(公告)号：US20150095342A1

公开(公告)日：2015-04-02

申请号：US14381214

申请日：2012-12-27

申请人： GUANGDONG ELECTRONICS INDUSTRY INSTITUTE LTD.

发明人： Xiaolin Li ,  Yi Xie ,  Zhiwei Xu ,  Qiang Yue

IPC分类号： G06F17/30

CPC分类号： G06F16/31 ,  G06F16/2264 ,  G06F16/3341

摘要： A virtual table index mechanism and a method for a multi-attribute compound condition query relate to a field of computer application technology. The virtual table index mechanism for a multi-attribute compound condition query includes: an index manager; a condition analyzer; and a pre-execution engine. The present invention forms index key values corresponding to a plurality of attributes in a virtual table. When querying, a query condition for the virtual table is calculated. Referring to a key value index, whether a mapping physical table of the virtual table should be executed is independently pre judged according to the attributes, so as to ensure that query is applied only to a virtual sub-table satisfying a corresponding key value condition. The present invention is effective for multi-attribute compound condition query, and is suitable for indexing virtual tables.

摘要翻译： 虚拟表索引机制和多属性复合条件查询的方法涉及计算机应用技术领域。 多属性复合条件查询的虚拟表索引机制包括：索引管理器; 条件分析仪 和一个预执行引擎。 本发明形成与虚拟表中的多个属性对应的索引关键字值。 当查询时，计算虚拟表的查询条件。 参考密钥值索引，是否应该执行虚拟表的映射物理表是否根据属性被预先判断，以便确保仅将查询应用于满足相应密钥值条件的虚拟子表。 本发明对多属性复合条件查询有效，适用于索引虚拟表。