JP2004318897A - Editing support method using database and recording medium with program thereof recorded - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide an editing support system using a database that facilitates the observation of a changed portion in a document resulting from data update in a database. <P>SOLUTION: By an editing support method using a database, when a database check direction is inputted for input data to be edited, document creation control means 8, based on metadata indicating the position in a database of referenced data recorded in the data to be edited, read the data in the position indicated by the metadata from an item database 5, determine whether the referenced data in the database and object data in the data to be edited are the same, and if they are different, display both of them to ask the selection of the data, and capture the selected data as new referenced data in the data to be edited. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

  The present invention relates to a document editing support system using a database, and more particularly to a database management and editing method thereof.

  In recent years, computer-based editing support has been provided. For example, desktop publishing (hereinafter referred to as DTP (Desk Top Publishing)) in document creation is a typical example (hereinafter, the most common DTP will be described as a representative). Such document editing support by a computer includes not only document data created by a document creation tool (software) but also data stored in a database in a computer or a computer connected to the computer via a network. OLE (Object Linking and Embedding) to be incorporated into a document is generally performed, so that the document creation has a wide range. In this OLE, each piece of data is linked (correlated) with the edited part of the document that refers to the data, and when the data is updated, the data in the document is also changed.

  However, in such an editing support system, it is difficult to specify which part of which document refers to the updated data in the database. A text search can be used to find a document or a reference to data in the document based on the updated data.However, searching a large number of documents requires a considerable amount of time. However, since the accuracy is low, there is a possibility that search omission or erroneous search may occur, which is not practical.

  Further, when the data in the database is updated, all the data at the reference location in the document is changed to the updated data, so that it is not possible to cope, for example, when it is desired to postpone the change depending on the document. In addition, the representation format of the data that the user has performed on the data before the change (for example, setting of significant figures when the data is a numerical value, setting of a plurality of columns, etc.) becomes invalid for the data after the change, The setting needs to be set again, and the degree of freedom in editing is lost.

  Furthermore, the reference point in the document is changed to the updated data. For example, even if an attempt is made to edit to return to the previous data, it is difficult to find the reference point in the document. In addition, it is difficult to edit the data to be edited among the data at the reference location, and to confirm whether the data to be kept is kept as it is.

  Therefore, it has been desired to realize an editing support system using a database in which it is easy to recognize a changed portion in a document due to updating of data in a database and to easily determine whether or not a reference portion has been edited.

  According to the present invention, with reference to data stored in a database, an editing support method using a database that performs editing by capturing the referenced data in the data to be edited includes a step of inputting the data to be edited, When the confirmation instruction is input, based on the metadata recorded in the data to be edited and representing the position of the referenced data in the database, reading the data at the position represented by the metadata from the database; and Determines whether the data read from the database is the same as the referenced data, and if the data read from the database is different from the referenced data, displays both the data read from the database and the referenced data The process of prompting the user to select data and the newly referenced data And a step of capturing the edited data as over data.

  In the present invention, when a database confirmation instruction is input after inputting the data to be edited, the data recorded in the data to be edited, based on the metadata including the table name, column name, and row number of the referenced data, The data stored at the position represented by the metadata is read from the database. It is determined whether the data read from the database is the same as the referenced data taken into the document. If the data in the database is not updated, the data is the same, but if the data read from the database is different from the referenced data, both the data read from the database and the referenced data are displayed, Prompt the operator to select data. The data selected by the operator is imported into the document as new referenced data, and the data at the reference location in the document is prevented from being automatically changed when the data in the database is updated. Make edits.

  Further, according to the present invention, a recording medium for providing editing support using a database that performs editing by referring to data stored in a database and incorporating the referenced data into data to be edited is a recording medium for editing. When the data is input and the database confirmation instruction is input, the data at the position represented by the metadata is stored in the database based on the metadata recorded in the data to be edited and representing the position of the referenced data in the database. From the database and determine whether the data read from the database and the referenced data are the same.If the data read from the database is different from the referenced data, the data read from the database and the referenced data are Is displayed to prompt the user to select data, and the selected data is It is obtained by recording a program for causing a computer to be incorporated into the edited data as irradiation data.

  In the present invention, when a database confirmation instruction is input after inputting the data to be edited, the data recorded in the data to be edited, based on the metadata including the table name, column name, and row number of the referenced data, The data stored at the position represented by the metadata is read from the database. A determination is made as to whether the data read from the database and the referenced data are the same. If the data in the database is not updated, the data is the same, but if the data read from the database is different from the referenced data, both the data read from the database and the referenced data are displayed, Prompt the operator to select data. The data selected by the operator is imported into the data to be edited, such as a document, as new referenced data. The above operation is performed by a control means such as a computer to prevent the data from being automatically changed when the data in the database is updated, and to perform free editing by the selection of the operator.

  As described above, according to the present invention, it is determined whether the data read from the database and the read reference data are the same, and if different, both the data read from the database and the referenced data are determined. The data is displayed and the operator is prompted to select the data, and the selected data is taken into the edited data as new referenced data, so that the operator can easily edit the data according to the edited material at his will. Editing with a high degree of freedom.

Embodiment 1 FIG.
FIG. 1 is a block diagram of an editing support system using a database according to the first embodiment of the present invention. Reference numeral 1 denotes a database control unit (hereinafter, referred to as a DB control unit). The DB control means 1 newly creates, updates, or deletes database input data (hereinafter, referred to as DB input data) based on an input signal (unless otherwise specified, these processes are collectively referred to as updating, etc.). And saves it in the specification database 5. Further, a process of recording and storing metadata (hereinafter, referred to as log data) including a table name, a column name, and a line number of updated DB input data in the log database 6 is performed. A process of comparing the stored data with the stored data and recording the comparison result in the comparison result recording unit 4 is performed. Further, in order to cause the database display means 3 to display the above processing status and the like, database display data (hereinafter, referred to as DB display data) is transmitted to the database display means 3. Reference numeral 2 denotes database input means (hereinafter, referred to as DB input means) including a keyboard or the like. When an instruction, DB input data, or the like is input from a user (hereinafter, referred to as a DB operator), an input signal corresponding to the instruction, DB input data, or the like is transmitted to the DB control unit 1. Reference numeral 3 denotes a database display unit (hereinafter, referred to as a DB display unit) including a CRT, a liquid crystal display, and the like. The DB display unit 3 displays characters and images based on the DB display data transmitted from the DB control unit 1. Reference numeral 4 denotes a comparison result recording unit, which stores comparison results (data such as updated DB input data, a document file name of a document that refers to the DB input data, a reference location, etc.) output by the DB control unit 1 as comparison result data. And print and save.

  5 is a specification database. In the present embodiment and the embodiment described later, the specification database 5 is assumed to be configured as a relational database storing a plurality of tables. DB input data stored for each table, column, and row (each cell) is referred to and taken in at the time of document creation. Reference numeral 6 denotes a log database which stores log data of the updated DB input data, as described above. Reference numeral 7 denotes a search information database, which is a relational database that stores a document identifier and reference data in association with each other. Here, the reference data refers to the metadata of the table name, column name, and line number of the DB input data referred to in the created document. The document identifier is composed of metadata for identifying the reference location in the document, such as the folder name, file name, and page number data of the reference location of the document referencing the DB input data.

  Reference numeral 8 denotes a document creation control unit that performs document creation control at the time of document creation. When an input signal indicating a database reference instruction is input from the document creation input means 9 during document creation, the DB input data is referenced from the specification database 5 and captured (this is referred to as a database capture function of the document creation means 7). Do). Further, the document storage unit 11 stores document data, which is data of a created document, as a document file. The reference data of the DB input data taken into the document when the document data is stored is linked to the document identifier and stored in the search information database 7. Further, in order to display the above processing status on the document creation display means 10, the document creation display data is transmitted to the document creation display means 10. Reference numeral 9 denotes a document creation input unit configured by, for example, a keyboard or the like. When an instruction, character data, or the like is input from a user (hereinafter, referred to as a document creation operator), an input signal corresponding to the instruction, character data, or the like is transmitted to the document creation control unit 8. Reference numeral 10 denotes a document creation and display unit including, for example, a CRT, a liquid crystal display, and the like. The document creation display means 10 displays characters and images based on the document creation display data transmitted from the document creation control means 8. A document storage unit 11 stores a document file. The document data recorded in the document file is data composed of at least character data, character control data, and filter data, which are recorded to be displayed in the same manner as a document displayed on the document creation display means 10. That is. Here, the filter data is control data (for example, an expression format such as a setting of a significant figure when the data is a numerical value, a setting of a plurality of columns, etc.) added to data at a reference portion of the DB input data.

  FIG. 2 is a flowchart showing the operation of the search information storage function of the document creation control means 8 according to the first embodiment. When the document creation operator finishes the creation of the document and instructs the search information storage function (S21), the document creation control means 8 sets the table name data, the column name data, and the metadata of the DB input data referred to in the document. The line number data is stored in the search information database 7 as reference data, and in association therewith, at least the folder name data, file name data, and page number data of the reference location, which are the metadata of the document, are used as different document identifiers. The information is stored in the table (S22). When the storage is completed, the document creation control unit 8 ends the operation of the search information storage function (S23).

  FIG. 3 is a flowchart showing the operation of database management centered on the DB control means 1 according to the first embodiment. The database management of the editing support system using the database will be described with reference to FIG.

  When an update processing instruction is input from the DB operator, the DB control unit 1 reads DB input data of the specification database 5 (or a table, a column, or the like including the specified DB input data), and sends the read data to the DB display unit 3. It is displayed (S31). The DB control means 1 causes the DB display means 3 to display the new DB input data input to the location (table, column, and row) that the DB operator wants to update (S32). When the DB operator inputs an update instruction to the DB input means 2, the DB control means 1 having received the input signal causes the specification database 5 to store and store updated DB input data (S33). Further, the log data of the updated DB input data is stored in the log database 6 (S34).

  The DB control means 1 accesses the search information database 7, reads the reference data, compares the log data with the reference data (S35), and obtains both metadata (table name data, column name data, and row number). (S36). If the two metadata match, the DB input data at the updated location is referred to, and assuming that the fetched document exists, the document identifier associated with the reference data is read (S37). If the two metadata do not match, it is assumed that there is no document referring to the updated DB input data.

  When the comparison between all the log data and the reference data is completed (S38), the DB control unit 1 displays the read document identifier and the updated DB input data on the DB display unit 3, and also displays the comparison result as comparison result data. It is stored in the recording unit 4 (S39). The comparison result data stored in the comparison result recording unit 4 can be printed out or the like in accordance with an instruction of the DB operator.

  As described above, according to the first embodiment, the DB control unit 1 compares the log data of the DB input data stored in the log database 6 with the reference data stored in the search information database 7, and If the metadata (table name, column name, and row number) of the document matches, it is determined that there is a document that refers to the location where the DB input data has been updated, and the document identifier and the reference data associated with the reference data Is displayed on the DB display means 3 and is stored in the comparison result recording unit 4 as comparison result data so that the search can be confirmed. For example, in a system managing about 1000 document files, one DB input In some cases, about 20 documents are associated with data. In such a system, log data and reference data can be compared, and a document file referencing the updated DB input data can be automatically searched, thereby improving work efficiency and preventing omission of search.

Embodiment 2. FIG.
FIG. 4 is a flowchart showing the operation of the database creation function of the document creation control means 7 according to the second embodiment of the present invention. Since the editing support system that realizes the operation of the flowchart in FIG. 4 can be realized with the same configuration as that in FIG. 1, FIG. 1 will be used for the description of the database confirmation function operation. The document creation control unit 8 reads the document file specified by the document creation operator from the document storage unit 11 and causes the document creation display unit 10 to display the document file (S41). When a database confirmation function instruction is input from the document creation operator to the document creation input means 9 and the document creation control means 8 receives the input signal, the database confirmation function processing is started (S42). The document creating means 8 finds a referenced part in the document based on the read document data in the document file, and reads the DB input data of the table, column and row referred to in the part from the specification database 5 (S43). .

  The document creating means 8 compares the read DB input data with data (hereinafter, referred to as reference location data) which is captured and held in the document data (S44). It is determined whether the data at the location is the same (S45). If the data is not the same, the read DB input data is assumed to have been newly created, updated, or deleted, and it is determined whether the data at the reference location is empty (hereinafter referred to as null) (S46). . If the data of the reference portion is null, the read DB input data is not null. Therefore, the read DB input data is assumed to be newly created. The document creation display data for displaying the data and the read DB input data side by side is transmitted and displayed on the document creation display means 10 (S47). If the data at the reference location is not null, it is determined whether the DB input data read next is null (S48). If the read DB input data is null, it is assumed that the data of the reference location, which is the previous DB input data, has been deleted. For example, the reference location data and the read DB input data in red are added to the reference location in the document. The document creation display data to be displayed side by side is transmitted and displayed on the document creation display means 10 (S49). If the read DB input data is not null, it is assumed that the DB input data in the specification database 5 has been updated to another data. The document creation display data for displaying the data side by side is transmitted and displayed on the document creation display means 10 (S50). The document creation control means 8 prompts the document creation operator to select and confirm the data at the reference location, which is the previous DB input data, or to select the updated DB input data. The creation display data is transmitted to the document creation display means 10 and displayed (S51).

  If it is determined in S45 that the DB input data and the data of the reference location are the same, or if it is determined in S51 that the selection confirmation input has been input from the document input means 9, the data of the reference location and the data of the selection confirmation are determined. The data is processed based on the filter data and displayed on the document creation display means 10 (S52). The above processing is performed for all the reference parts in the document (S53).

  FIG. 5 is a diagram illustrating an example of a document display at the end of the database confirmation function. When the database confirmation function end instruction is input (S54), the document creation control means 8 determines whether the data selected and confirmed at the reference location is updated DB input data (S55). If the updated new DB input data has been selected and confirmed, the display color of the document creation and display means 10 is displayed with a lighter color for the reference portion (S56). This is performed for all reference locations, and the processing ends.

  As described above, according to the second embodiment, when a database confirmation function instruction is input, the document creation control unit 8 takes in the read DB input data into the document data and holds the data. Compared with the data of the reference location, it is determined whether the read DB input data and the data of the reference location are the same, and when it is determined that the read DB input data has been updated, the read DB input data is updated. Since the data and the data at the reference location, which is the previous DB input data, are displayed and it is possible to select whether any of the data is to be taken into the document, it is possible to perform document editing with a high degree of freedom. Further, when the read DB input data is different from the data of the reference portion, the display color of the read DB input data is changed by one of new creation, deletion, and update. , The state can be easily identified. Further, when new DB input data is selected, it is displayed in a light color and distinguished by the selected data, so that editing confirmation becomes easy. Further, even when new DB input data is fetched using the filter data, the previous data expression format can be automatically reproduced in the new DB input data, thereby facilitating document editing.

Embodiment 3 FIG.
FIG. 6 is a diagram illustrating an example in which the editing support system according to the third embodiment of the present invention is used for editing support of a geographic information system (GIS). In the above embodiment, the editing support system is used for document support, but in the present embodiment, use of the editing support system for editing support of a geographic information system is considered. In the present embodiment, the specification database stores data relating to map positions and marks. In the search information database 7, a map identifier is stored in association with the reference data instead of the document identifier. The map identifier is similar to the document identifier of the first embodiment, and refers to a reference location on the map such as a folder name of a map file, a file name, and position data of a DB input data reference location on the map. It is composed of metadata for identification.

  In FIG. 6, Tokyo is referred to by Map A, Map B, and Map C. Regarding the map A and the map B, ☆ marks are set at the original positions of Tokyo on the map. Since the map C cannot be entered at the normal scale, a mark different from the original Tokyo position is marked with a star. Even in such a case, by associating, the map file that is referred to as Tokyo can be easily searched for, and the omission of editing hardly occurs.

Embodiment 4 FIG.
In the above-described embodiment, the DB control unit 1 and the document creation control unit 8 are described as separate units. However, the present invention is not limited to this. The operation of the means may be performed. Further, the specification database 5, the log database 6, the search information database 7, the document result recording unit 4, and the document storage unit 11 are described as separate storage units, but the present invention is not limited thereto. You may make it memorize | store separately in the same memory | storage means (for example, hard disk etc.). Further, there is no problem even if the respective means are connected by a network using a communication line or the like.

1 is a block diagram of an editing support system using a database according to a first embodiment of the present invention. 5 is a flowchart illustrating a search information storage function operation of the document creation control unit 8 according to the first embodiment. It is a flowchart showing operation | movement of database management centering on the DB control means 1 concerning 1st Embodiment. 9 is a flowchart illustrating an operation of a database confirmation function of a document creation control unit 7 according to the second exemplary embodiment of the present invention. FIG. 11 is a diagram illustrating a document display example at the time of termination of a database confirmation function. It is a figure showing the example used for editing support of the geographic information system concerning a 3rd embodiment of the present invention.

Explanation of reference numerals

Reference Signs List 1 database control means 2 database input means 3 database display means 4 comparison result recording section 5 specification database 6 log database 7 search information database 8 document creation control means 9 document creation input means 10 document creation display means 11 document storage section

Claims (5)

In an editing support method using a database that refers to data stored in a database and incorporates the referenced data into data to be edited to perform editing,
Inputting the edit target data;
When a database confirmation instruction is input, the data at the position represented by the metadata is read from the database based on the metadata recorded in the data to be edited and representing the position of the referenced data in the database. Process and
Determining whether the data read from the database and the referenced data are the same,
When the data read from the database and the referenced data are different, displaying both the data read from the database and the referenced data, prompting the selection of data,
Importing the selected data into the edit target data as new referenced data. When judging that the data read from the database and the referenced data are different,
If the referenced data is empty data, the data read from the database is determined to be newly created data,
If the referenced data is not empty data and the data read from the database is empty data, it is determined that the referenced data has been deleted in the database,
If the referenced data is not empty data, and the data read from the database is not empty data, the data read from the database is determined to be updated data,
2. The editing support method using a database according to claim 1, wherein the data read from the database and the referenced data are displayed by being distinguished by respective judgments, and a selection of data is prompted. In the step of loading the selected data into the edit target data as newly referenced data,
3. The editing support method using a database according to claim 1, wherein when the selected data is the data read from the database, the selected data is displayed separately from the case of the referenced data. . In the step of loading the selected data into a document as newly referenced data,
3. The editing using a database according to claim 2, wherein the selected data is processed and then loaded into a document based on the filter data storing a data processing procedure to be performed on the referenced data. How to help. In an editing support system using a database that refers to data stored in a database and incorporates the referenced data into data to be edited to perform editing,
When the edit target data is input and a database confirmation instruction is input, the metadata indicates based on the metadata recorded in the edit target data and indicating the position of the referenced data in the database. Read the position data from the database,
Determined whether the data read from the database and the referenced data are the same,
When the data read from the database and the referenced data are different, both the data read from the database and the referenced data are displayed, prompting the selection of data, and displaying the selected data. A computer-readable recording medium storing an editing support program using a database, wherein the data is taken into the editing target data as new referenced data.

Images