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

1. 发明授权

US10489394B2 Database query calculation using an operator that explicitly removes group-by characteristics 有权
公开(公告)号：US10489394B2
公开(公告)日：2019-11-26
申请号：US15164432
申请日：2016-05-25
申请人： SAP SE
发明人： Sebastian Schroetel , Stefan Dipper , Michael Wilking , Christof Mueller
IPC分类号： G06F16/00 , G06F16/242 , G06F16/22 , G06F16/28 , G06F16/9535 , G06F16/2455
CPC分类号： G06F16/244 , G06F16/221 , G06F16/24556 , G06F16/283 , G06F16/9535
摘要： In one embodiment, a method receives a query for analyzing data in a database. The query includes a first level calculation that is performed before a second level calculation. When an operator associated with the first level calculation is present in the query, the method performs: calculating the first level calculation by removing group by information for a reference characteristic for the first level calculation to determine a first level calculation result and calculating the second level calculation using the first level calculation result using the group by information for the reference characteristic to determine a second level calculation result, wherein the group by in the second level calculation combines groups of rows in a database table of the database that have the same content in their specified columns.

2. 发明申请

US20160267129A1 Database Query Calculation Using an Operator that Explicitly Removes Group-By Characteristics 审中-公开
标题翻译：使用明确删除按组合特征的运算符进行数据库查询计算
公开(公告)号：US20160267129A1
公开(公告)日：2016-09-15
申请号：US15164432
申请日：2016-05-25
申请人： SAP SE
发明人： Sebastian Schroetel , Stefan Dipper , Michael Wilking , Christof Mueller
IPC分类号： G06F17/30
摘要： In one embodiment, a method receives a query for analyzing data in a database. The query includes a first level calculation that is performed before a second level calculation. When an operator associated with the first level calculation is present in the query, the method performs: calculating the first level calculation by removing group by information for a reference characteristic for the first level calculation to determine a first level calculation result and calculating the second level calculation using the first level calculation result using the group by information for the reference characteristic to determine a second level calculation result, wherein the group by in the second level calculation combines groups of rows in a database table of the database that have the same content in their specified columns.
摘要翻译：在一个实施例中，方法接收用于分析数据库中的数据的查询。该查询包括在第二级计算之前执行的第一级计算。当在查询中存在与第一级计算相关联的操作者时，该方法执行：通过移除用于第一级计算的参考特征的信息组来计算第一级计算，以确定第一级计算结果并计算第二级使用第一级计算结果使用用于参考特征的信息组进行计算，以确定第二级计算结果，其中第二级计算中的组合计算将数据库中具有相同内容的数据库表中的行组合他们指定的列。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式