Sql Interview Question #5: What is OLTP (Online Transaction Processing)?

This entry was posted in Sql Server Interview Questions Sql Server tutorials and tagged oltp online processing server sql transaction on by .

Sql Interview Question 

What is OLTP (Online Transaction Processing)?

Solution

In OLTP (Online Transaction Processing systems), relational database design uses the discipline of data modeling and generally follows the Codd rules of data normalization in order to ensure absolute data integrity. Using these rules, complex information is broken down into its most simple structure (a table) where all of the individual atomic level elements relate to each other and satisfy the normalization rules.

 

Thanks for reading this article,

Next steps :

  1. Share this with your colleagues because Sharing is Learning
  2. Comment below if you need any assistance