CN109657224B - Automatic spacecraft test report generation method based on data analysis platform - Google Patents
Automatic spacecraft test report generation method based on data analysis platform Download PDFInfo
- Publication number
- CN109657224B CN109657224B CN201910006974.3A CN201910006974A CN109657224B CN 109657224 B CN109657224 B CN 109657224B CN 201910006974 A CN201910006974 A CN 201910006974A CN 109657224 B CN109657224 B CN 109657224B
- Authority
- CN
- China
- Prior art keywords
- test report
- template
- test
- data
- analysis platform
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Debugging And Monitoring (AREA)
Abstract
The invention relates to a spacecraft test report automatic generation method based on a data analysis platform, which comprises the following steps: a. configuring bottom layer information of a data analysis platform and associating related databases; b. constructing a test report section and generating a test report template; c. constructing a data index table according to the test report template to generate a data customizing template; d. starting a data analysis platform, and loading the test report template and the data customization template; e. and outputting and storing a test report. According to the automatic generation method of the spacecraft test report based on the data analysis platform, the working efficiency of testers is greatly improved, and the development work progress of models is effectively promoted.
Description
Technical Field
The invention relates to the technical field of overall electrical performance testing of spacecrafts, in particular to an automatic generation method of a spacecraft test report based on a data analysis platform, belonging to the field of comprehensive testing application of spacecrafts.
Background
The spacecraft electrical performance test, the test post personnel need to write a stage test report, analyze and summarize the contents of the state of the post test equipment, the completion condition of the test project, the parameter coverage inspection, the instruction execution condition, the automatic interpretation condition, the equipment power-on time/action times and the like, and give a test conclusion of the stage.
Besides the test parameter library, the test report is written, and an automatic interpretation conclusion library, an automatic test library and a state management library are also required to be queried, post personnel need to start a plurality of client software to query each type of database, the query result is pasted in the report, and the report is written with various information types, complex data structure and large workload.
In the prior art, spacecraft test reports are written, more operation client software is used, system resources are occupied greatly, the contents of the inquired curves, reports and the like are required to be manually copied and pasted in the reports, and the writing efficiency is low. Therefore, a data analysis platform needs to be developed, various databases are integrated, a data query strategy is optimized, and an automatic generation method of a test report is designed according to the research of the data analysis platform.
Disclosure of Invention
The invention aims to solve the problems and provides the automatic generation method of the spacecraft test report based on the data analysis platform, which is used for intensively inquiring the massive heterogeneous data of the spacecraft through the data analysis platform, loading the test report template to realize that the inquiry result is automatically recorded into each section, reducing the use of client software and improving the writing efficiency of the test report.
In order to achieve the above object, the present invention provides a method for automatically generating a test report of a spacecraft based on a data analysis platform, comprising the steps of:
a. configuring bottom layer information of a data analysis platform and associating related databases;
b. constructing a test report section and generating a test report template;
c. constructing a data index table according to the test report template to generate a data customizing template;
d. starting a data analysis platform, and loading the test report template and the data customization template;
e. and outputting and storing a test report.
According to one aspect of the invention, the test report template is a Word test report template, a Word document control is developed by adopting a net OpenXml technology, and a Word template document is formed by editing the document control;
the data customizing template is an Excel data customizing template, an Excel table corresponding to index information is edited according to the content of each chapter of the Word test report template, and the information index of each database can be established according to the Excel data customizing template;
the data analysis platform loads the Word test report template and the Excel data customization template through bottom layer information configuration, sends index requests to the test parameter library, the automatic interpretation conclusion library, the automatic test library and the state management library according to the Excel data customization template information, acquires feedback information of various libraries, inserts the feedback information into the Word test report template through the data analysis platform, and automatically generates a test report.
According to one aspect of the invention, the test parameter library is used for storing test data and instructions and completing test information storage;
the automatic interpretation conclusion library is used for storing conclusions of subsystem parameters in real time;
the automatic test library is used for storing the executed instruction information and the test item information, recording the automatic test execution process and recording the test item completion condition;
the state management library is used for storing subsystem equipment and software state change record information, and storing ground equipment and ground software state change record information, and is used for controlling the equipment state change process.
According to one aspect of the invention, in the step a, model information, a test parameter library, an automatic interpretation conclusion library, an automatic test library, a state management library IP and port number information are configured, a database index table is constructed, and the correlation of various database information of the spacecraft is completed.
According to one aspect of the invention, in the step b, control indexes are built for query information required to be obtained from various databases, a test report template is built through the Word document control, and the test report template is stored under the data analysis platform folder.
According to one aspect of the invention, in the step c, referring to the chapter content of the Word test report template, editing the Excel data customization templates corresponding to different chapters of the Word test report template by using Excel, acquiring data information in the Word test report template chapter from different database indexes through the Excel data customization templates, and storing the generated Excel data customization templates under the data analysis platform folder.
According to one aspect of the invention, in the step d, the data analysis platform is started, the Word test report template and the Excel data customization template are loaded, test stage information is filled in, a data index request is sent out, database information is searched according to the Excel data customization template, a query result is inserted into the Word test report, and the test report is automatically generated.
According to one aspect of the invention, in the step e, after the test report is automatically generated, the test report is output to a local storage through the data analysis platform, the report content is confirmed, an approval process is executed on the test report, and signing and archiving are completed.
According to the spacecraft test report automatic generation method based on the data analysis platform, the adopted data analysis platform supports the association and integration of a plurality of databases, so that the number of client software is reduced, and a unified platform foundation is provided for data analysis and decision making; the method for automatically generating the test report adopts a machine background to search the database, so that the manual participation in data query work can be reduced, the manpower resources are saved, and the test cost is reduced; the automatic test report generating method automatically inserts the query result into the Word report template, eliminates repeated labor such as manual drawing, copying, pasting and the like, greatly improves the working efficiency of testers, and effectively advances the development work progress of models.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings that are needed in the embodiments will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 schematically illustrates a flow chart of a method for automatically generating a spacecraft test report based on a data analysis platform according to an embodiment of the invention;
FIG. 2 schematically illustrates a Word test report template diagram according to one embodiment of the invention;
FIG. 3 schematically illustrates an Excel data customization template diagram in accordance with one embodiment of the present invention;
FIG. 4 schematically illustrates automatically generating a test report graph according to one embodiment of the invention.
Detailed Description
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings that are required to be used in the embodiments will be briefly described below. It is apparent that the drawings in the following description are only some embodiments of the present invention, and that other drawings may be obtained from these drawings without inventive effort for a person of ordinary skill in the art.
In describing embodiments of the present invention, the terms "longitudinal," "transverse," "upper," "lower," "front," "rear," "left," "right," "vertical," "horizontal," "top," "bottom," "inner," "outer," and the like are used in terms of orientation or positional relationship shown in the drawings for convenience of description and simplicity of description only, and do not denote or imply that the devices or elements in question must have a particular orientation, be constructed and operated in a particular orientation, so that the above terms are not to be construed as limiting the invention.
The present invention will be described in detail below with reference to the drawings and the specific embodiments, which are not described in detail herein, but the embodiments of the present invention are not limited to the following embodiments.
FIG. 1 schematically illustrates a flow chart of a method for automatically generating a spacecraft test report based on a data analysis platform according to an embodiment of the invention. As shown in fig. 1, the automatic spacecraft test report generation method based on the data analysis platform according to the invention comprises the following steps:
a. configuring bottom layer information of a data analysis platform and associating related databases;
b. constructing a test report section and generating a test report template;
c. constructing a data index table according to the test report template to generate a data customizing template;
d. starting a data analysis platform, and loading the test report template and the data customization template;
e. and outputting and storing a test report.
According to one embodiment of the invention, the test report template is a Word test report template, a Word document control is developed by adopting a net OpenXml technology, and a Word template document is formed by editing the document control;
the data customizing template is an Excel data customizing template, an Excel table corresponding to index information is edited according to the content of each chapter of the Word test report template, and the information index of each database can be established according to the Excel data customizing template;
the data analysis platform loads a Word test report template and an Excel data customization template through bottom layer information configuration, sends index requests to the test parameter library, the automatic interpretation conclusion library, the automatic test library and the state management library according to Excel data customization template information, acquires feedback information of the various libraries, and inserts the feedback information into the Word test report template through the data analysis platform to automatically generate a test report.
In this embodiment, the test parameter library is used for storing test data and instructions, and completing test information storage;
the automatic interpretation conclusion library is used for storing conclusions of subsystem parameters for real-time interpretation;
the automatic test library is used for storing the executed instruction information and the test item information, recording the automatic test execution process and recording the test item completion condition;
the state management library is used for storing subsystem equipment and software state change record information, and storing ground equipment and ground software state change record information, and is used for controlling the equipment state change process.
According to one embodiment of the present invention, in the step a, model information, a test parameter library, an automatic interpretation conclusion library, an automatic test library, a state management library IP and port number information are configured, a database index table is constructed, and the correlation of various database information of the spacecraft is completed.
In this embodiment, the model in the configuration model information is the spacecraft number, for example, the Shenzhou ten manned spacecraft, tianzhou one freight spacecraft, and is embodied as a group of letter+number numbers in the software configuration; the configuration model information refers to that the data analysis platform is applied to a spacecraft test system, and the number information (such as XXX-10) of the corresponding spacecraft (namely model) needs to be configured so as to distinguish the application under different spacecraft.
In the step b, the requirements of the test report are generally written according to the model number (namely according to spacecraft numbers such as Shenzhou ten and Tianzhou one, and a group of letter and number numbers are embodied in software configuration), a Word document control is developed by adopting a net OpenXml technology, a Word template document is generated by editing the document control, a control index is built according to query information required to be obtained from various databases as shown in fig. 2, a test report template is built through the Word document control, and the test report template is stored under the folder of the data analysis platform.
In the step c, referring to the chapter content of the Word test report template, editing Excel data customizing templates corresponding to different chapters of the Word test report template by using Excel, wherein the Excel data customizing templates are shown in fig. 3, data information in the chapter of the Word test report template is obtained from different database indexes through the Excel data customizing templates, and the generated Excel data customizing templates are stored under a folder of a data analysis platform.
In the step d, the data analysis platform is started, the Word test report template and the Excel data customization template are loaded, test stage information is filled in, a data index request is sent out, database information is searched according to the Excel data customization template, and query results (such as curves, reports, statistical results and the like) are inserted into the Word test report to automatically generate the test report.
In the step e, as shown in fig. 4, after the test report is automatically generated, the test report is output to a local storage through the data analysis platform, the report content is confirmed, and an approval process is executed on the test report to complete signing and archiving.
According to one embodiment of the invention, for a comprehensive analysis system of mass heterogeneous data of a plurality of spacecraft, a data warehouse is deployed in a spacecraft service area; comprehensively analyzing the application area of the client end in the spacecraft electrical performance test system, and establishing a communication interface with a data warehouse; the service area is responsible for data processing, distribution and storage, and the application area is responsible for data interpretation and query analysis.
For the data analysis platform, the communication interface is established by adopting a C/S architecture and a test parameter library, an automatic interpretation conclusion library, an automatic test library and a state management library, and the database adopts an Oracle database.
According to the spacecraft test report automatic generation method based on the data analysis platform, an Excel data customization template is loaded by the data analysis platform according to the content of a test report section to carry out integrated query on a test parameter library, an automatic interpretation conclusion library, an automatic test library and a state management library, and a query result is associated with the test report to complete automatic generation of the test report.
According to the spacecraft test report automatic generation method based on the data analysis platform, the adopted data analysis platform supports the association and integration of a plurality of databases, so that the number of client software is reduced, and a unified platform foundation is provided for data analysis and decision making; the method for automatically generating the test report adopts a machine background to search the database, so that the manual participation in data query work can be reduced, the manpower resources are saved, and the test cost is reduced; the automatic test report generating method automatically inserts the query result into the Word report template, eliminates repeated labor such as manual drawing, copying, pasting and the like, greatly improves the working efficiency of testers, and effectively advances the development work progress of models.
The above description is only one embodiment of the present invention and is not intended to limit the present invention, and various modifications and variations of the present invention will be apparent to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (7)
1. A spacecraft test report automatic generation method based on a data analysis platform comprises the following steps:
a. configuring bottom layer information of a data analysis platform and associating related databases;
b. constructing a test report section and generating a test report template;
c. constructing a data index table according to the test report template to generate a data customizing template;
d. starting a data analysis platform, and loading the test report template and the data customization template;
e. outputting and storing a test report;
the test report template is a Word test report template, a Word document control is developed by adopting a net OpenXml technology, and a Word template document is formed by editing the document control;
the data customizing template is an Excel data customizing template, an Excel table corresponding to index information is edited according to the content of each chapter of the Word test report template, and the information index of each database can be established according to the Excel data customizing template;
the data analysis platform loads the Word test report template and the Excel data customization template through bottom information configuration, sends index requests to a test parameter library, an automatic interpretation conclusion library, an automatic test library and a state management library according to the information of the Excel data customization template, acquires feedback information, and inserts the feedback information into the Word test report template through the data analysis platform to automatically generate a test report.
2. The automatic generation method of spacecraft test report based on the data analysis platform according to claim 1, wherein the test parameter library is used for storing test data and instructions and completing test information storage;
the automatic interpretation conclusion library is used for storing conclusions of subsystem parameters in real time;
the automatic test library is used for storing the executed instruction information and the test item information, recording the automatic test execution process and recording the test item completion condition;
the state management library is used for storing subsystem equipment and software state change record information, and storing ground equipment and ground software state change record information, and is used for controlling the equipment state change process.
3. The automatic generation method of spacecraft test report based on data analysis platform according to claim 2, wherein in the step a, model information, a test parameter library, an automatic interpretation conclusion library, an automatic test library, a state management library IP and port number information are configured, a database index table is built, and the association of various pieces of spacecraft database information is completed.
4. The automatic generation method of spacecraft test report based on data analysis platform according to claim 2, wherein in the step b, control indexes are built for query information required to be obtained from various databases, test report templates are built through the Word document controls, and the test report templates are stored under a folder of the data analysis platform.
5. The automatic generation method of a spacecraft test report based on a data analysis platform according to claim 2, wherein in the step c, referring to the chapter content of the Word test report template, editing the Excel data customization templates corresponding to different chapters of the Word test report template by using Excel, acquiring data information in the Word test report template chapter from different database indexes through the Excel data customization templates, and storing the generated Excel data customization templates under a folder of the data analysis platform.
6. The automatic generation method of spacecraft test report based on data analysis platform according to claim 2, wherein in the step d, the data analysis platform is started, the Word test report template and the Excel data customization template are loaded, test stage information is filled in, a data index request is sent out, database information is searched according to the Excel data customization template, a query result is inserted into the Word test report template, and a test report is automatically generated.
7. The automatic generation method of spacecraft test report based on data analysis platform according to one of claims 2 to 6, wherein in the step e, after the test report is automatically generated, the test report is output to a local storage through the data analysis platform, the report content is confirmed, an approval process is performed on the test report, and signing and archiving are completed.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910006974.3A CN109657224B (en) | 2019-01-04 | 2019-01-04 | Automatic spacecraft test report generation method based on data analysis platform |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910006974.3A CN109657224B (en) | 2019-01-04 | 2019-01-04 | Automatic spacecraft test report generation method based on data analysis platform |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109657224A CN109657224A (en) | 2019-04-19 |
| CN109657224B true CN109657224B (en) | 2023-05-26 |
Family
ID=66118508
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910006974.3A Active CN109657224B (en) | 2019-01-04 | 2019-01-04 | Automatic spacecraft test report generation method based on data analysis platform |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109657224B (en) |
Families Citing this family (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110908356A (en) * | 2019-10-11 | 2020-03-24 | 成都飞机工业（集团）有限责任公司 | Flight control test data rapid fault positioning method |
| CN111178026A (en) * | 2019-12-05 | 2020-05-19 | 北京直真科技股份有限公司 | Method for realizing operation analysis report of special line for collecting passenger |
| CN111190819B (en) * | 2019-12-25 | 2023-05-23 | 中国航空工业集团公司西安飞机设计研究所 | State control method for airborne software test project |
| CN111313958A (en) * | 2020-02-12 | 2020-06-19 | 深圳航天宏图信息技术有限公司 | Satellite data quality inspection report generation system |
| CN112052658A (en) * | 2020-09-04 | 2020-12-08 | 深圳市长隆科技有限公司 | Method, system and equipment for automatically generating detection report of water quality detector |
| CN112800009A (en) * | 2021-01-28 | 2021-05-14 | 重庆富民银行股份有限公司 | Centralized management system for automated test data based on compatible configuration |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6442714B1 (en) * | 1999-03-17 | 2002-08-27 | Cisco Technology | Web-based integrated testing and reporting system |
| CN101630283A (en) * | 2008-07-16 | 2010-01-20 | 鸿富锦精密工业（深圳）有限公司 | System and method for automatically generating report |
| CN108345538A (en) * | 2018-01-30 | 2018-07-31 | 北京智行鸿远汽车有限公司 | Test report automatic creation system based on LabVIEW and method |
| CN109086985A (en) * | 2018-07-20 | 2018-12-25 | 北京卫星环境工程研究所 | Professional test information management system towards spacecraft |
-
2019
- 2019-01-04 CN CN201910006974.3A patent/CN109657224B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6442714B1 (en) * | 1999-03-17 | 2002-08-27 | Cisco Technology | Web-based integrated testing and reporting system |
| CN101630283A (en) * | 2008-07-16 | 2010-01-20 | 鸿富锦精密工业（深圳）有限公司 | System and method for automatically generating report |
| CN108345538A (en) * | 2018-01-30 | 2018-07-31 | 北京智行鸿远汽车有限公司 | Test report automatic creation system based on LabVIEW and method |
| CN109086985A (en) * | 2018-07-20 | 2018-12-25 | 北京卫星环境工程研究所 | Professional test information management system towards spacecraft |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109657224A (en) | 2019-04-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109657224B (en) | Automatic spacecraft test report generation method based on data analysis platform | |
| CN103294475B (en) | The business automatic creation system of graphic based business scenario and domain template and method | |
| Babar et al. | A tool for managing software architecture knowledge | |
| CN101383871B (en) | Network element configuration implementing method and apparatus | |
| CN112417578A (en) | Method and system for modeling precast pile based on Dynamo and Excel | |
| CN105786506A (en) | User interface automatic-generation system and method | |
| CN109977162A (en) | A kind of urban and rural planning data transfer device, system and computer readable storage medium | |
| CN111190814B (en) | Method and device for generating software test case, storage medium and terminal | |
| CN108647147A (en) | It is a kind of to execute automatic test machine people and its application method using atlas analysis | |
| CN115169810A (en) | Artificial intelligence system construction method and device for power grid regulation | |
| CN105279138B (en) | A kind of information research report automatic creation system | |
| CN106802928A (en) | Power network historical data management method and its system | |
| CN114661715A (en) | Database data processing method and device, storage medium and electronic equipment | |
| CN116737113B (en) | Metadata catalog management system and method for mass scientific data | |
| CN114997154B (en) | Automatic dialogue robot corpus construction method and system | |
| CN109545285A (en) | A kind of knowledge application method of nuclear reactor digital experiment platform | |
| CN112989478B (en) | Revit-based silo structure steel bar modeling and drawing method and system | |
| CN113505184B (en) | Method for automatically generating information relation graph between systems and storage medium | |
| CN108830541A (en) | Issue management method and management system on a kind of line | |
| CN103164526A (en) | Generation method and generation device of test report | |
| CN109522356B (en) | Nuclear reactor digital experiment system | |
| Iriondo et al. | Simulation data management in a product lifecycle management context | |
| CN104731697A (en) | Running control method, control system and sound monitor of test case | |
| CN118503270B (en) | NL2SQL data set construction method, device, equipment and medium | |
| CN118535887B (en) | Efficient fine tuning evaluation method and system for large language model |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |