Skip to main content

Q) What is Batch updates?



A)
->Batch updates is a formality given by JDBC using which, DML SQL statement can be grouped physically into one unit and at a time submitted to the DBMS for processing as a batch.
->Batch updates mechanism improves performance some times by reducing the number of client/server interaction.
->we have 2 kinds of business Systems.
1) OLTPS (Online Transaction Processing Systems)
2) Batch processing System.
To support batch processing systems, batch updates is given in JDBC.
->In case of OLTP, end user waits the system responds after giving input into the system.
->in case of batch processing system, end user doesn’t wait for the systems responds.
ATM application is an example for OLTP.
->At the end of every month, all accounts must be created by their earned interest is an example use case of batch processing.

Comments

Post a Comment

Popular posts from this blog

Q) How to develop a java application using MyEclipse that displays “hello world” on console

A) Step 1) Create a new java project File->new->Java project->Enter Project Name Step 2) Create a userdefined package within “src” directory (given by MyEclipse into which we store all our java files and src means java source code). Right click on “src directory->new->package->enter the package name For example: com.prince (reverse domain naming connection is fallowing by industry for package names) Step 3) Create a class with main Right click on package ->new->class->Enter the class name->select the main option. Step 4) Write System.out.println and run the application. Right click on editor->Run As->java Application.
Post a Comment
Read more