Chapter 3: The Shortcut Guide to
Large Scale Data Warehousing and Advanced Analytics

"I’ve built data warehouses that performed well until they reached a size that was overwhelming. The Shortcut Guide to Large Scale Data Warehousing and Advanced Analytics identifies the key challenges in design, operation, and performance of large-scale data warehouses and provides practical advice for dealing with them. This book will help everyone from CIO’s and CTO’s to the database architects understand the unique issues that arise when data size grows to the multi-terabyte range."
Mark Scott, author of
"The Shortcut Guide to Large Scale
Data Warehousing and Advanced Analytics"

Large scale data warehouses typically import and manage large amounts of data. Systems that need to import and store millions of rows each day and then need to report back on them have very unique challenges. This chapter will address the system considerations in meeting those challenges.


Register for the third chapter of this ebook to learn about:
Importing and transforming large amounts of data in near real-time within tight maintenance windows
Dealing with the bandwidth and bottleneck issues on storing and retrieving large amounts of data from even larger data stores
Optimizing queries against large data sets to provide optimized results
Monitoring systems to assure continued operation

About the author
Mark Scott is a senior consultant for Microsoft Consulting Services. He develops multi-tier, data-centric web applications. He implements a wide variety of Microsoft-based technologies, with special emphasis on SQL Server and Analysis Services. He is a Microsoft Certified System Engineer + Internet, Solution Developer, Database Administrator and Trainer. He holds A+, Network + and CTT+ certifications from COMPTIA. Mark has also written a number of books and articles. He has co-authored the MSDE Bible, eCommerce for Dummies, Professional Data Warehousing Using Microsoft SQL Server 2000 and Analysis Services, Special Edition Using Commerce Server 2002 and other books. He regularly writes articles for technical publications and speaks at national conferences. He has also written courses and conducted national tours for Microsoft and a variety of other organizations.



About Realtime Publishers
Realtime Publishers has set the IT-Industry standard for corporate-sponsored ePublishing, creating interactive communities that employ RSS, blogs, and podcasting; electronic and printed books; white papers; video tutorials and webinars. With a who's who list of industry expert authors, a veteran editorial staff, and a leading syndication service through its digital library, Realtime Nexus (, Realtime Publishers offers the most current expert resources for IT professionals. Realtime Publishers’ sponsors include Microsoft, McAfee, CA, Novell, and Dell. For more information, please visit

Chapter 3 of 4
Register Now
- The Shortcut Guide to Large Scale
Data Warehousing and Advanced Analytics

* denotes required field

* * * * * * *
* What is your role in the decision-making process? *
How soon are you looking to implement a solution? *