17971506. FLEXIBLE ROUTING OF DATABASE OPERATIONS ACCESSING REMOTE TABLES simplified abstract (SAP SE)

FLEXIBLE ROUTING OF DATABASE OPERATIONS ACCESSING REMOTE TABLES

Organization Name

SAP SE

Inventor(s)

Won Wook Hong of Suwon (KR)

Joo Yeon Lee of Seoul (KR)

Hyeong Seog Kim of Seoul (KR)

Jane Jung Lee of Ansan (KR)

Younkyoung Lee of Bucheon (KR)

FLEXIBLE ROUTING OF DATABASE OPERATIONS ACCESSING REMOTE TABLES - A simplified explanation of the abstract

This abstract first appeared for US patent application 17971506 titled 'FLEXIBLE ROUTING OF DATABASE OPERATIONS ACCESSING REMOTE TABLES

The present disclosure introduces techniques for executing database operations involving a remote data source in a system with an anchor node and non-anchor nodes.

• First requests for database operations are received, including data requests for remote data objects.
• Operations that are not insert, delete, or update are assigned to either the anchor node or a non-anchor node.
• Non-insert, delete, or update operations are assigned to non-anchor nodes for execution.
• Subsequent operations for a remote data object are assigned to the anchor node after an insert, delete, or update operation is received for that object.

Potential Applications: - Distributed database systems - Remote data management - Data processing in networked environments

Problems Solved: - Efficient execution of database operations involving remote data sources - Load balancing in distributed systems - Optimizing data processing workflows

Benefits: - Improved performance in handling remote data requests - Enhanced scalability in distributed database systems - Streamlined data management processes

Commercial Applications: Title: "Optimizing Remote Data Operations in Distributed Systems" This technology can be applied in cloud computing, IoT systems, and enterprise databases to enhance data processing efficiency and scalability.

Questions about Optimizing Remote Data Operations in Distributed Systems: 1. How does this technology improve the performance of database operations involving remote data sources? 2. What are the key advantages of assigning operations to anchor and non-anchor nodes in a distributed system?

Original Abstract Submitted

The present disclosure provides techniques and solutions for executing requests for database operations involving a remote data source in a system that includes an anchor node and one or more non-anchor nodes. A first request for one or more database operations is received, where at least a first database operation includes a data request for a remote data object. It is determined that the first database operation is not an insert, delete, or update operation, and therefore is assignable to the anchor node or one of the non-anchor nodes. The first database operation is assigned to a non-anchor node for execution. In a particular implementation, for a particular set of requests for a database operation, once an insert, delete, or update operation is received for the remote data object, subsequent operations for the remote data object in the set of requests are assigned to the anchor node for execution.