JP2002132551A - Database system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a database system capable of treating XML data without new designing and creating of data definition command and capable of operating the XML data with SQL language. SOLUTION: In the system, an analysis control means 1 of XML defining information creates XML defining information to define a storage format and data storage space from defining information of inputted the XML data. A SQL conversion means 9 of data define command converts the XML defining information and a space creating command created by the means 1 into data configuration defining information of SQL and a space creating command of SQL. A SQL converting means 10 of data operating command converts XML data operating commands outputted from a storage control means 4 of the XML data, an update control means 5 of the XML data, a searching control means 6 of the XML data and a deletion control means 7 of the XML data into SQL data operating commands.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

[0001] 1. Field of the Invention [0002] The present invention relates to a database system used to save a large amount of data storage space and to speed up data retrieval.

[0002]

2. Description of the Related Art FIG. 11 is a block diagram showing the configuration of a conventional database system. As shown in FIG.
The database system includes a database management unit 201
, A definition information storage area 2, and a data storage storage area 8.

[0003] The data definition instruction 14 corresponds to the application 1
When the database management unit 201 transmits the data definition command 14 to the database management unit 201, the database management unit 201 stores definition information such as a data format that can be processed in the definition information storage area 2. Next, the database management unit 201
Creates an area creation command for storing data in accordance with the stored definition information in the data storage area 8, and determines a data storage area for storing the data.

When the data operation command 22 is transmitted from the application 11, the database management unit 201 first determines whether the data operation command 22 is a data storage command, an update command, a search command, or a delete command. Determine if there is.

When the data operation command 22 is a storage command, the database management unit 201 checks the definition information stored in the definition information storage area 2 and stores the definition information in the data storage storage area 8. Store the data that

When the data operation command 22 is an update command, the database management unit 201 checks the definition information stored in the definition information storage area 2 and updates the definition information from the data storage storage area 8 to be updated. Search for existing data and update that data.

If the data operation command 22 is a search command, the database management unit 201 checks the definition information stored in the definition information storage area 2 and retrieves from the data storage storage area 8 data satisfying the search condition. And returns the search result to the application 11.

When the data operation command 22 is a delete command, the database management unit 201 checks the definition information stored in the definition information storage area 2 and deletes the definition information from the data storage storage area 8. Search for data that exists and delete that data.

On the other hand, XML (eXtensible M) is a language for facilitating the transfer of data to software.
arkup Language). According to XML, by arbitrarily defining a tag, it is possible to describe what kind of data the described information is with the tag. Therefore, an application that performs data processing on the computer side can use the description. The obtained information can be taken in, processed for calculation, or made into a database. Note that data described in XML is called XML data.

However, when such XML data is to be handled by the database system, the attributes of the XML data must be applied to the data attributes that can be used by the database system. Has to be newly designed and created.

In a database system capable of handling XML data, the storage format of the XML data is SQ which is generally used in the database system.
Since the storage format is different from the storage format of L (Structured Query Language), there is a problem that the XML data cannot be operated by the SQL language.

[0012]

As described above, in the conventional database system, when the XML data is to be handled by the database system, the attributes of the XML data are applied to the data attributes that can be used by the database system. Therefore, there is a problem that a data definition command to be input to the database system must be newly designed and created.

Further, since the storage format of the XML data is different from the storage format of the SQL, the XML
There is a problem that L data cannot be operated.

According to the present invention, a data definition instruction is newly designed,
An object is to provide a database system that can handle XML data without creating it.

Further, the present invention provides an XML-based
An object of the present invention is to provide a database system capable of operating L data.

[0016]

