计算机专业外文翻译SQL Server 商业智能.doc

毕业设计（论文）外文翻译（2011届）外文题目 SQL Server 2008 Business Intelligence 译文题目 SQL Server 2008商业智能 外文出处 微软官网 学 生 SQL Server 2008 Business IntelligenceWhite PaperPublished: August 2007Updated: July 2008 Summary: SQL Server 2008 makes business intelligence available to everyone through deep integration with Microsoft Office, providing the right tool, to the right user, at the right price. Employees at all levels of an organization can see and help to influence the performance of the business by working with tools that are both easy to use and powerful. Integration with the 2007 Microsoft Office System enables users to view business performance in a way that they are familiar with. The introduction of PerformancePoint® Server 2007, helps customers gain actionable insight into the entire organization so they can monitor, analyze, and plan their businesses, as well as drive alignment, accountability, and actionable insight across the entire organization.For the latest information, see Microsoft SQL Server 2008.IntroductionIn an increasingly competitive marketplace, businesses are realizing that they can only succeed by proactively identifying market trends and opportunities, and by responding rapidly to new customer demands. Additionally, employees must prioritize business activities and expenditure to ensure the most efficient use of the available resources and make effective business decisions.To meet these challenges, employees need to gain actionable insight into the business so that they can make intelligent, informed decisions and contribute to business success. Organizations want to embed this insight into everyday business activities so that all employees are engaged, either explicitly or implicitly, in acting on the results of analysis of a complete and consistent version of all enterprise data.Microsoft Business Intelligence Technologies Microsoft provides a comprehensive Business Intelligence (BI) offering that is based on a scalable data platform for data integration, data warehousing, analysis, and reporting, including powerful and intuitive tools that end users can use to access and analyze business information. At the core of the Microsoft BI end-to-offering is Microsoft® SQL Server® 2008, a complete data platform that enables you to:· Unify storage and access for all data across the enterprise.· Build and manage sophisticated BI solutions.· Increase the reach of your business intelligence solution to empower all employees.The specific technologies of SQL Server 2008 that form the basis of this powerful BI offering are described in the following table.DescriptionSQL Server Database EngineA scalable, high-performance data storage engine for extremely large volumes of data making it an ideal choice for consolidating business data from across the enterprise into a central data warehouse for analysis and reportingSQL Server Integration ServicesA comprehensive platform for extract, transform, and load (ETL) operations that enables the population and synchronization of your data warehouse with data from the disparate data sources that are used by your business applications throughout the organizationSQL Server Analysis ServicesProvides an analytical engine for Online Analytical Processing (OLAP) solutions, including business measure aggregation over multiple dimensions and key performance indicators (KPIs), and for data mining solutions that use specialized algorithms to identify patterns, trends, and associations in business dataSQL Server Reporting ServicesAn extensive reporting solution that makes it easy to create, publish, and distribute detailed business reports both within the enterprise and outside the enterpriseWhile SQL Server 2008 delivers a comprehensive BI platform, it is through deep integration with productivity tools, such as the 2007 Microsoft Office System, that you can empower employees throughout the enterprise to use this platform and turn business insight into effective actions.2007 Microsoft Office System IntegrationThe SQL Server 2008 BI platform reaches information workers through the following 2007 Office System components:Microsoft Office Excel. Microsoft Office Excel® 2007 is a powerful spreadsheet application that you can use as an interface for OLAP analysis, data mining, and report rendering. Through deep integration between SQL Server 2008 and Excel 2007, you can:· Enhance the end users ability to access and analyze data from SQL Server 2008 Analysis Services. With Excel 2007, end users can browse data that is stored in multidimensional OLAP cubes in Analysis Services. Excel 2007 enables users to easily build Microsoft PivotTable® dynamic views to “slice and dice” data any way they wish through the tools that are already installed on most desktop computers. · Gain more value from your Excel implementation by using the tight integration between Excel and Analysis Services that enables end users to easily use the Analysis Services features, such as translations, Key Performance Indicators (KPIs), calculated members, named sets, and the server actions in Excel that turn Excel into an analytical client.· Make predictive analysis available to everyone and enable non-technical users to harness the highly sophisticated data mining algorithms of SQL Server 2005 Analysis Services within the familiar environment of Office. Designed with the end user in mind, Data Mining Add-Ins for Office 2007 empowers end users to perform complex analysis directly in Excel and Microsoft Office Visio®.· Add automatic analysis features, such as highlighting exceptions where data seems to differ from patterns in other areas of the table or data range, forecasting future values based on current trends, analyzing what-if scenarios, and determining what must change to meet a specific goal.· Deliver reports in the format preferred by most end users by using the new and enhanced Reporting Services Excel rendering capabilities, which enable end users to receive reports directly in Excel.Microsoft Office Word. Microsoft Word is a word processing application that you can use as a format for reports. Use the new, highly requested report renderer for Word, which enables you to render SQL Server 2008 Reporting Services reports in Word format.Microsoft Office Visio. Visio is a drawing and diagramming application that you can use to annotate, enhance, and present your data mining graphical views. With SQL Server 2008 and Visio 2007, you can: · Render decision trees, regression trees, cluster diagrams, and dependency nets.· Save data mining models as Visio documents embedded in other Office documents or saved as a Web page.Microsoft Office SharePoint Server. SharePoint® Server is comprehensive collaboration, publishing, and dashboard solution that you can use to provide one central location for placing all your enterprise-wide BI content and tools, so that everyone in your organization can view and interact with relevant and timely analytical views, reports, and KPIs. The integration of SQL Server 2008 Reporting Services with SharePoint Server 2007 enables you to:· Use one consistent user interface to manage and view reports.· Track versions and workflow of reports when they are stored in SharePoint Server 2007 document libraries.· Manage a single security model for reports through the SharePoint document library. · Use the SharePoint Server 2007 out-of-the-box Report Center template to easily build a site to store reports.Microsoft Office PerformancePoint Server. PerformancePoint® Server is an integrated performance management application that employees can use to monitor, analyze, and plan business activities based on the analytical data provided by SQL Server 2008.This white paper shows how SQL Server 2008 and its integration with the 2007 Office System can help you unify business intelligence data storage and access, build and manage sophisticated BI solutions, and extend the reach of those solutions to all of your employees.Unifying Data Storage and AccessMost organizations have multiple business systems, each with its own dedicated data store. Although you can often generate reports from individual applications and perform analysis on the data they contain, you can only achieve complete and consistent insight into the business by consolidating disparate data throughout the enterprise to create a central source of business data for reporting and analysis.Consolidating Corporate Data for Analysis and ReportingSQL Server 2008 supports two common approaches to unifying business data for analysis and reporting:· Data warehouse. A data warehouse is a dedicated data store for enterprise-wide data, which is populated and synchronized with business data from disparate data sources throughout the enterprise. The key advantage of this approach is that you can design the data warehouse for optimal analytical and reporting performance with no impact on the performance of the line-of-business applications from which the data originates. Another advantage is that you can clean and consolidate data that comes from multiple sources into a single consistent version of the truth.Data source abstraction. SQL Server 2008 Analysis Services enables the creation of data source views to provide an abstraction layer over one or more data sources. You can then use the data source view as a single source for Analysis Services, Integration Services, and Reporting Services. With a data source view, the data is retrieved from the underlying source systems when analysis occurs or a report is generated. This enables real-time analysis of the data in your business applications. Additionally, the data source view through its added layer of abstraction can be used to create friendly names to replace long or cryptic table names.These approaches are shown in the following illustration. With SQL Server 2008, you can use either one or a combination of the two.Work with All of Your Data the Way You Want toRegardless of which approach you take to unify your business data, SQL Server 2008 builds on its strong legacy of support for both relational and non-relational data by providing data types that enable developers and administrators to efficiently store and manage unstructured data such as documents and images, so you can store, manage, and analyze data in the format that best suits your business.SQL Server 2008 includes enhanced support for XML data storage as well as a FILESTREAM data type that enables large binary data to be stored in the file system yet remain an integral part of the database with transactional consistency. Additionally, restrictions on the size of user-defined data types have been removed, which makes it possible to exceed the 8-KB limit imposed in earlier releases of SQL Server. Support for spatial and location data types makes it possible to store and analyze geographical data that conforms to industry standards.Integrate All Enterprise Data SourcesSQL Server 2008 data source views enable integration of data and access to data that originates from heterogeneous enterprise-wide data stores, such as SQL Server, Oracle, DB2, and Teradata. These views also provide an OLAP store of enterprise scale; the breadth of support for diverse data sources 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 accomplish, 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 2008 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 communication across your extended enterprise systems.Data Warehouse PerformanceSQL Server 2008 provides a comprehensive 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 ProcessesData 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 up-to-date.SQL Server Integration Services provides a comprehensive 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 common operation in ETL processes, and in SQL Server 2008 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 2008 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 and its cause.Manage Hardware Resources EfficientlyThrough support for data compression, SQL Server 2008 enables you to store your data more effectively and reduce storage costs. In addition, the compression significantly improves performance for large input/output bound workloads. SQL Server 2008 also provides native support out-of-the-box for backup compression. Additionally, the VARDECIMAL data type and new sparse columns in SQL Server 2008 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 2008 supports dynamic allocation of Address Windowing Extensions (AWE) mapped memory that supports up to 64 gigabytes of memory with Windows Server® 2003, Datacenter Edition, and 2 terabytes with the 64-bit edition, to support large data warehouse environments.SQL Server 2008 also introduces Resource Governor, which enables administrators to define resource limits and priorities for different workloads, so that concurrent workloads can provide consistent performance