JPH0512084A - Data controller - Google Patents

Abstract

PURPOSE:To retrieve the necessary data in the name of an original data base and to return the synthesized data base to the condition before synthesization by giving the name of each data base to all data respectively as a keyword when plural data bases are combined to one data base. CONSTITUTION:An editing means 14 is equipped with a retrieving means 15 to retrieve the data base with a keyword and a registering means 16 to give the keyword to respective data and perform the rewriting of a data base name, register the data and erase the data and so forth. A data base system 10 having such a data controller can give plural keywords for respective data. The data can be retrieved by the keyword.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data management device for managing various data registered in a database, and more particularly to a data management device capable of synthesizing a plurality of databases to create one database.

[0002]

2. Description of the Related Art Conventionally, when creating a new database, it has been common to add new contents while referring to a plurality of existing databases. In addition, there is a case where one database is created by extracting only a necessary part from a plurality of existing databases. In the conventional data management device, for example, after selecting the icon of the database to be combined on the screen, press the transfer (move) key to match the icon of the database to be combined with the icon of another database,
When the synthesis instruction is input, all the data in each database are synthesized as one database.

[0003]

By the way, in the conventional data management apparatus, when a plurality of databases are combined into one, it is possible to determine which database the certain data was originally registered after the combination. There wasn't.
Therefore, there is an inconvenience that only the data existing in the specific original database cannot be extracted from the synthesized database. Further, in order to divide the synthesized database into the state before the synthesis, the user needs to remember the original state, and the work becomes complicated.

According to the present invention, even if a plurality of databases are combined into one, the required data can be searched for by using the name of the original database, and the combined database can be easily combined before being combined. An object of the present invention is to provide a data management device that can be returned to the state.

[0005]

In order to solve the above problems, in the data management apparatus according to the present invention, a keyword assigning means for assigning at least one keyword to each data in the database, and the keyword are assigned. A storage unit that stores a plurality of databases having data and its own identification name, a search unit that searches the data in the database using the keyword or the identification name, and a combination of the databases when there are a plurality of the databases,
Or, it comprises an instruction means for giving an instruction for various processing such as division, and a display means for displaying and outputting each data of each database.

[0006]

For example, when synthesizing the database A and the database B, first, the search means searches the storage means for a character string representing the identification name of the database A. Then, the character string is added as a keyword to all the data in the database A. Similarly, the storage means is searched for a character string representing the identification name of the database B, and all the data in the database B are added with the character string as a keyword. Next, the identification name of the database A is rewritten with the identification name of the newly created database. Then, all the data is taken out from the storage means of the database B and passed to the database A. In the database A, the received data is registered in the storage means, and finally the database B is deleted. According to this, when two databases are combined into one, the identification name of each database is added as a keyword to all the data of each database, so if the database identification name is searched as a keyword, it is applicable. You can easily retrieve only the data that is in the database of distinguished names. Further, since it is not necessary to remember in which database the specific data was registered, the synthesized database can be easily returned to the state before the synthesis.

[0007]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of a data management device according to the present invention will be described below with reference to the drawings.

FIG. 2 is a block diagram showing the configuration of an embodiment of the data management device according to the present invention. This data management device includes a CRT 1, a CRT control unit 2, a keyboard 3,
It is composed of a mouse 4, a keyboard / mouse controller 5, a database 6, a database controller 7, a memory device 8 and a CPU 9.

The CRT control unit 2 is a control device of the CRT 1 for displaying various data on the display, and displays and outputs each data of the database 6 in addition to windows and icons.

The keyboard 3 is an input device for inputting character strings, numerical values, commands and the like, and a mouse 4 as a pointing device is connected to the keyboard 3. The mouse 4 is used to move a cursor displayed on the CRT 1 or click a displayed icon to input a predetermined instruction to the device. Various data and instructions input by the user from the keyboard 3 and the mouse 4 are sent to the CPU 9 through the keyboard / mouse control unit 5.

The database control unit 7 includes a database 6
Control the input and output of data in. A plurality of databases 6-1, 6-2, 6-n are connected to the data management device via a database control unit 7, and these databases form a database system to be described later. ..

The memory device 8 is a storage means for storing a program for controlling the data management device and temporarily storing data for various works.

A CPU (Central Processing Unit) 9 is a circuit that controls the entire device and performs arithmetic processing on predetermined data based on various instructions. The CPU 9 performs a process of combining and dividing databases, and a process of adding the identification name of each database as a keyword to all the data of each database when combining the databases into one.

FIG. 1 shows a functional configuration of a database system 10 constructed by the data management device. In FIG. 1, the user interface 11 is composed of a display means 12 corresponding to the CRT 1 and the CRT control section 2 of FIG. 2 and an input means 13 corresponding to the keyboard 3, mouse 4 and keyboard / mouse control section 5. The editing unit 14 performs various editing processes (synthesis, division, etc.) on the database, and the searching unit 15 that searches the data in the database using a keyword or an identification name, and at least 1 for each data in the database It is provided with a registration means 16 for giving one keyword and rewriting the database name, and registering and deleting various data. The editing means 15 is composed of the CPU 9 of FIG. Data storage means 1
Reference numeral 7 denotes a storage device in which a plurality of databases having data with a keyword and an identification name are stored.
The database 6 of FIG.

The database system 10 can add a plurality of keywords to each data and can search the data by the keywords. Also,
Each database stored in the storage means 17 for data and the like has a unique name (identification name).
In this database system, when an instruction to synthesize the plurality of databases is input via the input means 13 of the user interface 11, the editing means 14
The respective identification names in the database are retrieved by the retrieval means 15 of. The registration means 16 adds the identification name as a keyword to all the data in each database, and synthesizes the data.

Next, a specific example of the case where a plurality of databases are combined to create one database in the above-mentioned database system will be described. Here, FIG.
A database named "Exported Goods" as shown in
A case where a database named "imported goods" as shown in FIG. 4 is synthesized to create a database named "imported / imported goods" will be described.

In the database named "exported goods" in FIG. 3, each data is divided into a heading and a content.
Keywords are assigned to each record. Headings and content can be searched by these keywords. The same applies to the database named "imported goods" in FIG. The user interface on the display of this database system is a window as shown in FIG. In FIG. 5, by inputting a keyword as a search key in the search key input area 21 and pointing the search button 22 with the mouse, the corresponding data is searched from the database named “exported goods”,
It is displayed in the search candidate display area 23 and the search result display area 24. By selecting the iconize button 25, the window is closed and the icon shown in FIG. 6 is displayed. FIG. 7 shows a display example on the display when a database named “exported goods” is searched for with the keyword “US”. The database named "imported goods" in FIG. 4 also has the same user interface as in FIG.

A database named "exported goods",
Instructions for synthesizing databases named "imported products" are given by overlapping the icons of both databases by operating the mouse as shown in FIG. When there is a synthesis instruction, a window 31 for registering the synthesized database name appears. In the typing area 32 on this window 31, enter "import / export goods" to register the name of the synthesized database.

Next, a processing procedure for assigning the keyword "exported product" to all data in the database named "exported product" will be described with reference to the database system configuration diagram of FIG. 9 and the flowchart of FIG. .. In FIG. 9, ~ indicates the order of processing.

First, the retrieval means 15 of the editing means 14 is used to retrieve from the storage means 17 for data or the like the "exported goods" of the character string representing the database name (step 101). Transfer (step 102). Then, the character string "exported goods" is passed to the registration means 16 (step 103). The registration means 16 registers the character string "exported goods" in the keyword items of all data in the storage means 17 for data etc. (step 104).

The state of the database thus obtained is shown in FIG. In FIG. 11, the character string "exported goods" is registered in the keyword item. On the other hand, FIG. 12 shows a state in which the same operation is performed on the database named “imported goods”. In FIG. 12, the character string “imported goods” is registered in the keyword item.

Next, the processing procedure for combining the above two databases will be described with reference to the database configuration diagram of FIG. 13 and FIG.
It will be described with reference to the flowchart of FIG. Note that in FIG. 13, database A corresponds to “exported goods” in FIG.
The database B is assumed to correspond to "imported goods" in FIG. Further, ~ indicates the order of processing.

First, using the registration means of the database A, the database name "exported goods" is rewritten to "imported / exported goods" (step 201). Next, all the data are retrieved from the storage means such as data using the search means of the database B and passed to the registration means of the database A (step 202). The registration means of the database A registers the received data in the storage means such as the data of the database A (step 203). Finally, the database B is deleted (step 204).

FIG. 15 shows the state of the database A after the series of processes is completed. The data of this synthesized database is shown in FIG. As is clear from FIG. 16, since the original database name “exported goods” or “imported goods” is added as a keyword to each data of the synthesized database “exported goods”, as shown in FIG. When a keyword "exported product" is entered in the search key input area 21 and a search is performed, only the data in the database named "exported product" can be easily retrieved.

In the above embodiment, whether or not the function of assigning the database name as a keyword to each data at the time of database synthesis is activated may be left to the selection of the user. For example, as shown in FIG. 18, before adding the database name to each data as a keyword, a window asking whether or not to add a keyword is displayed. The user can select the "Yes" or "No" button 25 on the window for each database with the mouse.

Further, by constructing a new database with only the data displayed in the search candidate display area in the window of FIG. 5, the once synthesized database can be easily returned to a plurality of original databases. The function of constructing a new database can be realized by existing technology.

[0027]

As described above, in the data management apparatus according to the present invention, when synthesizing a plurality of databases into one database, the names of the databases are given to all the respective data as keywords. Therefore, it is possible to retrieve only the data existing in the specific original database by searching the synthesized database for the required data using the name of the original database. Further, according to this, the synthesized database can be easily returned to the state before the synthesis.

[Brief description of drawings]

FIG. 1 is a diagram showing a functional configuration of a database system constructed by a data management device.

FIG. 2 is a configuration block diagram showing an embodiment of a data management device according to the present invention.

FIG. 3 is a diagram showing a database named “export goods”.

FIG. 4 is a diagram showing a database named “imported goods”.

FIG. 5 is a diagram showing a user interface on a display.

FIG. 6 is a diagram showing icons when the window of “exported goods” is closed.

FIG. 7 is a diagram showing a display example on a display.

FIG. 8 is a diagram showing an instruction procedure when synthesizing databases.

FIG. 9 is a configuration diagram of a database system.

FIG. 10 is a flowchart showing a processing procedure when a keyword is added to all data in the database.

FIG. 11 is a diagram showing an example of a database to which keywords are added.

FIG. 12 is a diagram showing an example of a database to which keywords are added.

FIG. 13 is a configuration diagram of a database system.

FIG. 14 is a flowchart showing a processing procedure for synthesizing two databases.

FIG. 15 is a diagram showing a state of database A after the combining process is completed.

FIG. 16 is a diagram showing data of a synthesized database.

FIG. 17 is a diagram showing a user interface on a display.

FIG. 18 is a diagram showing an instruction procedure for selecting whether or not to add a keyword.

[Explanation of symbols]

1 ... CRT, 3 ... keyboard, 4 ... mouse, 6 ... database, 9 ... CPU (central processing unit), 10 ... database system, 11 user interface, 12 ...
Display means, 13 ... Input means, 14 ... Editing means, 15 ... Search means, 16 ... Registration means, 17 ... Storage means for data, etc.

Claims (1)

Claim: What is claimed is: 1. A keyword assigning unit that assigns at least one keyword to each data in the database, and a storage unit that stores a database having the keyword-assigned data and an identification name. One of the databases is provided, comprising: a search unit that searches the data in the database using the keyword or the identification name; an instruction unit that gives an instruction of various processes to the database; and a display unit that displays and outputs various data. A data management device characterized by adding an identification name of each database as a keyword to all the data of each database when synthesizing.