CN113987083A - Rail vehicle database system - Google Patents

Abstract

The invention provides a database system for rail vehicles, comprising: the system comprises a database classification management module, a data template management module, a data management module and a plurality of sub-databases; the database classification management module is used for dividing and/or adjusting the categories of the sub-databases according to the categories of the professional disciplines; the data template management module is used for defining data templates for a plurality of sub-database definitions respectively; the data management module is used for realizing the input, the verification and the operation of data and managing the data relation among the data; the plurality of sub-databases are used for storing data of corresponding professional discipline categories. The method stores and manages the rail vehicle data according to the subject classification, and establishes the data relationship for the stored data with the incidence relationship, so that the existing rail vehicle data becomes 'live data', the rail vehicle data can be conveniently and rapidly searched, and the reference and the application of subsequent research and development are facilitated.

Description

Rail vehicle database system

Technical Field

The invention relates to the field of databases, in particular to a database system of a railway vehicle.

Background

In the rail vehicle industry, after years of product design, development and informatization construction, the rail vehicle has massive product design, simulation, manufacture, test and operation and maintenance data.

In the prior art, the storage and management of data related to rail vehicles has been performed by way of informatization systems. However, there are some problems, including: the lack of scientific classification and organization during data storage results in the failure to effectively utilize the existing data, which becomes "dead data" and is not conducive to reference and application of subsequent research and development.

Disclosure of Invention

Aiming at the problems in the prior art, the invention provides a database system of a railway vehicle.

The invention provides a database system for rail vehicles, comprising: the system comprises a database classification management module, a data template management module, a data management module and a plurality of sub-databases; wherein the content of the first and second substances,

the database classification management module is used for dividing and/or adjusting the categories of the sub-databases according to the categories of the professional disciplines;

the data template management module is used for defining data templates for the plurality of sub-database definitions respectively; the data template describes attribute information of data stored in a corresponding sub-database;

the data management module is used for realizing the input, the verification and the operation of data and managing the data relation among the data;

the sub-databases are used for storing data of corresponding professional discipline categories.

According to the database system of the railway vehicle, the database classification management module divides the sub-databases according to a predefined classification tree form; wherein the content of the first and second substances,

the classification tree is defined according to a plurality of disciplines related to the rail vehicle, and the first layer of the classification tree describes names of a plurality of sub databases divided according to the disciplines; the second layer of the classification tree form classifies data contained in the sub database according to the structure of the rail vehicle; the third layer of the classification tree shape is used for describing different professional technical points; the fourth layer of the classification tree is used for describing different processing flows.

According to the database system for the rail vehicle, the attribute information of the data comprises type information of the data, control information of the data and/or verification information of the data.

According to the database system of the railway vehicle, the data management module is used for displaying parameters of data to be input in different sub-databases to a user according to the data template provided by the data template management module; the data template management module is also used for verifying the data input by the user according to the data template provided by the data template management module; the data replication method is also used for realizing value replication or value reference of data among different sub-databases; and the data relation is established for the data with the incidence relation according to the pre-obtained information.

According to the database system for the rail vehicle provided by the invention, the system further comprises:

the data processing and analyzing module is used for processing and analyzing the rail vehicle data; wherein the process analysis includes operations including summarizing, comparing, plotting, and verifying the data.

According to the database system for the rail vehicle provided by the invention, the system further comprises:

and the data auditing management module is used for realizing the process of approving the data template and/or the data.

According to the database system for the rail vehicle provided by the invention, the system further comprises:

and the data configuration module is used for carrying out configuration management on the modules in the database system of the railway vehicle.

According to the database system for the rail vehicle provided by the invention, the system further comprises:

and the system management module is used for managing any one of the user, the role and the organization, configuring corresponding authority and managing system logs.

According to the database system for the rail vehicle provided by the invention, the system further comprises:

and the interface management module is used for realizing interface application management with an external database.

According to the database system for the rail vehicle provided by the invention, the system further comprises:

and the data version management module is used for performing version management on the data stored in the database system of the rail vehicle.

