【正文】 tudio offers a single tool that covers multiple types of BI solution and provides a single, consistent environment for developing ETL, analysis and reporting solutions. Intuitive BI wizards that are delivered as part of the Business Intelligence Development Studio make it easy for even novice developers to build advanced Business Intelligence models and projects. By embedding the mon language runtime (CLR) in the database engine, SQL Server 2020 enables developers to choose from a variety of languages to develop applications, including TransactSQL, Microsoft Visual Basic174。 a single, unified management tool that provides integrated management of Analysis Services, Reporting Services, Integration Services, and multiple versions of SQL Server, from the same interface for increased DBA productivity, flexibility, and manageability across extended SQL Server implementations. Monitor Data Warehouse Resources SQL Server 2020 includes performance data collection and warehousing, which enables monitoring and reporting of resources across your data services solution. Enterprise Scalability A key factor related to the successful delivery of truly sophisticated BI solutions requires sustained developer productivity and manageability even through largescale implementations. Furthermore, the infrastructure must provide performancerelated scalability, which in SQL Server 2020 has achieved a wide variety of investments that are focused on ensuring this enterprisescale sustainability even through the largest scale of BI implementation. 第 11 頁 共 28 頁 Scalable Analytics The premise of Online Analytical Processing (OLAP) is that instant access to accurate information enables end users to answer even the most plex questions at the speed of thought. Thus, the aim to continuously excel in providing even faster query times and data refresh rates is a priority during the development process of any SQL Server Analysis Services release, an aim that naturally also has been driving the release of SQL Server 2020 Analysis Services. SQL Server 2020 includes Analysis Services that enable you to drive broader analysis with enhanced capabilities, including plex putations and aggregations. Analysis Service provides enterprisescale performance through: ? A flexible caching model. With Analysis Services, you can control how data and aggregations are cached to optimize query performance while maintaining an acceptable level of latency between the cache and its underlying data store. ? Declarative attribute relationships. In an Analysis Services dimension, you can explicitly declare relationships between attributes in a hierarchy. This enables Analysis Services to pregenerate aggregations when a cube or dimension is processed, which improves runtime query performance. ? Block putation. Block putation eliminates unnecessary aggregation calculations (for example, when the values to be aggregated are NULL) and provides a significant improvement in analysis cube performance, which enables users to increase the depth of their hierarchies and plexity of putations. ? Writeback to MOLAP. Analysis Services 2020 removes the requirement to query ROLAP partitions when performing writebacks, which results in huge performance gains. ? Scaleout Analysis Services. A single readonly copy of an Analysis Services database can be shared between many Analysis Servers through a virtual IP address. This creates a highly scalable deployment option for an Analysis Services solution. ? Execution plan persistence. SQL Server 2020 provides functionality to lock down query plans so that, to the maximum extent possible for correctness, the query plans survive server restart, server upgrade, and production deployments. This ensures consistent optimal performance of queries against SQL Server data. 第 12 頁 共 28 頁 Scalable Reporting For many organizations, getting the right information to the right people at the right time is a significant challenge. SQL Server 2020 provides a highperformance reporting engine for processing and formatting reports along with a plete set of tools for creating, managing, and viewing reports. An extensible architecture and open interfaces enable easy integration of reporting solutions in diverse IT environments. You can generate reports from multiple diverse data sources, including SQL Server, DB2, and Oracle, without first building a centralized data warehouse. You can deliver reports throughout the organization both internally and externally through the simple deployment and configuration capabilities that are provided by Reporting Services. This enables users to easily create and share reports of any size or plexity. You can also deliver reports to customers and suppliers easily by deploying reports over the Inter. Reporting Service provides support and the ability to control server behavior with memory management, infrastructure consolidation, and straightforward configuration through a centralized store and an API for all configuration settings. Extending the Reach of Your BI Solution In the past, BI solutions were used by a small group of business analysts. Now, more and more organizations are realizing the benefits of extending the insights that are available through BI to all employees and embedding those insights into the daytoday operations of the business. SQL Server 2020 enables you to create a BI solution that can scale to thousands of users and deliver a rich user experience to everyone through an extensible, open, and embeddable architecture that is optimized for interoperability with Microsoft Office. Extending Business Insight to Everyone Through Familiar Tools Microsoft Office is a ubiquitous productivity suite that most information workers in organizations throughout the world use to perform their daily tasks. Through close integra