Difference between revisions of "Data warehouse"
From LIMSWiki
Jump to navigationJump to searchShawndouglas (talk | contribs) (Created article stub.) |
Shawndouglas (talk | contribs) (Added further reading.) |
||
| Line 2: | Line 2: | ||
The typical data warehouse uses staging, integration, and access layers to house its key functions. The staging layer stores raw data, the integration layer integrates the data and moves it into hierarchal groups, and the access layer helps users retrieve data.<ref name=IJCA96Patil>{{cite journal |url=http://www.ijcaonline.org/proceedings/icwet/number9/2131-db195 |author=Patil, Preeti S.; Srikantha Rao; Suryakant B. Patil |title=Optimization of Data Warehousing System: Simplification in Reporting and Analysis |work=IJCA Proceedings on International Conference and workshop on Emerging Trends in Technology (ICWET) |journal=International Journal of Computer Applications |year=2011 |volume=9 |issue=6 |pages=33–37 |publisher=Foundation of Computer Science}}</ref> | The typical data warehouse uses staging, integration, and access layers to house its key functions. The staging layer stores raw data, the integration layer integrates the data and moves it into hierarchal groups, and the access layer helps users retrieve data.<ref name=IJCA96Patil>{{cite journal |url=http://www.ijcaonline.org/proceedings/icwet/number9/2131-db195 |author=Patil, Preeti S.; Srikantha Rao; Suryakant B. Patil |title=Optimization of Data Warehousing System: Simplification in Reporting and Analysis |work=IJCA Proceedings on International Conference and workshop on Emerging Trends in Technology (ICWET) |journal=International Journal of Computer Applications |year=2011 |volume=9 |issue=6 |pages=33–37 |publisher=Foundation of Computer Science}}</ref> | ||
==Further reading== | |||
* {{cite web |url=http://www.labvantage.com/blog/?p=79 |title=Advantages of a Data Warehouse |author=Vannest, Jeff |publisher=LABVANTAGE Solutions, Inc. |date=11 February 2011 |accessdate=17 February 2012}} | |||
==References== | ==References== | ||
<references /> | <references /> | ||
Revision as of 00:38, 18 February 2012
In computing, a data warehouse is a database used for reporting and analysis. The data stored in the warehouse is uploaded from the operational systems. The data may pass through an operational data store for additional operations before it is used in the data warehouse for reporting.
The typical data warehouse uses staging, integration, and access layers to house its key functions. The staging layer stores raw data, the integration layer integrates the data and moves it into hierarchal groups, and the access layer helps users retrieve data.[1]
Further reading
- Vannest, Jeff (11 February 2011). "Advantages of a Data Warehouse". LABVANTAGE Solutions, Inc.. http://www.labvantage.com/blog/?p=79. Retrieved 17 February 2012.
References
- ↑ Patil, Preeti S.; Srikantha Rao; Suryakant B. Patil (2011). "Optimization of Data Warehousing System: Simplification in Reporting and Analysis". International Journal of Computer Applications (Foundation of Computer Science) 9 (6): 33–37. http://www.ijcaonline.org/proceedings/icwet/number9/2131-db195.
