CN113569184A - Configurable data calculation method, device, equipment and computer readable medium - Google Patents
Configurable data calculation method, device, equipment and computer readable medium Download PDFInfo
- Publication number
- CN113569184A CN113569184A CN202110808046.6A CN202110808046A CN113569184A CN 113569184 A CN113569184 A CN 113569184A CN 202110808046 A CN202110808046 A CN 202110808046A CN 113569184 A CN113569184 A CN 113569184A
- Authority
- CN
- China
- Prior art keywords
- data
- calculation
- dimension
- graph
- result
- 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
Links
- 238000004364 calculation method Methods 0.000 title claims abstract description 248
- 238000000034 method Methods 0.000 claims abstract description 30
- 230000001419 dependent effect Effects 0.000 claims description 13
- 238000004590 computer program Methods 0.000 claims description 9
- 238000010586 diagram Methods 0.000 abstract description 4
- 238000012800 visualization Methods 0.000 abstract description 2
- 238000004891 communication Methods 0.000 description 7
- 230000003287 optical effect Effects 0.000 description 4
- 230000009286 beneficial effect Effects 0.000 description 2
- 238000001514 detection method Methods 0.000 description 2
- 238000011156 evaluation Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000010365 information processing Effects 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 238000012795 verification Methods 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 1
- 125000004122 cyclic group Chemical group 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 230000004044 response Effects 0.000 description 1
- 238000012502 risk assessment Methods 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
Images
Classifications
-
- 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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/26—Visual data mining; Browsing structured data
Abstract
The invention discloses a configurable data calculation method, a configurable data calculation device, configurable data calculation equipment and a computer readable medium, and belongs to the technical field of computers. The method comprises the following steps: receiving source data information and a data calculation formula configured by a user, and acquiring a data dimension relation; acquiring source data according to the source data information; generating a dimension relation graph according to the data dimension relation, and determining a calculation sequence; calculating the source data according to the calculation sequence by using the data calculation formula to obtain a calculation result; and associating the calculation result with the dimension relation graph, and displaying the calculation result in the dimension relation graph. According to the invention, the workload of program technicians is reduced through configured data calculation, the calculation dimension is expandable, and the visualization of data calculation is realized through the calculation result display of the dimension relation diagram.
Description
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a configurable data calculation method, apparatus, device, and computer readable medium.
Background
Enterprises need to be divided into different dimensions for data calculation in different business scenes, and data of each dimension may have a deduction and summarization relationship based on a specific business scene, for example, the calculation of expected cash flows in the insurance business field, most cash flows have a dependency relationship and can be summarized and calculated based on a certain dimension.
In the prior art, data calculation is generally performed by using preset empirical assumptions and business dimensions, and technicians realize a computer formula by using a computer program according to data and deduction logic, but in an actual application process, the method has the problems of large engineering quantity, inflexible calculation, and insufficient intuition of relationships among data of different dimensions and data calculation results.
Disclosure of Invention
In order to solve the problems in the prior art, embodiments of the present invention provide a configurable data calculation method, apparatus, and computer readable medium. The technical scheme is as follows:
in a first aspect, a configurable data computation method is provided, the method comprising:
receiving source data information and a data calculation formula configured by a user, and acquiring a data dimension relation;
acquiring source data according to the source data information;
generating a dimension relation graph according to the data dimension relation, and determining a calculation sequence;
calculating the source data according to the calculation sequence by using the data calculation formula to obtain a calculation result;
and associating the calculation result with the dimension relation graph, and displaying the calculation result in the dimension relation graph.
Further, the generating a dimension relation graph according to the data dimension relation and determining a calculation order of each data dimension includes:
generating a directed graph according to the data dimension relation;
and traversing the directed graph, judging whether an annular part exists in the directed graph or not, if so, generating first prompt information to remind a user of reconfiguring the data dimension relation, and if not, determining the calculation sequence of each data dimension.
Further, the calculating the source data according to the calculation order by using the data calculation formula to obtain a calculation result includes:
sequentially calculating the source data corresponding to each data dimension according to the calculation formula according to the calculation sequence to obtain a preliminary calculation result of each data dimension;
and summarizing the preliminary calculation results of the data dimensions according to the calculation sequence to obtain the calculation results.
Further, the method further comprises:
and caching the preliminary calculation results of the data dimensions so as to be directly called in the subsequent summary calculation.
Further, the obtaining the data dimension relationship includes:
reading any two data calculation formulas;
and if the dependent variable factor in one data calculation formula is the independent variable factor of the other data calculation formula, determining that the data dimension corresponding to the dependent variable factor and the data dimension corresponding to the independent variable factor have a dependency relationship.
Further, the associating the calculation result with the dimension relation graph, and displaying the calculation result in the dimension relation graph includes:
traversing the dimension relation graph, and determining the display position of the calculation result in the dimension relation graph according to the data dimension corresponding to the calculation result;
and displaying the calculation result on the display position.
Further, the method further comprises:
comparing the calculation result with a preset expected result;
and if the calculation result does not meet the expected result, generating second prompt information to remind a user to adjust any one or more items of the source data information, the data dimension relation and the data calculation formula.
In a second aspect, there is provided a configurable data computing device, the device comprising:
the configuration module is used for receiving source data information and a data calculation formula configured by a user and acquiring a data dimension relation;
the source data acquisition module is used for acquiring source data according to the source data information;
the graph module is used for generating a dimensional relation graph according to the data dimensional relation and determining a calculation sequence;
the calculation module is used for calculating the source data according to the calculation sequence by using the data calculation formula to obtain a calculation result;
and the display module is used for associating the calculation result with the dimension relation graph and displaying the calculation result in the dimension relation graph.
Further, a graph module, comprising:
and the graph generating module is used for generating a directed graph according to the data dimension relation.
And the graph detection module is used for traversing the directed graph, judging whether the annular part exists in the directed graph or not, if so, generating first prompt information to remind a user of reconfiguring the data dimension relation, and if not, determining the calculation sequence of each data dimension.
Further, a computing module comprising:
and the preliminary calculation module is used for sequentially calculating the source data corresponding to the data dimensions according to the calculation formula according to the calculation sequence to obtain a preliminary calculation result corresponding to each data dimension.
The summarizing module summarizes the preliminary calculation results of the data dimensions according to the calculation sequence to obtain the calculation results, and further the calculating module further comprises:
and the cache module is used for caching the preliminary calculation result so as to facilitate the direct call of the subsequent summary calculation.
Further, a configuration module comprising: and the data dimension relation acquisition module is used for reading the calculation formulas of any two data, and if the dependent variable factor in one data calculation formula is the independent variable factor in the other data calculation formula, determining that the data dimension corresponding to the dependent variable factor and the data dimension corresponding to the independent variable factor have a dependency relation.
Further, the configuration module further includes:
the data dimension relation acquisition module is used for reading any two data calculation formulas;
and if the dependent variable factor in one data calculation formula is the independent variable factor of the other data calculation formula, determining that the data dimension corresponding to the dependent variable factor and the data dimension corresponding to the independent variable factor have a dependency relationship.
Further, the display module is specifically configured to:
traversing the dimension relation graph, and determining the display position of the calculation result in the dimension relation graph according to the data dimension corresponding to the calculation result;
and displaying the calculation result on the display position.
Further, the device disclosed by the invention also comprises:
the result checking module is used for comparing the calculation result with a preset expected result;
and if the calculation result does not meet the expected result, generating second prompt information to remind a user to adjust any one or more items of the source data information, the data dimension relation and the data calculation formula.
In a third aspect, an electronic device is provided, including:
one or more processors; and
memory associated with the one or more processors for storing program instructions which, when read and executed by the one or more processors, perform the method of any of the first aspects.
In a fourth aspect, a computer-readable medium is provided, on which a computer program is stored, wherein the program, when executed by a processor, implements the method according to any of the first aspects.
The technical scheme provided by the embodiment of the invention has the following beneficial effects:
1. according to the technical scheme disclosed by the invention, the workload of program technicians is reduced through configured data calculation, the calculation dimension is expandable, and the visualization of data calculation is realized through the calculation result display of the dimension relation graph;
2. according to the technical scheme disclosed by the invention, through detecting the annular part in the dimension relation graph, the configuration of a user is ensured to be correct, and the problem that the result cannot be output by circular calculation is avoided;
3. according to the technical scheme disclosed by the invention, the dependency relationship among the data dimensions can be automatically identified, manual input is not required, and the user operation is simplified;
4. according to the technical scheme disclosed by the invention, the configuration can be adjusted according to the comparison between the calculation result and the expected result, so that the adjustability of data calculation is realized.
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 description of the embodiments will be briefly introduced 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 creative efforts.
FIG. 1 is a flow chart of a configurable data computation method provided by an embodiment of the invention;
FIG. 2 is a graphical illustration of dimensional relationships provided by an embodiment of the invention;
FIG. 3 is a schematic view of a dimensional relationship including a ring portion provided by an embodiment of the present invention;
FIG. 4 is a schematic structural diagram of a configurable data computing device according to an embodiment of the present invention;
FIG. 5 is a flowchart of a cash flow calculation scenario based on insurance services provided by an embodiment of the present invention;
fig. 6 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
In the field such as insurance business, cash flows of different dimensions need to be calculated, and then summary is performed according to the dependency relationship among the data dimensions, where the dependency relationship mainly refers to the association relationship among the data dimensions, and the association relationship is generally embodied in a calculation formula corresponding to each data dimension, for example: the formula for the pending claims cash flow is: the pending cash flow is the expected payout amount x the payout proportion empirical data, and the calculation formula of the risk adjustment cash flow is as follows: the risk adjustment cash flow is the pending claims cash flow x risk factor, and the risk adjustment cash flow depends on the pending claims cash flow from the dependency relationship. In the prior art, for the calculation of data dimensions with dependency relationships, direct calculation is usually performed based on a calculation program containing data calculation logic and deduction logic written by a programmer, however, this way causes the problems of large workload of the programmer, flexible calculation, inconvenience in user verification, and non-intuitive calculation result display.
In order to solve the technical problems, the application provides a configurable data calculation scheme, which can generate calculation logic through autonomous configuration of a user to perform direct calculation, and avoids large-scale code compiling of programmers. And a dimension relation graph is generated based on the data dimension relation, and the calculation result of each data dimension is displayed on the dimension relation graph, so that the calculation result is visually displayed, and a user can conveniently and clearly view the coming and going pulse of data calculation. In addition, before calculation, the dimension relation graph is used for carrying out automatic configuration and verification on the data calculation formula and the dimension relation graph, so that cyclic calculation is prevented, and the accuracy and efficiency of data calculation are improved.
The specific technical scheme of the invention is as follows:
as shown in fig. 1, a configurable data computation method includes:
and S1, receiving source data information and a data calculation formula configured by a user, and acquiring a data dimension relation.
The source data information includes: the data type, the table name of the data table, or the file name of the system file, and further, the row ID of the data may be included to obtain the source data in batch. Data calculation formulas generally correspond to data dimensions, with one data dimension corresponding to at least one data calculation formula. Data dimensions primarily refer to the name of the data, for example: the risk adjusted cash flow is 2000, where 2000 is data and the risk adjusted cash flow is the data dimension. The data dimension relationship mainly refers to the dependency relationship existing between different data dimensions in data calculation, or may also be an association relationship between different data dimensions, and such an association relationship may be on a business level or a personnel level, etc.
In one embodiment, obtaining the data dimensional relationship may also be in a manner of receiving a user configured data dimensional relationship.
In another embodiment, when there are two data calculation formulas and there is an association relationship, that is, the data dimension relationship refers to a dependency relationship between data of different data dimensions, acquiring the data dimension relationship includes:
reading any two data calculation formulas;
and if the dependent variable factor in one data calculation formula is the independent variable factor in the other data calculation formula, determining that the data dimension corresponding to the dependent variable factor and the data dimension corresponding to the independent variable factor have a dependency relationship.
With respect to the dependency of the risk adjusted cash flow and the pending claims cash flow as described above, the calculation of the risk adjusted cash flow requires the pending claims cash flow as an argument and thus the risk adjusted cash flow depends on the pending claims cash flow.
And S2, acquiring the source data according to the source data information.
The obtaining of the source data may specifically be searching for a corresponding data table and a corresponding data row according to the data type, the data table name, and the row ID in the source data information, and extracting data corresponding to the data type from the data row. The source data information can also comprise data acquisition frequency so as to acquire the source data in batches and relieve the data transmission pressure.
And S3, generating a dimension relation graph according to the data dimension relation, and determining the calculation sequence.
The dimension relation graph is mainly a directed graph, nodes in the graph represent different data dimensions, each node in the graph represents one data dimension or a calculation result, and the relation between the data dimensions is represented by directed line segments. The calculation order may include a calculation order for each data dimension and a data summarization order. As shown in fig. 2, the calculation order shown in the figure is the unreported amount that has occurred, the reported amount that has occurred, the cash flow for payment, the risk adjusted cash flow, and the aggregate cash flow for payment, in that order. Directed line segments between the data dimensions and the calculation results represent the calculation order of the data dimensions.
In one embodiment, step S3 specifically includes:
generating a directed graph according to the data dimension relation;
and traversing the directed graph, judging whether the directed graph has a ring part, if so, generating first prompt information to remind a user of reconfiguring the data dimension relation, and if not, determining the calculation sequence of each data dimension.
As described above, in the directed graph generated according to the data dimension relationship, there may be a ring-shaped portion, such as a dotted line portion in fig. 3, which may cause a problem of circular calculation in subsequent calculation, so that a calculation result cannot be obtained.
And S4, calculating the source data according to the calculation sequence by using a data calculation formula to obtain a calculation result.
In the data calculation formula, besides the dependent variable factor and the independent variable factor, a coefficient or a constant exists, the coefficient and the constant are both configured in advance by a user, and the specific value is determined according to business experience.
The calculation order of the data dimensions may include an order of calculating the data dimensions individually, and the calculation is completed after the calculation result corresponding to each data dimension is obtained, for example, as shown in fig. 3, the calculation result corresponding to each data dimension is obtained, and the calculation is completed after the calculation results corresponding to each data dimension are obtained, except for the summary risk adjustment cash flow and the summary claims cash flow. The calculation order may further include a summary relationship of each data dimension, for example, the calculation result corresponding to the data dimension a and the calculation result corresponding to the data dimension B are summarized to obtain the data dimension C.
Thus, in one embodiment, step S4 includes:
sequentially calculating source data corresponding to data dimensions according to a calculation formula according to a calculation sequence to obtain a preliminary calculation result corresponding to each data dimension;
and summarizing the preliminary calculation results of the data dimensions according to the calculation sequence to obtain the calculation results.
In one embodiment, in order to facilitate subsequent summary calculation, the preliminary calculation result corresponding to each data dimension may be cached in a cache database, so that when the subsequent summary calculation requires the preliminary calculation result of a certain data dimension, the subsequent summary calculation may be directly invoked without repeated calculation.
And S5, associating the calculation result with the dimension relation graph, and displaying the calculation result in the dimension relation graph.
In the above way, the corresponding calculation result is displayed at the corresponding node position in the dimension relation graph, which is beneficial for the user to intuitively know the calculation condition. Further, the preliminary calculation result can be correspondingly displayed on the corresponding node in the dimension relation graph.
In one embodiment, step S5 specifically includes:
traversing the dimension relation graph, and determining the display position of the calculation result in the dimension relation graph according to the data dimension corresponding to the calculation result;
and displaying the calculation result on the display position.
In the above, the calculation result corresponding to each data dimension has a corresponding display position in the dimension relation graph, and specifically, the calculation result corresponding to each data dimension may be configured to be displayed above or below the corresponding data dimension in the dimension relation graph, so that a user can easily know the dependency relationship and the calculation result of each data dimension.
In one embodiment, the method of the present disclosure further comprises:
comparing the calculation result with a preset expected result;
and if the calculation result does not meet the expected result, generating second prompt information to remind a user to adjust any one or more items of the source data information, the data dimension relation and the data calculation formula.
The expected result is an index value corresponding to each data dimension input by the user, and can be associated with the enterprise business operation plan. If the calculation result does not meet the expected result, the source data, the data dimension relation and the data calculation formula are represented, and if one link or a plurality of links are wrong, the user can be reminded to correct the data.
In the configurable data calculation method disclosed by the invention, the data dimension relation can be automatically obtained through the source data information and the data calculation formula configured by the user, the dimension relation graph is generated, and the calculation result is displayed in the dimension relation graph, so that the data calculation is visible, configurable and adjustable.
As shown in fig. 4, based on the above technical solution of the configurable data calculation method disclosed in the present invention, the present invention further discloses a configurable data calculation apparatus, including:
the configuration module 401 is configured to receive source data information configured by a user, a data calculation formula, and obtain a data dimension relationship.
A source data obtaining module 402, configured to obtain source data according to the source data information.
And a graph module 403, configured to generate a dimension relation graph according to the data dimension relation, and determine a calculation order.
And a calculating module 404, configured to calculate the source data according to a calculation order by using a data calculation formula, so as to obtain a calculation result.
And a display module 405, configured to associate the calculation result with the dimension relation graph, and display the calculation result in the dimension relation graph.
The source data information received by the configuration module 401 includes: the data type, the table name of the data table, or the file name of the system file, and further may include a row ID of the data; the received data calculation formulas generally correspond to data dimensions, one data dimension corresponding to at least one data calculation formula. The source data obtaining module 402 is specifically configured to search a corresponding data table and a corresponding data row according to the data type, the data table name, and the row ID in the source data information, and extract data corresponding to the data type from the data row. Further, the source data obtaining module 402 is further configured to obtain the source data according to the data obtaining frequency. In the calculation module 404, the calculation order of the data dimensions may include the calculation order of each data dimension, and may further include a data summarization order, that is, a summarization relationship between data dimensions. . The display module 405 is specifically configured to display a corresponding display position of the calculation result corresponding to each data dimension in the dimension relation graph.
In one embodiment, the configuration module 401 is configured to receive a data dimension relationship configured by a user.
In another embodiment, the configuration module 401 includes a data dimension relationship obtaining module, configured to read calculation formulas of any two data, and determine that a dependency relationship exists between a data dimension corresponding to a dependent variable factor and a data dimension corresponding to an independent variable factor if a dependent variable factor in one of the data calculation formulas is an independent variable factor in the other data calculation formula.
In one embodiment, graph module 403, includes:
and the graph generating module is used for generating a directed graph according to the data dimension relation.
And the graph detection module is used for traversing the directed graph, judging whether the annular part exists in the directed graph or not, if so, generating first prompt information to remind a user of reconfiguring the data dimension relation, and if not, determining the calculation sequence of each data dimension.
In one embodiment, the calculation module 404 includes:
and the preliminary calculation module is used for sequentially calculating the source data corresponding to the data dimensions according to the calculation formula according to the calculation sequence to obtain a preliminary calculation result corresponding to each data dimension.
A summarizing module, which summarizes the preliminary calculation results of the data dimensions according to the calculation order to obtain the calculation results, in an embodiment, the calculating module 404 further includes:
and the cache module is used for caching the preliminary calculation result so as to facilitate the direct call of the subsequent summary calculation.
In one embodiment, the display module 405 is specifically configured to:
traversing the dimension relation graph, and determining the display position of the calculation result in the dimension relation graph according to the data dimension corresponding to the calculation result;
and displaying the calculation result on the display position.
In one embodiment, the disclosed apparatus further comprises:
the result checking module is used for comparing the calculation result with a preset expected result;
and if the calculation result does not meet the expected result, generating second prompt information to remind a user to adjust any one or more items of the source data information, the data dimension relation and the data calculation formula.
As described above, the configurable data computing apparatus disclosed in the present invention executes all steps of the configurable data computing method disclosed in the present invention through the configuration module 401, the source data acquisition module 402, the graph module 403, the computing module 404, and the display module 405, and the apparatus may be separately disposed in a hardware device, or may be embedded in a data computing system.
In order to further explain the technical solution disclosed in the present invention, a specific description will be made with reference to a calculation scenario of expected cash flow in a specific insurance business.
As shown in fig. 5, after the user configures the source data information, the data calculation formula, and the data dimension relationship, the source data is obtained in batch based on the source data information. And generating a dimension relation graph (not shown) according to the data dimension relation, and determining a calculation sequence (such as the sequence number before each data dimension in fig. 5). The cash flow output, the assessment point cash flow output, the accident point cash flow output, the risk adjustment assessment point cash flow output, the risk adjustment accident point cash flow output, the non-performing risk assessment point cash flow output, the non-performing risk accident point cash flow output and the non-performing risk cash flow output are calculated in sequence by using a data calculation formula in fig. 5. Wherein, cash flow output, assessment point cash flow output, accident point cash flow output, risk adjustment cash flow, and non-performance risk cash flow are summarized into a pay/expense cash flow; and the risk adjustment cash flow output, the risk adjustment evaluation point cash flow output, the risk adjustment accident point cash flow output and the risk adjustment accident point cash flow output are summarized into a risk adjustment cash flow, and the non-performing risk evaluation point cash flow, the non-performing risk accident point cash flow output and the non-performing risk cash flow output are summarized into a non-performing risk cash flow. And judging whether all the data dimensions are calculated, if so, summarizing the calculated data, otherwise, returning to the source data acquisition step, searching the reason, and readjusting the configuration.
In addition, an embodiment of the present invention further provides an electronic device, including:
one or more processors; and
a memory associated with the one or more processors for storing program instructions that, when read and executed by the one or more processors, perform the configurable data computation method disclosed in the above embodiments.
Fig. 6 illustrates an architecture of a computer system, which may include, in particular, a processor 610, a video display adapter 611, a disk drive 612, an input/output interface 613, a network interface 614, and a memory 620. The processor 610, the video display adapter 611, the disk drive 612, the input/output interface 613, the network interface 614, and the memory 620 may be communicatively connected by a communication bus 630.
The processor 610 may be implemented by a general-purpose CPU (Central Processing Unit), a microprocessor, an Application Specific Integrated Circuit (ASIC), or one or more Integrated circuits, and is configured to execute related programs to implement the technical solution provided in the present Application.
The Memory 620 may be implemented in the form of a ROM (Read Only Memory), a RAM (Random Access Memory), a static storage device, a dynamic storage device, or the like. The memory 620 may store an operating system 621 for controlling the operation of the electronic device, a Basic Input Output System (BIOS) for controlling low-level operations of the electronic device. In addition, a web browser 623, a data storage management system 624, a device identification information processing system 625, and the like may also be stored. The device identification information processing system 625 may be an application program that implements the operations of the foregoing steps in this embodiment of the present application. In summary, when the technical solution provided in the present application is implemented by software or firmware, the relevant program codes are stored in the memory 620 and called for execution by the processor 610.
The input/output interface 613 is used for connecting an input/output module to realize information input and output. The i/o module may be configured as a component in a device (not shown) or may be external to the device to provide a corresponding function. The input devices may include a keyboard, a mouse, a touch screen, a microphone, various sensors, etc., and the output devices may include a display, a speaker, a vibrator, an indicator light, etc.
The network interface 614 is used for connecting a communication module (not shown in the figure) to realize the communication interaction between the device and other devices. The communication module can realize communication in a wired mode (such as USB, network cable and the like) and also can realize communication in a wireless mode (such as mobile network, WIFI, Bluetooth and the like).
In addition, the electronic device may further obtain information of specific pickup conditions from the virtual resource object pickup condition information database for performing condition judgment, and the like.
It should be noted that although the above devices only show the processor 610, the video display adapter 611, the disk drive 612, the input/output interface 613, the network interface 614, the memory 620, the bus 630, etc., in a specific implementation, the device may also include other components necessary for normal operation. Furthermore, it will be understood by those skilled in the art that the apparatus described above may also include only the components necessary to implement the solution of the present application, and not necessarily all of the components shown in the figures.
In particular, according to embodiments of the application, the processes described above with reference to the flow diagrams may be implemented as computer software programs. For example, embodiments of the present application include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method illustrated by the flow chart. In such an embodiment, the computer program may be downloaded and installed from a network via the communication means, or installed from the memory, or installed from the ROM. The computer program, when executed by a processor, performs the above-described functions defined in the methods of embodiments of the present application.
It should be noted that the computer readable medium of the embodiments of the present application may be a computer readable signal medium or a computer readable storage medium or any combination of the two. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples of the computer readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In embodiments of the application, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In embodiments of the present application, however, a computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: electrical wires, optical cables, RF (Radio Frequency), etc., or any suitable combination of the foregoing.
The computer readable medium may be embodied in the server; or may exist separately and not be assembled into the server. The computer readable medium carries one or more programs which, when executed by the server, cause the server to: when the peripheral mode of the terminal is detected to be not activated, acquiring a frame rate of an application on the terminal; when the frame rate meets the screen information condition, judging whether a user is acquiring the screen information of the terminal; and controlling the screen to enter an immediate dimming mode in response to the judgment result that the user does not acquire the screen information of the terminal.
Computer program code for carrying out operations for embodiments of the present application may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C + +, and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).
The embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, the system or system embodiments are substantially similar to the method embodiments and therefore are described in a relatively simple manner, and reference may be made to some of the descriptions of the method embodiments for related points. The above-described system and system embodiments are only illustrative, wherein the units described as separate parts may or may not be physically separate, and the 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 modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment. One of ordinary skill in the art can understand and implement it without inventive effort.
The method, the device and the electronic device for processing the identification information of the terminal device provided by the present application are introduced in detail, and a specific example is applied in the description to explain the principle and the implementation of the present application, and the description of the above embodiment is only used to help understand the method and the core idea of the present application; meanwhile, for a person skilled in the art, according to the idea of the present application, the specific embodiments and the application range may be changed. In view of the above, the description should not be taken as limiting the application.
All the above-mentioned optional technical solutions can be combined arbitrarily to form the optional embodiments of the present invention, and are not described herein again.
The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents, improvements and the like that fall within the spirit and principle of the present invention are intended to be included therein.
Claims (10)
1. A configurable data computation method, comprising:
receiving source data information and a data calculation formula configured by a user, and acquiring a data dimension relation;
acquiring source data according to the source data information;
generating a dimension relation graph according to the data dimension relation, and determining a calculation sequence;
calculating the source data according to the calculation sequence by using the data calculation formula to obtain a calculation result;
and associating the calculation result with the dimension relation graph, and displaying the calculation result in the dimension relation graph.
2. The method of claim 1, wherein the generating a dimensional relationship graph from the data dimensional relationships and determining the calculation order of each of the data dimensions comprises:
generating a directed graph according to the data dimension relation;
and traversing the directed graph, judging whether an annular part exists in the directed graph or not, if so, generating first prompt information to remind a user of reconfiguring the data dimension relation, and if not, determining the calculation sequence of each data dimension.
3. The method of claim 1, wherein said computing said source data in said computing order using said data computing formula to obtain a computed result comprises:
sequentially calculating the source data corresponding to each data dimension according to the calculation formula according to the calculation sequence to obtain a preliminary calculation result of each data dimension;
and summarizing the preliminary calculation results of the data dimensions according to the calculation sequence to obtain the calculation results.
4. The method of claim 3, wherein the method further comprises:
and caching the preliminary calculation results of the data dimensions so as to be directly called in the subsequent summary calculation.
5. The method of claim 1, wherein the obtaining data dimension relationships comprises:
reading any two data calculation formulas;
and if the dependent variable factor in one data calculation formula is the independent variable factor of the other data calculation formula, determining that the data dimension corresponding to the dependent variable factor and the data dimension corresponding to the independent variable factor have a dependency relationship.
6. The method of claim 1, wherein said associating the computation result with the dimensional relationship graph, and displaying the computation result in the dimensional relationship graph, comprises:
traversing the dimension relation graph, and determining the display position of the calculation result in the dimension relation graph according to the data dimension corresponding to the calculation result;
and displaying the calculation result on the display position.
7. The method of any one of claims 1 to 6, further comprising:
comparing the calculation result with a preset expected result;
and if the calculation result does not meet the expected result, generating second prompt information to remind a user to adjust any one or more items of the source data information, the data dimension relation and the data calculation formula.
8. A configurable data computing device, comprising:
the configuration module is used for receiving source data information and a data calculation formula configured by a user and acquiring a data dimension relation;
the source data acquisition module is used for acquiring source data according to the source data information;
the graph module is used for generating a dimensional relation graph according to the data dimensional relation and determining a calculation sequence;
the calculation module is used for calculating the source data according to the calculation sequence by using the data calculation formula to obtain a calculation result;
and the display module is used for associating the calculation result with the dimension relation graph and displaying the calculation result in the dimension relation graph.
9. An electronic device, comprising:
one or more processors; and
a memory associated with the one or more processors for storing program instructions that, when read and executed by the one or more processors, perform the method of any of claims 1-7.
10. A computer-readable medium, on which a computer program is stored, which program, when being executed by a processor, carries out the method of any one of claims 1 to 7.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110808046.6A CN113569184A (en) | 2021-07-16 | 2021-07-16 | Configurable data calculation method, device, equipment and computer readable medium |
| PCT/CN2022/114571 WO2023284892A1 (en) | 2021-07-16 | 2022-08-24 | Configurable data computing method and apparatus, device, and medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110808046.6A CN113569184A (en) | 2021-07-16 | 2021-07-16 | Configurable data calculation method, device, equipment and computer readable medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113569184A true CN113569184A (en) | 2021-10-29 |
Family
ID=78165239
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110808046.6A Pending CN113569184A (en) | 2021-07-16 | 2021-07-16 | Configurable data calculation method, device, equipment and computer readable medium |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN113569184A (en) |
| WO (1) | WO2023284892A1 (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2023284892A1 (en) * | 2021-07-16 | 2023-01-19 | 众安在线财产保险股份有限公司 | Configurable data computing method and apparatus, device, and medium |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP0425078A2 (en) * | 1989-09-27 | 1991-05-02 | Kabushiki Kaisha Toshiba | Vectorization method |
| CN101179516A (en) * | 2006-11-10 | 2008-05-14 | 北京航空航天大学 | Digraph based data distributing method |
| CN106354703A (en) * | 2016-08-17 | 2017-01-25 | 浪潮通用软件有限公司 | Method and device for determining computation sequence of formulas |
| CN106557457A (en) * | 2016-11-28 | 2017-04-05 | 中国电子科技集团公司第二十八研究所 | A kind of system for automatically generating cross-platform Complicated Flow figure based on QT |
| CN107612886A (en) * | 2017-08-15 | 2018-01-19 | 中国科学院大学 | A kind of Spark platforms Shuffle process compresses algorithm decision-making techniques |
| CN108509440A (en) * | 2017-02-24 | 2018-09-07 | 腾讯科技（深圳）有限公司 | A kind of data processing method and device |
| CN108874757A (en) * | 2017-05-10 | 2018-11-23 | 北京京东尚科信息技术有限公司 | Report form generation method and system, computer-readable medium, electronic equipment |
| CN110059301A (en) * | 2019-03-12 | 2019-07-26 | 北京字节跳动网络技术有限公司 | Data processing method, device, electronic equipment and computer readable storage medium |
| CN111209301A (en) * | 2019-12-29 | 2020-05-29 | 南京云帐房网络科技有限公司 | Method and system for improving operation performance based on dependency tree splitting |
| CN111797619A (en) * | 2020-07-15 | 2020-10-20 | 浙江赢康医疗科技有限公司 | Device and method for automatically calculating observation items according to formula |
| CN112540863A (en) * | 2020-12-29 | 2021-03-23 | 深圳前海微众银行股份有限公司 | Data processing method, device, equipment and computer storage medium |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8671363B2 (en) * | 2008-11-19 | 2014-03-11 | Oracle International Corporation | Nested dimensions presentation structures |
| CN110888720A (en) * | 2019-10-08 | 2020-03-17 | 北京百度网讯科技有限公司 | Task processing method and device, computer equipment and storage medium |
| CN112527474B (en) * | 2020-12-10 | 2023-07-25 | 北京百度网讯科技有限公司 | Task processing method and device, equipment, readable medium and computer program product |
| CN112861492A (en) * | 2021-01-27 | 2021-05-28 | 亿企赢网络科技有限公司 | Method and device for linkage calculation between internal tables of report table and electronic equipment |
| CN113569184A (en) * | 2021-07-16 | 2021-10-29 | 众安在线财产保险股份有限公司 | Configurable data calculation method, device, equipment and computer readable medium |
-
2021
- 2021-07-16 CN CN202110808046.6A patent/CN113569184A/en active Pending
-
2022
- 2022-08-24 WO PCT/CN2022/114571 patent/WO2023284892A1/en unknown
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP0425078A2 (en) * | 1989-09-27 | 1991-05-02 | Kabushiki Kaisha Toshiba | Vectorization method |
| CN101179516A (en) * | 2006-11-10 | 2008-05-14 | 北京航空航天大学 | Digraph based data distributing method |
| CN106354703A (en) * | 2016-08-17 | 2017-01-25 | 浪潮通用软件有限公司 | Method and device for determining computation sequence of formulas |
| CN106557457A (en) * | 2016-11-28 | 2017-04-05 | 中国电子科技集团公司第二十八研究所 | A kind of system for automatically generating cross-platform Complicated Flow figure based on QT |
| CN108509440A (en) * | 2017-02-24 | 2018-09-07 | 腾讯科技（深圳）有限公司 | A kind of data processing method and device |
| CN108874757A (en) * | 2017-05-10 | 2018-11-23 | 北京京东尚科信息技术有限公司 | Report form generation method and system, computer-readable medium, electronic equipment |
| CN107612886A (en) * | 2017-08-15 | 2018-01-19 | 中国科学院大学 | A kind of Spark platforms Shuffle process compresses algorithm decision-making techniques |
| CN110059301A (en) * | 2019-03-12 | 2019-07-26 | 北京字节跳动网络技术有限公司 | Data processing method, device, electronic equipment and computer readable storage medium |
| CN111209301A (en) * | 2019-12-29 | 2020-05-29 | 南京云帐房网络科技有限公司 | Method and system for improving operation performance based on dependency tree splitting |
| CN111797619A (en) * | 2020-07-15 | 2020-10-20 | 浙江赢康医疗科技有限公司 | Device and method for automatically calculating observation items according to formula |
| CN112540863A (en) * | 2020-12-29 | 2021-03-23 | 深圳前海微众银行股份有限公司 | Data processing method, device, equipment and computer storage medium |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2023284892A1 (en) * | 2021-07-16 | 2023-01-19 | 众安在线财产保险股份有限公司 | Configurable data computing method and apparatus, device, and medium |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2023284892A1 (en) | 2023-01-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108874672B (en) | Application program exception positioning method, device, equipment and storage medium | |
| US20220066896A1 (en) | Method, system, and apparatus for monitoring blockchain smart contract | |
| US20230123573A1 (en) | Automatic detection of seasonal pattern instances and corresponding parameters in multi-seasonal time series | |
| CN113268260A (en) | Routing method and device for web front end | |
| CN111506579A (en) | Method, program and equipment for generating intelligent contract code | |
| CN110659210A (en) | Information acquisition method and device, electronic equipment and storage medium | |
| CN113569184A (en) | Configurable data calculation method, device, equipment and computer readable medium | |
| CN111309743A (en) | Report pushing method and device | |
| CN112954056A (en) | Monitoring data processing method and device, electronic equipment and storage medium | |
| CN112445691A (en) | Non-invasive intelligent contract performance detection method and device | |
| CN111639086A (en) | Data reconciliation method, device, equipment and storage medium | |
| CN110908899A (en) | Application program debugging method, mobile terminal and computer readable storage medium | |
| CN113112217B (en) | Business process configuration method, device, electronic equipment and computer readable medium | |
| CN110297639B (en) | Method and apparatus for detecting code | |
| CN114968696A (en) | Index monitoring method, electronic equipment and chip system | |
| CN112667119A (en) | Measuring point batch correlation method and device, electronic equipment and computer readable medium | |
| CN110928801A (en) | Role authority test method and device, computer medium and electronic equipment | |
| CN109947546B (en) | Task execution method and device, electronic equipment and storage medium | |
| CN114881546B (en) | Method and device for determining resource consumption | |
| CN113127309B (en) | Program monitoring method and device, electronic equipment and storage medium | |
| CN111104626B (en) | Information storage method and device | |
| CN115408297A (en) | Test method, device, equipment and medium | |
| CN113919829A (en) | Account transaction request processing method, device and system and electronic equipment | |
| CN114253633A (en) | Interface calling method and device, electronic equipment and storage medium | |
| CN113986410A (en) | Method and device for managing intelligent equipment out of band, electronic equipment and computer 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 |