-
公开(公告)号:US20240311371A1
公开(公告)日:2024-09-19
申请号:US18674387
申请日:2024-05-24
Applicant: SAP SE
Inventor: Colin FLORENDO , Surendra Vishnoi , Janardhan Hungund , Manuel Caroli
IPC: G06F16/23 , G06F3/06 , G06F9/48 , G06F12/02 , G06F12/0875 , G06F12/0882 , G06F16/22 , G06F16/2455
CPC classification number: G06F16/2379 , G06F3/0604 , G06F3/064 , G06F3/0673 , G06F9/4843 , G06F12/0223 , G06F12/0246 , G06F12/0875 , G06F12/0882 , G06F16/221 , G06F16/2219 , G06F16/2228 , G06F16/2237 , G06F16/2255 , G06F16/2272 , G06F16/2282 , G06F16/24552 , G06F16/24558 , G06F2212/1024 , G06F2212/1044
Abstract: Disclosed herein are system, method, and computer program product embodiments for maintaining of a geometric object in a database. An embodiment operates by a database maintaining a first page storing a data block in the database's on-disk store such that the data block stores at least one byte of the geometric object. After receiving the request for the geometric object, the database loads the page storing the geometric object in the in-memory store and determines the size of the geometric object. Based on the size of the geometric object, the database stores the geometric object in the in-memory store directly or in a heap of the in-memory store.
-
公开(公告)号:US20190317939A1
公开(公告)日:2019-10-17
申请号:US16274903
申请日:2019-02-13
Applicant: SAP SE
Inventor: Manuel Caroli , Aleksei Burlakov
IPC: G06F16/2455 , G06F16/185 , G06F16/22 , G06F16/2457
Abstract: A method may include generating, based on a representation of a hierarchy stored in a database, a visiting sequence data structure. The hierarchy may be stored in a table in the database. Each of a plurality of rows comprising the table may correspond to one of a plurality of nodes comprising the hierarchy. The visiting sequence data structure may include a row vector specifying an order for traversing the plurality of nodes in the hierarchy. A hierarchical window function may be executed by iterating through the plurality of rows in the table in accordance with the order specified by the row vector. The execution of the hierarchical window function may further include determining, for a first node in the hierarchy, a summary value corresponding to a first value of the first node and a second value of a second node descendent from the first node.
-
公开(公告)号:US12019622B2
公开(公告)日:2024-06-25
申请号:US18216218
申请日:2023-06-29
Applicant: SAP SE
Inventor: Colin Florendo , Surendra Vishnoi , Janardhan Hungund , Manuel Caroli
IPC: G06F3/06 , G06F9/48 , G06F12/02 , G06F12/0875 , G06F12/0882 , G06F16/22 , G06F16/23 , G06F16/2455
CPC classification number: G06F16/2379 , G06F3/0604 , G06F3/064 , G06F3/0673 , G06F9/4843 , G06F12/0223 , G06F12/0246 , G06F12/0875 , G06F12/0882 , G06F16/221 , G06F16/2219 , G06F16/2228 , G06F16/2237 , G06F16/2255 , G06F16/2272 , G06F16/2282 , G06F16/24552 , G06F16/24558 , G06F2212/1024 , G06F2212/1044
Abstract: Disclosed herein are system, method, and computer program product embodiments for maintaining of a geometric object in a database. An embodiment operates by a database maintaining a first page storing a data block in the database's on-disk store such that the data block stores at least one byte of the geometric object. After receiving the request for the geometric object, the database loads the page storing the geometric object in the in-memory store and determines the size of the geometric object. Based on the size of the geometric object, the database stores the geometric object in the in-memory store directly or in a heap of the in-memory store.
-
公开(公告)号:US11544267B2
公开(公告)日:2023-01-03
申请号:US16274903
申请日:2019-02-13
Applicant: SAP SE
Inventor: Manuel Caroli , Aleksei Burlakov
IPC: G06F16/2455 , G06F16/22 , G06F16/2457 , G06F16/185
Abstract: A method may include generating, based on a representation of a hierarchy stored in a database, a visiting sequence data structure. The hierarchy may be stored in a table in the database. Each of a plurality of rows comprising the table may correspond to one of a plurality of nodes comprising the hierarchy. The visiting sequence data structure may include a row vector specifying an order for traversing the plurality of nodes in the hierarchy. A hierarchical window function may be executed by iterating through the plurality of rows in the table in accordance with the order specified by the row vector. The execution of the hierarchical window function may further include determining, for a first node in the hierarchy, a summary value corresponding to a first value of the first node and a second value of a second node descendent from the first node.
-
公开(公告)号:US20200320108A1
公开(公告)日:2020-10-08
申请号:US16374142
申请日:2019-04-03
Applicant: SAP SE
Inventor: Manuel Caroli
Abstract: Described herein are systems and method for mapping data points in a spatial data set. In some embodiments, a hexagon grid can be defined for mapping a plurality of data points in a spatial data set. Location information can be specified for each hexagon in the hexagon grid. The specifying can include calculating, for each hexagon, a first location of a first vertex and a second location of a second vertex. A rectangular grid including a plurality of rectangular cells can be mapped to the hexagon grid. A location of a data point of the plurality of data points can be determined relative to a first hexagon of the hexagon grid.
-
公开(公告)号:US11726985B2
公开(公告)日:2023-08-15
申请号:US16890020
申请日:2020-06-02
Applicant: SAP SE
Inventor: Colin Florendo , Surendra Vishnoi , Janardhan Hungund , Manuel Caroli
IPC: G06F16/22 , G06F16/23 , G06F12/02 , G06F3/06 , G06F12/0882 , G06F16/2455 , G06F12/0875 , G06F9/48
CPC classification number: G06F16/2379 , G06F3/0604 , G06F3/064 , G06F3/0673 , G06F9/4843 , G06F12/0223 , G06F12/0246 , G06F12/0875 , G06F12/0882 , G06F16/221 , G06F16/2219 , G06F16/2228 , G06F16/2237 , G06F16/2255 , G06F16/2272 , G06F16/2282 , G06F16/24552 , G06F16/24558 , G06F2212/1024 , G06F2212/1044
Abstract: Disclosed herein are system, method, and computer program product embodiments for maintaining of a geometric object in a database. An embodiment operates by a database maintaining a first page storing a data block in the database's on-disk store such that the data block stores at least one byte of the geometric object. After receiving the request for the geometric object, the database loads the page storing the geometric object in the in-memory store and determines the size of the geometric object. Based on the size of the geometric object, the database stores the geometric object in the in-memory store directly or in a heap of the in-memory store.
-
公开(公告)号:US11163808B2
公开(公告)日:2021-11-02
申请号:US16374142
申请日:2019-04-03
Applicant: SAP SE
Inventor: Manuel Caroli
Abstract: Described herein are systems and method for mapping data points in a spatial data set. In some embodiments, a hexagon grid can be defined for mapping a plurality of data points in a spatial data set. Location information can be specified for each hexagon in the hexagon grid. The specifying can include calculating, for each hexagon, a first location of a first vertex and a second location of a second vertex. A rectangular grid including a plurality of rectangular cells can be mapped to the hexagon grid. A location of a data point of the plurality of data points can be determined relative to a first hexagon of the hexagon grid.
-
公开(公告)号:US20180096032A1
公开(公告)日:2018-04-05
申请号:US15282413
申请日:2016-09-30
Applicant: SAP SE
Inventor: Bjoern Mielenhausen , Manuel Caroli , Youssef Hatem
IPC: G06F17/30
CPC classification number: G06F16/24544 , G06F16/25 , G06F16/252
Abstract: Embodiments include a metadata application programming interface (API) for processing ad hoc database queries. Embodiments can be configured to process ad hoc database queries to determine the structure of the resulting data set and to provide metadata in the form of a result table, for example, in response to the queries that describes the structure of the data to be accessed by the queries. In one embodiment, this may be performed without accessing the data that would be retrieved upon executing the query. Certain embodiments may be adapted to prevent execution of the query and to return the metadata describing the structure of the data structure(s) in the resulting data set. A new “describe” statement can be incorporated into a query language expression and configured to work in a functionally coordinated manner with the API to implement a “describe” function in accordance with the techniques described in this disclosure.
-
-
-
-
-
-
-