Unlock instant, AI-driven research and patent intelligence for your innovation.

XML data storing method, method and device thereof for executing XML query

A data and data warehouse technology, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as waste, XML query performance degradation, etc.

Inactive Publication Date: 2010-03-03
IBM CORP
View PDF0 Cites 25 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Assuming that the XML query is " / article / author / name", that is, to query the names of all authors, then 10,000 disk pages need to be accessed. If the size of the name field does not exceed 64 bytes, there are 10,000*(4KB-64B) useless The data is fetched, and the waste rate reaches 98.44%, which makes the performance of XML query degrade

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • XML data storing method, method and device thereof for executing XML query
  • XML data storing method, method and device thereof for executing XML query
  • XML data storing method, method and device thereof for executing XML query

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021] It is believed that the above and other objects, features and advantages of the present invention will become more apparent through the following detailed description of specific embodiments of the present invention in conjunction with the accompanying drawings.

[0022] figure 2 A flowchart showing a method for storing XML data in an XML repository based on a simple path according to an embodiment of the present invention. The present embodiment will be described in detail below in conjunction with the accompanying drawings.

[0023] In this embodiment, the XML warehouse includes a simple path (Simple Path) warehouse and a data warehouse, wherein the simple path warehouse is used to store all simple paths, and the data warehouse is used to store data of all XML documents. The definition of the simple path will be described later.

[0024] Such as figure 2 As shown, in step S201, for each node in the XML document, a node identifier (DOrderPath) for uniquely identif...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention provides an XML data storing method based on a simple path in an XML storehouse. The XML storehouse comprises a simple path storehouse and a data storehouse; the XML data storing methodcomprises the following steps: for nodes in an XML document, generating node identifiers for uniquely identifying the nodes; generating simple paths of the XML document; storing the simple paths intothe simple path storehouse; using the simple paths as indexes to store the data of each node in each simple path into the data storehouse sequentially; and the data comprises the node identifiers andthe values of the nodes. The XML data storing method enables the data to be stored in a simple path bunching way, and the data with one simple path are stored according to the order of the node identifiers. Without the mode of the XML document, XML data without modes can be processed and the query performance of the XML data can be increased, and moreover, the invention also provides an XML data storing device based on the simple path in the XML storehouse, a method and a device for executing the XML query in the XML storehouse.

Description

technical field [0001] The present invention relates to XML data storage and XML query execution technology, in particular to a method and device for storing XML data in an XML warehouse based on a simple path, and a method and device for executing XML query in the XML warehouse. Background technique [0002] Large volumes of XML documents are usually stored in XML warehouses in native XML databases, or in columns of the XML data type in relational databases. Usually, XML documents stored in the same XML repository or columns of an XML data type have similar schemas. XML queries are often used to obtain information from these XML documents. In most cases, this information is small and scattered. Generally, the XML query uses an XPath-based language, for example, XQuery language, XUpdate language, XSLT language, and the like. [0003] The execution scheme of XML query is related to the storage scheme of XML data. The following are existing technical solutions for storing ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F17/30
Inventor 刘长浩张国根武硕
Owner IBM CORP