Rail transit timetable updating method and device

By reading and processing configuration files, establishing documents and connecting objects, the problems of inefficiency, insufficient accuracy and data security risks in rail transit timetable updates are solved, and efficient, reliable and secure timetable updates are achieved.

CN119903065AActive Publication Date: 2025-04-29WUHAN INTELLIGENCE METRO TECH CO LTD
View PDF 4 Cites 0 Cited by

Patent Information

Application Number
CN202411904636.9
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-12-23
Publication Date
2025-04-29
Estimated Expiration
2044-12-23

AI Technical Summary

Technical Problem

The prior art has problems such as inefficiency, insufficient accuracy and reliability, and data security risks in the update process of rail transit train schedules.

Method used

By reading the source configuration file and the destination configuration file, establish document objects and connection objects, and read and update timetable data according to the document format and destination data type to ensure the accuracy and consistency of the data.

Benefits of technology

It realizes the efficiency, accuracy and reliability of timetable updates, reduces the degree of coupling between systems, and enhances data security.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119903065A_ABST
    Figure CN119903065A_ABST
Patent Text Reader

Abstract

The invention discloses a rail transit timetable updating method and device, and belongs to the field of rail transit, and the method comprises the steps: reading a source configuration file, reading a timetable document according to document information parameters, storing the timetable document in a document object, extracting a line name and a workday state according to a document name, and respectively storing the line name and the workday state in a line name object and a workday object; reading the destination configuration file, establishing destination data connection according to the destination parameters, and storing a destination data connection mode into a connection object; performing timetable data reading on the document object according to the item position parameter, and storing the timetable data into the corresponding item object; and establishing a connection relationship between the line name object, the workday object and each project object and the data destination according to the destination position parameter, putting the connection relationship into the array object, performing operation for different destination data types, and updating the execution timetable to the data destination. According to the method, the import workload is reduced, the operation accuracy is improved, and the coupling degree between systems is reduced.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of rail transit, and in particular to a rail transit timetable updating method and device. Background Art

[0002] With the continuous advancement of urban rail transit construction, the number of rail transit lines and stations continues to grow, providing citizens with a more convenient choice for travel. In daily operations, frequent updates of train timetables have become an important task, and changes in train timetables have posed severe challenges to many software systems closely related to them.

[0003] At present, various software systems mainly update train timetables through reserved interfaces, manual input, and shared databases. However, these methods have exposed many problems in actual applications. The reserved interface method is limited by the differences in the construction period and usage cycle of each system. There are problems of inconsistency and incompatibility between interfaces, resulting in low efficiency in timetable updates; the manual input method is not only labor-intensive and error-prone due to the large number of lines and stations, but also seriously affects the accuracy and reliability of the timetable; although the shared database method has improved the efficiency of data sharing to a certain extent, the data security risks cannot be ignored. Once the data is leaked or tampered with, it will cause significant losses to rail transit operations.

[0004] Therefore, there is an urgent need to find a more efficient, secure and reliable way to update the timetable to ensure smooth communication and collaboration among various software systems. Summary of the invention

[0005] In order to solve the above problems, the present invention provides a method and device for updating a rail transit timetable.

[0006] The present invention provides a rail transit timetable updating method, comprising: reading a source configuration file, reading a timetable document according to a document information parameter therein and storing it in a document object, extracting a line name and a weekday status according to a document name, and storing them in a line name object and a weekday object respectively, wherein the document information parameter includes a document name, a document path and a document format; reading a destination configuration file, establishing a destination data connection according to a destination parameter therein, and storing a destination data connection mode in a connection object; for different document formats, reading the timetable data from the document object according to a project position parameter respectively, and storing each item of the read timetable in a corresponding project object respectively; for different destination data types, establishing a connection relationship between a line name object, a weekday object and each item object and a data destination according to a destination position parameter respectively, and putting the connection relationship into an array object; for different destination data types, operating the array object according to the connection object, and executing the timetable update to the data destination; wherein the document information parameter and the project position parameter are pre-configured in the source configuration file, and the destination parameter and the destination position parameter are pre-configured in the destination configuration file, and the destination parameter includes a destination data type, a destination data medium name and a destination data connection mode.

[0007] In the rail transit timetable updating method of the present invention, before reading the destination configuration file, it also includes: generating a timetable document for each line and different working day status for the timetable to be updated, the document name includes the line name and working day status, the working day status includes working days and rest days, and the items in each document include driving direction, station name, station code, first train time, last train time and travel interval.

[0008] In the rail transit timetable updating method of the present invention, before reading the source configuration file, it also includes: configuring the project location parameter in the source configuration file; when the document format is a table format, the project location parameter is the column name corresponding to each project, and when the document format is json, the project location parameter is the key name corresponding to each project.

[0009] In the rail transit timetable updating method of the present invention, before reading the destination configuration file, it also includes: configuring the destination parameter and the destination location parameter in the destination configuration file; when the destination data type is a database type, the destination data medium name is the import data table name, and the destination data connection method is the database connection parameter; when the destination data type is json, the destination data medium name is default, and the destination data connection method is the destination document path.

[0010] In the rail transit timetable updating method of the present invention, the destination location parameters include the line name location parameters of the data destination, the working day status location parameters and the location parameters of each item.

[0011] In the rail transit timetable updating method of the present invention, for different document formats, the timetable data is read from the document object according to the item position parameter, and each item of the read timetable is stored in the corresponding item object, including: when the document format is a table type, the document object is converted into a table object and read in row order, and the corresponding column is read according to each item, and each column value is stored in the corresponding item object; when the document format is a json type, the document object is converted into a json array object and read in row order, and the corresponding key value is read according to each item, and the corresponding column value is stored in the corresponding item object.

[0012] In the rail transit timetable updating method of the present invention, for different destination data types, the connection relationship between the line name object, the weekday object and each project object to the data destination is established according to the destination location parameters, and the connection relationship is placed in an array object, including: when the destination data type is json, create a json object, assign the values ​​of the line name object, the weekday object and each project object to the json object according to the key name configured for each project, and place the json object in the array object; when the destination data type is a database type, establish an insert statement from the line name object, the weekday object and each project object to the data destination, and place the insert statement in the array object.

[0013] In the rail transit timetable updating method of the present invention, for different destination data types, the array object is operated according to the connection object, and the timetable is updated to the data destination, including: when the destination data type is a database type, the database update operation is performed by executing the insert statement in the array object; when the destination data type is json, the array object is output as a file using a file handle connection.

[0014] The present invention also provides a rail transit timetable updating device, comprising: a source reading module, used to read a source configuration file, read the timetable document according to the document information parameters therein and store it in a document object, and extract the line name and the weekday status according to the document name, and store them in the line name object and the weekday object respectively, wherein the document information parameters include the document name, the document path and the document format; a destination reading module, used to read the destination configuration file, establish a destination data connection according to the destination parameters therein, and store the destination data connection mode in the connection object; a data extraction module, used to read the timetable data of the document object according to the project location parameters for different document formats, and store the read timetable data in the timetable object. Each project is stored in a corresponding project object; a connection establishment module is used to establish a connection relationship between the line name object, the weekday object and each project object to the data destination according to the destination location parameters for different destination data types, and put the connection relationship into an array object; a write execution module is used to operate the array object according to the connection object for different destination data types, and update the execution schedule to the data destination; wherein the source configuration file pre-configures document information parameters and project location parameters, and the destination configuration file pre-configures destination parameters and destination location parameters, and the destination parameters include the destination data type, the destination data medium name and the destination data connection method.

[0015] The present invention also provides a computer storage medium, which stores a computer program executable by a processor, and the computer program executes any of the rail transit timetable updating methods described above.

[0016] The beneficial effects of the present invention are as follows: through the form of documents and configurations, an accurate mapping relationship between the data to be imported and the target database (or data file) is established, ensuring the accuracy and consistency of the data. When the target system needs to update the train timetable, each system only needs to perform a simple configuration operation, which significantly reduces the workload of importing and improves the accuracy of the operation. In addition, this configuration-based approach reduces the degree of coupling between systems and enhances the reliability and stability of the import operation. BRIEF DESCRIPTION OF THE DRAWINGS

