发明名称 Constant mapping optimization in a database
摘要 A database server receives a query associated with a calculation scenario that defines a data flow model that includes one or more calculation nodes. Each calculation node defines one or more operations to execute on the database server, the database server comprising a column-oriented database. Thereafter, the database server instantiates the calculation scenario and executes the operations defined by the calculation nodes of the instantiated calculation scenario to result in a responsive data set having a result table with a row for each column in the column-oriented database implicated by the query having a constant value. The database server then provides the data set to the application server. Related apparatus, systems, methods, and articles are also described.
申请公布号 US9613094(B2) 申请公布日期 2017.04.04
申请号 US201314066496 申请日期 2013.10.29
申请人 SAP SE 发明人 Mindnich Tobias;Weyerhaeuser Christoph;Merx Johannes
分类号 G06F17/30 主分类号 G06F17/30
代理机构 Mintz Levin Cohn Ferris Glovsky and Popeo, P.C. 代理人 Mintz Levin Cohn Ferris Glovsky and Popeo, P.C.
主权项 1. A method comprising: receiving, at a database server, a query associated with a calculation scenario, wherein the query is received from a remote application server, wherein the calculation scenario defines a data flow model that includes one or more calculation nodes, wherein each calculation node defines one or more operations to execute on the database server, wherein the database server comprises a column-oriented database that includes at least a first constant column, and wherein each row of the first constant column has a same value; instantiating, by the database server, the calculation scenario; executing, by the database server, the operations defined by the calculation nodes of the instantiated calculation scenario, wherein the executing of the operations results in a responsive data set that includes a result table, wherein the result table includes a first row corresponding to the first constant column, when the first constant column is implicated by the query, and wherein the first row has the same value that is in each row of the first constant column; and transmitting, by the database server, the data set, wherein the data set is transmitted to the application server.
地址 Walldorf DE