SQL Server 最佳实践
发布日期: 2007年3月21
作者: Matt Carroll
投稿人: Robert Zare, Edward Melomed, Akshai Mirchandani, Marius Dumitru, Siva Harinath
技术评论家: Craig Utley, Nicholas Dritsas
项目编辑: Jeannine Nelson-Takaki
该文章描述了在Microsoft SQL Server 2005 Analysis Services 中设计OLAP 数据库并更好的迎合用户功能性需求和性能需求所推荐的最佳实践。为联机分析处理(Online Analytical Processing, OLAP)设计数据库，和为联机事务处理(Online Transaction Processing, OLTP)设计数据库有所不同，因此需要用不同的方法实现结果的优化。
更多信息，请参阅白皮书 OLAP Design Best Practices for Analysis Services 2005
About denny.lee
Denny Lee is a Senior Program Manager based out of Redmond, WA in the SQLCAT Best Practices Team. He has more than 12 years experience as a developer and consultant implementing software solutions to complex OLTP and data warehousing problems. His industry experience includes accounting, human resources, automotive, retail, web analytics, telecommunications, and healthcare. He had helped create the first OLAP Services reporting application in production at Microsoft and is a co-author of “SQL Server 2000 Data Warehousing with Analysis Services” and “Transforming Healthcare through Information [Ed. Joan Ash] (2008)”. In addition to contributing to the SQLCAT Blog, SQL Server Best Practices, and SQLCAT.com, you can also review Denny's Space (http://denster.spaces.live.com). Denny specializes in developing solutions for Enterprise Data Warehousing, Analysis Services, and Data Mining; he also has focuses in the areas of Privacy and Healthcare.
|
sql, server, best practices, whitepapers, analysis services, data mining, olap, datawarehouse, datawarehousing, availability, clustering, capacity, collation, data types, data warehouse, database, design, index, mirroring, optimization, partitions, performance, precision, processing, querying, scalability, security, reporting services, integration services
|
|
