KR100233938B1 - Method managing and processing construction command using related database - Google Patents

Abstract

The present invention relates to a construction order processing and management method using a relational database, when receiving a construction order generated from a commercial computer received as an acquisition table, and at the point of acquisition converts or generates necessary data for each work department before the operation After managing in the table, it is distributed to the working table so that the related department can work on the desired date. Then, when all the work in the relevant department is completed, it is managed in the work completion table. After managing the system, it distributes the work to the table during the processing time, and improves the operational efficiency of the operation management system and improves the efficiency of system performance management and application writing.

Description

Construction order processing and management method using relational database

The present invention relates to a construction command processing and management method using a relational database, and to divide the database table into work stages (obtainment, before work, in work, completed work, unprocessed work) in order to process the input work order quickly, The present invention relates to a method for processing and managing a construction command using a relational database by storing and managing the work command in each database table according to a processing situation, thereby reducing the load on the computer at the same time as the effective work command processing.

In general, a computerized operation system that processes a customer's service request using a relational database receives the service and generates a construction (work) order in the form of a record, and processes the data before and after the work in terms of managing one order as a record. Since the management must be handled by the application program, it is difficult to efficiently manage the data before and after the work, and accordingly, the application program is composed of multiple levels, so the more types of construction orders, the more difficult the maintenance is.

In particular, the process of controlling work orders in a timely manner and transmitting work results and contents to the linked computer system or communication equipment requires a fairly complicated task. There are many difficulties to manage by state and systematically, and there is also a problem that the program is extended.

In order to solve the conventional problems as described above, the present invention manages a construction command as a record in a relational database operating environment, and processes a construction command record under an environment in which various unit operations are processed (obtainment, work). It aims to improve the data management efficiency of the database operation system by managing the table in stages according to before, during, and after work.

1 is a configuration diagram of a computerized operation system to which the present invention is applied.

2 is a flow diagram of data processing and management in accordance with the present invention.

3 is a flow diagram of data movement between files and database tables in accordance with the present invention.

<Explanation of symbols for main parts of drawing>

1: main computer 2: relational database

3: application unit 4: commercial computer

5: service means 6: operator terminal

In order to achieve the above object, in the data processing and management method of managing one command as a record, the data processing before and after the processing of the command processing in the application program unit, and stored in a relational database to manage, In order to correspond to each instruction processing progress of the relational database, an acquisition table for managing orders received by an operator in the order of reception, and the data stored in the acquisition table are converted into unit instructions according to a working environment, and processed until the desired date. A pre-managing table, a work-in-time table for performing and managing processing for data at the processing time from data stored in the work-up table, and data not processed in the work-up table are waiting to be reprocessed. Processing through the unprocessed table and the table during the operation Classifying into a plurality of table units including a construction order processing management table for managing communication facility information constituting a subscriber network for the completed construction order, and a work completion table for managing data for which the work is completed; When the processing date of the data stored in the acquisition table by using each of the classified table is characterized in that the processing of the work of the construction order.

The above objects, features and advantages will become more apparent from the following detailed description taken in conjunction with the accompanying drawings. Hereinafter, embodiments of the present invention will be described in detail with reference to the accompanying drawings.

1 is a general configuration diagram of a computerized operation system to which the present invention is applied, and includes a main computer 1 for controlling the whole of the computerized operation system; A relational database (2) for storing data of an operating system on the main computer (1); An application program unit (3) operated using data stored in the relational database (2); A commercial computer 4 for generating command data; Service means (5) necessary for service provision and future maintenance services, such as exchangers and fault management systems; And an operator terminal 6 installed by each operator of each service provision-related department to control and manage the operator and to input / output data required by the operator.

The relational database 2 is divided into tables (memory regions) in order to apply the command processing and management method proposed in the present invention. The structure thereof will be described with reference to FIG.

An order table which manages orders received by the operator in order of receipt, and the main data to be managed is an acquisition table 21 for managing a telephone station name, a telephone number, a requested service type, and the like; The data stored in the acquisition table 21 is converted into a unit command according to the working environment and managed until the desired date and time for processing, and the main data to be managed is the name of the telephone station, telephone number, required service type, and subscriber information. Pre-operation table 22; The main data for performing and managing the processing time data from the data stored in the pre-operation table 22 are as follows: the corresponding telephone station name, telephone number, required service type, subscriber information, subscriber facility information, and each A table 23 during operation for managing work completion by device; The main data for managing the unprocessed data in the table 23 during the operation, waiting for the reprocessing date, and the main data to be managed include the name of the telephone company, telephone number, required service type, subscriber information, subscriber facility information, and each device. An unprocessed table 24 for managing work completion, unprocessed cause, and related data; Information on the various communication facilities constituting the subscriber network, such as the management of selection of various communication facilities, management of subscriber communication facilities, management of subscriber facilities, management of exchange facilities, and statistical analysis for construction orders processed through the table 23 during the operation. A table 25 for construction order processing management to manage; And the main data to manage all the work is completed, and the main data to manage the relevant telephone station name, telephone number, requested service type, subscriber information, subscriber facility information and work completion form for each device, cause of unprocessed history and related data In addition, it is divided into a work completion table 26 that manages each unit task completion date and a corresponding worker.

The application program unit 3 incorporates a construction instruction processing and management program proposed by the present invention to be described below to store data required by each commercial computer 4, service means 5, and operator terminal 6. Process to input / output.

The computerized operation system configured as described above, when a service construction instruction generated by the commercial computer 4 to provide a service related to the customer service is inputted, the operation completion table 26 in the relational database 2 is processed by processing the instruction. And to provide data required by each service means (5) and operator terminal (6). And process management) will be described in detail with reference to the flowchart shown in FIG.

First, when a service construction order (variable data) generated for the provision of services related to customer service is input in the commercial computer 4, the construction order data is used every unit of a predetermined time (hour, minute, second). A first step S1 of generating a file and transmitting it to the application program unit 3; When the command is input in the step S1, after receiving the construction order file, the received sales order document is made into a record form so as to facilitate the operation in the relational database environment. A second step S2 obtained in 21); When the data is input to the acquisition table 21 through the step (S2), after converting or adjusting the data according to the working environment to distribute the sales instruction data in the actual field situation, and then distributed to the pre-work table 22 , The third step (S3) to manage until the desired work day; If there is a command corresponding to the desired work date among the data being managed, all the tasks necessary for service provision are distributed by distributing the corresponding command to the table 23 during the operation (a series of unit operations required to complete the operation (e.g. sending and receiving related data to the interlocking system, The fourth step (S4) to control and process the personnel, work control, post- and post-management of the physical work); In the step (S4), the command that the work is not completed in the process (command that cannot be completed or deferred due to the situation of the telephone company such as congestion or the subscriber due to the congestion or the postponement) is moved to the unprocessed table 24 and managed. After that, the reprocessing date is designated among the commands that were being managed, the fifth step (S5) of moving to the table 23 during the reprocessing on the reprocessing day (S5); Instructions to be processed in relation to the maintenance on the job site is the sixth step (S6) to process the work by making a command in the table 23 during work; And a command in which work is completed through each of the steps includes a seventh step S7 of moving to the work completion table 26 as a daily closing work and managing for a predetermined period of time.

In this case, the converting and adjusting the data input to the acquisition table 21 in the third step S3 means to classify and convert the service type input in the sales according to the actual work. For example, The installation change command 'E1' in the telephone office is divided into 'BA' (new installation change) and 'AA' (discontinue installation change).

In the fourth step (S4), the work required to provide a service varies depending on the service provided. For example, when the service type is a new hypothesis command, the operation can be classified into six steps.

First, the address conversion step of standardizing the address called by the customer in order to select an external line suitable for the installation place.

Second, the outside line selection work that selects the subscriber line suitable for the telephone installation place.

Third, domestic facility selection work that grants mechanical facilities in the exchange for outside lines.

Fourth, the core line confirmation work step is to dispatch field personnel to form a line with facilities selected in cooperation with the operating personnel in the telephone company.

Fifth, the database update step of updating the database of the system for the completed service.

Sixth, the completion phase of notifying the relevant operation system of completion.

Finally, when the work is completed through the above steps, it is classified into a daily settlement work step of performing settlement.

In addition, in the fifth step (S5), the reprocessing date is specified by the customer complaints, etc. among the orders in the unprocessed table 24 (for example, the customer contacts the telephone company again for an instruction that cannot be placed on the padding member). When the hypothesis schedule is adjusted, the operator enters the adjusted date at the reprocessing date at this time.

Referring to FIG. 3, the movement state of data moving to each table in the process of processing and managing data required by the commercial computer 4 through the above process is described in the first step (S1). ) And the data flow corresponding to the second step (S2) is a data flow in which a file input from a commercial computer is obtained into a database; 'b' process is a data flow corresponding to the third step (S3), when the data stored in the acquisition table 21 is a processing day flows a command record to the pre-operation table 22; Processes 'c', 'd', and 'e' are data flows corresponding to the third step S3 and the sixth step S6 of the command record from the pre-work table 22 to the work table 23. A data flow showing movement of a construction instruction record required for movement, subsequent unit operations using a file, and execution of various unit operations using a database table, and command processing in the table 23 during operation; 'f' and 'g' processes the unprocessed data not processed in the table 23 during the operation in the data flow corresponding to the fifth step S5 in the unprocessed table 24, and then the unprocessed table 24. When the processing time for the unprocessed data is reprocessed in the flow again to move the command record to the table 23 in operation; 'h' process is a data flow corresponding to the seventh step (S7) is a state in which all the work is completed in the table 23 during the work is input to the work completion table 26 to represent the state.

As described in detail above, according to the data processing procedure proposed by the present invention, the construction instruction records are managed in a timely manner step by step in a database table having different characteristics according to the processing state, thereby improving the operational efficiency of the operation management system. It also has the advantage of managing the construction order record in a separate table for each processing status and dismantling (moving) the record when the work is needed, thereby improving efficiency in system performance management and application writing.

In addition, a preferred embodiment of the present invention is disclosed for the purpose of illustration, those skilled in the art will be able to make various modifications, changes, additions, etc. within the spirit and scope of the present invention, such modifications and modifications belong to the following claims You will have to look.

Claims (2)

In the data processing and management method of managing one command as a record, processing the data management before and after the processing by the application program unit, and then storing and managing the relational database in a relational database. And an operation table for managing the commands received by the operator in the order of reception, the pre-operation table for converting and dividing the data stored in the acquisition table into unit commands according to the working environment, and managing up to the processing date. Through the table during the operation to perform and manage the processing of the data at the processing time from the data stored in all the table, the unprocessed table to wait for the reprocessing date by managing the data that was not processed in the table during the operation, and the table during the operation Establish subscriber network for processed construction orders Tables, Ltd. command processing management facilities for managing the communication information, and classified into a plurality of unit table having a completion table for managing the data operations are all completed; When the processing date of the data stored in the acquisition table by using each of the classified table, the construction order processing and management method using a relational database, characterized in that for processing the work of the corresponding construction order. The method of claim 1, wherein the processing of the construction order comprises: receiving a service request, making business data in a record form, and then entering the acquisition table to manage a command related to a job; Converting or adjusting the data so that the sales order data can be processed in the actual working environment after the step, and moving the data to a pre-work table that manages the corresponding orders until a desired start date; Moving the construction order from the pre-work table to a working table for controlling and processing all the work required for the construction progress on the service desired date after the step; Moving unprocessed data during execution of the step to an unprocessed table managed to be reprocessed on a work reprocessing date; And moving all the instructions to a processing completion table when all the work required to complete the construction instruction for the processing data is completed, and managing the construction instruction.