计算机专业外文翻译---sqlserver2008商业智能(编辑修改稿)

计算机专业外文翻译---sqlserver2008商业智能(编辑修改稿)内容摘要：

es in SQL Server Integration Services means that you can extract data from all kinds of existing business applications. Therefore, unifying the data in all of your enterprise data sources is easy to acplish, regardless of whether you want to build an abstraction layer through a data source view or use an ETL process to synchronize a dedicated data warehouse for analysis and reporting. Additionally, through support for Web services and the Microsoft .NET Framework, SQL Server 2020 supports interoperability with multiple platforms, applications, and programming languages, so you can maximize your investment in new and existing systems by integrating and connecting your disparate data sources. Support for existing and emerging open standards, such as HTTP, XML, SOAP, XQuery, and XSD, further facilitate munication across your extended enterprise systems. Data Warehouse Performance SQL Server 2020 provides a prehensive and scalable data warehouse platform that enables your organization to integrate data into the data warehouse faster so you can scale and manage growing volumes of data and users. Optimize ETL Processes Data warehouses are usually populated and updated with data from source systems through an ETL process. After the initial load of data into the data warehouse, periodic refreshes of new and changed data from the source systems are performed to ensure that the data warehouse is uptodate. SQL Server Integration Services provides a prehensive platform that you can use to extract data from diverse source systems, make any required transformations to the data or its structure and format, and then load the transformed data into the data warehouse. Performing lookups to match records from source systems to existing records in the data warehouse is a mon operation in ETL processes, and in SQL Server 2020 the performance of lookups has been significantly improved so that these operations scale to extremely large tables. To help track data changes and ensure data warehouse consistency, SQL Server 2020 introduces change data capture functionality to log updates in change tables, which makes it easy to identify rows that have been modified and to determine the details of the modification 第 7 页 共 28 页 and its cause. Manage Hardware Resources Efficiently Through support for data pression, SQL Server 2020 enables you to store your data more effectively and reduce storage costs. In addition, the pression significantly improves performance for large input/output bound workloads. SQL Server 2020 also provides native support outofthebox for backup pression. Additionally, the VARDECIMAL data type and new sparse columns in SQL Server 2020 help you get the most efficiency from your disk storage resources by reducing the amount of space that is required for the large tables that contain the predominantly numeric or NULL values that are often found in data warehouses. In addition to efficiencies in data storage, SQL Server 2020 supports dynamic allocation of Address Windowing Extensions (AWE) mapped memory that supports up to 64 gigabytes of memory with Windows Server174。 2020, Datacenter Edition, and 2 terabytes with the 64bit edition, to support large data warehouse environments. SQL Server 2020 also introduces Resource Governor, which enables administrators to define resource limits and priorities for different workloads, so that concurrent workloads can provide consistent performance and make it possible to manage resource contention issues proactively. Optimize Database Performance SQL Server 2020 includes a highperformance relational database engine that enables you to build highly effective data warehouse solutions. Innovations, such as query optimizations for star schemas and tools to help you tune indexes and data structures, make SQL Server a natural choice for a heavily queried data warehouse. With the introduction of the MERGE TransactSQL statement in SQL Server 2020, developers can more effectively handle mon data warehousing scenarios, such as checking whether a row exists and then executing inserts or updates. Additionally, an extension to the GROUP BY clause enables users to define multiple grouping in the same query. Grouping Sets produce a single result set that is equivalent to a UNION ALL of differently grouped rows, which makes aggregation querying and reporting easier and faster. SQL Server 2020 supports partitioned tables to help you optimize the performance and management of large tables, and with new support for partitioned table parallelism, you can significantly optimize a data warehouse by using partitioned tables. Building and Managing Sophisticated BI Solutions As organizations demand ever increasingly plex analytics, the need to be able to build and deliver effective BI solutions quickly and to reduce the management overhead of 第 8 页 共 28 页 your BI infrastructure has bee a major consideration. SQL Server 2020 includes innovative tools that increase developer productivity and manageability, which enables faster capitalization on new analysis and reporting capabilities while incurring reduced administrative overhead. Developer Productivity SQL Server 2020 simplifies the development of business intelligence solutions. BI developers benefit from easytouse utilities and tools that increase control and automate routine, timeconsuming tasks, and can use the productivity features of SQL Server 2020 to create effective analysis and reporting solutions more quickly than ever。 so your organization can take advantage of them sooner. Use a Rich, Modern Programming Environment. Through tight interoperability with Microsoft Visual Studio174。 , developers can easily build and maintain robust, secure, scalable BI applications. SQL Server Business Intelligence Development Studio offers a single tool that covers multiple typ。