Business Intelligence with Microsoft SQL Server 2005
page 2 of 5
by Rajdeep Mukherjee
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 20632/ 48

Business Intelligence and Databases

Let us first take a look into the incorporation of Business Intelligence in databases. As we all know, that information is stored in databases in the form of useful data. When this data quantity is too high (for example, greater than 10 GB), Data Warehousing concept comes in and data is normally organized and stored in a data warehouse. Any such data warehouse supports multiple databases of same or different nature. For example, a data warehouse can store in structured format the mixture of several databases that are specific to SQL Server, Oracle, and DB2, etc. Database applications that work with backend databases normally go for various role based logins for its users having specific roles and corresponding privileges within the application. For example, there can be role based logins for administrators, directors, managers, sales reps, etc. and each of these groups can have specific defined set of privileges within the application.

The behavior of the application is a summation of the activities of all of these user roles. These database applications, however, do not possess management skills, but are primarily intended for providing useful data that helps the management users to make faster and important business decisions. One primary point to be noted here is that the data stored for this purpose should be accurate and plenty. This will help to make correct business decisions and make accurate business forecasts.       

View Entire Article

User Comments

No comments posted yet.

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2022  |  Page Processed at 2022-08-15 9:07:13 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search