Data acquisition method and system based on structured table flexible design

Abstract

The application provides a data acquisition method and system based on flexible design of structured table, comprising: obtaining table data; establishing a structured table feature model according to the table data; constructing a table knowledge database, and calling table related attributes from the table knowledge database to perform corresponding table flexible design and obtain a corresponding feature matrix; aggregating the corresponding feature matrix according to the structured table feature model to generate a multifunctional structured table; and establishing an associated mapping relationship between a production process and the structured table, integrating the multifunctional structured table with a data terminal for application, and realizing acquisition of structured table data. The application establishes a multifunctional structured table model and performs flexible design, realizes software and hardware integrated application with a diversified data acquisition terminal, and effectively improves data structured, integrated acquisition and management capability in a satellite development process.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of data collection, in particular to a data collection method and system based on flexible design of structured table. BACKGROUND

[0002] Satellites are mostly developed in single-piece production mode, and the product quality and reliability are strictly required, especially the effectiveness of process records, the integrity of data packets and the traceability of quality. There are a large number of data recording requirements in the satellite development process, involving a large amount of table design and data recording work; the data collection requirements are complex and diverse among different types, involving a large number of inspection tables with different styles and poor universality.

[0003] At present, in the satellite development process, non-structured Word documents are still mostly used as carriers for repetitive inspection table design, and a large amount of paper records are still stored on site, which results in large table design workload and low data collection efficiency. In terms of design and application of structured tables, various customized and developed fixed tables are mostly used, which results in large software development workload and poor table flexibility, and it is difficult to meet the diversified data collection content and functional requirements of different types. For the satellite development process, the existing inspection table design and application technical means have the following two shortcomings:

[0004] (1) The existing inspection table design and application method is difficult to meet the requirements of flexible design of a large number of complex and diverse inspection record table styles and functions, structured definition of tables, and structured storage of data in different types.

[0005] (2) The existing inspection table design and application method is difficult to realize integration and application with diversified data terminals such as signature confirmation and image collection, and the data collection means is single and has low integration; at the same time, it is difficult to realize structured storage of a large amount of heterogeneous data such as structured records, image records and attachments at a cell level. SUMMARY

[0006] In view of the defects in the prior art, the purpose of the present application is to provide a data collection method and system based on flexible design of structured table.

[0007] According to the data collection method and system based on flexible design of structured table provided by the present application, the method comprises the following steps:

[0008] Step S1: acquiring table data;

[0009] Step S2: establishing a structured table feature model according to the table data;

[0010] Step S3: constructing a table knowledge database, and calling table related attributes from the table knowledge database to perform corresponding table flexible design to obtain a corresponding feature matrix;

[0011] Step S4: aggregating the corresponding feature matrix according to the structured table feature model to generate a multifunctional structured table;

[0012] Step S5: establishing an association mapping relationship between a production process and a structured table, integrating and applying the multifunctional structured table with a data terminal to realize structured table data collection.

[0013] Preferably, the establishment of the structured table feature model comprises the following sub-steps:

[0014] Step S2.1: setting a table feature matrix A according to table data, as follows:

[0015]

[0016] wherein a nm represents each cell element in the matrix, subscript n represents the nth column in the table data, and subscript m represents the mth row in the table data;

[0017] Step S2.2: setting each cell element a nm in the matrix respectively, nm a cell content feature af nm , and a cell function feature ac nm , wherein a nm = as nm + af nm + ac nm ;

[0018] The cell style feature includes a different style attribute set of the cell, the cell content feature includes stored content in the cell, and the cell function feature includes a corresponding function type of the cell;

[0019] Step S2.3: aggregating the cell style feature as nm , the cell content feature af nm , and the cell function feature ac nm respectively to obtain a corresponding style feature matrix AS, a function feature matrix AF, and a content feature matrix AC, and further obtaining a structured table feature model by verifying structured expressions of table style features, function features, and content features, and the formula is as follows:

