Parsing SQL Server 2005 Business Intelligence features

This article describes the 10 most important features of SQL Server 2005 in terms of database business intelligence features ...

Analysis Services

SQL Server2005 Analytics Services have entered the field of real-time analysis. From enhancements to upgradeable performance to deep integration with Microsoft Office software, SQL Server2005 will help you extend business intelligence to every level of your business.

Data transfer Services (DTS)

The DTS Data Transfer service is a set of drawing tools and programmable objects that you can use to extract, transfer, and load (ETL) data from disparate sources, while transferring it to individual or multiple destinations. SQL Server2005 will introduce a complete, data transfer service, redesign program, which provides users with a comprehensive extract, transfer and load platform.

Data mining

We will introduce four new data mining algorithms, improved tools and sprites that will make data mining easier for businesses of any size.

Reporting Services

In SQL Server2005, Reporting Services will provide self service for an online analytical processing (OLAP) environment, create end-user ad hoc reports, enhance the development level of queries, and allow for enhanced performance in the context of enabling upgrades to enrich and facilitate the maintenance of an enterprise reporting environment.

Cluster support

Analysis Services improve their availability by supporting fault-tolerant technology transfer clustering, enhanced support for multiple-performing individuals, and support for backup and recovery analysis of service objects and data.

Main Operating indicators

The main operational metrics (KPIS) provide the enterprise with new capabilities to define charting, and customizable business metrics to help companies develop and track key business benchmarks.

Scalability and performance

Parallel split processing, the creation of remote relations on-Line Analytical Processing (ROLAP) or hybrid online analytical processing (HOLAP) segmentation, distributed segmentation units, continuous computing, and prefabricated caching features, greatly enhance the scalability and performance of the Analysis Services in SQL Server2005.

Click the cell

When you create a cell in a data warehouse, the Unit wizard includes an action that you can click on Unit detection and recommendations.

Prefabricated cache

The prefabricated cache merges the MOLAP level query run with the real-time data analysis to eliminate the need to maintain the online analytical processing storage. It is obvious that the prefab cache synchronizes and maintains an updated backup of the data, which is specifically organized for high-speed queries, separating end users from overloaded related databases.

Integration with Microsoftofficesystem

In report services, reports provided by the report server can run in the environment of the Microsoftsharepoint Portal Server and the Microsoftofficesystem application software. Officesystem application software includes MicrosoftWord and MicrosoftExcel. You can use SharePoint features, subscribe to reports, create new versions of reports, and distribute reports. You can also open a report in Word or Excel software to view a report of the Hypertext Connection Markup Language (HTML) version.