OLTP vs. OLAP - view details
Two important acronyms that you need to be familiar with are OLTP and OLAP. In this video Scott will go over what each of these stand for and why are they are important.
Highlights from this video:Databases are either OLTP or OLAP
OLTP
Online Transaction Processingdata entry applications
OLAP
Online Analytical Processingdate warehousing needs (reporting)
and much more Source: http://www.learnitfirst.com/Course/165/Video/2618/OLTP-vs-OLAP.aspx Course: http://www.learnitfirst.com/Course/165/SSAS-2008.aspx Skill Level: 100 (Beginner) Length: 11:15 (46.9MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".
Keywords for this video: introduction, step by step, beginner, beginning, for dummies, sql server 2008, ssas, analysis services, oltp. olap
This video comes from the SQL Server 2008 Analysis Services online training course, SQL Server 2008/R2 Analysis Services. And be sure to check out even more SQL Server Analysis Services training videos.
