User:Dhavalp453

What is Business Intelligence? Business Intelligence is the processes, technologies, and tools that help us change data into information, information into knowledge and knowledge into plans that guide organization Technologies for gathering, storing, analyzing and providing access to data to help enterprise users make better business Decisions

Database Engine- The database engine provides support to store,query,process,and secure data n the database server.The database engine allows you to create and manage database objects,such as tables.

service broker- provides support for asynchronous communication between clients and database server,enabling reliable query processing.the client application sends arequest to the database server and continues to work.the request sent by the client are queued up at the server,in case the server is not available to process the request immeditely.server broker ensures that the request in processed whenever the server is available.the preceding figure describes the example of the order processing system. the client application are sending order to the database server to enter the order details.All these orders are placed in queue,which is managed by service Broker.

Replication- allows you to copy and distribute data and database object from one database server to another.these server can be located at remote location to provides fast access to user at widely distributed location after replicating data, SQL server allows you to synchronize different database to maintain data consistency.for example,the database server for your organization might be located at different locations around the world.All the server store common data,To ensure that the data in all the server in synchronize,you can implement data replication.replication follows the publisher/subscriber model.in this model,the changes are sent out by one database server("publisher")and are received by other("subscribers").in the precending figure,articles are the database object to be replicated,these articales are contained in a publication.publication is the database data that is replicated.distributor takes the publications from the publisher and distributes them to the subscriber.

Full text search- allows you to implement fast and intelligent search in large databse.it allows you to search records containing certain words and phrases.you can search for different forms of a specific word,such as'produce','produces',or 'prodution'.In addition,you can search for synonyms of agiven word,such as 'garment','cloth',or'fabric'.

Notification services- Allows you to generate and send notification messages to the users or administrators about any event. for example,the database administrators should be notified when a table is created or deleted.the notification messages can be sent to variety of devices,such as computer or mobile devices.Notification services are a platform for developing and deploying highly scalable notification applications..It allows developers to build notificationn apllication that send timely,personalized information updates, helping to enhance customer relationship.

Integration services- integration services allow you to gather and integrate this varied data in a consistent format in a common database called the data warehouse.a data warehouse consists of integrated database,whis can be DBMS,text files,or flat files.A data warehouse is similar to aphysical warehouse that stores raw material or product for further distribution.the organization does not store useless materials or products in its warehouse because it cost money and affect the ability to get products in and out of the warehouse.similarly,a data warehouse should not contain useless data.the data should be meaningful and should be processed quickly. Sql server 2005 Integration services(SSIS) import and export wizard provides a series Of dialogs that helps you to complete the process of selecting the data source, the destination, and the objects that will be transferred to create a data warehouse

Analysis services- Data warehouses are desigend to facilitate reporting and analysis.Enterprises are increasingly using data stored in data warehouses for analytical purposes to assist them in making quick business decisions.the applications used for such analysis are termed as BI applications.Data analysis assists in determining past trends and formulating future business decisions.this type of analysis requires a large volume of data to reach a consistent level of sampling. The requirements for such an analysis include: 1 A large volume of data 2 Historical data, that is, data stored over a period of time.

Microsoft SQL Server 2005 analysis services(SSAS) provide Online Analytical Processing (OLAP) for BI applications. OLAP arranges the data in the data Warehouse in an easily accessible format. Now, this thing do by online.

Reporting services- Reporting services provide support to generate complete reports on data In the database engine or in the data warehouse.This service provide a set of tools that help in creating and managing different types of reports in different formats.using this services,you can create centralized reports that can be saved to a comman server.Reporting services provides secure and restricted access to these reports.

Microsoft SQL Server 2005 Reporting Services(SSRS) help in creating web-Based Reports that is based on the content stored in a variety of data sources.you can also publish these reports in different formats.