Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Keyword searching method facing to relational database of power production management system

A keyword search and management system technology, applied in the fields of electronic digital data processing, data processing applications, special data processing applications, etc., can solve the problems of database schema complexity, low query efficiency, low data storage and analysis efficiency, etc. The effect of narrowing the search space, overcoming the disadvantages of flexibility and practicability, and lowering the technical threshold

Active Publication Date: 2012-12-12
STATE GRID CORP OF CHINA +4
View PDF1 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0008] 1) In the case of high real-time requirements, the search engine needs to analyze the relationship between the keywords entered by the user and the database query language from the database schema, and provide online data query, but the complexity of the database schema leads to low query efficiency;
[0009] 2) In occasions with low real-time requirements, the existing solutions organize and store the records in the database through data collection, but the rapid expansion of the scale of data records leads to low efficiency of data storage and analysis;
[0010] 3) Existing search result sorting generally uses IR index or inherits the PageRank algorithm of traditional search engines, but whether this kind of sorting mechanism is suitable for database search is still inconclusive

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
  • Keyword searching method facing to relational database of power production management system
  • Keyword searching method facing to relational database of power production management system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0042] The present invention will be described in further detail below in conjunction with the accompanying drawings.

[0043] like figure 1 and figure 2 , a keyword search method for a relational database of an electric power production management system, said method comprising the following steps:

[0044] Step 1: Locate the relationship table according to keywords;

[0045] Step 2: according to the business dictionary specification query process;

[0046] Step 3: Query data centered on keywords;

[0047] Step 4: Expand the query mode according to the business rules;

[0048] Step 5: Return the query result.

[0049] In said step 1, the user finds a node containing at least one search keyword in the database schema graph by querying the node index table, wherein the database schema graph is an undirected graph G=(V, E), and V is a collection of vertices, Each vertex corresponds to a relationship table, E is a collection of edges, and each edge corresponds to a foreign...

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 keyword searching method facing to a relationship database of a power production management system. The keyword searching method comprises the following steps of: positioning a relational table according to keywords; specifying the query process according to a service dictionary; taking the keywords as central query data; expanding a query mode according to a service rule; and returning the query result. According to the keyword searching method, different relational tables of a service database can be effectively correlated, the global data query is realized by combining service knowledge with the process specification and the complexity of service data query is reduced, so that users can acquire the required search results quickly and conveniently.

Description

technical field [0001] The invention belongs to the technical field of electric power information, and in particular relates to a keyword search method for relational databases of electric power production management systems. Background technique [0002] Keyword-based search engines are currently the main way of information retrieval. Existing Internet search engines mainly index static web pages, while enterprise-level search engines focus more on the retrieval of unstructured data such as documents, videos, and images. . For power applications, both structured data and unstructured text are often required, and the fusion of the two types of information has become a core issue. At present, the retrieval of the two types of information is realized by using relational database and keyword query technology respectively, and there is no organic integration yet. The key to solving this problem is to find an efficient information query method, so as to realize the free query o...

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/30G06Q10/06G06Q50/06
Inventor 丁杰胡斌朱力鹏杨佩汪超
Owner STATE GRID CORP OF CHINA
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products