Information processing system and control method
An information processing system manages data on customers using tenants which are storage regions dedicated for the customers of a database and registers a message for processing data of a processing target in a queue. The data is processed by accessing the tenants corresponding to the data so as to refer to the tenants based on the message. The information processing system registers a message for processing a plurality of data of processing targets as a batch process in the queue in a case where the plurality of data satisfy the predetermined condition when the message for processing a plurality of data of processing targets is to be registered in the queue. In the process performed on the plurality of data, the different tenants are accessed to be referred to.
1. An information processing system using a system of a database which manages data on customers using tenants which are storage regions dedicated for the customers and using a queue in which a message for processing data of a processing target is registered, the information processing system comprising:
one or more memories storing instructions, and
one of more processors executing the instructions to:
receive a request for a process for data of processing targets, wherein the process requires accessing one or more tenants in the database;
generate a first message for performing a first process on the data of processing targets corresponding to the received request in a case where the received request is a request from a terminal apparatus via a web server and the data of the processing targets corresponding to the received request is first data not to be batch processed, wherein one tenant in the database manages the data of processing targets, and wherein the first message is a message for performing that requires accessing the one tenant corresponding to one customer in the database;
generate a second message for performing a second process on the data of processing targets corresponding to the received request in a case where the received request is a request for a periodic totaling process from a scheduler and the data of the processing targets corresponding to the received request is second data to be batch processed, wherein each of a plurality of tenants in the database manages one piece of data of processing targets, and wherein the second message is a message for performing a second process that requires accessing the plurality of tenants each corresponding to a different one of a plurality of customers in the database;
register the first message in the queue in a case where the first message is generated; and
register the second message in the queue in a case where the second message is generated,
wherein each message registered in the queue is obtained and executed by an execution system using at least one machine and the database,
wherein, in a case where the first message is obtained, the first process that requires accessing the one tenant in the database is executed, and
wherein, in a case where the second message is obtained, the second process that requires accessing the plurality of tenants in the database is executed.
2. The information processing system according to claim 1 ,
wherein a number of machines is controlled based on a number of messages registered in the queue or a processing load of the execution system.
3. The information processing system according to claim 1 , wherein the obtained message is deleted from the queue after the process performed by the execution process is successfully completed.
4. The information processing system according to claim 1 , wherein the obtained message is re-registered in the queue when the second process performed by the execution system has failed according to the obtained message.
5. The information processing system according to claim 1 , wherein the second process is a periodic totaling process.
6. The information processing system according to claim 1 , wherein the data of processing targets is stored in a tenant in the database.
7. A method employed in an information processing system using a system of a database which manages data on customers using tenants which are storage regions dedicated for the customers and using a queue in which a message for processing data of a processing target is registered, the method comprising:
receiving a request for a process for data of processing targets, wherein the process requires accessing one or more tenants in the database;
generating a first message for performing a first process on the data of processing targets corresponding to the received request in a case where the received request is a request from a terminal apparatus via a web server and the data of the processing targets corresponding to the received request is first data not to be batch processed, wherein one tenant in the database manages the data of processing targets, and wherein the first message is a message for performing a process that requires accessing the one tenant corresponding to one customer in the database;
generating a second message for performing a second process on the data of processing targets corresponding to the received request in a case where the received request is a request for a periodic totaling process from a scheduler and the data of the processing targets corresponding to the received request is second data to be batch processed, wherein each of a plurality of tenants in the database manages one piece of data of processing targets, and wherein the second message is a message for performing a second process that requires accessing the plurality of tenants each corresponding to a different one of a plurality of customers in the database;
registering the first message in the queue in a case where the first message is generated; and
registering the second message in the queue in a case where the second message is generated,
wherein each message registered in the queue is obtained and executed by an execution system using at least one machine and the database,
wherein, in a case where the first message is obtained, the first process that requires accessing the one tenant in the database is executed, and
wherein, in a case where the second message is obtained, the second process that requires accessing the plurality of tenants in the database is executed.
8. The method according to claim 7 , wherein the data of processing targets is stored in a tenant in the database.
9. The method according to claim 7 , wherein a number of machines is controlled based on a number of messages registered in the queue or a processing load of the execution system.
10. The method according to claim 7 , wherein the obtained message is deleted from the queue after the process performed by the execution process is successfully completed.
11. The method according to claim 7 , wherein the obtained message is re-registered in the queue when the second process performed by the execution system has failed according to the obtained message.
12. The information processing system according to claim 7 , wherein the second process is a periodic totaling process.