CN102169509B - Method for storing metro comprehensive pipeline data based on relational database and XML file - Google Patents

Abstract

The invention relates to a method for storing subway comprehensive pipeline data based on a relational database and an XML file. There are many types of subway comprehensive pipeline information, complex spatial topological relations, and a large amount of overall information. Effectively storing the extracted subway comprehensive pipeline data is the key to effective management of subway comprehensive pipelines. The present invention stores subway comprehensive pipeline information in a storage form of classification first and then layering, stores the space information of the pipeline with the largest amount of computation in an XML file, stores the pipeline attribute data most needed for business logic processing in a relational database, and stores the attribute information of the pipeline and spatial information constitute the data required for 3D digitization of pipelines. The present invention makes the relationship between information data clearer; enables relational databases and XML files to play their respective advantages in data access and improves data processing efficiency; fast business logic processing and calculation of spatial data make this method suitable for subway The data storage process of the comprehensive pipeline visualization management mode.

Description

Data Storage Method of Subway Comprehensive Pipeline Based on Relational Database and XML File

technical field

The invention belongs to the technical field of subway comprehensive pipeline information data management, and in particular relates to a method for storing subway comprehensive pipeline data based on a relational database and an XML file.

Background technique

With the development of my country's urban rail transit, subway construction has entered a period of rapid development. As an important part of subway facilities, subway integrated pipelines are one of the most important facilities that affect the normal operation of subways. How to effectively manage them is a key issue for subway construction units. Important issues facing operating units. At present, there are many types of information on subway comprehensive pipelines, involving dozens of communication pipelines, ventilation pipelines, fire protection, water supply pipelines, etc., and hundreds of pipelines with different functions. Any type of pipeline includes pipelines of different specifications or models; The spatial topological relationship is complex. Due to structural constraints in the subway station, the spatial location of the integrated pipeline is intricate. This complex spatial location relationship causes great inconvenience to design, construction, and maintenance; Pipelines have different spatial information, and different types of relationships have different basic attribute information and business information. Therefore, the subway comprehensive pipeline system has massive data, and the management of these massive data is the most important part of the subway comprehensive pipeline.

How to effectively store the extracted subway comprehensive pipeline data is the key to the effective management of the subway comprehensive pipeline, especially in the 3D visualized comprehensive pipeline management mode, the reasonable storage of pipeline data is an important link in the feasibility and practicality of this mode.

Contents of the invention

The purpose of the present invention is to provide a method for storing subway comprehensive pipeline data based on a relational database and XML files for three-dimensional digitization of subway comprehensive pipeline data, and to provide a data storage scheme for pipeline information for visual image management of subway comprehensive pipelines.

The technical scheme adopted in the present invention is:

The method for storing subway comprehensive pipeline data based on relational database and XML file is characterized in that: it is realized by the following steps:

Step 1: Divide the subway comprehensive pipeline information into two layers: pipeline information and pipeline section information, and the category information and section information are associated through the class ID; then divide the pipeline category information and pipeline section information into attribute information, spatial information and laying information, These three types of information are associated through the segment ID; the pipeline type information only includes attribute information, while the segment information not only includes attribute information, but also includes space information and laying information;

Step 2: Combining the storage characteristics of relational database and XML file, attribute information is stored by relational database, and spatial information and laying information are stored by XML file;

Step 3: In order to reduce data redundancy, two database tables are respectively designed in the relational database to store attribute information in pipeline class information and segment information;

Step 4: The spatial information of the pipeline is reflected by the coordinate pair, which should be stored in the same layer with XML files; in order to associate the spatial information of the pipeline with the attribute information of the pipeline, set the pipeline segment ID as an attribute field of the spatial information, and coordinate fields are in the same layer;

Step 5: Since the space information and the laying information belonging to the same pipeline segment have the same segment ID, the spatial information and the laying information of each pipeline are stored in the same XML file.

In the first step, the class ID is the unique ID number of the pipeline type; the segment ID is the unique ID number of the pipeline segment.

In the first step, the attribute information refers to the characteristics of the pipeline as a specific operating equipment, including: pipeline name, pipeline type, specification, purpose description, laying unit, laying date, service life, and remark information;

The spatial information refers to the three-dimensional coordinate pair information of each section of the pipeline in the determined three-dimensional space coordinate system and the data required for three-dimensional modeling of the pipeline, specifically including the X coordinate, Y coordinate and Z coordinate of the starting point of the pipeline, the X coordinate of the end point of the pipeline, Y coordinate and Z coordinate, the height and width of the square pipe port, the radius of the round pipe port;

