Font Size: a A A

The Application Of High Education Information Management System Based On Operational Data Store

Posted on:2006-08-18Degree:MasterType:Thesis
Country:ChinaCandidate:G X YangFull Text:PDF
GTID:2168360155450089Subject:Computer application technology
Abstract/Summary:PDF Full Text Request
With the application of high education information management system,large amount of history datum accumulated.People push more and more demands on decision-making based on history datum.These brand-new demands,companied with the development of data warehouse technique,make it necessary to build a warehouse on high education information management system. Be aware of the necessity and feasibility of the data warehouse technique,we have designed and implemented a data warehouse of high education information management system.The system is comprised of database,operational data store and data warehouse. Operational data store is a data storage technique which is between database and data warehouse,which is an architectural construct that is subject oriented,integrated,volatile,current valued,and contains detailed corporate data.ODS can recover the shortcoming the DW is hare to deal with real-time data. We often store the data in the warehouse as materialized view to speedup query processing on large amount of data . These views need to be maintained in respond to update in the source data. This paper has brought out a After-creating Version No-Locking based on a Multi-Version No-Locking for the maintenance of the ODS materialized views. I also discuss a strategy based on workflow to meet warehouse updating.
Keywords/Search Tags:data warehouse, operational data store, real-time updating, view maintenance, workflow
PDF Full Text Request
Related items