CN117892704A - Chart generation method, system, terminal and readable storage medium - Google Patents

Chart generation method, system, terminal and readable storage medium Download PDF

Info

Publication number
CN117892704A
CN117892704A CN202311719597.0A CN202311719597A CN117892704A CN 117892704 A CN117892704 A CN 117892704A CN 202311719597 A CN202311719597 A CN 202311719597A CN 117892704 A CN117892704 A CN 117892704A
Authority
CN
China
Prior art keywords
data
chart
user
statement
acquired
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.)
Pending
Application number
CN202311719597.0A
Other languages
Chinese (zh)
Inventor
邬传朋
吴锦松
郑凯匀
周枢湘
邓娜
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shenzhen Taiji Shuzhi Technology Co ltd
Original Assignee
Shenzhen Taiji Shuzhi Technology Co ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Shenzhen Taiji Shuzhi Technology Co ltd filed Critical Shenzhen Taiji Shuzhi Technology Co ltd
Priority to CN202311719597.0A priority Critical patent/CN117892704A/en
Publication of CN117892704A publication Critical patent/CN117892704A/en
Pending legal-status Critical Current

Links

Classifications

    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02DCLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00Energy efficient computing, e.g. low power processors, power management or thermal management

Landscapes

  • Stored Programmes (AREA)

Abstract

The application is applicable to the field of data processing, and provides a chart generation method, a chart generation system, a chart generation terminal and a readable storage medium, wherein the chart generation method comprises the following steps: analyzing the user service requirement to obtain the user service intention; converting the user business intention into a business execution statement based on code conversion processing; and executing the business execution statement to generate a target chart. According to the scheme, the chart generation time is reduced, and the generated target chart is more fit with the actual use requirement of a user.

Description

