JPH06332926A - Card type data base device - Google Patents

Abstract

PURPOSE:To provide a card type data base device for shortening the processing time of sum-up or retrieval and unnecessitating a large capacity memory while holding the format of a card suitable for the convenience of work. CONSTITUTION:Plural data input columns corresponding to the same item are collected in a group, and data for simultaneously instructing this group are prepared and stored in the high-order hierarchy of this group. Thus, the storage position of the instruction data instructing the relevant item inside card data is fixed rehardless of the number of the data input columns of the relevant item. Therefore, in the case of sum-up or retrieval, it is enough only to instruct the instruction data at the fixed position, and it is not necessary to read out all the data of the card. Namely, processing time is shortened.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a card type data base apparatus, and more particularly to an improvement in the data structure of a card type data base.

[0002]

2. Description of the Related Art As shown in FIG. 1, a card type database apparatus has a plurality of item names and one item name corresponding to each item name.
Alternatively, by displaying a card (form) having two or more data input fields on the display and accepting data input to each data input field, the form can be electronically produced. It is a device.

Japanese Examined Patent Publication No. 64-5346, JP-A-2-
In Japanese Patent No. 23716, Japanese Patent Laid-Open No. 3-233775, Japanese Patent Laid-Open No. 4-37953, etc., a card style (input / output style: FIG. There is disclosed a card type data base device capable of easily designing the image, data type, etc. illustrated in FIG.

[0004]

In the data input field of the card, there are one data input field for each card and a plurality of data input fields. There are items provided. For example, in Figure 1, "delivery destination""consumptiontax"
Each item of "total" has one data input field, but each item of "product name", "unit price", "quantity", and "amount" has four data input fields. Has been.

"Delivery destination" is an item that is not separated from the relevant card, and it is appropriate that the number of data input fields is one. Also,
Since "consumption tax" and "total" are items showing the calculation result from the data group described in the data input field of "amount" of the relevant card, these are also data input fields. It is reasonable that the number of is 1 and it is not separated from the card.

The items "item name", "unit price", "quantity", and "amount" are not non-separable items from the relevant card, but can be transcribed to other cards. It is also an item that is aggregated from a large number of cards on a monthly basis and that desired data is retrieved. Therefore, the number of data input fields in one card of these items does not necessarily have to be four from the viewpoint of tabulation and retrieval, but it is convenient for business (amount handled collectively). Etc.) in consideration of 3 to 4 cases.

In the conventional card type data base apparatus, as shown in FIG. 12, the data is stored in the memory in the order of the cards and the data is stored in each card. -Order of input fields (in the example of Fig. 1, a, b1, c1, d1, e1, b2, c2, ..., d
The data is stored in the order of 4, e4, f, g). Also, 2
It may be stored in the order of (..., e1, f, g), as if no data was input to the data input fields (b2, ..., e4) after the first item. . Therefore, it is necessary to read all the data each time the totaling process or the search process is performed, and the process takes a long time.

In order to reduce the processing time, the number of data input columns in one card for each item such as "product name" may be set to one. However, since only one card is usually displayed on the screen, the number of data input fields can be set to 1
If this is the case, not only will the operation of the operator at the time of input be complicated, but it will be difficult to confirm it on the screen after the input. That is, there arises a problem that convenience in business is impaired.

Further, in order not to impair business convenience,
As shown in Fig. 1, 3 to 4 data input fields are provided,
For example, there is a method to reduce the time required for search processing by disassembling and saving the data on a monthly basis, but in this case, the card will be destroyed. The problem arises that the relationship with etc. becomes unclear.

Further, in order to clarify the relationship with "consumption tax" and the like, for example, in the method of creating files for each required output format, such as a relational type database, A large capacity memory is required, and the data structure becomes complicated. SUMMARY OF THE INVENTION An object of the present invention is to provide a card type database device which can perform a totalization process and a search process in a short time without impairing business convenience.

[0011]

SUMMARY OF THE INVENTION The present invention introduces the concept of a hierarchical level to the storage location of data, collects the storage locations of data in level units, and stores the data of storage locations of lower levels. When instructing, the card-type data base apparatus achieves the above-mentioned object by passing through the instruction data of the higher level prepared so as to instruct the lower level.

That is, the card-type data base apparatus of the present invention is currently selected in a card format having item names and one or more data input fields corresponding to each item name. Display control means for synthesizing the data of the displayed card and displaying it on the display; the item name and the data input column corresponding to the item name are grouped and the hierarchical level of each group is set. Hierarchical level storage means respectively stored; item names designated by the cursor or hierarchical levels of the group to which the data input field belongs,
The data is stored in the memory by setting it in the counter as a hierarchical level of the data storage position of the data input field included in the group.
By counting the above counter every time the data is read,
Hierarchical level instruction means for transferring an instruction to the hierarchical level; instruction data for instructing the storage location of the data in the data input field at the head of the group whose hierarchical level is not the highest level Instruction data producing means for producing each group and setting the storage position of each instruction data to a higher hierarchical level.
Storage locations with the same hierarchical level are consecutive in memory,
Further, a storage position control means for controlling the storage position of the data in the memory so that the storage positions of the respective data in the data input fields of the same group are continuous in the memory; input mode; So de
When the hierarchy level of the group to which the data input field indicated by the cursor belongs is not the highest level when the data is input, the above-mentioned instruction created for the group. According to the data, the instruction is moved to the data storage position in the data input field at the head of the group, and the order from the storage position is from the head data input field to the cursor. Input control means for storing the input data in the designated storage position after the instruction is moved to the storage position in the same order as the order up to the data input field designated by the above; When the data is input in, if the hierarchical level of the item name designated by the cursor or the group to which the data input field belongs is not the highest level, According to the above-mentioned instruction data that has been created, the data in the data input field at the head of the group is After transferring the instruction in the storage position of the data, the finger shown the sequentially from which storage position Group - flop de -
Read the data and compare it with the above input data
Search control means for sequentially executing processing for searching for each card.

In the above, the hierarchy level is 2 or more. For example, if the hierarchy level is 3, the instruction data for instructing the storage location of the data in the first data input field of the group of the lowest hierarchy level is the middle hierarchy level. 2 and the instruction data of the highest hierarchical level are created in total.

[0014]

When data is input to any one of the items having a plurality of data input columns (eg, the nth data input column), the data is The data is stored in the (n-1) th storage position from the storage position indicated by the instruction data created so as to instruct the first (first) data input field of the item.

The data to be searched is input and the item name of an item having a plurality of data input fields or any data.
When a search command is issued with a cursor in the data input field,
The data is read out in order from the storage position designated by the designation data created to designate the data input column at the head of the item, and is compared with the data to be searched. Also, this processing is executed by changing the card in order.

[0016]

EXAMPLES Examples of the present invention will be described below. FIG. 1 shows a state in which the style of the card is displayed, and each symbol in parentheses is
The data to be entered in the data entry field in which the code is described is shown in correspondence with FIG. 6 (and FIG. 12 = conventional memory map).

As shown in FIG. 1, this card is a delivery slip, and the item names are "delivery destination", "consumption tax", and "total".
"Product name", "Unit price", "Quantity" and "Amount" are provided.
As described above, one data entry field is associated with each of the "delivery destination", "consumption tax", and "total", and the "product name", "unit price", "quantity", and "amount" are: Four data input fields are associated with each.

As shown in FIGS. 2 and 6, the "delivery destination" mentioned above.
The hierarchical level of the storage position of the data (a, f, g) to be entered in the respective data input fields of "consumption tax" and "total" is "0". In addition, the data (b1, b2, ..., e) that should be entered in the respective data input fields of the above "product name""unitprice""quantity""amount"
The hierarchical level of the storage location of 3, e4) is "1". In addition, each data (b, c, d, e) in Fig. 2 is the above "product name""unitprice".
Hierarchical instruction data created to indicate the storage location of the data (b1, c1, d1, e1) that should be entered in the data input fields at the beginning of "quantity" and "amount". The level is "0".

This apparatus has a keyboard, a display and a printer as shown in FIG.
It has a document editing unit, a processing unit, and a RAM. The document editor
It has a document editing function of a general Japanese word processor, and further has a database editing function. this is,
Design of card style (input style, output style), definition of item name, data input, data type (character, number, logic,
It is a function to define (date etc.).

In the processing section, the card designed in the document editing section is used.
Processing to store the card style in the card image of RAM,
On the contrary, the mode of the card is read from the card image in the RAM and displayed on the display or printed out from the printer. The car
The mode of the card is stored separately from the data of each card, and is synthesized according to the definition at the time of output.

Further, in the processing section, the processing of storing the data inputted in the card-style data input field in the document editing section in the card data of the RAM and the input in the document editing section Corresponding to the totalization and retrieval performed, the data is read from the card data in the RAM and the processing of totaling and retrieval is performed.

Of the processing executed by the processing section, the processing at the time of data input and the processing at the time of data search will be described below in accordance with the flow chart with reference to the memory map. .

* Processing at the time of inputting data: FIGS. 7 and 8 As a specific example, when the cursor is placed in the second "data input field" of the item "product name", the data "TV" is displayed. −
The case of inputting data will be described.

The data "TV" input from the keyboard is stored in the input data buffer (S101). The current card buffer stores the currently selected card (first card = card number 0, see FIG. 4) (S103). On the other hand, the current item buffer is
The sol position item number 1 (see FIG. 5) is stored,
The line number 1 at the cursor position is stored in the current line buffer (see FIG. 6).
Is stored (S105).

In this state, when the pressing of the key for instructing the end of the input is detected (S107; YES), the level counter indicates the hierarchical level 1 (FIG. 5) of the item number 1 stored in the current item buffer. (Reference) is substituted (S111). In the address buffer, the absolute address of the card number 0 stored in the current card buffer (the address indicating the head of the first card data) is stored in the current item buffer. The value to which item number 1 is added is stored.
In other words, the address buffer stores the address of the second data (b) of the first card in FIG. 6 (S11).
3).

Next, the data of the address designated by the address buffer (data (b) of FIG. 6) is read (S12).
1). Since the level counter is 1 at the beginning (S123; NO, see S111 above), the process proceeds to step S125, where the relative address of the second data (b) of the first card in FIG. 6 is an absolute address. Address converted to (in this case, the first data (b
The address 1) is stored in the address buffer. Further, the level counter is decremented (S127).

Next, step S121 is executed again to delete the data.
Data is read. In this case, the address of the head data (b1) of the product name has no data. It should be noted that this processing is based on the assumption that the data structure has three or more hierarchical levels. Next, the level counter is determined, and this time, the process proceeds to step S131 and thereafter.

First, an address obtained by adding the line number 1 (see S105 above) of the current line buffer to the address stored in the address buffer (the address of the head data (b1) of the product name), in other words, the product name. The data "television" (see S101 above) stored in the input data buffer is stored in the address of the second data (b2) of the above (S131).

After that, the number of item name data at the position of FIG. 6B is corrected so as to increase by 1 (S141). Also, the unit price,
Each relative address of each head data of quantity and amount (Fig. 6)
The data (c) to (e)) are corrected (S143). Here, if the storage position of the head data (b1) of the product name is blank before the storage of the data "TV", the number increased by the correction is 2. Further, if the data is already stored in the storage position of the head data (b1) of the product name before the data "TV" is stored, the increment number by the correction is one.

Further, each absolute address of the card index data is corrected (S145). The number increased by this correction is also the same as in step S143 above. In this way, the processing at the time of data input is performed.

* Processing at the time of data retrieval: FIGS. 9 to 11 As a specific example, a cursor is placed on the item name of the item "product name" or the "data input field" corresponding to the item name. In addition, a case of retrieving data "TV" will be described.

In the current item buffer, the item number 1 (see FIG. 5) at the cursor position is stored (S201), and the data "TV" input from the keyboard is It is stored in the input data buffer (S203). In this state, when the search mode is set by inputting from the keyboard (S205; YES), the search item buffer stores the item number 1 stored in the current item buffer, The data "TV" stored in the input data buffer is stored in the search data buffer (S211).

Next, when the pressing of the key for instructing the start of the search is detected (S213; YES), the current card buffer is
The card number 0 which is the first card is stored (S221), and the card number 0 which is the first card of the current card buffer is stored in the search card buffer. Ru
(S223).

Further, in the level counter, the hierarchy level 1 of the item number 1 stored in the search item buffer (see FIG. 5).
(Reference) is substituted (S225). The address buffer stores the card number 0 stored in the search card buffer.
The value obtained by adding the item number 1 stored in the search item buffer to the absolute address (the address indicating the beginning of the first card data) is stored (S227). Thus, the address buffer stores the second data of the first card in FIG.
The address of data (b) is stored.