[0020] A = AS + AF + AC

[0021]

[0022] Preferably, the table knowledge database comprises a table record element knowledge base, a product PBOM database, and a table style template library.

[0023] The table record element knowledge base stores data record element knowledge entries associated with each type of table in a structured manner, and the content of the data record element knowledge entries includes product object types, implementation processes, record elements, record methods, and required values.

[0024] The product PBOM database stores product basic information and process requirement information according to product assembly hierarchy relationships.

[0025] The table style template library stores various table style templates according to different dimensions and performs version updates.

[0026] Preferably, the corresponding table flexibility design includes table style flexibility design, table content flexibility design, and table function flexibility design.

[0027] Table style flexibility design: by importing Excel style templates or inheriting the style attributes of each cell and customizing adjustments, batch flexibility sets the style attributes of cells, generates cell style features, and aggregates to generate a table style feature matrix.

[0028] Table content flexibility design: according to the table type, automatically extract structured data record elements from the table record element knowledge base of the table knowledge database to generate column attributes of the table; according to the product type applicable to the table, automatically extract product basic information and process requirement information from the product PBOM database of the table knowledge database to generate row attributes of the table; obtain a table content feature matrix

[0029] Table function flexibility design: batch flexibility sets the function types of each cell, structuredly stores the function features of the cells, and aggregates to generate a table function feature matrix.

[0030] Preferably, step S4 further comprises the following sub-steps:

[0031] Multifunctional structured table association storage step: store table style features and table function features in a json format intermediate data file, store table content features in a relational database table, and associate and map the json format intermediate data file and the relational database table through cell position coordinates;

[0032] Multifunctional structured table lightweight rendering step: load the json intermediate data file in B / S web page, render the table style and the table function, extract structured data or image attachments through cell coordinate association, and present the multifunctional structured table in a lightweight manner.

[0033] According to the application, a data acquisition system based on flexible design of structured table is provided, comprising:

[0034] Module M1: obtaining table data;

[0035] Module M2: establishing a structured table feature model according to the table data;

[0036] Module M3: constructing a table knowledge database, calling table related attributes from the table knowledge database, and performing corresponding table flexible design to obtain a corresponding feature matrix;

[0037] Module M4: aggregating the corresponding feature matrix according to the structured table feature model to generate a multifunctional structured table;

[0038] Module M5: establishing an associated mapping relationship between a production process and the structured table, integrating and applying the multifunctional structured table with a data terminal, and realizing acquisition of structured table data.

[0039] Preferably, the establishment of the structured table feature model comprises the following sub-modules:

[0040] Module M2.1: setting a table feature matrix A according to table data, as shown below:

[0041]

[0042] wherein a nm represents each cell element in the matrix, subscript n represents the nth column in the table data, and subscript m represents the mth row in the table data;

[0043] Module M2.2: setting each cell element a nm in the matrix respectively; nm corresponding cell style feature as nm , cell content feature af nm , and cell function feature ac nm , wherein a nm = as nm + af nm + ac

[0044] The cell style feature comprises a set of different style attributes of the cell, the cell content feature comprises storage content in the cell, and the cell function feature comprises a corresponding function type of the cell;

[0045] Module M2.3: aggregating the cell style feature as nm , the cell content feature af nm , and the cell function feature ac nm, to obtain the corresponding style feature matrix AS, function feature matrix AF, and content feature matrix AC, and through inspection of the structured expression of the table style feature, function feature, and content feature, a structured table feature model is obtained, and the formula is as follows:

[0046] A = AS + AF + AC

[0047]

[0048] Preferably, the table knowledge database comprises a table record element knowledge base, a product PBOM database, and a table style template library.

[0049] The table record element knowledge base stores data record element knowledge items associated with each type of table in a structured manner, and the content of the data record element knowledge items comprises product object type, implementation process, record element, record system, and required value.

[0050] The product PBOM database stores product basic information and process requirement information according to product assembly hierarchy relationship.

