A method and a system for searching relational complex management information system data in a natural language

A management information system, natural language technology, applied in the field of natural language search relational complex management information system data, can solve the problem of difficulty in extracting data, and achieve the effect of enhancing support and availability, data security, and data accuracy

Active Publication Date: 2019-06-21
CHINA THREE GORGES PROJECTS DEV CO LTD
View PDF4 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

But in fact, except for a very few special users who have IT foundation or are very interested in IT, this method is impossible for most users to accept
General business personnel only want to focus on their own profession, rather than complex IT technology. Unless a simple and efficient data search tool such as Baidu search is provided, it is more difficult to extract data from the database

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 a system for searching relational complex management information system data in a natural language
  • A method and a system for searching relational complex management information system data in a natural language
  • A method and a system for searching relational complex management information system data in a natural language

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0051] Such as figure 1 As shown, a method and system for searching relational complex management information system data in natural language, the specific implementation part introduces the system from two levels of system function points and feature points included in the function points, and the logical process of implementation can be seen figure 1 Logic flow chart. The system consists of the following parts:

[0052] 1. Natural language analysis module:

[0053] According to the semantic analysis table, see Table 1-1, this module can perform semantic analysis on the search conditions input by the user, identify the table name, attribute name and attribute value in the input conditions, and match the attributes and attribute values ​​according to the rules. In order to facilitate the next generation of query statements to execute the query. There are three main features in this step:

[0054] 1.1. Part of speech analysis module:

[0055] According to the "Identificati...

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 and a system for searching relational complex management information system data in a natural language. The system comprises a natural language analysis module which carries out semantic analysis on search conditions input by a user according to a semantic analysis table, recognizes table names, attribute names and attribute values in the input conditions respectively, matches the attribute names and the attribute values according to rules, and completes logic recognition and combination of multiple conditions according to a matching result and set rules; a data query module which is used for processing the data analysis result according to the single-table association search logic and the hierarchical search logic, converting the processed query conditioninto an SQL query statement to execute query, and submitting the query result to the data security control module; a data security control module which realizes two levels of authority control; And asearch result display module which is used for submitting the data information to a user in the form of service information rather than pure form data. According to the system, the data availabilityis improved, and meanwhile, the data utilization rate is also increased.

Description

technical field [0001] The invention relates to the technical field of management information systems, in particular to a method and system for searching relational complex management information system data in natural language. Background technique [0002] In the existing technology, many organizations are running ERP and other complex management information systems based on relational databases. Most users of such systems are management-oriented, and data statistics and analysis are one of the core daily tasks. Therefore, the availability of data is a concern of such users. [0003] The reality is that most users of MIS are very passive in acquiring data, often requiring the assistance of developers and hardly autonomous. This greatly affects the value of data and reduces the work efficiency of business personnel. If you want business personnel to be able to independently obtain the data stored in the database, one way is to let users learn and let them know the databas...

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/28G06F16/2453G06F16/242G06F16/2452
Inventor 何文赵鑫阳熊水玲
Owner CHINA THREE GORGES PROJECTS DEV CO LTD
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