Chart generation method, system, terminal and readable storage medium
Technical Field
The application belongs to the field of data processing, and particularly relates to a chart generation method, a chart generation system, a chart generation terminal and a readable storage medium.
Background
The chart can enable the data to be visualized, so that people can more quickly and intuitively perceive the composition, the change trend and the like of the data. The existing chart generation method comprises the following steps: the programmer writes the front end code and the back end code of the chart of the data to be displayed according to the experience of the practitioner and the chart template to generate the chart, which is time-consuming and not suitable for the actual use requirement of the user.
Disclosure of Invention
The embodiment of the application provides a chart generation method, a chart generation system, a terminal and a readable storage medium, so as to solve the problems that the chart generation method in the prior art is time-consuming and is not fit with the actual use requirements of users.
A first aspect of an embodiment of the present application provides a chart generating method, including:
analyzing the user service requirement to obtain the user service intention;
converting the user business intention into a business execution statement based on code conversion processing;
and executing the business execution statement to generate a target chart.
A second aspect of an embodiment of the present application provides a chart generating system, including:
the analysis module is used for analyzing the user service requirements to obtain user service intentions;
the conversion module is used for converting the user business intention into a business execution statement based on code conversion processing;
and the generating module is used for executing the business execution statement and generating a target chart.
A third aspect of the embodiments of the present application provides a terminal comprising a memory, a processor and a computer program stored in the memory and executable on the processor, the processor implementing the steps of the method according to the first aspect when executing the computer program.
A fourth aspect of the embodiments of the present application provides a computer-readable storage medium storing a computer program which, when executed by a processor, implements the steps of the method according to the first aspect.
A fifth aspect of the present application provides a computer program product for causing a terminal to carry out the steps of the method of the first aspect described above when the computer program product is run on the terminal.
From the above, the present application analyzes the acquired user service requirement to obtain the user service intention, then converts the user service intention into a service execution statement through code conversion processing, and generates the target chart by executing the service execution statement. In the process, a user only needs to execute one operation, namely input user service requirements, the user service requirements can be analyzed, namely deep mining is performed, the essential requirements of the user, namely user service intention, front and rear end codes are not required to be written for data, a target chart can be generated according to the user service intention, chart generation time is shortened, the generated target chart is more suitable for actual use requirements of the user, and the generation method is more flexible.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the following description will briefly introduce the drawings that are needed in the embodiments or the description of the prior art, it is obvious that the drawings in the following description are only some embodiments of the present application, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flowchart I of a chart generation method provided in an embodiment of the present application;
FIG. 2 is a second flowchart of a chart generation method according to an embodiment of the present application;
FIG. 3 is a block diagram of a chart generation system provided in an embodiment of the present application;
fig. 4 is a block diagram of a terminal according to an embodiment of the present application.
Detailed Description
In the following description, for purposes of explanation and not limitation, specific details are set forth, such as particular system configurations, techniques, etc. in order to provide a thorough understanding of the embodiments of the present application. It will be apparent, however, to one skilled in the art that the present application may be practiced in other embodiments that depart from these specific details. In other instances, detailed descriptions of well-known systems, devices, circuits, and methods are omitted so as not to obscure the description of the present application with unnecessary detail.
It should be understood that the terms "comprises" and/or "comprising," when used in this specification and the appended claims, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof.
It is also to be understood that the terminology used in the description of the present application is for the purpose of describing particular embodiments only and is not intended to be limiting of the application. As used in this specification and the appended claims, the singular forms "a," "an," and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise.
It should be further understood that the term "and/or" as used in this specification and the appended claims refers to any and all possible combinations of one or more of the associated listed items, and includes such combinations.
As used in this specification and the appended claims, the term "if" may be interpreted in context as "when …" or "upon" or "in response to a determination" or "in response to detection. Similarly, the phrase "if a determination" or "if a [ described condition or event ] is detected" may be interpreted in the context of meaning "upon determination" or "in response to determination" or "upon detection of a [ described condition or event ]" or "in response to detection of a [ described condition or event ]".
In particular implementations, the terminals described in embodiments of the present application include, but are not limited to, other portable devices such as mobile phones, laptop computers, or tablet computers having a touch-sensitive surface (e.g., a touch screen display and/or a touch pad). It should also be appreciated that in some embodiments, the device is not a portable communication device, but a desktop computer having a touch-sensitive surface (e.g., a touch screen display and/or a touch pad).
In the following discussion, a terminal including a display and a touch sensitive surface is described. However, it should be understood that the terminal may include one or more other physical user interface devices such as a physical keyboard, mouse, and/or joystick.
The terminal supports various applications, such as one or more of the following: drawing applications, presentation applications, word processing applications, website creation applications, disk burning applications, spreadsheet applications, gaming applications, telephony applications, video conferencing applications, email applications, instant messaging applications, workout support applications, photo management applications, digital camera applications, digital video camera applications, web browsing applications, digital music player applications, and/or digital video player applications.
Various applications that may be executed on the terminal may use at least one common physical user interface device such as a touch sensitive surface. One or more functions of the touch-sensitive surface and corresponding information displayed on the terminal may be adjusted and/or changed between applications and/or within the corresponding applications. In this way, the common physical architecture (e.g., touch-sensitive surface) of the terminal may support various applications with user interfaces that are intuitive and transparent to the user.
It should be understood that the sequence number of each step in this embodiment does not mean the sequence of execution, and the execution sequence of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiment of the present application.
In order to illustrate the technical solutions described in the present application, the following description is made by specific examples.
Referring to fig. 1, fig. 1 is a flowchart of a chart generating method according to an embodiment of the present application. As shown in fig. 1, a chart generating method includes the steps of:
and step 101, analyzing the user service requirement to obtain the user service intention.
Specifically, before resolving a user service requirement to obtain a user service intention, the user service requirement needs to be acquired first. The user can input natural language, namely the user service requirement, through the user terminal.
Specifically, the user business requirements generate requirements for a chart entered by a user. The user service requirement comprises the name of the data category required by the generation of the chart indicated by the user, namely what kind of data is required, so as to facilitate the subsequent acquisition, and not specific data. In addition, the user business requirements may include a chart representation, i.e., how the data is processed to be visualized, e.g., reddening data exceeding a certain value, presenting it in a histogram, presenting it in a pie chart, or processing it as an integer, etc. The data category names are indispensable, the data category names in the application do not limit the expression format, and a user can clearly express the meaning of the data. For example, the data category name is referred to as "the monthly average sales of company 2022", the user may express "the sales amount of company every month of 2022 1-12 months", and so on.
Specifically, the application provides a chart generation method, which corresponds to a chart generation system. More specifically, the present application provides an artificial intelligence based chart generation method, preferably a generation type artificial intelligence technique, to generate charts. Training the standard generation type artificial intelligent model to obtain the generation type artificial intelligent model for generating the chart. The generated artificial intelligence (Artificial Intelligence Generated Content, AIGC) is an artificial intelligence technology based on a deep learning technology, that is, a technology for generating related content with proper generalization capability through learning and recognition of existing data based on a technical method for generating artificial intelligence such as an countermeasure network and a large-scale pre-training model, that is, the generated artificial intelligence model has excellent learning and imitation capability.
In particular, the user is typically an enterprise user, and the chart generation system and the database of the enterprise are stored in a communication interface, and data can be acquired through the communication interface, and the data in the database can be enterprise related data and public data provided by a third party platform.
Specifically, the present application provides a large amount of sample content for training by which a generative artificial intelligence model for generating charts is derived. The application provides sample service requirements and sample service data, and also provides sample service execution sentences written by developers based on the sample service requirements and sample service charts generated based on the provided contents. Training is mainly divided into two training phases.
Specifically, in the first training stage, the sample service requirement is taken as an input item, a standard generation type artificial intelligent model is input, one of output items is given, namely the sample service execution statement, the generation type artificial intelligent model continuously learns based on the sample service requirement and the sample service execution statement, and model parameters are adjusted, so that the training service execution statement output by the model is consistent with the implementation effect of the sample service execution statement.
Specifically, in the second training stage, the sample service data is obtained by executing the sample service execution statement, at this time, the sample service data is used as an input item and is input into the model, the sample service chart is used as an output item, learning is performed again, and model parameters are continuously adjusted, so that the training service chart output by the model is the same as the sample service chart, and the sample service requirement can be met.
Specifically, an output accuracy standard value may be set for each of the two training stages, and when the actual output accuracy reaches the output accuracy standard value, the training is considered to reach the requirement, and the generated artificial intelligence model at this time may be used as the generated artificial intelligence model for generating the chart, and for convenience of reference, the generated artificial intelligence model for generating the chart is referred to as the target generated artificial intelligence model.
Specifically, the generated artificial intelligence model has excellent text analysis function. In a first training stage, analyzing the sample service requirements through a generated artificial intelligent model, and mining the sample service requirements to obtain sample service intents corresponding to the sample service requirements.
In addition, the natural language input by the user can be text information or voice information, a voice recognition interface can be arranged at the user end, or the target generation type artificial intelligent model is directly utilized to recognize the voice information and convert the voice information into text information, so that the user service requirement is obtained, namely, the parsed natural language of which the user service requirement is text.
In particular, the generated artificial intelligence model typically interacts with the user at the user end in the form of a dialog. The goal-generating artificial intelligence model is no exception in this application. The user inputs the user service demands through a dialog box, and then the generated artificial intelligent model provides feedback information for the user through the dialog box, wherein the feedback information can be a target chart generated according to the user service demands, failure information of data acquisition, conflicting information of chart generation or problems encountered in other chart generation processes, and the like, and the introduction is not expanded any more.
Specifically, after the objective generation type artificial intelligence model obtains the user service requirement input by the user terminal, the user service requirement is analyzed, and in the analysis process, various technologies such as word segmentation, word recombination, synonym replacement, word correction, word order adjustment, semantic analysis and the like are adopted to continuously mine the user service requirement, so that the essential requirement is obtained by mining, namely the user service intention. Therefore, the user can input the user service requirement according to the language expression mode, a specific chart requirement format is not required to be followed, the input difficulty of the user service requirement is reduced, and the operation is simpler. The user business intention comprises data to be acquired and data processing logic, and the data to be acquired is processed based on the data processing logic. Wherein, the data to be acquired is generally a category name of the data to be acquired.
Specifically, the user service intention includes data to be acquired and data processing logic, and the analyzing the user service requirement to obtain the user service intention includes: analyzing the user service requirement to obtain first data to be acquired and first data processing logic; analyzing the first data to be acquired from a data category dimension to obtain second data to be acquired, wherein the second data to be acquired has data operation logic with the first data to be acquired; the acquisition priority of the first data to be acquired is higher than that of the second data to be acquired; and combining the first data processing logic and the data operation logic to obtain second data processing logic.
Specifically, the objective generation type artificial intelligence model analyzes the user service requirement to obtain the first data to be obtained and the first data processing logic, wherein the first data to be obtained and the first data processing logic are usually information directly obtained based on the surface layer meaning of the user service requirement, and the first data to be obtained is a data category name.
And then analyzing the first data to be acquired from the data category dimension to obtain second data to be acquired which has data operation logic with the first data to be acquired, wherein the second data to be acquired also has a data category name. The data category dimension includes a time dimension, a space dimension and the like. The first data to be acquired is higher in acquisition priority than the second data to be acquired, namely, when the data is acquired, the first data to be acquired is preferentially acquired, namely, the data closest to the user service requirement is preferentially acquired.
Specifically, the first data processing logic and the data operation logic between the first data to be acquired and the second data to be acquired are combined to obtain the second data processing logic.
Specifically, the first data to be acquired and the first data processing logic are a group, according to the first data to be acquired, first data can be obtained from the database, and the first data processing logic is used for processing the first data to generate the target chart. The second data to be acquired and the second data processing logic are a group, second data can be acquired from the database according to the second data to be acquired, and the second data processing logic is used for processing the second data to generate the target chart. The second data has more processing steps than the first data, namely data arithmetic logic.
Specifically, a plurality of user service intents can be mined and given at the same time, or after service data is not successfully acquired based on the previous user service intents, the service data can be parsed again, another user service intention is mined, and the service data is set according to requirements. However, in either way, the user cannot see the specific processing procedure, and the user can only see the feedback information of the dialog box, so that the page is more concise and comfortable for the user.
From the above, the present application may analyze the user service requirement through the relevance between the data, that is, the data operation logic, to obtain a plurality of user intents, which is a mining process. This arrangement can help the user to obtain derived data, i.e. target data as mentioned below, associated with the basic service data, i.e. in the presence of said data manipulation logic, in case only basic service data is present in the database. For example, the user needs to obtain the total annual sales for four years, but only the monthly sales for each month for the four years are in the database, and the total annual sales can be obtained by summing the monthly sales for each year.
In addition, the method and the device have the advantages that the technical means that data are matched based on keywords only by extracting the keywords in the past, and then the chart is generated is abandoned, a keyword library containing a large number of keywords is not required to be arranged, the method and the device can be widely applied to multiple enterprises and multiple types of data, and customization for enterprise data is not required. By mining the user business requirements, at least one user business intention is obtained, the method can be used when the requirements change, a target chart can be generated without waiting for a programmer to redeploy codes, the development cost of developers is reduced, the flexibility is higher, and the user requirements can be responded quickly.
And step 102, converting the user business intention into a business execution statement based on code conversion processing.
Specifically, after the target generation type artificial intelligence model analyzes the user service intention, the user service intention can be converted into a service execution statement through code conversion processing, namely, the user service intention is written into a code program which can be executed, namely, the service execution statement, namely, the user service intention is converted into a language which can be understood and executed by a machine.
In particular, structured query language (Structured Query Language, SQL) is a database language with various functions such as data manipulation and data definition, and is commonly used for accessing databases, querying and retrieving data in databases, and visualizing data. The purpose of the present application is to generate charts, i.e. business data visualizations, so the present application prefers SQL for transcoding. Thus, the business execution statement is an SQL statement.
Specifically, the service execution statement includes a data query statement and a data processing statement, and the transcoding-based process converts the user service intention into a service execution statement, including: performing code conversion processing on the first data to be acquired and the first data processing logic to obtain a first data query statement and a first data processing statement; and performing code conversion processing on the second data to be acquired and the second data processing logic to obtain a second data query statement and a second data processing statement.
Specifically, the user service intention includes the data to be acquired and the data processing logic, and when the code conversion is performed, the data to be acquired and the data processing logic are converted into a data query statement and a data processing statement, and correspondingly, the data query statement and the data processing statement are also SQL statements. The data query statement is used for querying and acquiring service data in the database, and the data processing statement is used for processing the acquired data to obtain the target chart.
Specifically, if there are a plurality of user service intents, transcoding is performed on all the plurality of user service intents. And performing code conversion processing on the first data to be acquired and the first data processing logic to obtain the first data query statement and the first data processing statement. And performing code conversion processing on the second data to be acquired and the second data processing logic to obtain the second data query statement and the second data processing statement. Wherein the first data query statement and the first data processing statement, and the second data query statement and the second data processing statement are also SQL statements.
And step 103, executing the business execution statement to generate a target chart.
Specifically, after the service execution statement is generated by conversion, the target chart, that is, the chart generated according to the service requirement of the user can be obtained by executing the service execution statement.
Specifically, the executing the service execution statement generates a target chart, including: acquiring service data from a database based on the data query statement; and carrying out data processing on the business data according to the data processing statement to generate the target chart.
Specifically, firstly, performing data query in the database by executing the data query statement, acquiring the service data after the query to obtain the required service data, and then executing the data processing statement to perform data processing on the service data to generate the target chart.
Specifically, the acquiring service data from the database based on the data query statement includes: executing the first data query statement according to the acquisition priority, and acquiring first data from the database; and if the first data is not acquired, executing the second data query statement, and acquiring the second data from the database.
Specifically, the data to be acquired in the user service intention corresponds to an acquisition priority, the data query statement is obtained after the data to be acquired is converted, and for the data query statement, the acquisition priority is equivalent to an execution priority, that is, the higher the acquisition priority is, the earlier the data query statement is executed.
Specifically, the acquisition priority of the first data to be acquired is known to be higher than the acquisition priority of the second data to be acquired, so that the first data query statement is executed first according to the acquisition priority, and the first data is queried and acquired from the database. And if the first data is queried, acquiring the first data, wherein the service data needed in the user service requirement is acquired, so that the data query statement with lower acquisition priority than the first data query statement, such as the second data query statement, does not need to be executed.
However, if the first data is not found in the database, it is indicated that the first data does not exist in the database, and the first data cannot be obtained at this time. And then executing the second data query statement according to the acquisition priority, and acquiring the second data from the database.
Specifically, the execution of the data query statement is not stopped until the service data is queried and acquired. And if all the data query sentences are executed and the service data is not successfully acquired, sending data missing information to the user side.
Specifically, if the first data is acquired, executing the first data processing statement to generate the target chart. And if the second data is acquired, executing the second data processing statement to generate the target chart.
Specifically, the step of performing data processing on the service data according to the data processing statement to generate the target chart includes: performing data operation processing on the service data to obtain target data; and performing data rendering processing on the target data to obtain the target chart.
Specifically, the data processing statement includes a data operation process and/or a data rendering process. The data rendering process is a process of visualizing data.
In particular, the data operation process may be null information. If the data operation processing is not null information, the acquired service data is required to be subjected to data operation processing, wherein the service data is basic service data in the database, the target data is obtained after the processing, at this time, the target data is required data indicated by the user service requirement, and the target data is derivative data of the basic service data.
Specifically, the data rendering process may be relatively fuzzy and wide information, for example, if only the month sales of 2022 is shown in the form of a graph in the user business requirement of the user, the user does not specify what graph is adopted, and what the specific format of the graph is, and the object generation type artificial intelligence model determines a chart which is most suitable for the object data to process the business data through an insight algorithm within the selectable range of the data rendering process according to the characteristics of the object data. For example, an annual sales line graph of 2019-2022 can be drawn based on the target data, so that a user can intuitively see the change trend of sales.
In the embodiment of the application, the acquired user service requirements are analyzed to obtain the user service intention, then the user service intention is converted into a service execution statement through code conversion processing, and the target chart is generated through executing the service execution statement. In the process, a user only needs to execute one operation, namely input user service requirements, the user service requirements can be analyzed, namely deep mining is performed, the essential requirements of the user, namely user service intention, front and rear end codes are not required to be written for data, a target chart can be generated according to the user service intention, chart generation time is shortened, the generated target chart is more suitable for actual use requirements of the user, and the generation method is more flexible.
Referring to fig. 2, fig. 2 is a flowchart second of a chart generating method according to an embodiment of the present application. As shown in fig. 2, a chart generating method includes the steps of:
step 201, analyzing the user service requirement to obtain the user service intention.
The implementation process of this step is the same as that of step 101 in the foregoing embodiment, and will not be described here again.
Step 202, converting the user business intention into a business execution statement based on the transcoding process.
The implementation process of this step is the same as that of step 102 in the foregoing embodiment, and will not be described here again.
And 203, executing the business execution statement to generate a target chart.
The implementation process of this step is the same as that of step 103 in the foregoing embodiment, and will not be described here again.
And step 204, transmitting the target graph to a user side.
Specifically, after the target chart is generated, the target chart is presented to the user in a dialogue form, that is, the target chart is sent to the user side through a dialogue box. And a user of the user side can view the target chart.
Step 205, if the chart adjustment requirement sent by the user terminal is received, adjusting the target chart based on the chart adjustment requirement to obtain a target adjustment chart.
Specifically, if the user of the user terminal is not satisfied with the generated target chart, the chart adjustment requirement can be sent through the user terminal. For example, change bar graph to pie chart, mark the numbers greater than 20 ten thousand in the table red, change rows and columns in the table, remove the top adjustment, and add the month sales data of 2021, etc.
Specifically, after the chart adjustment requirement sent by the user side is received, the target chart is adjusted according to the chart adjustment requirement, and the target adjustment chart is obtained.
Specifically, the user may make multiple adjustments to the target chart until satisfied. The method and the device provide the chart adjusting function for the user, can directly adjust the target chart, are quick in response and save time.
In the embodiment of the application, after the target chart is generated, the target chart is sent to the user side, and the chart adjustment function is provided for the user side, namely, after the chart adjustment requirement of the user side is received, the target chart is adjusted according to the chart adjustment requirement, so that the flexibility is high, the target chart can be directly adjusted on the basis of the target chart, the response is quick, and the time is saved.
Referring to fig. 3, fig. 3 is a block diagram of a chart generating system provided in an embodiment of the present application, and for convenience of explanation, only a portion related to the embodiment of the present application is shown.
The chart generation system 300 includes: parsing module 301, converting module 302, generating module 303.
The parsing module 301 is configured to parse the user service requirement to obtain the user service intention.
The conversion module 302 is configured to convert the user service intention into a service execution statement based on a transcoding process.
And the generating module 303 is used for executing the business execution statement to generate a target chart.
The parsing module 301 is specifically configured to:
analyzing the user service requirement to obtain first data to be acquired and first data processing logic;
analyzing the first data to be acquired from a data category dimension to obtain second data to be acquired, wherein the second data to be acquired has data operation logic with the first data to be acquired; the acquisition priority of the first data to be acquired is higher than that of the second data to be acquired;
and combining the first data processing logic and the data operation logic to obtain second data processing logic.
The conversion module 302 is specifically configured to:
performing code conversion processing on the first data to be acquired and the first data processing logic to obtain a first data query statement and a first data processing statement;
and performing code conversion processing on the second data to be acquired and the second data processing logic to obtain a second data query statement and a second data processing statement.
The generating module 303 is specifically configured to:
acquiring service data from a database based on the data query statement;
and carrying out data processing on the business data according to the data processing statement to generate the target chart.
Executing the first data query statement according to the acquisition priority, and acquiring first data from the database;
and if the first data is not acquired, executing the second data query statement, and acquiring the second data from the database.
Performing data operation processing on the service data to obtain target data;
and performing data rendering processing on the target data to obtain the target chart.
Specifically, the chart generation system 300 further includes an adjustment module for:
the target graph is sent to a user side;
and if the chart adjustment requirement sent by the user side is received, adjusting the target chart based on the chart adjustment requirement to obtain a target adjustment chart.
The chart generation system provided in the embodiment of the present application can implement each process of the embodiment of the chart generation method, and can achieve the same technical effects, so that repetition is avoided, and no redundant description is provided herein.
Fig. 4 is a block diagram of a terminal according to an embodiment of the present application. As shown in the figure, the terminal 4 of this embodiment includes: at least one processor 40 (only one is shown in fig. 4), a memory 41 and a computer program 42 stored in the memory 41 and executable on the at least one processor 40, the processor 40 implementing the steps in any of the various method embodiments described above when executing the computer program 42.
The terminal 4 may be a computing device such as a desktop computer, a notebook computer, a palm computer, a cloud server, etc. The terminal 4 may include, but is not limited to, a processor 40, a memory 41. It will be appreciated by those skilled in the art that fig. 4 is merely an example of the terminal 4 and is not limiting of the terminal 4, and may include more or fewer components than shown, or may combine some components, or different components, e.g., the terminal may further include input and output devices, network access devices, buses, etc.
The processor 40 may be a central processing unit (Central Processing Unit, CPU), but may also be other general purpose processors, digital signal processors (Digital Signal Processor, DSP), application specific integrated circuits (Application Specific Integrated Circuit, ASIC), field programmable gate arrays (Field-Programmable Gate Array, FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, or the like. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
The memory 41 may be an internal storage unit of the terminal 4, such as a hard disk or a memory of the terminal 4. The memory 41 may also be an external storage device of the terminal 4, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card) or the like, which are provided on the terminal 4. Further, the memory 41 may also include both an internal storage unit and an external storage device of the terminal 4. The memory 41 is used for storing the computer program as well as other programs and data required by the terminal. The memory 41 may also be used for temporarily storing data that has been output or is to be output.
It will be apparent to those skilled in the art that, for convenience and brevity of description, only the above-described division of the functional units and modules is illustrated, and in practical application, the above-described functional distribution may be performed by different functional units and modules according to needs, i.e. the internal structure of the apparatus is divided into different functional units or modules to perform all or part of the above-described functions. The functional units and modules in the embodiment may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit, where the integrated units may be implemented in a form of hardware or a form of a software functional unit. In addition, specific names of the functional units and modules are only for convenience of distinguishing from each other, and are not used for limiting the protection scope of the present application. The specific working process of the units and modules in the above system may refer to the corresponding process in the foregoing method embodiment, which is not described herein again.
In the foregoing embodiments, the descriptions of the embodiments are emphasized, and in part, not described or illustrated in any particular embodiment, reference is made to the related descriptions of other embodiments.
Those of ordinary skill in the art will appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware, or combinations of computer software and electronic hardware. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present application.
In the embodiments provided in the present application, it should be understood that the disclosed apparatus/terminal and method may be implemented in other manners. For example, the apparatus/terminal embodiments described above are merely illustrative, e.g., the division of the modules or units is merely a logical function division, and there may be additional divisions when actually implemented, e.g., multiple units or components may be combined or integrated into another system, or some features may be omitted or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed may be an indirect coupling or communication connection via interfaces, devices or units, which may be in electrical, mechanical or other forms.
The units described as separate units may or may not be physically separate, and units shown as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
In addition, each functional unit in each embodiment of the present application may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.
The integrated modules/units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable storage medium. Based on such understanding, the present application may implement all or part of the flow of the method of the above embodiment, or may be implemented by a computer program to instruct related hardware, where the computer program may be stored in a computer readable storage medium, and when the computer program is executed by a processor, the computer program may implement the steps of each method embodiment described above. Wherein the computer program comprises computer program code which may be in source code form, object code form, executable file or some intermediate form etc. The computer readable medium may include: any entity or device capable of carrying the computer program code, a recording medium, a U disk, a removable hard disk, a magnetic disk, an optical disk, a computer Memory, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), an electrical carrier signal, a telecommunications signal, a software distribution medium, and so forth. It should be noted that the computer readable medium contains content that can be appropriately scaled according to the requirements of jurisdictions in which such content is subject to legislation and patent practice, such as in certain jurisdictions in which such content is subject to legislation and patent practice, the computer readable medium does not include electrical carrier signals and telecommunication signals.
The present application may implement all or part of the procedures in the methods of the above embodiments, and may also be implemented by a computer program product, which when run on a terminal causes the terminal to implement steps in the embodiments of the methods described above.
The above embodiments are only for illustrating the technical solution of the present application, and are not limiting; although the present application has been described in detail with reference to the foregoing embodiments, it should be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present application, and are intended to be included in the scope of the present application.