[0051] The table style template library stores various table style templates according to different dimensions and performs version update.

[0052] Preferably, the corresponding table flexible design comprises table style flexible design, table content flexible design, and table function flexible design.

[0053] Table style flexible design: by importing an Excel style template or inheriting the style attributes of each cell and customizing adjustment, the style attributes of cells at the cell level are flexibly set in batches, cell style features are generated, and table style feature matrix is aggregated and generated.

[0054] Table content flexible design: structured data record elements are automatically extracted from the table record element knowledge base of the table knowledge database according to the table type, to generate column attributes of the table; product basic information and process requirement information are automatically extracted from the product PBOM database of the table knowledge database according to the product type applicable to the table, to generate row attributes of the table; and table content feature matrix is obtained.

[0055] Table function flexible design: the function types of each cell are flexibly set in batches, the function features of the cells are stored in a structured manner, and table function feature matrix is aggregated and generated.

[0056] Preferably, the module M4 further comprises the following sub-modules:

[0057] The multifunctional structured table association storage module: the table style features and table function features are stored in the json format intermediate data file, the table content features are stored in the relational database table, and the json format intermediate data file and the relational database table are associated and mapped through the cell position coordinates;

[0058] The multifunctional structured table lightweight rendering module: the json intermediate data file is loaded in B / S webpage, the table style and the table function are rendered, the structured data or the image attachment is extracted through the cell coordinate association, and the multifunctional structured table is lightweight presented.

[0059] Compared with the prior art, the present application has the following beneficial effects:

[0060] 1. The present application takes the structured table as a carrier, realizes the software and hardware integrated application of diversified data collection terminals such as electronic signature and image collection, realizes the online integrated collection and structured association storage of multi-source heterogeneous manufacturing process data, improves the satellite development process data integrated collection efficiency, and reduces the workload of related technical personnel.

[0061] 2. The present application can realize the efficient and flexible design of the multifunctional structured record table integrating online data recording, electronic signature confirmation, multimedia online collection, structured association storage and the like, and solves the problem of rapid analysis of a large number of complex and diverse test tables with poor universality under the satellite single-piece development mode. BRIEF DESCRIPTION OF DRAWINGS

[0062] Other features, objects and advantages of the present application will become more apparent through reading the following detailed description of the non-limiting embodiments with reference to the accompanying drawings:

[0063] Figure 1 It is a flowchart of the working method of the present application.

[0064] Figure 2 It is an effect schematic diagram of the structured data record element library in the present application.

[0065] Figure 3 It is an effect schematic diagram of the multifunctional structured record table aggregation generation in the present application.

[0066] Figure 4 It is a multifunctional structured record table and data terminal integrated application scene schematic diagram in the present application. DETAILED DESCRIPTION

[0067] The application will be described in detail below with specific examples. The following examples will help those skilled in the art to further understand the application, but do not limit the application in any form. It should be noted that those skilled in the art can make several changes and improvements without departing from the concept of the application. These are within the scope of the application.

[0068] The application generates a multifunctional structured form integrating online data recording, electronic signature confirmation, multimedia online collection, and structured association storage by structuring form feature modeling and corresponding flexible design, and integrates software and hardware of diversified data collection terminals to solve the problems of rapid design and integrated application of a large number of complex and diversified test forms with poor versatility, structured data collection and management under the satellite single-piece development mode, and effectively improves the data structured, integrated collection and management capability in the satellite development process.

[0069] According to the data collection method based on the flexible design of the structured form provided by the application, as shown in Figure 1 , the method comprises the following steps.

[0070] Step S1: Obtain form data.

[0071] Step S2: Establish a structured form feature model according to the form data. Establish a form feature matrix A, which is further decomposed into a style feature matrix AS, a content feature matrix AC, and a function feature matrix AF to realize the structured expression and modeling of the form. Specifically, the establishment of the structured form feature model comprises the following sub-steps.

