CN110147441B - Data integration display method and device, terminal equipment and medium - Google Patents
Data integration display method and device, terminal equipment and medium Download PDFInfo
- Publication number
- CN110147441B CN110147441B CN201910264908.6A CN201910264908A CN110147441B CN 110147441 B CN110147441 B CN 110147441B CN 201910264908 A CN201910264908 A CN 201910264908A CN 110147441 B CN110147441 B CN 110147441B
- Authority
- CN
- China
- Prior art keywords
- data
- value
- sub
- server
- time value
- 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.)
- Active
Links
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
- G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions
- G06F17/10—Complex mathematical operations
- G06F17/18—Complex mathematical operations for evaluating statistical data, e.g. average values, frequency distributions, probability functions, regression analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/20—Natural language analysis
- G06F40/279—Recognition of textual entities
- G06F40/289—Phrasal analysis, e.g. finite state techniques or chunking
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06T—IMAGE DATA PROCESSING OR GENERATION, IN GENERAL
- G06T11/00—2D [Two Dimensional] image generation
- G06T11/20—Drawing from basic elements, e.g. lines or circles
- G06T11/206—Drawing of charts or graphs
Abstract
The invention is suitable for the technical field of big data, and provides a method, a device, terminal equipment and a medium for integrating and displaying data, wherein a drawing instruction is used for calling first-class data from a sub server and calling second-class data from a main server; taking the sum of the first type data recorded before each time value as the corresponding total value of the first type data; fitting a regression equation according to the corresponding relation between the first type data total value and the time value; drawing a curve of the regression equation and a broken line representing the corresponding relation between the time value and the second type of data on a coordinate plane to generate an integrated image, calculating a data difference value corresponding to each time value according to the curve and the broken line, and taking the time value corresponding to the data difference value smaller than a preset difference threshold value as a selected time value; and when the current moment is the selected moment value, amplifying and displaying the local integrated image corresponding to the moment value after the current moment so as to intuitively and clearly display the relationship and the trend of various data.
Description
Technical Field
The invention belongs to the technical field of big data, and particularly relates to a data integration display method, a data integration display device, terminal equipment and a medium.
Background
Companies often generate bad accounts during operations due to customers failing to pay in time, in which case an induced collection procedure needs to be initiated to collect back the accounts payable by the customers. In order to better achieve the goal of hastening receipts, many companies use a hastening management system to monitor and remind the hastening process. However, some large companies often have a plurality of sub-companies, and each sub-company may perform the collection urging respectively, and when a certain sub-company has a debt to be paid, the sub-company will enter the corresponding collection urging amount into the corresponding sub-server. Therefore, the amount of the induced charge related to the induced charge process is dynamically recorded by different distributed sub-servers.
However, the existing collection urging management system is difficult to effectively and quickly integrate the data recorded by the distributed sub-servers, and the collection urging management system cannot systematically and comprehensively analyze the data due to the fact that the storage of the relevant collection urging data is messy and the data volume is huge; meanwhile, the whole receiving process cannot be intuitively displayed and predicted. Obviously, the current collection management system has the technical problems of data integration failure, data presentation non-intuitionistic and the like. These technical problems directly affect the revenue collection efficiency of the company.
Disclosure of Invention
In view of this, embodiments of the present invention provide a data integration display method and a terminal device, so as to solve the problems of insufficient data integration and non-intuitive data presentation in the current collection management system.
A first aspect of an embodiment of the present invention provides an integrated data display method, including:
according to a drawing instruction input by a user, calling a plurality of pieces of first-class data from more than one sub-server, and calling a plurality of pieces of second-class data from a main server, wherein each piece of first-class data and each piece of second-class data correspond to a time value, and the time value represents the time when the data are input; sequencing the first type data according to the sequence of the corresponding time values from front to back, and taking the sum of the first type data recorded before each time value as the corresponding total value of the first type data to generate the corresponding relation between the total value of the first type data and the time value; fitting a regression equation representing the development trend of the first type data total value according to the corresponding relation between the first type data total value and the time value; drawing a curve of the regression equation and a broken line representing the corresponding relation between the time value and the second type data on the same coordinate plane to generate an integrated image, wherein the abscissa of the coordinate plane is the time value; calculating a first class data estimation value and a second class data estimation value corresponding to each time value according to the curve and the broken line, taking a difference value of the first class data estimation value and the second class data estimation value corresponding to each time value as a data difference value corresponding to each time value, and taking a time value corresponding to a data difference value smaller than a preset difference value threshold value as a selected time value; and when the current time is not the selected time value, displaying the whole integrated image, and when the current time is the selected time value, only displaying and enlarging the local integrated image corresponding to the time value after the current time.
A second aspect of an embodiment of the present invention provides an integrated display device for data, including:
the system comprises a calling module, a receiving module and a sending module, wherein the calling module is used for calling a plurality of pieces of first-class data from more than one sub-server and a plurality of pieces of second-class data from a main server according to a drawing instruction input by a user, each piece of first-class data and each piece of second-class data correspond to a time value, and the time value represents the time when the data is input; the sorting module is used for sorting the first-class data according to the sequence of the corresponding time values from front to back, taking the sum of the first-class data recorded before each time value as the corresponding first-class data total value, and generating the corresponding relation between the first-class data total value and the time value; the fitting module is used for fitting a regression equation representing the development trend of the first type of data total value according to the corresponding relation between the first type of data total value and the time value; the drawing module is used for drawing a curve of the regression equation and a broken line representing the corresponding relation between the time value and the second type of data on the same coordinate plane to generate an integrated image, and the abscissa of the coordinate plane is the time value; the estimation module is used for calculating a first class data estimation value and a second class data estimation value corresponding to each time value according to the curve and the broken line, taking the difference value of the first class data estimation value and the second class data estimation value corresponding to each time value as a data difference value corresponding to each time value, and taking the time value corresponding to the data difference value smaller than a preset difference value threshold value as a selected time value; and the display module is used for displaying the whole of the integrated image when the current moment is not the selected moment value, and only displaying and amplifying and displaying the local integrated image corresponding to the moment value after the current moment when the current moment is the selected moment value. A third aspect of an embodiment of the present invention provides a terminal device, including: memory, a processor and a computer program stored in the memory and executable on the processor, characterized in that the steps of the method provided by the first aspect of an embodiment of the present invention are implemented when the computer program is executed by the processor.
A fourth aspect of the embodiments of the present invention provides a computer-readable storage medium, which stores a computer program, characterized in that, when the computer program is executed by a processor, the steps of the method provided by the first aspect of the embodiments of the present invention are implemented.
In the embodiment of the invention, a drawing instruction input by a user is analyzed, a sub-server with higher relevance is selected and a first class of data is called from the sub-server, so that the data in the distributed sub-servers is collected, a plurality of pieces of second class of data are called in a main server, wherein each piece of data corresponds to a time value, the first class of data is sequenced according to the sequence of the corresponding time values from front to back, the sum of the first class of data recorded before the time value is taken as a first class of data total value corresponding to the time value, the corresponding relation between the first class of data total value and the time value is generated, so that the called data is integrated, a regression equation representing the development trend of the first class of data total value is fitted according to the corresponding relation between the first class of data total value and the time value, a curve of the regression equation and a broken line representing the corresponding relation between the time value and the second class of data are drawn on the same coordinate plane, generating an integrated image, wherein the abscissa of the coordinate plane is the time value; calculating a first class data estimation value and a second class data estimation value corresponding to each time value according to the curve and the broken line, taking a difference value of the first class data estimation value and the second class data estimation value corresponding to each time value as a data difference value corresponding to each time value, and taking a time value corresponding to a data difference value smaller than a preset difference value threshold value as a selected time value; when the current moment is not the selected moment value, displaying the whole situation of the integrated image, and when the current moment is the selected moment value, only displaying and amplifying the local integrated image corresponding to the moment value after the current moment so as to quickly integrate the data stored in a distributed manner, and visually displaying the relation and development trend with various data through data development prediction and centralized drawing.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed to be used in the embodiments or the prior art descriptions will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without inventive exercise.
Fig. 1 is a flowchart of an implementation of a method for displaying data in an integrated manner according to an embodiment of the present invention;
fig. 2 is a flowchart illustrating a specific implementation of the data integration display method S101 according to an embodiment of the present invention;
fig. 3 is a flowchart illustrating an implementation of the data integration display method S103 according to an embodiment of the present invention;
FIG. 4 is a block diagram of an integrated display device for data according to an embodiment of the present invention;
fig. 5 is a schematic diagram of a terminal device according to an embodiment of the present invention.
Detailed Description
In the following description, for purposes of explanation and not limitation, specific details are set forth, such as particular system structures, techniques, etc. in order to provide a thorough understanding of the embodiments of the invention. It will be apparent, however, to one skilled in the art that the present invention 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 invention with unnecessary detail.
In order to explain the technical means of the present invention, the following description will be given by way of specific examples.
Fig. 1 shows an implementation process of the data integration display method provided by the embodiment of the present invention, where the method process includes steps S101 to S106. The specific implementation principle of each step is as follows.
S101: according to a drawing instruction input by a user, a plurality of pieces of first-class data are called from more than one sub-server, and a plurality of pieces of second-class data are called from a main server, wherein each piece of first-class data and each piece of second-class data correspond to a time value, and the time value represents the time when data are recorded.
In the embodiment of the invention, the existing data management system, particularly the collection data management system, is mainly improved. The collection-urging data management system mainly needs to process two types of data, wherein one type of data is accounts to be collected in a certain project, namely the sum of arrears of different customers aiming at the certain project; another type of data is the payoff amount of the customer for a certain item. In real life, customers pay for a certain project for a plurality of times, the collection data system records a payment amount each time the customers pay for the payment, and the money transfer of a project implemented by a company is generally fixed, so the sum of the arrearages is not changed in general, but the sum of the arrearages can be changed with low frequency because the money transfer of a project can be added or deleted in some cases.
By combining the above descriptions, the collection system may record new payment amount in real time, so the total sum of the payment amount is updated more frequently, and the update frequency of the debt total sum is lower and may even be kept constant. In the embodiment of the invention, the payment amount corresponding to a certain item is taken as the first type of data, and the total arrearage amount corresponding to the certain item is taken as the second type of data.
In an embodiment of the present invention, a collection system includes a main server and a plurality of distributed sub-servers, wherein the main server is generally disposed in a main company and used for calling and performing overall analysis on various types of data, and the distributed sub-servers are disposed in branch companies in various regions. Because the payment amount can be received by each branch company, the data volume is large, and the data updating frequency is also large, each sub-server stores the first type of data recorded by the sub-server at ordinary times, and the first type of data is not uniformly stored by the main server; on the contrary, the sum of arrears is approved by the head office, and the updating frequency and the data volume are small, so the second type data is stored by the main server.
In the embodiment of the invention, no matter the first type of data or the second type of data has a data entry moment, in order to draw and predict various types of data in subsequent steps, the main server or the sub-server records the data entry moment, so that the first type of data and the second type of data both correspond to a moment value.
It should be noted that, in the embodiment of the present invention, the main server is used as an execution main body, and the integrated display method of the data is executed in the main server.
Notably, different sub-servers may store first type data corresponding to different projects, and because the projects docked by each branch are not necessarily identical, and it is not possible for a branch to dock all projects, it is not possible for each sub-server to contain first type data corresponding to all projects. Therefore, after the main server receives the drawing instruction, if the instruction for calling data is directly sent to all the sub-servers according to the drawing instruction, unnecessary CPU load is inevitably brought to some sub-servers, and the whole time for integrating and displaying is wasted. Therefore, in the embodiment of the present invention, it is necessary to filter out the relevant sub-servers according to the drawing instruction, and retrieve the first type data from the relevant sub-servers.
As an embodiment of the present invention, as shown in fig. 2, the S101 includes:
and S1011, extracting the data name contained in the drawing instruction as a target name, and determining the correlation between each sub-server and the target name according to the preset description information corresponding to each sub-server.
As described above, in the embodiment of the present invention, it is considered that sending the instruction for calling data to all the sub-servers directly according to the drawing instruction inevitably brings unnecessary CPU load to some of the sub-servers, so that the drawing instruction needs to be analyzed, the sub-servers related to the drawing instruction are determined, and the first type of data is called from these sub-servers.
In the embodiment of the invention, when a user wants to know and intuitively perceive data of a certain item, a drawing instruction is input to the main server, the drawing instruction comprises a data name of the item, and the main server can extract the data name contained in the drawing instruction after receiving the drawing instruction.
In the embodiment of the present invention, the main server stores preset description information corresponding to each sub-server, where the preset description information is used to describe an item operated by a sub-company where the sub-server is located, that is, the preset description information is text data for introducing a business situation of each sub-company.
It can be understood that, by analyzing the correlation between the drawing instruction and the preset description information corresponding to each sub-server, the possibility that the first type of data corresponding to the target name is stored in each sub-server can be obtained. Specifically, for the collection prompting data, the target name is the name of a certain project, the first type of data is the payment amount which is prompted to be received by each subsidiary company, and the possibility that each subsidiary server enters the payment amount corresponding to the name of the project can be obtained by analyzing the correlation degree of the drawing instruction and the preset description information corresponding to each subsidiary server.
Optionally, in the embodiment of the present invention, by drawing the occurrence ratio of the data name in the instruction in the preset description information of each sub-server and the total number of words of the preset description information corresponding to the sub-server, the degree of correlation between each sub-server and the target name is obtained through analysis, and the specific steps are as follows:
the method comprises the following steps that firstly, word segmentation processing is carried out on preset description information corresponding to each sub-server, and a word set corresponding to each sub-server is generated.
It can be understood that, since the preset description information is a text, each word contained in the text can be obtained through word segmentation processing, so as to generate a word set. Because the preset description information corresponding to each sub-server is stored in the main server, the word set corresponding to each sub-server can be obtained after word segmentation processing.
Optionally, the preset description information may be participled through a jieba chinese participle package.
And step two, through a formula:
calculating a probability parameter of the sub-server, wherein the TarProiIs the probability parameter of the sub server i, the NumiTotalNum is the number of times of occurrence of the target name in the word set corresponding to the sub-server iiThe number of the sub servers containing the target name in the corresponding word set is the sum of the words contained in the word set corresponding to the sub server i, the ServerTotal is the sum of the number of the sub servers, and the ServerNum is the number of the sub servers containing the target name in the corresponding word set.
As can be appreciated, the first and second electrodes,
the target name is reflected by the appearance proportion of the target name in a word set, and in general, the higher the appearance proportion is, the higher the relevance between the target name and the sub-server corresponding to the word set is. However, the above-mentioned correlation is not completely accurate, and there may be a certain error, which is caused by: TotalNum if the total number of words in the word set corresponding to one sub-server is very smalliVery small, there is a possibility of only a very small NumiGet bigger
It is clear that, in this case,
the chance of (2) is great. Therefore, the embodiments of the present invention need to be
Multiplied by a parameter to eliminate certain contingencies. This parameter is
It can be understood that, for the logarithmic function, when the base number is a natural constant e, when the abscissa is greater than 1, the variation curve of the logarithmic function is relatively gentle, and the ordinate monotonically increases as the abscissa increases. Therefore, if the word quantity of the word set of one sub-server is larger, the corresponding word set is corresponding to the word set
Will be larger and the word amount of the word set of one sub-server is smallerThen it corresponds to
Will be smaller. Obviously by multiplication
This parameter will eliminate a part of the contingency caused by less word data in the word set, so that the finally calculated TarProiAnd the correlation of the target name and each sub-server is reflected more accurately.
And thirdly, determining the correlation corresponding to the probability parameter of the sub-server according to the corresponding relation between the interval of the preset probability parameter and the correlation, and taking the correlation as the correlation between the sub-server and the target name.
And S1012, taking the sub-server with the correlation degree with the target name higher than a preset correlation degree threshold value as a target server.
In the embodiment of the invention, since the probability that the sub-servers with the relevance to the target name not higher than the preset relevance threshold store the first type of data is 0 or very low, the sub-servers are not taken as the target servers for subsequent data calling.
Specifically, for the payment acceleration data, the subsidiary company of the subsidiary server whose degree of correlation with the target name is not higher than the preset threshold value of degree of correlation performs the payment acceleration work of the item corresponding to the target name with a very small probability, so that the probability of inputting the payment amount is very small, the influence on the total payment acceleration process is very small, and even if the payment amount exists, the numerical value of one payment amount is very small, and the influence on the payment process is very small. The embodiment of the invention aims to visually display the development trend of the data after the data of the distributed sub-servers are integrated, so that payment amount with extremely low occurrence probability can be ignored, and the embodiment of the invention only needs to take the sub-servers with the correlation degree with the target name higher than the preset correlation degree threshold value as the target server, thereby reducing the waste of computing resources of each sub-server of the collection and management system.
And S1013, calling the first type data corresponding to the target name from the target server.
In the embodiment of the invention, after the target servers are determined, the main server determines the query sentences corresponding to the query instructions according to the preset corresponding relation, and calls the first type data corresponding to the target names stored in each target server according to the query sentences.
S102, sequencing the first type data according to the sequence of the corresponding time values from front to back, taking the sum of the first type data recorded before each time value as the corresponding total value of the first type data, and generating the corresponding relation between the total value of the first type data and the time value.
Optionally, the main server integrates the first type of data called from each sub-server through a MapReduce program, and stores the integrated first type of data into the Hive storage warehouse, where time values corresponding to the first type of data need to be stored together in the storage process.
In the embodiment of the invention, for better integrated calculation, the first type of data in the Hive storage warehouse needs to be sorted according to the sequence of the corresponding time values from front to back. And further, adding and summing the first type data recorded before a time value, and taking the summation result as the total value of the first type data corresponding to the time value. The first type data total value corresponding to each time value can be obtained by performing the calculation for each time.
Specifically, for the payment urging data, the total value of the first type data corresponding to each time value is the sum of the payment amount corresponding to the target name received before the time value.
It is understood that since the amount of claim is a gradual accumulation, the total value of the first type data may reflect the progress of claim at each moment.
S103, fitting a regression equation representing the development trend of the first type data total value according to the corresponding relation between the first type data total value and the time value.
In the embodiment of the present invention, in order to predict the development trend of the first-type total data value, a regression equation needs to be fitted according to the corresponding relationship between the first-type total data value and the time value. Therefore, obviously, the embodiment of the present invention is not limited to calling and drawing the first type of data recorded before the current time, and also predicts and draws the first type of data at a future time.
As an embodiment of the present invention, as shown in fig. 3, the S103 includes:
and S1031, obtaining a preset regression model, and establishing a target function corresponding to the regression model.
Optionally, the preset regression model includes:
the objective function includes: :
wherein w and b are parameters of the regression model, respectively, C is a preset normalization constant, ε is a preset loss sensitivity, and
the method comprises the steps of determining a value corresponding to a normalization value corresponding to the ith moment value from the front to the back according to a preset norm relation, wherein P is a preset sparsity, and x isiIs the value from the front to the ith moment.
As can be appreciated, the first and second electrodes,
the term is a structural risk term that is used to characterize the solution of the regression model,
the term is an empirical risk term and is used for describing the fit degree of the regression model and the first type data. As can be appreciated, the first and second electrodes,
and
and when one item is large, the other item is necessarily small. In addition, l (z) is a predetermined loss function, and ∈ is loss sensitivity, which determines the tolerance of the regression equation to signal values with large deviations.
As can be appreciated, in
In the method, the closer p is to 0, the more sparse the solution w is, i.e., the number of non-zero components is as small as possible, and the larger p is, the more balanced the solution w is, i.e., the number of non-zero components is dense.
Preferably, in the embodiment of the present invention, p is 2, so that the solution of the objective function is relatively balanced, and meanwhile, the calculation solution is relatively simple. And the loss sensitivity epsilon determines the tolerance degree of the regression equation to the point with larger deviation, if the signal value is smaller than epsilon or larger than-epsilon than the value of the corresponding moment of the regression equation, the point is considered as a normal point, and if not, the point is an abnormal point. The larger the difference between the two is, the larger the degree of harm of the abnormal point is considered to be, and the point can be automatically eliminated in the fitting process.
S1032, solving the parameters in the objective function, and calculating the parameters of the regression model based on the parameters in the objective function to fit the regression equation.
Optionally, firstly, an equation in a dual form of the objective function is constructed, and secondly, parameters in the objective function are obtained by solving the equation in the dual form of the objective function.
Optionally, a mathematical derivation is performed by using a laranger operator method, and an equation in a dual form corresponding to the regression model is constructed, specifically, the equation in the dual form is:
It will be appreciated that by solving the dual form of the equation, two parameters in the objective function can be derived, namely
And ai. And then according to the formula:
calculating two parameters b and w in the regression equation, and fitting the regression equation: f (x)i)＝wTφ(xi) + b, wherein, xiRepresenting the value of the ith moment from front to back, wherein w is a parameter vector of the regression model, b is an error coefficient, and f (x)i) Is a theoretical value corresponding to the ith moment value, epsilon is a preset loss sensitivity, YiThe data sum value of the first type corresponding to the ith time value.
In the embodiment of the invention, considering that there may be a very large first-class data entry suddenly at a certain time value, the total value of the first-class data corresponding to the next time value is significantly increased, because in the method, the preset condition is set
Therefore, the regression equation fitted by the method can greatly avoid the influence on the regression equation caused by the obvious increase of the total value of the first type data at a certain moment.
And S104, drawing a curve of the regression equation and a broken line representing the corresponding relation between the time value and the second type of data on the same coordinate plane to generate an integrated image, wherein the abscissa of the coordinate plane is the time value.
For example, assuming that the first type of data is the payment amount, the curve of the regression equation may reflect the total payment amount corresponding to each time before the current time, or may predict the total payment amount corresponding to each time after the current time. Assuming that the second type of data is the "debt total" mentioned above, it can be known from the above description that, since the number of the first type of data is large, the curve of the regression equation is used to predict and display the first type of data value calculated from the first type of data, and the number of the second type of data is very small, so that the calculation amount can be reduced as much as possible by displaying the second type of data in a line graph manner.
Understandably, the relationship between the two types of data can be visually displayed by drawing the two lines. Specifically, for the data collection, the collection progress can be well reflected by drawing the two lines.
Further, if an intersection point exists between the curve of the regression equation and the broken line, the time value corresponding to the intersection point is used as a target time value; and sending the target time value to all the sub servers.
It is understood that the time value corresponding to the intersection point of the curve of the regression equation and the broken line is the time value of the bad account return predicted by the main server. In the embodiment of the invention, the target time value is sent to each sub-server, which is helpful for reminding workers of each sub-server to supervise the money urging process.
And S105, calculating a first class data estimation value and a second class data estimation value corresponding to each time value according to the curve and the broken line, taking the difference value of the first class data estimation value and the second class data estimation value corresponding to each time value as a data difference value corresponding to each time value, and taking the time value corresponding to the data difference value smaller than a preset difference value threshold value as a selected time value.
It is understood that the first-class data estimation values corresponding to the respective time values can be calculated by using the respective time values as the independent variables of the regression equation, so that the first-class data estimation values corresponding to a time value after the current time (i.e., in the future) can be calculated and displayed through the curve of the regression equation.
Notably, in the embodiment of the present invention, the second type data has a low variation frequency and may even be kept constant, so that the second type data is plotted in a line graph manner. In addition, after the last time value corresponding to the second type of data called from the main server, no actual second type of data is available for drawing the polyline, but since the embodiment of the invention needs to predict the relative relationship between the first type of data value and the second type of data in a future period of time, the second type of data corresponding to the latest time value called is taken as the second type of data estimation value corresponding to the later time value when drawing the polyline.
Exemplarily, it is assumed that a total of 3 second-class data are called from the master server, which are respectively: the time value is as follows: second type data corresponding to 1 month and 1 day: 1000 ten thousand, time value: second type data corresponding to 1 month and 3 days: 1050 ten thousand, time value: second type data corresponding to 1 month and 10 days: 1060 ten thousand. In the polygonal line drawn by the embodiment of the present invention, the abscissa 1 month 1 day to 1 month 3 days corresponds to a straight line segment, the abscissa 1 month 3 day to 1 month 10 days corresponds to a straight line segment, and the second-class data estimation values corresponding to all the abscissas after 1 month 10 days on the abscissa are 1060 ten thousand.
In an embodiment of the present invention, the curves and the broken lines corresponding to the time intervals formed by the plurality of continuous selected time instant values may be very close.
And S106, when the current time is not the selected time value, displaying the whole integrated image, and when the current time is the selected time value, only displaying and amplifying and displaying the local integrated image corresponding to the time value after the current time.
It can be understood that when the difference between the total value of the first type of data (e.g., total amount of payment due to collection) and the second type of data (total amount of payment due to items) is large, the collection task can be completed for a long time, and the detail significance of the data is not large, so that the overall situation of the integrated image is displayed, and the user can know the overall progress of collection. However, when the difference between the two is small, it is proved that the hastelling process may be close to the end, and when the difference between the two is very small, the difference between the broken line and the curve may not be seen clearly under a large coordinate system, so that the details should be emphasized at this time, so that only a part of the integrated image corresponding to the time value after the current time is displayed on the screen, and since the screen area is unchanged and the integrated image to be displayed is only a part, this part is automatically enlarged, which is more beneficial for the user to view the details of the broken line and the curve and their intervals.
Obviously, the embodiment of the invention can automatically enlarge and reduce the two types of data according to the variation trend and the relative relationship of the two types of data, thereby being more beneficial to clearly observing the data by a user.
In the embodiment of the invention, by selecting the sub-server with higher relevance to the drawing instruction and calling the first type of data from the sub-server, calling a plurality of pieces of second-class data in the main server, wherein each piece of data corresponds to a time value, sequencing the first-class data according to the sequence of the corresponding time values from front to back, taking the sum of the first-class data recorded before the time value as a first-class data total value corresponding to the time value, generating a corresponding relation between the first-class data total value and the time value, fitting a regression equation according to the corresponding relation between the first-class data total value and the time value, drawing a curve of the regression equation and a broken line representing the corresponding relation between the time value and the second class data on the same coordinate plane, the method can quickly integrate the data stored in a distributed manner, and can visually display the relationship and development trend of various data by predicting and centrally drawing the development of the data.
Fig. 4 shows a block diagram of a data integration display device according to an embodiment of the present invention, which corresponds to the data integration display method described in the above embodiment, and only shows the relevant parts according to the embodiment of the present invention for convenience of description.
Referring to fig. 4, the apparatus includes:
a calling module 401, configured to, according to a drawing instruction input by a user, call multiple pieces of first-class data from more than one sub-server, and call multiple pieces of second-class data from a main server, where each piece of the first-class data and each piece of the second-class data correspond to a time value, and the time value indicates a time at which data is entered;
the sorting module 402 is configured to sort the first-class data according to a sequence from front to back of the corresponding time value, and use a sum of the first-class data recorded before each time value as a corresponding first-class data total value to generate a corresponding relationship between the first-class data total value and the time value;
a fitting module 403, configured to fit a regression equation representing a development trend of the first type data total value according to a corresponding relationship between the first type data total value and the time value;
a drawing module 404, configured to draw a curve of the regression equation and a polyline representing a correspondence between the time value and the second type of data on the same coordinate plane, and generate an integrated image, where an abscissa of the coordinate plane is the time value;
an estimation module 405, configured to calculate a first class data estimation value and a second class data estimation value corresponding to each time value according to the curve and the polygonal line, use a difference between the first class data estimation value and the second class data estimation value corresponding to each time value as a data difference value corresponding to each time value, and use a time value corresponding to a data difference value smaller than a preset difference threshold value as a selected time value;
a display module 406, configured to display the global of the integrated image when the current time is not the selected time value, and display and enlarge only the local integrated image corresponding to the time value after the current time when the current time is the selected time value.
Optionally, the invoking module includes:
the calculation submodule is used for extracting a data name contained in the drawing instruction as a target name, and determining the correlation degree between each sub-server and the target name according to preset description information corresponding to each sub-server;
the determining submodule is used for taking the sub-server with the correlation degree with the target name higher than a preset correlation degree threshold value as a target server;
and the data extraction submodule is used for calling the first type of data corresponding to the target name from the target server.
Optionally, the determining, according to preset description information corresponding to each of the sub-servers, a degree of correlation between each of the sub-servers and the target name includes:
performing word segmentation processing on preset description information corresponding to each sub-server to generate a word set corresponding to each sub-server;
by the formula:
calculating a probability parameter of the sub-server, wherein the TarProiIs the probability parameter of the sub server i, the NumiTotalNum is the number of times of occurrence of the target name in the word set corresponding to the sub-server iiThe number of the sub servers containing the target names in the corresponding word set is the total number of the sub servers;
and determining the correlation corresponding to the probability parameter of the sub-server according to the corresponding relation between the interval of the preset probability parameter and the correlation, and taking the correlation as the correlation between the sub-server and the target name.
Optionally, the fitting module is specifically configured to:
obtaining a preset regression model:
and establishing an objective function corresponding to the regression model:
wherein w and b are parameters of the regression model, respectively, C is a preset normalization constant, ε is a preset loss sensitivity, and
express according toDetermining a value corresponding to a first class data total value corresponding to the ith moment value from the front to the back according to a preset norm relation, wherein P is a preset sparsity, and x isiIs the ith time value from front to back, yiThe first type data total value is corresponding to the ith time value from the front to the back;
and solving parameters in the objective function, and calculating parameters of the regression model based on the parameters in the objective function to fit the regression equation.
Optionally, the apparatus further comprises:
the sending module is used for enabling the curve of the regression equation and the broken line to have an intersection point, and enabling a time value corresponding to the intersection point to serve as a target time value; and sending the target time value to all the sub servers.
In the embodiment of the invention, by selecting the sub-server with higher relevance to the drawing instruction and calling the first type of data from the sub-server, calling a plurality of pieces of second-class data in the main server, wherein each piece of data corresponds to a time value, sequencing the first-class data according to the sequence of the corresponding time values from front to back, taking the sum of the first-class data recorded before the time value as a first-class data total value corresponding to the time value, generating a corresponding relation between the first-class data total value and the time value, fitting a regression equation according to the corresponding relation between the first-class data total value and the time value, drawing a curve of the regression equation and a broken line representing the corresponding relation between the time value and the second class data on the same coordinate plane, the method can quickly integrate the data stored in a distributed manner, and can visually display the relationship and development trend of various data by predicting and centrally drawing the development of the data.
Fig. 5 is a schematic diagram of a terminal device according to an embodiment of the present invention. As shown in fig. 5, the terminal device 5 of this embodiment includes: a processor 50, a memory 51 and a computer program 52, such as an integrated display program of data, stored in said memory 51 and executable on said processor 50. The processor 50 executes the computer program 52 to implement the steps of the above-mentioned embodiments of the method for integrating and displaying various data, such as the steps 101 to 106 shown in fig. 1. Alternatively, the processor 50, when executing the computer program 52, implements the functions of the modules/units in the above-mentioned device embodiments, such as the functions of the units 401 to 406 shown in fig. 4.
Illustratively, the computer program 52 may be partitioned into one or more modules/units that are stored in the memory 51 and executed by the processor 50 to implement the present invention. The one or more modules/units may be a series of computer program instruction segments capable of performing specific functions, which are used to describe the execution process of the computer program 52 in the terminal device 5.
The terminal device 5 may be a desktop computer, a notebook, a palm computer, a cloud server, or other computing devices. The terminal device may include, but is not limited to, a processor 50, a memory 51. Those skilled in the art will appreciate that fig. 5 is merely an example of a terminal device 5 and does not constitute a limitation of terminal device 5 and may include more or fewer components than shown, or some components may be combined, or different components, e.g., the terminal device may also include input-output devices, network access devices, buses, etc.
The Processor 50 may be a Central Processing Unit (CPU), other general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), an off-the-shelf Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic, discrete hardware components, etc. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
The memory 51 may be an internal storage unit of the terminal device 5, such as a hard disk or a memory of the terminal device 5. The memory 51 may also be an external storage device of the terminal device 5, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), and the like, which are provided on the terminal device 5. Further, the memory 51 may also include both an internal storage unit and an external storage device of the terminal device 5. The memory 51 is used for storing the computer program and other programs and data required by the terminal device. The memory 51 may also be used to temporarily store 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-mentioned division of the functional units and modules is illustrated, and in practical applications, the above-mentioned function distribution may be performed by different functional units and modules according to needs, that is, the internal structure of the apparatus is divided into different functional units or modules to perform all or part of the above-mentioned functions. Each functional unit and module in the embodiments may be integrated in one processing unit, or each unit may exist alone physically, or two or more units are integrated in one unit, and the integrated unit may be implemented in a form of hardware, or in a form of 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 processes of the units and modules in the system may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the above embodiments, the descriptions of the respective embodiments have respective emphasis, and reference may be made to the related descriptions of other embodiments for parts that are not described or illustrated in a certain embodiment.
The units described as separate parts may or may not be physically separate, and parts displayed 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 can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
The integrated modules/units, if implemented in the form of software functional units and sold or used as separate products, may be stored in a computer readable storage medium. Based on such understanding, all or part of the flow of the method according to the above embodiments may be implemented by a computer program, which may be stored in a computer-readable storage medium, to instruct related hardware.
The above-mentioned embodiments are only used for illustrating the technical solutions of the present invention, and not for limiting the same; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; such modifications and substitutions do not substantially depart from the spirit and scope of the embodiments of the present invention, and are intended to be included within the scope of the present invention.
Claims (7)
1. A method for integrating and displaying data is characterized by comprising the following steps:
according to a drawing instruction input by a user, calling a plurality of pieces of first-class data from more than one sub-server, and calling a plurality of pieces of second-class data from a main server, wherein each piece of first-class data and each piece of second-class data correspond to a time value, and the time value represents the time when the data are input;
sequencing the first type data according to the sequence of the corresponding time values from front to back, and taking the sum of the first type data recorded before each time value as the corresponding total value of the first type data to generate the corresponding relation between the total value of the first type data and the time value;
fitting a regression equation representing the development trend of the first type data total value according to the corresponding relation between the first type data total value and the time value;
drawing a curve of the regression equation and a broken line representing the corresponding relation between the time value and the second type data on the same coordinate plane to generate an integrated image, wherein the abscissa of the coordinate plane is the time value;
calculating a first class data estimation value and a second class data estimation value corresponding to each time value according to the curve and the broken line, taking a difference value of the first class data estimation value and the second class data estimation value corresponding to the time value as a data difference value corresponding to the time value, and taking a time value corresponding to the data difference value smaller than a preset difference value threshold value as a selected time value;
when the current time is not the selected time value, displaying the whole of the integrated image, and when the current time is the selected time value, only displaying and amplifying and displaying the local integrated image corresponding to the time value after the current time;
the method for calling a plurality of pieces of first-class data from more than one sub-server according to the drawing instruction input by the user comprises the following steps:
extracting a data name contained in the drawing instruction as a target name, and determining the correlation degree between each sub-server and the target name according to preset description information corresponding to each sub-server;
taking the sub-server with the correlation degree with the target name higher than a preset correlation degree threshold value as a target server;
calling first type data corresponding to the target name from the target server;
the determining the relevancy between each sub-server and the target name according to the preset description information corresponding to each sub-server includes:
performing word segmentation processing on preset description information corresponding to each sub-server to generate a word set corresponding to each sub-server;
by the formula:
calculating a probability parameter of the sub-server, wherein the TarProiIs the probability parameter of the sub server i, the NumiTotalNum is the number of times of occurrence of the target name in the word set corresponding to the sub-server iiThe total number of words contained in the word set corresponding to the sub-server i, and the ServerTotal is the number of the sub-serversThe ServerNum is the number of sub servers containing the target name in the corresponding word set;
and determining the correlation corresponding to the probability parameter of the sub-server according to the corresponding relation between the interval of the preset probability parameter and the correlation, and taking the correlation as the correlation between the sub-server and the target name.
2. The method for integrally displaying data according to claim 1, wherein the fitting a regression equation representing the trend of the first type of the total data values according to the corresponding relationship between the first type of the total data values and the time values comprises:
obtaining a preset regression model:
and establishing an objective function corresponding to the regression model:
wherein w and b are parameters of the regression model, respectively, C is a preset normalization constant, ε is a preset loss sensitivity, and
the method comprises the steps of determining a value corresponding to a first class data total value corresponding to the ith moment value from the front to the back according to a preset norm relation, wherein P is a preset sparsity, and x isiIs the ith time value from front to back, yiThe first type data total value is corresponding to the ith time value from the front to the back;
and solving parameters in the objective function, and calculating parameters of the regression model based on the parameters in the objective function to fit the regression equation.
3. The method for integrally displaying data according to claim 1, wherein after the plotting the curves of the regression equation and the polyline representing the correspondence between the time-of-day values and the second type of data on the same coordinate plane, the method further comprises:
if an intersection point exists between the curve of the regression equation and the broken line, taking a time value corresponding to the intersection point as a target time value;
and sending the target time value to all the sub servers.
4. An apparatus for integrating and displaying data, the apparatus comprising:
the system comprises a calling module, a receiving module and a sending module, wherein the calling module is used for calling a plurality of pieces of first-class data from more than one sub-server and a plurality of pieces of second-class data from a main server according to a drawing instruction input by a user, each piece of first-class data and each piece of second-class data correspond to a time value, and the time value represents the time when the data is input;
the sorting module is used for sorting the first-class data according to the sequence of the corresponding time values from front to back, taking the sum of the first-class data recorded before each time value as the corresponding first-class data total value, and generating the corresponding relation between the first-class data total value and the time value;
the fitting module is used for fitting a regression equation representing the development trend of the first type of data total value according to the corresponding relation between the first type of data total value and the time value;
the drawing module is used for drawing a curve of the regression equation and a broken line representing the corresponding relation between the time value and the second type of data on the same coordinate plane to generate an integrated image, and the abscissa of the coordinate plane is the time value;
the estimation module is used for calculating a first class data estimation value and a second class data estimation value corresponding to each time value according to the curve and the broken line, taking the difference value of the first class data estimation value and the second class data estimation value corresponding to each time value as a data difference value corresponding to each time value, and taking the time value corresponding to the data difference value smaller than a preset difference value threshold value as a selected time value;
the display module is used for displaying the whole situation of the integrated image when the current moment is not the selected moment value, and only displaying and amplifying and displaying the local integrated image corresponding to the moment value after the current moment when the current moment is the selected moment value;
the calling module comprises:
the calculation submodule is used for extracting a data name contained in the drawing instruction as a target name, and determining the correlation degree between each sub-server and the target name according to preset description information corresponding to each sub-server; specifically, word segmentation processing is performed on preset description information corresponding to each sub-server, and a word set corresponding to each sub-server is generated; by the formula:
calculating a probability parameter of the sub-server, wherein the TarProiIs the probability parameter of the sub server i, the NumiTotalNum is the number of times of occurrence of the target name in the word set corresponding to the sub-server iiThe number of the sub servers containing the target names in the corresponding word set is the total number of the sub servers; determining the correlation corresponding to the probability parameter of the sub-server according to the corresponding relation between the interval of the preset probability parameter and the correlation, and taking the correlation as the correlation between the sub-server and the target name;
the determining submodule is used for taking the sub-server with the correlation degree with the target name higher than a preset correlation degree threshold value as a target server;
and the data extraction submodule is used for calling the first type of data corresponding to the target name from the target server.
5. The device for integrated display of data according to claim 4, wherein the fitting module is specifically configured to:
obtaining a preset regression model:
and establishing an objective function corresponding to the regression model:
wherein w and b are parameters of the regression model, respectively, C is a preset normalization constant, ε is a preset loss sensitivity, and
the method comprises the steps of determining a value corresponding to a first class data total value corresponding to the ith moment value from the front to the back according to a preset norm relation, wherein P is a preset sparsity, and x isiIs the ith time value from front to back, yiThe first type data total value is corresponding to the ith time value from the front to the back;
and solving parameters in the objective function, and calculating parameters of the regression model based on the parameters in the objective function to fit the regression equation.
6. A terminal device 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 3 when executing the computer program.
7. A computer-readable storage medium, in which a computer program is stored which, when being executed by a processor, carries out the steps of a method according to any one of claims 1 to 3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910264908.6A CN110147441B (en) | 2019-04-03 | 2019-04-03 | Data integration display method and device, terminal equipment and medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910264908.6A CN110147441B (en) | 2019-04-03 | 2019-04-03 | Data integration display method and device, terminal equipment and medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110147441A CN110147441A (en) | 2019-08-20 |
| CN110147441B true CN110147441B (en) | 2022-05-13 |
Family
ID=67589324
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910264908.6A Active CN110147441B (en) | 2019-04-03 | 2019-04-03 | Data integration display method and device, terminal equipment and medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110147441B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111145304B (en) * | 2019-12-27 | 2023-10-10 | 新奥数能科技有限公司 | Data processing method and device, intelligent terminal and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102479033A (en) * | 2010-11-26 | 2012-05-30 | 金蝶软件（中国）有限公司 | Chart browsing method, device and system |
| CN103500185A (en) * | 2013-09-13 | 2014-01-08 | 北京奇虎科技有限公司 | Data table generation method and system based on multi-platform data |
| CN106528774A (en) * | 2016-11-07 | 2017-03-22 | 国网浙江省电力公司衢州供电公司 | Method and apparatus for predicting distribution network project management trend |
| CN108961027A (en) * | 2018-07-05 | 2018-12-07 | 平安科技（深圳）有限公司 | Fund management method, device, computer equipment and computer readable storage medium |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10572848B2 (en) * | 2014-12-16 | 2020-02-25 | Oracle International Corporation | System and method for intelligent project schedule forecasting |
-
2019
- 2019-04-03 CN CN201910264908.6A patent/CN110147441B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102479033A (en) * | 2010-11-26 | 2012-05-30 | 金蝶软件（中国）有限公司 | Chart browsing method, device and system |
| CN103500185A (en) * | 2013-09-13 | 2014-01-08 | 北京奇虎科技有限公司 | Data table generation method and system based on multi-platform data |
| CN106528774A (en) * | 2016-11-07 | 2017-03-22 | 国网浙江省电力公司衢州供电公司 | Method and apparatus for predicting distribution network project management trend |
| CN108961027A (en) * | 2018-07-05 | 2018-12-07 | 平安科技（深圳）有限公司 | Fund management method, device, computer equipment and computer readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110147441A (en) | 2019-08-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109034988B (en) | Accounting entry generation method and device | |
| WO2015148159A1 (en) | Determining a temporary transaction limit | |
| CN109635029B (en) | Data processing method, device, equipment and medium based on label index system | |
| CN111427971B (en) | Business modeling method, device, system and medium for computer system | |
| CN113988065A (en) | Influence factor analysis method and device, storage medium and electronic equipment | |
| CN111062799A (en) | Method and device for managing family client, electronic equipment and storage medium | |
| CN113393306A (en) | Product recommendation method and device, electronic equipment and computer readable medium | |
| CN113034046A (en) | Data risk metering method and device, electronic equipment and storage medium | |
| CN110147441B (en) | Data integration display method and device, terminal equipment and medium | |
| CN113987086A (en) | Data processing method, data processing device, electronic device, and storage medium | |
| CN116485019A (en) | Data processing method and device | |
| CN110352405B (en) | Computer-readable medium, computing system, method, and electronic device | |
| WO2022267364A1 (en) | Information recommendation method and device, and storage medium | |
| CN110795638A (en) | Method and apparatus for outputting information | |
| CN113706223B (en) | Data processing method and device | |
| CN114881739A (en) | Order event processing method and device, electronic equipment and storage medium | |
| CN115048487A (en) | Artificial intelligence-based public opinion analysis method, device, computer equipment and medium | |
| CN115016735A (en) | Control method, device and medium for distributed cache system | |
| CN112115316B (en) | Box separation method and device, electronic equipment and storage medium | |
| CN111222739B (en) | Nuclear power station task allocation method and nuclear power station task allocation system | |
| CN113971007B (en) | Information processing method, device, electronic equipment and medium | |
| CN113609407B (en) | Regional consistency verification method and device | |
| CN116308770A (en) | Data information processing method, device, terminal and medium | |
| CN113516466A (en) | Request response method, request response device, electronic equipment and readable storage medium | |
| CN114625905A (en) | Human body characteristic information comparison method and device, electronic 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |