| |
|
|
|
| |
|
|
| |
Data warehousing Solution |
| |
A data warehouse is a repository of an organization's computer generated data set up in a way to facilitate fast retrieval of correct data without slowing down the operational systems of the organization. Besides speed, an oft-stated goal is to make data retrieval easier than it would be if data were to be retrieved directly from the operational systems.
|
| |
| Advantages of data warehouses |
|
| |
 |
Data warehouses make it easier for end users to access a variety of data |
| |
|
Decision support system users can obtain trend reports, e.g., the items with the most sales in a particular area within the last two years, exception reports, reports that show actual performance versus goals. |
| |
| |
| |
|
Data warehouses can work in conjunction with and, hence, enhance the value of operational business applications, notably customer relationship management (CRM) systems. |
| |
|
| Disadvantages of data warehouses |
|
| |
|
Over their life, data warehouses can have high costs |
| |
|
The data warehouse is usually not static. Maintenance costs are high |
| |
|
Data warehouses can get outdated relatively quickly |
| |
|
There is a cost of delivering suboptimal information to the organization |
| |
|
There is often a fine line between data warehouses and operational systems |
| |
|
Duplicate, expensive functionality may be developed. Or, functionality may be developed in the data warehouse that, in retrospect, should have been developed in the operational systems and vise versa |
| |
|
| |
|
|
|
| : : : : : |
copyright@nextgbl.com / Software & IT Services Outsourcing India |
|
|
