JP2010237957A - System, method and program for obtaining range of influence - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a system for obtaining the range of influence of a communication network such as an optical fiber, which can be operated even by a person who does not have special knowledge, and which is suitable for a response to a disaster. <P>SOLUTION: The system for obtaining the range of influence, specifies the range of influence when a communication facility installed in a communication network such as an optical fiber is stopped. The system is provided with: a plurality of databases for storing information on the communication network; a capturing means for capturing information on the communication network from the plurality of databases; a retrieval object table generation means for extracting a plurality of information for specifying the range of influence from the captured information, and for generating a retrieval object table by associating the plurality of extracted information with each other; a retrieval condition input means for accepting the input of retrieval condition information for retrieving the generated retrieval object table; a retrieval means for specifying the range of influence by retrieving the retrieval object table on the basis of the input retrieval condition information; and a retrieval result output means for outputting the retrieval result information related to the specified range of influence. <P>COPYRIGHT: (C)2011,JPO&INPIT

Description

  The present invention relates to a system for grasping an influence range when communication equipment installed in a communication network is stopped in a communication network such as an optical fiber.

  In maintenance work for optical fiber and other communication networks, when updating or adding new communication equipment, the communication equipment installed in the communication network must be stopped and the communication lines in a specific range must be temporarily stopped. It may not be. If the communication line is stopped, social disruption occurs. Therefore, it is necessary to list the affected users in advance and contact them without omission. In addition, for important institutions that cannot stop communication, such as police and hospitals, it is necessary to prepare a detour in advance and perform work on communication facilities. Furthermore, even if it is not necessary to stop the line, it is necessary to predict the affected range in the unlikely event. Thus, in the maintenance work of the communication network, it is extremely important to accurately predict the range of influence when the communication equipment installed in the communication network is stopped.

  In addition, communication facilities such as cables and closures may be damaged by natural disasters such as typhoons. When a power outage due to a typhoon is prolonged, the entire station may be out of power. In this situation, when a failure notification is received from the user, it is necessary to quickly determine the location of the failure by comparing the location that is operating normally and the location where communication is stopped. Then, it is necessary to predict the range where the disaster is likely to be affected from the failure location, and to perform quick recovery work after passing the typhoon.

  Conventionally, when a communication facility is stopped in maintenance work as described above, or an influence range is predicted when a failure occurs in a communication facility, it has been performed based on existing printed drawings such as a network diagram. Further, it has been performed to search a database such as contract information and line device accommodation information, or to issue a PING and determine the presence or absence of a line based on the response of the device.

  On the other hand, as an invention for quickly identifying a failure occurrence site in an optical cable network, Patent Document 1 provides a database storing information indicating the length of each optical cable, information on a relay facility, etc. An invention relating to an information processing apparatus is described in which a fault occurrence site is specified by measuring and inputting an optical cable length to a point.

JP 2007-166505 A

  However, telecommunications carriers are expanding their networks as the area expands, and there are customers who cancel their contracts while there are new subscribers. It is changing every moment. Therefore, it is impossible to accurately predict the range of influence by the printed drawing.

  In addition, in order to search a database such as contract information and line device accommodation information, or to issue a PING and determine the presence or absence of a line based on the response of the device, expertise in database operation and communication equipment is required. Because it is necessary, only a professional engineer such as a system designer can do it. For example, it is impossible for a shift operator who has only general knowledge who happened to work on duty during a disaster to predict a wide range of effects in a short time.

  On the other hand, database systems such as contract information and line device accommodation information are usually accommodated in data centers. The data center is located in an earthquake-resistant building and operates 24 hours a day, 365 days a year, in an area where safety measures and security are sufficiently secured. On the other hand, the disaster countermeasure headquarters installed at the time of a disaster is usually installed in a general building, and is connected to the data center through a communication line. Therefore, even if the data center does not have a power outage at the time of a disaster, the disaster response headquarters may have a power outage. In addition, it must be assumed that the power outage around the building where the disaster response headquarters is located and the line on the way is cut off. In such a case, a generator is operated in the building where the disaster countermeasure headquarters is installed, and disaster countermeasures are negotiated using a personal computer without relying on a communication line, and a database housed in a data center. There is no way to search.

  The present invention solves the above-described conventional problems. In a communication network such as an optical fiber, when grasping an influence range when a communication facility installed in the communication network is stopped, the operation of the database and the communication facility are performed. It is possible to provide an impact range grasping system, an impact range grasping method, and an impact range grasping program that can be operated even by a person who does not have specialized knowledge about the above and is suitable for disaster response.

  The influence range grasping system of the invention according to claim 1 is an influence range grasping system for specifying an influence range when communication equipment installed in a communication network such as an optical fiber is stopped, and stores information related to the communication network. A plurality of databases; a capturing unit that captures information about the communication network from the plurality of databases; and a plurality of pieces of information for identifying the influence range are extracted from the captured information, and the plurality of pieces of extracted information are associated with each other Search target table generating means for generating a search target table, search condition input means for receiving input of search condition information for searching for the generated search target table, and based on the input search condition information, Search means for searching the search target table to identify the affected range, and search results relating to the identified affected range. Characterized by comprising a search result output means for outputting information.

  The invention according to claim 2 is the influence range grasping system according to claim 1, wherein the fetching unit periodically fetches information on the communication network from the plurality of databases, and the search target table generating unit includes: The search target table is generated in accordance with the information fetching by the fetching means.

  According to a third aspect of the present invention, in the influence range grasping system according to the first or second aspect, a backup of the generated search target table is created.

  The influence range grasping method of the invention according to claim 4 is an influence range grasping method for specifying an influence range when communication equipment installed in a communication network such as an optical fiber is stopped, and stores information related to the communication network. A step of taking in information related to the communication network from a plurality of databases, and extracting a plurality of pieces of information for specifying the influence range from the taken-in information, and associating the plurality of pieces of extracted information with each other to create a search target table A search target table generation step for generating, a search condition input step for accepting input of search condition information for searching the generated search target table, and searching the search target table based on the input search condition information And a search step for specifying the influence range, and search result information relating to the specified influence range is output. Characterized by comprising a search result output step.

  The influence range grasping program of the invention according to claim 5 includes a plurality of information on the communication network stored in an influence range grasping system for specifying an influence range when a communication facility installed in a communication network such as an optical fiber is stopped. A step of taking in information related to the communication network from the database, and extracting a plurality of pieces of information for specifying the influence range from the taken-in information, and generating a search target table by associating the extracted pieces of information with each other A search target table generation step, a search condition input step for receiving input of search condition information for searching the generated search target table, and searching the search target table based on the input search condition information A search step for specifying the influence range, and search result information relating to the specified influence range are output. It is intended for executing a search result output step that.

  According to the present invention, in order to specify the range of influence when communication equipment installed in a communication network such as an optical fiber is stopped, information is acquired from a plurality of databases storing information related to the communication network. Can be collected.

  In addition, it extracts multiple pieces of information to identify the affected area from the captured information, and creates a search target table by associating the extracted pieces of information with each other, making it easy to use a specially created table for search. In addition, the range of influence can be identified efficiently.

  Also, if the operator inputs search condition information for searching the search target table, the search target table is searched based on the input search condition information, and search result information related to the specified influence range is output. It can also be performed by those who do not have specialized knowledge of database operations or communication facilities.

  In addition, information about communication networks from a plurality of databases is periodically fetched, and a search target table is generated according to the information fetch. Therefore, there is already a search target table to be searched when searching, There is no need to generate a search target table for each search, and the search speed can be secured. Furthermore, it is not affected by the shutdown of the existing database.

  In addition, by creating a backup of the generated search target table, even if the system goes down at the time of failure, the affected range can be specified using the backup search target table.

  As described above, according to the present invention, an influence range grasping system, an influence range grasping method, which can be operated even by a person who does not have specialized knowledge about database operations and communication facilities, and is suitable for dealing with disasters, and An impact range assessment program can be provided.

It is a whole block diagram of the influence range grasping system concerning this embodiment. It is a figure which shows the information management object of the influence range grasping | ascertainment system which concerns on this embodiment. It is a lineblock diagram of the server for search concerning this embodiment, and an operation terminal. It is a block diagram of the database which concerns on this embodiment. It is a figure which shows a search object table. It is a figure which shows line | wire DB. It is a figure which shows contractor DB. It is a figure which shows mail DB. It is a figure which shows WebDB. It is a figure which shows FTTH connection information. It is a figure which shows accommodation station apparatus information. It is a figure which shows charge course information. It is a figure which shows reservation construction information. It is a figure which shows accommodation station information. It is a figure which shows drawing-in connection apparatus information. It is a figure which shows drawing-in information. It is a figure which shows application reception information. It is a figure which shows IP telephone contract information. It is a figure which shows option information. It is a data related figure which shows the relationship between a search object table and each data. It is a flowchart which shows the production | generation process of a search object table. It is a flowchart which shows the search process of an influence range.

  With reference to FIG. 1 thru | or FIG. 22, the influence range grasping | ascertainment system which concerns on embodiment of this invention is demonstrated. The influence range grasping system according to the present embodiment is a system for specifying an influence range when communication equipment installed in a communication network such as an optical fiber is stopped, and FIG. 1 is an overall configuration diagram thereof. The influence range grasping system according to this embodiment includes a search server (production system) 1, a database server 2, a network 3, an operation terminal 4, and a search server (standby system) 5.

  The search server (production system) 1 is connected to the database server 2 via the network 3 and takes in information related to a communication network such as an optical fiber from the database server 2. Then, a plurality of pieces of information for specifying the range of influence when the communication facility is stopped is extracted from the acquired information, and the plurality of pieces of extracted information are associated with each other to generate a search target table.

  The database server 2 has a plurality of databases and stores information related to various communication networks. Although one database server 2 is shown in FIG. 1, the database server 2 may be installed in a plurality of locations.

  The operation terminal 4 is connected to the search server 1 via the network 3, receives input of search condition information for searching the search target table generated by the search server 1, and transmits it to the search server 1. When the search server 1 performs a search based on the search condition information and specifies the influence range, the search result information related to the specified influence range is received and output.

  In the search server (standby system) 5, the search target table generated by the search server (production system) 1 is backed up. The search server 5 stores the same search program as the search server 1 in advance. When the search server 1 fails, the search server 5 is connected to the search server 5 from the operation terminal 4 so It is possible to specify. The search server 5 is not necessarily required, but it is preferable to provide it in preparation for a failure of the search server 1.

  Next, with reference to FIG. 2, an information management target of the influence range grasping system according to the present embodiment will be described. In this embodiment, a communication network such as an optical fiber is configured by an Internet network, a telephone network, a VLAN network, an FTTH broadcast relay network, a BOX, a WDM, a coupler, and a subscriber, as shown in FIG. Among these, the information management targets are the data communication line, voice communication line, SC, BOX, accommodating station apparatus OSW, accommodating station apparatus PON, broadcast amplifier, and subscriber surrounded by the double line in FIG. It is.

  Next, the configuration of the search server 1, the operation terminal 4, and the search server 5 according to the present embodiment will be described with reference to FIG. Note that the search server 1, the operation terminal 4, and the search server 5 are all computers, and the basic hardware configuration is the same. Here, the search server 1 will be described first.

  The search server 1 includes a CPU 11, a memory 12, an input device 13, an output device 14, a transmission / reception device 15, a storage device 16, and a recording medium reading device 17. The CPU 11 controls the entire search server 1 and reads a program stored in the storage device 16 into the memory 12 and executes it.

  The input device 13 and the output device 14 are for inputting / outputting information from / to the outside. The transmission / reception device 15 is for transmitting / receiving information to / from the outside via the network 3. The storage device 16 stores a program executed by the CPU 11, information related to a communication network fetched from the database server 2, a generated search target table, search condition information transmitted from the operation terminal 2, and specified Search result information relating to the influence range is also stored.

  The recording medium reading device 17 reads the recording medium 18 on which various types of information are recorded. The program executed by the CPU 11 is recorded on the recording medium 18 and then read and executed by the recording medium reading device 17. You may do it. Further, the information may be imported from the database server 2 via the recording medium 18 without via the network 3.

  With the above configuration, the search server 1 records information about the communication network by the cooperation of the CPU 11, the memory 12, the input device 13, the output device 14, the transmission / reception device 15, the storage device 16, and the recording medium reading device 17. "Fetching means" for fetching information from a plurality of databases, "Search target table creating means" for extracting a plurality of information for specifying the influence range from the fetched information and generating a search target table in association with each other, and input It functions as a “search means” that searches the search target table based on the search condition information thus specified to identify the affected range.

  The operation terminal 4 has the same hardware configuration, and the CPU 11, the memory 12, the input device 13, the output device 14, the transmission / reception device 15, the storage device 16, and the recording medium reading device 17 cooperate to operate the operation terminal 4. Functions as a “search condition input unit” that receives input of search condition information for searching the search target table, and a “search result output unit” that outputs search result information regarding the specified influence range.

  The search server 5 has the same hardware configuration and functions in the same manner as the search server 1.

  In the present embodiment, the search target table is searched on the search server 1 side. However, for example, the generated search target table and the search program are stored in the operation terminal 4, and the search target table is searched. It may be performed on the operation terminal 4 side. With such a configuration, even if the system goes down in the event of a failure, the influence range can be specified on the personal computer, for example, without using the network 3, using the stored search target table and search program. it can.

  On the other hand, in the present embodiment, the search condition information is input and the search result information is output on the operation terminal 4 side. However, these inputs and outputs may be performed on the search server 1 side. With such a configuration, the influence range can be specified on the personal computer, for example, without using the network 3.

  Next, the configuration of the database according to the present embodiment will be described with reference to FIGS. FIG. 4 is a configuration diagram of a database according to the present embodiment, and shows a state in which the system takes in information related to a communication network from a plurality of databases stored in the database server 2 and generates a search target table 100. Yes.

  As shown in FIG. 5, the search target table 100 includes a plurality of pieces of information such as a reception number, a data communication line, a data communication line port, etc., and the plurality of pieces of information are associated with each other and generated. . For example, when “BOX station” is selected and input as a search key (search condition), information associated with the input BOX station is presented. Thereby, when the communication equipment of the input BOX station stops, it is possible to identify the affected route, the subscriber, the service content, etc., and grasp the affected range.

  In order to generate the search target table 100, as shown in FIG. 4, the database server 2 is accessed and the line DB 201, the contractor DB 202, the mail DB 203, the Web DB 204, the FTTH connection information 205, the accommodation station device information 206, the fee course Imports information related to the communication network from a plurality of databases such as information 207, reservation work information 208, accommodation station information 209, service connection device information 210, service information 211, application reception information 212, IP telephone contract information 213, and option information 214 To do.

  The information stored in each database is as shown in FIGS. 6 to 19, but the information related to the communication network here includes not only information related to hardware such as the accommodation station device information 206 but also fee course information 207. Information on the contract with the user such as, and information on maintenance work such as the reservation work information 208 are also included.

  In the influence range grasping system according to the present embodiment, after fetching information related to the communication network from the plurality of databases, a plurality of pieces of information for specifying the influence range are extracted from the taken pieces of information, and the extracted pieces of information are mutually connected. The search target table 100 is generated in association with each other. FIG. 20 is a data relation diagram showing the relation between the information stored in the plurality of databases and each data of the search target table 100. As shown in FIG. 20, the search target table 100 is specially created by extracting only the information for search from a plurality of databases, and thus has a structure that is easy to handle and suitable for search.

  Next, the generation process of the search target table 100 will be described with reference to the flowchart of FIG. In addition, it is preferable to perform this process regularly, such as daily. In particular, it is preferable to use a time schedule in the middle of the night when access to a database such as the contractor DB is reduced, for example, at midnight.

  First, the search server 1 accesses the database server 2 via the network 3 and each database 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, Information 214 is fetched (step S101).

  Next, the search server 1 extracts a plurality of pieces of information necessary for generating the search target table 100, which are determined in advance, from the fetched information (step S102).

  Next, the search server 1 generates a search target table 100 by associating a plurality of extracted information with each other (step S103).

  Next, the search server 1 connects to the search server 5 via the communication network 3, creates a backup of the generated search target table 100 (step S104), and ends the process.

  Next, the influence range search process will be described with reference to the flowchart of FIG.

  First, the operation terminal 4 receives input of search condition information for searching the search target table 100, and transmits it to the search server 1 via the network 3 (step S201).

  Next, the search server 1 searches the search target table 100 based on the received search condition information to identify the affected range, and sends search result information regarding the identified affected range to the operation terminal 4 via the network 3. Transmit (step S202).

  Next, the operation terminal 4 outputs the received search result information (step S203) and ends the process.

  Since the influence range grasping system according to the present embodiment is configured as described above, the following operational effects can be obtained.

  A plurality of databases 201, 202, 203, 204, 205, 206, 207, 208, 209 storing information related to the communication network in order to specify the influence range when the communication equipment installed in the optical fiber communication network is stopped. , 210, 211, 212, 213, and 214, information can be collected from a wide range.

  In addition, a plurality of pieces of information for identifying the influence range are extracted from the captured information, and the search target table 100 is generated by associating the plurality of pieces of extracted information with each other, thereby using a specially created table for search. The range of influence can be specified easily and efficiently.

  If the operator inputs search condition information for searching the search target table 100, the search target table 100 is searched based on the input search condition information, and search result information related to the specified influence range is output. Therefore, it can also be executed by those who do not have specialized knowledge about database operations and communication facilities.

  In addition, information on the communication network from a plurality of databases 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214 is periodically taken in, so that information Since the search target table 100 is generated in response to the import of the search target table 100, there is already a search target table 100 to be searched at the time of search, and it is not necessary to generate the search target table 100 for each search, ensuring the search speed. can do. Furthermore, the existing database 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214 is not affected by the suspension.

  Further, by creating a backup of the generated search target table 100, even if the system goes down at the time of failure, the affected range can be specified on the personal computer, for example, using the backup search target table 100. .

  As described above, the influence range grasping system according to the present embodiment can be operated by a person who does not have specialized knowledge about database operations and communication facilities, and is also suitable for dealing with disasters.

  When the influence range grasping system according to the present embodiment is used, it is possible to accurately predict the range that is affected when a specific line is stopped. Accordingly, it is possible to give accurate guidance to the communication line user before the maintenance work of the communication network, and avoid confusion. In addition, when a communication cable is disconnected in the event of a disaster such as a typhoon, the affected area can be predicted and a quick response can be made. Conversely, the failure location can be detected by a report from the communication line user.

  Even if a building other than the data center fails due to a serious disaster such as a severe typhoon, and the disaster response headquarters is operated by private power generation, search data is stored inside the impact assessment system. Since the data is held, the affected range can be predicted using the held data without accessing the data center.

