OLTP and OLAP

You’ve probably heard the terms OLTP and OLAP in the context of data storage. When planning SQL Server 2008 BI solutions, you need to have a solid understanding of these systems as well as the implications of using them for your particular requirements.

Online Transactional Processing

OLTP stands for online transactional processing and is used to describe a relational data store that is designed and optimized for transactional activities. Transactional activities are defined as inserts, updates, and deletes to rows in tables. A typical design for this type of data storage system is to create a large number of normalized tables in a single source database.

Get Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.