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.