The laying information refers to the laying information of the pipeline during the actual construction process, including the start date of pipeline laying and the expected end date of laying, and the actual current actual laying length percentage.

In the third step, the attribute information of the pipeline class is the common information of a category of pipelines, including type, material, service life, and maintenance cycle;

In the third step, the attribute information of the pipeline segment is information specific to a pipeline segment, including pipeline name, type, laying unit, laying date and remarks.

In the step 4, the spatial information is not only reflected by the coordinate pairs, namely the starting X coordinate, the starting Y coordinate, the starting Z coordinate, the ending point X coordinate, the ending point Y coordinate and the ending point Z coordinate, these six attribute fields are reflected, For visual image modeling, the spatial information also includes the representation information of the pipeline, that is, the height and width of the square pipeline port, and the radius of the circular pipeline port.

The present invention has the following advantages:

The present invention stores subway comprehensive pipeline information in a storage form of classification first and then layering, the relationship between the data is clear, and data access is convenient; the pipeline space information with the largest amount of computation is stored in an XML file, which is most needed for business logic processing The attribute data of the pipeline is stored by the relational database, which makes the relational database and XML file play their respective advantages in data access and improves the overall data processing efficiency; the attribute information and spatial information of the pipeline constitute the data required for the three-dimensional digitalization of the pipeline. Moreover, the fast business logic processing and the calculation of spatial data make this method suitable for the data storage process of the visual image management mode of the subway comprehensive pipeline.

Description of drawings

Fig. 1 is a flow chart of steps of the present invention.

Figure 2 is a diagram of the data layering and classification module.

Figure 3 is a diagram of the data classification storage module.

Figure 4 is the organizational model of relational database information data.

Fig. 5 is a relational database segment information data organization mode.

Fig. 6 is a schematic diagram of the XML file structure.

FIG. 7 is a structural diagram and schematic diagram of spatial information data.

Fig. 8 is a structure diagram and a schematic diagram of laying information data.

Fig. 9 is an example diagram of the comprehensive pipeline of the embodiment.

Fig. 10 is an example diagram of the integrated pipeline information database of the embodiment.

Fig. 11 is an example diagram of the water pipe segment information database table in the embodiment.

Fig. 12 is an example diagram of the storage structure of the fresh air duct space information and laying information of the embodiment.

Detailed ways

The present invention will be described in detail below in combination with specific embodiments.

Relational database is a very mature data storage tool at present. The use of relational database system for basic data such as spatial information, attribute information and business information of subway comprehensive pipelines has significant advantages. Easy to operate, through the connection between the application program and the background basic data, it is convenient for users to call and operate the data; easy to maintain, the integrity constraints of the relational model, including entity integrity, referential integrity and user-defined integrity, greatly reduce the Data redundancy and data inconsistency; facilitate data access, provide objects such as stored procedures, views, and triggers, to facilitate user access to data, and data is random access, not only high access efficiency, but also flexible Stronger; more secure, the database has a higher security through the distribution of permissions and encryption measures.

However, one disadvantage of relational databases is that the data access process is slow, which will seriously affect the calculation speed in the massive calculation process. However, the XML file has the characteristics of fast access, and the data access method of the XML file can make up for the shortcoming of the relational database.

XML is an extensible markup language used to transmit and store data. It has a clear hierarchical tree structure and a good format, which is easy to analyze and is suitable for processing data with simple relationships; its data is stored in plain text format. It is a data storage method independent of software and hardware. It can exchange data across platforms and be accessed by different programs. Its data reading is very convenient and has a large storage capacity. Because XML is a plain text file, it can be used to Store massive data, and use tags to describe the data, which can be read conveniently and quickly; however, XML text files are searched sequentially, which is not easy to process business logic. You must search all the previous nodes to find the obtained node.

Combined with the background of the rapid development of the three-dimensional digital management technology of subway comprehensive pipelines and the characteristics of relational databases and XML files, according to the needs of the specific management process of subway comprehensive pipelines, the present invention proposes a method for storing subway comprehensive pipeline data based on relational databases and XML files .

As shown in Figure 1, the specific steps of the subway comprehensive pipeline data storage method based on relational database and XML file involved in the present invention are:

Step 1: Data stratification and classification.

As shown in Figure 2, the comprehensive subway pipeline information is divided into two layers: pipeline class information and pipeline segment information. The class information and segment information are associated through the class ID, which is the unique ID number of the pipeline type. Through the class ID in the segment information, a segment of pipeline can be associated with the information of the type of pipeline it belongs to.

