計算機專業(yè)外文翻譯---sql server 2008商業(yè)智能

1、<p>　　畢業(yè)設(shè)計（論文）外文翻譯</p><p><b>　?。?011屆）</b></p><p>　　外文題目 SQL Server 2008 Business Intelligence </p><p>　　譯文題目 SQL Server 2008商業(yè)智能

2、 </p><p>　　外文出處 微軟官網(wǎng) </p><p>　　學(xué) 生 </p><p>　　SQL Server 2008 Business Intelligence

3、</p><p>　　White Paper</p><p>　　Published: August 2007</p><p>　　Updated: July 2008 </p><p>　　Summary: SQL Server 2008 makes business intelligence available to everyone t

4、hrough 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

5、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 introducti</p>

6、<p>　　For the latest information, see Microsoft SQL Server 2008.</p><p>　　Introduction</p><p>　　In an increasingly competitive marketplace, businesses are realizing that they can only succ

7、eed 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

8、use of the available resources and make effective business decisions.</p><p>　　To meet these challenges, employees need to gain actionable insight into the business so that they can make intelligent, informe

9、d 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 a

10、nalysis of a complete and consistent version of all enterprise data.</p><p>　　Microsoft Business Intelligence Technologies </p><p>　　Microsoft provides a comprehensive Business Intelligence (BI)

11、 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 informatio

12、n. At the core of the Microsoft BI end-to-offering is Microsoft® SQL Server® 2008, a complete data platform that enables you to:</p><p>　　Unify storage and access for all data across the enter

13、prise.</p><p>　　Build and manage sophisticated BI solutions.</p><p>　　Increase the reach of your business intelligence solution to empower all employees.</p><p>　　The specific techn

14、ologies of SQL Server 2008 that form the basis of this powerful BI offering are described in the following table.</p><p>　　While SQL Server 2008 delivers a comprehensive BI platform, it is through deep integ

15、ration 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.</p><p&g

16、t;　　2007 Microsoft Office System Integration</p><p>　　The SQL Server 2008 BI platform reaches information workers through the following 2007 Office System components:</p><p>　　Microsoft Off

17、ice 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 a

18、nd Excel 2007, you can:</p><p>　　Enhance the end user’s ability to access and analyze data from SQL Server 2008 Analysis Services. With Excel 2007, end users can browse data that is stored in multi

19、dimensional 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

20、on most desktop computers. </p><p>　　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 Servic

21、es 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.</p><p>　　Make predictive analy

22、sis 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 e

23、nd user in mind, Data Mining Add-Ins for Office 2007 empowers end users to perform complex analysis directly in Excel and Microsoft Office Visio®.</p><p>　　Add automatic analysis features, such as

24、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

25、 to meet a specific goal.</p><p>　　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 r

26、eports directly in Excel.</p><p>　　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, whi

27、ch enables you to render SQL Server 2008 Reporting Services reports in Word format.</p><p>　　Microsoft Office Visio. Visio is a drawing and diagramming application that you can use to annotate, enhance,

28、 and present your data mining graphical views. With SQL Server 2008 and Visio 2007, you can: </p><p>　　Render decision trees, regression trees, cluster diagrams, and dependency nets.</p><

29、;p>　　Save data mining models as Visio documents embedded in other Office documents or saved as a Web page.</p><p>　　Microsoft Office SharePoint Server. SharePoint® Server is comprehensive collaborati

30、on, 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

31、 and timely analytical views, reports, and KPIs. The integration of SQL Server 2008 Reporting Services with SharePoint Server 2007 enables you to:</p><p>　　Use one consistent user interface to mana

32、ge and view reports.</p><p>　　Track versions and workflow of reports when they are stored in SharePoint Server 2007 document libraries.</p><p>　　Manage a single security model for reports t

33、hrough the SharePoint document library. </p><p>　　Use the SharePoint Server 2007 out-of-the-box Report Center template to easily build a site to store reports.</p><p>　　Microsoft Office Per

34、formancePoint 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 SQ

35、L Server 2008.</p><p>　　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 m

