KR0128838B1 - Data base management system - Google Patents

Abstract

Disclosed is a method to automatically generate a data related to the cable layout database. The method comprises 4 steps. In the first step, the operation environment is set, the remark on the cable layout diagram is automatically erased, the diagram is arranged and converted into a raceway diagram. In the second step, the temporarily diagram is arranged by loading the software and removing the residual image in the erased files. In the third step, the raceway diagram file to be actually used is generated. In the fourth step, a file list is generated to arrange the diagrams which has been converted, the line format of the converted diagram is converted into that of the raceway diagram. In the fifth step, the environmental data related to changing are removed. Thereby, the graphic and non-graphic data are automatically generated so that the time of the establishing database is saved and the data reliability is improved.

Description

Automatic creation of data related to the pipeline diagram database

1 is a flowchart illustrating a method for automatically generating pipeline-related database (DB) related data according to the present invention.

The present invention relates to a method for constructing a track facility management system (TOMS) database used in a telephone station or the like, and to a method for automatically generating a pipeline diagram database-related data for automatically generating data necessary for creating a pipeline diagram database.

In general, a telephone company is constructing and utilizing a database for managing track facilities in the area under the jurisdiction of the telephone station. When constructing such a database, a database of a cable diagram and a pipeline diagram should be constructed. Conventionally, although there are a lot of common data which is transferred by the transferor, since the database is separately constructed, work efficiency due to the database construction is low. That is, the graphic data and the non-graphic data input at the time of constructing the city cable are not utilized at the time of constructing the pipeline and the database, and thus there is a problem that the work efficiency due to the database construction is significantly reduced.

Accordingly, the present invention has been made in order to solve the problems of the prior art, the pipeline diagram for converting the graphic and non-graphic data of the underground cable diagram portion of the city cable network during the construction of the track facility management database to automatically generate the data of the pipeline diagram The purpose is to provide a method for automatically generating database-related data.

In order to achieve the above object, the present invention provides a method for establishing a track facility management database under a computer hardware environment. A first step of generating a temporary drawing for converting the path into a pipeline; Load the software for the construction and management of the track facility diagram into memory, and delete the annotations of the track facilities created in the facility chart for the track facility management system with the program at the same time, and remove the residual images of the deleted files. A second step of organizing the drawings; A third step of generating a pipeline diagram file that can be actually used by using a file completed in a drawing preparation process after preparing a drawing conversion for generating a pipeline diagram from an existing cable diagram; A fourth step of generating a file list for organizing the converted drawings, changing the line form of the converted drawing into the line form of the pipeline diagram, deleting the temporarily created drawings for conversion and renaming the converted drawings; And a fifth step of deleting the environment related to the conversion.

Hereinafter, with reference to the accompanying drawings will be described an embodiment according to the present invention; First, referring to the hardware environment to which the present invention is applied, the present invention is implemented under a medium-class computer hardware environment (VAX / VMS V5.4, INFORMAP 3 V3.3).

1 is a flow chart of the present invention implemented under the hardware environment as described above. Referring to the drawings, the process according to the present invention will be described in detail as follows.

When the work for carrying out the present invention is started, the work environment is first set (1), and the schema for changing the data of the city cable diagram to the pipeline by using the program and the schema copy of the existing environment are created and stored, Then, when working on track facility management, set up a user account (ACCOUNT) which is a group of commands to execute individual commands sequentially as a set of commands for executing related programs. In addition, the process of setting an application environment for batch processing of copying and renaming of drawings is performed. This is a directory in which programs are collectively stored because the application can be executed only in the corresponding directory. This is a configuration process for copying to.

After the above environment setting process is performed, a program for automatically deleting the annotations displayed on the railroad facility diagram, a drawing plan, and a temporary drawing for converting the existing downtown cable diagram to the pipeline are generated. (2) .

Next, the software for building and managing the database of the track facility is loaded into memory, and the program deletes the annotations of the track facility created in the facility diagram for the track facility management system with the program and simultaneously removes the residual images of the deleted files. To arrange temporary drawings to be converted.

Then, a batch processing list file for drawing conversion is generated, and the drawings which have been arranged in the cable diagram are renamed to the storage directory of the pipe diagram, and the drawing conversion preparation for generating the pipe diagram from the existing cable diagram is performed. (4) After the drawing conversion preparation is performed as described above, the pipeline diagram file which can be actually used is generated using the file completed in the drawing preparation process.

When drawing conversion is completed, a batch file list file for converting line types is generated, i.e., a file list for organizing converted drawings is generated. (6) Then, the hardware environment, InfoFORM, is driven to (7) When all the changes in the form of the line are performed, the drawing created temporarily for conversion is deleted, and the renamed drawing is renamed. 8). Then, to delete the environment related to conversion, the file list, the user account, the schema, and the registration database are deleted, the associated macro is deleted (9), and the work execution is finished.

Therefore, the present invention carried out for the above processing procedure, since the graphic and non-graphic data of the cable diagram is automatically generated when the database of the track facility management system is constructed, the graphic and non-graphic data of the pipeline diagram are automatically generated. The construction time can be shortened, reducing the cost of use, and the conversion of the non-graphic data of the cable diagram automatically generates the data of the cable diagram as the data of the pipeline diagram, thereby increasing the reliability of the data. have.

Claims (3)

In the construction of the track management database under the computer hardware environment, after setting up the work environment, it automatically deletes the annotations displayed on the track facility diagram, organizes the drawings, and converts the existing downtown cable diagram to the pipeline. Generating a temporary drawing for the first step; Loading software for database construction and management of track facility diagram into memory, deleting annotations of track facility created in facility chart for track facility management system with program, and removing residual images of deleted files A second step of arranging temporary drawings; A third step of preparing a pipeline diagram file that can be actually used by using a file completed in the preparation for reaching after preparing a drawing conversion for generating a pipeline diagram from an existing cable diagram; Generating a file list for arranging the converted drawings, changing the line form of the converted drawing to the line form of the pipeline diagram, deleting the temporarily created drawings for conversion, and renaming the converted drawings; And a fifth step of deleting the environment related to the conversion. The method of claim 1, wherein the setting of the working environment in the first step comprises: a sixth step of generating and storing a schema for changing the data of the city cable diagram to a pipeline diagram using a program and a schema copy of an existing environment; A seventh step of setting a user account (ACCOUNT) environment, which is a command group for sequentially executing individual commands, as a set of instructions for executing a related program during a work for managing a track facility; And an eighth step of setting an application environment for batch copying and renaming of drawings. The method of claim 1 or 2, wherein the drawing conversion preparation process in the third step is performed by renaming to a storage directory of the pipe diagram for converting the drawings. Way.