专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明申请

WO2016118783A1 QUERYING ACROSS A COMPOSITE JOIN OF MULTIPLE DATABASE TABLES USING A SEARCH ENGINE INDEX 审中-公开
标题翻译：使用搜索引擎索引来查询多个数据库表的复合数据
公开(公告)号：WO2016118783A1
公开(公告)日：2016-07-28
申请号：PCT/US2016/014383
申请日：2016-01-21
申请人： ATTIVIO, INC.
发明人： SMITH, Timothy
IPC分类号： G06F7/00 , G06F17/00 , G06N5/04
CPC分类号： G06F17/3087 , G06F17/30498 , G06F17/30613 , G06F17/30657
摘要： A computer system executes a user-supplied query across multiple relational database tables linked by a common key. A new query form, called a composite join, takes a user-supplied query including one or more terms optionally joined by logical operations, an identification of two or more tables and an identification of a common join key shared across the tables. The composite join applies the query across the tables such that any of the query terms can be matched by any of the tables. A query is performed across all tables for each query term and any join keys associated with matching records from the tables are identified in a set of join keys associated with the respective term. The logical operations are then performed on the resulting sets of join keys to combine the results of the term queries according to the user query.
摘要翻译：计算机系统通过由公共密钥链接的多个关系数据库表执行用户提供的查询。称为复合连接的新查询表单接受用户提供的查询，包括一个或多个可选择通过逻辑操作连接的术语，两个或多个表的标识以及跨表共享的公共连接密钥的标识。复合连接通过表应用查询，使得任何查询项可以被任何表匹配。在每个查询项的所有表中执行查询，并且与与各个项相关联的一组连接密钥中的表中识别与来自表的匹配记录相关联的任何连接密钥。然后对所生成的连接密钥集执行逻辑操作，以根据用户查询组合术语查询的结果。

IPRDB

热门服务

关于我们

友情链接

联系方式