会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 3. 发明授权
    • System and methodology for control of, and access and response to internet email from a wireless device
    • 用于控制和访问和响应来自无线设备的互联网电子邮件的系统和方法
    • US07376701B2
    • 2008-05-20
    • US10135031
    • 2002-04-29
    • Gautam BhargavaSlva V. Kumar
    • Gautam BhargavaSlva V. Kumar
    • G06F15/16G06F15/173
    • H04L67/327H04L29/06H04L51/066H04L51/14H04L51/38H04L67/04H04L69/329H04M1/72547
    • The invention discloses a system and method for access and response to Internet emails, from a wireless device. The system extracts the emails from multiple Internet email accounts and forwards them, on the basis of pre-defined filter settings of the user, to the user's wireless device. The filter settings comprise filter criteria for identifying whether a new mail is to be forwarded to the wireless device or not, and content selection criteria for identifying parts of the new email to be sent to the wireless device. The system also enables the user to reply to the emails in a transparent manner whereby the replied message from the wireless device appears to have originated from the email address. The system also enables the user to dynamically change the filter settings using multi-modal inputs from his/her wireless device.
    • 本发明公开了一种从无线设备访问和响应互联网电子邮件的系统和方法。 该系统从多个互联网电子邮件帐户提取电子邮件,并将其根据用户的预定义过滤器设置转发给用户的无线设备。 过滤器设置包括用于识别新邮件是否要转发到无线设备的过滤器标准,以及用于识别要发送到无线设备的新电子邮件的部分的内容选择标准。 该系统还使用户能够以透明的方式回复电子邮件,由此来自无线设备的回复消息似乎源自于电子邮件地址。 该系统还使用户能够使用他/她的无线设备的多模态输入来动态地改变滤波器设置。
    • 7. 发明授权
    • Method and apparatus for reordering complex SQL queries containing inner
and outer join operations
    • 重新排序包含内部和外部连接操作的复杂SQL查询的方法和装置
    • US5832477A
    • 1998-11-03
    • US856198
    • 1997-05-14
    • Gautam BhargavaPiyush GoelBalakrishna Ragmavendra Iyer
    • Gautam BhargavaPiyush GoelBalakrishna Ragmavendra Iyer
    • G06F17/30
    • G06F17/30463G06F17/30466Y10S707/99932
    • A method and apparatus for reordering complex SQL queries containing joins, outer and full outer joins. The method and apparatus first translates the query into a hypergraph representation. Required sets, conflict sets and preserved sets are then generated for the query hypergraph. Using the required sets, a plurality of plans are enumerated, wherein the plans represent associative re-orderings of relations in the query. SQL operators are selectively assigned to each of the enumerated plans using the conflict sets and/or preserved sets, so that the results from the plans are identical to the original query. A novel Modified General Outer Join (MGOJ) operator may be assigned to the root of a sub-tree, wherein the MGOJ operator is a compensation operator. The operator assignment is performed recursively for the root of each sub-tree in the plan. One of the enumerated plans (generally the most optimal) is then selected for execution.
    • 一种重新排序复杂SQL查询的方法和装置,它包含连接,外部和外部连接。 该方法和装置首先将查询翻译成超图表示。 然后为查询超图生成所需的集合,冲突集和保留集。 使用所需的集合,列举了多个计划,其中计划表示查询中的关系的关联重新排序。 使用冲突集和/或保留集合将SQL运算符选择性地分配给每个枚举的计划,以便计划的结果与原始查询相同。 可以将新颖的修改后的通用外部联接(MGOJ)运算符分配给子树的根,其中,MGOJ运算符是补偿运算符。 对于计划中每个子树的根,递归地执行运算符分配。 然后选择一个列举的计划(通常是最优)。
    • 8. 发明授权
    • Method and apparatus for executing complex SQL queries using projection
operations
    • 使用投影操作执行复杂SQL查询的方法和装置
    • US5752017A
    • 1998-05-12
    • US468647
    • 1995-06-05
    • Gautam BhargavaPiyush GoelBalakrishna Ragmavendra Iyer
    • Gautam BhargavaPiyush GoelBalakrishna Ragmavendra Iyer
    • G06F17/30
    • G06F17/30463G06F17/30466Y10S707/99932
    • A method and apparatus for reordering complex SQL queries containing joins, outer and full outer joins. The method and apparatus first translates the query into a hypergraph representation. Required sets, conflict sets and preserved sets are then generated for the query hypergraph. Using the required sets, a plurality of plans are enumerated, wherein the plans represent associative reorderings of relations in the query. SQL operators are selectively assigned to each of the enumerated plans using the conflict sets and/or preserved sets, so that the results from the plans are identical to the original query. A novel Modified General Outer Join (MGOJ) operator may be assigned to the root of a sub-tree, wherein the MGOJ operator is a compensation operator. The operator assignment is performed recursively for the root of each sub-tree in the plan. One of the enumerated plans (generally the most optimal) is then selected for execution.
    • 一种重新排序复杂SQL查询的方法和装置,它包含连接,外部和外部连接。 该方法和装置首先将查询翻译成超图表示。 然后为查询超图生成所需的集合,冲突集和保留集。 使用所需的集合,列举了多个计划,其中计划表示查询中关系的关联排序。 使用冲突集和/或保留集合将SQL运算符选择性地分配给每个枚举的计划,以便计划的结果与原始查询相同。 可以将新颖的修改后的通用外部联接(MGOJ)运算符分配给子树的根,其中,MGOJ运算符是补偿运算符。 对于计划中每个子树的根,递归地执行运算符分配。 然后选择一个列举的计划(通常是最优)。
    • 9. 发明授权
    • Reordering complex SQL queries containing inner and outer join
operations using hypergraphs and required sets
    • 使用超图和所需的集合重新排序包含内部和外部连接操作的复杂SQL查询
    • US5724568A
    • 1998-03-03
    • US464268
    • 1995-06-05
    • Gautam BhargavaPiyush GoelBalakrishna Ragmavendra Iyer
    • Gautam BhargavaPiyush GoelBalakrishna Ragmavendra Iyer
    • G06F17/30
    • G06F17/30463G06F17/30466Y10S707/99932
    • A method and apparatus for reordering complex SQL queries containing joins, outer and full outer joins. The method and apparatus first translates the query into a hypergraph representation. Required sets, conflict sets and preserved sets are then generated for the query hypergraph. Using the required sets, a plurality of plans are enumerated, wherein the plans represent associative reorderings of relations in the query. SQL operators are selectively assigned to each of the enumerated plans using the conflict sets and/or preserved sets, so that the results from the plans are identical to the original query. A novel Modified General Outer Join (MGOJ) operator may be assigned to the root of a sub-tree, wherein the MGOJ operator is a compensation operator. The operator assignment is performed recursively for the root of each sub-tree in the plan. One of the enumerated plans (generally the most optimal) is then selected for execution.
    • 一种重新排序复杂SQL查询的方法和装置,它包含连接,外部和外部连接。 该方法和装置首先将查询翻译成超图表示。 然后为查询超图生成所需的集合,冲突集和保留集。 使用所需的集合,列举了多个计划,其中计划表示查询中关系的关联排序。 使用冲突集和/或保留集合将SQL运算符选择性地分配给每个枚举的计划,以便计划的结果与原始查询相同。 可以将新颖的修改后的通用外部联接(MGOJ)运算符分配给子树的根,其中,MGOJ运算符是补偿运算符。 对于计划中每个子树的根,递归地执行运算符分配。 然后选择一个列举的计划(通常是最优)。