JPH0991359A - Method and device for designing physical file - Google Patents

Abstract

PROBLEM TO BE SOLVED: To efficiently design data items and automatically generate physical files by specifying data items of each determined physical file according to the data items of an input/output screen and an output document and adding necessary information to the respective specified data items. SOLUTION: Screen/document images 1 and 2 are registered in a computer interactively (3) and data items are extracted from the registered screen/ document images 1 and 2. All the extracted data items 5 by the screen/document images 1 and 2 are put together and necessary data items are added to generate a data item dictionary (6 and 8). Then a physical file is determined and data items of each determined physical file are specified according to the data items of the input/output screen and output document. Further, necessary information is added to the respective specified data items to complete physical file designs 11 and 12.

Description

Detailed Description of the Invention

[0001]

[0001] The present invention relates to a computer
The present invention relates to a physical file design method for efficiently creating a physical file of a system, and an automatic physical file design device.

[0002]

2. Description of the Related Art In general, system development involves research / analysis.
Requirement definition → It is performed according to the flow of the design process, etc., but the requirement definition is to define the functions that the system should have.In addition to hardware design, the overall design of application programs and data items. Includes the design of.

[0003]

However, conventionally, it was very inconvenient because there is no device capable of efficiently designing screens, books and data items in the process of defining requirements. In addition, the physical file cannot be automatically generated, which is also a problem. The present invention has been made in view of these problems, and it is an object of the present invention to provide a physical file designing method capable of efficiently designing data items and automatically generating a physical file, and an apparatus thereof. And

[0004]

To achieve the above object, in the physical file designing method according to the present invention, an input / output screen and an output book table layout (screen / book table image) are interactively displayed on a computer. Registering and extracting data items from the registered screen / book table image,
All the data items for each screen / book table image that have been extracted are added together with the necessary data items to create a data item dictionary, and physical files related to each input / output screen and output book table. And specifying the data item of each determined physical file by the data item of the input / output screen or the output book, and the step of adding necessary information to each specified data item. Completed physical file design.

The effect of the present invention will be described below while specifying the present invention based on the schematic view of FIG. (A) In the present invention, the screen / book (user interface) is considered to be an important point in system construction, and the screen / book drawn by the system user in order to include all the requirements of the system user. A screen / book table image file is constructed based on the table layout (ST1). Since the registered screen / book table image is printed and can be visually checked as appropriate (ST2), it can be added or changed as many times as necessary (ST3). Also,
Since the screen / book table image list can be printed, it can be utilized as a management book table, and if necessary, the screen / book table image list can be printed for each subsystem.
In the conventional method, the system builder rough-sketches the screen / book table image and handwrites the screen / book-table image list, but according to the present invention, it is possible to eliminate the difficulty of handwriting rough sketch. At the same time, troubles such as omissions and mistakes in the screen / book image list are eliminated. In addition, in the conventional method, the work (washing out work) of transcribing the data items to another sheet from the rough sketched screen image or book table image was performed.
Again, problems such as omission of transcription and transcription errors occurred, but according to the present invention, at the time of creating the screen / book table image, all the data items used in the screen or book table are extracted. Since the troublesome cleaning work has been completed, there is no room for omission of transcriptions and transcription errors. There is an input screen at the start point of the data flow, and the end point is the book table or display screen. Therefore, even if data processing in the middle is taken into consideration, the data will not be displayed when the screen / book table image is finalized. Almost 95% or more of the items have been decided, and the method of the present invention is extremely effective.