[0017] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the following briefly introduces the drawings required for use in the embodiments or the description of the prior art. Obviously, the drawings described below are some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0018] Figure 1 This is one of the flow charts of the rail transit timetable updating method according to an embodiment of the present invention;

[0019] Figure 2 This is the second flowchart of the rail transit timetable updating method according to an embodiment of the present invention. DETAILED DESCRIPTION

[0020] In order to make the purpose, technical solution and advantages of the present invention more clearly understood, the present invention is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention and are not used to limit the present invention.

[0021] Combine the following Figure 1 to Figure 2 The rail transit timetable updating method and device of the present invention are described. Figure 1 FIG. 1 is a flow chart of a method for updating a rail transit timetable according to an embodiment of the present invention. Figure 1 As shown, the present invention provides a rail transit timetable updating method, comprising:

[0022] S1. Read the source configuration file, read the timetable document according to the document information parameters therein and store it in the document object, and extract the route name and weekday status according to the document name, and store them in the route name object and weekday object respectively; the document information parameters include the document name, document path and document format; wherein the document information parameters and project location parameters are pre-configured in the source configuration file.

[0023] When the train schedule in the rail transit network is adjusted, the train schedule documents of all lines are sorted out, and each document includes document information, such as the document name F1, the document path F2 and the document format F3, as well as the items of each schedule. In one embodiment, the items in each document include the driving direction, station name, station code, first train time, last train time and travel interval.

[0024] In one embodiment, before reading the destination configuration file, the method further includes: generating a timetable document for each route and different working day status for the timetable to be updated, wherein the document name includes the route name and working day status, and the working day status includes working days and rest days.

[0025] Specifically, each line forms a document D according to working days (Monday to Friday) and rest days (Saturday to Sunday). The document naming rule of the working day schedule D1 is: Line X working day train schedule, and the document name of the rest day schedule D2 is: Line X rest day train schedule. The physical addresses on the disk are P1 and P2 respectively. When the schedules of n lines need to be updated, a total of 2n documents are generated, and the document names are D1, D2, ..., D2n.

[0026] Each document contains the following items: driving direction, station name, station code, first train time, last train time, and running interval. The above content can be provided in table or structured document json format. When organized in table format, the row and column rules of the table are as follows: column (column N1 is the train direction, column N2 is the station name, column N3 is the station code, column N4 is the first train time, column N5 is the last train time, column N6 is the running interval, N1 to N6 are positive integers, and the running interval unit is seconds), row (one data per row), and the relevant content examples are as follows:

[0027]

[0028]

[0029] When the above content is provided in the form of a structured document json, it is required to be a serialized array, which contains several objects including driving direction, station name, station code, first train time, last train time, and running interval. The key name in the object can be customized (for example, K1 represents driving direction, K2 represents station name, K3 represents station code, K4 represents first train time, K5 represents last train time, K6 represents running interval, K1 to K6 are strings, and the running interval unit is for seconds), examples of relevant content are as follows: [{'K1':'direction a','K2':'station a','K3':'aaaa','K4':'06:30','K5':'23:30','K6':'180'},{'K1':'direction a','K2':'station b','K3':'bbbb','K4':'06:33','K5':'23:33','K6':'180'}].

[0030] In general, it is to organize the data of each station on weekdays and weekends for each line. The following describes this type of document as a source document. From the above description, it can be found that the train timetable information in the source document is a list or an array.

[0031] Then put the relevant information of the source document in the source configuration file. The method of the present invention can be implemented by running the script file. When the schedule update script R is running, the source configuration file S is read and detected to determine whether the document name F1, document path F2 and document format F3 configuration items exist. After completion, the format is checked according to the established rules and the schedule document is read according to the document name F1, document path F2 and document format F3. After the reading is completed, the schedule document is an object Z (document object) in the memory.

