MU Yongmin, DING Yuan. Research of Automated Test Case Generation for Spreadsheet Part in Document Format Translator[J]. Chinese Journal of Electronics, 2014, 23(2): 243-247.
Citation: MU Yongmin, DING Yuan. Research of Automated Test Case Generation for Spreadsheet Part in Document Format Translator[J]. Chinese Journal of Electronics, 2014, 23(2): 243-247.

Research of Automated Test Case Generation for Spreadsheet Part in Document Format Translator

Funds:  This work is supported by the Key Discipline Construction Foundation of Beijing (No.PXM2011-014224-113530), Discipline and Graduate Education Foundation of Beijing (No.PXM2012-014224-000038).
  • Received Date: 2012-12-01
  • Rev Recd Date: 2013-07-01
  • Publish Date: 2014-04-05
  • Document format translator can achieve information sharing and interoperability between the office document national standard UOF (Uniform office format) and the international standard ISO29500 (Open office XML, OOXML). There are several difficult issues in the manual test of document format translator: the manual test case design is complicated due to the complexity of document standard; test case coverage rate is hard to evaluate and test blind spots are hard to avoid. This paper brings about methods to solve these problems by achieving automated test case generation. Analyzing the XML Schema of document standard in logical level, building UML object model in conceptual level, designing objectoriented algorithm based on the .Net platform, operate the underlying XML code of spreadsheet in physical level, and then compress underlying XML code to generate new spreadsheet documents as test case. A formal definition about the UOF document standard is presented and statistics of functional test point is conducted so as to measure test case coverage rate. Experiments have shown that this method can realize the automated generation of test cases, improve the efficiency of test work, decrease test case redundancy and avoid test blind spots.
  • loading
  • Li Ning, Wu Xinsong, Chinese Office Software Document Format Rules Use Guide, Hunan Normal University Press, Hunan, China, pp.12-14, 2010.
    Li Ning, Mu Yongmin, "Document format in the ‘content' and ‘performance' of separation and integration", Acta Electronica Sinica, Vol.35, No.2, pp.375-378, 2007. (in Chinese).
    Zhang Zhihua, Mu Yongmin, "Based on the path to override the generated function calls Research", Acta Electronica Sinica, Vol.38, No.8, pp.1808-1811, 2010. (in Chinese).
    W3C Recommendation, XML Schema Part 0: Primer Second Edition, http://www.w3.org/TR/2004/REC-xmlschema-0-20041028, 2004.
    Augustin Yu, Robert Steele, "An overview of research on reverse engineering XML schemas into UML diagrams", Third International Conference on Information Technology and Applications, Vol.2, pp.772-777, 2005.
    Priscilla Walmsley, Definitive XML Schema, Pearson Education, New Jersey, United States, pp.105-106, 2003.
    Routledge, N., Bird, L., "UML and XML Schema", Proceedings of the thirteenth Australian conference on Database technologies, Vol.5, pp.157-166, 2002.
    GB/T 20916-2010: Chinese Office Software File Format Standard UOF Schema, 2010.
  • 加载中

Catalog

    通讯作者: 陈斌, bchen63@163.com
    • 1. 

      沈阳化工大学材料科学与工程学院 沈阳 110142

    1. 本站搜索
    2. 百度学术搜索
    3. 万方数据库搜索
    4. CNKI搜索

    Article Metrics

    Article views (236) PDF downloads(1287) Cited by()
    Proportional views
    Related

    /

    DownLoad:  Full-Size Img  PowerPoint
    Return
    Return