JPH0391042A - Card type data base mechanism - Google Patents

Abstract

PURPOSE:To improve efficiency when data are transferred from quotation side data base to the data of a card under an input by displaying the picture of a table for the item names of collation candidates, selecting and designating the plural collation items in the input side data base from the table. CONSTITUTION:According to the operation of a keyboard KBD 22 by a user, for example, the introduced picture of card redesign is displayed on a liquid crystal display LCD 24. When the 'set of other file quotation item' is designated on this picture, at first, based on the information of a data base name management file 17 stored in a data base name management table 15 on a main memory 12, a CPU 11 displays the table, which is previously set at the time point, concerning the other file quotation item, etc., of the file, which is presently opened, on the LCD 24. In a state that the table for the collation candidate item names is displayed, the user moves a cursor to a position, where the objective item name is displayed, by the key operation of the KBD 22, selects and designates the plural collation item names from the table for the collation candidata item names. Thus, the efficiency is improved for transferring and inputting the data from the quotation side data base to the card data under the input.

Description

DETAILED DESCRIPTION OF THE INVENTION [Object of the Invention] (Industrial Application Field) The present invention relates to a card-type database mechanism having a function of quoting other files and managing data using card images.

(Prior Art) In the field of data processing, cards are often used as a unit of recording. Therefore, in recent years, database mechanisms have been developed that allow data management to be performed in the same way as using this type of card. This database mechanism is generally called a card-type database mechanism.
``Card design'', ``Card redesign'', ``Card human power (
It has various functions such as data input) and quoting other files.

The above-mentioned other file citation function in the card-type database mechanism is to search for a card whose matching item data of the card currently being input matches the matching item data of another file (quoting file, quoting database), and to find a match. This is a function that manually transfers (manually) the data of the item cited by the card (transfer source item) to the specified item (transfer destination item) of the card being input. Other file citation functions include:
This is convenient because the data of the already registered card can be used effectively. Conventionally, the above-mentioned verification items used to realize the other file quoting function are one item per card for both the input side database and the quoting side database, and therefore the posting destination item and the posting source There was also one item for each item.

Now, conventionally, the above-mentioned quoting database was generally specified as follows. That is, first, a list of database names that are citation candidates is displayed on the screen. In this state, the user performs a key operation to select and designate a desired database name as the quoting side from the list of citation candidate database names.

(Problem to be solved by the invention) As mentioned above, in the past, the other file citation function was used as a condition for manually transcribing data from the quoting database into card data (unit for one database) manually. The number of verification items to be checked was one for each card in both the input-side database and the quotation-side database. However, depending on the content of the card layout, by setting multiple check items in the input database, data can be transferred from multiple items in the quoting database to corresponding items in the input database. However, if you set only one check item in the input database for each card as in the past, it is not possible to use the data of already registered cards efficiently. There was a problem that it could not be used effectively.

Furthermore, conventionally, when specifying a quoting database, a list of database names that are citation candidates is simply displayed on the screen. There was a problem in that it was not possible to determine at a glance whether or not there was a database, and the selection and designation of the quoting database was inefficient.

This invention was made in view of the above circumstances, and its purpose is to enable setting of multiple check items in the input side database for one card, thereby making it easier to input data from the quoting side database to the card data being input. The object of the present invention is to provide a card-type database mechanism that can improve efficiency.

Another object of the present invention is that when specifying a citing database, candidates for collation items included in the database to be selected and specified are displayed on the screen together with a list of database names that are citation candidates. The object of the present invention is to provide a card-type database mechanism that allows efficient selection and specification.

[Structure of the Invention] (Means for Solving the Problems) The present invention provides for selecting a maximum of n (n is n) desired candidates as matching items from a list of matching candidate item names displayed on the screen as matching item candidates in the input database. an integer of 2 or more) for selecting and specifying a first collation item; and a quoting side for selecting and specifying a desired candidate as a quoting database from a list of citation candidate database names displayed on the screen as candidates for the quoting database. database selection designation means;
From among the matching item candidates of the citing database selected and specified by this citing database selection and specification means,
A second verification item selection and specification means is provided for selecting and specifying the only verification item corresponding to the maximum n verification items of the input database selected and designated by the first verification item selection and designation means. . Further, the present invention provides provisional designation means for provisionally designating one of the candidates on the list of citation candidate database names in the quoting side database selection designation means, and collation of the database provisionally designated by the provisional designation means. The present invention is characterized in that item candidates are displayed on the screen together with the list of citation candidate database names as a list of collation candidate item names.

(Operation) According to the above configuration, the input side database σ) displays a list of matching candidate item names indicating matching item candidates on the screen, and selects the matching items of the input side database from the list on the card 1.
Since a plurality of cards can be selected and specified, it is possible to improve the efficiency of data transfer input from the quoting database to the card data being input.

Furthermore, according to the above configuration, when one of the candidates on the list of citation candidate database names is provisionally designated, the candidates for the matching item of the temporarily designated database are added together with the list of citation candidate database names as the list of matching candidate item names. This will be displayed on the screen, so the user can refer to the list of matching item names and enter the term E1/(
・You can easily check whether or not the i is inserted.

(Embodiment) FIG. 1 shows a block configuration of a card play database mechanism according to an embodiment of the present invention. The card-type database mechanism shown in FIG. 1 is realized by a word processor, a personal computer, etc., and will be explained here using a word processor as an example. In the figure, ti is a CPU forming the control center of the card type database mechanism, and 12 is a main memory. The main memory 12 stores "card design", "card redesign", which the card type database mechanism has.
"Card input (data manually)", "Citation of other files"
A database program 13 necessary for realizing various functions such as the above is placed. The main memory 12 also includes a human database information storage buffer 14 that is used to store information (human database information) about the database that is currently being input (files that are currently open), and information about a database name management file 17 that will be described later. An area such as the database name management table 15 where the information is set is secured.

16 is a storage medium used for storing database information, etc.;
For example, 17 is a database name management file stored on a floppy disk (FD). This database name management file 17 is for managing the database names of all databases stored in the FDlB, and is placed on the FDlB. t8 is F
Among the databases stored in FDlB, information on the human database (input database information), 19 is information on the databases cited in the database being inputted above among the databases stored on FDlB (citation database information) It is. F D ll'i
Each database stored in is managed by being divided into files for each data type, including a file for card layout data (card design data) that defines the layout of the corresponding card, and a file for managing the registration status of the card. Card management data files, card data files that are the actual data part of the card, and index items for each card! 'jf' (J-M.

It consists of files of sales item data (index item data), etc.

20 is a floppy disk drive (FDD) for performing operations necessary for read/write access to the FDIG, such as driving the loaded FD1B, determining the head h and K, etc.
), 21 is a floppy disk controller (FDC) that controls the FDD 20 in response to requests from the CPULI. 22 is a keyboard (KBD) with various character keys and function keys (including kana-kanji conversion keys).
, 23 is a keyboard control device that provides an interface between the CPU II and the KBD 22 and controls input from the KBD 22. 24 is an output device for displaying card data (card image), a list of collation item names, etc., such as a liquid crystal display (LCD); LCD
This is a display control device that performs display control for 24.

FIG. 2 shows the file structure of the database name management file 17 placed on the FD1B. This database name management file 17 contains management information for managing all the corresponding FD1Bs, database names assigned to each database stored in the FD1B, and databases cited in each of the above databases (citation file). , other files) (other file citation information), etc. The above management information is FD
Contains detailed information (in this case, 8-bit configuration) for each database stored in IB, and its specific bit (
Here, bit 0) is used to indicate whether an index item is set in the corresponding database.

The arrangement of detailed information for each database matches the arrangement of database names in the database name management file 17.

As shown in Figure 2, the above other file citation information includes a citation file NQ for identifying a citation database (citation file), a key item IDNQ for identifying a collation item (key item) of a citation file, etc. and information on each item of the own file (open file). The information for each item includes the ID number for identifying the item (
) consists of open file side information set corresponding to the open file side information and other file side information. Open file side information indicates whether the corresponding item is a verification item on the open file side (input side) (in the case of FFH, the H at the end indicates hexadecimal expression), or whether it is a posting destination item (other than FFH or OOH). ) or is an unconfigured item that is neither of these (
(in the case of OOH). Open file side information is FF
H.

If the value is other than 00H, the setting information indicates the IDk of the corresponding open file side verification item. Next, the other file side information is the item on the other file side that the corresponding item (open file side item) quotes, that is, the transcription source ring g (quoting item)
1D No. (other than OOH), or indicates that it is an unset item (in the case of OOH). Therefore, in the example shown in Figure 2, ID No. is used as a verification item on the open file side.
, 2 and 6 are set, and the transfer destination item with ID No. 2 as the oven file side verification item is ID No. 3, IDNa.

The posting destination item with 6 as the oven file side verification item is I.
D No. 5. In addition, in the example in Figure 2, IDN
The transcription source item corresponding to the transcription destination item o, 3 is the ID No. 1 item of the other file, and the transcription source item corresponding to the transcription destination item ID No. 5 is the ID k of the other file.
This is item 2.

Next, the operation of the configuration shown in FIG. 1 will be described with reference to FIGS. 2 and 3 to 12, taking as an example the other file citation item setting process necessary to realize the other file citation function. In addition, FIG. 3 is a flowchart showing the processing procedure for setting other file citation items, FIG. 4 is a flowchart showing the procedure for trust database name selection processing in the other file citation item setting processing, and FIGS. 5 to 12 are flowcharts showing the processing procedure for setting other file citation items. FIG. 6 is a diagram illustrating an example of a display screen related to quotation item settings.

Information on the database name management file 17 registered in the FDIB loaded in the FDD 20 is now stored in the database name management table i5 on the main memory 12, and information on the open database (card type database) is stored in the database name management table i5 on the main memory 12. (input database information 18 here) is input database information storage buffer 14 on main memory 12.
Assume that it is stored in .

In such a state, for example, the card redesign introduction screen is displayed on the LCD 22 according to the user's operation of the KBD 20.
is displayed, and when "Setting other file citation items" is specified on this screen, the CPU II first downloads the database name management file shown in FIG. 2 stored in the database name management table 15 on the main memory 12. 17 (more specifically, other file citation information regarding the currently open file in the database name management file 17), other files of the currently open file that have already been set at that point. A list of cited items etc. is displayed on LCD2 as shown in Figure 5.
Display on 4. The example shown in FIG. 3 is a case where the name of the currently open file is "sales slip" and the cited file name is "list of sales items." Then, when "citation item setting" is selected and specified on the screen shown in Figure 5, the CPU
11 is the file currently open (input database)
A list of item names is displayed on the screen as a list of matching candidate item names (for example, the item names are arranged in the order of the line digits of the card design) as shown in FIG. 6 (step 10 in FIG. 3). Here, items that have already been set as verification items (i.e., IDN0 whose open file information is FFH among other file citation information regarding the currently open file)
．． The item name (product number A in the example in Figure 6) is
It is highlighted to indicate this.

The user moves the cursor to the display position of the desired item name by operating the KBD 22 key while the list of matching candidate item names is displayed as shown in FIG. 6, and presses the Select/Execute key. As a result, the CPU II selects the item name where the cursor is located as the collation item name of the currently open file, and displays the item name in reverse video (Step S1 in Figure 3).
2). Then, the CPU II will not complete the selection of verification items (in this case, unless there is a combination operation of the [Function 1] key, which is a predetermined function key, and the [1] key, which indicates the number 1).
, the selected collation item name is stored in a predetermined area on the main memory 12 (step S14.S in FIG. 3), and the next selection process (step 512 in FIG. 3) is entered. Here, it is assumed that the item "product number B" has been newly selected as the verification item.

In this embodiment, it is possible to select and specify a plurality of matching item names from the matching candidate item name list shown in FIG.

Therefore, if multiple verification items are required for the file in the oven, the user should specify the desired item name with the cursor and press the [Select/Execute] key.Repeat the operation for all the required item names. . Each time the [Select/Execute] key is pressed, the CPU II selects the item name at the cursor position and stores it as the collation item name. When the user has finished selecting and specifying all the desired item names, the user presses the [Function 1] key and the [1 Cokey]. This allows C.P.
The UII determines whether the process for selecting the collation items of the open file is complete (step 514 in FIG. 3) and proceeds to the process for selecting the citation database name (citation file name) (step S18 in FIG. 3). This citation database name selection process is performed as follows according to the flowchart of FIG.

First, the CPU II refers to the detailed information for each database set in the management information of the database name management table 15 on the main memory 12 and checks whether an index item (verification item) is set (step 540 in FIG. 4). ). C
Based on the contents of the database name information block on the database name management table 15, PUII identifies the database name (file name) corresponding to the above detailed information with index item settings, excluding files in the oven. According to the same database name, the matching item information of the corresponding database is read from the FD 16 (step 542 in FIG. 4).
). Next, the CPU II generates a list of database names with index item settings, excluding the files in the oven identified in the process of step S42, as a list of citation candidate database names (for example, arranged in JIS code order) as shown in FIG. is displayed on the screen (step 44 in FIG. 4). At this time, CP
The UIL is where the cursor is located (the initial cursor position is the first database name when designing a new card, and the name of the database being set when redesigning a card as in this example). A list of matching candidate item names of the database having the database name is also displayed (step 84B). The screen shown in FIG. 7 shows a case where "Sales item list" has already been set as the citation database for the file in the oven whose database name is "Sales slip".

Now, in the screen display state shown in Fig. 7, the user selects KBD.
When the up/down/left/right keys (cursor movement keys) on 22 are operated and the CPU II detects this (step S48.550 in Figure 4), the CPU II moves the cursor according to the operation details (Figure 4). Step 552).

The CPU II then returns to step 54fi and switches the currently displayed list of matching candidate item names of the database to the list of matching candidate item names of the database having the database name "l2" where the moved cursor is located. By referring to this collation candidate item name list, the user can select an item to be collated in the database with the database name where the cursor is currently located, that is, the database name that is being selected (temporarily specified). You can recognize at a glance whether or not it is included. If the target item is included in the currently displayed collation candidate item name list, and therefore the corresponding database (the database with the database name where the cursor is currently located) is used as the citation database (citation file). If desired, the user presses the [Select/Execute] key. In this case, the CPU (
(Selects the database name at the cursor position as the cited database name (quoted file name), highlights the same database name, and rewrites the cited file name in the file citation information for other files in the oven on the database name management table 15. (Figure 4 Step S54. 558
), the citation database name selection process ends. Here, since the already set file name "Sales item list" has been selected and specified again, the cited file number in the other file quotation information of the file in the oven with the file name "Sales slip" remains unchanged.

When the CPU II finishes the citation database name selection process shown in the flowchart of FIG. 4, that is, when step 318 of FIG.
The screen is displayed as shown in the figure (Step S20 in Figure 3).
). At this time, the CPU II displays a cursor at the beginning of the candidate verification item name if a new card design is being designed, and if the card is being redesigned as in this embodiment, the cursor is displayed at the item name currently set as a verification item. Display. The user moves the cursor in the screen display state shown in FIG. 8, specifies the item name of the item to be checked, and presses the [Select/Execute] key. As a result, the CPU II selects the item name at the cursor position as indicating the only reference item A in the citation database, and selects the key item IDNQ of the citation file in the file citation information for other open files on the database name management table 15. , name the column to the selected item name I
A verification item selection process is performed to rewrite the data to DNQ (step 522 in FIG. 3). Here, since the item name "Product number/month" that has already been set has been selected and specified again, the key item ID No. of the cited file in the file quotation information other than the file in the oven whose file name is "Sales slip"
, remains unchanged.

When the CPU II completes step S22, it displays the transfer destination item selection screen shown in FIG. 9 and performs a transfer destination item selection process (step '24). On the screen shown in FIG. 9, all the item names of the file in the oven are displayed, for example, in the order of the line digits of the card design. Also, if the collation item name (on the open file side) used for collation for posting to that item has already been set, that item name will be used in other files that are also quoted (transcribed) to that item. If the item name (transfer source item name) has already been set, that item name is displayed in association with the item name that is a candidate for the transfer destination. The collation item name and transcription source item name are obtained from the information of each item in the other file citation information of the open file (see FIG. 2).

The user moves the cursor up and down in the screen display state shown in Figure 9 to specify the item name of the item to be the posting destination item, and
Press the [Select/Execute] key. As a result, CPU II
The item name at the cursor position is selected as the transfer destination item name and temporarily stored in a predetermined area on the main memory (2).

When the CPU II completes the above posting destination item selection process,
The verification item setting screen shown in FIG. 10 is displayed, and the verification item setting process for the human database (open file, own file) is performed (step 826). The screen in FIG. 10 shows a case where "Product Name B" is selected as the transfer destination item on the screen in FIG. 9, and all collation items selected on the screen in FIG. 6 are displayed. The user moves the cursor up and down in the screen display state shown in Figure 10, and selects the matching item name for the posting destination item selected on the screen shown in Figure 9 (i.e., the name to be used for matching for posting to the posting destination item). Verification item name)
, and press the [Select/Execute] key. This allows C.P.
The UII selects the item name at the cursor position as the collation item name. At this time, the CPU 11 searches the database name management table 15 for collation item (key item ), and the ID corresponding to the posting destination item name selected in the previous step S24.
Oven file side information unique to No. is set to IDNa corresponding to the selected collation item name.

When the CPU II completes the verification item setting processing described below, it displays the transcription source item (quoted item) setting screen shown in FIG. 11, and performs transcription source item selection processing (of the citation database) (step 828). ).

The screen in Figure 11 shows the case where "Product number B" is selected as the verification item for the posting destination item "Product name B" on the screen in Figure 10, and the posting source item in the citation database (citation file) Suggestions will be displayed. These transcription source item candidates are displayed, for example, in the order of line digits of the card design. At this time, item names whose data types (character string data/numeric string data) are different from those of the transfer destination item are not candidates for the transfer source item and are not displayed. The user is the first
In the screen display state shown in Figure 1, move the cursor up and down r,..., thousand...
j, : to specify the name of the posting source item for the posting destination item 1 selected on the screen of FIG. 9, and press the [Select/Execute] key. Thereby, the CPU II selects the item name at the cursor position as the transcription source item name. At this time, the CPU II searches the database name management table 15 for the '''IDN that corresponds to the transfer destination item name selected in the previous step S24 among the other file citation information regarding the file being opened.
Other file-side information specific to o is set to ID No. corresponding to the transcription source item name selected above.

When the CPU II completes the above transcription source item selection process,
Manual key to instruct the end of all settings ([Function 1] + [
1] Manual input of the key) is not performed, it is assumed that the setting is not completed (step 530), a transfer destination item selection screen similar to that shown in FIG. 8 is displayed, and the transfer destination item selection process of step S24 is performed again. In this example, the previous step S24
"Product name B" is selected as the posting destination item in step S26, "product number B" is set as the verification item in step S26, and "product name" is selected as the posting source item in step 328. From this, the transfer destination item selection screen becomes as shown in FIG.

Above step S24. A series of processes consisting of S2B and S28 are repeated, and a pair of posting destination item and posting source item is selected for each of the collation items of several input side databases, and the input of the [Function 11 + [1] key When this is done, CPUI! determines that all settings have been completed and ends the other file citation item setting process. At this time, the CPU
I is database name management table 1 on main memory 12
The database name management file 17 on the FDIS is updated according to the contents of 5.

In the above-described embodiment, the desired item is selected by moving the cursor, but it is of course possible to select the desired item by operating the numeric keypad.

[Effects of the Invention] As detailed above, according to the present invention, a list of matching candidate item names indicating candidates for matching items in the input end database is displayed on the screen, and a matching item in the input end database is selected from the list. You can select multiple items for one card, so
Efficiency is improved when transferring data from the quoting database to the card data being input.

Further, according to the present invention, when one of the candidates on the list of citation candidate database names is tentatively designated, the candidate collation item of the temporarily designated database is displayed on the screen together with the list of citation candidate database names as a list of collation candidate item names. By referring to the list of matching item names above, the user can check at a glance whether or not the database that has been provisionally specified (that is, the one that will be selected and specified) contains the item to be used as a matching item. This makes it possible to efficiently select and specify the quoting database.

[Brief explanation of drawings]

FIG. 1 is a block diagram of a card-type database mechanism according to an embodiment of the present invention, FIG. 2 is a diagram showing the file structure of a database name management file, and FIG. 3 is a diagram showing the processing procedure for setting other file citation items. FIG. 4 is a flowchart showing the procedure of the citation database name selection process in the other file citation item setting process, and FIGS. 5 to 12 are diagrams showing examples of display screens related to other file citation item setting. DESCRIPTION OF SYMBOLS 11... CPU512... Main memory, 13... Database program, 15... Database name management table, 16... Floppy disk (FD), 1
7...Database name management file, 22...Keyboard (KBD), 24...Liquid crystal display (LCD)

Claims (3)

[Claims] (1) Data is managed using card images. It searches for cards whose verification items of the card being input match the verification items of the quoting database, and then displays the data of the pre-specified transcription source item of the matching card. In a card-type database mechanism that has a file citation function that transfers data to the pre-specified transfer destination item of the card being input, select the desired name from the list of matching candidate item names displayed on the screen as matching item candidates in the input database. a first verification item selection and specification means for selecting and specifying a maximum of n candidates (n is an integer of 2 or more) as verification items; and a desired candidate from the list of quotation candidate database names displayed on the screen as candidates for the quotation side database. a quoting database selection and designation means for selecting and designating the quoting database as the quoting database, and selecting the first verification item from among the verification item candidates of the quoting database selected and designated by the quoting database selection and designation means. a second verification item selection and designation means for selecting and specifying the only verification item corresponding to the maximum n verification items of the input database selected and designated by the designation means, the verification item of the input database being selected and specified; A card-type database mechanism characterized in that multiple settings can be made for one card. (2) The above-mentioned quoting database selection and specification means has a temporary specification means for temporarily specifying one of the candidates on the above-mentioned list of citation candidate database names, and collation of the database tentatively specified by this temporary specification means. 2. The card-type database mechanism according to claim 1, wherein item candidates are displayed on the screen as a list of collation candidate item names together with the list of citation candidate database names. (3) It is characterized by further comprising a transfer destination/transfer source item designation means for specifying a transfer destination item of the input side database and a transfer source item of the quoting side database for each collation item of the input side database. A card-type database mechanism according to claim 1 or 2.