1 Search server (production system)
2 Database server 3 Network 4 Operation terminal 5 Search server (standby system)
11 CPU
DESCRIPTION OF SYMBOLS 12 Memory 13 Input device 14 Output device 15 Transmission / reception device 16 Storage device 17 Recording medium reader 18 Recording medium 100 Search object table 201 Line DB
202 Contractor DB
203 Mail DB
204 WebDB
205 FTTH connection information 206 accommodation station device information 207 fee device information 208 reservation work information 209 accommodation station information 210 service connection device information 211 service information 212 application reception information 213 IP telephone contract information 214 option information

Claims (5)

An influence range grasping system for identifying an influence range when a communication facility installed in a communication network such as an optical fiber is stopped,
A plurality of databases storing information on the communication network;
Capture means for capturing information about the communication network from the plurality of databases;
Search target table generating means for extracting a plurality of information for specifying the influence range from the captured information, and generating a search target table by associating the extracted plurality of information with each other;
Search condition input means for receiving input of search condition information for searching the generated search target table;
Search means for searching the search target table and identifying the influence range based on the input search condition information;
Search result output means for outputting search result information relating to the specified influence range;
An impact range grasping system characterized by having   The fetching unit periodically fetches information about the communication network from the plurality of databases, and the search target table generating unit generates the search target table in response to the fetching of information of the fetching unit. The influence range grasping system according to claim 1 characterized by things.   3. The influence range grasping system according to claim 1, wherein a backup of the generated search target table is created. An influence range grasping method for identifying an influence range when a communication facility installed in a communication network such as an optical fiber is stopped,
A step of taking in information related to the communication network from a plurality of databases storing information related to the communication network;
A search target table generating step of extracting a plurality of information for specifying the influence range from the captured information, and generating a search target table by associating the extracted plurality of information with each other;
A search condition input step for receiving input of search condition information for searching the generated search target table;
A search step of searching the search target table and identifying the influence range based on the input search condition information;
A search result output step of outputting search result information relating to the identified influence range;
An impact range grasping method characterized by comprising To the impact range grasping system to identify the impact range when the communication equipment installed in the communication network such as optical fiber is stopped,
A step of taking in information related to the communication network from a plurality of databases storing information related to the communication network;
A search target table generating step of extracting a plurality of information for specifying the influence range from the captured information, and generating a search target table by associating the extracted plurality of information with each other;
A search condition input step for receiving input of search condition information for searching the generated search target table;
A search step of searching the search target table and identifying the influence range based on the input search condition information;
A search result output step of outputting search result information relating to the identified influence range;
A program for grasping the scope of influence to execute

Images