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

Method for constructing result set based on electronic official document keyword query

A technology for electronic documents and keywords, applied in the field of relational databases, can solve the problems of low accuracy of query results and cumbersome query process.

Pending Publication Date: 2021-05-11
SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] Aiming at the needs and deficiencies of the current technological development, the present invention provides a method for constructing a result set based on electronic document keyword query to solve the problems of low accuracy of existing query results and cumbersome query process

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
  • Method for constructing result set based on electronic official document keyword query

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0028] combined with figure 1 , this embodiment proposes a method for constructing a result set based on electronic document keyword query, and its implementation includes:

[0029] Step S1, based on the title of the electronic document in the relational database, construct the tuple storage information of the keywords of the electronic document, and store it in redis. The specific operation process is as follows:

[0030] Step S1.1. When creating an electronic document, call redis to store the title of the electronic document and the information of the electronic document. The electronic document information includes the information contained in the electronic document information table and the record identifier of the electronic document information table;

[0031] Step S1.2, during the circulation of electronic documents, call redis to determine whether there is table information in electronic documents, determine whether the table information of electronic documents is con...

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 discloses a method for constructing a result set based on electronic official document keyword query, and relates to the technical field of relational databases, which is implemented by the following steps of: constructing tuple storage information of electronic official document keywords based on electronic official document titles of the relational databases, and storing the tuple storage information into redis; obtaining an association relationship of the mode patterns in the relational database, storing the association relationship into redis, and constructing a query structure set based on a primary and foreign key relationship between the tables by the redis; based on the keyword of the electronic official document title, querying in redis to obtain related tuple storage information, and combining to obtain a new data table; querying to obtain a data table set related to the new data table and a primary and foreign key relationship between tables in the set based on the association relationship of the mode patterns in the redis; and automatically constructing a query sql engine based on the master and foreign key relationship between the tables, and querying the relationship database by the query sql engine based on the sql statement of the connection slave table of the master table to obtain a result set of the input keyword. According to the method, the required content can be quickly queried from massive electronic official documents.

Description

technical field [0001] The invention relates to the technical field of relational databases, in particular to a method for constructing a result set based on electronic document keyword query. Background technique [0002] With the rapid development of informatization, electronic office has become the main way of daily work communication in the government and enterprise industry, and electronic official documents have become an important form of information transmission, communication and storage for government and enterprise. How to enable users to quickly and comprehensively find the complete content they need from the massive electronic documents at any time has become very important. [0003] Now the business data of the electronic document system is stored in a relational database, and the complete data is stored in multiple relational tables. Ordinary users' query requirements for data are an important aspect that reflects the value of data. The main problems of trad...

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): G06F16/248G06F16/28
CPCG06F16/284G06F16/248
Inventor 张晓民
Owner SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD