公开(公告)号：US09122678B2

公开(公告)日：2015-09-01

申请号：US13705580

申请日：2012-12-05

Applicant: Business Objects Software Ltd.

Inventor： Joseph Wong

IPC: G06F17/30

CPC classification number: G06F17/30002 ,  G06F17/30324 ,  G06F17/3069

Abstract: The suggestions of objects in a real-time collaboration tool can be accomplished by first forming a first vector representing an object utilized in the real-time collaboration tool. The vector can then be compared to a plurality of vectors representing a plurality of objects stored in a database to locate one or more vectors similar to the first vector. One or more of the plurality of objects stored in the database can be recommended to a user of the real-time collaboration tool based on the comparing.

Abstract translation: 可以通过首先形成表示实时协作工具中使用的对象的第一向量来实现实时协作工具中的对象的建议。 然后可以将向量与表示存储在数据库中的多个对象的多个向量进行比较，以定位与第一向量类似的一个或多个向量。 基于比较，可以向实时协作工具的用户推荐存储在数据库中的多个对象中的一个或多个。

公开(公告)号：US20140181073A1

公开(公告)日：2014-06-26

申请号：US13721601

申请日：2012-12-20

Applicant: BUSINESS OBJECTS SOFTWARE LTD.

Inventor： Joseph Wong

IPC: G06F17/30

CPC classification number: G06F17/30466 ,  G06F17/30436

Abstract: A method and system of transforming a query at a web server are provided. An abstract syntax tree representing the query can be traversed from the top down, for each node in the abstract syntax tree: labeling the node as being in a conjunct position when the node's parent is a WHERE node; labeling the node as being not in a conjunct position when the node's parent is an OR node; and labeling the node identically to the node's parent node when the node's parent is an AND node. Then any IN node in the abstract syntax tree can be transformed to an INNER JOIN node when the IN node is labeled as being in a conjunct position. The abstract syntax tree can be converted into a Structured Query Language (SQL) query, which can then be passed to a database for processing.

Abstract translation: 提供了一种在Web服务器上转换查询的方法和系统。 代表查询的抽象语法树可以从上到下遍历抽象语法树中的每个节点：当节点的父节点为WHERE节点时，将节点标记为处于连接位置; 当节点的父节点为OR节点时，将节点标记为不在连接位置; 并且当节点的父节点是AND节点时，将节点与节点的父节点相同地标记。 然后，当IN节点被标记为处于连接位置时，抽象语法树中的任何IN节点都可以转换为INNER JOIN节点。 抽象语法树可以转换成结构化查询语言（SQL）查询，然后将其传递给数据库进行处理。

公开(公告)号：US20140156688A1

公开(公告)日：2014-06-05

申请号：US13705580

申请日：2012-12-05

Applicant: BUSINESS OBJECTS SOFTWARE LTD.

Inventor： Joseph Wong

IPC: G06F17/30

CPC classification number: G06F17/30002 ,  G06F17/30324 ,  G06F17/3069

Abstract: The suggestions of objects in a real-time collaboration tool can be accomplished by first forming a first vector representing an object utilized in the real-time collaboration tool. The vector can then be compared to a plurality of vectors representing a plurality of objects stored in a database to locate one or more vectors similar to the first vector. One or more of the plurality of objects stored in the database can be recommended to a user of the real-time collaboration tool based on the comparing.

Abstract translation: 可以通过首先形成表示实时协作工具中使用的对象的第一向量来实现实时协作工具中的对象的建议。 然后可以将向量与表示存储在数据库中的多个对象的多个向量进行比较，以定位与第一向量类似的一个或多个向量。 基于比较，可以向实时协作工具的用户推荐存储在数据库中的多个对象中的一个或多个。