The rail vehicle database system provided by the invention can store and manage the rail vehicle data according to subject classification, and establish a data relationship for the stored data with the incidence relationship, so that the existing rail vehicle data becomes 'live data', the rail vehicle data can be conveniently and rapidly searched, and the reference and application of subsequent research and development are facilitated.

Drawings

In order to more clearly illustrate the technical solutions of the present invention or the prior art, the drawings needed for the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and those skilled in the art can also obtain other drawings according to the drawings without creative efforts.

FIG. 1 is a schematic diagram of a rail vehicle database system provided by the present invention;

FIG. 2 is an exemplary diagram of a classification tree involved in a rail vehicle database system provided by the present invention;

FIG. 3 is an exemplary diagram of a data relationship diagram involved in a rail vehicle database system provided by the present invention.

Detailed Description

In order to make the objects, technical solutions and advantages of the present invention clearer, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings, and it is obvious that the described embodiments are some, but not all embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.

The rail vehicle database system of the invention is described below in conjunction with fig. 1-3.

Fig. 1 is a schematic diagram of a database system for a railway vehicle according to the present invention, and as shown in fig. 1, the database system for a railway vehicle according to the present invention includes a database classification management module, a data template management module, a data management module, and a plurality of sub-databases.

The database classification management module is used for dividing and/or adjusting the sub-databases contained in the rail vehicle database system according to the categories of the professional disciplines.

In the embodiment, the data stored in the database system of the rail vehicle is data related to processes such as design, simulation, manufacture, test and operation and maintenance of the rail vehicle. As is common knowledge to those skilled in the art, rail vehicles are the result of a combination of multidisciplinary knowledge. In general, it relates to a number of disciplines, such as vehicle dynamics, material engineering, weld simulation, vibration noise, structural strength, ergonomics, hydrodynamics, electrical engineering, system integration, etc. Thus, the rail vehicle data also relates to the above-mentioned subjects.

In the prior art, rail vehicle data is generally stored according to the occurrence time of the data or the structure of the rail vehicle when being stored, but is not classified and stored according to the subject related to the rail vehicle. In this embodiment, the database classification management module divides the database system into a plurality of sub-databases according to the discipline categories, for example: the sub-database comprises 8 disciplinary major sub-databases such as structural strength, vehicle dynamics, hydromechanics, vibration noise, electromagnetic compatibility, power supply and transmission, man-machine engineering, materials and manufacturing process and the like. When data are required to be stored subsequently, the data can be stored in the corresponding sub-database according to the subject to which the data to be stored belong. It should be noted that the types of the sub-databases included in the database system of the rail vehicle are not limited to the above 8 types, and in other embodiments, the types of the sub-databases may also be adjusted according to the development of the rail vehicle technology.

Specifically, the database classification management module may divide the sub-databases according to a predefined classification tree. Wherein the classification tree is defined according to a plurality of disciplines related to the rail vehicle. FIG. 2 is an exemplary diagram of a taxonomy tree, as shown in FIG. 2, the first level of the taxonomy tree describing the names of a plurality of sub-databases partitioned by discipline; the second layer of the classification tree classifies the data contained in the sub-databases according to the structure of the rail vehicle, such as storing data related to a pantograph of the rail vehicle and data related to a bogie of the rail vehicle in different sub-databases; the third layer of the classification tree shape is used for describing different technical points; the fourth layer of the classification tree shape is used for describing different processing flows of simulation, experiment and the like.

Based on the classification tree form, when the database classification management module generates the sub-databases, the corresponding sub-databases and data items in the sub-databases can be generated at one time according to each node in the classification tree form; or when the data is stored, checking whether a sub-database corresponding to the subject to which the data to be stored belongs exists in the database system of the rail vehicle, and if not, newly building a corresponding sub-database or a data item in the sub-database.

The database classification management module can not only create a sub-database according to the data storage requirement, but also adjust the sub-database according to the change of the data storage. The adjustment includes any one of addition, deletion, modification and the like. For example, line test data entry points for structural health monitoring are added to the structural strength sub-database.