[0032] According to the document name F1 in the configuration file S, the line name M1 and whether it is a working day M2 are intercepted and assigned according to the naming rules of the document D, where if the document name contains a working day, M2=1, and if the document name contains a holiday, M2=0. M1 and M2 are an object in the memory.

[0033] S2. Read the destination configuration file, establish a destination data connection according to the destination parameters therein, and store the destination data connection mode in the connection object.

[0034] like Figure 2 As shown, read the destination configuration file T, determine whether the destination data type L1, destination data medium name L2 and destination data connection method L3 configuration items exist, and after completion, perform format verification according to established rules and establish a database connection (or file handle connection) based on the data type L1, destination data medium name L2, destination data connection method L3, and store it in object M3.

[0035] S3. For different document formats, the schedule data is read from the document object according to the item position parameter, and each item of the read schedule is stored in the corresponding item object.

[0036] The document formats include table and json. According to different formats, the corresponding items are read according to the configuration of the item location parameters driving direction V1, station name V2, station code V3, first train time V4, last train time V5, and driving interval V6, and the item values ​​are stored in the objects M4, M5, M6, M7, M8, and M9 in the memory respectively.

[0037] S4. For different destination data types, respectively, according to the destination location parameters, establish the connection relationship between the line name object, the weekday object and each project object and the data destination, and put the connection relationship into the array object;

[0038] In one embodiment, the destination location parameter includes a line name location parameter of the data destination, a workday status location parameter, and a location parameter of each item.

[0039] For example, the position parameter of each item is V c1 、V c2 、V c3 、V c4 、V c5 、V c6 , which corresponds to the items in the timetable document, but records the item location of the data destination, and also includes the line name location parameter V c7 , Workday status position parameter V c8 Finally, connect M4, M5, M6, M7, M8, M9, M1, M2 to V c1 、V c2 、Vc3 、V c4 、V c5 、V c6 、V c7 、V c8 The connection relationship is put into the array object P.

[0040] S5. For different destination data types, operate the array object according to the connection object and update the execution schedule to the data destination.

[0041] Taking into account different destination data types, such as database type and json type, corresponding array object P operations are performed to complete the update of the timetable.

[0042] The rail transit timetable updating method of the present invention establishes an accurate mapping relationship between the data to be imported and the target database (or data file) in the form of documents and configurations, thereby ensuring the accuracy and consistency of the data. When the target system needs to update the train timetable, each system only needs to perform a simple configuration operation, which significantly reduces the import workload and improves the accuracy of the operation. In addition, this configuration-based approach reduces the degree of coupling between systems and enhances the reliability and stability of the import operation.

[0043] In one embodiment, before reading the source configuration file, it also includes: configuring a project location parameter in the source configuration file; when the document format is a table format, the project location parameter is a column name corresponding to each project; when the document format is json, the project location parameter is a key name corresponding to each project.

[0044] Configure the document information and project location parameters in the source configuration file S. The specific configuration items are as follows: the document information includes the document name F1, the document path F2, and the document format F3; the project location parameters include the driving direction V1, the station name V2, the station code V3, the first train time V4, the last train time V5, and the driving interval V6.

[0045] For example, F1=Dy, F2=full document path (such as / xxx / xxx / xxx / xxx), and the document format F3 can be table and json, which respectively represent that the document format is table and json.

[0046] When F3=table, V1, V2, V3, V4, V5, and V6 are the corresponding column names. For example, column N1 is the train direction, column N2 is the station name, column N3 is the station code, column N4 is the first train time, column N5 is the last train time, and column N6 is the train interval, then V1=N1, V2=N2, V3=N3, V4=N4, V5=N5, and V6=N6.

[0047] When F3=json, V1, V2, V3, V4, V5, and V6 are corresponding key names. For example, K1 represents the driving direction, K2 represents the station name, K3 represents the station code, K4 represents the first train time, K5 represents the last train time, and K6 represents the driving interval, then V1=K1, V2=K2, V3=K3, V4=K4, V5=K5, and V6=K6.

[0048] In one embodiment, before reading the destination configuration file, it also includes: configuring the destination parameters and destination location parameters in the destination configuration file; when the destination data type is a database type, the destination data medium name is the import data table name, and the destination data connection method is the database connection parameter; when the destination data type is json, the destination data medium name is default, and the destination data connection method is the destination document path.

[0049] Configure the destination data information in the destination configuration file T (the destination data is simply the place where the new train schedule information is going to go, which can be a data table in the destination system or a schedule configuration file in the destination system), including the destination data information and the destination data correspondence. The specific destination parameters include: the type of the destination data L1, the name of the destination data medium L2, and the connection mode of the destination data L3. The destination location parameters include: driving direction C1, station name C2, station code C3, first train time C4, last train time C5, driving interval C6, line name C7, whether it is a working day C8. The data type L1 can be mysql, oracle or jsonarray.

[0050] When L1=mysql and L1=oracle, L2 is the name of the data table to be imported T1, C1, C2, C3, C4, C5, C6, C7, C8 are the corresponding column names in the data table B1. If the column does not exist in the data table, configure the field according to the business system requirements of the data table; L3 is the database connection information, which is filled in according to IP: port: user name: password: database name (for example, L3=127.0.0.1:9999:user:password:dbname).

[0051] When L1=jsonarray, L2 can be unconfigured, C1, C2, C3, C4, C5, C6, C7, and C8 are the target key names; L3 is the full path of the target document (for example, / xxx / xxx / xxx / xxx.json).

[0052] In one embodiment, for different document formats, the schedule data is read from the document object according to the item position parameter, and each item of the read schedule is stored in the corresponding item object, including: when the document format is a table type, the document object is converted into a table object and read in row order, and the corresponding column is read according to each item, and each column value is stored in the corresponding item object; when the document format is a json type, the document object is converted into a json array object and read in row order, and the corresponding key value is read according to each item, and the corresponding column value is stored in the corresponding item object.

[0053] When F3 = table, define the global array variable P, convert the document object Z in the memory into the table object Z1 and read it in row order. Read the corresponding columns according to the configuration of driving direction V1, station name V2, station code V3, first train time V4, last train time V5, and driving interval V6, and store the column values ​​in the objects M4, M5, M6, M7, M8, and M9 in the memory respectively.

[0054] When F3=json, define a global array variable P, convert the object Z in the memory into a json array object Z1 and read it in row order. Each row is read as a json object R1. According to the configuration of driving direction V1, station name V2, station code V3, first train time V4, last train time V5, and driving interval V6, read the corresponding key values, and store the column values ​​in the objects M4, M5, M6, M7, M8, and M9 in the memory respectively.

[0055] In one embodiment, for different destination data types, the connection relationship between the line name object, the weekday object and each project object and the data destination is established according to the destination location parameters, and the connection relationship is placed in an array object, including: when the destination data type is json, creating a json object, assigning the values ​​of the line name object, the weekday object and each project object to the json object according to the key name configured for each project, and placing the json object in the array object; when the destination data type is a database type, establishing an insert statement from the line name object, the weekday object and each project object to the data destination, and placing the insert statement in the array object.

[0056] According to the configuration in the configuration file T, when L1 = jsonarray, a json object R is created in memory. n , according to the key names configured in driving direction C1, station name C2, station code C3, first train time C4, last train time C5, driving interval C6, line name C7, whether it is a weekday C8, the json object R n Assignment, R n The assignment relationship is as follows V c1 =M4, Vc2 =M5, V c3 =M6, V c4 =M7, V c5 =M8, V c6 =M9, V c7 =M1, V c8 =M 2, And R n Put into P. After the table object Z1 is read in row order, the array variable P is operated according to the L1 configuration in T.

[0057] When the target data type is a database type, such as L1 = mysql and L1 = oracle, according to the table column name with values ​​in driving direction C1, station name C2, station code C3, first train time C4, last train time C5, driving interval C6, line name C7, whether it is a working day C8, spell the corresponding data table insert statement Q n , Q n The assignment relationship is as follows V c1 =M4, V c2 =M5, V c3 =M6, V c4 =M7, V c5 =M8, V c6 =M9, V c7 =M1, V c8 =M2, and replace statement Q n Put in P.

[0058] In one embodiment, for different destination data types, the array object is operated according to the connection object, and the execution schedule is updated to the data destination, including: when the destination data type is a database type, the database update operation is performed by executing the insert statement in the array object; when the destination data type is json, the array object is output as a file using a file handle connection.

[0059] When the destination data type is a database type, such as L1 = mysql and L1 = oracle, use the database connection M3 to perform database operations. When L1 = jsonarray, use the file handle connection M3 to output the array variable P1 as a file, and finally complete the timetable update to the data destination.

[0060] The present invention also provides a rail transit timetable updating device, comprising: a source reading module, used to read a source configuration file, read the timetable document according to the document information parameters therein and store it in a document object, and extract the line name and the weekday status according to the document name, and store them in the line name object and the weekday object respectively, wherein the document information parameters include the document name, the document path and the document format; a destination reading module, used to read the destination configuration file, establish a destination data connection according to the destination parameters therein, and store the destination data connection mode in the connection object; a data extraction module, used to read the timetable data of the document object according to the project location parameters for different document formats, and store the read timetable data in the timetable object. Each project is stored in a corresponding project object; a connection establishment module is used to establish a connection relationship between the line name object, the weekday object and each project object to the data destination according to the destination location parameters for different destination data types, and put the connection relationship into an array object; a write execution module is used to operate the array object according to the connection object for different destination data types, and update the execution schedule to the data destination; wherein the source configuration file pre-configures document information parameters and project location parameters, and the destination configuration file pre-configures destination parameters and destination location parameters, and the destination parameters include the destination data type, the destination data medium name and the destination data connection method.

[0061] The rail transit timetable updating device provided in the embodiment of the present invention has the same implementation principle and technical effects as those of the aforementioned rail transit timetable updating method embodiment. For the sake of brief description, for matters not mentioned in the embodiment of the rail transit timetable updating device, reference may be made to the corresponding contents in the aforementioned rail transit timetable updating method embodiment.

[0062] The present application also provides a computer-readable storage medium, such as a flash memory, a hard disk, a multimedia card, a card-type memory (e.g., an SD or DX memory, etc.), a random access memory (RAM), a static random access memory (SRAM), a read-only memory (ROM), an electrically erasable programmable read-only memory (EEPROM), a programmable read-only memory (PROM), a magnetic memory, a disk, an optical disk, a server, an App application store, etc., on which a computer program is stored, and when the program is executed by a processor, a corresponding function is realized. When the computer-readable storage medium of this embodiment is executed by a processor, a method embodiment of rail transit timetable updating method is realized.

[0063] It should be pointed out that, according to the needs of implementation, the various steps / components described in this application can be split into more steps / components, and two or more steps / components or partial operations of steps / components can be combined into new steps / components to achieve the purpose of the present invention.

[0064] The order of execution of each step in the above embodiment does not mean the order of execution. The order of execution of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiment of the present application.

[0065] It should be understood that those skilled in the art can make improvements or changes based on the above description, and all these improvements and changes should fall within the scope of protection of the appended claims of the present invention.

Claims

1. A method for updating a rail transit timetable, characterized in that: The method comprises: Read the source configuration file, read the timetable document according to the document information parameters therein and store it in the document object, and extract the route name and weekday status according to the document name, and store them in the route name object and weekday object respectively, wherein the document information parameters include the document name, document path and document format; Read the destination configuration file, establish a destination data connection according to the destination parameters therein, and store the destination data connection mode in the connection object; For different document formats, the timetable data is read from the document object according to the item position parameter, and each item of the read timetable is stored in the corresponding item object; For different destination data types, a connection relationship between the line name object, the weekday object and each project object and the data destination is established according to the destination location parameter, and the connection relationship is placed in an array object; For different destination data types, the array object is operated according to the connection object, and the execution schedule is updated to the data destination; The source configuration file pre-configures document information parameters and project location parameters, the target configuration file pre-configures destination parameters and target location parameters, and the destination parameters include target data type, target data medium name, and target data connection method.

