JP2003099572A - Data management method and data management system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To systematically perform management of data about construction plan for a communication network having various facilities with complicatedly correlating objects to manage. SOLUTION: A construction facility management program manages an existing attribute management table managed on an existing communication network facility management DB, an existing graphic attribute link table, a construction use attribute table corresponding to an existing graphic layer, a construction use graphic attribute link table, a construction use graphic layer, a construction job name table, and a construction history table, all on a construction facility management DB. A construction completion program builds data after implementation of the construction plan on the existing facility management DB by extracting information on the specified construction from the construction facility management DB so as to be reflected in the existing facility management DB. A display attribute change processing program extracts data from the construction use graphic attribute link information, and displays on a screen the construction plan information which varies depending on a construction specified.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a construction management data management method and data management system, and more particularly to a data management method and data management system suitable for construction management of a communication network.

[0002]

2. Description of the Related Art Generally, in construction management of a communication network, the scope of construction is geographically large and it is difficult to manage construction plan data linked with geographical information. For this reason, there is currently no known system for managing the construction plan data linked with the geographical information.

On the other hand, a GIS (Geographic Information Systems) is known as a technique that enables a configuration for managing various data related to geographical information. This system makes it possible to add various information to data having information about a position based on a geographical position as a clue, manage the data, and visually display them.

As a conventional technique for managing information relating to the position of the geographic information system and various information in association with each other, a technique described in, for example, Japanese Patent Laid-Open No. 2001-134595 is known. This conventional technique manages various kinds of information related to geographic information by managing a process of associating position-related information with various information associated with the position and managing link information thereof.

[0005]

In recent years, there has been an increasing demand for the adoption of IT, and along with this, the infrastructure of communication networks has been rapidly required. Therefore, it is necessary to efficiently carry out the construction of the communication network, and the construction plan of the communication network is complicated, and it is required to systematically manage the data related to such construction plan.

However, conventionally, there has not been a system that systematically manages data relating to a construction plan of a communication network.

In view of the foregoing, an object of the present invention is to provide a data management method capable of systematically managing data related to a construction plan of a communication network having a variety of facilities whose management targets are complicatedly interrelated. Another object of the present invention is to provide a data management system, and a data management method and a data management system that can effectively use the conventionally known GIS.

[0008]

According to the present invention, the above object is to provide a data management method for construction plan management, which has an existing equipment management database and a construction equipment management database. In the items managed in the existing equipment attribute management table, "Construction N
o ”,“ Management No ”,“ Sub Management No ”,“ Parent-Child N ”
“O”, “Brother No.”, “Management flag”, “Display color” are added, and these are managed in the equipment attribute management table for the construction plan in the construction equipment management database. As the key items of the equipment attribute management table, the key items in the existing equipment attribute management table, and the "construction case number", "management No", "sub-management No", "parent-child N"
It is achieved by using “o” and “brother No.” and generating a history of existing equipment information changed by the construction plan or a history of new construction equipment information based on the key items. It

Further, the above object is to provide a data management system for managing a construction plan, which comprises an existing equipment management database, a construction equipment management database, and a central processing unit, and the existing equipment management database manages existing equipment attributes. A table and an existing equipment graphic attribute link table, and the construction equipment management database has a construction equipment attribute management table, a construction equipment graphic attribute link table, a construction subject table, and a construction history table. ,
The central processing unit has an existing equipment management program, a construction equipment management program, a construction completion program, and a display attribute change processing program, and the construction equipment management program is managed by the existing equipment attribute management table. "Construction No.", "Management No.", "Sub Management No.", "Parent-Child No.", "Sibling No.", "Management Flag", "Display Color" are added to the existing items. A means for managing in the equipment attribute management table for construction planning, and a key item in the existing equipment attribute management table as a key item of the equipment attribute management table for construction planning, the "construction case number", "management" No ”,“ sub management No ”,
Using "parent-child No." and "sibling No.", it has a means for generating a history of existing facility information changed by a construction plan or a history of new construction facility information based on the key item. It is achieved by

[0010]

BEST MODE FOR CARRYING OUT THE INVENTION Embodiments of a data management method and a data management system for a communication network construction plan according to the present invention will be described in detail below with reference to the drawings.

FIG. 1 is a block diagram showing the configuration of a data management system for a communication network construction plan according to an embodiment of the present invention. In FIG. 1, 1 is a display, 2
Is a keyboard device, 3 is a central processing unit, 4 is an existing facility management DB, 5 is a construction facility management DB, 6 is a map DB, 7 is an existing facility management program, 8 is a construction completion program, 9 is a construction facility management program, 10 Is an existing attribute management table, 11 is an existing figure attribute link table, 12 is an existing figure layer, 13 is a construction equipment attribute management table, 14 is a construction equipment figure attribute link table, 15 is a construction figure layer, and 16 is a construction subject. A table, 17 is a construction history table, 18 is a graphic data display processing program, and 19 is a display attribute change processing program.

As shown in FIG. 1, a data management system according to an embodiment of the present invention includes a display device 1 for displaying graphic data having position information, facility management information, etc. on a screen, and an administrator performing various processes. Keyboard device 2 for inputting data such as instructions and facility management information, a central processing unit 3 that executes various programs to manage construction data according to the present invention, and an existing facility management DB 4 that manages facilities of a communication network. And a construction equipment management DB 5 that manages equipment planned for construction of the communication network.

The central processing unit 3 has an existing equipment management program 7, a construction completion program 8, a construction equipment management program 9, a display attribute change processing program 19, and a graphic data display processing program 18, and these are executed. Run. The graphic data display processing program 18 has a function of displaying a graphic on a map on a screen and an interface (having a library whose display color can be changed by a user program). This program is a standard GIS. What is provided can also be used.

The existing facility management DB 4 includes a facility attribute management table 10 for various existing facilities and a plurality of existing graphic attribute link tables 11 for managing link information between corresponding existing facility attribute management information and graphic information. And a plurality of existing graphic layers 12 (layers: units for classifying data when a data file is created from a map) that manages graphic data having information on the position of existing equipment.

The construction equipment management DB 5 is a link between a plurality of construction equipment attribute tables 13 for managing data such as new construction according to a construction plan and corresponding construction equipment attribute management information and construction equipment graphic information. It comprises a plurality of construction facility graphic attribute link tables 14 for managing information, and a plurality of construction graphic layers 15 for managing graphic data having information on the position of a new building or the like according to a construction plan.

In the above description, the existing graphic layer 12 and the construction graphic layer 15 logically belong to the existing equipment management DB 4 and the construction equipment management DB 5, respectively, but physically, on the map DB 6. It is managed. Further, in the embodiment of the present invention to be described, the communication network is an optical cable network system, and further it is possible to input / reference information on communication equipment and output a drawing.

In the above description and the following description, "existing" means "existing equipment".

FIG. 2 is a diagram for explaining the relationship of the existing equipment management data in the existing equipment management DB 4 in FIG. 1, which will be described below. Note that the example shown in FIG. 2 is a part of a data-related diagram of existing equipment management data for an optical cable network in which the minimum necessary parts have been extracted to explain the present invention.

In FIG. 2, the cable core wire table is
This is a table that manages one core wire (glass wire) of an optical fiber cable, and the cable I is used for each cable.
It manages D, core number, and line connection ID. The closure table is a table for managing cable connection equipment called a closure, and manages each equipment as an accessory of a telephone pole by means of equipment ID and installation equipment ID.
The cable connection table manages the cables as equipment that is connected to each other by connection equipment such as closures, and for each cable, the cable ID, the equipment to which both ends of the cable are connected, terminal 1 equipment, terminal 2 equipment. Is managed by each ID. The cable figure table manages the cables between the electric poles and manages them so as to be the constituent elements of the cables that are connected to each other by the connection equipment. The cable graphic ID, the cable ID, the end 1 equipment ID, and the end 2 It is managed by facility ID. The intra-closure connection table manages connection information between core wires by a closure, which is a cable connection equipment, and includes equipment ID and installation equipment I.
It is managed by D. The line connection table manages the connection of the cable cores connected in the closure, and manages the line connection ID, end 1 node ID, and end 2 node ID for each line.

Further, the cable figure management table is a table for managing the link information of the record of the cable figure on the map and the cable figure table, and the map DB 6
It has as its management items the shape element number that is the primary key of and the cable figure ID of the primary key of the cable figure table. The closure figure management table and the telephone pole figure management table are tables for managing the link information between the closure figure and the telephone pole figure, like the cable figure management table.

FIG. 3 is a diagram for explaining the concept in which the minimum unit of data has a history according to the construction plan,
Figure 4 shows data updating without causing data inconsistency.
Fig. 5 is a diagram explaining the indexes for managing new installations, and Fig. 5 is Fig. 3
FIG. 6 is a diagram expressing flags of parent-child No. and sibling No. by applying the indexes shown in FIG. 4 in each case of FIG. 4, and then referring to these drawings, “parent-child No.” and “parent-child No.” in data management according to the present invention. The concept of "sibling No." will be described.

First, referring to FIG. 3, a case in which the minimum unit of data can have a history depending on a construction plan will be described.

In case 1, the records managed as the existing equipment (hereinafter referred to as "existing records") are 1
Or, it shows the state referred to by a plurality of construction plans. Specifically, this corresponds to a case where a cable is newly installed in an existing closure by construction, and in that case, the record of the existing closure table and the state of the construction plan referring to the record are shown.

Case 2 shows a state in which the "existing record" is deleted by one construction plan (at the completion of construction). Specifically, it shows the record of the existing closure table when removing the existing closure and the state of the construction plan for deleting the record when the construction is completed.
The point to be noted here is that if the existing records are allowed to be deleted by multiple (two or more) construction plans, the records that do not exist will be deleted when the construction is completed, resulting in a contradiction. That is the point. Therefore, it is necessary to manage the data so as not to allow such a state.

Case 3 shows a newly installed state,
Specifically, in the case of Case 1 described above, the cable connection record is newly added when the construction is completed (hereinafter referred to as “new addition record”).

In case 4, the "new addition record" is
The state referred to by one or more construction plans is shown.

Case 5 shows a state in which the "existing record" is updated by one or a plurality of construction plans.
In this case, one existing record is not allowed to be updated by two or more construction plans for the same reason as described in case 2.

In case 6, the "new addition record" is
The state is updated by one or more construction plans.

Case 7 shows a state in which the "existing record" is updated by one construction plan and then referred to by a plurality of construction plans.

In case 8, the "newly added record" is
After being updated by one construction plan, the state is referred to by a plurality of construction plans.

Next, with reference to FIG. 4, an index for managing data update and new installation without causing data inconsistency will be described. The example shown in FIG. 4 is expressed with the “existing record” or “newly added record” as the origin, and further represents the state of the record that is referred to or updated by the construction plan.

The present invention is characterized in that the history of the record update direction is managed as the parent-child No. and the history of the reference direction is managed as the sibling No. In addition, management of these history is
From the viewpoint of data consistency, a record on the Y axis that has a referred history (X direction) cannot have an updated history, and a record on the Y axis that has an updated history is referred to as a history. Must be done so as not to have. In other words, the management of these histories is expressed in terms of parents and siblings: "If you have a younger brother, you cannot have children." If you have no children, you can have a younger brother. "

Next, referring to FIG. 5, in each case of FIG. 3, parent-child No. and sibling N fitted to the index shown in FIG.
The o flag will be described.

In FIG. 5, the drawings shown as case 1 to case 8 correspond to the cases 1 to 8 in FIG. The sibling No. corresponding to the reference direction is numbered with coordinate values in order to facilitate understanding of the description of the present invention.
Except for 0 and 1, there is no essential difference in data management.
In other words, the sibling numbers have the same rating regardless of the No value, and it is possible to manage the No value of 2 or later as 1.

FIG. 6 is a diagram for explaining the "management flag" and "display color" managed by the construction facility attribute management table 13 and the construction facility graphic attribute management table 14, which will be described below. .

As shown in FIG. 6 (a), the management flags managed by the construction facility attribute management table are record addition, record deletion, record reference, and record update, and FIG. As shown, the management flags managed by the construction facility attribute graphic link table are graphic drawing, graphic deletion, and graphic reference, and the processing performed by these flags is the processing described at the corresponding position in the figure. Is. The management flags of these tables have slightly different meanings, and in particular, the flag construction graphic in FIG. 6B is deleted when there is no graphic management record having the same system ID. .
The display color of the facility graphic attribute management table for construction is shown in Fig. 6.
As shown in (c), it is used for the display change processing of the construction figure, and the new color and the removal color are prepared.

FIG. 7 is a diagram for explaining the relationship between the construction facility data in the construction facility management DB 5 corresponding to the existing facility management data described in FIG. 2, and this will be described next.

A major difference in comparison with the example shown in FIG. 2 of the construction equipment data shown in FIG. 3 is that there is no construction table corresponding to the existing equipment management line connection table. The line connection table of the existing equipment management is a table for managing the connection of the cable cores, and therefore is data that covers a wide range on the map. In the case of the embodiment of the present invention,
To prevent the connection construction plans between different connection facilities from affecting each other (in order to localize and manage the construction plans), do not have a line connection table for construction, Originally, the line processing (processing to group the cable core records having the same connection with the line connection record and manage the start and end information as the line information) will be performed when the construction is completed. In addition, the reason for adopting the sub-management No. in the connection table in the construction closure is that the construction operation is grouped without assigning a management No. when connecting and disconnecting with the same construction number on the same closure. This is because

FIG. 8 is a diagram for explaining the functions of the construction facility management program 9 and the construction completion program 8, which will be described below.

First, a construction matter (construction including one or a plurality of constructions that constitutes one set) is registered, and after that, a construction equipment management program, after selecting a construction matter number of the registered construction matter, The construction completion program is executed. When selecting the construction case number, the central processing unit 3 shown in FIG. 1 is caused to read as the construction case number currently selected.
Therefore, each construction facility management program including the new installation function is started after the user designates the construction operation under which construction operation. Similarly, the construction completion program is also started to execute after the user has designated which construction matter the completion processing is to be performed on. These processing results are reflected in the existing facility management DB.

FIG. 9 is a flow chart for explaining the operation of the new closure processing in the construction equipment management program, FIG.
FIG. 10 is a diagram for explaining an example of records before and after the process shown in FIG. 9, and next, a process operation for newly establishing a closure will be described.

(1) First, it is determined whether or not the specified figure is a utility pole, and when the utility pole is specified, the shape factor number (unique ID in the map DB) of the specified figure is used to identify the existing equipment. The telephone pole table is searched and its ID is acquired. Then, the construction utility pole table is searched by that ID and the parent-child number is searched.
If there is anything other than 0, and if the parent N
If o is not 0, it is determined that the telephone pole has been removed, and the processing here is terminated (steps 901 and 902).

(2) If it is determined in step 902 that the utility pole has not been removed, the attribute input screen for the new closure is activated and various information about the new closure (closure type, etc.) is input (step 903). .

(3) Next, the currently selected construction case number is acquired from the central processing unit 3 shown in FIG. 1, the construction history table is searched by the currently selected construction case number, and if there is a hit, a hit is made. A record in which the maximum management number in the record is incremented by 1 and the operation code for the new closure operation is set is added to the construction history table (step 9).
04, 905).

(4) Management No. assigned in step 905
A record with the management flag “record added” is added to the construction closure table by using the and construction number. In addition, a record with the management flag set to “record reference” is added to the construction utility pole table using the management number and the construction case number assigned in step 905 (step 90).
6, 907).

(5) Next, draw a closure symbol on the construction closure layer, and then use the shape element number of the drawn closure symbol, the management number assigned in step 905, and the construction case number to close the construction closure. A record with a management flag of "graphic drawing" and a display color of "new color" is added to the graphic management table (step 90).
8, 909).

As a result of the above-mentioned closure new processing, FIG.
The state of the record before the new closure shown in 0 (a) is
The state of the record after the new closure is updated as shown in FIG. In FIG. 10, the equipment ID of the construction closure record to be added is acquired from the same sequence of existing equipment (a table for obtaining a unique number in the system) so as not to overlap with the existing closure record. . As a result, it is possible to avoid duplication with the record of the existing equipment table and to eliminate the need to newly acquire the equipment ID when the construction is completed. That is, the embodiments of the present invention do not use a sequence for construction planning.

FIG. 11 is a flowchart for explaining the operation of the closure new installation cancellation processing in the construction equipment management program, and FIG. 12 is a record when the closure newly installed in step 1104 of the processing shown in FIG. 11 is referred to by a cable new installation or the like. Is a diagram for explaining the state of the above, and next, the cancellation processing operation of the new closure will be described.

(1) First, it is determined whether or not the specified figure is a newly installed closure, and if it is a newly installed closure, the construction item number currently selected is acquired from the central processing unit 3 in FIG. (Steps 1101 and 1102).

(2) Next, the construction closure figure management table is searched from the shape element number of the specified new closure, and it is judged whether or not the closure is a newly installed closure in the selected construction case. If they are different, the processing here is terminated (step 1103).

(3) If it is determined in step 1103 that the newly installed closure is the selected construction item, it is checked whether or not the newly installed closure is referred to by a new cable or the like. Specifically, it is determined whether or not there is a record that refers to the corresponding record in the construction closure table, based on whether or not there is a record whose sibling number is 1. If there is a record that refers to the record, the process here is terminated (step 1
104).

(4) If it is determined in step 1104 that the newly installed closure is not referenced, the attribute information of the closure for which the new installation is to be canceled is displayed. Then, the management No. of the new construction cancellation target is acquired from the record of the construction closure table, and the selected construction case No. and management No.
Then, the record added to each table at the time of new establishment is deleted, and the processing ends (steps 1105-1109).

In FIG. 12, in step 1104 described above,
The state of the record when the newly installed closure is referred to by a new cable or the like is shown, and the equipment of the record whose brother No. is 1 refers to the newly installed closure.

FIG. 13 is a flow chart for explaining the operation of the closure removal process as an example of the removal function in the construction equipment management program, and FIG. 14 is a diagram for explaining an example of records before and after the process shown in FIG. The processing operation of closure removal will be described below.

(1) First, it is determined whether or not the designated figure is an existing closure. If it is an existing closure, the construction item number currently selected is acquired from the central processing unit 3 in FIG. 1 ( Steps 1301, 1302).

(2) Next, the existing cable connection table is searched from the specified existing closure ID to determine whether or not it is registered as the end equipment, and if there is one that is registered as the end equipment. If not, it is determined whether or not the specified closure is referred to by a new cable or the like, and if it is referred to, the processing here is ended (steps 1303 and 1304).

(3) If it is judged in step 1303 that there is one registered as the end equipment, it is checked if the connected cable has been removed by the construction operation of the selected subject, and it has been removed. If there is even one cable that does not exist, the processing here is terminated (step 1305).

(4) If all the connected cables have been removed in the check in step 1305, a "record reference" record is added to the construction cable connection table for the record having the removal information. (Step 1306).

(5) If it is determined in step 1304 that the specified closure is not referred to by a new cable or the like, or after the processing in step 1306, the closure attribute screen for removal is displayed, and in step 905 The same process as that of the case is performed to assign a management number. In this case, the operation code is a code for closure removal (steps 1307 and 1308).

(6) Next, using the management No. assigned in step 1308, a record with the management flag "record deleted" is added to the construction closure table, and then the construction closure layer is targeted for removal. A closure removal symbol is drawn at the same position as the existing closure arrangement point (steps 1309 and 1310).

(7) Using the assigned management No. and construction No., a record with the management flag "graphic deletion" and the display color "removal color" is added to the construction closure graphic management table, and the processing ends. (Step 1311).

As a result of the closure removal process described above, FIG.
The state of the record before removal of the closure shown in 4 (a) is
The state of the record after closure removal as shown in FIG. 14B is updated.

FIG. 15 is a flow chart for explaining the operation of the closure removal cancellation processing as an example of the removal cancellation function in the construction equipment management program. Next, this will be described.

(1) First, it is judged whether or not the specified figure is a removed closure, and if the removed closure is specified, the construction item number currently selected is acquired from the central processing unit 3 in FIG. (Steps 1501 and 1502).

(2) Search the construction figure management table for construction from the shape element number of the specified removal closure, determine whether the closure has been removed in the selected construction item, and remove it in the selected construction item. If it is not the closed closure, the processing here is ended (step 1503).

(3) If it is determined in step 1503 that the specified removal closure is the closure removed in the selected construction item, a confirmation screen for attribute information of the closure to be removed is displayed (step 1504). .

(4) After that, the management N of the removal cancellation target
o from the record of the construction closure table,
The record added at the time of removal to each table is deleted from the selected construction case number and management number (step 1505).
1507).

FIG. 16 is a flow chart for explaining the operation of the core wire connection / disconnection work on the closure as an example of the functions of the connection work and the disconnection work in the construction equipment management program, which will be described below. The flowchart described here is a common part of the core wire connection / disconnection work processing.

(1) First, since the facility is designated on the map, it is judged whether the facility designated on the map is a closure. If it is the closure, the selected construction item N
o is acquired (steps 1601 and 1602).

(2) Next, if the closure specified in step 1601 is an existing closure from the shape element numbers that can be acquired, the existing closure graphic management table is searched to acquire the system ID (closure ID). ,
The construction closure table is searched, and it is determined by this search whether or not the record whose management flag is "delete record" is hit, and the management flag is "delete record".
If the record with is hit, it is determined that the closure has been removed, and the processing here is terminated (step 1603).

(3) If it is determined in step 1603 that the specified closure is not a removed closure, the facility ID of the specified closure is used as a search key, and the existing closure connection table and construction closure are used. The connection table is searched, and the closure core wire connection screen in which the connection / disconnection construction status in the selected subject is added is displayed (step 1604).

(4) Next, it is judged whether or not the end button of the closure core wire connection screen is pressed, and if the end button is pressed, the processing here is ended (step 160).
5).

(5) If the end button is not pressed in the judgment of step 1605, the connection source core wire and the connection destination core wire are core wires connected by a subject other than the selected subject, or selected. It is determined by searching the connection table in the construction closure whether or not the connection information is disconnected by the subject other than the selected subject. This determination is made based on whether or not there is a record whose management flag is “record deleted”. If such a record exists, step 1
The processing from 605 is repeated (step 1606).

(6) If there is no record satisfying the condition in the judgment according to the condition of step 1606, it is judged whether or not the connection or disconnection work has already been performed with the selected subject on the selected closure, If the connection or disconnection work has not already been performed with the selected subject, the management number is assigned. This process manages each connection or disconnection work
Since the management data becomes redundant when the number is assigned, this is a process for assigning the management No. by the connection / disconnection work only once to one connection facility (closure in the example described). (Steps 1607, 1608).

(7) As described above, the management No. is connection /
Since a number is not assigned for each disconnection operation, it is necessary to group records to be added in the connection / disconnection operation for connection / disconnection cancellation processing. Therefore, if it is determined in step 1608 that the connection or disconnection work has already been performed with the selected subject, a sub-management No. is assigned to manage the operation for each connection / disconnection work in one connection facility and one selected subject. (Step 1609).

(8) Next, it is determined whether or not the construction operation performed is disconnection work. If it is not disconnection work, it is determined that it is connection work, and the processing of connection work described below is performed. Then, the process branches to processing of cutting work described later (steps 1610 to 1612).

FIG. 17 is a flow chart for explaining the processing operation of the connection construction sub-routine in the above-mentioned step 1611. Next, this will be explained.

(1) First, the connection source core wire and the connection destination core wire are
It is determined whether or not the core wire has been cut by the cutting work of the selected subject. If so, the connection work is premised on the cutting work. A record of "record reference" having the corresponding management flag of "record deletion" is added (steps 1701 and 1702).

(2) If it is determined in step 1701 that the connection source core wire and the connection destination core wire are not the core wires cut by the cutting work of the selected subject, the “record” with the same subject and the same management No. In order to determine whether or not the record of “reference” exists, and if it does not exist, in order to exclude that the cable of the connected core wire does not exist (for example, cable removal work), set the management flag corresponding to the cable connection. Add the record referred to as “record reference” to the work cable connection. It should be noted that, if it exists, the reason why the record is not added is a device for eliminating data redundancy (steps 1703 and 1704).

(3) If it is determined in step 1704 that there is no record of "record reference" with the same subject and the same management number, the connection work information is added to the connection record in the work closure. Although not described in the flow, next, a process of drawing a closure on the construction closure graphic layer with a new color is performed so that the closure on which the connection construction operation has been performed can be determined on the map. However, in the case of a newly established closure, it is not necessary to draw an image, so only a record with the management flag "record reference" is added to the construction closure graphic table. If the color is mixed with the removed color (such as cutting work described later), the new color is prioritized (step 1705).

(4) Next, it is judged whether or not the specified closure has been drawn on the construction graphic layer by checking whether or not a record with the same system ID already exists in the construction closure graphic management table. Yes (Step 1
706).

(5) If it is determined in step 1706 that the specified closure is drawn on the construction graphic layer, and the display color of the graphic is the removal color, the graphic is changed to the new color and the same color is used. The display color flag of the closure construction figure management record with the same subject and the same management number is changed to the new color, and a record with the management flag "figure reference" is added to the construction closure figure table (steps 1707, 1).
708).

(6) If it is determined in step 1706 that the specified closure is not drawn in the construction graphic layer, a record with the management flag "graphic reference" is added to the construction closure graphic table, The symbol of the designated closure is copied to the construction closure graphic layer, and the display color is changed to the new color (steps 1709 and 1710).

FIG. 18 shows step 161 of FIG. 16 described above.
3 is a flowchart for explaining the processing operation of the cutting construction subroutine in No. 1, which will be described next.

(1) First, a record with the management flag set to "record deleted" is added to the connection table within the work closure as the cutting work information, and a record with the management flag set to "figure reference" is added to the construction closure graphic table. Is added (steps 1801 and 1802).

(2) Next, it is judged whether or not a record having the same system ID already exists in the construction closure graphic management table, and if it exists, the process here is ended, otherwise. In this case, the symbol of the designated closure is copied to the construction graphic layer for construction, and its display color is changed to the removal color (steps 1803 and 180).
4).

In the processing of steps 1802 to 1804 described above, processing is performed to draw the closure on the construction closure graphic layer in the removed color so that the closure on which the cutting work has been performed can be determined on the map. If it is a closure (connect to the closure to be removed,
Note that cutting work cannot be done.) As mentioned above, when mixed with the removed color, the new color is prioritized and there is no need to print. Will only be added.

A more detailed description of the record states of the construction graphic table and the construction graphic management table will be given below.
It will be described later in the process of the graphic display process changing program.

FIGS. 19 and 20 are diagrams for explaining the transition of the record state when the connection / disconnection work for connecting the core wires is performed on the closure, which will be described below.

In the example described here, as shown in FIG. 19, each of three electric poles is provided with a closure α, β, γ, and between the closures α, β and the closure β,
A two-core cable is stretched between γ, and in the closure β, the core wire having the core wires No1 and 2 inside is connected to the cable No1 core wire and the cable No1 core wire, and the cable No2 From the state where the core wire and the No. 2 core wire of the cable are connected, the No. 2 core wire of the cable and the No. 1 core wire of the cable are connected, and the No. 1 core wire of the cable and the No. 2 core wire of the cable are connected This is an example of the case where connection / disconnection work was performed to switch to

In this case, the state of the record before the construction is shown in FIG. 19 as the state of the record before the reconnection design. Then, the record of the connection in the design closure that changes with the process of reconnection as described above,
As a record state transition at the time of designing to change the connection,
9, shown in FIG. The process of changing the connection is performed by cutting the two cores and changing the connection between the connecting cores twice.

FIG. 21 is a flowchart for explaining the operation of the core wire connection construction cancellation processing on the closure as an example of the connection construction cancellation function in the construction equipment management program. Next, this will be described.

(1) First, the same processing as the processing of steps 1601-1603 described with reference to FIG. 16 is executed (steps 1901-1903).

(2) If it is determined in step 1903 that the specified closure is not a removed closure, the construction flag in the selection case is used as a search key to search the connection in the construction closure, and the management flag is set. The record information for which "Record added" is displayed, and it is determined whether or not the end button of the connection work information screen that is being displayed is pressed,
When the end button is pressed, the processing here is ended (steps 1904, 1905).

(3) If it is determined in step 1905 that the end button has not been pressed, the connection in the construction closure is searched from the selected connection construction information, the management No. and the sub management No. are acquired, and the specified closure Checks whether there is any other connection work for the specified cable, and determines whether or not to delete the “record reference” record of the work cable connection added in the connection work process (step 1906,
1907).

(4) If it is judged in step 1907 that there is no other connection work for the specified cable in the specified closure, a record whose corresponding management flag is "record reference" from the construction cable connection table. To delete. If there is another connection work for the specified cable in the specified closure, the record of the specified connection work is deleted from the connection table in the construction closure, and the processing from step 1905 is repeated (step 1908,
1909).

FIG. 22 is a flow chart for explaining the operation of the core wire cutting work cancellation processing on the closure as an example of the cutting work cancellation function in the construction equipment management program. Next, this will be described.

(1) First, the same processing as the processing of steps 1601 to 1603 described with reference to FIG. 16 is executed (steps 2001 to 2003).

(2) If it is judged in step 2003 that the specified closure is not a removed closure, the connection in the construction closure is searched using the construction case number in the selection case as a search key, and the management flag is set. Display the record information for which "Deleted" is displayed, determine whether the end button of the cutting work information screen that is being displayed is pressed,
When the end button is pressed, the processing here is ended (steps 2004 and 2005).

(3) If it is determined in step 1005 that the end button has not been pressed, the connection within the work closure is searched from the selected disconnection work information, the management No. and sub-management No. are acquired, and the specified disconnection is performed. It is checked whether or not there is a record whose management flag is “reference record” corresponding to the construction record, and it is determined whether or not the connection construction is carried out based on the specified disconnection construction (step 2).
006, 2007).

(4) If it is judged in the step 1007 that the connection work is carried out on the premise of the specified disconnection work, an appropriate message indicating that the disconnection cannot be canceled is output, and then the process returns to step 2005. Then, the process from here is repeated. If the connection work premised on the specified disconnection work has not been performed, the record of the specified disconnection work is deleted from the connection table within the closure for work, and then the process returns to step 2005 to repeat the processing from here. (Steps 2008, 2009).

FIG. 23 is a flow chart for explaining the operation of the equipment deletion process for the closure for which the construction is planned as an example of the existing equipment management function for the equipment operated by the existing equipment management program. explain.

(1) First, it is checked whether the specified figure is a closure symbol and the shape element number is acquired. If the specified figure is a closure symbol, the acquired shape element is acquired. After the existing closure figure management table is searched by using the number as a key and the system ID (closure equipment) is acquired, the construction closure table is searched by using the system ID as a search key, and there is a closure for which a construction is planned. Or not. If there is even one record that hits, a message such as "Equipment for which construction is planned" is output and the processing here ends (steps 2101, 2102).

(2) If it is determined in step 2102 that there is no closure planned for construction, it is checked whether an existing cable is connected to the specified closure. Specifically, it is checked whether or not a record exists by using the end 1 equipment ID and the end 2 equipment ID of the existing cable connection table as search conditions. If the record exists, the processing here is terminated (step 2103).

(3) If it is determined in step 2103 that the existing cable is not connected to the specified closure, the system ID acquired in step 2102 is used as a search key to search the closure table for existing facility management, and Display the attributes and delete the specified closure record from the existing closure table (step 21).
04, 2105).

(4) Next, delete the record of the specified closure from the existing closure graphic management, and map the closure symbol specified from the closure graphic layer using the shape element number obtained in step 21-01 as a key. Deleted from the drawing (map DB) (step 21)
06, 2107).

FIG. 24 is a flow chart for explaining the main processing operation of the construction completion program, which will be described next.

(1) First, the construction case number being selected is acquired, the construction case name table is searched by using the acquired construction case number as a search key, the attribute is acquired, and the corresponding construction information is displayed on the screen ( Steps 2201 to 2203).

(2) Next, the construction history table is searched using the construction case number as a search key. This search is performed by sorting by management number because registration processing (hereinafter referred to as main registration processing) to the existing equipment DB is performed in the order in which the operation is performed here (step 2204).

(3) Next, it is judged whether or not the main registration of the construction operation to be processed is completed, and if all are registered,
The process ends. Also, if there is something that has not been registered,
The main registration processing subroutine of each construction operation is executed (steps 2205 and 2206).

FIG. 25 shows step 2206 in FIG.
10 is a flowchart for explaining the operation of the registration process of the new closure construction as an example of the registration process subroutine in FIG.

(1) When the registration process of the new closure construction work is started, first, the construction case number and management number being processed
Get the construction closure record using
The closure shape element number for construction is acquired from the construction closure graphic management table for construction using the system ID of the acquired record as a search key (steps 2301 and 230).
2).

(2) Next, the shape data of the construction closure graphic is acquired from the shape element number acquired in the process of step 2302 and copied to the existing closure graphic layer (step 2303).

(3) Then, the process of judging whether or not to delete the construction closure graphic is checked whether or not a record having the same closure ID in the subject other than the selected subject exists in the construction closure graphic management. The same closure ID in the subject other than the selected subject if
If there is no record that has "" in the construction closure graphic management, the construction closure graphic is deleted (steps 2304 and 2305).

(4) If it is determined in step 2304 that a record having the same closure ID as the subject other than the selected subject is present in the construction closure graphic management, step 2
The attribute information of the construction closure record acquired in step 301 is added to the existing closure table and copied (step 2306).

(5) Next, the construction closure record is deleted, and then the shape element number of the existing closure graphic copied in the process of step 2303 and the system ID obtained in the process of step 2301 are used. , Records are added to the existing closure graphic management table, and the processing is terminated (steps 2307 and 2308).

FIG. 26 shows step 2206 in FIG.
2 is a flow chart for explaining the operation of the registration processing of the core wire cutting work on the closure as an example of the registration processing subroutine in FIG.

(1) First, the same processing as the processing of steps 2301, 2302, 2303 and 2304 described with reference to FIG. 25 is executed (steps 2401 to 2403 and 2).
405).

(2) If it is determined in step 2403 that a record having the same closure ID as the subject other than the selected subject exists in the construction closure graphic management, the construction case No. and management No. to be processed are search keys. As a result, the construction in-closure connection record of the disconnection construction information is acquired, and the record acquired from the existing in-closure connection record is deleted (steps 2404 and 2406).

(3) Next, the line connection ID is acquired from the connection (original) core wire information of the record acquired in step 2404, and the existing line connection record is acquired using the line connection ID as a search key. In this case, as the acquired line connection information, the end equipment I in consideration of the connection of the cut core wires is used.
D can be obtained. Assuming that the end equipment IDs are A and B respectively for the start end and the end and the ID of the closure for which the connection work is performed is C, the end equipment of the acquired line connection record is
A and C are set, and the end equipment of the line connection record to be newly added is set to C and B, so that a line connection record to be newly added is generated (step 2407).

(4) Next, the processing for acquiring the core wire whose line connection ID is updated (by the added line connection ID) is performed.
Specifically, it is carried out by handing the existing cable core wire record to the end equipment B side from the end equipment C in consideration of connection information in the middle of the closure (step 2408).

(5) The line connection ID added to the line connection ID of the cable core wire record acquired in the above process is updated, and the connection record in the construction closure acquired in the process of step 2404 is deleted and processed. Ends (steps 2409 and 2410).

27 and 28 are views for explaining an example of the state of the records managed in the construction figure management table. Next, this will be described.

Normally, only one color can be displayed for the same equipment symbol on the drawing, so even if the same figure is drawn on the construction figure layer, it is only redundant. Therefore, according to the embodiment of the present invention, the graphic having the same system ID is drawn only once in the construction graphic layer.
As described in the above-described core wire connecting / disconnecting construction operation, in the embodiment of the present invention, in the core wire connecting construction operation and the like, a construction figure is drawn in order to express the construction operation on the drawing. In addition, the embodiment of the present invention differs from the selected subject in that the construction operation is not performed with the selected subject and the construction operation is performed with other than the selected subject (hereinafter referred to as other matter). It is supposed to be displayed in color (hereinafter referred to as other case new color and other case removed color). In that case, the new color has priority.

27 and 28 show, by way of example, a closure as to what state exists in the construction figure management table. In these figures, XXX indicates the equipment number of the existing equipment, and YYY indicates the equipment number of the removal equipment. When the above-described core wire connection / disconnection work operation is performed, the equipment The display color of the equipment figure is changed by changing the display attribute. Then, in this case, when the new color and the removed color are mixed, the new color is prioritized.

FIG. 29 is a flow chart for explaining the processing operation of the display attribute change processing program, which will be described next.

(1) First, the construction case number being selected is acquired, and the figure of the construction figure layer to be displayed on the screen is sequentially searched using the figure data display processing program 18 to display the figure. To do. Then, it is determined whether or not the display change process (display position change process) described later has been completed for all the searched and displayed figures, and if there is no display color change target, the process ends (step 260).
1-2603).

(2) The construction figure management table corresponding to the layer to be processed is searched by using the shape element number as a search key, and it is determined whether or not the record of the selected subject exists in the records hit in the search ( Steps 2604, 260
5).

(3) If the record of the selected subject does not exist in the judgment of step 2605, it is judged whether or not the record having the new color is displayed in the records hit in the search. Figure 1 shows the display colors of the graphics to be processed.
The graphic data display processing program 18 is used to change the removal color of another case. After that, the process returns to step 2603 and the process from here is repeated (step 260).
6, 2608).

(4) If it is determined in step 2606 that there is no record with the new display color in the record hit in the search, the display color of the processing target graphic is changed to the graphic data display processing program of FIG. Use 18 to change to another new color. After that, the process returns to the step 2603 and the process from here is repeated (step 2609).

(5) If the record of the selected subject exists in the judgment in step 2605, it is judged whether or not the record of the selected subject of the search result has a new display color, and the record exists. Then, the display color of the graphic to be processed is changed to the new color of the case using the graphic data display processing program 18 of FIG. Then, step 2603
Then, the process from here is repeated (steps 2607 and 2610).

(6) If it is determined in step 2607 that there is no record whose display color is the new color in the record of the selected subject of the search result, the display color of the figure to be processed is changed to that shown in FIG. The figure data display processing program 18 is used to change to the removal color of the case (step 2611).

The various processes in the above-described embodiments of the present invention can be performed by executing each process program as described above, and the process programs are HD, DAT, FD, MO, CD. -It can be provided by being stored in a recording medium such as a ROM.

According to the above-described embodiment of the present invention, the management items of the existing equipment include "Construction No.", "Management No.", "Sub Management No.", "Parent-Child No.", "Sibling No.", and "Management Flag". By adding a table (construction equipment management table) to which items "display color" are added, and adding a graphic layer for construction to the map DB, it is difficult to manage because the management targets have been complicatedly related to each other. It is possible to systematically manage the construction plan information that was previously.

Further, according to the above-described embodiment of the present invention, the construction plan is extracted from the construction history table, the construction facility management table, and the construction graphic layer to manage the construction plan for the existing facility. It becomes possible to provide the function of registering in the DB.

The embodiments of the invention described above are standard G
Can be incorporated into IS. That is, the map DB 6, the graphic data display processing program 18, the display attribute change processing program 1 in the system according to the present invention shown in FIG.
The nine functions can be made to perform those functions of the standard GIS.

With such a configuration, the construction plan can be changed for each construction subject and represented on the map only by assuming the graphic data display processing program included in the standard GIS. Becomes

[0138]

As described above, according to the present invention,
It is possible to systematically manage data related to a construction plan of a communication network having a variety of facilities whose management targets are complicatedly related to each other.

[Brief description of drawings]

FIG. 1 is a block diagram showing a configuration of a data management system for a communication network construction plan according to an embodiment of the present invention.

FIG. 2 is a diagram illustrating a relationship between existing facility management data in an existing facility management DB in FIG.

FIG. 3 is a diagram illustrating a concept of examining what history a minimum unit of data has according to a construction plan.

FIG. 4 is a diagram illustrating an index for managing data update and new installation without causing data inconsistency.

FIG. 5 is a diagram expressing flags of parent-child No. and brother No. by applying the indexes shown in FIG. 4 to each case of FIG.

FIG. 6 is a “management flag” managed in the construction facility attribute management table and the construction facility graphic attribute management table;
It is a figure explaining "display color".

FIG. 7 is a diagram illustrating a relationship between construction facility data in a construction facility management DB corresponding to the existing facility management data described in FIG.

FIG. 8 is a diagram illustrating the functions of a construction facility management program and a construction completion program.

FIG. 9 is a flowchart illustrating the operation of a new closure process in the construction facility management program.

10 is a diagram illustrating an example of records before and after the process illustrated in FIG.

FIG. 11 is a flowchart illustrating an operation of closure new installation cancellation processing in the construction equipment management program.

FIG. 12 is a diagram illustrating a state of a record when a closure newly installed in the processing shown in FIG. 11 is referred to by a cable new installation or the like.

FIG. 13 is a flowchart illustrating an operation of closure removal processing as an example of a removal function in a construction facility management program.

14 is a diagram illustrating an example of records before and after the processing illustrated in FIG.

FIG. 15 is a flowchart illustrating the operation of closure removal cancellation processing as an example of the removal cancellation function in the construction equipment management program.

[Fig. 16] Core wire connection on the closure as an example of the functions of connection work and disconnection work in the construction equipment management program
It is a flow chart explaining operation of cutting construction processing.

FIG. 17 is a flowchart illustrating a processing operation of a connection construction subroutine.

FIG. 18 is a flowchart illustrating a processing operation of a cutting work subroutine.

FIG. 19 is a diagram (No. 1) for explaining the transition of the record state when the connection / disconnection work for connecting the core wires is performed on the closure.

FIG. 20 is a diagram (No. 2) for explaining the transition of the record state when the connection / disconnection work for connecting the core wires is performed on the closure.

FIG. 21 is a flowchart illustrating an operation of a core wire connection construction cancellation process on a closure as an example of a connection construction cancellation function in the construction equipment management program.

FIG. 22 is a flowchart illustrating an operation of a core wire cutting work canceling process on a closure as an example of a cutting work canceling function in a construction facility management program.

FIG. 23 is a flowchart illustrating an operation of equipment deletion processing for a closure for which a construction plan has been performed, which is an example of an existing equipment management function for equipment that has been construction-operated by an existing equipment management program.

FIG. 24 is a flowchart illustrating main processing operations of a construction completion program.

25 is a flowchart illustrating an operation of registration processing for closure new construction as an example of the registration processing subroutine of FIG. 24.

FIG. 26 is a flowchart illustrating an operation of registration processing for core cutting work on a closure as an example of the registration processing subroutine of FIG. 24.

FIG. 27 is a diagram (part 1) explaining an example of the state of records managed in the construction figure management table.

FIG. 28 is a diagram (part 2) explaining an example of the state of records managed in the construction figure management table.

FIG. 29 is a flowchart illustrating a processing operation of a display attribute change processing program.

[Explanation of symbols]

1 display 2 keyboard device 3 Central processing unit 4 Existing equipment management database (DB) 5 Construction equipment management DB 6 map DB 7 Existing facility management program 8 construction completion program 9 Construction equipment management program 10 Existing attribute management table 11 Existing graphic attribute link table 12 Existing figure layer 13 Construction equipment attribute management table 14 Facility graphic attribute link table for construction 15 Construction figure layer 16 Construction subject table 17 Construction history table 18 Graphic data display processing program 19 Display attribute change processing program

Claims (8)

[Claims] 1. A data management method for construction plan management, comprising an existing equipment management database and a construction equipment management database, which are managed by an existing equipment attribute management table in the existing equipment management database. ,
"Construction No.", "Management No.", "Sub Management No.",
"Parent-child No.", "Sibling No.", "Management flag", "Display color" items are added, and these are managed in the equipment attribute management table for construction planning in the construction equipment management database. Key items in the existing equipment attribute management table as key items in the equipment attribute management table for
"Construction No.", "Management No.", "Sub Management N"
“O”, “parent-child No.”, and “sibling No.” are used to generate a history of existing equipment information that is changed by the construction plan or a history of new construction equipment information based on the key items. A data management method characterized by going. 2. The construction plan is a construction plan for existing equipment,
2. The data management method according to claim 1, wherein the data is a construction plan for new construction or cancellation of the construction plan, and the construction plan is registered in the existing facility database upon completion of the construction. 3. The data is extracted from the graphic attribute link information for construction in the construction equipment management database, and the information of the construction plan different depending on the construction specified in one of the construction plans is displayed on the display screen. The data management method according to claim 2. 4. The “construction case number” is an ID that is managed as a group of constructions when planning the construction, and the “management No” is a serial number of each construction operation that occurred in the designated construction case number, and the “ "Sub management No." is a management No. for grouping a plurality of construction operations, and "Parent-Child No." is an item numbered when the construction plan updates the key items of the records in the table. The above "Brother N
“O” is a flag indicating that the key item of the record is referred to by the construction plan, and the “management flag” is record addition and deletion indicating the processing content when the construction plan is completed and registered as existing equipment. , Record update, record reference, graphic drawing, graphic deletion, graphic reference flags,
4. The data management method according to claim 1, wherein the "display color" is each flag of a new color and a removal color used for expressing the construction plan on the screen. 5. A data management system for construction plan management, comprising an existing equipment management database, a construction equipment management database, and a central processing unit, wherein the existing equipment management database includes an existing equipment attribute management table,
The existing facility graphic attribute link table is provided, and the construction facility management database includes a construction facility attribute management table, a construction facility graphic attribute link table, a construction subject table, and a construction history table. The processing device has an existing equipment management program, a construction equipment management program, a construction completion program, and a display attribute change processing program, and the construction equipment management program is an item managed by the existing equipment attribute management table. To
"Construction No.", "Management No.", "Sub Management No.",
"Parent-child No.", "Sibling No.", "Management flag", "Display color" items are added, and these are managed in the construction plan equipment attribute management table, and the construction planning equipment. As the key item of the attribute management table, the key item in the existing equipment attribute management table and the “Construction N”
o ”,“ Management No ”,“ Sub Management No ”,“ Parent-Child N ”
“O” and “brother No.”, and a means for generating a history of existing facility information changed by the construction plan or a history of new construction facility information based on the key item. Characteristic data management system. 6. The construction equipment management program further plans to construct new equipment by construction (hereinafter,
A means for managing "new construction", a means for managing a plan for removing existing equipment by construction (hereinafter referred to as "removal"), and a means for canceling a plan for constructing new equipment by construction (hereinafter , "New construction cancellation"), means for canceling a plan to remove existing equipment by construction (hereinafter called "removal cancellation"), and means for managing a plan for newly connecting equipment by construction (hereinafter " ,
Cancels the "connection work") and the means for managing the plan to disconnect the existing connected equipment by the construction (hereinafter referred to as "disconnection work") and the plan for newly connecting the equipment by the construction. 6. The apparatus according to claim 5, further comprising means (hereinafter referred to as “connection work cancellation”) and means for canceling an existing plan to disconnect the connected equipment (hereinafter referred to as “disconnection work cancellation”). Described data management system. 7. The construction completion program comprises means for extracting a construction plan planned by the construction equipment management program from a construction equipment management database, and means for registering the extracted construction completion construction plan in an existing equipment management database. 7. The data management method according to claim 5, further comprising means for deleting the construction plan from the construction equipment management database. 8. The display attribute change processing program, on the display, means for extracting graphic display color information from the construction equipment management database in order to express the construction plan planned by the construction equipment management program on the screen. 8. The data management system according to claim 5, 6 or 7, further comprising: means for changing the figure color.