SEMANTIC BASED TEST DATA EXTRACTION FOR INTEGRATED SYSTEMS (iSTDE)

Ali Raza, Stephen Clyde

Abstract

Testing an integrated information system that relies on data from multiple sources can be a serious challenge, particularly when the data is confidential. Such is the case for the Child-Health Advanced Record Management (CHARM) system, which is now in production at the Utah Department of Health. CHARM allows various public health-care programs, like vital records, immunization, and hearing screening, to seamlessly access data from each others’ databases in real-time. Since CHARM deals with confidential health-care information, it was impossible to use real data for testing purposes, especially since the development and testing environments were outside the confidential environment in which CHARM operates. This paper describes a test-data extraction tool built and successfully used for testing the CHARM system. This tool, called Semantic based Test Data Extractor for Integrated Systems or iSTDE, reads a consistent cross-section of data from the production databases, manipulates that data to obscure individual identities while preserving overall data characteristics that are critical to thorough system testing, and finally moves that test data from the confidential production environment to the unprotected test environment.

References

  1. GenerateData.com, a tool for generating test data, last accessed on December 22, 2008.
  2. SqlEdit, www.sqledit.com, last accessed on November 28, 2008.
  3. www.forsql.com, a tool for automatics generating test data for developers, last accessed on December 30, 2008.
  4. http://www.tethyssolutions.com/T10.htm, a tool for generating meaningful randomized data for QA testing, load testing, last accessed on December 30, 2008.
  5. www.tns-soft.com, a tool for generating meaningful randomized data for QA testing, load testing, last accessed on December 30, 2008.
  6. www.datanamic.com, generate the test data from a variety of sources, including the database tables, last accessed on December 30, 2008.
  7. www.turbodata.ca, generate the test data from a real database, last accessed on February 11, 2008.
  8. R.Maddy, DBTESTGEN - MS Thesis 2006, Computer Science Department, Utah State University.
  9. Clyde, S., and Salkowitz, S., The Unique Records Portfolio, Public Health Informatics Institute, Decatur, GA, April, 2006.
  10. http://www.sqlmanager.net/en/products/postgresql/datage nerator, generate the test data by a variety of sources, last accessed on February 11, 2008.
  11. Bersano, T., Clement, B., and Shilkrot, L. Synthetic Data for Testing in Databases, University of Michigan, 1997.
  12. Harper, K.E. Syntactic and semantic problems in automatic sentence generation. In Proceedings of International Conference on Computational Linguistics, 1967, 1-9.
  13. Chays, D., Dan, S., Vokolos, F.I., and Weyuker, E.J. A framework for testing database applications. In ISSTA 2000, ACM 1-58113-266-2.
  14. Phyllis F., D. Chays, Test data generation for relational database applications, 2004, ACM AA13115007.
Download


Paper Citation


in Harvard Style

Raza A. and Clyde S. (2010). SEMANTIC BASED TEST DATA EXTRACTION FOR INTEGRATED SYSTEMS (iSTDE) . In Proceedings of the Third International Conference on Health Informatics - Volume 1: HEALTHINF, (BIOSTEC 2010) ISBN 978-989-674-016-0, pages 173-180. DOI: 10.5220/0002692401730180


in Bibtex Style

@conference{healthinf10,
author={Ali Raza and Stephen Clyde},
title={SEMANTIC BASED TEST DATA EXTRACTION FOR INTEGRATED SYSTEMS (iSTDE)},
booktitle={Proceedings of the Third International Conference on Health Informatics - Volume 1: HEALTHINF, (BIOSTEC 2010)},
year={2010},
pages={173-180},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002692401730180},
isbn={978-989-674-016-0},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Third International Conference on Health Informatics - Volume 1: HEALTHINF, (BIOSTEC 2010)
TI - SEMANTIC BASED TEST DATA EXTRACTION FOR INTEGRATED SYSTEMS (iSTDE)
SN - 978-989-674-016-0
AU - Raza A.
AU - Clyde S.
PY - 2010
SP - 173
EP - 180
DO - 10.5220/0002692401730180