Client Server Question:
What is OLTP in client server environment?
Answer:
In the transaction server, the client component usually includes GUI and the server components usually consists of SQL transactions against a database. These applications are called OLTP (Online Transaction Processing) OLTP Applications typically,
Receive a fixed set of inputs from remote clients.
Perform multiple pre-compiled SQL comments against a local database.
Commit the work and
Return a fixed set of results.
Receive a fixed set of inputs from remote clients.
Perform multiple pre-compiled SQL comments against a local database.
Commit the work and
Return a fixed set of results.