On the basis of layering, pipeline information and pipeline segment information are divided into three categories of information: attribute information, spatial information and laying information. Attribute information refers to the characteristics of the pipeline as a specific operating equipment, including: pipeline name, pipeline type, specification, purpose description, laying unit, laying date, service life, remark information, etc. Spatial information refers to the three-dimensional coordinate pair information of each section of the pipeline in the determined three-dimensional space coordinate system and the data required for three-dimensional modeling of the pipeline, specifically including the X coordinate, Y coordinate and Z coordinate of the starting point of the pipeline, the X coordinate, Y coordinate and Z coordinate, the height and width of the square pipe port, the radius of the round pipe port, etc. The laying information refers to the laying information of the pipeline during the actual construction process, including the start date of pipeline laying and the expected end date of laying, and the actual current actual laying length percentage.

Pipeline information only includes attribute information, while segment information includes not only attribute information, but also space information and laying information. These three types of information are associated through the segment ID, which is the unique ID number of the pipeline segment. The attribute information, space information and laying information of a certain pipeline are associated together through the section ID.

Step 2: Data classification storage.

As shown in Figure 3, the comprehensive pipeline information forms three types of data after layering and classification, namely attribute information, spatial information and laying information. According to the characteristics of different types of information, combined with the storage characteristics of relational database and XML files, attribute Information is stored by relational database, and spatial information and laying information are stored by XML files.

Step 3: Carry out data organization on attribute information.

Both the pipeline class information and segment information contain attribute information, and the attribute information is stored by the relational database. The attribute information of the pipeline class is the common information of a type of pipeline, including type, material, service life, maintenance cycle, etc.; the attribute information of the pipeline segment is the unique information of a pipeline, including the pipeline name, type, laying unit, laying date and Remarks, etc. In order to reduce data redundancy, two database tables are designed in the relational database to store attribute information in pipeline class information and segment information.

The data organization mode of the attribute information in the class information is shown in Figure 4, where the plastic class ID is set as the primary key, which is used to uniquely identify a certain type of pipeline record. Reserved fields are reserved for information attributes other than those mentioned above, and users can decide whether to reserve them or not according to actual needs.

The pipeline section is the main object of subway comprehensive pipeline management, which involves a large amount of business logic. It is also the main data object for visual image modeling and visual image management based on the subway comprehensive pipeline data information. It involves massive digital information, so the pipeline section The organization of information is the focus of the data storage of the subway comprehensive pipeline. In the method proposed by the present invention, the organizational mode of the attribute information in the pipeline segment information is as shown in Figure 5, wherein the segment ID of shaping is set as the primary key, which is used to uniquely identify a certain segment of pipeline records, and the pipeline class ID is set as a foreign key. To facilitate the association of pipeline segment information and class information, the reserved fields are also reserved for segment information attributes other than the above, and users can decide whether to reserve or not according to actual needs.

Step 4: Data organization of spatial information.

The hierarchical structure of the XML file is shown in Figure 6. The spatial information of the pipeline is reflected by a pair of coordinates. The coordinate pair includes the start X coordinate, start Y coordinate, start Z coordinate, end point X coordinate, end point Y coordinate, and end point Z coordinate. These six attribute fields are parallel Relationships, stored in XML files should be in the same layer. In visual image modeling, not only attention is paid to the spatial information of the pipeline, but also the form of the pipeline. Therefore, in addition to the six spatial coordinate attribute fields, the spatial information also includes the information for drawing the pipeline model, such as the height and width of the square pipe port, Or the radius of the round pipe port.

In order to associate the spatial information of the pipeline with the attribute information of the pipeline, the pipeline segment ID is set as an attribute field of the spatial information, which is in the same layer as the coordinate field. The storage structure of the pipeline space information of different ports is shown in FIG. 7 .

Step 5: Carry out data organization for laying information.

The pipeline during the laying period has its specific laying information in addition to all the information of the pipeline that has been laid, and the laying information is the unique attribute of the pipeline during the laying period. The pipeline in the laying period is also an important part of the comprehensive pipeline management of the subway, so the present invention proposes a storage scheme for the laying information of the pipeline during the laying period.

As mentioned earlier, laying information is stored by XML files. The laying information mainly consists of the start laying date, the ending laying date, and the actual laying percentage, etc. Users can add or modify these attribute fields according to actual needs. The specific storage structure is shown in Figure 8. Since the spatial information and the laying information belonging to the same pipeline segment have the same segment ID, the spatial information and the laying information of each pipeline can be stored in the same XML file for the convenience of reading.

The following is the specific embodiment of the subway comprehensive pipeline data storage method based on relational database and XML file involved in the present invention:

Taking the two integrated pipelines of wind pipe and water pipe in the library station of Xi’an Metro Line 2 as an example, the air pipe only includes two kinds of pipelines: fresh air pipe and exhaust pipe, and the water pipe only has one kind of pipeline, drain pipe. Among them, the new The air pipe, exhaust pipe and drain pipe are all composed of two sections, and one section of the new air pipe has been laid, and the other end is still in the laying period, and the laying percentage is 50%. The data storage process is as follows:

Step 1: First, conduct an on-site inspection of the Municipal Library Station, and combine the AutoCAD drawings to count all the two types of integrated pipelines in the station, including air ducts and water pipes, as well as the pipelines contained in each type of pipeline, and the topology of each pipeline situation, as shown in Figure 9.

Step 2: According to Figure 2, layer the information of the two types of integrated pipelines, air ducts and water ducts. Section information of pipes and drain pipes. On the basis of layering, all data are divided into attribute information, spatial information and laying information.

Step 3: Store the class information of air ducts and water pipes in a relational database table, which is only used to store pipeline class information, as shown in Figure 10. The attribute information of the exhaust pipe in the air duct, the fresh air pipe, and the drainage pipe in the water pipe is stored in another relational database table. This table is only used to store the basic attribute information of various pipelines, as shown in Figure 11.

Step 4: Store the space information and laying information of the fresh air pipe, the exhaust pipe, and the drain pipe in three XML files respectively, and each XML file stores all the segment space information and laying information in the corresponding pipeline. The spatial information and laying information structure in the XML file of the new air duct is shown in Figure 12.

Claims (4)

1. the subway comprehensive pipeline data storage method based on relational database and XML file, it is characterized in that: realize by following steps: Step 1: Divide the subway comprehensive pipeline information into two layers: pipeline information and pipeline section information, and the category information and section information are associated through the class ID; then divide the pipeline category information and pipeline section information into attribute information, spatial information and laying information, These three types of information are associated through the segment ID; the pipeline type information only includes attribute information, while the segment information not only includes attribute information, but also includes space information and laying information; in: Attribute information refers to the characteristics of the pipeline as a specific operating equipment, including: pipeline name, pipeline type, specification, purpose description, laying unit, laying date, service life, and remark information; Spatial information refers to the three-dimensional coordinate pair information of each section of the pipeline in the determined three-dimensional space coordinate system and the data required for three-dimensional modeling of the pipeline, specifically including the X coordinate, Y coordinate and Z coordinate of the starting point of the pipeline, the X coordinate, Y coordinate and Z coordinate, the height and width of the square pipe port, the radius of the round pipe port; Laying information refers to the laying information of the pipeline during the actual construction process, including the start date of pipeline laying and the expected end date of laying, and the actual current actual laying length percentage; Step 2: Combining the storage characteristics of relational database and XML file, attribute information is stored by relational database, and spatial information and laying information are stored by XML file; Step 3: In order to reduce data redundancy, two database tables are respectively designed in the relational database to store attribute information in pipeline class information and segment information; Step 4: The spatial information of the pipeline is reflected by the coordinate pair, which should be stored in the same layer with XML files; in order to associate the spatial information of the pipeline with the attribute information of the pipeline, set the pipeline segment ID as an attribute field of the spatial information, and coordinate fields are in the same layer; Step 5: Since the space information and the laying information belonging to the same pipeline segment have the same segment ID, the spatial information and the laying information of each pipeline are stored in the same XML file. 2. the subway integrated pipeline data storage method based on relational database and XML file according to claim 1, is characterized in that: In the first step, the class ID is the unique ID number of the pipeline type; the segment ID is the unique ID number of the pipeline segment. 3. the subway integrated pipeline data storage method based on relational database and XML file according to claim 2, is characterized in that: In the third step, the attribute information of the pipeline class is the common information of a category of pipelines, including type, material, service life, and maintenance cycle; In the third step, the attribute information of the pipeline segment is information specific to a pipeline segment, including pipeline name, type, laying unit, laying date and remarks. 4. the subway integrated pipeline data storage method based on relational database and XML file according to claim 3, is characterized in that: In the step 4, the spatial information is not only reflected by the coordinate pairs, namely the starting X coordinate, the starting Y coordinate, the starting Z coordinate, the ending point X coordinate, the ending point Y coordinate and the ending point Z coordinate, these six attribute fields are reflected, For visual image modeling, the spatial information also includes the representation information of the pipeline, that is, the height and width of the square pipeline port, and the radius of the circular pipeline port.

Images