JPS63228217A - System for sorting facility managing number - Google Patents

Abstract

PURPOSE:To sort a facility managing number at high speed, automatically, and in a sequence of smaller number, by supplying a sort routine program and a managing file to a sorting means. CONSTITUTION:The managing file 1a and the sort routine program 1b are registered in a data base 1. When a request to sort the facility managing number included in the managing file 1a in the sequence of the smaller number is issued via a user interface 3, a data base managing system 2 supplies the managing file 1a and the sort routine program 1b to the sorting means 7. The sorting means 7 sorts the facility managing number included in the managing file 1a in the sequence of the smaller number. In such a way, it is possible to sort the facility managing number in the sequence of the smaller number without putting load on a user.

Description

[Detailed Description of the Invention] [Industrial Application Field] The present invention uses a management file registered in a database, and each record contains the equipment management numbers of m devices included in each equipment constituting the equipment group. The present invention relates to a method for sorting equipment management numbers from registered management files; sorting equipment management numbers in ascending order of numbers.

[Conventional technology]

When managing a facility group consisting of a plurality of facilities (for example, personal computers, etc.), a plurality of devices (for example, a main unit, etc.) that constitute each facility are managed.

It has been conventional practice to register a management file in a database in which the equipment management numbers of devices (ports, displays, etc.) are different data items in the same record, and to manage a group of equipment based on this management file.

FIG. 5 is a diagram showing an example of a management file registered in the database, in which a record is provided for each piece of equipment. Each record has data items such as equipment number No., equipment name ITEM N to ME, and equipment management number MAIN assigned to the main unit that makes up the equipment.
UNIT, equipment management number DISPLAY given to the display that makes up the equipment, equipment management number FD given to the floppy disk device that makes up the equipment
D. Equipment management number PRINTER given to the printers that make up the equipment, equipment management numbers given to the input/output devices that make up the equipment ■○ UNIT, equipment installation location LOCATION, equipment manager name MANAGER and use The law USAGE is registered.

By the way, when managing a group of equipment, from the management file shown in Figure 5, the management file shown in Figure 6 shows which equipment name each equipment management number corresponds to, and the equipment management numbers are sorted in ascending order of numbers. It may be necessary to obtain information such as: In addition, in Figure 6, ASSETS
ID represents the equipment management number, No represents the equipment number, and ITEM represents the equipment name. Conventionally, in such cases, the management files registered in the database were printed out using a printer, etc., and the equipment management numbers were manually sorted in descending order, or the management files registered in the database were read out from the database system. In addition to other systems, equipment management numbers are sorted in ascending order of numbers using a sorting routine program created by a user that performs the above-mentioned special sorting.

[Problem that the invention seeks to solve]

However, the method of manually sorting equipment management numbers in ascending order of numbers has the problem that the sorting process takes a very long time, and the method of using a sort routine program requires the user to create a sort routine program. In addition, there was also the problem that the management list had to be transferred from the database system to another system, making the operation cumbersome.

The present invention solves the above-mentioned problems, and its purpose is to make it possible to sort equipment management numbers in descending order of numbers without placing a burden on the user.

[Means for solving problems]

In order to solve the above-mentioned problems, the present invention provides a database in which a management file is registered in which the equipment management number of the equipment included in each equipment constituting the equipment group is registered as a data item of each record, and the database is managed. In a database system comprising a database management system and a user interface provided between the database management system and input/output equipment, an equipment management number managed by the database management system and included in the management file. The database management system is provided with a storage means for storing a sort routine program for sorting equipment management numbers in descending numerical order, and a sorting means for sorting equipment management numbers in ascending numerical order according to the sorting routine program stored in the storing means. By being requested to sort the equipment management numbers included in the management file in ascending order of numbers through the user interface, the management files stored in the database and the equipment management numbers stored in the storage means can be sorted. A sorting routine program is provided to the sorting means.

[For production]

When a request is made via the user interface to sort the equipment management numbers included in the management file in ascending order of numbers, the database management system provides the management file and the sorting routine program to the sorting means. Thereby, the sorting means sorts the equipment management numbers included in the management file into the smallest classification.

〔Example〕

Next, embodiments of the present invention will be described with reference to the drawings.

FIG. 1 is a block diagram of an embodiment of the present invention, in which a management file 1a and a sort routine program (sort routine name is IDLST, CMD) lb as shown in FIG.
a database 1 in which is registered, a database management system 2, a user interface 3, and a keyboard 4 connected to the user interface 3. It includes an input/output device 9 including a printer 5 and a CRT 6, a sorting means 7, and a working memory 8. Furthermore, database 1
．． Database management system 2. User interface 3. The sorting means 7 and working memory 8 constitute a database system. Furthermore, the database management system Z is, for example, Japanese dBAsEIIV2.4.
(Ashton Tates) and others.