Claims (10)

1. A graph generation method, characterized by comprising:
analyzing the user service requirement to obtain the user service intention;
converting the user business intention into a business execution statement based on code conversion processing;
and executing the business execution statement to generate a target chart.
2. The method of claim 1, wherein the user service intention comprises data to be acquired and data processing logic, the parsing the user service requirement to obtain the user service intention comprises:
analyzing the user service requirement to obtain first data to be acquired and first data processing logic;
analyzing the first data to be acquired from a data category dimension to obtain second data to be acquired, wherein the second data to be acquired has data operation logic with the first data to be acquired; the acquisition priority of the first data to be acquired is higher than that of the second data to be acquired;
and combining the first data processing logic and the data operation logic to obtain second data processing logic.
3. The method of claim 2, wherein the business execution statement comprises a data query statement and a data processing statement, the transcoding process based converting the user business intent into a business execution statement comprising:
performing code conversion processing on the first data to be acquired and the first data processing logic to obtain a first data query statement and a first data processing statement;
and performing code conversion processing on the second data to be acquired and the second data processing logic to obtain a second data query statement and a second data processing statement.
4. The method of claim 3, wherein the executing the business execution statement to generate a target graph comprises:
acquiring service data from a database based on the data query statement;
and carrying out data processing on the business data according to the data processing statement to generate the target chart.
5. The method of claim 4, wherein the obtaining business data from a database based on the data query statement comprises:
executing the first data query statement according to the acquisition priority, and acquiring first data from the database;
and if the first data is not acquired, executing the second data query statement, and acquiring the second data from the database.
6. The method of claim 4, wherein said data processing said business data in accordance with said data processing statement to generate said target graph comprises:
performing data operation processing on the service data to obtain target data;
and performing data rendering processing on the target data to obtain the target chart.
7. The method of claim 1, wherein the executing the business execution statement, after generating a target graph, further comprises:
the target graph is sent to a user side;
and if the chart adjustment requirement sent by the user side is received, adjusting the target chart based on the chart adjustment requirement to obtain a target adjustment chart.
8. A chart generation system, comprising:
the analysis module is used for analyzing the user service requirements to obtain user service intentions;
the conversion module is used for converting the user business intention into a business execution statement based on code conversion processing;
and the generating module is used for executing the business execution statement and generating a target chart.
9. A terminal comprising a memory, a processor and a computer program stored in the memory and executable on the processor, characterized in that the processor implements the steps of the method according to any of claims 1 to 7 when the computer program is executed.
10. A computer readable storage medium storing a computer program, characterized in that the computer program when executed by a processor implements the steps of the method according to any one of claims 1 to 7.
CN202311719597.0A 2023-12-14 2023-12-14 Chart generation method, system, terminal and readable storage medium Pending CN117892704A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202311719597.0A CN117892704A (en) 2023-12-14 2023-12-14 Chart generation method, system, terminal and readable storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202311719597.0A CN117892704A (en) 2023-12-14 2023-12-14 Chart generation method, system, terminal and readable storage medium

