A method and system for importing planning documents into business incubators

Abstract

This invention relates to the field of incubator data processing technology, and discloses a method for importing planning document data for business incubators, including the following steps: S1, reading source files in the source folder; S2, classifying the source file list; S3, obtaining the target data table field list; S4, importing the fields into the target data table; S5, publishing and sharing the data. It also discloses a planning document data import system for business incubators, including a system management module, a data preprocessing module, a data management module, and a publishing management module. This invention, by reading source files in the source folder and performing correlation analysis on entity information, classifies the source file list without repeatedly reading files, thus reducing workload. By importing the required fields one by one into the target data table, data omissions can be effectively prevented. By displaying and sharing the data information, information can be easily accessed by related SMEs within the incubator.

Description

Technical Field

[0001] This invention relates to the field of incubator data processing technology, specifically a method and system for importing planning document data for business incubators. Background Technology

[0002] Business incubators provide newly established technology-based SMEs with physical space and infrastructure, along with a range of support services, to reduce entrepreneurial risks and costs, increase the success rate of startups, promote the transformation of scientific and technological achievements, help and support the growth and development of technology-based SMEs, and cultivate successful enterprises and entrepreneurs. Their organizational structure mainly consists of a project investment promotion department, an industry service department, a comprehensive service department, a property management department, and an information department. Therefore, importing the plan document data into a database for big data analysis can better serve enterprises.

[0003] However, business incubators accumulate a large amount of data in their daily operations. Collecting and integrating this data is of great significance, but the raw data that needs to be processed is usually massive and disorganized, with many types of data to be processed, including both structured and unstructured data. Resource sharing is difficult, which makes it impossible for small and medium-sized enterprises in business incubators to effectively obtain the information they need. Summary of the Invention

[0004] The purpose of this invention is to provide a method and system for importing planning document data for business incubators, so as to solve the problems mentioned in the background art.

[0005] To achieve the above objectives, the present invention provides the following technical solution:

[0006] A method for importing planning document data for business incubators, characterized by comprising the following steps:

[0007] S1. Log in to the plan file data import system through the user rights management unit. Then, collect the corresponding source folder, read the source files in the source folder, and record the valid file names in a list to obtain the source file list.

[0008] S2. The source file content is extracted through the file acquisition and storage unit to achieve semi-structured data; then the entity information extraction unit extracts entities from the semi-structured source file content to achieve fully structured data; next, the data analysis unit performs correlation analysis on the entity information to find data information of interest and establishes relationships between objects to classify the source file list.

[0009] S3. List the fields in the categorized source file list into a new list, select the fields to be imported, and cache the fields to form a data source file field list; select the target server location to be imported, and after the server connection is successful, select the database list under the server, the data source list under the database list, and the target data table under the data source list in sequence to obtain the target data table field list.

[0010] S4. Combine the field list of the data source file and the field list of the target data table to determine the fields of the data source file and the fields of the target data table; based on the fields of the data source file and the fields of the target data table, automatically generate a new data import operation expression, and open and read the data source files one by one according to the data source file list, and import the fields to be imported into the target data table one by one through the data import unit;

[0011] S5. The imported data is assigned to administrators with approval authority for approval through the application unit. The approved data is classified and managed through the internal data management unit. The data information is displayed on the web page through the result display unit. Non-privacy data is shared with other related SMEs in the incubator through the data push unit.

[0012] As a further aspect of the present invention: the field caching method in step S3 includes the following steps:

[0013] S31. Remove the separators between fields and unnecessary fields to obtain the field data;

[0014] S32. After each field data is read, the field data is stored in the field linked list. When all the original field data in a file has been read, a field linked list is created in the server's memory.

[0015] S33. Search the field linked list for identical field data. If not, it indicates a new field. Then, dynamically create a new linked list node to store the field data and continue searching for the next field data until all field data in the plan file has been read. If there is a duplicate field data, it indicates that the field data read this time is a duplicate. There is no need to dynamically create a linked list node. Just record the number of times the field is repeated and create a new field linked list to complete the field storage.

[0016] As a further aspect of the present invention, the method for creating the linked list node in step S33 is as follows:

[0017] S331. Insert a new node with the value x at the i-th position of a linear linked list and return a flag indicating whether the insertion was successful.

[0018] S332. After successful insertion, find the (i-1)th node and set pointer p to that node. Check if the node exists. If it does not exist, end the process. If it exists, request a new node and set pointer S to that new node. Then insert the new node pointed to by pointer S.

[0019] As a further aspect of the present invention, the source file list classification method in step S3 is as follows: the source file list is divided into a categorizable list and an uncategorizable list, and the rationality of the attributes of the categorizable list is verified according to the attributes, and then the rationality of its data is verified; at the same time, the rationality of the data of the uncategorizable list is also verified.

[0020] A data import system for business incubator planning documents includes a system management module, a data preprocessing module, a data management module, and a release management module. The system management module includes an architecture management unit and a user access control unit. The data preprocessing module includes a document acquisition and storage unit, an entity information extraction unit, and a data analysis unit. The data management module includes a data import unit, a data source management unit, and an internal data management unit. The release management module includes a release application unit, a release result display unit, and a data push unit.

[0021] As a further aspect of the present invention: the system architecture management unit is used to modify and view the system architecture; the user permission management unit is used to manage user permission resources, add new users, and set up super users.

[0022] As a further aspect of the present invention: the file acquisition and storage unit is used to extract file content and store it in the database to achieve semi-structured file data; the entity information extraction unit is used to extract entities from the file content to achieve fully structured file data; the data analysis unit is used to perform correlation analysis on entity information, find data information of interest, and establish relationships between objects.

[0023] As a further aspect of the present invention: the data import unit is used to exchange data with external systems and import external data into the system; the data source management unit is used to manage the connection information with external systems and has complete CRUD functions for the imported data; the internal data management unit is used to classify and manage the imported data and can update, delete and preview it.

[0024] As a further aspect of the present invention: the release application unit is used to release the data import process and preprocessing process of the system and assign them to an administrator with approval authority for approval; the release result display unit is used to display the released data information on a web page; the data push unit shares non-privacy data with other small and medium-sized enterprises in other incubators.

[0025] Compared with the prior art, the beneficial effects of the present invention are as follows:

[0026] This invention achieves semi-structured data by reading source files in the source folder and extracting their content. It then extracts entities from the semi-structured source file content to achieve fully structured data. By performing correlation analysis on the entity information, the source file list can be categorized. This process eliminates the need for repeated file reading, minimizing workload. By identifying the fields in the data source file and the target data table, and importing the necessary fields one by one into the target data table, data omissions can be effectively prevented. Furthermore, by displaying and sharing the data, it facilitates information access for SMEs within the incubator. Attached Figure Description

[0027] Figure 1 A schematic diagram of a system for importing planning document data into a business incubator;

[0028] Figure 2 A flowchart illustrating the process of importing planning document data for a business incubator into the system management module.

[0029] Figure 3 This is a flowchart illustrating the process of importing planning document data into a data management module of a business incubator system. Detailed Implementation

[0030] Please see Figures 1-3 In this embodiment of the invention, a method for importing planning document data for a business incubator includes the following steps:

[0031] S1. Log in to the plan file data import system through the user rights management unit. Then, collect the corresponding source folder, read the source files in the source folder, and record the valid file names in a list to obtain the source file list.

[0032] S2. The source file content is extracted through the file acquisition and storage unit to achieve semi-structured data, such as filename, file creation time, and file content. Then, the entity information extraction unit extracts entities from the semi-structured source file content to achieve fully structured data, such as investment information, policy information, resource information, and risk information. Next, the data analysis unit performs correlation analysis on the entity information to find data information of interest and establish relationships between objects, thereby classifying the source file list and achieving an orderly distribution of disorganized data. While mining the data, privacy can be effectively prevented. In a source file list, all files have the same type and field format, so only the fields of the first file in the source file list need to be read, without having to read other files repeatedly.

[0033] S3. List the fields in the categorized source file list into a new list, select the fields to be imported, and cache the fields to form a data source file field list; select the target server location to be imported, and after the server connection is successful, select the database list under the server, the data source list under the database list, and the target data table under the data source list in sequence to obtain the target data table field list.

[0034] S4. Combine the field list of the data source file and the field list of the target data table to determine the fields of the data source file and the target data table. Based on the fields of the data source file and the target data table, automatically generate a new data import operation expression, and open and read the data source files one by one according to the data source file list. Import the fields that need to be imported into the target data table one by one through the data import unit, which can effectively prevent data omission.

[0035] S5. The imported data is assigned to administrators with approval authority for approval through the application unit. The approved data is classified and managed through the internal data management unit. The data information is displayed on the web page through the result display unit. Non-privacy data is shared with other related SMEs in the incubator through the data push unit.

[0036] Preferably, the field caching method in step S3 includes the following steps:

[0037] S31. Since there may be various symbols used as delimiters between fields, first remove the delimiters between fields and unnecessary fields to obtain the field data;

[0038] S32. After each field data is read, the field data is stored in the field linked list. When all the original field data in a file has been read, a field linked list is created in the server's memory.

[0039] S33. Search the field linked list for identical field data. If not, it indicates a new field. Then, dynamically create a new linked list node to store the field data and continue searching for the next field data until all field data in the program file has been read. If the field data is found, it indicates that the field data read this time is a duplicate. It is not necessary to dynamically create a linked list node again. Just record the number of times the field is repeated and create a new field linked list to complete the field storage. This can improve the program's execution efficiency.

[0040] Preferably, the method for creating the linked list node in step S33 is as follows:

[0041] S331. Insert a new node with the value x at the i-th position of a linear linked list and return a flag indicating whether the insertion was successful.

[0042] S332. After successful insertion, find the (i-1)th node and set pointer p to that node. Check if the node exists. If it does not exist, end the process. If it exists, request a new node and set pointer S to that new node. Then insert the new node pointed to by pointer S.

[0043] Preferably, the source file list classification method in step S3 is as follows: the source file list is divided into a categorizable list and an uncategorizable list, and the reasonableness of the attributes of the categorizable list is verified according to the attributes, and then the reasonableness of its data is verified; at the same time, the reasonableness of the data of the uncategorizable list is also verified.

[0044] A data import system for business incubator planning documents includes a system management module, a data preprocessing module, a data management module, and a release management module. The system management module includes an architecture management unit and a user access control unit. The data preprocessing module includes a document acquisition and storage unit, an entity information extraction unit, and a data analysis unit. The data management module includes a data import unit, a data source management unit, and an internal data management unit. The release management module includes a release application unit, a release result display unit, and a data push unit.

[0045] Preferably, the system architecture management unit is used to modify and view the system architecture; the user permission management unit is used to manage user permission resources, add new users, and set up super users; wherein, permission resources are allocated according to roles, thereby realizing permission control and management of system resources and functions.

[0046] Preferably, the file acquisition and storage unit is used to extract file content and store it in the database to achieve semi-structured file data; the entity information extraction unit is used to extract entities from the file content to achieve fully structured file data; and the data analysis unit is used to perform correlation analysis on entity information, find data information of interest, and establish relationships between objects.

[0047] Preferably, the data import unit is used to exchange data with external systems and import external data into the system; the data source management unit is used to manage the connection information with external systems and has complete CRUD functions for the imported data; the internal data management unit is used to classify and manage the imported data and can update, delete, and preview it; small and medium-sized enterprise users enter data information through the data import unit, verify the data, and after verification, insert the corresponding data into the data source list under the database list; and then classify and manage it through the internal data management unit.

[0048] Preferably, the release application unit is used to release the data import process and preprocessing process of this system and assign it to an administrator with approval authority for approval; the release result display unit is used to display the released data information on the web page; and the data push unit shares non-privacy data with other small and medium-sized enterprises in other incubators.

[0049] The above description is merely a preferred embodiment of the present invention, but the scope of protection of the present invention is not limited thereto. Any equivalent substitutions or modifications made by those skilled in the art within the scope of the technology disclosed in the present invention, based on the technical solution and inventive concept of the present invention, should be covered within the scope of protection of the present invention.

Claims

1. A method for importing planning document data for business incubators, characterized in that, It comprises the following steps: S1, log in the plan file data import system through the user permission management unit, then collect the corresponding source folder, read the source files under the source folder, and record the valid file names to a list to obtain the source file list; S2, extract the source file content through the file collection and warehousing unit to realize semi-structured data; then, the entity information extraction unit is used for entity extraction on the semi-structured source file content to realize comprehensive structured data; then, the data analysis unit is used for correlation analysis on the entity information, finds out the data information of interest, and establishes the correlation between objects to realize the classification of the source file list; S3, list the fields in the classified source file list in a new list, select the fields to be imported, cache the fields to form a data source file field list; select the target server position to be imported, and after the server is connected successfully, select the database list under the server, the data source list under the database list, and the target data table in the data source list to obtain the target data table field list; The caching method of the fields in the S3 step comprises the following steps: S31, remove the separators between the fields and the fields that are not needed to obtain field data; S32, store the field data in the field linked list after reading out one field data, and establish a field linked list in the memory of the server when all the original field data in a file is read; S33, find out whether there is the same field data in the field linked list, if not, it indicates that it is a new field, then dynamically create a new linked list node to store the field data, and continue to find the next field data until all the field data in the plan file is read; if yes, it indicates that the current reading is repeated field data, and a new linked list node does not need to be dynamically created, only the repeated number of the field needs to be recorded, and a new field linked list is established to complete the storage of the field; The creation method of the linked list node in the S33 step is as follows: S331, in the linear linked list... Insert one at each position The new node contains the value and returns a flag indicating whether the insertion was successful. S332、When the insertion is successful, find the node and point the pointer to the node, judge whether the node exists, if not, end; if yes, then apply a new node and make the pointer point to the new node; then insert the new node pointed by the pointer. ​​​​ S4, combine the data source file field list and the target data table field list to determine the data source file field and the target data table field; according to the data source file field and the target data table field, automatically generate a new data import operation expression, open and read the data source file according to the data source file list one by one, and import the fields to be imported into the target data table through the data import unit; S5, assign the imported data to the administrator with approval right for approval through the release application unit, classify the data after the approval is completed through the internal data management unit, display the data information on the network page through the release result display unit, and share the non-private data with other small and medium-sized enterprises associated in the incubator through the data pushing unit.

2. The method for plan file data import for business incubator according to claim 1, characterized in that, The source file list classification method in the S3 step is as follows: the source file list is divided into a classifiable list and a non-classifiable list, the attribute rationality of the classifiable list is verified according to the attribute, and then the data rationality thereof is verified; meanwhile, the data rationality of the non-classifiable list is verified.

3. A plan file data import system for an enterprise incubator as claimed in claim 1, wherein, The system comprises a system management module, a data preprocessing module, a data management module and a release management module, wherein the system management module comprises an architecture management unit and a user permission management unit; the data preprocessing module comprises a file collection and storage unit, an entity information extraction unit and a data analysis unit; the data management module comprises a data import unit, a data source management unit and an internal data management unit; and the release management module comprises a release application unit, a release result display unit and a data pushing unit.

4. The plan file data import system for an enterprise incubator of claim 3, wherein, The architecture management unit is configured to modify and view the architecture of the system. The user permission management unit is configured to manage user permission resources, add new users and set super users.

5. The plan file data import system for an enterprise incubator of claim 3, wherein, The file collection and storage unit is configured to extract file content and store the same in a database to realize semi-structured file data; the entity information extraction unit is configured to extract entities from file content to realize comprehensive structured file data; and the data analysis unit is configured to perform correlation analysis on entity information, find data information of interest and establish correlations between objects.

6. The plan file data import system for an enterprise incubator of claim 3, wherein, The data import unit is configured to exchange data with the outside and import data from the outside into the system. The data source management unit is configured to manage connection information with the outside and has complete add, delete, modify and query functions for imported data; and the internal data management unit is configured to classify and manage imported data and perform updating, deleting and previewing.

7. The plan file data import system for an enterprise incubator of claim 3, wherein, The release application unit is configured to release data import and preprocessing processes of the system and assign the same to administrators with approval rights for approval; the release result display unit is configured to display released data information on a network page; and the data pushing unit is configured to share non-private data with small and medium-sized enterprises in other incubators.

Images