In order to solve the above problems, a database system of the present invention specifies a data storage area for storing data and a storage format of data stored in the data storage area. A definition information storage area for storing definition information, and a data storage area for storing data according to the definition information while analyzing the input data definition command and storing the definition information in the definition information storage area. An area creation command for creating a storage area is created, a data storage area of the data storage area is determined, the definition information is confirmed according to an input data operation instruction, and the data is stored in the data storage area. A database management unit for storing, updating, retrieving and deleting data that has been When the XML definition information is input as the data definition command, the database management unit analyzes the XML definition information that specifies the storage format of the XML data, stores the XML definition information in the definition information storage area, and stores the XML definition information in the XML information. XML definition information analysis management means for creating an area creation command for creating a data storage area for storing XML data in the data storage area in accordance with the information, and an input data operation instruction being an XML data storage instruction; A data manipulation language analyzing unit for analyzing whether the command is an update command, a search command, a search command, or a delete command; and if the data manipulation command is an XML data storage command,
An XML storage management unit that checks the XML definition information with reference to the definition information storage area and stores the XML data to be stored in the data storage storage area; and wherein the data manipulation instruction is an XML data update instruction. If there is
XML update management means for checking the XML definition information with reference to the definition information storage area, searching the data storage storage area for XML data to be updated, and updating the XML data; Operation command is XM
If the command is an L data search instruction, the XML definition information is checked with reference to the definition information storage area, XML data to be searched is searched from the data storage storage area, and an XML that returns a search result is returned. A search management unit, wherein the data operation instruction is an XML data deletion instruction;
XML deletion management means for checking the XML definition information with reference to the definition information storage area, searching the data storage storage area for XML data to be deleted, and deleting the XML data. It is characterized by.

In the database system of the present invention, XM
By providing the L definition information analysis management means, the XML
Since the definition information can be used as a data definition command, the X data can be used without newly designing and creating a data definition command.
ML data can be handled.

In another database system according to the present invention, the XML definition information and the area creation command analyzed by the XML definition information analysis management means are stored in an SQL
A data definition command SQL conversion means for converting the data structure definition information into an SQL area creation command, the XML data storage management means, the XML data update management means, the XML data search management means, and the XML data deletion management means. And a data manipulation command SQL conversion means for converting the data manipulation command output from the SQL to a SQL data manipulation command and executing the data manipulation command.

In the database system of the present invention, the data definition command SQL conversion means and the data operation command SQL conversion means are provided, so that the XML definition information can be converted to SQL data.
Since it can be converted into L definition information and the XML data operation instruction can be converted into the SQL data operation instruction, the XML data in the database can be operated by the SQL language.

[0020]

Next, a database system according to an embodiment of the present invention will be described in detail with reference to the drawings. Note that all components denoted by the same reference numerals in all drawings indicate the same components.

(First Embodiment) FIG. 1 shows a first embodiment of the present invention.
It is a block diagram showing the composition of the database system of an embodiment. As shown in FIG. 1, the database system according to the present embodiment includes a database management unit 101, a definition information storage area 2, and a data storage storage area 8. The database management unit 101 includes an XML definition information analysis management unit 1 and a data operation language analysis unit 3
XML storage management means 4 and XML update management means 5
, An XML search management unit 6 and an XML deletion management unit 7.

The XML definition information analysis management means 1 is an XML
Definition information input means 1A and XML definition information analysis execution means 1
B, definition information output means 1C, and data storage area creation means 1
D. Further, the XML storage management means 4
An XML data storage execution unit 4A is provided, an XML update management unit 5 is provided with an XML data update execution unit 5A, an XML search management unit 6 is provided with an XML data search execution unit 6A, and an XML deletion management unit 7 is provided. Is provided with XML data deletion executing means 7A.

Next, the operation of the database system of this embodiment will be described. FIG. 2 shows the XML definition information 13
5 is a flowchart showing the operation of the database system of the present embodiment when a is input.

First, the XML definition information 13 is transmitted to the XML definition information analysis management unit 1 through the XML definition information input unit 1A.
(Step A1), the XML definition information analysis execution unit 1B analyzes the XML definition information 13 and
Create XML definition information that specifies the data storage format. In this case, the storage format is X
The format itself of the ML data can be used (step A2). Next, the XML definition information created by the XML definition information analysis executing means 1B is
C, and is stored in the definition information storage area 2 (step A3). Thereafter, an area creation command for storing the XML data according to the stored XML definition information in the data storage area 8 is created by the data storage area creation means 1D, and the data storage area for storing the data is determined. (Step A4).

