GSM-R system engineering data table generation method, system and device and storage medium
By automatically generating the title row and associated data table of the GSM-R system engineering data table, the problem of low work efficiency caused by manual writing is solved, and the automatic filling and efficient generation of data tables are realized.
Patent Information
- Application Number
- CN202510445067.4
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2025-04-10
- Publication Date
- 2025-05-06
- Estimated Expiration
- Not applicable · inactive patent
AI Technical Summary
In the prior art, manual writing of GSM-R system engineering data sheets leads to low work efficiency.
By automatically generating the title row of the target data table based on the GSM-R system network data numbering rules, one or more associated data tables of the target data table are determined, the associated data is obtained from the associated data table and adaptively integrated, the target associated input items are generated and automatically filled in the data table.
It improves data extraction efficiency, reduces the workload of manual input, realizes automatic filling of target data tables, and improves work efficiency.
Smart Images

Figure CN119938718A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of railway communication technology, and in particular to a method, system, device and storage medium for generating a GSM-R system engineering data table. Background Art
[0002] The Global System for Mobile Communications-Railway (GSM-R) is a comprehensive dedicated digital mobile communication system, which is specially used for the daily operation and management of railways. It is a very effective dispatching and command communication tool, which mainly provides wireless train dispatching, marshaling and shunting communication, section maintenance and repair operation communication, emergency communication, tunnel communication and other voice communication functions. It can provide data transmission channels for train automatic control and detection information, and also provides train automatic addressing and passenger services.
[0003] GSM-R system numbering data is the basis for GSM-R system opening, service provision, operation and maintenance. As the scale of GSM-R network projects gradually expands, GSM-R system numbering becomes more and more complex. Generally, designers fill in each project data table manually based on existing information and GSM-R network data numbering rules, and compile them one by one, resulting in low work efficiency. Summary of the invention
[0004] The present invention aims to provide a method, system, device and storage medium for generating a GSM-R system engineering data table, so as to solve the problem of low working efficiency caused by manually writing the GSM-R system engineering data table in the prior art.
[0005] To achieve the above object, the present invention provides the following technical solutions: In a first aspect, a method for generating a GSM-R system engineering data table is provided, comprising: Automatically generate a header row of a target data table based on a GSM-R system network data numbering rule, and determine one or more associated data tables of the target data table through the header row; Acquire the associated data of the header row from one or more associated data tables, adaptively integrate the associated data according to the GSM-R system network data numbering rule, generate target associated input items, and automatically fill the target associated input items into cells corresponding to the header row; Generate a target data table and use it as an associated data table of other data tables.
[0006] Furthermore, before automatically generating the header row of the target data table based on the GSM-R system network data numbering rule, the method further includes: generating a basic data table and at least one application data table according to the input basic data and application data.
[0007] Furthermore, generating a basic data table and at least one application data table based on the input basic data and application data includes: inputting basic data to generate a GSM-R basic data table; obtaining first associated data, and inputting first application data to generate a first application data table, wherein the first application data table obtains the first associated data from the GSM-R basic data table.
[0008] Furthermore, the method further includes: acquiring second associated data, and inputting second application data to generate a second application data table, wherein the second application data table acquires the second associated data from the GSM-R basic data table and / or the first application data table.
[0009] Furthermore, the automatically generating a header row of the target data table based on the GSM-R system network data numbering rule, and determining one or more associated data tables of the target data table through the header row, include: The table name and each title row of the target data table are automatically generated based on the GSM-R system network data numbering rules; one or more associated data tables of the target data table are determined according to the title row, wherein the associated data table is selected from the GSM-R basic data table and at least one application data table.
[0010] Furthermore, the method of obtaining the associated data of the title row from one or more associated data tables and adaptively integrating the associated data according to the GSM-R system network data numbering rules to generate target associated input items includes: traversing each title row, obtaining the associated data of each title row from one or more associated data tables according to the title feature fields; using the associated data of the title row as the target associated input item, or adaptively integrating the associated data of the title row according to the GSM-R system network data numbering rules to generate corresponding target associated input items.
[0011] Furthermore, before generating the target data table, the method further includes: inputting relevant data into the application data cell of the target data table, and reporting an error or triggering an alarm when the input format is incorrect.
[0012] In a second aspect, a GSM-R system engineering data table generation system is also provided, comprising: An associated data table determination module is used to automatically generate a header row of a target data table based on a GSM-R system network data numbering rule, and determine one or more associated data tables of the target data table through the header row; A related data input module, used for extracting related data of the header row from one or more related data tables, adaptively integrating the related data according to the GSM-R system network data numbering rules, generating target related input items, and automatically filling the target related input items into the cells corresponding to the header row; The tabulation module is used to generate a target data table and use the target data table as an associated data table of other data tables.
[0013] Based on the same inventive concept, the present invention also provides an electronic device, comprising: a memory and a processor; the processor is used to read and execute a computer program stored in the memory to implement the aforementioned GSM-R system engineering data table generation method.
[0014] Based on the same inventive concept, the present invention further provides a computer storage medium, wherein the computer storage medium stores computer executable instructions, and when the computer executable instructions are executed, the aforementioned method for generating a GSM-R system engineering data table is implemented.
[0015] Technical effects and advantages of the present invention: One or more associated data tables are determined according to the title row of the target data table, and then the associated data of the title row are extracted from the one or more associated data tables, thereby improving data extraction efficiency; for the associated data of the title row, they are adaptively integrated according to the GSM-R system network data numbering rules, and the generated target associated input items are automatically filled in the cells corresponding to the title row, so that all or part of the data of the target data table can be automatically filled in, thereby reducing the workload of manual input; the target data table can also be used as an associated data table of other data tables. When other data tables are generated subsequently, the associated information does not need to be repeatedly input, thereby improving work efficiency.
[0016] Other features and advantages of the present invention will be described in the following description, and partly become apparent from the description, or understood by practicing the present invention. The purpose and other advantages of the present invention can be realized and obtained by the structures pointed out in the description, claims and drawings. BRIEF DESCRIPTION OF THE DRAWINGS
[0017] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following briefly introduces the drawings required for use in the description of the embodiments. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.
[0018] Figure 1 Flow chart of a method for generating a GSM-R system engineering data table in a first embodiment of the present invention; Figure 2 This is a configuration interface diagram of the base station basic data table in this embodiment; Figure 3 This is the base station basic data table generated in this embodiment; Figure 4This is a configuration interface diagram of the dispatch terminal data table in this embodiment; Figure 5 The dispatch terminal data table generated in this embodiment; Figure 6 This is a configuration interface diagram of the short number call routing data table in this embodiment; Figure 7 A short number call routing data table generated in this embodiment; Figure 8 This is a configuration interface diagram of the station base station area group call data table in this embodiment; Fig. 9 The station base station area group call data table generated in this embodiment; Fig.10 This is a configuration interface diagram of the emergency group call data table in this embodiment; Fig.11 The emergency group call data table generated in this embodiment; Fig.12 This is a configuration interface diagram of the GRIS device configuration data table in this embodiment; Fig.13 The GRIS device configuration data table generated in this embodiment; Fig.14 It is a schematic diagram of the structure of the GSM-R system engineering data table generating system in the second embodiment of the present invention. DETAILED DESCRIPTION
[0019] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.
[0020] In order to improve the efficiency of writing GSM-R system engineering data tables, a first embodiment of the present invention provides a method for generating GSM-R system engineering data tables, such as Figure 1 As shown, the following steps are included: Step S1, automatically generating a header row of a target data table based on a GSM-R system network data numbering rule, and determining one or more associated data tables of the target data table through the header row; In an embodiment of the present invention, the GSM-R system network data numbering rules are numbering rules formulated according to the "Railway Digital Mobile Communication System (GSM-R) Numbering Plan", such as user numbers, equipment numbers, dialing methods, etc., which belong to the prior art and are not described in detail here. Generally, according to the GSM-R system network data numbering rules, the GSM-R system engineering data table is compiled, including the GSM-R basic data table, the GSM-R network interconnection data table, the dispatch terminal data table, the short number call routing data table, the station base station area group call data table, the emergency group call data table, and the GRIS (interface server) equipment configuration data table. The target data table is any one of the other engineering data tables except the GSM-R basic data table. The associated data table of the target data table can be other engineering data tables generated before the target data table.
[0021] Step S2, obtaining the associated data of the title row from one or more associated data tables, and adaptively integrating the associated data according to the GSM-R system network data numbering rules to generate target associated input items, and automatically filling the target associated input items into the cells corresponding to the title row; In step S2, the associated data of each title row is adaptively integrated according to the GSM-R system network data numbering rules to generate target associated input items that comply with the numbering rules. The target associated input items are automatically filled in the cells corresponding to the title row to achieve automatic filling of all or part of the data in the target data table.
[0022] Step S3: Generate a target data table, and use the target data table as an associated data table of other data tables.
[0023] In an embodiment of the present invention, one or more associated data tables are determined according to the title row of the target data table, that is, the data table where the associated data is located is determined from the numerous engineering data tables that have been generated, and then the associated data of the title row is extracted from the one or more associated data tables, thereby improving data extraction efficiency; for the associated data of each title row, it is adaptively integrated according to the GSM-R system network data numbering rules, and the generated target associated input items are automatically filled in the cells corresponding to the title row, so that all or part of the data of the target data table can be automatically filled in, thereby reducing the workload of manual input; the target data table can also be used as an associated data table of other data tables. When other data tables are generated subsequently, the associated information does not need to be repeatedly input, thereby improving work efficiency.
[0024] According to a preferred embodiment, before step S1 of automatically generating the header row of the target data table based on the GSM-R system network data numbering rule, it also includes: generating a basic data table and at least one application data table based on the input basic data and application data.
[0025] In the embodiment of the present invention, the basic data table is a GSM-R basic data table, and the application data table is another data table in the GSM-R system engineering data table except the GSM-R basic data table and generated before the target data table.
[0026] Specifically, the method of generating a basic data table and at least one application data table based on input basic data and application data includes: inputting basic data to generate a GSM-R basic data table; obtaining first associated data, and inputting first application data to generate a first application data table, wherein the first application data table obtains the first associated data from the GSM-R basic data table.
[0027] In the embodiment of the present invention, the basic data is line data and base station data, and the GSM-R basic data table is a line information table generated according to the input line data and a base station basic data table generated according to the input base station data. Preferably, the first application data table obtains the first associated data from the GSM-R basic data table according to its title row, and the first associated data is data associated with the title row, and the title row of the first application data table is automatically generated based on the GSM-R system network data numbering rule.
[0028] Furthermore, the generating of the basic data table and at least one application data table according to the input basic data and application data further includes: obtaining second associated data, and inputting the second application data to generate the second application data table, wherein the second application data table obtains the second associated data from the GSM-R basic data table and / or the first application data table. Preferably, the second application data table obtains the second associated data from the GSM-R basic data table and / or the first application data table according to its title row, the second associated data is data associated with the title row, and the title row of the second application data table is automatically generated based on the GSM-R system network data numbering rule.
[0029] In an embodiment of the present invention, each data table can be generated in a custom order, and the generated data table provides associated data for the subsequent data table to be generated. In the process of generating the target data table, the associated data table is determined by the title row. Since the target data table has multiple title rows, the associated data table can be one or more. In actual applications, each data table is traversed in turn according to the table generation order, and the data table that provides all or the most associated data of the title row can be used as the associated data table. For the data table that provides the same associated data, after the associated data has been extracted from the previous data table, the relevant information of other data tables can be ignored or used as comparison items and auxiliary items, thereby improving the traversal efficiency and data extraction accuracy. After extracting the associated data of the title row from one or more associated data tables, the associated data is processed according to the numbering rules and automatically filled in the cells under the title row. Application data can also be entered into the data table. The application data is data that cannot be obtained from the associated data table and needs to be manually entered. Therefore, an application data table is generated based on the acquired associated data and the self-entered application data, and the application data table provides associated data for subsequent other data tables.
[0030] According to an embodiment of the present invention, the step S1 described in which the header row of the target data table is automatically generated based on the GSM-R system network data numbering rules, and one or more associated data tables of the target data table are determined through the header row, specifically includes: automatically generating the table name and each header row of the target data table based on the GSM-R system network data numbering rules; determining one or more associated data tables of the target data table according to the header row, wherein the associated data table is selected from the GSM-R basic data table and at least one application data table.
[0031] Preferably, the table name of the target data table is automatically generated based on the GSM-R system network data numbering rules, such as the dispatch terminal data table, the short number call routing data table, the station base station area group call data table, the emergency group call data table, etc., as well as several first-level titles of the target data table and second-level titles related to certain first-level titles. For example, in the station base station area group call data table, "Group call personnel list" is the first-level title, and the two related second-level titles are "Group call initiator" and "Group call members".
[0032] According to a specific embodiment, the step S2 of obtaining the associated data of the title row from one or more associated data tables, and adaptively integrating the associated data according to the GSM-R system network data numbering rules to generate target associated input items includes: traversing each title row, obtaining the associated data of each title row from one or more associated data tables according to the title feature fields; using the associated data of the title row as the target associated input item, or adaptively integrating the associated data of the title row according to the GSM-R system network data numbering rules to generate corresponding target associated input items.
[0033] Preferably, the titles of the target data table are sorted, and the program traverses the serial numbers of each title row. During the traversal process, the characteristic fields of the title row are extracted, and the GSM-R basic data table and other generated application data tables are searched according to the title characteristic fields to determine one or more associated data tables related to the target data table. For example, the associated data table of the target data table is determined according to the characteristic fields of the first-level title; for each first-level title, the associated data is obtained from the found associated data table according to the title characteristic fields, and for the second-level title under the first-level title, the associated data of the second-level title is extracted from the associated data of the first-level title; for some associated data, it is directly filled in the cells under the title row as a target associated input item. In addition, for the associated data that needs additional processing, it is integrated and processed to generate target associated input items that comply with the numbering rules, and then automatically filled in the cells of the corresponding title row.
[0034] Before generating the target data table according to step S3, the method further includes: inputting relevant data into the application data cell of the target data table, and reporting an error or triggering an alarm when the input format is wrong. The data input into the application data cell by the staff is data that cannot be obtained from the associated data table.
[0035] According to the embodiment of the present invention, by pre-configuring the input box, the format of the input content is fixed or the number of digits or letters is limited, thereby reducing the possibility of mis-entry or wrong input. For example, the input box for the routing area code can only input numbers or letters, and the number of input digits is limited to 4; the input box for the longitude and latitude of the tower can only input numbers, and when entering text, it will prompt "input error" and clear the input content.
[0036] In actual applications, if the staff is not familiar with the numbering rules, it is easy to make mistakes or incorrect entries when filling in the engineering data table, and professional personnel are required to check and modify it, which wastes manpower and time. The embodiment of the present invention generates a target data table based on the associated data obtained from the associated data table and the self-input application data, thereby reducing the workload of manual input and preventing misinput or incorrect input by restricting the input format, thereby further improving work efficiency. The target data table can also be used as an associated data table for other subsequent engineering data tables, thereby providing associated data for other engineering data tables.
[0037] The following is described by a specific embodiment: 1. Enter the line name (A is the abbreviation of the starting station, B is the abbreviation of the terminal station), the name of the railway bureau, and select the line type (such as C1, C2 or C3) in the configuration interface of the line information table. The line type will affect the generation of associated data in actual application. For example, enter the line name as AB line, select C2 as the line type, click the "√Add" button to store the input information in the system, and generate the line information table. The "Help" button set in this configuration interface can directly jump to the "Railway GSM-R Digital Mobile Communication System Numbering Plan", which provides convenience for staff who are not familiar with the GSM-R network numbering plan rules.
[0038] 2. Based on the GSM-R system network data numbering rules, the header row of the base station basic data table is automatically generated, including: base station serial number, base station name, tower kilometer mark, tower longitude, tower latitude, base station type, cell name, global cell identifier (CGI), routing area code (RAC), base station identification color code (BSIC), number of carrier frequencies, station name, affiliated BSC, base station group ring and remarks.
[0039] like Figure 2 and Figure 3 As shown, in the configuration interface of the base station basic data table, information such as the base station serial number, base station type (such as C1, C2, C3), affiliated BSC (such as bjBSC, syBSC3), and prefix of the global cell identifier (CGI) (such as 46020) are obtained from the line information table and other related input or basic information and automatically filled in, while the base station name (such as jia, jia-yi01, yi, yi-bing01-07, bing), tower kilometer mark, tower longitude, tower latitude, cell name (such as jia, jia-yi01, yi, yi-bing01-07, bing), routing area code (RAC), base station identification color code (BSIC), carrier frequency number, station name (such as Jia, Yi, Bing, Ding), base station group ring and remarks need to be manually input. In addition, by pre-configuring each input box, fixing the format of the input content or limiting the number of digits and letters, the possibility of manual mis-entry or wrong input is reduced. For example, the input box for the routing area code (RAC) can only be entered with numbers or letters, and the number of input digits is limited to 4 digits. The input box for the longitude and latitude of the tower can only be entered with numbers. When entering text, it will prompt "input error" or an alarm, and the input content will be cleared. The total number of digits required to enter the global cell identification code (CGI) is 13 digits. When the input is less than or more than 13 digits, the input box will report an error and prompt that the number of digits entered is incorrect.
[0040] In the configuration interface of the base station basic data table, some input boxes are equipped with a "?" button, i.e., an input prompt button, which is used to provide staff with input instructions for the input box; there is also an "Add" button at the top of the interface, which is used to add the content filled in this interface to the system; a "Show" button is set to view the filled in content in a table format; a "Clear" button is set to clear all the content filled in this interface to empty or format; an "Import Excel" button is set to import the existing GSM-R network engineering data table into the system. For example, when for some reason only a part of the data table is done and you want to continue to add content later, you can enable the "Import Excel" function to add new content.
[0041] The base station basic data table generated in this embodiment provides some associated data for the subsequent dispatch terminal data table, short number call routing data table, station base station area group call data table, emergency group call data table and GRIS equipment configuration data table.
[0042] 3. Based on the GSM-R system network data numbering rules, the header row of the dispatch terminal data table is automatically generated, including: dispatch serial number, dispatch terminal name, dispatch main system, road bureau number (H1H2), dispatch terminal number (ISDN), location number (LN), dispatch terminal function number, dispatch DA value and remarks.
[0043] like Figure 4 and Figure 5 As shown, in the configuration interface of the dispatch terminal data table, the dispatch serial number, the name of the dispatch main system (such as bjFAS, syFAS2) and other information are obtained from the base station basic data table or other basic information and automatically filled in. The information in other title rows needs to be manually entered. For example, the manually entered dispatch terminal name is XY train dispatch desk, XZ train dispatch desk, A station duty desk, etc., and X, Y, and Z are the abbreviations of train line stations. In this embodiment, the dispatch terminal data table is generated based on the automatically filled in associated data and other manually entered data. The dispatch terminal data table is similar to the base station basic data table in basic configurations such as input box configuration and function button configuration, which will not be repeated here.
[0044] 4. Automatically generate the header row of the short number call routing data table based on the GSM-R system network data numbering rules, including: routing object (including sending and receiving ends), cell list, station name, DA and remarks.
[0045] like Figure 6 and Figure 7As shown in the figure, in the configuration interface of the short number call routing data table, the staff respectively input the routing sending object and the routing receiving object. According to the title row, the base station basic data table and the dispatching terminal data table are determined as the associated data tables of the short number call routing data table, and other data are automatically filled. For example, when the routing sending object is four XX train dispatching units and the routing receiving object is the duty desk of Station A, the associated data "cell name" is obtained from the base station basic data table, and the "cell name" corresponding to the routing object is directly filled into the cell under the "cell list" of the short number call routing data table; according to "DA", the associated data "dispatching DA value" and the remarks information are obtained from the dispatching terminal data table, and the DA value in the remarks is automatically filled into the cell under "DA". The configuration of other functions is similar to that of the base station basic data table and will not be elaborated here.
[0046] 5. Automatically generate the title row of the station base station area group call data table based on the GSM-R system network data numbering rule, including: station name, station base station area cell list, group ID and level, group call service area number (SA), group call cell list, group call personnel list and remarks.
[0047] Such as Figure 8 and Fig. 9 As shown in the figure, in the configuration interface of the station base station area group call data table, only the group call service area number (such as 12345, 12346, 12347) needs to be manually input, while the information such as the station name, station base station area cell list, group ID and level, group call cell list, group call personnel list, etc. are the associated data obtained from the base station basic data table, the dispatching terminal data table, and the short number call routing data table. After being adaptively integrated according to the GSM-R system network data numbering rule, the associated input items are automatically generated and filled into the table. For example, when filling in the "group call service area number" as 12345, the station name (A) and the station base station area cell (jia) are automatically filled. In the first-level title "group call cell list", the group call initiating cell (jia) and the group call receiving cell (jia) are automatically filled. Also, according to the first-level title "group call personnel list", the associated data "dispatching terminal name", that is, the duty desk of Station A, is obtained from the dispatching terminal data table. After adaptively integrating and processing this associated data according to the GSM-R system network data numbering rule, the associated input items of the second-level title "group call initiator" are "Station A duty officer, GSM-R mobile user" and the associated input items of "group call members" are "Station A duty officer, GSM-R mobile user".
[0048] In the configuration interface of the station base station area group call data table, only the "Import Excel" button, "Generate Excel" button and "Help" button can be set above the interface. The "Generate Excel" button is used to generate the station base station area group call data table at one key according to the input data and the obtained associated data.
[0049] 6. Automatically generate the header row of the emergency group call data table based on the GSM-R system network data numbering rules, including the base cell, group ID and level, group call service area number (SA), virtual group call number, group call cell list, group call personnel list and remarks.
[0050] like Fig.10 and Fig.11 As shown, in the configuration interface of the emergency group call data table, only the virtual group call number needs to be manually input, and the base cell, group ID and level, group call service area number (SA), group call cell list, group call personnel list and other information are related data obtained from other existing data tables, and the processing method and interface setting of the related data are similar to those of the station base station area group call data table, which will not be repeated here.
[0051] 7. Automatically generate the header row of the GRIS equipment configuration data table based on the GSM-R system network data numbering rules, including the cell name, global cell identity (CGI), GRIS, CTC service common base station data and remarks.
[0052] like Fig.12 and Fig.13 As shown, in the configuration interface of the GRIS device configuration data table, there is no need to manually input any information. You only need to use the "Import Excel" function to extract a lot of related data from the generated Excel tables and import them into the database. Then, use the "Generate Excel" function to generate the GRIS device configuration data table with one click. The processing method of the related data and the interface settings are similar to those of the station base station area group call data table, which will not be repeated here.
[0053] By using the method of the above embodiment, GSM-R system engineering data tables such as base station basic data table, dispatch terminal data table, short number call routing data table, station base station area group call data table, emergency group call data table, GRIS equipment configuration data table, etc. are generated. Since the generated data table provides part of the associated data for the subsequent data table, and the associated data is automatically filled in after being processed according to the GSM-R system network data numbering rules, the problem of large workload, low efficiency and easy error caused by manual numbering in the prior art is solved. At the same time, since the data format is fixed in the input box of the data table, it can effectively prevent mis-entry and wrong input, and when the numbering rules are updated, the numbering rules can be updated by changing the corresponding constraints in the background code.
[0054] The second embodiment of the present invention also provides a GSM-R system engineering data table generation system, such as Fig.14 As shown, the system includes: An associated data table determination module is used to automatically generate a header row of a target data table based on a GSM-R system network data numbering rule, and determine one or more associated data tables of the target data table through the header row; A related data input module, used for extracting related data of the header row from one or more related data tables, adaptively integrating the related data according to the GSM-R system network data numbering rules, generating target related input items, and automatically filling the target related input items into the cells corresponding to the header row; The tabulation module is used to generate a target data table and use the target data table as an associated data table of other data tables.
[0055] Regarding the system in the above embodiment, the specific manner in which each unit module performs operations has been described in detail in the embodiment of the method, and will not be elaborated here.
[0056] Based on the same inventive concept, an embodiment of the present invention further provides an electronic device, comprising: a memory and a processor, wherein the processor is used to read and execute a computer program stored in the memory to implement the aforementioned method for generating a GSM-R system numbering plan data table.
[0057] Based on the same inventive concept, an embodiment of the present invention further provides a computer storage medium, wherein the computer storage medium stores computer executable instructions, and when the computer executable instructions are executed, the aforementioned method for generating a GSM-R system numbering plan data table is implemented.
[0058] In the several embodiments provided in the present application, it should be understood that the disclosed devices and methods can be implemented in other ways. For example, the device embodiments described above are only schematic. For example, the division of the modules is only a logical function division. There may be other division methods in actual implementation, such as multiple modules or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or modules, which can be electrical, mechanical or other forms.
[0059] The modules described as separate components may or may not be physically separated, and the components displayed as modules may or may not be physical modules, that is, they may be located in one place, or they may be distributed on multiple network modules. Some or all of the modules may be selected according to actual needs to achieve the purpose of the scheme of this embodiment. In addition, the functional modules in the various embodiments of the present invention may be integrated into a processing module, or each module may exist physically separately, or two or more modules may be integrated into one module. The above-mentioned integrated modules may be implemented in the form of hardware or in the form of software functional modules.
[0060] If the integrated module is implemented in the form of a software function module and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product. The computer software product is stored in a storage medium, including several instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present invention. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), disk or optical disk, etc. Various media that can store program codes.
[0061] It should be noted that, for the convenience of description, the aforementioned method embodiments are all described as a series of action combinations, but those skilled in the art should be aware that the present invention is not limited by the described action sequence, because according to the present invention, certain steps can be performed in other sequences or simultaneously. Secondly, those skilled in the art should also be aware that the embodiments described in the specification are all preferred embodiments, and the actions and modules involved are not necessarily required by the present invention.
[0062] In the above embodiments, the description of each embodiment has its own emphasis. For the part not described in detail in a certain embodiment, please refer to the relevant description of other embodiments. Finally, it should be noted that the above description is only a preferred embodiment of the present invention and is not used to limit the present invention. Although the present invention is described in detail with reference to the above embodiments, for those skilled in the art, they can still modify the technical solutions recorded in the above embodiments, or replace some of the technical features therein with equivalents. 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
1. A method for generating a GSM-R system engineering data table, characterized in that: The method comprises: Automatically generate a header row of a target data table based on a GSM-R system network data numbering rule, and determine one or more associated data tables of the target data table through the header row; Acquire the associated data of the title row from the one or more associated data tables, adaptively integrate the associated data according to the GSM-R system network data numbering rule, generate target associated input items, and automatically fill the target associated input items into cells corresponding to the title row; The target data table is generated, and the target data table is used as an associated data table of other data tables.
2. The method according to claim 1, characterized in that Before the header row of the target data table is automatically generated based on the GSM-R system network data numbering rules, it also includes: A basic data table and at least one application data table are generated according to the input basic data and application data.
3. The method according to claim 2, characterized in that The step of generating a basic data table and at least one application data table according to the input basic data and application data comprises: Input basic data and generate GSM-R basic data table; The first associated data is obtained, and the first application data is input to generate a first application data table, wherein the first application data table obtains the first associated data from the GSM-R basic data table.
4. The method according to claim 3, characterized in that: Also includes: Acquire second associated data, and input second application data to generate a second application data table, wherein the second application data table acquires the second associated data from the GSM-R basic data table and / or the first application data table.
5. The method according to claim 2, characterized in that: The method of automatically generating a header row of a target data table based on the GSM-R system network data numbering rule, and determining one or more associated data tables of the target data table through the header row, includes: Automatically generate the table name and title rows of the target data table based on the GSM-R system network data numbering rules; One or more associated data tables of the target data table are determined according to the header row, wherein the associated data tables are selected from the GSM-R basic data table and at least one application data table.
6. The method according to claim 1, characterized in that The acquiring the associated data of the header row from the one or more associated data tables, and adaptively integrating the associated data according to the GSM-R system network data numbering rule to generate target associated input items, includes: Traversing each of the title rows, and acquiring associated data of each title row from the one or more associated data tables according to the title feature fields; The associated data of the title row is used as the target associated input item, or the associated data of the title row is adaptively integrated according to the GSM-R system network data numbering rule to generate the corresponding target associated input item.
7. The method according to claim 1, characterized in that Before generating the target data table, the method further includes: Relevant data is input into the application data cell of the target data table, and an error is reported or an alarm is triggered when the input format is incorrect.
8. A GSM-R system engineering data table generation system, characterized in that: The system comprises: An associated data table determination module, used to automatically generate a header row of a target data table based on a GSM-R system network data numbering rule, and determine one or more associated data tables of the target data table through the header row; A related data input module, used for acquiring the related data of the title row from the one or more related data tables, adaptively integrating the related data according to the GSM-R system network data numbering rule, generating target related input items, and automatically filling the target related input items into the cells corresponding to the title row; The tabulation module is used to generate the target data table and use the target data table as an associated data table of other data tables.
9. An electronic device, characterized in that: include: Memory, processor; The processor is used to read and execute the computer program stored in the memory to implement the method according to any one of claims 1 to 7.
10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer-executable instructions, and the computer-executable instructions, when executed, implement the method according to any one of claims 1 to 7.
Citation Information
Patent Citations
Method for creating data table and computing equipment
CN110909003A
Form filling method and device, equipment and medium
CN112765944A
Report generation method and terminal
CN115169303A
Method, device and equipment for automatically generating data
CN115185845A
Online table data generation method and device and medium
CN115496044A