The Development and Validation of Data Transformat

  • Phelim Murnion
  • Claire Lally


The core functions of information technology — data storage, data processing and data retrieval — have become part of the basic infrastructure of business. Justification for the advantages of computing technology has moved from a data processing approach to a business-driven approach. Data Warehousing is a concept that supports this business-driven approach. The primary objective of a data warehouse is to facilitate management in the decision-making process. This is achieved by turning raw operational data into strategic information for decision making. Quality assurance is an important area of decision making in higher education. Data warehousing offers the possibility of utilising the large quantities of detailed student data held by institutions of higher education to support decision making in the quality assurance area. This chapter (the major thesis for a Masters Degree in Information Systems) describes work in progress on an investigation into data warehousing using student data.


Quality Assurance Data Warehouse Transformation Function Business Intelligence Educational Data 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


  1. Anthony, R. (1965) Planning and Controlling Systems: A Framework for Analysis. Harvard Business School Division of Research Press, Boston.Google Scholar
  2. Barquin, R. C. (1996) ‘On the First Issue of the Journal of Data Warehousing. ’ Journal of Data Warehousing, 1(1).Google Scholar
  3. Bischoff, J., Alexander, T., Foreword by Zachman, J. A. (1997) Data Transformation, Data Warehousing, Practical Advice from the Expert. Prentice Hall, New Jersey.Google Scholar
  4. Black, P., Wiliam, D. (1998) ‘Inside the Black Box: Raising Standards Through Classroom Assessment. Phi Delta Kappan, 80(2): 139–148.Google Scholar
  5. Bloom, B., Englehart, M. Furst, E., Hill, W., Krathwohl, D. (1956) Taxonomy of Educational Objectives: The Classification of Educational Goals. Handbook I: Cognitive Domain.Longmans/Green, New York/Toronto.Google Scholar
  6. Carr, N. G. (2003) IT Doesn't Matter. Harvard Business Review. May 2003, 5(12).Google Scholar
  7. Cronbach, L. J. (1984) Essential of Psychological Testing, 4th Edition. Harper, New YorkGoogle Scholar
  8. Devlin, B. (1997) Data Warehouse from Architecture to Implementation. Addison-Wesley Professional, Reading, MA.Google Scholar
  9. Dyché, J. (2000) E-data: Turning Data into Information with Data Warehousing. Addison-Wesley Information Technology Series, Reading, MA.Google Scholar
  10. Gagné, R. M., Briggs, L. J., Wager, W. G. (1992) Principles of Instructional Design, Harcourt Brace College Publishers, Fort Worth.Google Scholar
  11. Gorry, A. G., Scott Morton, M. S. (1989) ‘A Framework for management information systems. ’ Sloan Management Review, 13(1): 55–70.Google Scholar
  12. Gould, L. S. (1998) ‘What you need to know about data warehousing. ’ Automative Manufacturing & Production, 64(4). Retrieved February 18, 2007 from InfoTrac OneFile.Google Scholar
  13. Heise, D. L. (2006) ‘Data Warehousing and Decision Making in Higher Education in the United States’. Andrews UniversityGoogle Scholar
  14. HETAC (2002) Guidelines and Criteria for Assurance Procedures in Higher Education and Training, Higher Education and Training Awards Council, Dublin.Google Scholar
  15. Hoffer, J. A., Prescott, M. B., McFadden, F. R. (2001) Modern Database Management, 6th edition. Prentice Hall, New JerseyGoogle Scholar
  16. Hsu, T. (2005) Research Methods and Data Analysis Procedures Used by Educational Researchers. International Journal of Research and Method in Education 28(2): 109–133.Google Scholar
  17. Inmon, W. H. (1996) The Data Warehouse Environment, Building the Data Warehouse, 2nd edition. Wiley, New York.Google Scholar
  18. Light, D., Wexler, D. H., Hienze, J. (2004). ‘Keeping Teachers in the Center: A Framework of Data-Driven Decision Making’
  19. McAlpine, M. (2001) Workshop on Computer Assisted Assessment: Issues in the Large Scale Use of Multiple Choice Questions. Robert Clark Centre, University of Glasgow.Google Scholar
  20. Pellegrino, J. W., Chudowsky, N., Glaser, R. (2001) Knowing What Students Know: The Science and Design of Educational Assessment. National Academy Press, Washington, DC.Google Scholar
  21. Shahzad, M. A., (2003) ‘Data Warehousing with Oracle. ’ Retrieved March 5, 2007 from
  22. Thorndike, R. L. (1971) Educational Measurement. American Council of Education, Washington, DC.Google Scholar
  23. Zamanian, K., Diaz, N. (2002) ‘Apparatus and Method for performing Data Transformations in Data Warehousing. ’ United States Patent, Patent No. US 6,339,775 B1.

Copyright information

© Springer Science+Business Media, LLC 2009

Authors and Affiliations

  • Phelim Murnion
  • Claire Lally
    • 1
  1. 1.School of BusinessGalway Mayo Institute of TechnologyIreland

Personalised recommendations