Login| Sign Up| Help| Contact|

Patent Searching and Data


Title:
HANDLING BULK INSERTS OR UPDATES TO A DATABASE
Document Type and Number:
WIPO Patent Application WO/2019/155251
Kind Code:
A2
Inventors:
SHARMA PRATIK (IN)
Application Number:
PCT/IB2018/050749
Publication Date:
August 15, 2019
Filing Date:
February 07, 2018
Export Citation:
Click for automatic bibliography generation   Help
Assignee:
SHARMA PRATIK (IN)
International Classes:
G06F17/30
Download PDF:
Claims:
wo 2019/155251 Claims PCT/IB2018/050749

Following is the claim for this invention: -

1> In this invention we have huge number of incoming writes(inserts or updates) to a database like document oriented database MongoDB. We here use a non-blocking queue for threads or processes to insert the objects(inserts or updates) ready to be pushed to the database. Then different worker processes or threads dequeue or remove objects from the non-blocking queue typically in batches of size allowed for bulk operations depending upon the database used and do bulk updates or inserts to the database. Also different worker processes or threads pushing bulk inserts or updates to the database will use different connections(one unique connection per worker process or thread) to the database server from the connection pool made available to it. Typically some databases spawn one process or thread per connection request and hence the above novel technique which helps us to handle bulk

operations like inserts or updates for a database is the claim for this invention.

Description:
wo 2or 9/ r5525randling bulk inserts or updates to a databpcT/iB2or 8/ o5074 9

In this invention we have huge number of incoming writes(inserts or updates) to a database like document oriented database MongoDB. We here use a non-blocking queue for threads or processes to insert the objects(inserts or updates) ready to be pushed to the database. Then different worker processes or threads dequeue or remove objects from the non-blocking queue typically in batches of size allowed for bulk operations depending upon the database used and do bulk updates or inserts to the database. Also different worker processes or threads pushing bulk inserts or updates to the database will use different connections(one unique connection per worker process or thread) to the database server from the connection pool made available to it. Typically some databases spawn one process or thread per connection request and hence the above architecture helps us to handle bulk operations like inserts or updates for a database.