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

A method and device for creating a dynamic index

A dynamic indexing and indexing technology, applied in the field of database storage, can solve the problem of waste of XML-DBMS storage space, and achieve the effect of saving storage space and improving query efficiency.

Inactive Publication Date: 2020-07-14
NEW FOUNDER HLDG DEV LLC
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

But for users, there is no need to perform query operations on each path in the xml document, and creating a node path index for each path in the xml document will cause a great waste of storage space in the XML-DBMS

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
  • A method and device for creating a dynamic index
  • A method and device for creating a dynamic index
  • A method and device for creating a dynamic index

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0061] In order to make the technical problems, technical solutions and advantages to be solved by the present invention clearer, the following will describe in detail with reference to the drawings and specific embodiments.

[0062] Aiming at the problem in the prior art that all node paths of element nodes are indexed, and users do not need to query all nodes, which seriously wastes the storage space of the database, the present invention provides a method and device for creating a dynamic index, according to The user wishes to create an index for the node path corresponding to the element node that needs to be indexed, and correspondingly save the index in the node path index metadata table; the user can flexibly create, delete and manage the index, on the basis of meeting the user's query needs , saving the storage space of the database and improving the query efficiency of the database.

[0063] Such as figure 1 As shown, the embodiment of the present invention provides ...

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 a method and device for creating a dynamic index, and relates to the technical field of database storage. The method for creating the dynamic index comprises the following steps: obtaining an element node which needs to establish the index in an XML (Extensive Markup Language) document; setting an identifier for the element node which needs to establish the index, and storing the element node with the identifier into a node storage table of the XML document; and obtaining the node path of the element node with the identifier from the node path table of the XML document, creating the index on the node path, and storing the index into the index metadata database of the node path. A user can flexibly create, delete and manage the index, the storage space of the database is saved on the basis of meeting the query requirements of the user, and the query efficiency of the database is improved.

Description

technical field [0001] The invention relates to the technical field of database storage, in particular to a method and device for creating a dynamic index. Background technique [0002] XML database management system (XML-DBMS) is a new type of database management system (DBMS) that has developed rapidly in recent years. The data it stores and retrieves is XML documents. The retrieval and update language of XML data are XQuery and XQuery Update which have standards formulated by W3C. The XQuery family of languages ​​is based on the sequence data model (XDM), that is, any data in XQuery is a sequence, and the sequence is composed of several ordered items (items); an item is an atomic value or an XDM node, and an XDM node is One of the seven types of nodes in an XML document. Based on such a data model, the most natural and efficient XML data storage solution is to store XML documents as nodes. [0003] The entity that stores XML documents in XML-DBMS is called a container....

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/81
Inventor 彭川郑程光孙伟丰罗正海李浩王博
Owner NEW FOUNDER HLDG DEV LLC