Excel & VBA-based data collection and processing automation tool and use method

An automated tool and data collection technology, applied in special data processing applications, electronic digital data processing, database management systems, etc., can solve the problems of consuming researchers' energy and time, and the lack of unified practical tools for data sets, and reduce experimental work. amount of effect

Active Publication Date: 2019-05-21
NORTHEASTERN UNIV
View PDF10 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In this type of neural network-based defect localization method, there is no unified practical tool for the construction of the data set required for training the defect localization model, and this part of data preparation consumes a lot of energy and time for researchers

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Excel & VBA-based data collection and processing automation tool and use method
  • Excel & VBA-based data collection and processing automation tool and use method
  • Excel & VBA-based data collection and processing automation tool and use method

Examples

Experimental program
Comparison scheme
Effect test

test Embodiment t2

[0062] Step 2.3: Because the number of program code executions is cumulative, if the previously generated t1.gcda file is not cleared when the program is executed again, the code information executed again will be added to the last result. Accurate long-term information during program running has many benefits, but it cannot meet the needs of dynamically collecting code execution information for each test case in this type of experiment. Therefore, before executing the next test case t2, delete t1.gcda under the current path file to ensure that the data of each gcov type file obtained in the experiment is independent of each other;

[0063] Step 2.4: Determine whether all test cases in the set S have been executed, if not, repeat steps 2.1 to 2.3 until all test cases are executed; if yes, end the operation and obtain the original gcov of the code execution information of each test case type file.

[0064] Step 3: If Figure 4 As shown, run the data collection module of the a...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The dynamic software defect positioning technology is always a research hot spot in the field of software testing, and more possibilities are provided for the development of the technology based on the proposal of the neural network defect positioning method. However, the collection and processing of mass data for training the neural network model have no unified process and tool all the time, sothat many work results of the precedent are difficult to reuse or cannot be reused. The invention provides an Excel & VBA-based data collection and processing automation tool and a use method thereof.The Excel & VBA-based data collection and processing automation tool comprises a data collection module, a data sample marking module, a data cleaning module and a data conversion module, code execution information in a large number of gcov files can be automatically collected, an original code execution information data set is generated, and then a standard data set for training of a neural network is generated through automatic cleaning and conversion processes. By using the tool provided by the invention, collection and processing work of mass data in a defect positioning experiment can bereduced, repeated work is avoided, and the overall experiment efficiency is improved.

Description

technical field [0001] The invention belongs to the field of software testing, in particular to an Excel&VBA-based data collection and processing automation tool and a usage method. Background technique [0002] For the solution to the problem of software dynamic defect location, the defect location method based on BP neural network proposed by W.REIC WONG et al. has been continuously improved and developed in recent years because of its higher accuracy than traditional location methods. . In this type of neural network-based defect localization method, there is no unified practical tool for the construction of the data set required to train the defect localization model, and this part of the data preparation consumes a lot of energy and time for researchers. [0003] The original data of this kind of data set comes from the code basic block information (BB) and arc jump count statistics (ARC) generated during the program running. Before executing the GCC tool to compile t...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/22G06F16/215G06F16/25G06F11/36
CPCY02P90/02
Inventor 徐美秋于海朱志良吴迪杨博侯雁博
Owner NORTHEASTERN UNIV
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap