Patent ID: 11914603
Assignee: HITACHI, LTD.
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 0:
1. A data layout model generation system that generates, with reinforcement learning, a node configuration and a data layout key in a distributed parallel database, the data layout model generation system comprising:
a hardware processor that acquires, on the basis of a predetermined acquisition method, sample data from data stored in the distributed parallel database;
a non-transitory computer-readable storage medium operatively coupled with the hardware processor, and storing program instructions executed by the hardware processor that cause the data layout model generation system to:
estimate layout of the data on the basis of the sample data and states in the reinforcement learning, the states including the node configuration and the data layout key including information regarding an order of sorting columns that constitute the data and information regarding a method for distribution between nodes;
calculate a reward in the reinforcement learning on the basis of a result obtained by estimating the layout of the data, the node configuration, and a processing cost of a query executed on the distributed parallel database;
output, according to the calculated reward, the node configuration and the data layout key that are subjected to reinforcement learning as an action; and
update, as a new state, the node configuration and the data layout key that are output as the action.