JP2003140933A - General purpose database built-in system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a system for generally and easily building data into a database. SOLUTION: Data delimited by [¥t] (tab) is aligned in an input file, the end of each data is [¥n]. A template file includes a table name, the number of columns, a KEY name, a processing section. A DATABASE (database) building-in part 3 determines a data storing table based on the table name in the template file, the number of data inputs based on the number of columns, a KEY column based on the KEY name, and an input processing (INSERT, UPDATE) based on the processing section, produces and issues an SQL sentence, and stores data.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a system for processing data with respect to a database, and more particularly to a system for processing data without paying attention to a schema, a table name and a table layout.

[0002]

2. Description of the Related Art In a widely used database, the schema of the database is defined,
In the conventional database incorporation, for example, in order to update the database, the data cannot be updated unless the schema, table name, and column name of the database are taken into consideration.

[0003]

Therefore, the conventional mechanism has the following problems. In other words, when the schema of the database is changed, it is necessary to create and modify a program each time a table is added or a column is changed. The present invention solves the above problems and provides a wide variety of database embedding methods.

Another object of the present invention is to provide a system that can easily and universally incorporate data into a database.

[0005]

According to the present invention for achieving the above object, input data to a database and corresponding to this input data, at least a table name of the database,
A template including the number of columns, a key name, and a processing division is received, the target database item is specified based on the table name, the number of columns, and the key name included in the template, and the specified with respect to the input data. It includes a general-purpose database embedding system including a database embedding means for performing the processing designated by the processing classification with an item as a processing target.

Further, the database embedding means creates an SQL description for operating the database based on the input data and the template.

Further, the above system determines a target database based on the additional information of the input data, identifies an item to be processed by referring to the determined target database, and selects the item to be identified. A template creating means for extracting the corresponding table name, the number of columns, and the key name, and creating a template for the target database based on the extracted table name, the number of columns, the key name, and the designated processing information. , Prepared for more.

The invention of the above system is also realized as a method invention. Further, the above invention is also realized as a program for causing a computer to realize a predetermined function or a recording medium recording the program.

The means in this specification can be realized by hardware, software, or a combination of hardware and software. Execution by a combination of hardware and software corresponds to execution in a computer system having a predetermined program, for example.

Even if the function of one means is realized by two or more pieces of hardware, software or a combination of hardware and software, 2
The functions of one or more means may be realized by one piece of hardware, software, or a combination of hardware and software.

[0011]

BEST MODE FOR CARRYING OUT THE INVENTION Embodiments of the present invention will be described below with reference to the drawings. Here, FIG. 1 is a block diagram showing a configuration of a general-purpose database built-in system according to an embodiment of the present invention.

(Outline of Embodiment) The present invention provides a mechanism for incorporating data without considering the schema name, the table name, and the table layout. Figure 1
In, the input files (input data) 1 and 3 and the templates 2 and 4 are transmitted to the DATABASE (database) 100. In the input files 1 and 3
There are data groups separated by [\ t] (tab). The templates 2 and 4 mainly describe the structure or format of the target database, including the table name 10, the number of columns 20,
There are a KEY name 30 and a processing division 40.

DATABASE (database) incorporation 3
Is input file 1 from template 2 table name,
The number of columns, the KEY name, and the processing category are read, and the data is stored in the table (TABLE A). Similarly, the input file 3 reads information from the template 4 and stores the data in the table (TABLE B).

By thus preparing the template corresponding to the input file, it is possible to update the database without being aware of the design of each table.

(Structure of Embodiment) Next, the structure of the embodiment will be described. Referring to FIG. 1, an embodiment of a general-purpose database built-in system of the present invention comprises a host computer A101 and a store computer B102. The store computer B102 is
Includes DATABASE embedded 3. Each of these means operates roughly as follows.

DATABASE (database) incorporation 3
Reads the data storage table with the table names included in the templates 2 and 4 transmitted from the host computer A101 and stores the input files 1 and 3.

(Operation of Embodiment) Next, the overall operation of the general-purpose database embedded system according to the embodiment of the present invention will be described in detail with reference to FIGS. 1 and 2.
Here, FIG. 2 is a flowchart for explaining the operation of the general-purpose database built-in system according to the embodiment of the present invention.

First, when the input data is created, the host computer A101 transmits the input files 1 and 3 and the template files 2 and 4 to the store computer B102 (step A1 in FIG. 2).

Next, DATABASE (database)
The embedded 3 reads the data storage table from the table name included in the template files 2 and 4, and stores the input files 1 and 3 in the data storage table. (Step A2).

(Specific Example) Next, a specific example will be described in more detail. Here, FIG. 3 is a block diagram showing an example of the general-purpose database built-in system of the present invention. Figure 3
As shown in, the input file contains data separated by [\ t] (tab), and the end of 1 (each) data ends with [\ n]. The template file includes the table name, the number of columns, the KEY name, and the processing classification.

DATABASE (database) incorporation 3
Determines the data storage table by the table name of the template file, determines the number of data inputs based on the number of columns in the file, the column that becomes KEY from the KEY name, and the input processing (INSERT, UPDATE) from the processing classification. The SQL statement as shown is created and issued, and the data is stored.

(Other Specific Example) Next, another specific example will be described. Here, FIG. 4 is a block diagram showing another example of the general-purpose database built-in system of the present invention. Note that in FIG. 4, the database embedding 3 is shown as a database deletion 4. As shown in Figure 4, the input file contains [\
The data separated by t] (tab) are arranged, and the end of one data ends with [\ n]. The template file includes the table name, the number of columns, the KEY name, and the processing classification.
In DATABASE (database) deletion 4, the data deletion table is determined by the table name of the template file, the deletion line of the data is determined from the number of columns in the file, and the deletion processing is performed from the processing category (TURUNCATE, DELETE).
Then, the SQL statement is created and issued, and the data is deleted.

(Other Embodiments) Next, other embodiments will be described. In another embodiment of the invention, FIG.
The host computer A101 is configured to include a template creating unit (not shown). The template creating means has a function of creating a template to be transmitted to the store computer B102, and particularly has a function of dynamically creating a template corresponding to each database.

More specifically, first, input data and processing information such as update are input to the template creating means. Here, additional information is attached to the input data. This additional information includes information corresponding to the column name, KEY name, etc. of the database table.

Upon receiving the input data and the additional information, the template creating means searches one or a plurality of databases based on the column name and the KEY name included in the additional information to determine the target database.

Next, the item to be processed is specified by referring to the target database. Then, the table name, the number of columns, and the key name corresponding to the specified items are extracted and used as the contents of the template.

Then, processing information such as update, insertion, and deletion input by the operator and the extracted table name,
A template including a table name, the number of columns, a key name, and a processing category is created based on the number of columns and the key name.
Information for identifying the target database may be added to the template.

By doing so, it becomes possible to dynamically create a template in accordance with the input data and the additional information.

The template creating means may search a database condition information file (not shown), extract conditions specific to the target database, and create the template by adding the extracted conditions. .
It should be noted that the database condition information file stores specific format conditions, or specific conditions (such as commands) for operating individual databases.

By doing so, even when a plurality of databases to be incorporated have different conditions regarding their formats, etc., it is possible to create a template suitable for each database. Further, it becomes possible to use the database embedding means having the same function (without customization) for a plurality of databases having different format conditions and the like.

In the above example, the host computer A101 is provided with the template creating means, but the present invention is not limited to this, and the store computer B is not limited to this.
It may be included in 102. Further, a database backup database is provided on the host computer A101 side, and when the template creating means creates a template, the backup database can be referenced to reduce the database processing load. .

When the present invention is implemented in a client / server type system, the database embedding means may be provided in the database server and the template creating means may be provided in the client side. It may be provided. further,
The template creating means may be provided in a server different from the database server.

Although the present invention has been described with reference to the preferred embodiment, the present invention is not limited to the above embodiment. Those skilled in the art can make appropriate changes or improvements based on the contents disclosed herein without departing from the scope of the present invention. Further, such changes or improvements are also included in the present invention.

[0034]

As described above, according to the present invention,
The first effect is that the database can be updated without being aware of the design of each table. The reason is that the design of each table receives the template file as information.

The second effect is that the versatility of incorporating a database is wide. The reason is that it is easy to create input data and template files.

[Brief description of drawings]

FIG. 1 is a block diagram showing a configuration of a general-purpose database embedded system according to an embodiment of the present invention.

FIG. 2 is a flowchart illustrating an operation of the general-purpose database embedded system according to the embodiment of the present invention.

FIG. 3 is a block diagram showing an example of a general-purpose database built-in system of the present invention.

FIG. 4 is a block diagram showing another example of the general-purpose database built-in system of the present invention.

[Explanation of symbols]

3 DATABASE (database) incorporation 100 databases 101 Host computer A 102 Store computer B

   ─────────────────────────────────────────────────── ─── Continued front page    (72) Inventor Makoto Miyashita             18-6, Shinkiba, Koto-ku, Tokyo N             Within Easesoft Co., Ltd. F term (reference) 5B075 ND03 ND23 ND34 NK54 PR10                       QT06 UU40                 5B082 GA07

Claims (6)

[Claims] 1. An input data to a database and a template corresponding to the input data and including at least a database table name, the number of columns, a key name, and a processing division are received, and the table name, the number of columns included in the template, A general-purpose database embedding unit that includes a database embedding unit that identifies a target database item based on a key name, and performs the process specified in the process category with respect to the specified item as a process target for the input data. system. 2. The general-purpose database embedding system according to claim 1, wherein the database embedding means creates an SQL description for operating the database based on the input data and the template. 3. A target database is determined based on the additional information of the input data, an item to be processed is specified by referring to the determined target database, a table name corresponding to the specified item, The number of columns and key name are extracted, and the extracted table name, number of columns, and key name,
The general-purpose database embedding system according to claim 1 or 2, further comprising a template creating unit that creates a template for the target database based on designated processing information. 4. A computer receives input data to a database and a template corresponding to the input data and including at least a table name of the database, the number of columns, a key name, and a processing division, and a table name included in the template, The target database item is specified based on the number of columns and the key name, and the input data is caused to function as a database embedding unit that performs the process specified by the process classification, with the specified item as the processing target. Program for. 5. The program according to claim 4, wherein the database embedding means creates an SQL description for operating the database based on the input data and the template. 6. A computer determines a target database based on additional information of input data to the database, identifies an item to be processed by referring to the determined target database, and responds to the identified item. Functions as a template creating means for extracting the table name, the number of columns, and the key name to be created, and creating a template for the target database based on the extracted table name, the number of columns, the key name, and the specified processing information. A program to let you.