36、anage sophisticated BI solutions, and extend the reach of those solutions to all of your employees.</p><p>　　Unifying Data Storage and Access</p><p>　　Most organizations have multiple business s

37、ystems, 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 int

38、o the business by consolidating disparate data throughout the enterprise to create a central source of business data for reporting and analysis.</p><p>　　Consolidating Corporate Data for Analysis and Reporti

39、ng</p><p>　　SQL Server 2008 supports two common approaches to unifying business data for analysis and reporting:</p><p>　　Data warehouse. A data warehouse is a dedicated data store for enterpris

40、e-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 analytic

41、al 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</p>

42、<p>　　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

43、 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

44、enables real-time analysis of the data in your business applications. Additi</p><p>　　These approaches are shown in the following illustration. With SQL Server 2008, you can use either one or a combinat

45、ion of the two.</p><p>　　Work with All of Your Data the Way You Want to</p><p>　　Regardless of which approach you take to unify your business data, SQL Server 2008 builds on its strong

46、 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

47、store, manage, and analyze data in the format that best suits your business.</p><p>　　SQL Server 2008 includes enhanced support for XML data storage as well as a FILESTREAM data type that enables large binar

48、y 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 possi

49、ble 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 geog</p><p>　　Integrate All Enterprise Data Sou

50、rces</p><p>　　SQL 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 Teradat

51、a. 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 a

52、pplications. Therefore, unifying the data in all of your enterprise data sources is easy to accom</p><p>　　Additionally, through support for Web services and the Microsoft .NET Framework, SQL Server 200

53、8 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. Sup

54、port for existing and emerging open standards, such as HTTP, XML, SOAP, XQuery, and XSD, further facilitate communication across your extended enterprise systems.</p><p>　　Data Warehouse Performance</p>

55、;<p>　　SQL 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 d

56、ata and users.</p><p>　　Optimize ETL Processes</p><p>　　Data warehouses are usually populated and updated with data from source systems through an ETL process. After the initial load of data int

57、o 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.</p><p>　　SQL Server Integration Services provides a com

58、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. Per

59、forming 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 improve

60、d so that these ope</p><p>　　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 i

61、t easy to identify rows that have been modified and to determine the details of the modification and its cause.</p><p>　　Manage Hardware Resources Efficiently</p><p>　　Through support for data c

62、ompression, 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 Serve

63、r 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 storag

64、e resources by reducing the amount of space that </p><p>　　In addition to efficiencies in data storage, SQL Server 2008 supports dynamic allocation of Address Windowing Extensions (AWE) mapped memory th

65、at 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.</p><p>　　SQL

66、 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 and make

67、 it possible to manage resource contention issues proactively.</p><p>　　Optimize Database Performance</p><p>　　SQL Server 2008 includes a high-performance relational database engine that enables

68、 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 heavi

69、ly queried data warehouse. With the introduction of the MERGE Transact-SQL statement in SQL Server 2008, developers can more effectively handle common data warehousing scenarios, such as checking whethe</p>&

70、lt;p>　　SQL Server 2008 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 war

71、ehouse by using partitioned tables.</p><p>　　Building and Managing Sophisticated BI Solutions</p><p>　　As organizations demand ever increasingly complex analytics, the need to be able to bu

72、ild and deliver effective BI solutions quickly and to reduce the management overhead of your BI infrastructure has become a major consideration. SQL Server 2008 includes innovative tools that increase developer prod

73、uctivity and manageability, which enables faster capitalization on new analysis and reporting capabilities while incurring reduced administrative overhead.</p><p>　　Developer Productivity</p><p>

74、;　　SQL Server 2008 simplifies the development of business intelligence solutions. BI developers benefit from easy-to-use utilities and tools that increase control and automate routine, time-consuming tasks, and can use t

75、he productivity features of SQL Server 2008 to create effective analysis and reporting solutions more quickly than ever; so your organization can take advantage of them sooner.</p><p>　　Use a Rich, Mode

