JPH0528197A - Database processing device - Google Patents

Abstract

PURPOSE:To sort and retrieve a plurality of information registered in a database by each rank. CONSTITUTION:A rank to be specified for the field data of general record to be stored is supplied to the specified index field in each information to be registered, and the rank list is prepared and stored in an index data area 3. When a direction of a sort by rank comes from the input device 1, a sort judgement part 9 by ranks and a data comparison part 12 outputs each rearranged information according to the rank, and a retrieval judgement part 13 by ranks and a data comparison part 15 retrieves all the information within the range at its output.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database processing device for registering a plurality of information in a searchable database.

[0002]

2. Description of the Related Art A database processing device as described above is
For example, multiple pieces of information including address, name, age, job title, etc. are entered as an address book and registered in the database. After registration, if search conditions such as name, job title, etc. are entered and specified, the search is performed from multiple information. It is a device that can retrieve and call information corresponding to a condition.

Conventionally, in such a database processing apparatus, a plurality of registered information items are sorted, for example, such that the first sound of a name is rearranged in the Japanese syllabary order or the age is rearranged in a younger order. I was able to. The former is to sort the kanji codes of each information at the time of sort processing and rearrange them in the reading order.
In addition, for example, when it is desired to search for information of persons whose titles are section chiefs or higher from a plurality of pieces of information, 1 or more is used as the search condition such as section chiefs or section managers or department managers or presidents.
I was trying to specify all by inputting them one by one.

Further, in the above sort processing, only the information that completely satisfies the specified search condition is extracted. Furthermore, when a search condition is specified, for example, when a plurality of items such as age and job title are specified in combination, information corresponding to both items is searched in the order in which the information is extracted or in the order in which the items are arranged. I was trying to output information.

[0005]

However, in the above-described database processing apparatus, it is not possible to sort in a rank order of positions, for example, in order of sorting, for example, department manager, section manager, section manager, chief. Therefore, when performing such rearrangement, there is a problem in that it is necessary to perform a work of sequentially replacing the information registered by the operator, and the sorting work takes time and effort.

Further, as described above, when it is desired to search for information having a search condition of a predetermined rank or higher, such as information of a section chief or higher, it is troublesome for the search work to specify all the search conditions within the range of the rank. There was also the problem that it took time.

Furthermore, if only the information that completely satisfies the search condition specified at the time of search is extracted, the search condition specified while referencing the search result is not completely satisfied but partially satisfied. If you want to refer to such information as well, you have to cancel the search results that are currently being output and specify the search conditions for the information you want to refer to again to perform another search. There was a problem.

Furthermore, when a search condition in which a plurality of items are combined is designated, if the search results are output in the order in which they are extracted or in the order in which any one of the items is arranged, a plurality of pieces of information are simply mixed. There is also a problem that the search results are difficult to see because it is easy to enumerate them.

The present invention has been made in view of the above points, and it is a first object of the present invention to enable a plurality of pieces of information registered in a database to be sorted or searched for each rank. A second object is to reduce the operation for searching information from the database.

[0010]

In order to achieve the above object, the present invention provides a means for registering a plurality of information input from an input device in a database, and a database for storing information corresponding to conditions input from the input device. In the database processing device equipped with a means for searching from the above and a display device for displaying the information searched by the means, the rank specified for the field data of the total record to be stored in the specified item field in each information is determined. A rank list creating means for creating the rank list, and a rank for sorting each information in the rank list in record units when a sort-by-rank instruction is input from the input device and sorting each information according to the rank. The other sort means is provided.

Further, in the database processing device provided with the above-mentioned registering means, searching means and display device, a designated rank is assigned to the field data of the total record to be stored in the designated item field in each information. Then
Rank list creating means for creating the rank list,
A rank-based search means is provided to search all information within the rank range by comparing the ranks in the rank list on a record-by-record basis when the rank search instruction and the rank range to be searched are input from the input device. We also provide food.

Further, means for registering a plurality of information input from the input device in the database, means for retrieving information corresponding to a plurality of conditions input from the input device from the database, and information retrieved by the means In a database processing device equipped with a display device for displaying, each information is searched by means for adding an identifier indicating whether or not each condition is met to each information at the time of search, and the number of identifiers added by the means. It is also provided with a grouping means for grouping. Further, it is preferable to provide a means for outputting each information grouped by the grouping means to the display device according to the group designation or the priority order inputted from the input device.

[0013]

In the database processing apparatus according to the present invention, the rank list creating means assigns the designated rank to the field data of the total record to be stored in the designated item field in the plurality of information registered in the database. When a rank list is created and rank sorting instructions are input from the input device, the rank sorting means compares each rank in the rank list on a record-by-record basis and sorts each information according to that rank. When a plurality of pieces of information to be sorted are to be sorted by rank, it is not necessary to replace each piece of information.

Further, when a rank-based search instruction and a range of ranks to be searched are input from the input device, rank-based search means compares the ranks in the rank list on a record-by-record basis, and all information within the rank range is displayed. If you search for
When searching for information within the range of a predetermined rank, it becomes unnecessary to input all the search conditions within the range.

Furthermore, when searching the database for information corresponding to a plurality of conditions input from the input device,
By adding an identifier indicating whether or not each condition matches each condition and grouping the information into groups by the number of the identifiers, a plurality of conditions to be input can be completely satisfied. It is possible to search for information that is not available. Furthermore, if each information grouped by the grouping means is output to the display device in accordance with the group designation or the priority order input from the input device, the retrieved information items are simply mixed and listed. There is no output.

[0016]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENT An embodiment of the present invention will be specifically described below with reference to the drawings. FIG. 1 is a block diagram showing the configuration of a database processing device according to the present invention. This database processing device includes an input device 1 such as a keyboard having various input keys, and a CRT, LC for displaying various information.
A display device 2 such as D and an item data area 3 which is a database for registering a plurality of information and a rank list of each information
And file 4 such as a hard disk device that stores it
It has and.

Further, means for registering a plurality of pieces of information input from the above-mentioned input device 1 in the database, means for searching the database for information corresponding to the conditions input from the input device 1, and designation in each information. In the rank list, when the rank list creating means for creating the rank list and adding the specified rank to the field data of the total record to be stored in the selected item field and the sorting instruction by rank is input from the input device 1 In the rank list when rank-by-rank sorting means for comparing each rank of each of the records in a record unit and rearranging each information according to the rank and a rank-by-rank search instruction and a range of ranks to be searched are input from the input device 1. It is possible to realize a rank-based search means for searching all the information within the range of ranks by comparing each rank of To, and includes the following sections.

That is, the input control unit 5, the sort condition input unit 6, the search condition input unit 7, the Kanji code comparison unit 8, the rank-based sort determination unit 9, the data storage unit 10, and the rank designation unit 1
1, data comparison unit 12, rank-based search judgment unit 13, data extraction unit 14, data comparison unit 15, Kanji code comparison unit 1
6, a character pattern area 17, and a display control unit 18.

Next, the rank designation process will be described with reference to the flowchart of FIG. This rank specification attaches the rank specified to the field data of the total record to be stored in the specified item field in each information,
This is a process of creating the rank list.

First, when item data of each information is input from the input device 1, the data storage unit 10 is input via the input control unit 5.
Are stored in the item data area 3. Next, after an instruction input for designating a rank is made from the input device 1 and sent to the rank designating section 11 via the input control section 5,
As shown in FIG. 2, when an item to be rank-processed, a rank data name, and the rank are input from the input device,
They are stored in a predetermined area of the item data area 3. In this way, when all the data names of the items designated first are given ranks to create a rank list, this rank designation processing is terminated.

Next, the sorting process will be described with reference to the flowchart of FIG. This sort process is a process in which, when a rank-specific sort instruction is input from the input device 1, the ranks in the rank list are compared on a record-by-record basis, the pieces of information are rearranged according to the ranks, and then displayed.

First, when a sort instruction is input from the input device 1 and subsequently items to be sorted are key-designated and rank-designated as shown in FIG. It is sent to the sort condition input unit 6 via the. Then, the sort-by-rank determining unit 9 refers to the item data area 3 and determines whether or not a rank is designated for the input item.

If the rank is designated, the data comparison unit 1
2 displays the data (information) for one record by comparing the ranks given to each data (each information) in the item data area 3, checks the total number of records, and displays all information sorted. Until the above processing is repeated until this is completed, this processing is ended.

If the rank is not designated, the Kanji code comparison unit 8 compares the Kanji codes of the respective information items in the item data area 3, rearranges them in the order of the Kanji code, and records one record of data (information). When is displayed, the total number of records is checked and the above processing is repeated until all the information is sorted and displayed. When it is completed, this processing is ended.

In the data comparison unit 12 and the Kanji code comparison unit 8, the storage positions of the respective information are rearranged so that the data extraction unit 14 receives the storage positions and the data extraction unit 14 character code of the respective information in the item data area 3. Is read, the character pattern corresponding to the character code is read from the character pattern area 17, sent to the display controller 18, and displayed on the display device 2.

Next, the search process will be described with reference to the flowchart of FIG. In this search processing, when a rank-specific search instruction and a rank range to be searched are input from the input device 1, each rank in the rank list is compared on a record-by-record basis to search for all information within the rank range. It is a thing.

First, when a search instruction is input from the input device 1 and, as shown in FIG. 4, the items to be searched are subsequently key-specified and the range of ranks is specified, the input control unit 5 receives them. Is sent to the search condition input unit 7 via. After that, the rank-based search determination unit 13 refers to the item data area 3 and determines whether or not a rank is designated for the input item.

If the rank is designated, the data comparison unit 1
5 compares the rank assigned to each data (each information) in the item data area 3 with the designated rank range, displays the corresponding one record data (information), and checks the total number of records. The above process is repeated until all information is retrieved and displayed, and when this is completed, this process is terminated.

If the rank is not specified, the Kanji code comparison unit 16 compares the Kanji code of each information of the specified item in the item data area 3, and the one record of the information corresponding to the Kanji code is compared. When the data (information) is displayed, the total number of records is checked, all the information is searched, and the above processing is repeated until all the relevant information is displayed, and when this is completed, this processing is terminated.

The data comparison unit 15 and the Kanji code comparison unit 16 search the storage position of each information, receive the storage position, and the data extraction unit 14 determines the character code of each corresponding information in the item data area 3. Read and display the character pattern corresponding to the character code in the character pattern area 1
The data is read out from the device 7, sent to the display controller 18, and displayed on the display device 2.

FIG. 5 is an explanatory diagram showing an example of the format of the item data area 3. The item data area 3 is roughly divided into three areas of an ID, an item control block and an item data block. The version, the total number of records, the number of items, the record length, etc. are stored in the ID.

In the item control block, the byte length of the following item data, the item name, and the rank presence / absence flag 16
Stores bytes of data. This rank-specific processing presence / absence flag is an identifier indicating whether or not a rank is designated for each information at the time of the sort and search processing, and when rank-specific processing is designated, the flag is set to 1, The rank and data name are stored in the next 32 bytes.

When rank-specific processing is not designated, the flag is set to 0 and nothing is stored in the next 32 bytes. Further, a plurality of pieces of information are stored in the item data block in the order of items, all the item data ends with 0, and the file end code of OX1A is stored at the end of the file.

FIG. 6 is an explanatory view showing the format of the item data area when specific information is stored by designating rank-specific processing. In this way, the item control block
The flag 1 indicating that the process by rank is designated and the rank corresponding to each data name are "1 department manager""2 section manager"
It is stored as "3 chief" ... Further, each information is sequentially stored in the item data block for each item of name, title, address, and telephone number.

Next, an operation procedure of rank designation and search condition designation, and a display example of sorting and search results will be described with reference to FIGS. Here, a case where an employee list as shown in FIG. 7 is registered in the database will be described.
The employee number, affiliation, name, title, address, and telephone number are registered in this employee list.

When the rank is designated, a work screen as shown in FIG. 9 is displayed on the display device 2, so that items to be sorted or searched by rank are set later. For example, if you want to specify a job title as that item, the character displayed will be displayed in black and white when you specify the job title.
The rank name and the corresponding data name are, for example, "1 division manager"
Enter "2 section manager", "3 section manager", "4 chief", "5 none".

When the sort-by-rank sort process is selected after such rank designation, each information is automatically rearranged and displayed in the order of high rank (low rank numerical value) as shown in FIG. The list is displayed on the display screen of the device 2.

Next, when designating search conditions, the process shown in FIG.
The work screen as shown in is displayed, so if you select, for example, a job title and enter the rank range of the information you want to search, for example, if the job title is more than the staff manager, you will be registered. Only the information whose position is the section chief or higher is retrieved from the information that is displayed and displayed in a list on the display screen in descending order of position.

In this way, if a rank is designated for any item in a plurality of pieces of information registered in the database, the item is automatically sorted according to the rank or searched within the rank range. Because I will be able to do it,
Such work can be performed without the time and effort of the operation.

Next, a second embodiment of the present invention will be described. FIG. 11 is an external perspective view of a card-type database processing device in this embodiment, and FIG. 12 is a functional block diagram thereof. This database processing device is equipped with a keyboard 21 having various input keys, a display device 22 such as a CRT or LCD, and a microprocessor including a CPU, a ROM, a RAM, and the like. It is composed of a control processing device 23 that controls various related processes.

The control processing device 23 registers means for registering a plurality of pieces of information input from the above-mentioned keyboard 21 (input device) in the database, and retrieves information corresponding to a plurality of conditions input from the input device from the database. Means, a means for adding an identifier indicating whether or not each condition matches each information at the time of search, and a grouping means for grouping each information by the number of identifiers added by the means, Each unit (shown in FIG. 12) listed below is provided in order to realize a unit that outputs each information grouped by the unit to the display unit according to the group designation or the priority order input from the input unit.

That is, the input control unit 24, the record data unit 25, the data file search unit 26, the search condition input unit 27, the output condition order determination unit 28, the index data unit 29, the search data pointer number alignment unit 30, the determination result data. Unit 31, display control unit 32, and search result data unit 3
Equipped with 3.

FIG. 13 is an explanatory diagram showing an example of the format of the record data part 25, and FIG. 14 is an explanatory diagram showing an example of the format of the index data part 29 according to the name item. As shown in FIG. 13, the record data unit 25 sequentially stores item data such as names, heights, and dates of birth of a plurality of persons as address book data.

Further, in the index data part 29, as shown in FIG. 14, in order to refer to the item of "name" of each information stored in the record data part 25, the pointer "P20" of each record of the index is referred to. "P4"
"P1" ... is stored. Then, when the information retrieved from the record data section 25 is displayed on the display device 22, it is displayed in a format as shown in FIG. 15, for example.

Next, the retrieval process and the information extraction process will be described with reference to FIGS. Here, a description of a known technique of comparing character strings of record data and determining whether or not a search condition matches is omitted.

First, when the information retrieval process is selected, as shown in FIG.
Since a work screen for inputting search conditions as shown in 6 is displayed on the display device 22, for example, when searching for a person who has an annual income of 5 million or more and was born between 1960 and 1965, “> = 500” is entered in the annual income column. In the date of birth column to "196
0 to 1965 ”are input respectively. in this way,
The condition of each search item is to enter the relation that is combined with "and" by default.

