- SQL Server 2005 – Major New Features. - SQL Server 2005 Analysis Services (SSAS). - Microsoft Analysis Services is server-based platform for on-line analytical processing (OLAP) and Data Mining Services provided with Microsoft SQL Server 2005.. - While Analysis Services 2000 was more of an evolutionary release building on the same OLAP architecture that Microsoft (MS) introduced with SQL 7, the new version of SSAS is a fundamental change, built on Unified Dimensional Model (UDM). - Microsoft released SSAS in November 2005, and it ships as an add-on to SQL Server 2005 just like its predecessors.. - Business Intelligence – The Big Picture. - The goal of SSAS 2005 is to ”democratize” the process and to provide instant information readily available to the entire organization – or what MS calls “pervasive business intelligence” (PBI).. - The two major build- ing blocks of Microsoft BI Platform are SQL Server and Office System. - The back-end analytics engine provided by SQL Server is supplemented with the user interface provided by Office System. - Beyond the scope of this paper are the topics of Data Transformation Services, Data Mining, Multidimensional Expressions (MDX) language, Reporting Services, and SQL Server 2005 itself. - The following table summarizes the differences between the BI components of SQL Server 2000 and SQL server 2005.. - In this paper I will discuss the user interface and architectural differences between AS for SQL Server 2000 and SSAS for SQL Server 2005.. - The new Business Intelligence Development Studio (BIDS) is single suite of development and mainte- nance tools that replaces SQL Server 2000 Enterprise Manager, Analysis Services Manager, and Query Analyzer.. - Component SQL Server 2000 SQL Server 2005. - Extract, transformation, and load Data Transformation Services (DTS) SQL Server 2005 Integration Services Relational data warehouse SQL Server 2000 relational database SQL Server 2005 relational database Multidimensional database SQL Server 2000 Analysis Services SQL Server 2005 Analysis Services Data mining SQL Server 2000 Analysis Services SQL Server 2005 Analysis Services Managed reporting SQL Server 2000 Reporting Services SQL Server 2005 Reporting Services. - Ad hoc reporting Not applicable SQL Server 2005 Reporting Services. - Microsoft Office products (Excel, Office Web Components, Data Analyzer, SharePoint Portal Server) Database development tools SQL Server 2000 Enterprise Manager,. - SQL Server 2005 Business Intelligence Development Studio (New). - Database management tools Enterprise Manager, Analysis Manager SQL Server Management Studio (New). - Another new tool is SQL Server Management Studio (SSMS), previously referred to as the SQL Server Workbench. - Another new option allows you to generate virtual columns (called named calculations) on exist- ing tables and virtual views (called named queries). - SSAS comes with a powerful Deployment Wizard that allows you to easily customize the deployment of a proj- ect. - This allows you to automate deployment using AMO objects. - The AMO layer sits between the user application and Analysis Services instance. - SQL Server Management Studio allows you to create XMLA scripts that can be later executed for deployment based on a schedule.. - Backup/Restore is the old way of copying Analysis Services databases. - While ”the-more-the-bet- ter” rule still applies, remember that the 32 bit version of SQL cannot address more than three GB of memory.. - The new SQL Server 2005 Analysis Services is a a welcome addition to a growing BI industry.. - Microsoft SQL Server 2005 Administration Microsoft SQL 2005 Reporting Services Microsoft SQL Server 2005 for Developers. - Microsoft SQL Server 2005 for Business Intelligence
Xem thử không khả dụng, vui lòng xem tại trang nguồn hoặc xem
Tóm tắt