[0072] Step S2.1: Set the form feature matrix A according to the form data as follows:

[0073]

[0074] Wherein, a nm represents each cell element in the matrix, subscript n represents the nth column in the form data, and subscript m represents the mth row in the form data.

[0075] Step S2.2: Set each cell element a nm in the matrix respectively as follows: nm corresponding cell style feature as nm , cell content feature af nm , and cell function feature ac nm , wherein a nm = as nm + af nmThe cell style feature includes different style attribute sets of the cell, the cell content feature includes the stored content in the cell, and the cell function feature includes the corresponding function type of the cell. Specifically, the different style attribute sets include the horizontal and vertical coordinates, the width and height size, the border attribute, the font size, the association and combination of the cell. The stored content in the cell includes product attributes, process requirements, measured records and the like. The function type includes text entry, static text, drop-down selection, electronic signature, image collection, attachment upload and the like.

[0076] Step S2.3: aggregating the cell style feature as nm , the cell content feature af nm , and the cell function feature ac nm respectively to obtain the corresponding style feature matrix AS, function feature matrix AF and content feature matrix AC. Through the inspection of the structured expression of the table style feature, function feature and content feature, a structured table feature model is further obtained, and the formula is as follows:

[0077] A = AS + AF + AC

[0078]

[0079] Thus, we obtain:

[0080]

[0081] Step S3: constructing a table knowledge database and calling table related attributes from the table knowledge database to perform corresponding table flexible design to obtain the corresponding feature matrix. Specifically, the table knowledge database includes a table record element knowledge base, a product PBOM database and a table style template library. As shown in Figure 2 , the table record element knowledge base stores each type of table associated data record element knowledge item in a structured manner. The content of the data record element knowledge item includes product object type, implementation process, record element, record method and requirement value, wherein the product object type includes single machine product, structure product, cable product, thermal control product and the like. The product PBOM database stores product basic information and process requirement information according to the product assembly level relationship. The table style template library stores various table style templates according to different dimensions and performs version update, wherein the different dimensions include professional, process, department and the like. Through the construction of the table knowledge database, version management and change management of data, knowledge and templates can be realized. The corresponding table flexible design includes table style flexible design, table content flexible design and table function flexible design. Specifically, each flexible design is described as follows:

[0082] Table style flexible design: by importing Excel style template or inheriting the style properties of each cell and customizing adjustment, batch flexible setting of cell level style properties, generating cell style characteristics, and aggregating to generate table style feature matrix.

[0083] Table content flexible design: according to the table type, the structured data record elements are automatically extracted from the table record element knowledge base of the table knowledge database to generate the column attributes of the table; according to the product type applicable to the table, the product basic information and process requirement information are automatically extracted from the product PBOM database of the table knowledge database to generate the row attributes of the table; the table content feature matrix is obtained, wherein the product basic information includes product name, code, batch number and other key basic information. The table type, such as equipment assembly and disassembly table required in satellite development process, product inspection and confirmation table, process inspection and confirmation table, etc.

[0084] Table function flexible design: batch flexible setting of function type of each cell, structured storage of cell function characteristics, and aggregation to generate table function feature matrix.

[0085] Step S4: according to the structured table feature model, the corresponding feature matrix is aggregated to generate a multifunctional structured table. The multifunctional structured table can realize online data recording, electronic signature confirmation and online image recording. Step S4 further includes the following sub-steps:

[0086] Multifunctional structured table association storage step: the table style characteristics and table function characteristics are stored in the json format intermediate data file, the table content characteristics are stored in the relational database table, and the json format intermediate data file and the relational database table are associated and mapped through the cell position coordinates.

[0087] Multifunctional structured table lightweight rendering step: loading the json intermediate data file in B / S web page, rendering the table style and table function, and extracting structured data or image attachments through cell coordinate association, so as to present the multifunctional structured table in a lightweight manner, as shown in Figure 3

[0088] Step S5: establishing the association mapping relationship between production process and structured table, integrating the multifunctional structured table with data terminal, and realizing the collection of structured table data. That is, the association relationship between the structured table and each process in the process procedure is established, and the multifunctional structured table is distributed to the production site with the process procedure; a plurality of data collection terminals are integrated to realize the collection of structured table data. Specifically, as shown in Figure 4 ​As shown, according to the model development process, an online fast flexible structured table is created, a mapping relationship between the production process and the structured table is established, and the mapping relationship is sent to the operation site with the process plan. Then, the multifunctional structured table is presented in a lightweight and visual manner through B / S web pages, and data terminals such as electronic signature, image acquisition, and barcode scanning are called according to different cell function types to realize electronic signature confirmation and online image data acquisition. This step mainly establishes a mapping relationship between each process in the production process and the inspection record table required by the process, so that in the production process, when a process is executed, the related structured table is automatically called for online data record confirmation by the operator / inspector.

[0089] The application also provides a data acquisition system based on flexible design of structured tables, and those skilled in the art can realize the data acquisition system based on flexible design of structured tables by performing the step flow of the data acquisition method based on flexible design of structured tables, that is, the data acquisition method based on flexible design of structured tables can be understood as a preferred embodiment of the data acquisition system based on flexible design of structured tables.

[0090] According to the application, a data acquisition system based on flexible design of structured tables is provided, which comprises:

[0091] Module M1: acquire table data.

[0092] Module M2: establish a structured table feature model according to the table data. The establishment of the structured table feature model comprises the following sub-modules:

[0093] Module M2.1: set a table feature matrix A according to the table data, as shown below:

[0094]

[0095] wherein a nm represents each cell element in the matrix, subscript n represents the nth column in the table data, and subscript m represents the mth row in the table data.

[0096] Module M2.2: set each cell element a nm in the matrix respectively. nm , a cell content feature af nm , and a cell function feature ac nm , wherein a nm = as nm + af nm + ac nm . The cell style feature comprises a set of different style attributes of the cell, the cell content feature comprises the storage content in the cell, and the cell function feature comprises the corresponding function type of the cell.

[0097] Module M2.3: aggregating cell style feature as nm , cell content feature af nm , cell function feature ac nm , to obtain the corresponding style feature matrix AS, function feature matrix AF, and content feature matrix AC. By checking the structured expression of table style features, function features, and content features, a structured table feature model is obtained, and the formula is as follows:

[0098] A = AS + AF + AC

[0099]

[0100] Module M3: constructing a table knowledge database and calling table-related attributes from the table knowledge database to perform corresponding table flexible design to obtain the corresponding feature matrix. The table knowledge database includes a table record element knowledge base, a product PBOM database, and a table style template library. The table record element knowledge base stores the data record element knowledge items associated with each type of table in a structured manner. The content of the data record element knowledge items includes product object type, implementation process, record element, record system, and required value. The product PBOM database stores product basic information and process requirement information according to the product assembly hierarchy relationship. The table style template library stores various table style templates according to different dimensions and performs version updates.

[0101] Corresponding table flexible design includes table style flexible design, table content flexible design, and table function flexible design. Table style flexible design: by importing Excel style templates or inheriting the style attributes of each cell and customizing adjustments, batch flexible setting of cell-level style attributes is performed to generate cell style features and aggregate table style feature matrix. Table content flexible design: structured data record elements are automatically extracted from the table record element knowledge base of the table knowledge database according to the table type to generate column attributes of the table; product basic information and process requirement information are automatically extracted from the product PBOM database of the table knowledge database according to the product type applicable to the table to generate row attributes of the table; and table content feature matrix is obtained. Table function flexible design: batch flexible setting of the function type of each cell is performed, and the function features of the cells are stored in a structured manner to aggregate the table function feature matrix.

