Data Management And Analysis Technologies in SQL

Management and Analysis Technologies	Description
Database Engine	The Database Engine is the core service for storing, processing and securing data. The Database Engine provides controlled access and rapid transaction processing to meet the requirements of the most demanding data consuming applications within your enterprise. The Database Engine also provides rich support for sustaining high availability.
Analysis Services - Multidimensional Data	Analysis Services supports OLAP by allowing you to design, create, and manage multidimensional structures that contain data aggregated from other data sources, such as relational databases.
Analysis Services - Data Mining	Analysis Services enables you to design, create, and visualize data mining models. These mining models can be constructed from other data sources by using a wide variety of industry-standard data mining algorithms.
Integration Services	Integration Services is a platform for building high performance data integration solutions, including packages that provide extract, transform, and load (ETL) processing for data warehousing.
Replication	Master Data Services is the source of master data for your organization. By integrating disparate operational and analytic systems with Master Data Services, you ensure that all applications across the organization rely on a central, accurate source of information. Using Master Data Services, you create a single source of master data and maintain an auditable record of that data as it changes over time.
Reporting Services	Reporting Services delivers enterprise, Web-enabled reporting functionality so you can create reports that draw content from a variety of data sources, publish reports in various formats, and centrally manage security and subscriptions.
SharePoint Integration	SQL Server 2008 R2 offers new self-service business intelligence capability through integration with SharePoint products and technologies. In this release, both Analysis Services and Reporting Services support deployment in a SharePoint farm.
Service Broker	Service Broker helps developers build scalable, secure database applications. This new Database Engine technology provides a message-based communication platform that enables independent application components to perform as a functioning whole. Service Broker includes infrastructure for asynchronous programming that can be used for applications within a single database or a single instance, and also for distributed applications.