-
公开(公告)号：US20170185642A1
公开(公告)日：2017-06-29
申请号：US15457945
申请日：2017-03-13
Applicant: SAP SE
Inventor： Franz Faerber , Juchang Lee , Ivan Schreter
CPC classification number: G06F16/2365 , G06F3/0604 , G06F3/0638 , G06F3/0644 , G06F3/0647 , G06F3/065 , G06F3/0652 , G06F3/0673 , G06F3/0683 , G06F16/162 , G06F16/1744 , G06F16/221 , G06F16/2308 , G06F16/2379 , G06F16/27 , G06F16/28
Abstract: A system and method of logless atomic data movement. An internal transaction is started within a multi-level storage architecture, the internal transaction to merge data from the first level storage structure to the second level storage structure. Committed data is read from a first level storage structure of the multi-level storage architecture as specified by the internal transaction. The committed data from the first level storage structure is inserted into a second level storage structure in a bulk insertion process, and the committed data is marked as being deleted from the first level storage. The internal transaction is then committed to the multi-level storage architecture when the committed data has been inserted into the second level storage structure.
-
公开(公告)号：US20170147671A1
公开(公告)日：2017-05-25
申请号：US14946757
申请日：2015-11-19
Applicant: SAP SE
Inventor： Christian Bensberg , Norman May , Alexander Boehm , Juchang Lee , Sung Heun Wi , Jeong Ae Han , Ki Hong Kim , Kyu Hwan Kim , Chul Won Lee , Andreas Kemmler , Christoph Glania , Armin Risch , Kai Morich
IPC: G06F17/30
CPC classification number: G06F17/30578 , G06F17/3048
Abstract: A method may include receiving a query for data to be provided by a database server, wherein the query includes an indication of a maximum lag. The method may further include determining whether a hint is available to apply to the query, wherein the hint affects an execution of the query. When no hint is available, a baseline database server may be selected to be the database server. When the hint is available, a replication server or a cache server may be selected to be the database server based on the hint and the maximum lag. The query may be processed at the selected database server.
-
公开(公告)号：US20170147628A1
公开(公告)日：2017-05-25
申请号：US14985766
申请日：2015-12-31
Applicant: SAP SE
Inventor： Changgyoo Park , Yongjae Chuh , Juchang Lee , Norman May , Thomas Seufert , Hannes Jakschitsch
IPC: G06F17/30
Abstract: Disclosed herein are system, method, and computer program product embodiments for efficiently providing transaction-consistent snapshots of data stored in or associated with a database stored within a database management system. An embodiment operates by receiving, at a source database, an update request to update a table at the source database and transmitting a message to a cache node to invalidate a copy of a table time stamp associated with the table, where the copy of the table time stamp is stored at the cache node. The embodiment continues by updating the table at the source database based on the update request.
-
公开(公告)号：US20160371357A1
公开(公告)日：2016-12-22
申请号：US14871675
申请日：2015-09-30
Applicant: SAP SE
Inventor： Chang Gyoo Park , Juchang Lee , Kyu Hwan Kim , Hyoung Jun Na , Hyejeong Lee
IPC: G06F17/30
CPC classification number: G06F17/30578 , G06F11/1451 , G06F17/30362 , G06F17/30377 , G06F17/30545 , G06F17/30598 , G06F17/30864
Abstract: Technologies are described for performing replication within a database environment. Where a database transaction is replicated at multiple replica nodes, a replica node is selected as a coordinator replica node for the transaction. The other replica node or nodes are designated as follower replica nodes for the transaction. A follower replica node sends the coordinator replica node a precommit notification when the follower replica node has precommitted the transaction. The coordinator replica node sends the follower replica node a postcommit notification to commit the transaction when the transaction has been precommitted by all of the replica nodes to which the transaction is to be replicated.
Abstract translation: 描述了在数据库环境中执行复制的技术。 在数据库事务在多个副本节点上进行复制的情况下，选择副本节点作为事务的协调器副本节点。 其他副本节点或节点被指定为事务的跟随复制节点。 当跟随者复制节点预先提交事务时，跟随者副本节点发送协调器副本节点预先通知。 协调器副本节点发送跟随者副本节点的后期通知，以便在交易已被事务被复制到的所有副本节点事先预先提交时提交事务。
-
公开(公告)号：US20160364440A1
公开(公告)日：2016-12-15
申请号：US14945296
申请日：2015-11-18
Applicant: SAP SE
Inventor： Juchang Lee , Chang Gyoo Park , Hyejeong Lee
CPC classification number: G06F17/30377 , G06F11/00 , G06F11/1474 , G06F17/30477 , G06F17/30578 , G06F2201/80
Abstract: Technologies are provided for reducing or eliminating transaction consistency anomalies that can occur during data replication, such as during database table replication. For example, commit values can be used to coordinate requests so that the requests are not performed on database tables with inconsistent data.
Abstract translation: 提供了技术来减少或消除数据复制期间可能发生的事务一致性异常，例如在数据库表复制期间。 例如，提交值可用于协调请求，以便不对具有不一致数据的数据库表执行请求。
-
Patent Agency Ranking
公开(公告)号：US20160042016A1
公开(公告)日：2016-02-11
申请号：US14827231
申请日：2015-08-14
Applicant: SAP SE
Inventor： Franz Faerber , Juchang Lee , Ivan Schreter
IPC: G06F17/30
CPC classification number: G06F17/30303 , G06F17/30289 , G06F17/30306 , G06F17/30315 , G06F17/30345 , G06F17/30371
Abstract: Deleting a data record from the second level storage or main store is disclosed. A look-up is performed for the data record in the first level storage, where the data record is defined by a row identifier. If the row identifier is found in the first level storage, a look-up is performed for an updated row identifier representing an update of the data record in the second level storage and the main store, the update of the data record being defined by an updated row identifier. If the updated row identifier is found in the second level storage, an undo log is generated from the first level storage to invalidate a row identifier of the row identifier. A flag is generated representing an invalid updated row identifier, and a redo log is generated to restore the data record in the first level storage.
Abstract translation: 公开了从第二级存储或主存储器中删除数据记录。 对第一级存储器中的数据记录执行查找，其中数据记录由行标识符定义。 如果在第一级存储器中找到行标识符，则对表示第二级存储器和主存储器中的数据记录的更新的更新行标识符执行查找，数据记录的更新由 更新的行标识符。 如果在第二级存储器中找到更新的行标识符，则从第一级存储器生成撤销日志以使行标识符的行标识符无效。 生成表示无效的更新行标识符的标志，并且生成重做日志以恢复第一级存储器中的数据记录。
-
公开(公告)号：US11880371B2
公开(公告)日：2024-01-23
申请号：US18065187
申请日：2022-12-13
Applicant: SAP SE
Inventor： Franz Faerber , Juchang Lee , Ivan Schreter
IPC: G06F16/2455 , G06F16/24 , G06F16/21 , G06F16/22
CPC classification number: G06F16/24561 , G06F16/213 , G06F16/221 , G06F16/24 , G06F16/2455 , G06F16/2456
Abstract: A system and method of query processing in a multi-level storage system having a unified table architecture. A query is received by a common query execution engine connected with the unified table architecture, the query specifying a data record. The common query execution engine performs a look-up for the data record based on the query at the first level storage structure. If the data record is not present at the first level storage structure, the common query execution engine performs separate look-ups in each of the second level storage structure and the main store.
-
公开(公告)号：US11663091B2
公开(公告)日：2023-05-30
申请号：US16222775
申请日：2018-12-17
Applicant: SAP SE
Inventor： Dongin Shin , Yeonghun Jeong , Jeong Hee Won , Juchang Lee
IPC: G06F11/14 , G06F16/2455
CPC classification number: G06F11/1469 , G06F16/24552 , G06F2201/84
Abstract: A client computer establishes one or more sessions with a DBMS. Session context information for each session is cached in a client-side session cache. When a session disconnection is detected, the session recovery includes establishing a new session with the DBMS, and restoring the session context of the disconnected session from the session information of the disconnected session that is stored in the session cache.
-
公开(公告)号：US11550618B2
公开(公告)日：2023-01-10
申请号：US17322715
申请日：2021-05-17
Applicant: SAP SE
Inventor： Kyu Hwan Kim , Juchang Lee
Abstract: Innovations in the area of server-side processing when committing transactions to disk in a distributed database system can improve computational efficiency at database nodes and/or reduce network bandwidth utilization. For example, when transactions are committed in a database system, at a master node of the database system, a server uses different threads for certain processor-intensive operations and certain I/O-intensive operations.
-
公开(公告)号：US20220318249A1
公开(公告)日：2022-10-06
申请号：US17826060
申请日：2022-05-26
Applicant: SAP SE
Inventor： Jaeyoung Choi , Deok Hoe Kim , Kyu Hwan Kim , Chae Kwang Lee , Jane Jung Lee , Juchang Lee
IPC: G06F16/2455 , G06F16/2453 , G06F16/22 , G06F16/248
Abstract: Technologies are described for routing structured query language (SQL) statements to elastic compute nodes (ECNs) using workload classes within a distributed database environment. The elastic compute nodes do not store persistent database tables. For example, a SQL statement can be received for execution within the distributed database environment. A workload class can be identified that matches properties of the SQL statement. Based on the workload class, a routing location hint can be obtained that identifies a set of elastic compute nodes. The SQL statement can then be routed to one of the identified elastic compute nodes for execution. Execution of the SQL statement at the elastic compute node can involve retrieving database data from other nodes which store persistent database tables.
-
-
-
-
-
-
-
-
-
Search Results
160
records
(took 0.021 seconds)
