CN112463954A - Visual multidimensional data display system and method based on semantic recognition - Google Patents
Visual multidimensional data display system and method based on semantic recognition Download PDFInfo
- Publication number
- CN112463954A CN112463954A CN202011252986.3A CN202011252986A CN112463954A CN 112463954 A CN112463954 A CN 112463954A CN 202011252986 A CN202011252986 A CN 202011252986A CN 112463954 A CN112463954 A CN 112463954A
- Authority
- CN
- China
- Prior art keywords
- query
- data
- service
- module
- user
- 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
- 238000000034 method Methods 0.000 title claims abstract description 20
- 230000000007 visual effect Effects 0.000 title claims abstract description 18
- 238000004458 analytical method Methods 0.000 claims abstract description 45
- 238000012545 processing Methods 0.000 claims abstract description 38
- 238000013523 data management Methods 0.000 claims abstract description 7
- 230000008520 organization Effects 0.000 claims description 18
- 230000006870 function Effects 0.000 claims description 15
- 238000007726 management method Methods 0.000 claims description 6
- 238000010606 normalization Methods 0.000 claims description 6
- 239000013589 supplement Substances 0.000 claims description 6
- 230000008569 process Effects 0.000 claims description 3
- 230000004044 response Effects 0.000 abstract description 5
- 238000010586 diagram Methods 0.000 description 11
- 230000000694 effects Effects 0.000 description 11
- 238000007405 data analysis Methods 0.000 description 5
- 230000005611 electricity Effects 0.000 description 5
- 230000002159 abnormal effect Effects 0.000 description 4
- 238000004422 calculation algorithm Methods 0.000 description 3
- 230000003993 interaction Effects 0.000 description 3
- 238000005259 measurement Methods 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 2
- 238000010219 correlation analysis Methods 0.000 description 2
- 238000013079 data visualisation Methods 0.000 description 2
- 238000001914 filtration Methods 0.000 description 2
- 238000010801 machine learning Methods 0.000 description 2
- 238000012800 visualization Methods 0.000 description 2
- 230000001174 ascending effect Effects 0.000 description 1
- 230000006399 behavior Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000004590 computer program Methods 0.000 description 1
- 238000007728 cost analysis Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000002372 labelling Methods 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/34—Browsing; Visualisation therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/33—Querying
- G06F16/332—Query formulation
- G06F16/3329—Natural language query formulation or dialogue systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/30—Semantic analysis
Abstract
The invention relates to a visual multidimensional data display system and method based on semantic recognition, belongs to the technical field of data processing and display, and solves the problems of low intelligent degree, low data utilization rate and low response speed of the conventional data processing and display. The system comprises: the semantic recognition module acquires the query requirement of the user in a multi-round conversation mode and further determines a query instruction; the data management module is used for acquiring service data from the service system, performing structuring processing to obtain different service scene data packets and storing the different service scene data packets in a database; the query module is used for extracting the service data from the database according to the query instruction; the analysis module is used for converting the business data into at least one functional chart according to the characteristics of the business data; and the operation display module is used for displaying the extracted service data and the function chart. The system improves the intelligent degree of data processing and display, the utilization rate of data and the data response speed.
Description
Technical Field
The invention relates to the technical field of data processing and display, in particular to a visual multidimensional data display system and method based on semantic recognition.
Background
In the prior art, enterprise users can only rely on the traditional support to pull the visual display tool to display in the face of the requirements of tens of millions of service data and hundreds of thousands of multi-dimensional report data visual graphics, the method has higher requirements on the use skills of the users, improves the learning cost of the users on the display tool, can only display data results according to the operation of the users, and has low data utilization rate in a service system database; in addition, the traditional display tool cannot actively guide the user to acquire or recommend valuable data to the user according to the user behavior, only the degree is low, the data utilization rate is low, the flexible and variable data analysis and processing requirements of the user cannot be quickly responded, and the use experience of the user is reduced.
Disclosure of Invention
In view of the foregoing analysis, the present invention aims to provide a system and a method for displaying visualized multidimensional data based on semantic recognition, so as to solve the problems of low intelligence degree, low data utilization rate and low corresponding speed of the existing data processing and displaying methods.
In one aspect, the present invention provides a visual multidimensional data display system based on semantic recognition, including:
the semantic recognition module is used for acquiring the query requirements of the user in a multi-round conversation mode based on the input instruction of the user and determining a corresponding query instruction; the query instruction comprises a query service scene, a query dimension, a query index, a query date or a query condition;
the data management module is used for acquiring service data from a service system, performing structuring processing on the service data to obtain different service scene data packets and storing the different service scene data packets in a database;
the query module is used for extracting corresponding service data from the database according to the query instruction;
the analysis module is used for converting the business data into at least one functional chart according to the extracted characteristics of the business data;
and the operation display module is used for displaying the extracted service data and the converted function chart.
Further, the database is also used for storing the determined query instruction, the correspondingly extracted service data and the corresponding function chart;
and the query module is used for directly extracting corresponding service data and function charts from the database according to the query instruction after the semantic recognition module determines the corresponding query instruction when the user inputs the same query requirement again.
Further, the analysis module is specifically configured to:
when the extracted business data comprise year or month, converting the extracted business data into a trend chart by using a trend analysis model;
when the ratio among the extracted service data values in the service data reaches a preset ratio, converting the extracted service data into a ratio chart by using a ratio analysis model;
when the extracted business data contain singular values, converting the extracted business data into an outlier chart by using an outlier analysis model.
Further, the service scenario includes an organization and a service type;
the semantic recognition module comprises:
the corpus module is used for respectively carrying out normalization processing on the organization related to the historical query data and the standard names of the corresponding service types, and respectively carrying out normalization processing on the types and the standard names of the key fields corresponding to each service type to obtain corresponding standard corpus and storing the standard corpus in the database;
and the entry processing module is used for cutting words of the instruction input by the user to obtain a plurality of sequentially arranged field information, matching the field information with the organization, the service type and the key field in the speech packet, and obtaining a corresponding query instruction according to the matching result.
Further, the semantic recognition module further comprises a guidance module:
the guiding module is used for giving an input instruction prompt in a multi-turn conversation mode based on the field information to guide a user to supplement an input instruction and transmitting the input instruction to the entry management module when the entry processing module cannot determine a corresponding query instruction through matching, so as to obtain the corresponding query instruction; and when a plurality of query instructions are obtained according to the matching result, the query instructions are sent to a user, the query instructions are selected by the user through the operation display module, and the query instructions selected by the user are transmitted to the query module.
Further, the guiding module is further configured to:
and guiding the user to supplement the query organization, the query service type, the query index, the query dimension, the query date or the query condition so as to obtain a corresponding query instruction.
Furthermore, the guidance module is further configured to give a prompt of a query instruction according to a historical query record of the user, provide the user with a selection through the operation display module, and transmit the query instruction selected by the user to the query module.
Further, the data management module performs structured processing on the service data to obtain different service scene voice packets, including:
determining the standard name of the corresponding dimension information, index information and date information of each service data in each service scene;
unifying the dimension information, index information and date information corresponding to each service data to obtain different service scene data packets, and storing the different service scene data packets in a database
Further, the entry processing module is further configured to:
matching each field information with the organization and the service type in the speech packet respectively, and determining the standard name of the organization and the service type so as to obtain a service scene in the query instruction;
determining a standard name of the field information according to the category and the standard name of the key field in the determined key field corresponding to the service scene, so as to obtain a query dimension, a query index and a query date in a query instruction;
and marking the sequentially arranged field information based on the obtained standard name, and replacing the corresponding field information to obtain the query instruction.
On the other hand, the invention provides a visual multidimensional data display method based on semantic recognition, which comprises the following steps:
acquiring a query demand of a user in a multi-turn conversation mode based on an input instruction of the user, and determining a corresponding query instruction; the query instruction comprises a query service scene, a query dimension, a query index, a query date or a query condition;
acquiring service data from a service system, performing structured processing on the service data to obtain different service scene data packets, and storing the different service scene data packets in a database;
extracting corresponding service data from the database according to the query instruction;
converting the business data into at least one functional chart according to the extracted characteristics of the business data;
and displaying the extracted service data and the converted function chart through a display.
Compared with the prior art, the invention can realize at least one of the following beneficial effects:
1. the visual multidimensional data display system and method based on semantic recognition, provided by the invention, obtain the query intention of a user in a multi-turn conversation mode so as to determine a corresponding query instruction; in addition, corresponding input instructions or query instruction prompts can be provided for the user according to the historical query records of the user so as to be selected by the user, or corresponding data and diagrams are directly displayed for the user according to the historical query records of the user, so that the humanization of human-computer interaction is improved, and the response rate of data query is improved;
2. the invention can construct a scene data analysis model according to the business characteristics of an enterprise, the analysis model can analyze and convert the business data into a corresponding chart according to the characteristics of the obtained business data, the steps of artificial learning, calculation, chart making and the like are omitted, the data display is diversified, concretely, algorithm services based on content recommendation, collaborative filtering and the like are provided according to the data characteristics to realize active correlation analysis recommendation, various multi-dimensional data analysis charts can be provided for users with different businesses and different requirements, the presentation mode is accurate and scientific, support is provided for reporting and conveying data information, and the data processing and analysis degree, the intelligent degree and the data utilization rate are improved; in addition, the analysis model is not limited by the client and the display terminal, convenience is provided for centralized management of data, data processing time is saved, and data visualization display efficiency is improved.
In the invention, the technical schemes can be combined with each other to realize more preferable combination schemes. Additional features and advantages of the invention will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. The objectives and other advantages of the invention will be realized and attained by the structure particularly pointed out in the written description and drawings.
Drawings
The drawings are only for purposes of illustrating particular embodiments and are not to be construed as limiting the invention, wherein like reference numerals are used to designate like parts throughout.
FIG. 1 is a schematic diagram of a visual multidimensional data presentation system based on semantic recognition according to an embodiment of the present invention;
fig. 2 is a schematic diagram of a result of performing structured processing on service data according to an embodiment of the present invention;
FIG. 3 is a schematic diagram illustrating service data corresponding to other operation fees queried by a user according to an embodiment of the present invention;
FIG. 4 is a diagram illustrating an analysis module according to the business data shown in FIG. 3;
FIG. 5 is a diagram illustrating a guidance module providing an input instruction prompt in a multi-turn conversation manner according to an embodiment of the present invention;
fig. 6 is a schematic diagram of a visualization multidimensional data display method based on semantic recognition according to an embodiment of the present invention.
Detailed Description
The accompanying drawings, which are incorporated in and constitute a part of this application, illustrate preferred embodiments of the invention and together with the description, serve to explain the principles of the invention and not to limit the scope of the invention.
The invention discloses a visual multidimensional data display system based on semantic recognition. As shown in fig. 1, the system includes:
and the semantic recognition module is used for acquiring the query requirement of the user in a multi-turn conversation mode based on the input instruction of the user and determining a corresponding query instruction. The user can input the instruction manually or by voice, and the input of the multiple turns of conversation of the user can be used as a whole for determining the query instruction in the multiple turns of conversation mode. Specifically, the query instruction includes a service scenario of the query, a query dimension, a query index, a query date, or a query condition. The business scenario includes organization and business type. For example, the business scenario may be other operation cost analysis scenario of company a or marketing activity user category analysis scenario of company B; specifically, the company A and the company B are organizations, and other operation expense analysis scenes and marketing activity user category analysis scenes are service types, wherein the other operation expense analysis scenes comprise service activity dimensions and a series of cost element indexes, such as business handling fees, traveling fees, consulting fees and the like; the marketing activity user category analysis scene comprises a business activity dimension, a user category dimension and a series of marketing activity indexes such as user quantity, electricity sales amount, marketing cost and the like.
Preferably, the policy corresponding to the multi-round session mode includes: and clearing the historical state memory over time, clearing the historical state memory over polling times, permanently saving strategies and the like. The historical state mainly records and stores word slot values in word slots, and the word slots are slots used for filling in keyword entries in user conversations.
And the data management module is used for acquiring service data from the service system, performing structuring processing on the service data to obtain different service scene data packets, and storing the different service scene data packets in the database. The business systems refer to business systems of different enterprises or business systems corresponding to different fields in the enterprises. As shown in fig. 2, the structuring of the service data refers to a unification process (or specification) of scenes, dimensions, indexes, dates, and the like of the service data. Illustratively, data in a business system is loaded into the system, and the data is processed according to a unified specification, including synonym conversion, data integrity row check and the like.
And the query module is used for extracting corresponding service data from the database according to the query instruction.
And the analysis module actively explores the potential rules of the service data based on machine learning, an intelligent algorithm, an NLP (non-line segment) technology and the like, and excavates abnormal deviation values, null values, maximum values, minimum values, average values, gradients and the like of various dimensionalities and index combinations under the scene to locate abnormal service data information in the data set. Preferably, the service data may be converted into at least one function chart according to characteristics of the extracted service data. Specifically, different analysis models can be set according to the business characteristics of different enterprises.
And the operation display module is used for displaying the extracted service data and the converted function chart. Preferably, the operation display module can be a PC end or a mobile phone end for realizing human-computer interaction.
Preferably, the database is further configured to store the determined query instruction, the correspondingly extracted service data, and the corresponding function chart.
When the user inputs the same query requirement again, after the semantic recognition module determines the corresponding query instruction, the query module can directly extract the corresponding service data and the corresponding function chart from the database according to the query instruction, and directly display the service data and the function chart through the operation display module, so that the response speed of data processing and display is increased, and the user experience is improved.
Preferably, the analysis module may include a trend analysis model, a proportion analysis model, and an outlier analysis model.
Specifically, when the extracted service data includes year or month, that is, when the queried data changes with time, the corresponding trend analysis model may convert the extracted service data into a trend chart for the user to refer to.
And when the ratio among the extracted service data values in the service data reaches a preset ratio, converting the extracted service data into a ratio chart by using a ratio analysis model for reference of a user. Preferably, the preset proportion can be set in a user-defined mode according to the use requirement. Illustratively, the total cost of an enterprise 2020 in one month is 150 ten thousand, the staff incentive class cost is 90 ten thousand, and the duty ratio reaches more than 50%, it is obvious that the difference between the staff incentive class cost and the cost of other items is significant, the duty ratio analysis model converts the corresponding business data into a duty ratio chart, and the user can more intuitively determine the dominant duty ratio data item through the chart.
When the extracted business data contains singular values, the corresponding outlier analysis model can convert the extracted business data into an outlier chart. For example, only the electricity consumption business has a corresponding cost value in the enterprise business scale trend cost, and the cost values of other items (such as enterprise management, power supply service, substation maintenance, intelligent electricity consumption and the like) are all 0, which indicates that the cost data of the electricity consumption business may be abnormal, and the outlier analysis model converts the cost data into an outlier chart for the user to refer to, so as to remind the user that the data may be abnormal.
Preferably, when the extracted service data has the above characteristics, the analysis module correspondingly converts the service data into a plurality of charts. Exemplarily, when the user inquires about other operation fees in january, the obtained service data is shown in fig. 3, which also includes data including corresponding dimensions and corresponding indexes of other operation fees in february and march, and since the space is large, only part of the service data is shown in fig. 3; the analysis module may analyze the characteristics of the queried service data, and then convert the characteristics into a corresponding graph, as shown in fig. 4. The intelligent degree of the system is improved, and meanwhile, the manual work of tabulation and drawing is reduced. Specifically, fig. 3 includes changes of other operating expenses with months, so that the trend analysis model converts the service data into a corresponding trend chart according to the characteristics; the difference value of the personnel incentive cost is larger than that of other costs, so that the proportion analysis model can convert the service data into a corresponding proportion chart according to the characteristics; in addition, the value of the policy cause type cost in three months is relatively average, so that the low variance analysis model can convert the service data into an average chart according to the characteristic; the business scale dynamic dimension corresponds to a plurality of indexes, only the electricity utilization business index has a numerical value and is far larger than the values of other indexes, and at the moment, the outlier analysis model can be utilized to convert the business data into an outlier chart according to the characteristic.
Preferably, the analysis module converts the extracted service data into a corresponding graph by:
determining the display dimension of the chart according to the query dimension, the query condition and the display mode (ascending or descending); and determining the display measurement of the chart according to the query dimension, the query index, the query condition and the display mode, wherein the display mode is a visual mode, and preferably comprises a card, a list, a column diagram, a bar chart, a line chart, a pie chart, a ring chart, a scatter diagram, a tree diagram and the like. Preferably, priorities of a plurality of default display modes of the analysis model are preset, if the visualization mode is empty or conflicts with the display dimension measurement number of the analysis model, the display dimension number is judged, if 0 display dimension is judged, 1 display dimension default card is provided, more than or equal to 1 display dimension or a default list with the measurement value larger than 2 is provided, and the dimension is converted into a line graph by default when the dimension is time.
Preferably, the semantic recognition module includes:
and the corpus module is used for respectively carrying out normalization processing on the organization related to the historical query data and the standard name of the corresponding service type, and respectively carrying out normalization processing on the type and the standard name of the key field corresponding to each service type to obtain a corresponding standard corpus and storing the standard corpus in the database. For example, the names of the company a may be various, the names of a certain part of the company a may also be various, the various names are unified into a standard name, and the corresponding service types are processed in the same way. Specifically, each service type includes a time, a dimension, an index, and the like of the type of the key field. Illustratively, the types of the key fields corresponding to the last year, the present month, the month and the previous month are all time, and the present month, the present month and the present month are all unified into a standard name of "the present month"; the types of key fields corresponding to the business expenses, the travelling expenses, the lodging expenses, the traffic expenses and the catering expenses are all indexes, and the travelling expenses, the lodging expenses, the traffic expenses and the catering expenses are unified into a standard name of 'travelling expenses'.
And the entry processing module is used for cutting words of the instruction input by the user to obtain a plurality of sequentially arranged field information, matching the field information with the organization, the service type and the key field in the speech packet, and obtaining a corresponding query instruction according to the matching result.
Specifically, each field information is respectively matched with the organization and the service type in the speech packet, and the standard name of the organization and the service type is determined, so that the service scene in the query instruction is obtained. Specifically, when the user queries the relevant data in the company or the enterprise, the corresponding organization standard name does not need to be determined, and in addition, the corresponding business type can be determined according to the specific characteristics of some field information.
And determining a standard name of field information in the key field corresponding to the determined service scene according to the category and the standard name of the key field, so as to obtain the query dimension, the query index and the query date in the query instruction.
And marking the sequentially arranged field information based on the obtained standard name, and replacing the corresponding field information to obtain the query instruction.
Illustratively, the user inputs the instruction: i check the business activities with the monthly transaction fee more than 10 and the traveling fee less than 100 and sort the transaction fees in descending order. The specific process of obtaining the query instruction according to the instruction is as follows:
And 2, determining the corresponding service type as multidimensional analysis of other operation expenses according to the travelling and business expenses.
And 3, determining the query dimension as the business activity according to the field information business activity.
And 4, determining the query indexes of the travel fee and the business fee according to the field information as the travel fee and the business fee.
And 5, determining the query time according to the month of the field information as the month, namely the month when the user queries.
And 6, determining that the business charge is more than 10 and the travelling charge is less than 100 according to the field information, wherein the query conditions are that the business charge is more than 10 and the travelling charge is less than 100.
And 7, determining the display form of the inquired data in descending order of the handling fees according to the field information handling fees and descending order.
Step 8, performing text labeling on the field information to obtain a corresponding query instruction:
i check the < query dimension > business activity of the month < query time > < query index > transaction cost > greater than < value >10 and < query index > traveling cost > less than < value >100< and sort the transaction cost < presentation form > descending order < query index >.
Preferably, the semantic recognition module further comprises a guidance module:
when the entry processing module cannot determine the corresponding query instruction through matching, as shown in fig. 5, the guidance module is configured to give an input instruction prompt in a multi-turn conversation manner based on the field information to guide the user to supplement the input instruction and transmit the input instruction to the entry management module, so as to obtain the corresponding query instruction.
In addition, when the entry processing module obtains a plurality of query instructions according to the matching result, the guiding module can send the plurality of query instructions to the user, the user can select the query instructions through the operation display module, and the query instructions selected by the user are transmitted to the query module.
Preferably, the guidance module gives the input instruction prompt in a multi-turn conversation mode, and the method comprises the following steps:
and guiding the user to supplement the query organization, the query service type, the query index, the query dimension, the query date or the query condition so as to obtain a corresponding query instruction.
Preferably, the guidance module performs machine learning based on the historical query record of the user, so that when the user input instruction is incomplete, a query instruction prompt can be given according to the historical query record of the user, the user can select the query instruction by operating the display module, the query instruction selected by the user is transmitted to the query module, and other query instructions related to the query instruction are recommended to the user, so that data query reference is provided for the user, and the use efficiency of data is improved.
Preferably, the data management module performs structured processing on the service data to obtain different service scene voice packets, and includes:
and determining the standard name of the dimension information, the index information and the date information corresponding to each service data in each service scene.
And carrying out unified processing on the dimension information, the index information and the date information corresponding to each service data to obtain different service scene data packets, and storing the different service scene data packets in a database.
The invention further discloses a visual multidimensional data display method based on semantic recognition.
Since the principle of the embodiment of the method is the same as that of the embodiment of the system, the detailed description may refer to the embodiment of the system, and is not repeated herein.
As shown in fig. 6, the method comprises the steps of:
acquiring a query demand of a user in a multi-turn conversation mode based on an input instruction of the user, and determining a corresponding query instruction; the query instruction comprises a service scene, a query dimension, a query index, a query date or a query condition of the query.
And acquiring service data from the service system, performing structuring processing on the service data to obtain different service scene data packets, and storing the different service scene data packets in a database.
And extracting corresponding service data from the database according to the query instruction.
And converting the business data into at least one function chart according to the characteristics of the extracted business data.
And displaying the extracted service data and the converted function chart through a display.
Compared with the prior art, the visual multidimensional data display system and method based on semantic recognition, provided by the invention, have the advantages that on one hand, the query intention of a user is obtained in a multi-turn conversation mode to determine a corresponding query instruction; in addition, corresponding input instructions or query instruction prompts can be provided for the user according to the historical query records of the user so as to be selected by the user, or corresponding data and diagrams are directly displayed for the user according to the historical query records of the user, so that the humanization of human-computer interaction is improved, and the response rate of data query is improved; on the other hand, the invention can construct a scene data analysis model according to the business characteristics of an enterprise, the analysis model can analyze and convert the business data into a corresponding chart according to the characteristics of the obtained business data, the steps of artificial learning, calculation, chart making and the like are omitted, the data display is diversified, concretely, algorithm services based on content recommendation, collaborative filtering and the like are provided according to the data characteristics to realize active correlation analysis recommendation, various multi-dimensional data analysis charts can be provided for users with different businesses and different requirements, the presentation mode is accurate and scientific, support is provided for reporting and conveying data information, and the data processing and analysis degree, the intelligent degree and the data utilization rate are improved; in addition, the analysis model is not limited by the client and the display terminal, convenience is provided for centralized management of data, data processing time is saved, and data visualization display efficiency is improved.
Those skilled in the art will appreciate that all or part of the flow of the method implementing the above embodiments may be implemented by a computer program, which is stored in a computer readable storage medium, to instruct related hardware. The computer readable storage medium is a magnetic disk, an optical disk, a read-only memory or a random access memory.
The above description is only for the preferred embodiment of the present invention, but the scope of the present invention is not limited thereto, and any changes or substitutions that can be easily conceived by those skilled in the art within the technical scope of the present invention are included in the scope of the present invention.
Claims (10)
1. A visual multidimensional data presentation system based on semantic recognition is characterized by comprising:
the semantic recognition module is used for acquiring the query requirements of the user in a multi-round conversation mode based on the input instruction of the user and determining a corresponding query instruction; the query instruction comprises a query service scene, a query dimension, a query index, a query date or a query condition;
the data management module is used for acquiring service data from a service system, performing structuring processing on the service data to obtain different service scene data packets and storing the different service scene data packets in a database;
the query module is used for extracting corresponding service data from the database according to the query instruction;
the analysis module is used for converting the business data into at least one functional chart according to the extracted characteristics of the business data;
and the operation display module is used for displaying the extracted service data and the converted function chart.
2. The system of claim 1, wherein the database is further configured to store the determined query instruction, the corresponding extracted business data, and the corresponding function chart;
and the query module is used for directly extracting corresponding service data and function charts from the database according to the query instruction after the semantic recognition module determines the corresponding query instruction when the user inputs the same query requirement again.
3. A visual multi-dimensional data presentation system according to claim 1 or 2, wherein said analysis module is specifically configured to;
when the extracted business data comprise year or month, converting the extracted business data into a trend chart by using a trend analysis model;
when the ratio among the extracted service data values in the service data reaches a preset ratio, converting the extracted service data into a ratio chart by using a ratio analysis model;
when the extracted business data contain singular values, converting the extracted business data into an outlier chart by using an outlier analysis model.
4. A visual multidimensional data presentation system as claimed in claim 1 or 2 wherein said semantic identification module comprises:
the corpus module is used for respectively carrying out normalization processing on the organization related to the historical query data and the standard names of the corresponding service types, and respectively carrying out normalization processing on the types and the standard names of the key fields corresponding to each service type to obtain corresponding standard corpus and storing the standard corpus in the database;
and the entry processing module is used for cutting words of the instruction input by the user to obtain a plurality of sequentially arranged field information, matching the field information with the organization, the service type and the key field in the standard language packet, and obtaining a corresponding query instruction according to a matching result.
5. The visualized multidimensional data presentation system of claim 4 wherein the semantic recognition module further comprises a guidance module:
the guidance module is used for: when the vocabulary entry processing module cannot determine a corresponding query instruction through matching, an input instruction prompt is given in a multi-turn conversation mode based on the field information to guide a user to supplement the input instruction and transmit the input instruction to the vocabulary entry management module, and then the corresponding query instruction is obtained; and when a plurality of query instructions are obtained according to the matching result, the query instructions are used for sending the query instructions to a user, the query instructions are selected by the user through the operation display module, and the query instructions selected by the user are transmitted to the query module.
6. The visualized multidimensional data presentation system of claim 5 wherein the guidance module is further configured to:
and guiding the user to supplement the query organization, the query service type, the query index, the query dimension, the query date or the query condition so as to obtain a corresponding query instruction.
7. The system according to claim 5 or 6, wherein the guidance module is further configured to give a prompt of query instructions according to the historical query records of the user, provide the user with a choice through the operation display module, and transmit the query instructions selected by the user to the query module.
8. The system according to any one of claims 1, 2, 5-6, wherein the data management module performs a structuring process on the service data to obtain different service scene language packages, and comprises:
determining the standard name of the corresponding dimension information, index information and date information of each service data in each service scene;
and carrying out unified processing on the dimension information, the index information and the date information corresponding to each service data to obtain different service scene data packets, and storing the different service scene data packets in a database.
9. The visual multi-dimensional data presentation system of any one of claims 5-6, wherein the term processing module is further configured to:
matching each field information with the organization and the service type in the speech packet respectively, and determining the standard name of the organization and the service type so as to obtain a service scene in the query instruction;
determining a standard name of the field information according to the category and the standard name of the key field in the determined key field corresponding to the service scene, so as to obtain a query dimension, a query index and a query date in a query instruction;
and marking the sequentially arranged field information based on the obtained standard name, and replacing the corresponding field information to obtain the query instruction.
10. A visualized multidimensional data display method based on semantic recognition is characterized by comprising the following steps:
acquiring a query demand of a user in a multi-turn conversation mode based on an input instruction of the user, and determining a corresponding query instruction; the query instruction comprises a query service scene, a query dimension, a query index, a query date or a query condition;
acquiring service data from a service system, performing structured processing on the service data to obtain different service scene data packets, and storing the different service scene data packets in a database;
extracting corresponding service data from the database according to the query instruction;
converting the business data into at least one functional chart according to the extracted characteristics of the business data;
and displaying the extracted service data and the converted function chart through a display.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011252986.3A CN112463954B (en) | 2020-11-11 | 2020-11-11 | Visual multidimensional data display system and method based on semantic recognition |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011252986.3A CN112463954B (en) | 2020-11-11 | 2020-11-11 | Visual multidimensional data display system and method based on semantic recognition |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112463954A true CN112463954A (en) | 2021-03-09 |
| CN112463954B CN112463954B (en) | 2024-01-02 |
Family
ID=74826474
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011252986.3A Active CN112463954B (en) | 2020-11-11 | 2020-11-11 | Visual multidimensional data display system and method based on semantic recognition |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112463954B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113076305A (en) * | 2021-04-20 | 2021-07-06 | 广东电网有限责任公司 | Data processing method and device, electronic equipment and storage medium |
| CN113094424A (en) * | 2021-04-09 | 2021-07-09 | 北京元年科技股份有限公司 | Method and system for identifying chart mode by constructing multi-level index system |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JPH1173431A (en) * | 1997-02-10 | 1999-03-16 | Nippon Telegr & Teleph Corp <Ntt> | Definition generation supporting device based on feature of data, method therefor and storage medium stored with program therefor |
| CN102915381A (en) * | 2012-11-20 | 2013-02-06 | 公安部第三研究所 | Multi-dimensional semantic based visualized network retrieval rendering system and rendering control method |
| US20140074887A1 (en) * | 2012-09-07 | 2014-03-13 | Splunk Inc. | Data model for machine data for semantic search |
| US20150082219A1 (en) * | 2013-09-19 | 2015-03-19 | Oracle International Corporation | Contextualized report building |
| US20170039281A1 (en) * | 2014-09-25 | 2017-02-09 | Oracle International Corporation | Techniques for semantic searching |
| CN106598988A (en) * | 2015-10-16 | 2017-04-26 | 阿里巴巴集团控股有限公司 | Data processing method and device |
| CN109325097A (en) * | 2018-07-13 | 2019-02-12 | 海信集团有限公司 | A kind of voice guide method and device, electronic equipment, storage medium |
| CN110188163A (en) * | 2019-04-13 | 2019-08-30 | 上海策友信息科技有限公司 | Data intelligence processing system based on natural language |
| US10546001B1 (en) * | 2015-04-15 | 2020-01-28 | Arimo, LLC | Natural language queries based on user defined attributes |
| CN110825472A (en) * | 2019-10-14 | 2020-02-21 | 东软集团股份有限公司 | Chart color drawing method and device, readable storage medium and electronic equipment |
-
2020
- 2020-11-11 CN CN202011252986.3A patent/CN112463954B/en active Active
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JPH1173431A (en) * | 1997-02-10 | 1999-03-16 | Nippon Telegr & Teleph Corp <Ntt> | Definition generation supporting device based on feature of data, method therefor and storage medium stored with program therefor |
| US20140074887A1 (en) * | 2012-09-07 | 2014-03-13 | Splunk Inc. | Data model for machine data for semantic search |
| CN102915381A (en) * | 2012-11-20 | 2013-02-06 | 公安部第三研究所 | Multi-dimensional semantic based visualized network retrieval rendering system and rendering control method |
| US20150082219A1 (en) * | 2013-09-19 | 2015-03-19 | Oracle International Corporation | Contextualized report building |
| US20170039281A1 (en) * | 2014-09-25 | 2017-02-09 | Oracle International Corporation | Techniques for semantic searching |
| US10546001B1 (en) * | 2015-04-15 | 2020-01-28 | Arimo, LLC | Natural language queries based on user defined attributes |
| CN106598988A (en) * | 2015-10-16 | 2017-04-26 | 阿里巴巴集团控股有限公司 | Data processing method and device |
| CN109325097A (en) * | 2018-07-13 | 2019-02-12 | 海信集团有限公司 | A kind of voice guide method and device, electronic equipment, storage medium |
| CN110188163A (en) * | 2019-04-13 | 2019-08-30 | 上海策友信息科技有限公司 | Data intelligence processing system based on natural language |
| CN110825472A (en) * | 2019-10-14 | 2020-02-21 | 东软集团股份有限公司 | Chart color drawing method and device, readable storage medium and electronic equipment |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113094424A (en) * | 2021-04-09 | 2021-07-09 | 北京元年科技股份有限公司 | Method and system for identifying chart mode by constructing multi-level index system |
| CN113094424B (en) * | 2021-04-09 | 2022-03-01 | 北京元年科技股份有限公司 | Method and system for identifying chart mode by constructing multi-level index system |
| CN113076305A (en) * | 2021-04-20 | 2021-07-06 | 广东电网有限责任公司 | Data processing method and device, electronic equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112463954B (en) | 2024-01-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8943087B2 (en) | Processing data from diverse databases | |
| WO1996027837A1 (en) | Apparatus for applying if-then-else rules to relational database | |
| US20090132581A1 (en) | Information service for facts extracted from differing sources on a wide area network | |
| CN112463954B (en) | Visual multidimensional data display system and method based on semantic recognition | |
| CN112506921B (en) | Multi-source heterogeneous index multi-dimensional self-service analysis method based on data middleboxes | |
| Hariguna et al. | Implementation of business intelligence using highlights in the yii framework based attendance assessment system | |
| Yaakub et al. | Integration of opinion into customer analysis model | |
| CN111475531A (en) | Information analysis system based on student employment data | |
| Nudurupati et al. | Performance measurement in data intensive organisations: resources and capabilities for decision-making process | |
| CN103473305A (en) | Method and system for performing decision-making process show in statistic analysis | |
| Stjepić et al. | Technology, organizational and environmental determinants of business intelligence systems adoption in croatian SME: a case study of medium-sized enterprise | |
| CN113626571A (en) | Answer sentence generating method and device, computer equipment and storage medium | |
| US20200160359A1 (en) | User-experience development system | |
| US20090171744A1 (en) | System and method for reducing employee training time and distributing corporate and job information to employees | |
| Havnes | Dynamics of small business internationalisation. A European panel study | |
| CN111625616A (en) | Enterprise-level data management system capable of realizing mass storage | |
| KR20080112141A (en) | Construction project performance management method and system using bsc and the data warehouse | |
| Mitra | Models for decision making: an overview of problems, tools and major issues | |
| Beem | A DESIGN STUDY TO ENHANCE PERFORMANCE DASHBOARDS TO IMPROVE THE DECISION-MAKING PROCESS | |
| CN110659867A (en) | Comprehensive personal management service system for fund flow, travel management and financial management | |
| Kamaruddin et al. | Small and medium enterprise business solutions using data visualization | |
| CN115168603B (en) | Automatic feedback response method, device and storage medium for color ring back tone service process | |
| Levashova et al. | Context-based modelling of information demand: Approaches from information logistics and decision support | |
| Ingvaldsen | Ontology-Driven Business Process Intelligence | |
| Smyrnaki | Data warehousing in higher education. A case study of the Hellenic Mediterranean University. |
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 |