(B, C) A data item that is supposed to be unique, for example, "customer code" is a numeric type of 7 digits on the "customer master maintenance" screen, and on the "order entry slip" screen. It is more or less experienced by system developers that the character type has 6 digits. Finding inconsistencies in data items is otherwise troublesome, and it is true that it may be discovered at some point in the development. Therefore, in the present invention, all the data items used in the application program are put together in one data (item) dictionary. In this data dictionary, for example, if any of "data digit number, data type, decimal digit, item name" is different, it is treated as another data item. Therefore, the data dictionary list (S
By T6) or the like, input mistakes of data items are surely extracted. In the present invention, the data item is determined through the above work, and the identification of the data item and the determination of the data item are distinguished. In addition, since the screens and book tables related to the modified data items are also output in a list,
You can understand at a glance which screen / book file should be modified (S
T9). By the way, the data dictionary must be easy to search as a dictionary. Therefore,
In the present invention, the data dictionary has three index entries. That is, "data item type code" used for large classification and "index I" used for middle classification
D "and" data item I added to each data item
D ”are provided (ST10 to ST11). Therefore,
In the application program, for example,
It is possible to easily search what data items are largely classified as “amount” and what data items are included in data items roughly classified as “code”. Also,
For example, it is possible to search for data items that are classified into "person code" and "customer code", and to subdivide data items that are classified into "code".

(D) In view of the fact that the screen and the book table are created based on some data files, in the present invention, after confirming the data items, the data file (particularly the data classification) is displayed from the screen or the book table. Called) (ST14
~ ST16). Specifically, all the data items picked up from the screen or the table are sorted according to the data classification (data file) in which they are supposed to exist. For example, in the case of "Purchase input screen",
"Supplier Master File" and "Supplier Input Transaction File" that should store input values are
Obviously necessary. Therefore, all the data items used in the “purchase input screen” are sorted into the above-mentioned two data classifications (files). Further, assuming a "purchase slip", for example, it is assumed that it is created by the "supplier master file" and the "purchase input transaction file", and all data items of the "purchase slip" are Distribute to each. If it is assumed that an application program is created only from the screen and the book table described above, the data items required for the data file have been completely determined at this point.

(E) Next, the original physical file design is performed based on the above-mentioned data classification (data file). However, at this stage, it suffices to set the data classification ID as a file ID, and add a record format ID and a field ID to each data file (physical file). At this time, if the field IDs are determined one by one as in the conventional method, the unique field ID cannot be given. For example, for the "supplier code", the supplier master file has "SRCD", and the supplier transaction file has "SICD". Sometimes. However, in the present invention, the above-mentioned problem is solved by automatically numbering the field IDs by utilizing the "data item ID" given to the data dictionary. For example,
Since there is only one "Supplier Code" in the data dictionary in the data dictionary, part of the "Data Item ID" of the only one "Supplier Code" and the "File ID" of the relevant physical file The field ID is always uniquely determined by combining with a part of ".

[0009]

BEST MODE FOR CARRYING OUT THE INVENTION Embodiments in which the present invention is realized by using AS / 400 system of IBM will be described more specifically below. FIG. 1 is an overall view showing a processing procedure, and shows a design procedure of a database file (physical file). 2 to 5 are menu development diagrams in each procedure and schematically show each processing content of the above (A) to (E).

( A) Creation of screen / book table image (1) For all screen images and book table images required by the system, first the system user (customer)
Ask them to make a rough sketch of the screen / book. 6 and 7 respectively show a screen image of "input order slip" and a book table image of "order detail table (by product)". In the present invention, the system user designates the screen layout and the book table layout, so that a user interface that best matches the actual situation of the customer can be realized.

(2) Next, the system designer, while looking at the screen / book table layouts in FIGS. 6 and 7, determines the skeleton by assuming the processing contents that best match the input screen and the output book table. . Further, the record format and the like are entered in the screen / book table layouts of FIGS. 8 and 9 show a state in which necessary information is entered. The screen image of "order entry slip input" has a screen image ID of "JU0".
"1010D", the skeleton used is "ET010", and the book table image of the "order details table (by product)" has the book table image ID "JU01010P" and the skeleton used "LT020". . Here, the skeleton is a program of the skeleton part that realizes each of the classified processings by classifying all the processings required by the application program into 34 typical processings (special (See Japanese Patent Application No. 7-26186). In this example, the skeleton “ET010” is selected for the input process of the order receipt, and the skeleton “LT020” is selected for the printout of the order detail table (by product). This is as shown in FIG. For convenience of explanation, the screen image I for the input screen image of “Customer Master Maintenance” is also displayed.
D "JM00001D", used skeleton "MM01"
It has been determined to be "0". FIG. 12 shows an outline of processing of the skeleton “MM010”.

(3) Subsequently, the system designer performs "screen image creation (SAGC520)" shown in FIG.
Select "Create book table image (SAGC 510)" and register the information of FIGS. 8 and 9 in the "screen image file" or the "book table image file". 13 to 25 show a procedure of calling "create screen image (SAGC 520)" and registering the screen image of "input order slip" shown in FIG. Explaining below, in the initial screen of FIG. 13, screen image ID "JU
Enter "01010D" and press the Enter key (Fig. 14),
Screen name "Order entry input" and skeleton "ET010"
Is input (FIG. 15). When the function key F9 is pressed in the state shown in FIG. 15, the state shown in FIG. 16 is obtained, so "10" is input and the execute key is pushed. Then, the entered "10"
Since the operation mode changes to "fixed character layout" in response to (Fig. 17), enter "order slip number .:" and press the execute key. Then, when the cursor is set at the head position where the character string is to be arranged and the execute key is pressed, the state shown in FIG. 18 is obtained. When "01" is input and the execute key is pressed in the state of FIG. 18, the state of FIG. 19 is obtained, so "input / output classification""data item name""data item digit number""datatype""decimal digit number , ”And then press the Enter key. As a result of this processing, the data item name of the part following the character string "Order slip No .:" is "Order slip No."
In addition, it is specified that the data is an "S" type 6-digit data (FIG. 20).

When the screen image is completed in the same manner according to the layout shown in FIG. 8, the state shown in FIG. 21 is obtained. Then, when the function key F9 is pressed to register the data, the state shown in FIG. 22 is obtained, but in this example, the skeleton has been determined, so the optimum value is displayed. Since the state of FIG. 23 is reached in which the function key F9 is pressed in the state of FIG. 22, the name (in this example, “key input screen”) and the number of lines (in this example, the first row to the fifth row) are pressed for each record format. Line) and press F9 (Fig. 23). In addition,
The process shown in FIG. 23 is repeated by the number of record formats. In this example, the “header input screen” and the “total display screen” are displayed.
Similar operations are performed on the “detail input screen”, the “function key display screen”, and the “message display control screen”. Then, the state of FIG. 24 is entered, and the information set in FIG. 23 is confirmed. Next, press function key F9
Then, the display procedure determined by the skeleton “ET010” is displayed. Then, if the function key F9 is pressed in this state, the registration process of the screen image of "order slip input" is completed. For registering the book table image of the "order specification table (by product)", "book table image creation (SAGC 510)" shown in FIG. 2 is used, but the processing content is almost the same as that described above. Further, with respect to the input screen image of "customer master maintenance", necessary data is registered by following the same procedure as in the case of "input order slip" described above.

(4) By the above processing, the "screen image file" and the "book table image file" are constructed. Also, only variables are extracted from the input screen image or book table image, and a collection of data items is created.
It is saved as a "data item file" in screen / book table image units. Here, the variable is a term corresponding to a fixed value, and refers to a portion whose value changes according to processing. For example, in FIG. 21, “order slip No .:” from the 10th digit of the third line is a fixed value, and “ZZZ
"ZZ9" is the variable. After the "screen / book table image file" is constructed, "print screen image (SALC510)" and "print book table image (SAL
C520) ”can be used to confirm the input value. That is, since the screen / book table image can be confirmed as shown in FIGS. 26 to 28, any deficiency can be immediately detected and corrected. Note that, if necessary, the "printing of sample book (SALC520)" shown in FIG.
It is also possible to print a sample "order list (by product)" such as. In addition, "Print screen image list (SA
LC520) ”and“ Print a book table image list (SAL
C520) ”is used to print out the screen / book table image name, image ID, used skeleton, etc., and utilize it for subsequent management (FIG. 30).

( B) When a file used in the data item design system is viewed as a field, which is the minimum unit, it is divided into two groups.
One is external processing that is displayed or printed on the screen or book and has an interface with humans.
One is used internally as it is not touched by human eyes. Since the externally processed data item has already been created in (A) above, only the internally processed data item will be created next.

(5) "Design of data item (S
AGC 150) "is selected to design a data item used for internal processing, and the content is saved in a" data item file ". Specifically, in the state of FIG. 31, as the “data item generic ID”, for example, “NOIN
When "TER" is input and the execution key is pressed, the state shown in FIG. 32 is obtained. Therefore, for example, "internal use data item" is input as "data item generic name", then "data item name", "data digit". Enter "Number", "Data type", "Number of decimal places", and "Item contents (remarks)" as appropriate. Note that in FIG. 32, for example, “data creation date”,
"8", "S", "0", etc. are input. After that, as shown in FIG. 3, “printing a data item list (SEGC5
71) ”is selected, the data item list as shown in FIGS. 33 to 36 is printed out, so that an input error or an input omission can be detected even at this stage. 34 to 36
Shows the contents of the "data item file" automatically generated at the stage of creating the screen / book table image (A). The "data item generic ID" and the "data item generic name" are respectively ""Screen / book table image ID" and "screen / book table image name" are matched. Note that FIG.
Is a list of data item generic names defined up to this point (automatic, manual), printed using "print data item generic table (SEGC573)" shown in FIG.

( C) Creation of Data Dictionary (6) When the design of the data items is completed and the “data item file” is completely constructed, the data item file is compressed to construct the data dictionary. Specifically, the “data dictionary creation process (S
If you select "AFC600)", "Data item name",
Data items having the same "number of digits", "data type", and "number of decimal places" are compressed as the same data item. Conversely, even if the same data item is mistaken for "data item name", "digit number", "decimal digit number", etc., it is registered as a different data item in the data dictionary. It will be.
Next, as shown in FIG. 4, "printing of data dictionary (S
EGC8343) ”is selected, a data dictionary list (hereinafter referred to as D / D list)
The data is sorted and output in the order of "data item name" (see FIGS. 38 and 39). A list of all data items without compression is a “all data item list”, as shown in FIGS. 40 to 41, for example. 38 to 39
According to the D / D list shown in,
A mistake in "data item name" can be immediately detected. For example, it can be seen that the number of digits in No. 19 and No. 20 in Fig. 38 is incorrect (in this case, 26 digits are correct), and No. 27 is the same as No. 29, so the name is not correct. It becomes clear that it is suitable.

(7) When an input error or the like is detected in this way, "correction of data item (SAFC1
70) "to correct the typo. This process then automatically modifies the contents of the data dictionary and data item files. Further, at this time, since the “data item generic name” of the screen / book table image that uses the changed data item is printed (FIG. 42), the “Create screen image (SAG
C520) ”and“ Create a book table image (SAGC51
0) ”to modify the screen / book image.

(8) After the correction process is completed in this manner, the D / D list is printed out again, and an appropriate "data item ID" is entered therein, and if necessary,
Fill in the "data item type code" and "index ID". 43 and 44 are diagrams showing the D / D list after the entry. Here "data item type code"
Is used in a large classification, and "index ID" is used in a middle classification, and is used in a data dictionary inquiry or the like. FIG.
In the example of FIGS. 3 to 44, the “data item type code” “NAME” is assigned to the “customer name”, “customer name (abbreviation)”, and “customer person in charge”, and “order amount”
"Order amount (monthly total)""Order amount (daily total)""Order amount (slip total)" for "Data item type code"
"KING" is added. Also, "customer name"
"Customer name (abbreviation)" for "index ID""TOK
NM ”is given, and“ Index I ”is given to“ Customer Contact ”.
"D" and "TANNM" are added. Note that FIG.
FIG. 46 shows the initial screen (FIG. 45) of “Add index ID / data item ID (SAGC 620)” shown in FIG. 4, and “data item ID” “index ID” “data item type code”.
And an input example (FIG. 46) such as. 47 and 48 are the D / D list after the addition of the index ID, the data item ID, etc., printed out by the "print data dictionary (SEGC8343)" shown in FIG. .

( D) Classification of data items (9) Next, assuming physical files required for processing such as “order entry slip input”, “order detail table (by product)” and “customer master maintenance”, Classify all data items. Specifically, the data item classification sheet (1) printed out by the "print data item classification sheet (SEGC 814)" shown in FIG.
Fill in the necessary information in (2). In the data item classification sheet (1), "classification ID" and "classification name" of the physical file accessed in each process are entered.
The “classification name” and the “classification ID” are the basis of the “file name” and the “file ID”. In FIGS. 49 to 52, physical files that are accessed by the processes of “order entry input”, “order list (by product)” and “customer master maintenance” or that require “internal use data item” are listed. Has been done. The data item classification sheet (2) contains data items for each screen / book table image,
Enter the relationships with the physical files listed in the data item classification sheet (1) (FIGS. 53 to 56). For example,
53. In FIG. 53, the data items related to the “order file (header)” in the “order slip input” process are “order slip number,” “customer code,” “slip date,” “order person in charge,” “order amount ( Slip total) ".

(10) When the above preparation is completed, the data item classification sheet (1) shown in FIGS. 49 to 56 is used by using the "data item classification (SEGC801)" shown in FIG.
The value entered in (2) is registered in the computer. Fig. 57
Is an initial screen of “Classification of data items (SEGC801)”, and in this state, “Data item generic ID” “JU
58. When the user inputs "01010D" and presses the execute key, the state shown in FIG. 58 is obtained. Therefore, according to the data item classification sheet (1) of FIG. 49, "classification ID" and "classification name" are input and the function key F9 is pressed. Then, the state shown in FIG. 59 is reached, so that “Y” is input to the position of the corresponding data item according to the data item classification sheet (2) of FIG. 53 (FIG. 60). By repeating the above processing of FIGS. 57 to 60, the data item classification sheet (1) of FIGS. 49 to 56 can be obtained.
(2) Registration of the entered value is completed. After the registration is completed, the "print data item classification sheet (SEG
C814) ”is selected, the data corresponding to the data item classification sheets of FIGS. 49 to 56 are printed out, so that an input error or the like can be immediately confirmed. After that, if "print classification data item list (SEGC811)" shown in FIG. 3 is selected, the "classification ID list" of FIG.
Since the “category data item list” of FIG. 65 is printed out, it can be confirmed whether or not the classified contents are correct. In addition,
Since the “category data item list” is the information that has been classified and input as it is, even if the same data item is printed separately, as in No. 7 and No. 8 in FIG. 64, here However, it is possible to check the number of digits in the data.

( E) Design of Physical File When the above processing is completed, all the data items necessary for the physical file are decided, and the actual physical file is defined thereafter. Since the necessary information has already been determined, what is specified is the order of the data items in the actual physical file, the key order when accessing the physical file, and the record format ID.

(11) First, the "field ID" shown in FIG.
Automatic numbering definition (SEGC527) "is used to determine field ID numbering rules. Specifically, FIG.
When "1" is input on the initial screen of No. 6 and the execution key is pressed, the state shown in FIG. 67 is displayed.
It is specified that the upper 2 digits of “D” and the 4 digits of “data item ID” are combined to form a 6-digit “field ID” (FIG. 6).
7).