2. The rail transit timetable updating method according to claim 1, characterized in that: Before reading the destination configuration file, the method further includes: A timetable document is generated for each route and different working day status for the timetable to be updated. The document name includes the route name and working day status. The working day status includes working days and rest days. The items in each document include driving direction, station name, station code, first train time, last train time and travel interval.

3. The rail transit timetable updating method according to claim 1, characterized in that: Before reading the source configuration file, the method further includes: Configuring project location parameters in the source configuration file; When the document format is a table format, the item position parameter is a column name corresponding to each item. When the document format is json, the item position parameter is a key name corresponding to each item.

4. The rail transit timetable updating method according to claim 1, characterized in that: Before reading the destination configuration file, the method further includes: Configuring the destination parameter and the destination location parameter in a destination configuration file; When the target data type is a database type, the target data medium name is the name of the imported data table, and the target data connection method is the database connection parameter; When the target data type is json, the target data medium name is default, and the target data connection method is the target document path.

5. The rail transit timetable updating method according to claim 1 or 4, characterized in that: The destination location parameters include a line name location parameter of the data destination, a workday status location parameter, and a location parameter of each item.

6. The rail transit timetable updating method according to claim 1, characterized in that: The method of reading the schedule data from the document object according to the item position parameter for different document formats and storing each item of the read schedule into the corresponding item object includes: When the document format is a table type, the document object is converted into a table object and read in row order, and the corresponding column is read according to each item, and each column value is stored in the corresponding item object; When the document format is of json type, the document object is converted into a json array object and read in row order, and the corresponding key value is read according to each item, and the corresponding column value is stored in the corresponding item object.

7. The rail transit timetable updating method according to claim 1, characterized in that: For different destination data types, the connection relationship between the line name object, the workday object and each project object and the data destination is established according to the destination location parameter, and the connection relationship is placed in an array object, including: When the destination data type is json, create a json object, assign the line name object, weekday object and the value of each project object to the json object according to the key name configured for each project, and put the json object into an array object; When the destination data type is a database type, create insert statements for the line name object, weekday object, and each item object to the data destination, and place the insert statements into an array object.

8. The rail transit timetable updating method according to claim 7, characterized in that: The method of operating the array object according to the connection object for different destination data types and updating the execution schedule to the data destination includes: When the destination data type is a database type, the database update operation is performed by executing the insert statement in the array object; When the destination data type is json, the file handle connection is used to output the array object as a file.

9. A rail transit timetable updating device, characterized in that: include: A source reading module, used to read a source configuration file, read a timetable document according to the document information parameters therein and store it in a document object, and extract a route name and a working day status according to the document name and store them in a route name object and a working day object respectively, wherein the document information parameters include a document name, a document path and a document format; The destination reading module is used to read the destination configuration file, establish a destination data connection according to the destination parameters therein, and store the destination data connection mode in the connection object; A data extraction module, for reading the timetable data from the document object according to the item position parameter for different document formats, and storing each item of the read timetable into a corresponding item object; A connection establishment module is used to establish connection relationships between the line name object, the weekday object and each project object and the data destination according to the destination location parameters for different destination data types, and put the connection relationships into an array object; A write execution module is used to operate the array object according to the connection object for different destination data types, and update the execution schedule to the data destination; The source configuration file pre-configures document information parameters and project location parameters, the target configuration file pre-configures destination parameters and target location parameters, and the destination parameters include target data type, target data medium name, and target data connection method.

10. A computer storage medium, characterized in that: A computer program executable by a processor is stored therein, and the computer program executes the rail transit timetable updating method described in any one of claims 1-8.

Citation Information

Patent Citations

  • Urban rail transit operation simulation system and method

    CN105835912A

  • Data conversion loading method and device for JSON file and storage medium

    CN112114866A

  • Urban rail transit train operation adjustment scheme optimization method and system

    CN114312926A

  • Automating Creation of Multiple Simultaneous Software Development Environments on a Computer System

    US20240095028A1