Publications (1)

Publication Number Publication Date
CN117892704A true CN117892704A (en) 2024-04-16

Family

ID=90641686

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202311719597.0A Pending CN117892704A (en) 2023-12-14 2023-12-14 Chart generation method, system, terminal and readable storage medium

Country Status (1)

Country Link
CN (1) CN117892704A (en)

Similar Documents

Publication Publication Date Title
US10558688B1 (en) Natural language interface for data analysis
KR100969447B1 (en) Rendering tables with natural language commands
CA2684822C (en) Data transformation based on a technical design document
WO2021017735A1 (en) Smart contract formal verification method, electronic apparatus and storage medium
Chen et al. Mining user requirements to facilitate mobile app quality upgrades with big data
US20100121883A1 (en) Reporting language filtering and mapping to dimensional concepts
US10108698B2 (en) Common data repository for improving transactional efficiencies of user interactions with a computing device
US20220083949A1 (en) Method and apparatus for pushing information, device and storage medium
CN108829884B (en) Data mapping method and device
CN112597182A (en) Data query statement optimization method and device, terminal and storage medium
CN111708805A (en) Data query method and device, electronic equipment and storage medium
US11928433B2 (en) Systems and methods for term prevalence-volume based relevance
US8260772B2 (en) Apparatus and method for displaying documents relevant to the content of a website
WO2020149959A1 (en) Conversion of natural language query
CN110837545A (en) Interactive data analysis method, device, medium and electronic equipment
US8271493B2 (en) Extensible mechanism for grouping search results
CN110704635B (en) Method and device for converting triplet data in knowledge graph
CN117892704A (en) Chart generation method, system, terminal and readable storage medium
CN114661747A (en) Index calculation method and device, storage medium and computer equipment
CN113157964A (en) Method and device for searching data set through voice and electronic equipment
CN113687827A (en) Data list generation method, device and equipment based on widget and storage medium
CN114391151A (en) Enhanced natural language generation platform
US20240104297A1 (en) Analysis of spreadsheet table in response to user input
CN116339733B (en) Application page generation method, system, electronic device and medium
CN116737278B (en) Method and device for generating system operation package, computer equipment and storage medium

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