[0102] Module M4: according to the structured table feature model, the corresponding feature matrix is aggregated, and a multifunctional structured table is generated. Module M4 further includes the following sub-modules: a multifunctional structured table associated storage module: the table style features and table function features are stored in the json format intermediate data file, the table content features are stored in the relational database table, and the json format intermediate data file and the relational database table are associated and mapped through the cell position coordinates. A multifunctional structured table lightweight rendering module: the json intermediate data file is loaded in the B / S web page, the table style and the table function are rendered, the structured data or image attachments are associated and extracted through the cell coordinates, and the multifunctional structured table is lightweight presented.

[0103] Module M5: an associated mapping relationship between the production process and the structured table is established, the multifunctional structured table is integrated and applied with the data terminal, and the structured table data acquisition is realized.

[0104] Those skilled in the art know that, in addition to implementing the system, device and each module thereof provided by the present application in the form of pure computer readable program code, the same program can be realized in the form of logic gates, switches, application specific integrated circuits, programmable logic controllers and embedded microcontrollers by logically programming the method steps. Therefore, the system, device and each module thereof provided by the present application can be considered as a hardware component, and the modules included therein for realizing various programs can also be considered as structures within the hardware component; the modules for realizing various functions can also be considered as both software programs for realizing methods and structures within the hardware component.

[0105] The specific embodiments of the present application are described above. It needs to be understood that the present application is not limited to the above specific embodiments, and those skilled in the art can make various changes or modifications within the scope of the claims, which does not affect the essential content of the present application. In the case of no conflict, the embodiments of the present application and the features in the embodiments can be combined with each other at will.

Claims

1. A data acquisition method based on structured table flexible design, characterized in that, Comprise: Step S1: obtaining table data; Step S2: establishing a structured table feature model according to the table data; Step S3: constructing a table knowledge database, and calling table related attributes from the table knowledge database to perform corresponding table flexible design, and obtaining a corresponding feature matrix; Step S4: aggregating the corresponding feature matrix according to the structured table feature model to generate a multifunctional structured table; Step S5: establishing an associated mapping relationship between a production process and a structured table, integrating and applying the multifunctional structured table with a data terminal, and realizing collection of structured table data; The establishment of the structured table feature model comprises the following sub-steps: Step S2.1: Setting up the table feature matrix from table data As follows: wherein, represents each cell element in the matrix, subscript n represents the nth column in the table data, and subscript m represents the mth row in the table data; Step S2.2: Set each cell element in the matrix respectively Corresponding cell style features , Cell content features , Cell function features Wherein, ; The cell style feature comprises a set of different style attributes of the cell, the cell content feature comprises the storage content in the cell, and the cell function feature comprises a corresponding function type of the cell; Step S2.3: aggregating the cell style features respectively , cell content features , cell function features , to obtain the corresponding style feature matrix , function feature matrix , content feature matrix , by checking the structured expression of table style features, function features, content features, and further obtaining the structured table feature model, the formula is as follows: ， ， 。 2. The flexible design based on structured table data collection method according to claim 1, characterized in that, The table knowledge database comprises a table record element knowledge base, a product PBOM database, and a table style template library; The table record element knowledge base stores data record element knowledge items associated with each type of table in a structured manner, and the content of the data record element knowledge items comprises product object types, implementation processes, record elements, record methods, and required values; The product PBOM database stores product basic information and process requirement information according to product assembly hierarchy relationships; The table style template library stores various table style templates according to different dimensions and performs version updates.

3. The flexible design based on structured table data collection method of claim 1, wherein, The corresponding table flexible design comprises table style flexible design, table content flexible design, and table function flexible design; Table style flexible design: by importing an Excel style template or inheriting style attributes of each cell and customizing adjustment, batch flexible setting of style attributes at the cell level is performed to generate a cell style feature, and a table style feature matrix is aggregated and generated; Table content flexible design: structured data record elements are automatically extracted from the table record element knowledge base of the table knowledge database according to table types to generate column attributes of the table; product basic information and process requirement information are automatically extracted from the product PBOM database of the table knowledge database according to product types applicable to the table to generate row attributes of the table; A table content feature matrix is obtained; Table function flexible design: function types of each cell are batch flexibly set, and function features of the cells are stored in a structured manner to aggregate and generate a table function feature matrix.

4. The flexible design based on structured table data collection method of claim 1, wherein, Step S4 further comprises the following sub-steps: Multifunctional structured table associated storage step: storing table style features and table function features in a json format intermediate data file, storing table content features in a relational database table, and associating and mapping the json format intermediate data file and the relational database table through cell position coordinates; Multifunctional structured table lightweight rendering step: loading a json intermediate data file through B / S web pages to render table style and table function, and extracting structured data or image attachments through cell coordinate association to present the multifunctional structured table in a lightweight manner.

5. A flexible design based data acquisition system based on structured table, characterized in that, Comprise: Module M1: obtaining table data; Module M2: establishing a structured table feature model according to the table data; Module M3: constructing a table knowledge database, and calling table related attributes from the table knowledge database to perform corresponding table flexible design, and obtaining a corresponding feature matrix; Module M4: aggregating the corresponding feature matrix according to the structured table feature model to generate a multifunctional structured table; Module M5: establishing an associated mapping relationship between a production process and a structured table, integrating and applying the multifunctional structured table with a data terminal, and realizing collection of structured table data; The establishment of the structured table feature model includes the following sub-modules: Module M2.1 : Setting a table feature matrix from table data As follows: wherein, represents each cell element in the matrix, subscript n represents the nth column in the table data, and subscript m represents the mth row in the table data; Module M2.2: Setting each cell element in the matrix respectively Corresponding cell style features Cell content features Cell function features wherein ; The cell style feature includes a set of different style attributes of the cell, the cell content feature includes the storage content in the cell, and the cell function feature includes the corresponding function type of the cell; Module M2.3: aggregating the cell style features respectively , cell content features , cell function features , to obtain the corresponding style feature matrix , function feature matrix , content feature matrix , by checking the structured expression of table style features, function features, content features, and further obtaining the structured table feature model, the formula is as follows: ， ， 。 6. The flexible design based on structured table data acquisition system of claim 5, wherein, The table knowledge database includes a table record element knowledge base, a product PBOM database, and a table style template library; The table record element knowledge base stores data record element knowledge items associated with each type of table in a structured manner, and the content of the data record element knowledge items includes product object type, implementation process, record element, record system, and required value; The product PBOM database stores product basic information and process requirement information according to product assembly hierarchy relationship; The table style template library stores various table style templates according to different dimensions and performs version update.

7. The flexible design based on structured table data acquisition system of claim 5, wherein, The corresponding table flexible design includes table style flexible design, table content flexible design, and table function flexible design; Table style flexible design: by importing an Excel style template or inheriting the style attributes of each cell and customizing adjustment, batch flexible setting of style attributes at the cell level is performed to generate cell style features and aggregate table style feature matrix; Table content flexible design: structured data record elements are automatically extracted from the table record element knowledge base of the table knowledge database according to table type to generate column attributes of the table; product basic information and process requirement information are automatically extracted from the product PBOM database of the table knowledge database according to the product type to which the table is applicable to generate row attributes of the table; Obtaining table content feature matrix; Table function flexible design: batch flexible setting of function types of each cell is performed to store function features of the cells in a structured manner to aggregate table function feature matrix.

8. The flexible design based on structured table data acquisition system of claim 5, wherein, Module M4 further includes the following sub-modules: Multifunctional structured table associated storage module: storing table style features and table function features in a json format intermediate data file, storing table content features in a relational database table, and associating and mapping the json format intermediate data file and the relational database table through cell position coordinates; Multifunctional structured table lightweight rendering module: loading a json intermediate data file through B / S web page to render table style and table function, and extracting structured data or image attachments through cell coordinate association to present the multifunctional structured table in a lightweight manner.

Images