FIG. 3 is a flowchart showing the operation of the database system of this embodiment when storing, updating, searching, and deleting data. When the data operation instruction 22 is input from the application 11 to the data operation language analysis means 3, the data operation language analysis means 3 analyzes the data operation instruction 22 (step B1), and the data operation instruction 22 is changed to the XML data storage instruction. Is checked (step B2).

If the data operation instruction 22 is an XML data storage instruction, the processing shifts to the XML storage management means 4, and the XML data storage execution means 4A refers to the definition information storage area 2 and The storage format is checked, and the XML data to be stored is stored in the data storage area 8.
(Step B3).

In step B2, the data operation instruction 2
2 is not an XML data storage command, the data manipulation language analysis means 3 checks whether the data manipulation command 22 is an XML data update command (step B).
4). If the data operation instruction 22 is an XML data update instruction, the processing shifts to the XML update management means 5, and the
The L data update execution unit 5A checks the data storage area and storage format with reference to the definition information storage area 2, searches the data storage storage area 8 for the XML data to be updated, and Update (Step B
5).

In step B4, the data operation instruction 2
2 is not an XML data update command, the data manipulation language analysis unit 3 checks whether the data manipulation command 22 is an XML data search command (step B).
6).

If the data operation command 22 is an XML data search command, the processing shifts to the XML search management means 6, and the data search execution means 6A stores the definition information storage area 2 by the XML data search execution means 6A. The storage area and storage format of the data are confirmed by referring to the data, the XML data to be searched is searched from the data storage storage area 8, and X
The search result of the ML data is returned to the application 11 (step B7).

In step B6, the data operation instruction 2
2 is not an XML data search command, since the data operation command 22 is an XML data deletion command, the processing shifts to the XML deletion management means 7, and the XML data deletion execution means 7A To check the storage area and storage format, search the data storage storage area 8 for XML data to be deleted, and
The L data is deleted (step B8).

For example, assume that an XML definition document as shown in FIG. 4 is defined. The database system of the present embodiment inputs the XML definition document as it is as XML definition information 13 and stores the XML definition information in the definition information storage area 2 of FIG. 1 according to the operation of the flowchart of FIG. Then, when a storage command, an update command, a search command, and a delete command as shown in FIG. 5 are input to the data manipulation language analysis means 3 in FIG. 1, respectively, based on the commands according to the operation of the flowchart in FIG. Store operation,
An update operation and a search operation are performed, and an XML as shown in FIG.
Document data is stored in the data storage area 8.

As described above, in the database system of the present embodiment, XM is used as the definition information of the database.
Since the L definition information can be input as it is, the database operation can be performed on the XML data without having to design and create a database in advance to use the XML data.

(Second Embodiment) Next, a database system according to a second embodiment of the present invention will be described with reference to the drawings. FIG. 7 is a block diagram illustrating a configuration of the database system according to the present embodiment. As shown in FIG.
In the database system of the present embodiment, in addition to the components of the database system of FIG. 1, a data definition command SQL conversion unit 9, a data operation command SQL conversion unit 10, and a SQL interface operation unit 11 are newly added. I have.

The data definition command SQL conversion means 9 converts the XML definition information output from the definition information output means 1C into SQL data structure definition information which is a standard database language, and is created by the data storage area creation means 1D. The area creation instruction is converted into an SQL area creation instruction.

The data manipulation command SQL conversion means 10
The XML data storage execution unit 4A, the XML data update execution unit 5A, the XML data search execution unit 6A, and the XML data deletion execution unit 7A execute XML data operation instructions executed by
It is converted into a QL data operation instruction and executed.

Next, the overall operation of the database system of the present embodiment will be described in detail with reference to the flowcharts of FIGS. FIG. 8 is a flowchart illustrating the operation of the database system according to the present embodiment when XML definition information is input.

First, the XML definition information 13 is transmitted to the XML definition information analysis management unit 1 through the XML definition information input unit 1A.
(Step C1), the XML definition information is analyzed by the XML definition information analysis execution unit 1B.
XML definition information that defines the storage format of the L data is created (step C2).

Then, the XML definition information output from the definition information output means 1C is converted into SQL data definition information by the data definition command SQL conversion means 9 and stored in the definition information storage area 2 (step C3).

Thereafter, the data definition command SQL conversion means 9
Converts the area creation command created by the data storage area creation means 1D into an SQL data definition command, and determines the storage area of the data storage storage area 8 for storing the SQL data (step C4).

FIG. 9 is a flowchart showing the operation of the database system of this embodiment when storing, updating, searching, and deleting data. First, data manipulation instruction 2
2 is input from the application 11 to the data manipulation language analysis means 3, the data manipulation language analysis means 3 analyzes the data manipulation instruction 22 (step D1) and determines whether the data manipulation instruction 22 is an XML data storage instruction. It is checked whether or not it is (step D2).

If the data operation instruction 22 is an XML data storage instruction, the processing shifts to the XML storage management means 4. The XML data storage execution unit 4A checks the storage area and storage format stored in the definition information storage area 2,
The XML data storage command is output to the data manipulation command SQL conversion means 10. Data manipulation instruction SQL conversion means 1
0 converts the XML data storage instruction into an SQL instruction, and stores the SQL data included in the SQL instruction in the data storage area 8 (step D3).

In step D2, data operation instruction 2
2 is not an XML data storage command, the data manipulation language analysis unit 3 checks whether the data manipulation command 22 is an XML data update command (step D).
4).

If the data operation instruction 22 is an XML data update instruction, the processing shifts to the XML update management means 5. The XML data update execution unit 5A checks the storage area and storage format with reference to the definition information storage area 2, and checks the XML
The L data update command is converted to a data manipulation command SQL conversion means 10
Output to The data manipulation command SQL conversion means 10 converts the XML data update command into an SQL command,
SQL data included in the QL instruction is retrieved from the data storage area 8, and the SQL data to be updated is updated (step D5).

If step D4 has not been executed, the data manipulation language analysis means 3 sends the data manipulation instruction 22
Is an XML data search command (step D6). If the data operation command 22 is an XML data search command, the processing shifts to the XML search management means 6. The XML data search execution means 6A checks the storage area and storage format with reference to the definition information storage area 2, and converts the XML data search instruction into the data operation instruction SQL.
Output to the conversion means 10. The data manipulation command SQL conversion means 10 converts the XML data search command into an SQL command, searches the data storage area 8 for SQL data,
The search result of the SQL data is converted into the search result of the XML data with reference to the definition information storage area 2 and returned to the application 11 (step D7).

In step D6, the data operation instruction 22
Is not an XML data search command, the data operation command 22 is an XML data deletion command, and the process shifts to the XML deletion management means 7. The XML data deletion execution means 7A refers to the definition information storage area 2 to check the storage area and storage format, and outputs the XML data deletion command to the data manipulation command SQL conversion means 10. The data manipulation command SQL conversion means 10 converts the XML data deletion command into an SQL command, and deletes the SQL data from the data storage area 8 (step D8).

For example, assume that an XML definition document as shown in FIG. 4 is defined. The database system according to the present embodiment inputs the XML definition document as it is as the XML definition information 13 and converts the XML definition information into SQL definition information as shown in FIG. 10 according to the operation of the flowchart in FIG. SQL definition information is stored in the information storage area 2.

The storage command, update command, search command, and delete command for the XML data as shown in FIG.
9 are converted into SQL instructions by the operation of the flowchart of FIG. 9 and stored, updated, and searched for in the data storage area 8 of FIG. , A delete operation is performed.

When an SQL command is input from the application 11 to the SQL interface operating means 12 shown in FIG. 7, data storage operation, update operation, search operation, and delete operation are performed by a standard SQL interface.

Further, in the database system of the present embodiment, by using the SQL interface operating means 12 as a standard SQL interface with the application 11, data in the data storage area can be accessed.

As described above, in the database system of the present embodiment, in addition to the effects of the database system of the first embodiment, the data stored in the data storage area 2 can be transferred to the ordinary SQL interface. Therefore, the data in the data storage area 2 can be accessed from the existing application 11 having the SQL interface.

[0051]

As described above, in the database system of the present invention, the XML definition information can be analyzed and converted into the definition information defining the storage format suitable for the database system. You can build a database.

Further, in the database system of the present invention, by providing the data definition command SQL conversion means, the data operation command SQL conversion means, and the SQL interface operation means, it is possible to convert the XML definition information into the SQL definition information. As a result, the database can be accessed from an application having a standard SQL interface.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a configuration of a database system according to a first embodiment of the present invention.

FIG. 2 shows a first example of the present invention when XML definition information is input.
9 is a flowchart showing the operation of the database system according to the embodiment.

FIG. 3 is a flowchart showing the operation of the database system according to the first embodiment of the present invention when storing, updating, searching, and deleting data.

FIG. 4 is a diagram illustrating an example of an XML definition document.

FIG. 5 is a diagram showing an example of an XML data operation command.

FIG. 6 is a diagram illustrating an example of a stored XML document.

FIG. 7 is a block diagram illustrating a configuration of a database system according to a second embodiment of the present invention.

FIG. 8 illustrates a second example of the present invention when XML definition information is input.
9 is a flowchart showing the operation of the database system according to the embodiment.

FIG. 9 is a flowchart illustrating the operation of the database system according to the second embodiment of the present invention when storing, updating, searching, and deleting data.

FIG. 10 is a diagram illustrating an example of SQL definition information.

FIG. 11 is a block diagram showing a configuration of a conventional database system.

[Explanation of symbols]

1 XML definition information analysis management means 1A XML definition information input means 1B XML definition information analysis execution means 1C definition information output means 1D data storage area creation means 2 definition information storage area 3 data manipulation language analysis means 4 XML storage management means 4A XML data Storage execution means 5 XML update management means 5A XML data update execution means 6 XML search management means 6A XML data search execution means 7 XML deletion management means 7A XML data deletion execution means 8 Data storage storage area 9 Data definition command SQL conversion means 10 Data Operation command SQL conversion unit 11 Application 12 SQL interface operation unit 13 XML definition information 14 Data definition instruction 22 Data operation command 102, 201 Database management unit A1 to A4, B1 to B8, C1 to C4, D1 to D8
Steps

Claims (3)

[Claims] 1. A data storage storage area for storing data, a definition information storage area for storing definition information that defines a storage format of data stored in the data storage storage area, and an input data definition instruction is analyzed. Storing the definition information in a definition information storage area, and creating an area creation command for creating a data storage area in the data storage storage area for storing data in accordance with the definition information, Determine the data storage area of the area,
A database management unit that checks the definition information in accordance with the input data operation instruction, and stores, updates, searches, and deletes data stored in the data storage area; When the XML definition information is input as the data definition command, it analyzes the XML definition information defining the storage format of the XML data, stores the XML definition information in the definition information storage area, and converts the XML according to the XML definition information. XML definition information analysis management means for creating an area creation command for creating a data storage area for storing data in the data storage storage area; an input data manipulation instruction being an XML data storage instruction;
A data manipulation language analysis unit for analyzing whether the command is an update command, a search command, a search command, or a delete command; and if the data manipulation command is an XML data storage command, XML storage management means for checking the XML definition information and storing the XML data to be stored in the data storage storage area; and when the data operation instruction is an XML data update instruction, An XML update management unit that checks the XML definition information with reference to the data storage area to update the XML data to be updated, and updates the XML data; If the command is an instruction, the XML definition information is checked with reference to the definition information storage area, and the XML data to be searched is searched. Retrieved from the data storage memory area, and returns the search results X
ML search management means, when the data manipulation command is an XML data deletion command, checks the XML definition information with reference to the definition information storage area, and deletes the XML data to be deleted in the data storage storage area. A database system comprising: XML deletion management means for retrieving data and deleting the XML data. 2. A data definition command SQL conversion means for converting the XML definition information and the area creation command created by the XML definition information analysis management means into SQL data structure definition information and the SQL area creation command. The XML data storage management means, the XML data update management means, the XML data search management means, and the XML
2. The database system according to claim 1, further comprising: a data operation command SQL conversion unit that converts a data operation instruction output from the data deletion management unit into an SQL data operation instruction and executes the data operation instruction. 3. The database system according to claim 2, further comprising an SQL interface operating means which is a standard SQL interface with an application.