Understadning the Components of SQL Server 2014
SQL Server 2014 includes a powerful relational database engine, but as a complete data platform and more such:
Database Engine: A relational database engine based on the SQL language
Analysis Services: An online analytical processing (OLAP) engine that enables
business analysts to query multidimensional and tabular data models, and to perform data mining.
Integration Services: A tool used to orchestrate the movement of data between SQL Server components and external systems (in both directions)
Reporting Services: Offers a reporting engine based on web services and provides a
web portal and end-user reporting tools
Master Data Services: Provides a platform for managing master or reference data
StreamInsight: A platform for building applications to process high-speed events
Data Mining: Provides tooling and an inference engine for deriving knowledge and insights from existing OLAP data or relational data
Full-Text Search: Enables the inclusion of sophisticated search options into applications.
PowerPivot: A component of Analysis Services that enables end-users, power users, and business analysts to share Excel workbooks that contain tabular data models in SharePoint Server.
Replication: Enables synchronization of data between servers to suit data distribution needs
Data Quality Enables data cleansing and matching to ensure optimal data
Services: quality
Power View: A component of Reporting Services that enables users to create interactive visualization of data models in SharePoint Server.
Database Engine: A relational database engine based on the SQL language
Analysis Services: An online analytical processing (OLAP) engine that enables
business analysts to query multidimensional and tabular data models, and to perform data mining.
Integration Services: A tool used to orchestrate the movement of data between SQL Server components and external systems (in both directions)
Reporting Services: Offers a reporting engine based on web services and provides a
web portal and end-user reporting tools
Master Data Services: Provides a platform for managing master or reference data
StreamInsight: A platform for building applications to process high-speed events
Data Mining: Provides tooling and an inference engine for deriving knowledge and insights from existing OLAP data or relational data
Full-Text Search: Enables the inclusion of sophisticated search options into applications.
PowerPivot: A component of Analysis Services that enables end-users, power users, and business analysts to share Excel workbooks that contain tabular data models in SharePoint Server.
Replication: Enables synchronization of data between servers to suit data distribution needs
Data Quality Enables data cleansing and matching to ensure optimal data
Services: quality
Power View: A component of Reporting Services that enables users to create interactive visualization of data models in SharePoint Server.
Understadning the Components of SQL Server 2014
Reviewed by Unknown
on
11:47 PM
Rating:
No comments: