CN109918453A - A kind of method and system with Natural Language Search relationship type complex management data of information system - Google Patents
A kind of method and system with Natural Language Search relationship type complex management data of information system Download PDFInfo
- Publication number
- CN109918453A CN109918453A CN201910115361.3A CN201910115361A CN109918453A CN 109918453 A CN109918453 A CN 109918453A CN 201910115361 A CN201910115361 A CN 201910115361A CN 109918453 A CN109918453 A CN 109918453A
- Authority
- CN
- China
- Prior art keywords
- data
- search
- attribute
- name
- field
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
A kind of method and system with Natural Language Search relationship type complex management data of information system, the system comprises natural language parsing modules, according to semantic resolution table, semantic parsing is carried out to the search condition of user's input, table name in input condition, attribute-name, attribute value are identified respectively, attribute-name, attribute value are matched according to rule, and complete the logic identification and combination of many condition according to matching result and established rule.Data inquiry module is handled data parsing result according to single table associative search logic and level search logic, and will treated querying condition, be converted into SQL query statement and execute inquiry, then query result is submitted into Data Security Control module.Data Security Control module realizes the permission control of two levels.Data information is submitted to user in the form of business information rather than in the form of simple form data by search result display module.While system raising data are ready availability, the utilization rate of data is also improved.
Description
Technical field
It is specifically a kind of with Natural Language Search relationship type complex management the present invention relates to management information system technology field
The method and system of data of information system.
Background technique
In the prior art, the complex management information system that many tissues are all established in operation ERP etc. based on relevant database
System, this kind of system user belong to management type mostly, and data statistic analysis work is one of daily core work.Therefore, data
Ready availability is the problem that this kind of user is concerned about very much.
Reality is that the user of most of management information systems is very passive when obtaining data, it usually needs exploitation
Personnel assist, it is difficult to autonomous.This value for significantly impacting data plays, and also reduces the working efficiency of business personnel.If
Allow business personnel that can independently obtain the data being stored in database profession, a kind of way is exactly: allowing user to learn, allows it
Know incidence relation between database structure, including base table content, base table, base table field meanings, also skillfully to grasp sql like language,
It does so, what user can be autonomous extracts oneself desired data as IT personnel from database.But it is practical
On, this mode except to extremely individually have IT basis or to the very interesting special user of IT it is useful in addition to, the overwhelming majority use
Family is can not be receptible.General business personnel merely desire to the profession for being absorbed in oneself, and non-complex IT technology, unless providing one
Otherwise the efficient data search tool of extremely letter of such as Baidu search extracts data from database and is more difficult to realize.
Summary of the invention
In order to solve the above technical problems, the present invention provides one kind with Natural Language Search relationship type complex management information system
The method and system of data, present system support scan for the data in relevant database with natural language, reduce
The technical threshold that data use;Present system supports many condition typing, identification and query composition, and according to service logic pair
Query result optimizes, derivation process;The system also uses stringent mechanism of authorization control, to ensure the safety of data.Benefit
With searching method of the present invention, user only needs to can be obtained inquiry with natural language input inquiry condition according to their own needs
And related data as a result;The individual demand of user is fast implemented, and is enhanced the availability of data, is also more bonded business need
It asks.
The technical scheme adopted by the invention is as follows:
A kind of system with Natural Language Search relationship type complex management data of information system, the system include:
Natural language parsing module, is used for: according to semantic resolution table, carrying out semantic solution to the search condition of user's input
Analysis, identifies table name in input condition, attribute-name, attribute value, and match attribute-name, attribute value according to rule respectively,
Obtain the querying condition of standard;
Data inquiry module is used for: according to index configurations table, the querying condition that natural language parsing module is obtained,
It is converted into SQL query statement and executes inquiry, then query result is submitted into Data Security Control module, can be seen with to obtain user
Query result;
Data Security Control module, is used for: the permission control of two levels is realized, first is that setting according in search object table
" security level " field set is realized and is managed to the primary of data permission;Second is that the mechanism of authorization control of prime information system is introduced,
Realize the accurate control to data permission;
Search result display module, is used for: in the form of business information rather than in the form of simple form data, by data
Information submits to user, while providing simple data analysis and visualization tool for user.
The natural language parsing module further include:
Part of speech analysis module, is used for: according to " mark " field in semantic resolution table, identifying that the input item of user is
Table name, attribute-name or attribute value, then attribute-name preferential according to table name, the sequence of last attribute value identify;Then basis
The matching rule that attribute-name and attribute value close on, attribute-name is matched in pairs with attribute value;Ultimately form " table name+attribute-name+category
Property value " combination, the querying condition that user inputs precisely is resolved into the querying condition of standard.
The natural language parsing module further include:
Many condition identification and composite module, are used for:, being capable of intelligent recognition in the case where user inputs multiple queries condition
Logical relation between multiple queries condition executes query composition, realizes accurate search, logical relation identification and inquiry item
Part anabolic process follows following rule:
Rule one: according to index configurations table, the relationship between attribute and table name is determined, if multiple attributes belong to same table
In different attribute, then with AND query composition condition between condition;
Rule two: according to index configurations table, determine the relationship between attribute and table name, if multiple attributes belong to it is different
Table obtains the attribute value relationship between different tables then further according to configuring in index configurations table, determines table according to the value relationship
Between subquery relationship, with IN query composition condition;
Rule three: if the result of natural language parsing only has the case where table name+attribute value, the attribute value is brought into rope
The all properties for drawing current table in allocation list are matched, but at this time between the different attribute in same table with OR query composition item
Part;
Above-mentioned be rule one, two, three is basic principle, by the combined application of Different Rule, can analyze identify it is each
Kind complex query.
The data inquiry module further include:
Single table associative search module, is used for: being corresponded to according to " object table+aiming field " that configures in index configurations table
The mode of " source table+source field+search field " can will be converted into search words multiple in the table of source the inquiry of one aiming field
The inquiry of section allows service-user to start with from the different attribute of object and searches for data, and greatly expand data can search for range;
On the other hand coding class data stronger for repeatability, the inquiry velocity in the table of source are also far superior to quoting the coding
Inquiry velocity in traffic table has been further reduced along with the setting of " value condition " field in index configurations table in source table
In search range, improve the speed of data search.
The data inquiry module further include:
Level search module, is used for: using " hierarchical identification " field in index configurations table, can configure present field
Value whether there is hierarchical relationship;If the aiming field of search is hierarchical relationship field, will be analyzed in the source field of source table
Field value, finds out the superior and the subordinate's hierarchical relationship, searches out upper layer and lower data together and is back to search result display module,
Level search has good effect for the integrality for reacting business.
Described search result display module further include:
Data automatic push module, be used for: related data push definition table is devised, wherein taking according to field between table
Value relationship defines the relevant parent base table of some base table, sub- grade base table and other association base tables;It is complete in data search module
It, can be at it according to relationship between the table configured in related data push definition table and index configurations table after data search
He is associated in base table finds related data and feeds back to user together, the data automatic push module raises business of institute's feedback data
Integrality, the availability for improving search result.
Described search result display module further include:
Search result derives display module, is used for, first: coding class data are converted to business information description: i.e. root
According to Coding and description conversion table, readable stronger business is converted by the coding class data code stored in business datum table and is retouched
It states;Second: according to business demand, addition auxiliary display field, i.e., show according to auxiliary and define table, i.e., in search result displaying
Associated display field can be added in any display table, to improve the business integrality for showing information, improve search result
Availability.
Described search result display module further include:
Different types of data personalization display module, is used for: for structural data, number is provided in a manner of tables of data
According to, and active push related data;For file, news type data, data are provided in a manner of link;For location information,
Data are provided in a manner of map links, it is user-friendly.
Described search result display module further include:
Search result analysis and visualization model, are used for: providing data download function, data subscription function, data system
Meter and chart systematic function;User can track the variation of the latest data in current table by data subscription function in time, own
Data update will be automatically pushed to user;Data statistics and chart systematic function provide for user by field count, summation etc.
Data handling procedure, and corresponding diagrammatic representation can be generated according to result.
In many condition identification and composite module, if multiple table names involved in the result of part of speech analysis and attribute-name
Combination, first confirms that the relationship between table name and attribute-name: if belonging to a table, the combinations of multiple attribute+attribute values with
The logical combination of " AND " is inquired;If belonging to different tables, according to the information in index configurations table, confirm between different tables
Field value relationship, combined between the different attribute in query composition condition in same table or in a manner of " AND ", without
It is combined in a manner of subquery " IN " with the field value relationship between table;
If only table name+attribute value is as a result, so bring attribute value into the table all in the result of part of speech analysis
Attribute executes inquiry as condition, but the logical relation combined between each attribute+attribute value is " OR ".
In addition, the present invention also provides a kind of method with Natural Language Search relationship type complex management data of information system,
The following steps are included:
Step A: input search condition;
Step B: according to semantic resolution table, carrying out semantic parsing to the search condition of user's input, identify to part of speech,
Including confirmation table name, attribute-name and attribute value, and by attribute value and attributes match;
Step C: the condition and set logic rules inputted according to user confirms that the logic between multiple queries condition is closed
System obtains and describes the query composition condition formed by standard;
Step D: corresponding table name and field name are converted by standard description, and source will be converted into the inquiry of aiming field
The inquiry of table search field, and according to the logical relation in step C, splice query statement;
Step E: inquiry is executed according to the query statement of stitching portion in D;
Step F: it according to the security level field being arranged in search object table, realizes and the primary of data permission is managed;Needle
The mechanism of authorization control that prime information system is introduced to sensitive data, further screens the search result in E, realizes and weighs to data
The accurate control of limit;
Step G: derivative display data and auxiliary display field are generated;
Step H: according to data type returned data, and corresponding data analysis and visualization tool are provided.
A kind of method and system with Natural Language Search relationship type complex management data of information system of the present invention, beneficial to effect
Fruit is as follows:
1, interaction is simple.Ideal interaction is, it is only necessary to which user inputs searching requirement, other friendships in a manner of natural language
It is done to tool, similar Baidu's formula interaction.
2, data safety.Operation system data have permission setting, and different role can only search respective extent of competence
Interior data.
3, data are accurate.Business datum searches for unusual Webpage search, high to the accuracy requirement of data, otherwise can shadow
Ring statistical accuracy.
4, the proprietary database features of Complex Information Systems such as high normal form design, complex hierarchy operation code are supported.
5, the present invention fully considers in terms of index configurations, data search and result and introduces business datum
The problems such as logical associations, the readability of business information, integrality, ease for use and settling mode, provide the user with not only
It is only the research tool of data in relevant database, is even more directed to the search and displaying of information system business information.Based on
The design of business demand angle substantially increases combining closely for search and business, enhance the present invention to the support of business and
Degree can be used.
5, it needs that data of information system, data could be obtained in the case where IT personnel assist system solves the problem current operation personnel
Inefficiency is obtained, the personalized query demand of business personnel is unable to get the not high problem of quick response, data user rate.
6, it searches user in the system of library what is developed based on the present invention and need to only be needed in a manner of natural language by the inquiry of oneself
Input inquiry condition is sought, system can automatically parse querying condition, quick execution data query and permission and control and return the result,
It realizes and independently obtains business datum by business personnel, personalized query demand can obtain the target of quick response;Improve number
According to it is ready availability while, also improve the utilization rate of data.
Detailed description of the invention
Fig. 1 is the logical flow chart of system of the invention.
Specific embodiment
As shown in Figure 1, a kind of method and system with Natural Language Search relationship type complex management data of information system, tool
Two levels of characteristic point that body embodiment part is included from system function point and function point carry out introducing system, about realization
The visible Fig. 1 logical flow chart of logical process.The system includes following components:
1, natural language parsing module:
This module can be shown in Table 1-1 according to semantic resolution table, carry out semantic parsing to the search condition of user's input, respectively
It identifies table name in input condition, attribute-name and attribute value, and is matched attribute and attribute value according to rule, with convenient
Query statement is generated in next step executes inquiry.It is main in this step that there are three characteristic points:
1.1, part of speech analysis module:
According to " mark " field in table 1-1, identify that the input item of user is table name, attribute-name or attribute value, root
, then attribute-name preferential according to table name, the sequence of last attribute value identify;Then the matching closed on according to attribute-name and attribute value
Rule matches attribute-name with attribute value in pairs;Ultimately form the combination of " table name+attribute-name+attribute value ".
1.2, many condition identification and composite module:
Present system allows user to input multiple queries condition, and the logic between the energy multiple conditions of intelligent recognition is closed
System executes query composition, achievees the purpose that accurately to search for.If multiple table names and attribute-name involved in the result of part of speech analysis
Combination, first confirms that the relationship between table name and attribute-name: if belonging to a table, the combinations of multiple attribute+attribute values with
The logical combination of " AND " is inquired;If belonging to different tables, according to index configurations table, information in table 1-2, confirmation is different
Field value relationship between table, the group between the different attribute in query composition condition in same table or in a manner of " AND "
It closes, and the field value relationship between different tables is combined in a manner of subquery " IN ".If in the result of part of speech analysis only
Table name+attribute value executes inquiry, but each attribute+category as condition as a result, attribute value so to be brought into all properties of the table
Property value between the logical relation that combines be " OR ".The mode adjustment of inquiry after many condition identification and combination are as follows:
1., table name attribute-name+attribute value AND attribute-name+attribute value
2., table name attribute-name+attribute value AND attribute-name IN (table name attribute-name+attribute value AND attribute-name+attribute
Value)
3., table name attribute-name+attribute value OR attribute-name+attribute value
It is above-mentioned only to list three kinds of most basic combinations, according to patrolling between the difference and table of user's input condition
Relationship difference is collected, above-mentioned several ways can also be combined into other complicated query patterns;The condition of its neutron interrogation is also by root
It is handled according to the single table associative search feature recorded in 2.1 sections.
2, data inquiry module, Data Security Control module:
The search condition that user inputs has been done into standardization in language parsing, that is, has been converted into table name, attribute
The combination of name, attribute value and logical relation, wherein table name and attribute-name convert according to table 1-2 for standard description.This step
Suddenly the querying condition after standardization will be converted into SQL query statement and executes inquiry, then query result is submitted into safety
Control module, to obtain the query result that user can see.This step mainly has following characteristics point:
2.1, single table associative search module:
In the index configurations table of present system, be shown in Table in 1-2 devise object table, aiming field, source table, source field with
And the corresponding relationship between the table search field of source, the inquiry of aiming field will can be converted into source table in SQL subquery
The inquiry of search field, such as:
1., be originally used for querying condition are as follows: select aiming field from object table;
2., be added IN subquery after become:
Select aiming field from object table where aiming field IN (source select source field from table);
3., be added search field after become:
The select aiming field from object table where aiming field IN (source select source field from table
The source where table search field like (the attribute value % of % user's input))
Since an aiming field can configure multiple search fields, the inquiry of an aiming field will can be converted into pair
The inquiry of multiple source table search fields in the table of source, therefore associative search feature allows service-user to start with from the different attribute of object
Data are searched for, extend data can search for range.
Such as: user will search for all paying bills of some contract, can only be according to if only searched in payment base table
Contract code searches for (because contract attribute only one contract code defined in payment base table);But if using this hair
Associative search in bright system, then can be according to the search field in source table (the value table of contract code field: contract base table)
(contract attribute defined in contract base table to search for), such as: contract title, signs unit, contract type, conjunction at the date
With total amount etc., these conditions finally will all be directed toward this contract.
Single table associative search greatly expands the available attributes range of search data, allows user from different majors angle
Data are searched for, improve the availability of search;Coding class data (such as contract type, department) stronger for repeatability,
The speed inquired in the table of the source also inquiry far superior in the traffic table for quoting the data, adds " value condition " field
Setting, further reduced the search range in the table of source, improved the speed of data search.
2.2, level search module:
In information system, often there is hierarchical relationship in definition in certain form of data, such as: accounting item generation
Code, division code, the coding at engineering construction position etc., but user be concerned about be frequently not some level data, and it is same
When need the data of a level or next level;To meet business demand, level search function is introduced in present system
Energy.Using " hierarchical identification " field in table 1-2, the value that can configure present field whether there is hierarchical relationship;If search
Aiming field is hierarchical relationship field, will analyze field value in the source field of source table, finds out the superior and the subordinate's hierarchical relationship, and by phase
The superior and the subordinate's data of pass return together.
Level search has a good effect for the integrality for reacting business, for example, I to search for " investment project " this
Junior's project of accounting item identifies that present field is level field according to table 1-2, and searching out, " investment project " is corresponding
After subject, the value of subject code field will be analyzed, find out the related data of higher level's code and junior's code, return together.
2.3, Data Security Control module:
Data in information system are controlled often with permission, realize that the premise that data utilize first has to ensure data
Safety.The permission control of two levels is realized in present system: first is that in search object table, being shown in Table in 1-3 and is provided with " peace
Full rank " field is realized and is managed to the primary of data permission, second is that the mechanism of authorization control of prime information system is introduced, realization pair
The accurate control of data permission.The security level of tables of data is divided into sensitive and non-sensitive: nonsensitive data is can be to user
Wide-open data are controlled without permission;And sensitive data is then that can not open completely to user, needs to introduce prime information system
The mechanism of authorization control of system is managed.Under the mechanism of authorization control, the safety of data had both been ensured, also facilitate making for user
With.
2.4, data automatic push module:
What present system illustrated is the data search of oriented of Information System, highlights the business association between data.?
Related data push definition table is devised in present system, is shown in Table 1-4, wherein according to the value relationship of field between table, definition
One base table relevant parent base table, sub- grade base table and other association base tables;After completing data search, according to table 1-
Relationship between the table configured in 4 and table 1-2 can find related data in other association base tables and feed back to user together, mention
It rises the business integrality of institute's feedback data, improve the availability of search result.
3, search result display module:
The personalized of search result shows readability, the availability for predominantly improving search result, as far as possible with business information
Form rather than data information is submitted to user by the form of simple form data, while providing simple data for user and analyzing
And visualization tool.Personalization shows mainly include the following aspects:
3.1, the derivative display module of search result:
Search result is derivative to be shown mainly include two aspect: one is to will coding class data conversion display;Second is that according to industry
Business demand adds associated non-base table field in search result displaying.
The conversion display of class data is encoded, coding class data are mainly converted into business information description: being turned according to Coding and description
It changes table and is shown in Table 1-5, the code stored in tables of data can be converted to readable stronger business description.Source field is as to be converted
Corresponding field of the field in the table of source, source word segment description are corresponding description field in the table of source.It is set according to the field in table 1-5
Set can it is sliceable go out required conversion query sentence.
Show non-base table field, i.e., for according to service logic, addition assists display field in display result.System of the present invention
Auxiliary display definition table is defined in system, is shown in Table 1-6, according to the setting of table 1-6, can be added in any display table associated
Display field, parameter involved in value condition are to answer data in the query result of display table pair, accordingly shown information
More business integrality, improve the availability of search result.
3.2, different types of data personalization display module:
According to search object table, " mark " field being shown in Table in 1-3 distinguishes current base table storing data institute's generation in business
The data type of table can customize different displaying interfaces accordingly for different data: for structural data, in a manner of tables of data
Data and active push related data are provided;For file, news type data, data are provided in a manner of link;For position
Information provides data etc. in a manner of map links.
3.3, search result analysis and visualization model:
Search result analysis and visualization, mainly for structural data.The data processing function provided in present system
It can include: data download function, data subscription function, data statistics and chart systematic function.User passes through data subscription function
The latest data that can be tracked in time in current table changes, and all data updates will be automatically pushed to user, facilitates user timely
Understand data update status;Data statistics and chart systematic function provide for user by data processings such as field count, summations
Process, and corresponding diagrammatic representation can be generated according to result.
1-1 semanteme resolution table:
Field setting | Field meanings |
Standard description | The standard description of corresponding table name or attribute-name |
Synonym | Corresponding natural language (being accustomed to collecting based on business terms and user) can be described with the standard |
Mark | TABLE/FIELD: it identifies the standard and describes corresponding table name or attribute-name |
I-2 index configurations table:
I-3 searches for object table:
The push of I-4 related data defines table:
Field setting | Field meanings |
Object table | Target to be searched table name |
Parent table | The definition table of certain fields in object table |
Sub- grade table | Certain field values are in object table in sub- grade table |
Other can jump list | Other have the table of data relation of equality between table with object table |
I-5 Coding and description conversion table
Field setting | Field meanings |
Convert table name | The affiliated table name of field to be converted |
Field name to be converted | Field name to be converted |
Source table name | The table name of field definition table to be converted |
Source field name | Field to be converted corresponding field name in the table of source |
Source word segment description | Corresponding business description when source field defines |
Value condition | Corresponding value condition (when conversion display, the condition of inquiry need to be brought into) when being inquired in the table of source |
Standard description | The standard of source field describes |
I-6 auxiliary display defines table
Claims (10)
1. a kind of system with Natural Language Search relationship type complex management data of information system, it is characterised in that the system packet
It includes:
Natural language parsing module, is used for: according to semantic resolution table, semantic parsing is carried out to the search condition of user's input,
Table name in input condition, attribute-name, attribute value are identified respectively, and is matched attribute-name, attribute value according to rule, are obtained
The querying condition of standard;
Data inquiry module is used for: according to index configurations table, the querying condition that natural language parsing module is obtained, and conversion
Inquiry is executed for SQL query statement, then query result is submitted into Data Security Control module, is looked into obtain that user can see
Ask result;
Data Security Control module, is used for: the permission control of two levels is realized, first is that according to being arranged in search object table
" security level " field is realized and is managed to the primary of data permission;Second is that introducing the mechanism of authorization control of prime information system, realize
Accurate control to data permission;
Search result display module, is used for: in the form of business information rather than in the form of simple form data, by data information
User is submitted to, while providing simple data analysis and visualization tool for user.
2. a kind of system with Natural Language Search relationship type complex management data of information system according to claim 1,
It is characterized in that: the natural language parsing module further include:
Part of speech analysis module, is used for: according to " mark " field in semantic resolution table, identifying that the input item of user is table
Name, attribute-name or attribute value, then attribute-name preferential according to table name, the sequence of last attribute value identify;Then according to category
Property the name and matching rule closed on of attribute value, attribute-name is matched in pairs with attribute value;Ultimately form " table name+attribute-name+attribute
The querying condition that user inputs precisely is resolved to the querying condition of standard by the combination of value ".
3. a kind of system with Natural Language Search relationship type complex management data of information system according to claim 1,
It is characterized in that: the natural language parsing module further include:
Many condition identification and composite module, be used for: user input multiple queries condition under, can intelligent recognition it is multiple
Logical relation between querying condition executes query composition, realizes accurate search, logical relation identification and querying condition group
Conjunction process follows following rule:
Rule one: according to index configurations table, the relationship between attribute and table name is determined, if multiple attributes belong in same table
Different attribute, then with AND query composition condition between condition;
Rule two: according to index configurations table, determining the relationship between attribute and table name, if multiple attributes belong to different tables,
Then further according to configuring in index configurations table, the attribute value relationship between different tables is obtained, determined between table according to the value relationship
Subquery relationship, with IN query composition condition;
Rule three: it if the result of natural language parsing only has the case where table name+attribute value, brings the attribute value into index and matches
The all properties for setting current table in table are matched, but at this time between the different attribute in same table with OR query composition condition;
Above-mentioned be rule one, two, three is basic principle, by the combined application of Different Rule, can analyze identify it is various multiple
Miscellaneous inquiry.
4. a kind of system with Natural Language Search relationship type complex management data of information system according to claim 1,
It is characterized in that: the data inquiry module further include:
Single table associative search module, is used for: corresponding to " source according to " object table+aiming field " that configures in index configurations table
The mode of table+source field " can will be converted into the inquiry to search fields multiple in the table of source to the inquiry of an aiming field, permit
Perhaps service-user is started with from the different attribute of object searches for data;On the other hand coding class data stronger for repeatability,
Inquiry velocity in the table of source is also far superior to the inquiry velocity in the traffic table for quoting the coding, along in index configurations table
The setting of " value condition " field, has further reduced the search range in the table of source, has improved the speed of data search.
5. a kind of system with Natural Language Search relationship type complex management data of information system according to claim 1,
It is characterized in that: the data inquiry module further include:
Level search module, is used for: using " hierarchical identification " field in index configurations table, can configure the value of present field
With the presence or absence of hierarchical relationship;If the aiming field of search is hierarchical relationship field, field will be analyzed in the source field of source table
Value, finds out the superior and the subordinate's hierarchical relationship, searches out upper layer and lower data together and is back to search result display module.
6. a kind of system with Natural Language Search relationship type complex management data of information system according to claim 1,
It is characterized in that: described search result display module further include:
Data automatic push module, is used for: related data push definition table is devised, wherein the value according to field between table is closed
System defines the relevant parent base table of some base table, sub- grade base table and other association base tables;Number is completed in data search module
It, can be in other passes according to relationship between the table configured in related data push definition table and index configurations table after search
Related data, which is found, in symbasis table feeds back to user together.
7. a kind of system with Natural Language Search relationship type complex management data of information system according to claim 1,
It is characterized in that: described search result display module further include:
Search result derives display module, is used for, first: coding class data being converted to business information description: i.e. according to volume
The coding class data code stored in business datum table is converted readable stronger business description by code description conversion table;The
Two: according to business demand, addition auxiliary display field, i.e., show according to auxiliary and define table in search result displaying, can
Associated display field is added in any display table.
8. a kind of system with Natural Language Search relationship type complex management data of information system according to claim 1,
It is characterized in that: described search result display module further include:
Different types of data personalization display module, is used for: for structural data, provided in a manner of tables of data data,
And active push related data;For file, news type data, data are provided in a manner of link;For location information, with ground
The mode of figure link provides data.
9. a kind of system with Natural Language Search relationship type complex management data of information system according to claim 1,
It is characterized in that: described search result display module further include:
Search result analysis and visualization model, be used for: provide data download function, data subscription function, data statistics and
Chart systematic function;User can track the variation of the latest data in current table by data subscription function in time, and all data are more
User will be newly automatically pushed to;Data statistics and chart systematic function provide for user by the data such as field count, summation
Reason process, and corresponding diagrammatic representation can be generated according to result.
10. using such as above-mentioned 1-9 any one system with Natural Language Search relationship type complex management data of information system
Method, it is characterised in that the following steps are included:
Step A: input search condition;
Step B: according to semantic resolution table, carrying out semantic parsing to the search condition of user's input, identify to part of speech, including
Confirm table name, attribute-name and attribute value, and by attribute value and attributes match;
Step C: the condition and set logic rules inputted according to user confirms the logical relation between multiple queries condition,
It obtains and the query composition condition formed is described by standard;
Step D: corresponding table name and field name are converted by standard description, and is searched source table is converted into the inquiry of aiming field
The inquiry of rope field, and according to the logical relation in step C, splice query statement;
Step E: inquiry is executed according to the query statement of stitching portion in step D;
Step F: derivative display data and auxiliary display field are generated;
Step G: it according to the security level field being arranged in search object table, realizes and the primary of data permission is managed;For quick
Feel the mechanism of authorization control that data introduce prime information system, the search result in step E is further screened, realizes and data are weighed
The accurate control of limit;
Step H: according to data type returned data, and corresponding data analysis and visualization tool are provided.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910115361.3A CN109918453B (en) | 2019-02-13 | 2019-02-13 | Method and system for searching relational complex management information system data by natural language |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910115361.3A CN109918453B (en) | 2019-02-13 | 2019-02-13 | Method and system for searching relational complex management information system data by natural language |
Publications (2)
Publication Number | Publication Date |
---|---|
CN109918453A true CN109918453A (en) | 2019-06-21 |
CN109918453B CN109918453B (en) | 2021-03-12 |
Family
ID=66961608
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910115361.3A Active CN109918453B (en) | 2019-02-13 | 2019-02-13 | Method and system for searching relational complex management information system data by natural language |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109918453B (en) |
Cited By (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110413708A (en) * | 2019-07-23 | 2019-11-05 | 杭州城市大数据运营有限公司 | A kind of data analysis system of service-oriented term |
CN110674164A (en) * | 2019-09-30 | 2020-01-10 | 南京网感至察信息科技有限公司 | Method for natural language query and intelligent report generation facing main data |
CN110717319A (en) * | 2019-09-24 | 2020-01-21 | 车智互联(北京)科技有限公司 | Self-service report generation method and device, computing equipment and system |
CN110866091A (en) * | 2019-11-19 | 2020-03-06 | 杭州数梦工场科技有限公司 | Data retrieval method and device |
CN111967269A (en) * | 2020-08-13 | 2020-11-20 | 支付宝(杭州)信息技术有限公司 | Business risk identification method and device and electronic equipment |
CN112948374A (en) * | 2021-01-29 | 2021-06-11 | 吉林大学 | Relational database searching method based on logic program |
CN114064655A (en) * | 2021-11-23 | 2022-02-18 | 上证所信息网络有限公司 | Configurable data query and automatic discovery method of data relationship |
CN114548062A (en) * | 2022-04-27 | 2022-05-27 | 成都瑞华康源科技有限公司 | Report arranging method |
CN114925118A (en) * | 2022-06-09 | 2022-08-19 | 北京百度网讯科技有限公司 | Cross-table search method, device, equipment and storage medium |
CN116681382A (en) * | 2023-05-16 | 2023-09-01 | 智诚计算机辅助设计(深圳)有限公司 | Material list data grabbing method, system and readable storage medium |
CN117519702A (en) * | 2023-12-29 | 2024-02-06 | 冠骋信息技术(苏州)有限公司 | Search page design method and system based on low code collocation |
CN117891847A (en) * | 2024-03-18 | 2024-04-16 | 辽宁牧龙科技有限公司 | Data query device and method based on data center |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102073701A (en) * | 2010-12-30 | 2011-05-25 | 浪潮集团山东通用软件有限公司 | Semantic definition-based multi-data source data querying method |
US20130013291A1 (en) * | 2011-07-06 | 2013-01-10 | Invertix Corporation | Systems and methods for sentence comparison and sentence-based search |
CN104657439A (en) * | 2015-01-30 | 2015-05-27 | 欧阳江 | Generation system and method for structured query sentence used for precise retrieval of natural language |
CN109241259A (en) * | 2018-08-24 | 2019-01-18 | 国网江苏省电力有限公司苏州供电分公司 | Natural language querying method, apparatus and system based on ER model |
-
2019
- 2019-02-13 CN CN201910115361.3A patent/CN109918453B/en active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102073701A (en) * | 2010-12-30 | 2011-05-25 | 浪潮集团山东通用软件有限公司 | Semantic definition-based multi-data source data querying method |
US20130013291A1 (en) * | 2011-07-06 | 2013-01-10 | Invertix Corporation | Systems and methods for sentence comparison and sentence-based search |
CN104657439A (en) * | 2015-01-30 | 2015-05-27 | 欧阳江 | Generation system and method for structured query sentence used for precise retrieval of natural language |
CN109241259A (en) * | 2018-08-24 | 2019-01-18 | 国网江苏省电力有限公司苏州供电分公司 | Natural language querying method, apparatus and system based on ER model |
Cited By (19)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110413708A (en) * | 2019-07-23 | 2019-11-05 | 杭州城市大数据运营有限公司 | A kind of data analysis system of service-oriented term |
CN110717319A (en) * | 2019-09-24 | 2020-01-21 | 车智互联(北京)科技有限公司 | Self-service report generation method and device, computing equipment and system |
CN110717319B (en) * | 2019-09-24 | 2023-10-20 | 车智互联(北京)科技有限公司 | Self-service report generation method, device, computing equipment and system |
CN110674164A (en) * | 2019-09-30 | 2020-01-10 | 南京网感至察信息科技有限公司 | Method for natural language query and intelligent report generation facing main data |
CN110866091A (en) * | 2019-11-19 | 2020-03-06 | 杭州数梦工场科技有限公司 | Data retrieval method and device |
CN110866091B (en) * | 2019-11-19 | 2023-07-11 | 杭州数梦工场科技有限公司 | Data retrieval method and device |
CN111967269A (en) * | 2020-08-13 | 2020-11-20 | 支付宝(杭州)信息技术有限公司 | Business risk identification method and device and electronic equipment |
CN111967269B (en) * | 2020-08-13 | 2024-04-26 | 支付宝(杭州)信息技术有限公司 | Business risk identification method and device and electronic equipment |
CN112948374B (en) * | 2021-01-29 | 2022-07-08 | 吉林大学 | Relational database searching method based on logic program |
CN112948374A (en) * | 2021-01-29 | 2021-06-11 | 吉林大学 | Relational database searching method based on logic program |
CN114064655A (en) * | 2021-11-23 | 2022-02-18 | 上证所信息网络有限公司 | Configurable data query and automatic discovery method of data relationship |
CN114064655B (en) * | 2021-11-23 | 2024-03-29 | 上证所信息网络有限公司 | Automatic discovery method capable of configuring data query and data relationship |
CN114548062B (en) * | 2022-04-27 | 2022-08-02 | 成都瑞华康源科技有限公司 | Report arranging method |
CN114548062A (en) * | 2022-04-27 | 2022-05-27 | 成都瑞华康源科技有限公司 | Report arranging method |
CN114925118A (en) * | 2022-06-09 | 2022-08-19 | 北京百度网讯科技有限公司 | Cross-table search method, device, equipment and storage medium |
CN116681382A (en) * | 2023-05-16 | 2023-09-01 | 智诚计算机辅助设计(深圳)有限公司 | Material list data grabbing method, system and readable storage medium |
CN117519702A (en) * | 2023-12-29 | 2024-02-06 | 冠骋信息技术(苏州)有限公司 | Search page design method and system based on low code collocation |
CN117519702B (en) * | 2023-12-29 | 2024-03-19 | 冠骋信息技术(苏州)有限公司 | Search page design method and system based on low code collocation |
CN117891847A (en) * | 2024-03-18 | 2024-04-16 | 辽宁牧龙科技有限公司 | Data query device and method based on data center |
Also Published As
Publication number | Publication date |
---|---|
CN109918453B (en) | 2021-03-12 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN109918453A (en) | A kind of method and system with Natural Language Search relationship type complex management data of information system | |
AU780565B2 (en) | Method and apparatus for selecting aggregate levels and cross product levels for a data warehouse | |
US6199059B1 (en) | System and method for classifying and retrieving information with virtual object hierarchy | |
Auer et al. | Linkedgeodata: Adding a spatial dimension to the web of data | |
US8250529B2 (en) | Specification to ABAP code converter | |
US20070203893A1 (en) | Apparatus and method for federated querying of unstructured data | |
CN105912595A (en) | Data origin collection method of relational databases | |
CN109800284A (en) | A kind of unstructured information intelligent Answer System construction method of oriented mission | |
CN107169033A (en) | Relation data enquiring and optimizing method with parallel framework is changed based on data pattern | |
CN101493820A (en) | Medicine Regulatory industry knowledge base platform and construct method thereof | |
CN101118554A (en) | Intelligent interactive request-answering system and processing method thereof | |
KR101505858B1 (en) | A templet-based online composing system for analyzing reports or views of big data by providing past templets of database tables and reference fields | |
CN102262640A (en) | Method and device for full-text retrieval of document database | |
CN104778540A (en) | BOM (bill of material) management method and management system for building material equipment manufacturing | |
CN101410865A (en) | Method of establishing a data management fee structure based on fine grained data entities | |
CN108009270A (en) | A kind of text searching method calculated based on distributed memory | |
CN101458692A (en) | Strategic material industry knowledge base platform and construct method thereof | |
CN106897285A (en) | Data Elements extract analysis system and Data Elements extract analysis method | |
CN109885665A (en) | A kind of data query method, apparatus and system | |
CN109471929A (en) | A method of it is matched based on map and carries out equipment maintenance record semantic search | |
CN109815254A (en) | Cross-region method for scheduling task and system based on big data | |
CN109739882A (en) | A kind of big data enquiring and optimizing method based on Presto and Elasticsearch | |
US5557788A (en) | Relational access system for network type data bases which uses a unique declarative statement | |
CN114997624A (en) | Intelligent whole-person safety production responsibility management system | |
US9207917B2 (en) | Application generator for data transformation applications |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |