CN103136304B - Article processing method and device - Google Patents

Abstract

The present invention provides an entry processing method, including: creating an XML document to record the content of the entry, wherein the XPATH of the element in the XML document corresponds to the chapter hierarchy in the content of the entry; storing each XML document in the entry data table In the XML document domain; according to the XPATH of the elements in the XML document, create an index for the XML document domain of the database. The present invention provides an item processing device, comprising: a structural module for creating an XML document to record the content of the item, wherein the XPATH of an element in the XML document corresponds to the chapter hierarchy in the content of the item; a database module, It is used to store each XML document into the XML document field of the entry data table; the index module is used to create an index on the XML document field of the database according to the XPATH of the elements in the XML document. The invention improves the efficiency of item retrieval.

Description

Item processing method and device

technical field

The invention relates to the field of Internet publishing, in particular to a method and device for processing items.

Background technique

The data of the entry class has a hierarchical structure of chapters. In order to maintain the integrity and hierarchical relationship of the entry content, the entire entry content can be stored in a domain of the database as an attribute in the form of XML, constituting the XML document domain, together with other attributes of the entry constitute a complete record.

When retrieving items, the attributes of the items are organized into retrieval conditions in the form of domains, and then the items are retrieved. When the retrieval condition includes restrictions on the elements in the entry content, firstly, it is necessary to obtain the records that meet other conditions, obtain the complete XML fragment of the entry content, and then retrieve the elements through XPATH, and then obtain the qualified records by filtering .

The inventors found that this retrieval method leads to frequent loading of XML documents and consumes more resources.

Contents of the invention

The present invention aims to provide an item processing method and device to improve the efficiency of item retrieval.

In an embodiment of the present invention, a method for processing an entry is provided, including: creating an XML document to record the content of the entry, wherein the XPATH of an element in the XML document corresponds to the chapter hierarchy in the content of the entry; The document is stored in the XML document field of the entry data table; according to the XPATH of the elements in the XML document, an index is created on the XML document field of the database.

In an embodiment of the present invention, an entry processing device is provided, including: a structural module for creating an XML document to record the content of the entry, wherein the XPATH of an element in the XML document corresponds to a chapter in the content of the entry The hierarchical relationship; the database module is used to store each XML document in the XML document field of the entry data table; the index module is used to create an index on the XML document field of the database according to the XPATH of the elements in the XML document.

Because the method and device for processing items in the above embodiments of the present invention create an index for the XML document domain, it overcomes the problem of low efficiency of item retrieval in the prior art and improves the efficiency of item retrieval.

Description of drawings

The accompanying drawings described here are used to provide a further understanding of the present invention and constitute a part of the application. The schematic embodiments of the present invention and their descriptions are used to explain the present invention and do not constitute improper limitations to the present invention. In the attached picture:

Fig. 1 shows the processing method of the item according to the embodiment of the present invention;

Fig. 2 shows a schematic diagram of index relationships according to a preferred embodiment of the present invention;

FIG. 3 shows a flow chart of performing index retrieval according to a preferred embodiment of the present invention;

Figure 4 shows a screen shot of an index management interface according to a preferred embodiment of the present invention;

Fig. 5 shows a schematic diagram of an item processing device according to an embodiment of the present invention.

detailed description

The present invention will be described in detail below with reference to the accompanying drawings and in combination with embodiments.

Fig. 1 shows the processing method of the item according to the embodiment of the present invention, including:

Step S10, create an XML document to record the content of the entry, wherein the XPATH of the element in the XML document corresponds to the chapter hierarchy in the content of the entry;

Step S20, storing each XML document in the XML document domain of the entry data table;

Step S30, according to the XPATH of the elements in the XML document, create an index for the XML document field of the database.

In the prior art, when using XML technology to retrieve an entry, the complete XML fragment of the entry content is obtained, and then retrieved through XPATH; while the entry processing method of this embodiment creates an index for the XML document field, so the index can be used To retrieve items, there is no need to load the entire XML document, which reduces resource consumption, significantly improves retrieval efficiency, and shortens retrieval time.

In addition, in the prior art, elements are retrieved through traversal addressing, and the retrieval speed is slow. This method can use indexes to retrieve items without traversal addressing elements, which also shortens the retrieval time.

Preferably, step S30 includes: creating a corresponding index for the element in the XML document field, wherein, the name of the index=XML document field name+domain name separator+XPATH of the element. This embodiment is simple and easy to implement.

Fig. 2 shows a schematic diagram of index relationships according to a preferred embodiment of the present invention. It can be seen from the figure that the relationship between the index field and the XML document is uniquely determined, so the retrieval of elements (the content of which is the entry) can be equivalently converted into the retrieval of the index field, and at the same time, the management conversion of the element index The management of paired index data table data makes the retrieval of elements fast and efficient.

For example, with the following data table:

In this data table, the XML stored in the field DOC_XMLDATA has the following structure:

According to this preferred embodiment, the names of the generated indexes are as follows:

<node text="DOC_XMLDATA_/Thesis/Industry Background"/>

<node text="DOC_XMLDATA_/Thesis/Product Positioning"/>

<node text="DOC_XMLDATA_/Papers/Key Features/Functional Features"/>

<node text="DOC_XMLDATA_/Papers/Key Features/Performance Features"/>

<node text="DOC_XMLDATA_/Papers/Key Features/Technical Features"/>

<node text="DOC_XMLDATA_/Thesis/Market Prospect"/>

<node text="DOC_XMLDATA_/Thesis/Risk Assessment"/>

Preferably, step S30 further includes: collectively storing each index as an index data table, wherein the name of the index is stored in an index field of the index data table.

Preferably, a name field is also created in the index data table for recording the simple name of the index field for presentation to users.

An index data table created according to the above-mentioned preferred embodiment is as follows:

CLOB refers to a long text field.

Preferably, the method also includes:

Present the user with a simple naming documented in the name field;

Receive the user's choice of simple naming and the input search string;

Use the search string as a keyword to search the index field corresponding to the selected simple name;

Submits the content of the XML document field pointed to by the retrieved index to the user.

This preferred embodiment organizes the search syntax of the search engine based on the search conditions input by the user, and the user only needs to select the item to be searched and input keywords. If the user needs to inquire about the industry background or the product positioning belongs to the digital publishing documents, the search syntax of the organization is as follows:

((DOC_XMLDATA_/Thesis/Industry Background LIKE'Digital Publishing')OR(DOC_XMLDATA_/Thesis/Product Positioning LIKE'Digital Publishing'))

The syntax conversion device converts the retrieval sentence into the syntax of element retrieval and sends it to the retrieval service. The syntax of element retrieval is as follows:

The retrieval service receives the retrieval condition, invokes the syntax conversion service, converts it into a retrieval statement and executes the retrieval, and obtains a retrieval result set. The retrieval engine returns the retrieval result set to the human-computer interaction interface.

Figure 3 shows a flow chart of performing index retrieval according to a preferred embodiment of the present invention, including:

In the first step, the search engine receives the search request from the previous page,

In the second step, the search engine invokes the grammar conversion device to convert the search conditions of the page into the grammar of element search,

In the third step, the search engine initiates a search request and passes the search statement to the search service.

Step 4: The search service parses the search syntax, executes the search, and obtains the search result set

The fifth step, the retrieval service returns the obtained index result set to the retrieval engine,

In the sixth step, the search engine parses the result set, obtains the result document according to the index rules and returns it to the previous stage for processing.

Fig. 4 shows a screenshot of an index management interface according to a preferred embodiment of the present invention.

This preferred embodiment provides a relatively friendly interactive interface, uses the name field to help the user select a suitable index field, and realizes the retrieval of items by using the index, which is more flexible and easy to use for the user.

Fig. 5 shows a schematic diagram of an item processing device according to an embodiment of the present invention, including:

A structuring module 10, configured to create an XML document to record the content of the entry, wherein the XPATH of the element in the XML document corresponds to the chapter hierarchy in the content of the entry;

The database module 20 is used for storing each XML document in the XML document domain of the entry data table;

The indexing module 30 is configured to create an index for the XML document field of the database according to the XPATH of the elements in the XML document.

The device reduces resource consumption, remarkably improves retrieval efficiency, and shortens retrieval time.

Preferably, the index module is used to create a corresponding index for the elements in the XML document domain, wherein, the name of the index=XML document domain name+domain name separator+XPATH of the element.

Preferably, the index module is also used to collectively store each index as an index data table, wherein the name of the index is stored in the index field of the index data table.

Preferably, the index module is also used to create a name field in the index data table, which is used to record the simple name of the index field for presentation to the user.

Preferably, it also includes: an interface module, used to present the simple name recorded in the name domain to the user; a receiving module, used to receive the user's selection of the simple name and the input search string; a search module, used to use the search string The index field corresponding to the selected simple name is retrieved as a keyword; the submission module is used to submit the content of the XML document field pointed to by the retrieved index to the user.

As can be seen from the above description, the present invention has achieved the following technical effects:

Elements can be retrieved directly: on the basis of not changing the original XML storage structure, the elements of XML can be retrieved directly.

Reduce repeated loading of resources: directly reduce elements, reduce repeated loading of complete XML documents, save resources, and improve resource utilization.

Improved retrieval efficiency: Abandon the original method of traversal and addressing, and adopt the method of directly retrieving elements through indexes, which improves the retrieval efficiency.

Obviously, those skilled in the art should understand that each module or each step of the above-mentioned present invention can be realized by a general-purpose computing device, and they can be concentrated on a single computing device, or distributed in a network formed by multiple computing devices Optionally, they can be implemented with program codes executable by a computing device, so that they can be stored in a storage device and executed by a computing device, or they can be made into individual integrated circuit modules, or they can be integrated into Multiple modules or steps are fabricated into a single integrated circuit module to realize. As such, the present invention is not limited to any specific combination of hardware and software.

The above descriptions are only preferred embodiments of the present invention, and are not intended to limit the present invention. For those skilled in the art, the present invention may have various modifications and changes. Any modifications, equivalent replacements, improvements, etc. made within the spirit and principles of the present invention shall be included within the protection scope of the present invention.

Claims (6)

1. a kind of processing method of entry is it is characterised in that include：

Create XML document with record strip purpose content, wherein, the corresponding described entry of XPATH of the element in described XML document Chapters and sections hierarchical relationship in content；

Each described XML document is stored in the XML document domain of entry data table；

According to the XPATH of the element in described XML document, index is created to the XML document domain of described tables of data, wherein, for Element in described XML document domain creates corresponding index, and the title=described XML document domain name of described index claims+and domain name divides Every the XPATH of symbol+this element, each described index venue is stored as index data table, and the title of described index is deposited Store up in the index domain of described index data table.

2. method according to claim 1, it is characterised in that also creating title-domain in described index data table, is used for Record the simple name in described index domain, to present to user.

3. method according to claim 2 is it is characterised in that also include：

The simple name that described title-domain is recorded is presented to user；

The selection to described simple name for the receive user and the retrieval word string of input；

Line retrieval is entered as the keyword index domain corresponding to selected simple name using described retrieval word string；

The content in XML document domain pointed for the index retrieving is submitted to user.

4. a kind of processing meanss of entry are it is characterised in that include：

Structurized module, for creating XML document with record strip purpose content, wherein, element in described XML document Chapters and sections hierarchical relationship in the content of the corresponding described entry of XPATH；

Memory module, for storing each described XML document in the XML document domain of entry data table；

Index module, for the XPATH according to the element in described XML document, creates rope to the XML document domain of described tables of data Draw, wherein, corresponding index, the title=described XML document domain of described index are created for the element in described XML document domain The XPATH of title+domain name separating character+this element, each described index venue is stored as index data table, and by described rope The title drawn stores in the index domain of described index data table.

5. device according to claim 4 is it is characterised in that described index module is additionally operable in described index data table Also create title-domain, for recording the simple name in described index domain, to present to user.

6. device according to claim 5 is it is characterised in that also include：

Interface module, the simple name for recording described title-domain is presented to user；

Receiver module, for the retrieval word string of the selection to described simple name for the receive user and input；

Retrieval module, for being carried out using described retrieval word string as the keyword index domain corresponding to selected simple name Retrieval；

Submit module to, for the content in XML document domain pointed for the index retrieving is submitted to user.