SQL Server RDBMS, Fast Track DW, and SQL Server PDW
It may strike you as odd that, as we’re well into our coverage of the Microsoft BI stack, we mention the SQL Server Relational Database Management System (RDBMS) itself. We do so because while the primary application of the SQL Server RDBMS is as a transactional database, it is also an excellent data mart and data warehouse solution. Before we explain why, let’s define what these terms actually mean.
Data Marts and Data Warehouses
The purpose of both data marts and data warehouses is to provide consolidation points for disparate systems, reconcile their data structures, unify their data, and allow queries across the universe of transactions. There’s no hard and fast definition that distinguishes ...
Get Programming Microsoft® SQL Server® 2012 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
