 |
| - A - |
| - B - |
| - C - |
| - D - |
| - E - |
| - F - |
| - G - |
| - H - |
| - I - |
| - J - |
| - K - |
| - L - |
| - M - |
| - N - |
| - O - |
| - P - |
| - Q - |
| - R - |
| - S - |
| - T - |
| - U - |
| - V - |
| - W - |
| - X - |
| - Y - |
| - Z - |
Data Warehouse
Data Warehouse
The basis of a data warehouse centers around storing electronic information. The following definitions may also apply: to retrieve and analyze data, to extract, modify and load data, and to manage dictionary data. A data warehouse may also be referred to as a tool for business intelligence or a tool designed for managing and retrieving metadata.
Benefits of a data warehouse:
Common data model - a data warehouse is able to store and manage data regardless of it’s source. This adds simplicity to the task of reporting and analyzing information.
Efficiency - inconsistencies are detected and resolved prior to being loaded.
Reliability - data can be stored securely for a long period of time.
Fast - because it stands alone from the operational system, a date warehouse offers quick retrieval of data.
Compatibility - a data warehouse facilitates various support system applications. This allows data to analyzed and reported in many different ways. A data warehouse also works in conjunction with operational business software in which it enhances the value in CRM (customer relationship management) systems.