Parallel processing of assigned table partitions
AssigneeSap SE
InventorsHarish Mehta, Heiko Gerwens
Life of this patent
Estimating the term…
Abstract
Methods and apparatus, including computer program products, for parallel processing of assigned table partitions. In general, a group of data may be received and at least a portion of the data may be caused to be assigned to an application server to process the data based at least in part on the application server and the at least a portion of the data being assigned to a same segment. A segment may represent one or more partitions of data of a database, such as a multidimensional database or a flat database. The data that is processed may be payment items that are processed as part of payment order processing by a payment engine.
Claims20
A computer program product, embodied in a non-transitory computer-readable storage medium, the computer program product being operable to cause data processing apparatus to perform operations comprising:
- assigning, using a plurality of synchronized database servers, each application server of a plurality of application servers to a corresponding segment of a plurality of segments of a database table, each application server being assigned a single segment and one or more application servers assigned a same segment, each database server of the plurality of synchronized database servers being assigned corresponding one or more application servers, each segment having at least one separate and corresponding index;
- receiving, at each application server, corresponding data to be processed;
- assigning, based on a number of items within a portion of the data and based on the assignment of each application server to the corresponding segment and based on a round robin scheme, the portion of the data to the corresponding segment;
- and
- causing the assigned data to be processed by an application server of the plurality of application servers based at least in part on the application server and the assigned data being assigned a same segment.
A computer implemented method comprising:
- assigning, using a plurality of synchronized database servers, each application server of a plurality of application servers to a corresponding segment of a plurality of segments of a database table, each application server being assigned a single segment and one or more application servers assigned a same segment, each database server of the plurality of synchronized database servers being assigned corresponding one or more application servers, each segment having at least one separate and corresponding index;
- receiving, at each application server, corresponding data to be processed;
- assigning, based on a number of items within a portion of the data and based on the assignment of each application server to the corresponding segment and based on a round robin scheme, the portion of the data to the corresponding segment;
- and
- causing the assigned data to be processed by an application server of the plurality of application servers based at least in part on the application server and the assigned data being assigned a same segment.
A system comprising:
- a plurality of application servers, each application server comprising memory and at least one data processor to execute instructions stored in the memory;
- and
- a plurality of synchronized database servers, each database server comprising memory and at least one data processor to execute instructions stored in the memory;
- wherein:
- each application server is assigned, by the data processors of the synchronized database servers executing the instructions stored in the memory of the corresponding plurality of synchronized database servers, to a corresponding segment of a plurality of segments of a database table, each application server being assigned a single segment and one or more application servers assigned a same segment, each database server of the plurality of synchronized database servers being assigned corresponding one or more application servers, each segment having at least one separate and corresponding index;
- corresponding data to be processed is received at each application server;
- the portion of the data is assigned to the corresponding segment based on a number of items within a portion of the data and based on the assignment of each application server to the corresponding segment and based on a round robin scheme;
- and
- the assigned data is processed by an application server of the plurality of application servers based at least in part on the application server and the assigned data being assigned a same segment.
Dependencies are inferred from the claim text.