76、rn Programming Environment.</p><p>　　Through tight interoperability with Microsoft Visual Studio®, developers can easily build and maintain robust, secure, scalable BI applications. SQL Server Busi

77、ness Intelligence Development Studio 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

78、 that are delivered as part of the Business Intelligence Development Studio make it easy for even novice developers to b</p><p>　　By embedding the common language runtime (CLR) in the database engine, SQL Se

79、rver 2008 enables developers to choose from a variety of languages to develop applications, including Transact-SQL, Microsoft Visual Basic®, and C#®. This flexible environment enables developers to use the

80、ir existing skills to efficiently develop database applications. </p><p>　　When integrated with Visual Studio, the development experience across all of the SQL Server 2008 BI technologies is optimized for pr

81、oviding a true application development environment that supports the full project development life cycle (develop, test, deploy, modify, and test).</p><p>　　Implement Best Practice Solutions </p><

82、p>　　Enabling developers to build solutions more quickly is only effective if those solutions are optimally designed. To help ensure the best possible performance and correct functionality, SQL Server 2008 includes the

83、 following development environment features that promote best practices and help developers create effective analysis solutions:</p><p>　　A consistent development environment for all BI solutions, including

84、Analysis Services, OLAP, and data mining applications.</p><p>　　Built-in support for the full development lifecycle, including design, build, debug, and deploy operations; and support for team-based developm

85、ent through integrated support for source control.</p><p>　　A number of intuitive designers and wizards that make it easy to create Analysis Services solutions quickly.</p><p>　　An attribute rel

86、ationship designer that includes built-in validations to help in creating optimal dimension designs.</p><p>　　A dimension editor that has been slimmed down to provide better productivity and the presence of

87、parent child relationships is automatically detected.</p><p>　　A cube designer that has been streamlined and improved to provide better detection and classification of attributes along with identification of

88、 member properties.</p><p>　　Aggregation of individual partitions, which enables you to optimize measures from different periods or areas.</p><p>　　The aggregation designer has a new algorithm t

89、o help create initial aggregations. The aggregation designer is optimized to work with usage driven aggregations. You can now look at the aggregations that have been created and add to those aggregations or remove them.

90、Intelligent support is provided to help with merging existing and new aggregation designs.</p><p>　　Additionally, SQL Server 2008 provides AMO warnings to alert developers when their design breaks one of ove

91、r 40 best practices. These warnings are integrated into real-time designer checks, and provide a non-intrusive way for developers to detect potential problems with their design.</p><p>　　Increase Report

92、ing Flexibility</p><p>　　Reporting is a significant element of any BI solution, and business users are demanding increasingly complex reports. SQL Server Reporting Services provides the following features to

93、 make it easy to build reporting solutions:</p><p>　　A Visual Studio-based report development interface in Business Intelligence Development Studio that developers can use to build, debug, and deploy reports

94、.</p><p>　　A business-focused report development tool named Report Builder that business users can use to create and deploy reports.</p><p>　　A wide range of data display structures, including t

95、ables, matrices, lists, and charts.</p><p>　　Additionally, SQL Server 2008 includes extensive enhancements to Reporting Services that improve reporting performance and provide increased flexibility for forma

96、tting and publishing reports. One of the enhancements made to Reporting Services in SQL Server 2008 is support for a new layout structure that combines table and matrix data regions into a new Tablix data region. Ta

97、blix enables developers to generate reports that combine fixed and dynamic rows. Previously, layouts of this kind had to be</p><p>　　Manageability</p><p>　　Through innovations such as a unified

98、management tool, enhanced self-tuning capabilities, and a powerful management programming model, SQL Server 2008 extends the SQL Server ease-of-use leadership and increases the productivity of database administ

99、rators (DBAs). These enhancements enable DBAs to focus on high value tasks, like database architecture, while spending less time on routine maintenance, configuration, and tuning.</p><p>　　Use a Single, Unif

100、ied Tool</p><p>　　SQL Server 2008 provides DBAs with SQL Server Management Studio; a single, unified management tool that provides integrated management of Analysis Services, Reporting Services, Integra