Both OLTP and OLAP are types of IT systems.OLTP (Online transaction processing system) deals with transactions ( insert, update , delete and simple search ) while OLAP (Online analytical processing) deals with analyzing historical data, forecasting etc.
Below is a simple table which chalks out the differences.
|Design||Normalized. (1st normal form, second normal form and third normal form).||Denormalized (Dimension and Fact design).|
|Motive||Faster insert, updates, deletes and improve data quality by reducing redundancy.||Faster analysis and search by combining tables.|
|SQL complexity||Simple and Medium.||Highly complex due to analysis and forecasting.|
See the following video on First, Second, and Third normal form in SQL Server: -
See for more stuffs on SQL Server Training
Click to view more from author's on SQL Server Training
write a comment