(12) Next, as shown in FIG. 5, "physical file design (source object generation) (SEGC52
0) ”is selected. Then, the state shown in FIG. 68 is obtained.
The “classification ID” (FIG. 49) that is the basis of the “physical file ID”
(See FIG. 53) and press the Enter key. FIG. 69 shows
It shows the initial screen after pressing the Enter key,
The upper 2 digits "JU" of the "classification file ID" and FIG.
The 4-digit “data item ID” determined in FIG. 44 and the like is combined and the 6-digit “field ID” is displayed. As is clear from FIG. 69, for example, "field ID" of "data item name""order slip number.""JU
JDNO "is the" physical file ID "" JUCHUH "
And "data item ID""JDNO" are combined to form. When the "record format ID""JUCHUHR" is input on the initial screen of FIG. 69 and the function key F9 is pressed, the state of FIG. 70 changes to the state of FIG. Therefore, the function key F6 is pressed to set the key field and the state shown in FIG. 72 is obtained. And
Enter "Y" in the key data item (Fig. 73),
Press the function key F9 to finish designing the physical file "order file (header)". "Order file (details)""Productmaster""Customermaster"
The physical file design for is also performed in the same procedure.

(13) The contents of the created physical file are
It can be confirmed at any time by "printing of physical file design document (record layout) (SEGC 561)" in FIG. Figure 7
4 to 81 show a printed database design document,
3 is a diagram of a database file source list.

[Brief description of drawings]

FIG. 1 is an overall view showing a processing procedure of the present invention.

FIG. 2 is a menu development view.

FIG. 3 is a menu development view.

FIG. 4 is a menu development view.

FIG. 5 is a menu development view.

FIG. 6 is a layout of order entry slip input.

FIG. 7 is a layout of an order schedule.

FIG. 8 shows a state in which necessary items are entered in FIG.

9 is a state in which necessary items are entered in FIG. 7.

FIG. 10 is a flowchart showing a processing outline of a skeleton ET010.

FIG. 11 is a flowchart showing a processing outline of the skeleton LT020.

FIG. 12 is a flowchart showing an outline of processing of a skeleton MM020.

FIG. 13 illustrates a screen of “Create screen image”.

FIG. 14 illustrates a screen of “Creation of screen image”.

FIG. 15 illustrates a screen of “Creation of screen image”.

FIG. 16 illustrates a screen of “Creation of screen image”.

FIG. 17 illustrates a screen of “Creation of screen image”.

FIG. 18 illustrates a screen of “Creation of screen image”.

FIG. 19 illustrates a screen of “Create screen image”.

FIG. 20 is a diagram showing a screen of “Create screen image”.

FIG. 21 is a diagram showing a screen of “Create screen image”.

FIG. 22 illustrates a screen of “Creation of screen image”.

FIG. 23 is a diagram showing a screen of “Create screen image”.

FIG. 24 is a diagram showing a screen of “Create screen image”.

FIG. 25 is a diagram showing a screen of “Creation of screen image”.

FIG. 26 is a printout of a screen image.

FIG. 27 is a printout of a book table image.

FIG. 28 is a printout of another screen image.

FIG. 29 is a printout of a book table sample.

FIG. 30 is a screen image list.

FIG. 31 illustrates a “design of data item” screen.

FIG. 32 is a diagram showing a screen of “design of data item”.

FIG. 33 is a data item list for each screen / book.

FIG. 34 is a data item list for each screen / book.

FIG. 35 is a data item list for each screen / book.

FIG. 36 is a data item list for each screen / book.

FIG. 37 is a list of generic data items.

FIG. 38 is a data dictionary list.

FIG. 39 is a data dictionary list.

FIG. 40 is a list of all data items.

FIG. 41 is a list of all data items.

FIG. 42 is a result list of contents of change of data items.

[FIG. 43] Data item ID and index I in the D / D list
D, the type code is entered.

FIG. 44 shows a data item ID and index I in the D / D list.
D, the type code is entered.

FIG. 45 is a diagram showing a screen of “Add index ID / data item ID”.

FIG. 46 is a diagram showing a screen of “Add index ID / data item ID”.

FIG. 47 is a D / D list after necessary information is registered.

FIG. 48 is a D / D list after necessary information is registered.

FIG. 49 is a diagram showing a state in which necessary information is entered in the data item classification sheet (1).

FIG. 50 is a view showing a state in which necessary information is entered in the data item classification sheet (1).

FIG. 51 is a view showing a state in which necessary information is entered in the data item classification sheet (1).

FIG. 52 is a view showing a state in which necessary information is entered in the data item classification sheet (1).

FIG. 53 is a view showing a state in which necessary information is entered in the data item classification sheet (2).

FIG. 54 is a view showing a state in which necessary information is entered in the data item classification sheet (2).

FIG. 55 is a view showing a state in which necessary information is entered in the data item classification sheet (2).

FIG. 56 is a view showing a state in which necessary information is entered in the data item classification sheet (2).

FIG. 57 is a diagram showing a screen of “Classification of data items”.

FIG. 58 is a diagram showing a screen of “Classification of data items”.

FIG. 59 is a diagram showing a screen of “Classification of data items”.

FIG. 60 is a diagram showing a screen of “Classification of data items”.

FIG. 61 is an ID list of data classification.

FIG. 62 is a classification data item list.

FIG. 63 is a list of classified data items.

FIG. 64 is a list of classified data items.

FIG. 65 is a list of classified data items.

FIG. 66 is a diagram showing a screen of “Definition of automatic field ID numbering”.

FIG. 67 shows a screen of “Definition of automatic field ID numbering”.

FIG. 68 is a diagram showing a screen of “design of physical file (generation of source object)”.

FIG. 69 is a diagram showing a screen of “design of physical file (generation of source object)”.

[Fig. 70] Fig. 70 is a diagram showing a "Physical file design (source object generation)" screen.

71 is a diagram showing a screen of "design of physical file (generation of source object)"; FIG.

FIG. 72 is a diagram showing a screen of “design of physical file (generation of source object)”.

FIG. 73 is a diagram showing a screen of “design of physical file (generation of source object)”.

FIG. 74 is a database design document.

FIG. 75 is a database design document.

FIG. 76 is a database design document.

FIG. 77 is a database design document.

FIG. 78 is a source list of database files.

FIG. 79 is a source list of database files.

FIG. 80 is a source list of database files.

FIG. 81 is a source list of database files.

FIG. 82 is a schematic explanatory diagram of the present invention.

FIG. 83 is a schematic explanatory diagram of the present invention.

Claims (9)

[Claims] 1. A process of interactively registering an input / output screen and an output book table layout (screen / book table image) in a computer, and extracting data items from the registered screen / book table image, and extracting. All the data items for each screen / book table image that have been created are added together with the necessary data items to create a data item dictionary, and the physical files related to each of the input / output screen and output book table are created. It is determined by the process of determining the data items of each determined physical file by the data items of the input / output screen or the output table, and the process of adding necessary information to each of the identified data items. A physical file design method characterized by performing a file design. 2. A first means for registering an input / output screen and an output book table layout (screen / book table image) in a computer interactively and extracting data items from the registered screen / book table image. , All the data items for each extracted screen / book table image are put together, and necessary data items are added, and the second means for creating a data item dictionary and the relationship between each of the input / output screen and the output book table Third, the physical file to be determined is determined, and the data item of each determined physical file is specified by the data item of the input / output screen or the output book table.
A physical file design device comprising means and a fourth means for adding necessary information to each specified data item, and automatically generating a physical file design. 3. An input / output screen or an output book table layout is registered in a computer, and then each registered screen / book table image and its list are printed out as necessary. The physical file design device according to claim 2. 4. The physical file designing method according to claim 1, further comprising the step of printing out a list of created data item dictionaries and correcting defective data items. 5. The physical file design method according to claim 1, wherein different IDs are assigned to different data items in the data item dictionary. 6. The physical file design device according to claim 2, wherein different IDs are assigned to different data items in the data item dictionary. 7. The data item dictionary is further provided with a type ID for making only necessary data items hard to classify and a search ID for making only necessary data items hard to classify. The physical file design device according to claim 6. 8. The physical file design method according to claim 5, wherein the field ID of the physical file is automatically determined by combining the ID of the data item and the ID of the physical file. 9. The physical file design device according to claim 6, wherein the field ID of the physical file is automatically determined by combining the ID of the data item and the ID of the physical file.