The data template management module is used for defining data templates for each sub-database in the database system of the railway vehicle.

In this embodiment, the data template describes attribute information of data stored in the corresponding sub-database. The attribute information of the data may include type information of the data, and the type information may be various, such as a number, an array, text, a figure, a file, time, reference, and the like. The types of data stored in different types of sub-databases may be different. For example, the data for boundary conditions, stiffness values in the structural strength sub-database are numbers; the data of the stress cloud picture, the displacement cloud picture and the like in the structural strength sub-database are pictures.

The attribute information of the data may further include control information of the data. Such as the length of the data, the accuracy of the data, etc. The attribute information of the data may further include verification information of the data. Such as type check information of the data, value check information of the data.

Further, the attribute information of the data may also include name information of the attribute, number information of the attribute, and the like.

The data management module is used for realizing the input, the verification and the operation of data and managing the data relation among the data.

As already mentioned in the preceding description, the rail vehicle database may be divided into a plurality of sub-databases according to the subject categories, and different sub-databases may store data of different subjects; the data in different sub-databases have certain difference in data type, and the data template management module sets corresponding data templates for the different sub-databases. In this embodiment, the data management module may display parameters of data to be input in different sub-databases to a user according to a data template provided by the data template management module; the user may enter data according to these parameters. After the user enters the data, the data management module verifies the entered data according to the data template provided by the data template management module.

For example, according to the definition of the data template, for the data item B in the sub-database a or the sub-database a, it is not allowed to store pictures, and then when the data entered by the user includes pictures, the data management module does not allow to store the data entered by the user (or the pictures in the data entered by the user) into the data item B in the sub-database a or the sub-database a through verification.

There is a case in the processing of data: the data which the user intends to enter are already stored in a certain sub-database of the rail vehicle database system, it is now desirable to store these data in another sub-database of the rail vehicle database system. Obviously, it is time consuming and laborious if the user re-enters the data. In this embodiment, the data management module provides a function of value copying or value referencing.

Value copying refers to copying some data from a prior memory address to a subsequent memory address; value referencing refers to establishing a reference relationship with a prior memory address of some data. The automatic transfer of data from one sub-database to another sub-database can be realized no matter in a value copying mode or a value reference mode, and the problems of complex execution, time and labor waste, high possibility of errors and the like of manual operation of a user can be avoided; meanwhile, the data sharing in the disciplines, between the disciplines and between departments is realized.

The data are related, for example, the boundary conditions of different working conditions of the rail vehicle are related to the stress cloud chart and the displacement cloud chart. In this embodiment, the data management module may further establish a data relationship for the data having the association relationship according to the information obtained in advance. For example, a data relationship graph is established for data having an association relationship. FIG. 3 is an example of a data relationship diagram.

In the data relationship graph, nodes represent data and edges represent associations. If there is an edge between two nodes, it means that there is an association relationship between the data represented by the two nodes. After the data management module establishes the relationship for the data, the jump between the data can be realized. For example, the boundary conditions of different working conditions of the rail vehicle have an incidence relation with the stress cloud picture and the displacement cloud picture, and according to the data relation picture, by clicking a boundary condition button of a certain working condition, the simulation calculation results such as the stress cloud picture and the like can be automatically jumped.

The data management module can also delete, modify and the like the established data relation, and can also realize the operations of browsing, modifying, deleting, downloading and the like of the stored data.

The rail vehicle database system provided by the invention can store and manage rail vehicle data according to subject classification, and establish a data relationship for the stored data with the incidence relationship, so that the existing rail vehicle data becomes 'live data', the rail vehicle database system is favorable for fast searching of the rail vehicle data, and the reference and application of subsequent research and development are favorable.

Based on any one of the above embodiments, in this embodiment, the database system for rail vehicles further includes:

and the data processing and analyzing module is used for realizing the processing and analysis of the rail vehicle data.

After the rail vehicle data are stored in the database, the rail vehicle data need to be processed and analyzed to show the value of the data. In this embodiment, the data processing and analyzing module may perform operations such as summarizing, comparing, plotting, and checking on the data.

Specifically, the data processing and analyzing module can collect data according to retrieval conditions set by a user, and if the user needs to retrieve the size data of the bogie, the data processing and analyzing module can collect all the bogie size data stored in the database system of the railway vehicle.

The data processing and analyzing module can compare data according to comparison conditions set by a user, and if the user needs to know power comparison results of different types of air conditioners in the railway vehicle, the data processing and analyzing module can compare power data of different air conditioners stored in a database system of the railway vehicle.

The data processing and analyzing module can count the data according to the statistical conditions set by the user, and if the user needs to know the damage condition of the wheels of the certain type of railway vehicle in the last 5 years, the data processing and analyzing module can count the damage condition of the wheels of the certain type of railway vehicle stored in the database system of the railway vehicle and display the damage condition in a graph (such as a break-point graph, a curve graph, a pie graph and the like).

The data processing and analyzing module can verify the data according to the verification rule set by the user and verify whether the data storage format, type, unit and the like are stored according to the data standard requirements.

The rail vehicle database system provided by the invention provides a data processing and analyzing function for a user, realizes deep processing on data, and enables the user to acquire deeper information from the data.

Based on any one of the above embodiments, in this embodiment, the database system for rail vehicles further includes:

and the data auditing management module is used for realizing the process of approving the data template and/or the data.

In the approval process, an applicant submits an application through a data approval management module, and the data approval management module transmits the application to a corresponding approver according to a preset approval process; and after the approver approves, transferring the approval result (such as approval, rollback and the like) to the next link of the approval process until the approval process is finished. And feeding back a final approval result to the applicant, wherein the approval result comprises a passing prompt, a failing reason and the like.

The data auditing and managing module can also track and monitor each examining and approving link, and determine the process node where the current application is located.

The database system of the rail vehicle provided by the invention provides a function of approving the data template and/or the data for a user, the standard format requirement of the data is solidified, and the authority and the uniqueness of the data are ensured.

Based on any one of the above embodiments, in this embodiment, the database system for rail vehicles further includes:

and the data configuration module is used for carrying out configuration management on the modules in the database system of the railway vehicle.

Specifically, the configuration management that can be implemented by the data configuration management module may include: the data browsing configuration, for example, sets a query result list display template, sets a result representation field, and display order, arrangement type, whether to fill in, label width, and other screen representation attributes. According to the setting, the data browsing screen dynamically displays the configuration content.

The configuration management may further include: workflow settings, such as providing flexible workflow applications, configuration functions, developing workflows (classification/classification templates/test data) involved in a rail vehicle database system.

The configuration management may further include: and setting physical quantity, such as setting the physical quantity and conversion relation of the parameter item point data.

The configuration management may further include: managing the conversion relation of the physical quantity, and if parameter item physical quantity type is defined/modified/deleted, setting a default unit of the physical quantity; maintaining the relationship between the physical quantities; in the statistical analysis, value conversion of different physical quantities (such as: kg- > g) is supported.

The rail vehicle database system provided by the invention can flexibly configure information such as data browsing, work flow, physical quantity and the like through the data configuration module, and realizes that each function module in the rail vehicle database system is free of maintenance or easy to maintain.

Based on any one of the above embodiments, in this embodiment, the database system for rail vehicles further includes:

and the system management module is used for managing the user, the role and the organization, configuring corresponding authority and managing system logs.

Specifically, when the system management module manages the user, the user information can be added, deleted and modified; when the roles are managed, roles can be defined, and users are allocated to the roles; when managing a organizational structure, an organizational structure may be defined and users assigned to the organizational structure.

When configuring the authority, the system management module can authorize according to the role, the department, the user or the function.

The system management module manages the system log, and comprises: an audit administrator manages and maintains a user login log; the audit administrator manages and checks the management logs of the system administrator maintenance department, the user and the security administrator maintenance role and authorization; and checking the user operation information.