FIG. 2 is a diagram showing the operating procedure of an operator when obtaining information in which equipment management numbers are sorted into smaller classifications from the management file 1a registered in the database 1, and FIG. 3 is a processing example of the database management system 2. FIG.

Next, the operation shown in FIG. 1 will be explained.

When the operator wants to obtain information in which the equipment management numbers registered in the management file 1a are sorted into the smallest number categories, the operator first performs startup processing of the database 1 as shown in FIG. 2 (step 2). This start-up process includes a command (SET DEFA) to start up the floppy disk device in which database 1 has been created (in this case, it is assumed that database 1 has been created in floppy disk device B).
ULT TOB) and a command (SET CARRY ON) for activating the database management system 2 from the keyboard 4.

Next, the operator issues "D", which has been determined in advance as a request command for sorting the equipment management numbers.

Enter a sort command (Do IDLST, CMD) from the keyboard 4 using "<Sort Routine Name>" (Step 2).

The database management system 2, as shown in FIG.
When it is detected that a sort command (Do IDLST, CMD) has been input (step S1), the sort routine program 1 registered in the database 1 is first executed.
B is transferred to the sorting means 7 (step S2), and then C
As shown in FIG. 4, RT6 displays a file name input prompt request +a+ and an output method input prompt request (bl) (steps S3 and S4).

When the file name input prompt ta) is displayed on the CRT 6, the operator operates the keyboard 4 and enters the file name of the management file la to be sorted into the area surrounded by the dotted line (a) on the CR 76 screen. By doing this, you will be prompted to specify the file name of the management file to be sorted (step ■), and a request to prompt you to input the output method (when bl is displayed, 1 or 0 will be displayed in the area surrounded by the dotted line (b)). , specify the output method (step S■).If the operator wants to display the equipment management numbers sorted into the lowest number classification on the CRT 6, press 0 in the area surrounded by the dotted line (b). When outputting from the printer 5, 1 is pressed in the area surrounded by the dot m (b).

When the file name of the management file to be sorted is input, the database management system 2 provides the file having the file name from the database 1 to the sorting means 7 (step S5), and the sorting means 7 uses the working memory 8. Then, the equipment management numbers included in the file given in step S5 are sorted into the smallest classification according to the sorting routine program given in step S2. The database management system 2 outputs the sorted equipment management numbers sorted by the sorting means 7 to the designated device (
Step S6).

In the above-described embodiment, the sort routine program 1b is stored in the database 1, but the invention is not limited to this. For example, a storage device that can be accessed by the database management system 2 may be provided, and this storage It is also possible to store it in the device.

〔Effect of the invention〕

As explained above, the present invention includes a storage means for storing a sort routine program managed by a database management system, and a sorting means for sorting equipment numbers in ascending order of numbers, Since the equipment management numbers are required to be sorted in descending order, the sorting means is provided with a sort routine program and a management file, and the equipment management numbers are automatically sorted in descending order. It becomes possible to quickly and automatically sort equipment management numbers in ascending order of numbers without putting a burden on the operator.

[Brief explanation of the drawing]

Fig. 1 is a block diagram of an embodiment of the present invention, Fig. 2 is a flowchart showing the operating procedure of the operator, Fig. 3 is a flowchart showing an example of processing of the database management system, and Fig. 4 shows the display contents of the CRT 6. FIG. 5 is a diagram showing an example of a management file, and FIG. 6 is a diagram showing sorted equipment management numbers. In the figure, 1...database, 1a...management file, 1b...sort routine program, 2...
・Database management system, 3... User interface, 4... Keyboard, 5... Printer, 6.
...CRT, 7... Sorting means, 8... Working memory, 9... Input/output equipment.

Claims (1)

[Scope of Claims] A database in which a management file is registered in which each record has an equipment management number of equipment included in each equipment constituting an equipment group as a data item, a database management system that manages the database, and the database. In a database system equipped with a user interface provided between a management system and input/output equipment, for sorting equipment management numbers managed by the database management system and included in the management file in descending order of numbers. storage means for storing a sorting routine program; and sorting means for sorting equipment management numbers in ascending order according to the sorting routine program stored in the storage means; Due to the request for sorting the equipment management numbers included in the management file in ascending order of numbers, the management file stored in the database and the sorting routine program stored in the storage means are sorted by the sorting means. A sorting method for equipment management numbers, which is characterized by giving