Full text retrieval inquiry index method for extensible markup language document in relational database

A technology of extended markup language and database, which is applied in the index field that supports full-text search and query of Extensible Markup Language documents, can solve problems such as lack of index structure support, achieve high versatility, reduce execution time, and improve execution efficiency

Inactive Publication Date: 2011-04-27
NORTHEASTERN UNIV
View PDF5 Cites 49 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] However, no matter what kind of storage method is used to process the relational database of XML documents, the full-text search query of XML documents lacks sufficient index structure support to improve the execution efficiency of full-text search queries

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
  • Full text retrieval inquiry index method for extensible markup language document in relational database
  • Full text retrieval inquiry index method for extensible markup language document in relational database
  • Full text retrieval inquiry index method for extensible markup language document in relational database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0057]

[0058]

[0059]

[0060] Database System Implementation

[0061] author1, author2

[0062] Mechanical Industry Press

[0063]

[0064]

[0065] C Language Programming

[0066] Author 3

[0067] Tsinghua University Press

[0068]

[0069]

[0070]

[0071] There is a full-text search query for the XML document data: query for content that contains the word "database" and the phrase "mechanical industry" under the path of " / commodity / books / books";

[0072] Step 1: Save the XML document data as an XML-type attribute column of the relational table in the relational database, where the storage form of the XML data is an XML data table based on a tag sequence, and the specific structure is as follows figure 2 As shown; where the XML document is stored as a record in a relational table, in which only the number of the document is stored, the detailed data of the XML document is stored in the XML data table, and each record in the table corresponds to an ...

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 full text retrieval inquiry index method for an extensible markup language document in a relational database. The method comprises the following four steps of: storing XML document data in the way of a mark sequence-based dimensional relation table; constructing a document structure basic information table; creating a word-based inverted index on a node text column of the document structure basic information table; and carrying out full text retrieval inquiry on the basis of the index. By the index method, the management efficiency of the extensible markup language document and the execution efficiency of the full text retrieval operation of the extensible markup language document can be effectively improved, and the inquiry execution time is shortened. The method has relatively high commonality and can be seamlessly fused with existing relation database in the way that the XML document data and the index data are stored in a using relation mode. At the same time, the method can be applied to inquiry of keyword research of the XML document data and then the execution efficiency of inquiry is improved.

Description

technical field [0001] The invention belongs to the technical field of computer databases, and in particular relates to an indexing method for supporting full-text search and query of Extensible Markup Language documents in relational databases. Background technique [0002] With the Extensible Markup Language (XML) gradually becoming the standard for data representation and data exchange, XML has been widely used in more and more fields, and the number of XML documents is gradually increasing. How to extract from a large number of XML documents It has become an important requirement in the field of database applications to find satisfactory results for users in the query; in the query of XML documents, full-text search query can help users access the data in the document according to the text content, and the performance of full-text search mainly depends on How XML documents are stored in the database and the structure of the index; [0003] Since the current application ...

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 Applications(China)
IPC IPC(8): G06F17/30
Inventor 聂铁铮赵利申德荣于戈岳德君
Owner NORTHEASTERN UNIV
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products