Batch Execution on Distributed Database
Batch execution is background process to analyse data. There are two way to prepare data before execute batch process.
- Prepare another data storage to execute batch. After execution, return data to main database.
- Execute batch using current relational database.
When we hire first option, this process is done by replicated database or NoSQL storage.
When we use other storage then main database, we have to prepare data to analyse in another storage. This process is heavy task, we have to synchronize two databases.
The second option is easy. But in order to do that, the main database needs more overhead on executing it.