Next, the data of the address designated by the address buffer (data (b) of FIG. 6) is read (S23).
1). Initially, the level counter is 1 (S233; NO, refer to S225 above), so the flow proceeds to step S235, and the relative address of the second data (b) of the first card in FIG. Address converted to (in this case, the first data (b
The address 1) is stored in the address buffer. Further, the level counter is decremented (S237).

Next, step S231 is executed again to delete the data.
Data is read. In this case, the leading data (b1) of the product name is read. It should be noted that this processing is executed so as to be applicable to the case where the data structure has three or more hierarchical levels. Next, the level counter is determined, this time
Proceed to step S241 and subsequent steps.

First, in step S241, 0 is assigned to the row counter. Next, the processes of steps S251 to S259 are executed. This processing is performed by each data of "Product name" (b1, b2,
b3, b4) is a process for sequentially comparing the data "television" stored in the search data buffer.

First, the count value of the row counter is set to the address of the address buffer (the initial value is 0 substituted in S241).
The data of the address (the address of the first data b1 of the product name for the first time) designated by the value added with is read and the comparison data
Stored in the data buffer (S251). Next, the data in the comparison data buffer is compared with the data "TV" stored in the search data buffer (S253).

As a result of the comparison, if they match (S255; YES), that is, if the desired data is retrieved, a process for outputting the retrieved data is performed (S261). . on the other hand,
If they do not match, the row counter is incremented (S257), and the processes of steps S251 to S255 are performed again.
As a result, the second data b2 of the product name in FIG. 6 is read and compared in the same manner.

Thus, each data (b1, b2, b) of the product name in FIG.
(3, b4), when the comparison with the search data "TV" is completed (S259; YES), the next card is stored in the search card buffer in order to perform the same search processing for the next card. The mode number is stored (S271). Then, for the next card, the processes of steps S225 to S259 are executed in the same manner as above. Even if the search processing for all the cards is completed, if the corresponding data is not found (S273; YES), an output to that effect is output (S281). In this way, the processing at the time of data retrieval is performed.

[0041]

As described above, in the present invention, the concept of the hierarchical level is introduced to the storage position of the data, and the storage positions are grouped in level units, and the storage position of the lower level is used for data input and retrieval. (When instructing an item having a plurality of data input fields), the instruction data stored so as to instruct the lower level is stored in the upper level. . That is, a plurality of data corresponding to the same item
By grouping the data input fields into groups, creating data for collectively instructing the groups, and storing it in the upper hierarchy of the group, the data for instructing the relevant items can be obtained. Cardboard
The storage position in the data is unchanged regardless of the number of data input fields of the item.

For this reason, the card format can be reduced to the processing time such as totalization and retrieval while keeping the format suitable for business convenience. Further, the capacity of the memory can be small as compared with the case where each file of the required output format is created.

[Brief description of drawings]

FIG. 1 is a diagram showing a card format of an example.

FIG. 2 is a diagram showing a hierarchical structure of data.

FIG. 3 is a block diagram showing a configuration of an apparatus according to an embodiment.

FIG. 4 is a memory map of a card data index.

FIG. 5 is a memory map of definition data.

FIG. 6 is a memory map of card data.

FIG. 7 is a flowchart showing a part of the processing at the time of data input.
To.

FIG. 8 is a flowchart showing the rest of the processing when data is input.
To.

FIG. 9 is a flowchart showing a part of the processing at the time of data retrieval.
To.

FIG. 10 is a flowchart showing a part of the processing at the time of data retrieval.

FIG. 11 is a flowchart showing the rest of the processing at the time of data retrieval.

FIG. 12 is a memory map of conventional card data.

Front Page Continuation (72) Inventor Kanji Toyokura 2-18 Keihan Hondori, Moriguchi City, Osaka Sanyo Electric Co., Ltd.

Claims (1)

[Claims] 1. The data of the currently selected card is combined in a card format having an item name and one or more data input fields corresponding to each item name. A display control means for displaying on the display, and a hierarchy level storage means for storing the hierarchy level of each group with the item name and the data input field corresponding to the item name as a group, The item name indicated by the cursor or the hierarchical level of the group to which the data input field belongs is stored in the counter as the hierarchical level of the data storage position of the data input field included in the group. By setting and counting the counter each time the data in the memory is read, the hierarchy level indicating means for moving the instruction to the relevant hierarchy level and the top data of the group whose hierarchy level is not the highest level. Instruction data for instructing the storage location of data in the data input field Is created for each of the above groups, and an instruction data creating means for setting the storage position of each instruction data to an upper hierarchical level and a storage position having the same hierarchical level are consecutive in the memory. Then
Further, a storage position control means for controlling the storage position of the data in the memory and an input mode so that the storage positions of the respective data in the data input fields of the same group are continuous in the memory. When the data is input in the mode, if the hierarchical level of the group to which the data input field specified by the cursor belongs is not the highest level, the group is created for that group. In accordance with the instruction data, the instruction is moved to the data storage position of the head data input field of the group, and the order from the storage position is from the head data input field. An input control means for storing the input data in the designated storage position after moving the designation to the storage position which is the same as the order up to the data input field designated by the cursor , Item name specified by the cursor when data is entered in the search mode When the hierarchical level of the group to which the data input field belongs is not the highest level, the data input field at the head of the group is in accordance with the instruction data prepared for the group. After the instruction is moved to the storage position of the data, the data of the group is sequentially read from the instructed storage position, and the same data is compared with the input data. A card-type data base apparatus having: search control means for sequentially executing a searching process for each card.