Abstract

A data warehouse is an asset for an enterprise and exists for the benefit of an entire enterpriseincluding business unit, individual customer, Student etc. Data in a data warehouse does not conform specifically to the preferences of any single enterprise entity. Instead, it is intended to provide data to the entire enterprise in such a way that all members can use the data in the warehouse throughout its lifespan [7]. This work explores using the star schema forAutomation of a Data Warehouse. An implementation of a data warehouse for an Examination Automation System is presented as an example.

References

• A. Gupta, V. Harinarayan, and D. Quass. Aggregatequery processing in data-warehousing environments. In Proc. 21th Int. Conf. on Very Large Data Bases, Zurich, Switzerland, 1995.
• ACM/ IEEE-CS Joint Task Force for Computing Curriculum 2005. "Computing Curriculum 2005". The Over view report" 30 Sep, 2005
• C. Fahrner, and G. Vossen. A survey of database transformations based on the Entity-Relationship model. Data & Knowledge Engineering, vol. 15, n. 3, pp. 213-250. 1995. :
• CAI Yong, HE Guangsheng, "Designing Model of Data Warehouse with OO Method [J]", Computer Engineering and Applications, 2003. 6.
• Inmon, W. H. , "Building the Data Warehouse", Second Edition, John Wiley & Sons, Inc 1996
• Fon Silvers, "Building and Maintaining a Data Warehouse," AN AUERBACH BOOK", CRC Press is an imprint of the Taylor & Francis Group, an informa business
• Jeff Lawyer, ShamsulChowdhury, " Best Practices in Data Warehousing to Support Business Initiatives and Needs", Proceedings of the 37th Hawaii International Conference on System Sciences – 2004
• Jorge Bernardino, Pedro Furtado, Henrique Madeira," A Cost Effective Approach for Very Large Data Warehouses", Proceedings of the International Database Engineering and Applications Symposium, 2002
• Kimball, Ralph, "The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses", John Wiley & Sons, Inc, 1996.
• Krishna. "Principles of Curriculum Design and Revision: A Case Study in Implementing Computing Curricula CC2001". ITiCSE'05, June 27–29, 2005
• Larry, Greenfield, LGI Systems Inc. , "The Data Warehousing Information Center," 1997 pp http://pwp. starnetinc. com/larryg/index. html.
• LIN Yu,etc, "The Principles and Applications of Data Warehouse [M]", Posts & Telecommunications Press, 2003. 1
• R. Barquin, and S. Edelstein. "Planning and Designing, the Data Warehouse",. Prentice Hall, 1996.
• REN Jinluan, GU Peiliang, ZENG Zhenxiang, "Research on the Methods of Designing Data Structure of Data Warehouse [J]". Computer Engineering and Applications, 2001. 22.
• SvetlozarNestorov, NenadJuki?, "Ad-Hoc Association-Rule Mining within the Data Warehouse", Proceedings of the 36th Hawaii International Conference on System Sciences, 2002
• Syed Najam-ul-Hassan, MaqboolUddinShaikh, UzairIqbalJanjua," Data Warehousing an Academic Discipline "Curriculum Development Approach, Methodologies and Issues", 2006
• Wu Shuning, Cui Deguang, Cheng Peng ,"The Four-stage Standardized Modeling Method in Data Warehouse System Development" Proceedings of the IEEE International Conference on Mechatronics & Automation Niagara Falls, Canada • July 2005
• YUAN Hong, HE Houcun, "Online Analysis and Data Warehouse Modeling Technologies [J]", Computer Application Research, 1999. 12.