Home > DeveloperSection > Interviews > What is OLTP (Online Transaction Processing)?

Posted on    January-16-2015 10:41 PM

 MSSQL Server SQL Server 2012 
Ratings:
 1 Answer(s)
  434  View(s)
Rate this:

Chintoo Semi

Total Post:79

Points:395
Posted on    January-16-2015 11:41 PM

In OLTP - online transaction processing systems relational database design use the discipline of data modeling and generally follow 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 structures (a table) where all of the individual atomic level elements relate to each other and satisfy the normalization rules.

Don't want to miss updates? Please click the below button!

Follow MindStick