JPH04350740A - Data converting device - Google Patents

Abstract

PURPOSE:To relatively easily and efficiently perform data conversion between data bases. CONSTITUTION:Item names are checked by the control of a controller 10, and an item number to be converted is set to a conversion table 12. When the conversion table generation processing is started in the conversion table 12 by the control of the controller 10, card type data base item names are read in, and the conversion item is retrieved and conversion information is set, and item names of conversion source data and conversion destination data are checked. It is checked whether conversion source data and conversion destination data include the same item name or not, and the conversion table 12 is corrected if they have no same item names, but the item name is added to the conversion table otherwise. The conversion table 12 generated in this manner is used to convert data of the same item name as data of one item by the controller 10.

Description

[Detailed description of the invention]

0001

[Industrial Application Field] The present invention enables data exchange between databases.
The present invention relates to a data conversion device that performs data conversion.

0002

2. Description of the Related Art Generally, a database handled by this type of data conversion device is composed of data having a plurality of items. For example, in a database related to an address book, , data having an item called name, and data having an item called address. A database configured in this manner is usually stored in a suitable storage medium as data information for each item along with format information such as item name and item size.

[0003] When converting data between databases in which each item of data is stored in this way, conventional data conversion devices do not change the format of the database. Conversion is performed for each item according to the following.

0004

SUMMARY OF THE INVENTION In this type of data conversion apparatus, it is generally desired to perform data conversion more efficiently using simpler processing. However, according to the conventional data conversion device as described above, the data
Since conversion is performed item by item according to the database format, it is necessary to keep the number of data items and item sizes the same during actual data conversion work.
There is a problem that the conversion process becomes complicated and takes time.

The present invention has been made in view of the above-mentioned conventional problems, and provides a data conversion device that can perform data conversion in a database relatively easily and efficiently. The task is to do so.

[0006]

[Means for Solving the Problems] In order to achieve the above-mentioned problems, the data conversion device of the present invention converts data between databases including a plurality of data items each having an item name. A data conversion device that performs data conversion, an identification means for identifying an item name of conversion source data and an item name of conversion destination data;
The present invention is characterized by comprising a conversion means for converting data having the same item name identified by the identification means as one data.

[0007]

[Operation] According to the data conversion device of the present invention, when converting data between databases including a plurality of data items each having an item name, the identification means identifies the source of conversion. The item name of the data and the item name of the conversion destination data are identified, and the conversion means converts data having the same item name identified by the identification means as one data. It is not necessary to have the same number of items or item sizes when converting data, and it is relatively easy and efficient to convert between different databases, regardless of the order of the items in the data to be converted. Data conversion can be performed well.

[0008] From the following examples of the present invention, these effects of the present invention will become clearer, and other effects of the present invention will become clearer.

[0009]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Examples of the present invention will be described in detail below with reference to the drawings.

FIG. 1 is a block diagram schematically showing the configuration of a data conversion device as an embodiment of the present invention together with a database.

In the figure, the data conversion device includes a control device 10, a program memory 11, a conversion table 12, a keyboard 13, and a display device 14.

[0012] The control device 10 receives the data as described below.
It is a device that performs control to operate the data conversion device,
For example, it is composed of a CPU (central processing unit), a semiconductor memory device, and the like. The program memory 11 is connected to the control device 10 and stores a program that causes the control device 10 to perform data conversion processing. Such program memory 11 is, for example, RAM (readable/writable memory) or ROM (read-only memory).
It is composed of etc.

The conversion table 12 is connected to the control device 10, and is a memory for checking item names and setting item numbers to be converted under the control of the control device 10, as will be described later. Such a conversion table 12 is composed of, for example, a RAM or the like. The keyboard 13 is connected to the control device 10 and is used to input a series of operating commands to the control device 10. keyboard 1
3 includes various keys such as character/numeric keys and control keys. The display device 14 is connected to the control device 10 and is used to display a series of operations using characters or the like under the control of the control device 10. The display device 14 is, for example, a CRT (cathode ray tube) display device or an LCD.
(liquid crystal display) device, etc. As described above, in this embodiment, the conversion table 12 constitutes an example of identification means, and the control device 10 constitutes an example of conversion means.

On the other hand, a format memory 101 and a data memory 102 of a database to be subjected to data conversion are connected to the control device 10 in such a manner that they can be accessed. Here, the format memory 101 is
This is a memory that stores layout information of the database. Data memory 102 is a memory that stores database data. The format memory 101 and the data memory 102 are constituted by large-scale storage devices such as hard disk storage devices, semiconductor memory devices, and the like. 2 and 3 schematically show specific data structures in the format memory 101 and data memory 102, respectively.

In FIG. 2, the format memory stores paper information, various format information, and item information i (i=1
, 2,...n). Here, as paper information, information such as the paper size, left and right, top and bottom margins, etc. is set. Further, as shown in the figure, the item information i is composed of an item number, an item name, an item size, and an item attribute.

Further, in FIG. 3, the data memory constitutes a card-type database, and data for items 1 to n are stored for each card numbered 1 to m. - data is stored.

Next, the operation of the data conversion apparatus configured as described above will be explained using FIGS. 4 and 5. Here, FIG. 4 is an explanatory diagram showing an overview of data conversion by the data conversion device, and FIG. 5 is a flowchart of a conversion table creation process related to the data conversion operation. - It is.

In FIG. 4, the conversion source includes item names such as "Address 1", "Address 2", and "Address 3" in addition to "Name". On the other hand, the conversion destination includes the item name "address" in addition to "name". That is, in this case, since they have a common item name "Address", these are identified by a conversion table under the control of the control device, and are converted into "Address 1", "
"Address 2" and "Address 3" are combined into one item and converted.

In FIG. 5, when the conversion table creation process is started, first, in step S1, the card type data is
Reads the database item name. Next, step S2
, search for conversion items and set conversion information. Subsequently, in step S3, the item names of the conversion source data and conversion destination data are checked. Here, in step S4, it is determined whether the checked item name is the final one, and if it is the final one (YES), the conversion table creation process is ended.

[0020] In step S4, if it is not the final (
If NO), the process proceeds to step S5, where it is checked whether or not the conversion source data and conversion destination data contain the same item name. Then, in step S6, if there is no same item name (NO), the process advances to step S7 and the conversion table is corrected. Further, in step S6, if there is the same item name (YES), the process advances to step S8 and a conversion table is added. When the processing in step S7 or S8 is completed, the process returns to step S3, and the data item names are checked again.

Using the conversion table created in this manner, the control device converts data having the same item name into one item or, conversely, separates the data.

As described above, when the conversion source data and conversion destination data contain the same item name, a conversion table is added, and when they do not contain the same item name, a conversion table is added. Since the conversion table is modified, data with the same item name can be converted into one item by the control device using such a conversion table, or conversely, data can be separated and converted.
Data conversion can be performed relatively easily and efficiently in a database.

[0023]

As described in detail above, according to the present invention, when converting data between databases each containing a plurality of data items each having an item name, the identification means identifies the item name of the conversion source data and the item name of the conversion destination data, and the conversion means converts data that have the same item name identified by the identification means as one data. Therefore, regardless of the order of the items of data to be converted, data conversion can be performed relatively easily and efficiently between different databases.

[Brief explanation of drawings]

FIG. 1 is a block diagram schematically showing the configuration of a data conversion device as an embodiment of the present invention together with a database.

FIG. 2 is an explanatory diagram schematically showing the data structure of the format memory of FIG. 1;

FIG. 3 is an explanatory diagram schematically showing the data structure of the data memory of FIG. 1;

FIG. 4 is an explanatory diagram showing an overview of data conversion by the data conversion device of FIG. 1;

FIG. 5 is a flowchart of conversion table creation processing related to the data conversion operation of FIG. 1;

[Explanation of symbols]

10 Control device 11 Program memory 12 Conversion table 13 Keyboard 14 Display device 100 format memory 101 Data memory

Claims (1)

[Claims] [Claim 1] Data conversion between databases configured to include a plurality of data items each having an item name.
The data conversion device is equipped with an identification means for identifying the item name of the conversion source data and the item name of the conversion destination data, and for data in which the item name identified by the identification means is the same. 1. A data conversion device comprising: conversion means for converting the data into one data.