Then, when "optimal" in the bottom column is selected, a process for searching and extracting only the information that completely satisfies the above search conditions is executed, and when "set" is selected, the search conditions are input from the input control unit 24. A set classification search process is performed in which each piece of information is sent to the search condition input unit 27 and each piece of information is classified and extracted for each number of satisfied conditions.

In this set classification search processing, as shown in the flow chart of FIG. 17, the data file search unit 26 determines for each record whether or not the respective search conditions are met, and records of the information to which the conditions are met. The identifier indicating that the above is matched is stored in the determination result data section 31. FIG. 18 is an explanatory diagram showing an example of the format of the determination result data section 31. In this way, the determination result data section 3
In 1 is stored 1 byte of data for each record, and "1" is stored if they match, and "0" is stored for each search condition if they do not match.

When the judgment is completed for all the search conditions for one record, the cumulative number of matching conditions is counted as the judgment result. When such a process is performed for all records (all information) and the record ends, the determination result data as shown in FIGS. 19 and 20 is created and stored in the determination result data section 31.

Next, it is judged whether "optimal" or "set" is designated. If "optimal", the judgment result expression "00000011b" shown in FIG. 21 is set as the selection result expression, and the index data part 29 Based on the index order of the names shown in FIG. 14, the search data pointer number sorting unit 30 sorts and extracts the determination results by the set expression and stores them in the search result data unit 33.

FIG. 22 is an explanatory view showing the format of the search result data obtained in this way, in which a pointer indicating the storage position of each information is stored as a set for each number of matching search conditions.

On the other hand, if "collection" is specified, then FIG.
Four determination result expressions “00000011b” and “0” shown in 1
00000010b "" 00000001b "" 0000
"0000b" in this order in the selection result formula, and based on the index order of the names shown in FIG. 14 of the index data unit 29, the search data pointer number alignment unit 30 performs the alignment extraction of the determination result by the set formula. And stores it in the search result data section 33.

After that, when the data is stored in the search result data section 33, the display control section 32 causes the display device 22 to display it. At that time, the output condition order determining section 28
The search data pointer number alignment unit 30 according to the group designation or the priority order input from the keyboard 21 by the
The pointers of the record data are read in that order, the corresponding record data is read and output.

Therefore, for example, if the search result is specified to be output as follows: 1) Annual income is 5 million or more and the date of birth is from 1960 to 196.
Person of 5 years 2) Annual income of more than 5 million and date of birth 1960-196
Persons other than 5 years 3) Annual income less than 5 million and date of birth 1960-196
5 years old 4) Annual income is less than 5 million and birth date is from 1960 to 196
The list displayed by people other than 5 years becomes easy to see.

When three search conditions are input, each piece of information corresponds to the condition area of 8 as shown in FIG.
It is classified into a set of streets. The processing by the output condition order determination unit 28 in the above-described embodiment is performed by the keyboard 21.
Although it is performed by inputting from the above, it may be determined by the system in advance and automatically judged by the device and rearranged in order to output.

In this way, if the record data section 25 in which a plurality of pieces of information are registered is accessed and searched only once, it is possible to classify and output information other than all the information that matches all the input search conditions. Therefore, labor saving of the search condition input device and simplification of the search process can be achieved.

Further, since each information is classified into a set according to the number matching a plurality of search conditions, it is possible to select in each set or output according to the priority, so that the record data of each information can be ranked. However, it is possible to preferentially search and extract and refer to the most necessary information excluding unnecessary information.

[0058]

As described above, according to the database processing apparatus of the present invention, it is possible to sort or search a plurality of pieces of information registered in the database for each rank. Further, it becomes possible to reduce the operation for searching information from the database.

[Brief description of drawings] 【Example】

FIG. 1 is a block diagram showing a configuration of a database processing device according to the present invention.

FIG. 2 is a row chart showing rank designation processing in the database processing apparatus shown in FIG.

FIG. 3 is a flowchart showing a sorting process in the database processing device of FIG.

FIG. 4 is a flowchart showing a search process in the database processing device shown in FIG.

5 is an explanatory diagram showing an example of a format of an item data area 3 shown in FIG.

FIG. 6 is an explanatory diagram showing a format of an item data area when specific information is stored by designating rank-specific processing.

FIG. 7 is an explanatory diagram showing an example of an employee list.

FIG. 8 is an explanatory diagram showing a format when displaying each information searched by rank-based search.

FIG. 9 is an explanatory diagram showing an example of a work screen when a rank is designated.

FIG. 10 is an explanatory diagram showing an example of a work screen when a search condition is designated.

FIG. 11 is an external perspective view of a card-type database processing device according to the second embodiment of the present invention.

FIG. 12 is also a functional block diagram showing the configuration of the control processing device.

13 is an explanatory diagram showing an example of a format of a record data section 25 of FIG.

14 is an explanatory diagram showing an example of a format of an index data part 29 according to the item of the name shown in FIG.

FIG. 15 is an explanatory diagram showing an example of a format when displaying retrieved record data.

FIG. 16 is an explanatory diagram illustrating an example of a search condition input work screen.

17 is a flowchart of a set classification search process in the database processing device shown in FIG.

18 is an explanatory diagram showing an example of a format of the determination result data part 31 shown in FIG.

FIG. 19 is an explanatory diagram showing an example of a format of determination result data.

FIG. 20 is an explanatory diagram showing an example of a format of determination result data.

FIG. 21 is an explanatory diagram of a determination result formula.

FIG. 22 is an explanatory diagram showing a format of search result data.

FIG. 23 is an explanatory diagram of determination result expressions when there are three search conditions.

[Explanation of symbols] 1 input device 2 display device 3 item data area 4 files 5, 24 input control unit 6 sort condition input unit 7 search condition input unit 8 and 16 Kanji code comparison unit 9 sort determination unit by rank 10 data storage unit 11 Rank designation part 12, 15
Data comparison unit 13 Search determination unit by rank 14 Data extraction unit 17 Character pattern area 18, 32
Display control unit 21 Keyboard 22 Display device 23 Control processing device 25 Record data unit 26 Data file search unit 27 Search condition input unit 28 Output condition order determination unit 29 Index data unit 30 Search data pointer number alignment unit 31 Judgment result data unit 33 Search Result data section

Claims (4)

[Claims] 1. A means for registering a plurality of information inputted from an input device in a database, a means for retrieving information corresponding to a condition inputted from the input device from the database, and information retrieved by the means. In a database processing device equipped with a display device for displaying, a rank list creating means for creating a rank list by assigning a specified rank to the field data of the total record to be stored in the specified item field in each of the information, A rank-sorting means for comparing the ranks in the rank list on a record-by-record basis and rearranging the pieces of information according to the rank when a rank-sorting instruction is input from the input device. And database processing device. 2. A means for registering a plurality of information inputted from an input device in a database, a means for retrieving information corresponding to a condition inputted from the input device from the database, and information retrieved by the means. In a database processing device equipped with a display device for displaying, a rank list creating means for creating a rank list by assigning a specified rank to the field data of the total record to be stored in the specified item field in each of the information, When a rank-specific search instruction and a range of ranks to be searched are input from the input device, ranks in the rank list are compared on a record-by-record basis to search for all information within the rank range. And a database processing device. 3. A means for registering a plurality of information inputted from an input device in a database, a means for retrieving information corresponding to a plurality of conditions inputted from the input device from the database, and a means for retrieving by the means. In a database processing device provided with a display device for displaying information, a unit for adding an identifier indicating whether or not each condition matches each of the information at the time of the search, and an identifier added by the unit. A database processing device, comprising: a grouping unit for grouping each of the information items by number. 4. The database processing apparatus according to claim 3, further comprising means for outputting each information grouped by the grouping means to the display device according to a group designation or a priority order input from the input device. A database processing device characterized by the above.