The rail vehicle database system provided by the invention can manage users, roles and organizations in the system through the system management module, configure corresponding authorities, manage system logs and provide help for the operation of the rail vehicle database system.

Based on any one of the above embodiments, in this embodiment, the database system for rail vehicles further includes:

and the interface management module is used for realizing interface application management with an external database.

In this embodiment, the interface management module may provide a data query service in a WebService manner, so that the service system can perform data query.

The rail vehicle database system provided by the invention can realize data communication with the outside through the interface management module.

Based on any one of the above embodiments, in this embodiment, the database system for rail vehicles further includes:

and the data version management module is used for performing version management on the data stored in the database system of the rail vehicle.

The data stored in the database system of the rail vehicle is dynamically changed, and in order to describe the data in the database of the rail vehicle at different times, version numbers can be set for the data. The data version management module can perform version management on data, and specifically comprises: and tracing the historical version data, automatically identifying historical change data and supporting recovery of the historical version data.

The rail vehicle database system provided by the invention can realize version management of data through the data version management module, can realize operations such as data recovery and the like based on the version management of the data, and ensures the data safety of the rail vehicle database system.

Finally, it should be noted that: the above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.

Claims (10)

1. A rail vehicle database system, comprising: the system comprises a database classification management module, a data template management module, a data management module and a plurality of sub-databases; wherein the content of the first and second substances,

the database classification management module is used for dividing and/or adjusting the categories of the sub-databases according to the categories of the professional disciplines;

the data template management module is used for defining data templates for the plurality of sub-database definitions respectively; the data template describes attribute information of data stored in a corresponding sub-database;

the data management module is used for realizing the input, the verification and the operation of data and managing the data relation among the data;

the sub-databases are used for storing data of corresponding professional discipline categories.

2. The rail vehicle database system according to claim 1, wherein the database classification management module divides the sub-databases according to a predefined classification tree; wherein the content of the first and second substances,

the classification tree is defined according to a plurality of disciplines related to the rail vehicle, and the first layer of the classification tree describes names of a plurality of sub databases divided according to the disciplines; the second layer of the classification tree form classifies data contained in the sub database according to the structure of the rail vehicle; the third layer of the classification tree shape is used for describing different professional technical points; the fourth layer of the classification tree is used for describing different processing flows.

3. The rail vehicle database system according to claim 1, wherein the attribute information of the data comprises type information of the data, control information of the data and/or verification information of the data.

4. The database system for the rail vehicles according to claim 1, wherein the data management module is configured to display parameters of data to be input in different sub-databases to a user according to the data template provided by the data template management module; the data template management module is also used for verifying the data input by the user according to the data template provided by the data template management module; the data replication method is also used for realizing value replication or value reference of data among different sub-databases; and the data relation is established for the data with the incidence relation according to the pre-obtained information.

5. The rail vehicle database system according to any one of claims 1 to 4, characterized in that the system further comprises:

the data processing and analyzing module is used for processing and analyzing the rail vehicle data; wherein the process analysis includes operations including summarizing, comparing, plotting, and verifying the data.

6. The rail vehicle database system according to any one of claims 1 to 4, characterized in that the system further comprises:

and the data auditing management module is used for realizing the process of approving the data template and/or the data.

7. The rail vehicle database system according to any one of claims 1 to 4, characterized in that the system further comprises:

and the data configuration module is used for carrying out configuration management on the modules in the database system of the railway vehicle.

8. The rail vehicle database system according to any one of claims 1 to 4, characterized in that the system further comprises:

and the system management module is used for managing any one of the user, the role and the organization, configuring corresponding authority and managing system logs.

9. The rail vehicle database system according to any one of claims 1 to 4, characterized in that the system further comprises:

and the interface management module is used for realizing interface application management with an external database.

10. The rail vehicle database system according to any one of claims 1 to 4, characterized in that the system further comprises:

and the data version management module is used for performing version management on the data stored in the database system of the rail vehicle.

Images