JP2798147B2 - Database input / output method and input / output device - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention automatically registers a document recorded on a storage medium such as a magnet in a database, and stores the data registered in the database in a format different from the output format provided in the database system. The present invention relates to a database input / output method for automatically outputting a document and an input / output device.

[0002]

2. Description of the Related Art Conventionally, when a document created by a word processor or the like is registered in a database, data on a form is manually input from a keyboard or the like and registered in a database item. When data registered in the database is to be output in a format different from the format provided in the database system, the data is first output in the form of the database system, and the output form is used to output a table from a keyboard or the like. The work was input to a word processor and output to a user-specific format document.

FIG. 10 is a diagram showing a conventional database input / output method. In the figure, reference numeral 200 denotes an input means, which is a word processor (hereinafter referred to as a word processor).
Reference numeral 201 denotes a keyboard for inputting a document. 201 is a word processor. 202 is a word processing document A
, And is a document created by the word processing device 201. Numeral 203 denotes an input means, which comprises a keyboard for inputting data to the database. 20
4 is a database system. Reference numeral 205 denotes a database search means for inputting search conditions and searching the database. Reference numeral 206 denotes a search result output form, and 207 denotes an input means such as a keyboard for inputting a document to the word processor 208. Reference numeral 208 denotes a word processor. Reference numeral 209 denotes a word processing document B, which is a document created by the word processor 208.

A conventional database input / output method will be described. This shows a case where a document created by a word processor is registered in a database. Document data is input to the word processor 201 manually by the input means 200. Then, the created document is output as a word processing document A (202).

When registering the contents of the word processing document A (202) in the database, the user reads the word processing document A (202) output on the form, and
Thus, data is manually input to the database system 204 for each database item.

Conversely, when data registered in the database system 204 is to be output as a document having a format different from the output format provided in the database system, first, the input means 203 inputs search conditions (record number, output number). Items, etc.) are input to the search means 205 of the database. The database system 204 outputs the search result to the display 206 ′ and the search result output form 206 according to the search condition. Then, the user reads the data of the search result output form 206 and manually inputs the data into the word processor 208 by the input means 207 of the word processor. Then, the document (word processing document B (209)) in a format desired by the user is output by the word processor 208.

[0007]

According to the conventional database input / output method, as described above, even if a word processing document created on a storage medium such as a floppy disk is input to the database, it is once written in a form. The user had to output the output form, read the output form again, specify the database items, and re-enter the database. When the data registered in the database is output to a document in a format different from the output format provided in the database system, the database is searched, the search result is output as a form, and the output form is read by the user. He re-entered the data into the word processor and created a document in the required format.

For this reason, the conventional database input / output method has many manual steps, is inefficient, and tends to cause data input errors and the like. The present invention provides a database input / output method and an input / output method capable of easily and efficiently inputting data to a database system without causing data input errors, and easily creating a document having a format different from the format provided in the database system. It is an object to provide an output device.

[0009]

SUMMARY OF THE INVENTION The present invention enables data to be directly registered in a database from a storage medium such as a floppy disk, and automatically outputs data registered in the database to a user-specific format. did.

FIG. 1 shows the basic configuration of the present invention. In FIG. 1, reference numeral 1 denotes a word processing document 1 in which a section for inputting data is defined and a section name is set. The word processor document 1 (1) represents a document created on a storage medium such as a floppy disk.

Reference numeral 2 denotes a database system for registering data. Reference numeral 3 denotes creation condition input means for inputting the correspondence between the section name of the word processing document 1 (1) and the item name of the record of the database.

Reference numeral 4 denotes a document analysis means for extracting data from a section of the word processing document 1 (1) and registering the data in a corresponding item of the database 21. Reference numeral 5 denotes a document assembling unit that extracts data registered in the database 21 in item units and outputs the data to the section of the word processor document 2 (8) corresponding to the item.

Reference numeral 6 denotes search condition input means for inputting search conditions for the database 21. Reference numeral 7 denotes a database search means for searching the database 21 according to search conditions. Reference numeral 8 denotes a word processor document 2, which represents a document created by the document assembling unit 5. 8 '
Is a template document selecting means for inputting a template of a format of a document to be output (word processor document 2 (8)).

In the word processing document 1 (1), 10, 1
Reference numerals 1 and 12 denote sections of the word processing document 1 (1), which represent section names of the section name A, section name B and section name C. (The word processing document 1 (1) defines sections and can set section names. This is a document created by a word processor. A document created by a word processor that cannot set a section name will be described later.)

In the database system 2, reference numeral 21 denotes a database, which is composed of records, and each record is composed of items. In the document analyzing means 4, reference numeral 13 denotes an information table creating means for creating an information table (13 ') in accordance with the correspondence between the section names input by the creating condition input means 3 and the items of the database (word processing document). In some cases, an information table is created by associating section positions with item names (this case will be described later). Reference numeral 13 'denotes an information table in which section names and item names are associated with each other. , Other table attributes, table values, etc.) 14 is a data extracting means for extracting data of a section of the word processing document 1 (1). 15 is a database registration means, which is an information table. The data extracted from the word processor document 1 (1) is registered in the database 21 with reference to 13 '.

In the document assembling means 5, 16 is an information table creating means, 16 'is an information table, and 17 is a data output means, which fetches data from the database 21 in units of items, and refers to the information table 16' for items. Is output to the section of the word processor document 2 (8) corresponding to.

In the word processing document 2 (8), 18, 1
Reference numerals 9 and 20 denote sections having section names A ', B' and C ', respectively. Numeral 22 denotes a definition file creating means. In the case of a document created by a word processor which cannot set a section name in the document, the creating condition input means 3
The definition file is created in accordance with the correspondence between the partition position (for example, the upper left start position and the lower right end position of the rectangle) input by the user and the items of the database 21. 22 'is a definition file, which is a word processing document 1
This is a file in which the section positions of (1) are associated with item names.

Reference numeral 23 denotes a definition file creating means. When a section name cannot be set, the section position (for example, the starting position at the upper left of the rectangle and the ending position at the lower right of the rectangle) input by the user from the creating condition input means 9 are defined. The definition file is created according to the correspondence with the items of the database 21. 2
Reference numeral 3 'is a definition file, which is a file in which the section positions of the word processing document 2 (8) are associated with the items.

[0019]

The operation of the basic configuration shown in FIG. 1 will be described. (a) When a section is defined in a word processing document and the section name is set.

[Registration process to database] The correspondence between the section name and the item name is input to the document analysis means 4 by the creation condition input means 3.

The document analysis means 4 reads the word processing document 1 (1). Then, the information table creating means 13 creates an information table 13 'in which the section names and item names of the word processing document, the attributes (character type, numeric type, etc.) of the data input to the items, the data length, and the like are associated.

The data extracting means 14 reads the data of the section. The database registration means 15 stores the information table 1
The data of the section read with reference to 3 ′ is registered in the corresponding item.

[Process of Outputting Data Registered in Database] The correspondence between the section name and the item is input from the creation condition input means 9. The model (format) of the document to be output is selected by the model document selecting means 8 '. The document assembling means 5 inputs the template selected from the template document file 8 ".

The information table creating means 16 creates an information table 16 'in which the section names are associated with items, attributes, and data lengths. A search condition (record number, item name, etc.) of the database is input from the search condition input means 6. The database search means 7 searches the database 21 according to the search condition.

The data output means 17 retrieves the retrieval result in item units, outputs the retrieved result to the corresponding document section by referring to the information table 16 ', and creates a word processing document 2 (8). (b) When a partition name cannot be set in a word processing document.

In the case of a document created by a word processor in which a section is defined in the document and the section name cannot be set,
The section position is defined by the coordinates of the upper left point and the coordinates of the lower right point of the section, and the item is made to correspond to the section position.

[Database Registration Process] The information table creating means 13 reads the definition file 22 'and creates an information table 13' in which the partition names are associated with item names, attributes, data lengths and the like.

The data extraction means 14 is a word processing document 1 (1).
Is read, and the data of the section is extracted for each item. The database registration unit 15 registers the data read with reference to the information table 13 'in a corresponding item.

[Process for Outputting Data Registered in Database] A definition file 23 'is created in which the section positions of the word processor document 2 (8) are associated with the item names.

A template document is selected by the template document selecting means 8 '. The document assembling means 5 reads the template (format) of the created document from the template document file 8 ". The information table creating means 16 reads the definition file 23 'and associates the section position with the item name, attribute, and data length. The created information table 16 'is created.

The search condition input means 6 inputs search conditions for the database. The database search means 7 searches the database 21 according to the search condition. The data output means 17 extracts the data of the search result in item units. Then, referring to the information table 16 ', the data is output to the corresponding section, and the word processing document 2 (8) is created.

[0032]

FIG. 2 is a diagram showing an embodiment (1) of data registration according to the present invention. In the figure, 20 is a word processing document 3, 21
Is a document creating means, which is a word processor for creating a word processing document 3 (20), which can define a section in the document and set a section name. Reference numeral 21 'denotes section name setting means for setting a section name in a document. 22 is a document analysis means, 23 is an information table creation means, 24 is a database registration means, 25 is a database system, 25 '
Is a database having a plurality of records (record 1, record 2, etc.), and each record is composed of a plurality of items. Each item has an item name, attribute, and data length. 26 is a creation condition input means.

In the word processing document 3 (20), reference numeral 30 denotes a section, which has a section name ACH10, and the corresponding item has an item name A, a data type of a character type, and a data length of 10 bytes (section). The definition of the correspondence between the name and the item name is input by the user from the creation condition input means 26). Reference numeral 31 denotes a section name BCH20, and the corresponding database items are the item name B, character type, and data length of 20 bytes. Numeral 32 denotes a section name CDM9, a numeric type, and a data length of 9 digits.

In the information table creating means 23, 33
Is an information table in which the section names and the item names of the word processing document 3 (20) are associated with each other. The operation of the configuration shown in FIG.

The word processing document 3 is generated by the document creating means 21.
(20) is created. At this time, the section 30, the section 31, and the section 32 are determined, and the section names ACH10 and BCH2 are respectively given.
0, set CDM9.

On the other hand, the user inputs the section name of the word processing document 3 (20) and the database (2
Enter the correspondence with the item name in 5 '). Further, the document analysis unit 22 reads the section name and the section data from the word processor document 3 (20). Then, the information table creating means 23
Creates an information table 33 in which the block names are associated with item names, attributes, and data lengths.

The database registration unit 24 refers to the information table 33 and registers the data of the section read from the word processing document 3 (20) in an item corresponding to the section. In the example shown in the figure, the data of the section 30 is represented by the item names A,
The data of section 31 is registered as item name B, and the data of section 32 is registered as item name C.

FIG. 3 shows an embodiment (2) of data registration according to the present invention.
Is shown. In the figure, reference numeral 40 denotes a document creation means, which is a word processor. Reference numeral 41 denotes a word processing document 4, which is a document created by the document creating means 40. 42 is a document analysis unit, 43 is an information table creation unit, 44 is a database registration unit, 45 is an information table, 46 is a database system, 46 'is a database, 47 is a definition file creation unit, and 48 is a definition file. In the definition file shown in the figure, Fld represents "item name: attribute: data length" of the database, and Item represents the section position of the word processing document "coordinates of upper left point: coordinates of lower right point".

In the word processing document 4 (41), 50,
Reference numerals 51 and 52 denote sections, respectively, at the section positions (1,
2), (8, 5), section position (1, 7), (10, 1)
0) Division positions (1, 13) and (10, 15). The operation of the configuration shown in FIG.

The document processing means 40 causes the word processing document 4
(41) is created. Reference numeral 41 denotes a document created on a storage medium such as a floppy disk. The definition file creating means 47 determines the position of the section by the coordinates of the upper left point and the coordinates of the lower right point of the section of the word processing document 41, and stores the definition file 48 in which the section position is associated with the item of the database 46 '. create.

The document analysis means 42 outputs the word processing document 4 (4
1) and the definition file 48 is read. The information table creating means 43 creates an information table 45 in which the sections of the word processing document 4 (41) are associated with the items. For example, the division positions (1, 2), (8, 5) of the word processing document 4 (41)
And item name A, character type, data length 10 bytes, partition position (1, 7), (10, 10) and item name B, character type, data length 20, partition position (1, 13), (10, 15) ) Is associated with item name C, numeric type, and data length of 9 digits. The database registration unit 44 reads data from the word processor document 4 (41) for each section, and registers the corresponding item with reference to the information table 45. For example, the partition position (1,
The data of 2) and (8, 5) are registered in the item name A, the data of the block positions (1, 7) and (10, 10) are registered in the item name B, and the block positions (1, 13) and ( The table of 10, 15) is registered in the item name C.

FIG. 4 shows a data output embodiment (1) of the present invention. In the figure, reference numeral 60 denotes a document creating means for defining a section in a document and setting a section name. Reference numeral 60 'denotes a template document file created by the document creating means 60. Reference numeral 61 denotes a template document selecting means for selecting a format of a word processing document. Reference numeral 62 denotes a model (format) of the selected word processing document 5. 63 is a document assembling means, 64 is an information table creating means, 65 is a data output means, 66 is a creating condition input means,
Reference numeral 67 denotes a word processing document 6, which represents a created document. 68 is a database system and 68 'is a database. 69 is a search condition input means, and 69 'is a database search means.

In the template (62) of the word processing document 5, 70 and 71 are sections, each of which has a section name. Each section corresponds to an entry in the database 68 '. For example, 70 is a section name A and corresponds to the item name A, and 71 is a section name B and corresponds to the item name B. The correspondence between the section name and the item is determined by the creation condition input means 66.
Is given by the user.

The operation of the configuration shown in FIG. The user inputs the correspondence between the section of the template 62 of the word processing document 5 and the item of the database 68 'from the creation condition input means 66.

The document assembling means 63 outputs the word processing document 5
Is read. Then, the information table creating means 64 creates an information table 64 'in which the section names, item names, attributes, and data lengths are associated with each other based on the correspondence between the sections of the template 62 of the word processor document 5 and the items. For example, the section name A is associated with the item name A, and the section name B is associated with the item name B.

A search condition is input from the search condition input means 69. The database search means 69 'is the database 6
8 'is searched, and the search result is output to a display (not shown) or the like. On the display screen, the user specifies a record to be output to the document.

The data output means 65 is provided for the information table 6
With reference to 4 ′, data of necessary items is extracted from the search result of the database 68 ′ and output to each section of the template 62 of the word processing document 5 to create a word processing document 6 (67).

FIG. 5 shows a data output embodiment (2) of the present invention. In the figure, 75 is a definition file creation means, 76
Is a definition file, Fld is an item name of a database, etc., and Item is a partition position (same as the definition file 48 in FIG. 3). 77 is a document assembling means, 78 is an information table, 79 is a data output means, 80 is a database system, and 80 'is a database. 81 is a search condition input means, and 82 is a database search means. 8
Reference numeral 3 denotes a word processing document 7, which represents a created document.
84 and 85 are sections of the word processor 7 (83), respectively, and 84 is a section position (2, 3), (8, 5), and 85 is a section position (2, 6), (8, 8).

The operation of the configuration shown in FIG. The user inputs the correspondence between the section position of the word processing document 7 (83) and the item name of the database 80 'through the definition file creating means 75,
A definition file 76 is created. For example, the section position (2,
3), (8, 5) have item name A, section position (2, 6),
(8, 8) is associated with item name B.

The information table creating means 77 reads the definition file 76 and creates an information table 78. The data output unit 79 extracts data for each item from the record specified for the search result of the database 80 ′ by referring to the information table 78, and outputs the word processing document 7 (8
Output to the corresponding section position in 3).

FIG. 6 shows an embodiment of the present invention. In the figure, reference numeral 90 denotes a database system, which is an existing database system which is generally commercially available. 91
Is a database, and 92 is a database driving means for starting, registering, searching, and terminating the database system. Numeral 93 denotes a word processing document A, in which a section name is set for a section of the document.
Reference numeral 94 denotes a word processing document B, in which a section position is specified for a section. 95 is a definition file creation means, and 95 'is a definition file 1, which is a word processing document B
The correspondence between the section name of (94) and the item name of the database is defined. 96 is a means for creating a word processing document A,
97 is a document analysis means, 98 is a database search means, 9
Reference numeral 9 denotes a search condition input. Reference numeral 100 denotes a template document A, which is a template of a document in which a section name is set. 10
Reference numeral 1 denotes a template document B, which is a template of a document for specifying a section by a section position. 103 is a document assembling means, 1
Reference numeral 04 denotes a word processing document C, which is a document assembling unit 103.
This is a document created by. Reference numeral 105 denotes a display which performs display in a document analysis process, a database search process, a document assembly process, and the like. Reference numeral 106 denotes an input means, which includes a keyboard, a mouse, and the like. The components of the configuration shown in the figure are the same as those described above, and a description thereof will be omitted (the document analysis unit 97, the document assembly unit 103, and the database search unit 98 will be described later). FIG. 7 shows a flowchart of the document analysis means.

S1 and S1 'documents are input, and it is determined whether the document is a word processing document A or a word processing document B. S2 If it is a word processing document A, read the word processing document A.

S3 An information table is created based on the section names, database item names, attributes, and lengths. S4 If the document is a word processing document B, the definition file 1 is read.

S5: An information table is created based on the start / end positions (section positions) of the sections, database items, attributes, and lengths. S6 Whether the document is a word processing document A or a word processing document B
Is determined.

S7 If the document is a word processing document A, read the word processing document A. S8 Data is extracted from the section with the section name. S9 If it is a word processing document B, read the word processing document B.

S10 Data is extracted from the start / end position (section position) of the section. S11 Register in the database. FIG. 8 shows a flowchart of the document assembling means of the present invention.

S1, S1 'A template document is input, and it is determined whether the template is a template document A or a template document B. S2 If the document is the template document A, the template document A is read.

S3 An information table is created with the section names, database item names, attributes, and data lengths. S4 If it is the template document B, the definition file 2 is read.

S5: An information table is created based on the start / end positions (section positions) of the sections, database item names, attributes, and table lengths. S6 Determine whether the document is a template document A or a template document B.

S7 Read the template document A. S8 Data is output to the corresponding section of the template document. S9 Read the template document B.

S10 Data is output to the corresponding position of the template document. S11 Output the document. FIG. 9 shows the processing of the database search means.

FIG. 7A shows a search condition input screen. 13
0 'is display display screen, 131 is item name display, 1
32 is a search condition input area.

By selecting a search mode, a search condition input screen shown in the figure is displayed. The structure (item name) of the record is displayed in the left half of the screen. A search condition input area is attached to each item.

For example, “sales” is input as a search condition for an item name (section). Also, "April 1992" is entered as a search condition for the item name (data creation date). As a result, the search means searches for data registered in “Sales” as a department and “April 1992” as a data creation date.

FIG. 9B shows a search result display screen. 133
Is a display display screen, and 134 is a search result display. The result is displayed in the right half of the screen as shown. Therefore, a search result is selected on the screen. For example, the cursor position of the record 10 is specified on the screen.

FIG. 9C shows a template document selection screen. 13
5 is a display screen, and 136 is a display (window) of an output format.

By selecting a record on the search result display screen and executing the record, an output format selection screen (model selection screen) is displayed in a window. Therefore, a template document (format) is selected by specifying the cursor position.

[0068]

According to the present invention, data can be registered in a database directly from a document recorded on a storage medium such as a magnet. Therefore, data input can be easily performed, and erroneous data input can be prevented. Also, data output registered in the database can be output in a user-specific format different from the format provided in the database system. This makes it easy to create documents based on data registered in the database,
The database can be used effectively.

[Brief description of the drawings]

FIG. 1 is a diagram showing a basic configuration of the present invention.

FIG. 2 is a diagram showing an embodiment (1) of data registration according to the present invention.

FIG. 3 is a diagram showing an embodiment (2) of data registration according to the present invention.

FIG. 4 is a diagram showing a data output embodiment (1) of the present invention.

FIG. 5 is a diagram showing a data output embodiment (2) of the present invention.

FIG. 6 is a diagram showing a configuration of an embodiment of the present invention.

FIG. 7 is a diagram showing a flowchart of the document analysis means of the present invention.

FIG. 8 is a diagram showing a flowchart of the document assembling means of the present invention.

FIG. 9 is a diagram showing the processing of the search means of the present invention.

FIG. 10 is a diagram showing a conventional database input / output method.

[Explanation of symbols]

 1: Word processing document 1 2: Database system 3: Creation condition input means 4: Document analysis means 5: Document assembling means 6: Search condition input means 7: Database search means 8: Word processing document 2 8 ': Model document selection means 8' ' : Model document file 9: Creation condition input means 10: Section name A 11: Section name B 12: Section name C 13: Information table creation means 13 ': Information table 14: Data extraction means 15: Database registration means 16: Information table Creation means 16 ': Information table 17: Data output means 18: Partition name A' 19: Partition name B '20: Partition name C' 21: Database 22: Definition file creation means 22 ': Definition file 23: Definition file creation means 23 ': Definition file

 ──────────────────────────────────────────────────続 き Continuing on the front page (72) Ryoichi Tanaka, Inventor 4-49, Fukami Nishi, Yamato-shi, Kanagawa Prefecture PF Yuyama Plant, Ltd. (72) Inventor Mitsuhiko Ueda 2-49, Fukami-Nishi, Yamato-shi, Kanagawa No. Within the PF Yamato Factory (72) Inventor Shoji Ose 4-49 Fukami Nishi, Yamato City, Kanagawa Prefecture Inside the PF Yamato Factory (72) Yoshihiro Fujino 4-49, Fukami Nishi, Yamato City, Kanagawa Prefecture No. 2-49, Fukami Nishi 4-chome, Yamato-shi, Kanagawa Prefecture No. 56 JP-A-3-91067 (JP, A) Hei 3-91066 (JP, A) JP-A-4-57151 (JP, A)

Claims (4)

(57) [Claims] 1. A word processing document (1) created on a storage medium
Is registered in the database (21), and the data registered in the database (21) is converted into a word processing document in a format different from the format defined by the database system (2).
A method of input and output (8), document analysis means for registering a document recorded in the storage medium in the data base over the scan (21)
(4) Document assembling means for outputting data registered in the database (21) to a document having a format different from the format specified in the database system (2) (5)
The information on the section name or the section position is attached to the section of the word processing document (1) recorded on the storage medium, and the item name of the database (21) corresponding to the section name or the section position is designated. Then, the document analysis means (4) creates an information table (13 ') in which the section names or section positions are associated with the item names of the database (21), extracts data from the sections of the document, and stores the data in the database (21). When registering the corresponding item and outputting the data of the database (21), the item of the database (21) corresponding to the section name or the section position of the document format to be output is designated, and the document assembling means is designated.
(5) creates the information table (16 ') and creates the information table (1 ').
A database input / output method characterized by outputting data extracted from a database with reference to 6 ′) to a section of a word processing document (8). 2. The definition file (2) according to claim 1, wherein the partition positions of the input word processing document (1) and the output word processing document (8) are associated with the item names of the database (21).
Definition file creation means (22), (2)
Create definition files (22 ') and (23') in which the positions of the sections of the input word processing document (1) and the output word processing document (8) are associated with the database item names, and create an information table. Means (13) and (16) correspond to the definition files (22 ') and (2
A database input / output method characterized in that the information of (3 ') is read to create information tables (13') and (16 ') in which the partition positions are associated with the item names. 3. A word processing document (1) created on a storage medium
Is registered in the database (21), and the data registered in the database (21) is converted into a word processing document in a format different from the format defined by the database system (2).
A document analysis means for registering a document recorded in a storage medium in a database (2) in a device for outputting in (8);
(4) Document assembling means for outputting data registered in the database (21) to a document having a format different from the format specified in the database system (2) (5)
The document analysis means (4) has information which associates the item name of the database (21) with the section name or section position of the document.
Information table creation means (13) for creating table (13 ' )
Data extraction means for extracting data of the section of the document in accordance with the information table (13 '), and database registration means (15) for registering the data extracted from the section in a database item corresponding to the section. The means (5) comprises: an information table creating means (16) for creating an information table (16 ') in which a section name or a section position of an output document is associated with an item name of a database (21); A database input / output device comprising: data output means (17) for extracting data of a section of a document output according to (16 ') from a database and outputting the extracted data to a corresponding section. 4. The definition file according to claim 3, wherein a section position of a document to be input is associated with an item name of a database.
(22 ') definition file creating means for creating the definition file creating means for creating (22), the definition file that associates the item name of the compartment location and database document output (23')
(23) , document analysis means (4) and document assembly means
The information table creation means (13) and (16) of (5) correspond to the information tables (13 ') and (16') in which the partition positions are associated with the item names according to the definition files (22 ') and (23'). ') A database input / output device characterized in that the input / output device creates a').