A business data combination display method and device

Abstract

The present application provides a business data combination display method and device, which belongs to the field of big data and can be used in the financial field. The method includes: screening business data tables and some business fields in business data tables from pre-selected metadata; using a pre-established business field selection model to select business fields related to some business fields from the remaining business fields; and combining and displaying business data of some business fields and selected business fields according to a pre-selected dashboard template. The present application can use the business field selection model to select business fields related to some pre-selected business fields, and combine and display business data of the two in the dashboard template.

Description

Technical Field

[0001] The present application relates to the field of big data and can be used in the financial field. Specifically, it is a method and device for displaying a combination of business data. Background Art

[0002] Business intelligence is widely used in the field of data analysis and mining. Through modern data warehouse technology, online analysis and processing technology, data mining technology, data analysis technology and data presentation technology, data analysis can be performed to realize business value. However, most of the current commercial data analysis platforms can only rely on the subjective behavior of users to conduct data mining and analysis, and cannot achieve intelligent data analysis and intelligent recommendation of data analysis models by training big data models. Summary of the invention

[0003] In response to the problems in the prior art, the present application provides a business data combination display method and device, which can utilize a business field selection model to select related business fields based on some pre-selected business fields, and combine the two to display business data in a dashboard template.

[0004] In order to solve the above technical problems, this application provides the following technical solutions:

[0005] In a first aspect, the present application provides a method for displaying a business data combination, including:

[0006] Filtering a business data table and some business fields in the business data table from pre-selected metadata; the metadata includes a relational business data table and a business document;

[0007] Selecting a business field related to the part of the business fields from the remaining business fields using a pre-established business field selection model;

[0008] The business data combination of the partial business fields and the selected business fields is displayed according to the pre-selected dashboard template.

[0009] Furthermore, the filtering of the business data table and some business fields in the business data table from the pre-selected metadata includes:

[0010] Extracting SQL statement segments from the business document according to a pre-established screening intention;

[0011] Generate a business data table according to the relational business data table and the SQL statement segment;

[0012] The part of business fields is filtered from the business data table.

[0013] Furthermore, the steps of establishing a business field selection model include:

[0014] Filtering a historical business data table and some historical business fields in the historical business data table from historical metadata;

[0015] Calculate the correlation coefficient between the historical part business field and the historical remaining business field in the historical business data table;

[0016] A business field selection model is established according to the correlation coefficient.

[0017] Further, the business fields related to the part of the business fields are selected from the remaining business fields using a pre-established business field selection model, including:

[0018] Determine the corresponding historical business data table according to the business data table;

[0019] Using the business field selection model, querying the business fields related to the partial business fields in the historical business data table; the related business fields include the dimension area selected in the dashboard template, the metric area selected in the dashboard template, the grouping area selected in the dashboard template, and the screening area selected in the dashboard template;

[0020] Performing correlation aggregation calculation on the related business fields respectively to obtain correlation coefficients of the related business fields;

[0021] The correlation coefficients are arranged in descending order to determine the first N related business fields with higher correlation coefficients; wherein N is a positive integer.

[0022] In a second aspect, the present application provides a business data combination display device, including:

[0023] A partial field screening unit, used to screen a business data table and some business fields in the business data table from pre-selected metadata; the metadata includes a relational business data table and a business document;

[0024] A related field selection unit, used for selecting a business field related to the part of business fields from the remaining business fields by using a pre-established business field selection model;

[0025] The combined display unit is used to display the business data of the partial business fields and the selected business fields in combination according to the pre-selected dashboard template.

[0026] Furthermore, the partial field screening unit includes:

[0027] A statement segment extraction module, used to extract SQL statement segments from the business document according to a pre-established screening intention;

[0028] A data table generation module, used to generate a business data table according to the relational business data table and the SQL statement segment;

[0029] The partial field screening module is used to screen the partial business fields from the business data table.

[0030] Furthermore, the business data combination display device further includes:

[0031] A historical partial field screening unit, used to screen a historical business data table and a historical partial business field in the historical business data table from historical metadata;

[0032] A correlation calculation unit, used to calculate a correlation coefficient between a historical part of the business field and a historical remaining business field in the historical business data table;

[0033] The selection model establishment unit is used to establish a business field selection model according to the correlation coefficient.

[0034] Furthermore, the relevant field selection unit includes:

[0035] A historical data table determination module is used to determine the corresponding historical business data table according to the business data table;

[0036] A related field query module, used to query the business fields related to the part of the business fields in the historical business data table by using the business field selection model; the related business fields include the dimension area selected in the dashboard template, the metric area selected in the dashboard template, the grouping area selected in the dashboard template, and the screening area selected in the dashboard template;

[0037] A correlation calculation module, used to perform correlation aggregation calculation on the related business fields respectively to obtain correlation coefficients of the related business fields;

[0038] The related field determination module is used to arrange the correlation coefficients in descending order and determine the first N related business fields with higher correlation coefficients; wherein N is a positive integer.

[0039] In a third aspect, the present application provides an electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of the business data combination display method when executing the program.

[0040] In a fourth aspect, the present application provides a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the steps of the business data combination display method.

[0041] In response to the problems in the prior art, the business data combination display method and device provided in the present application can be based on modern data warehouses and online analysis technologies, and use big data in the big data platform to train models, so that the trained model can perform intelligent recommendations on data fields, thereby accurately and efficiently identifying business fields that users may need, thereby achieving the purpose of quickly displaying business data combinations. BRIEF DESCRIPTION OF THE DRAWINGS

[0042] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0043] Figure 1 This is a flowchart of the business data combination display method in an embodiment of the present application;

[0044] Figure 2 A flowchart for screening a business data table and some business fields in the business data table in an embodiment of the present application;

[0045] Figure 3 A flowchart of establishing a business field selection model in an embodiment of the present application;

[0046] Figure 4 A flowchart of selecting a business field related to the part of business fields in an embodiment of the present application;

[0047] Figure 5 This is one of the structural diagrams of the business data combination display device in the embodiment of the present application;

[0048] Figure 6 This is a structural diagram of a partial field screening unit in an embodiment of the present application;

[0049] Figure 7 This is the second structural diagram of the business data combination display device in the embodiment of the present application;

[0050] Figure 8 This is a structural diagram of a relevant field selection unit in an embodiment of the present application;

[0051] Fig. 9 It is a schematic diagram of the structure of an electronic device in an embodiment of the present application;

[0052] Fig.10 This is a schematic diagram of a dashboard template in an embodiment of the present application. DETAILED DESCRIPTION

[0053] The following will be combined with the drawings in the embodiments of the present application to clearly and completely describe the technical solutions in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this application.

[0054] It should be noted that the business data combination display method and device provided in the present application can be used in the financial field, and can also be used in any field other than the financial field. The application field of the business data combination display method and device provided in the present application is not limited.

[0055] See also Figure 1 In order to utilize the business field selection model, select the business fields related to the pre-selected partial business fields, and combine the two to display business data in the dashboard template, the present application provides a business data combination display method, including:

[0056] S101: Filtering a business data table and some business fields in the business data table from pre-selected metadata; the metadata includes a relational business data table and a business document;

[0057] S102: Selecting a business field related to the part of the business fields from the remaining business fields using a pre-established business field selection model;

[0058] It is understandable that the present application can be implemented based on data warehouse technology, and the data warehouse may include various relational business data tables and business documents. These relational business data tables can be stored in various common relational databases, and the business documents can be various structured documents, such as Microsoft Excel documents and documents stored in a distributed file system (Hadoop Distributed File System, HDFS).

[0059] For relational business data tables and business documents that have business data tables stored inside, those skilled in the art can directly filter out useful business data tables; for business documents that do not have business data tables stored inside but only store some business data, those skilled in the art can obtain useful business data tables after processing the business data therein. The specific processing process is to extract the business data in the business document into SQL statement segments, and then generate a business data table based on the extracted SQL statement segments.

[0060] In actual business, due to the large amount of business data, when retrieving business data for display, it is necessary to filter out business data that meets the filtering intention for display, and the above filtering action is for the business fields in each business data table. In order to make the filtering more convenient and quick, after manually filtering out some business fields, the pre-established business field selection model can select business fields related to some business fields from the remaining business fields to improve efficiency.

[0061] Preferably, after the business field selection model selects business fields related to some business fields, those skilled in the art may manually confirm these related business fields to make these business fields more consistent with the screening intention.

[0062] S103: Perform business data combination display of some business fields and selected business fields according to the pre-selected dashboard template.

[0063] It is understandable that the embodiments of the present application provide a variety of dashboard templates for technicians in the field of business data combination display. Those skilled in the art can choose according to actual business scenarios and application requirements. These dashboard templates include but are not limited to nine-square grid type, six-square grid type and field grid type. Fig.10 The pre-selected dashboard template can be used to combine and display the business data in the above-mentioned business fields and the selected business fields. When using the dashboard template to display business data in combination, it is necessary to fill in the basic business information, the directory where the business data is located, the combination display name and related descriptions.

[0064] Figure 1 The execution subject of the process shown is a terminal or a server. The terminal may be a PC or a mobile terminal (such as a mobile phone or a PAD, etc.), but the present invention is not limited thereto.

[0065] From the above description, it can be seen that the business data combination display method provided by this application can be based on modern data warehouses and online analysis technologies, and use the big data in the big data platform to train models, so that the trained model can perform intelligent recommendations on data fields, thereby accurately and efficiently identifying the business fields that users may need, and achieving the purpose of quickly displaying business data combinations.

[0066] See also Figure 2 , filtering the business data table and some business fields in the business data table from the pre-selected metadata, including:

[0067] S201: extracting SQL statement segments from business documents according to a pre-established screening intention;

[0068] It is understandable that, for example, the so-called screening intention refers to which business data needs to be combined and displayed as clearly defined by those skilled in the art, and these screening intentions include but are not limited to the region to which the business data belongs and the time when the business data is recorded, etc. As has been explained above, although some business documents record business data, they have not formed standardized relational data tables and are difficult to directly screen and utilize, so those skilled in the art need to convert the business data in the business documents into statement segments of the database structured query language (SQL).

[0069] S202: Generate a business data table according to the relational business data table and the SQL statement segment;

[0070] It is understandable that the business data table can be directly derived from the relational business data table, or can be derived from the SQL statement segment corresponding to the business data. Those skilled in the art can generate the business data table using mature data query and screening methods in the prior art.

[0071] S203: Filter some business fields from the business data table.

[0072] It is understandable that the above has explained that the business data combination is displayed based on the business fields, not the entire data table, so it is necessary to filter some business fields from the business data table. At the same time, based on the filtered business fields, the related business fields can be established later.

[0073] It can be seen from the above description that the business data combination display method provided in the present application can filter the business data table and some business fields in the business data table from pre-selected metadata.

[0074] See also Figure 3 , the steps to establish a business field selection model include:

[0075] S301: Filtering a historical business data table and some historical business fields in the historical business data table from historical metadata;

[0076] It is understandable that in order to establish a business field selection model, a certain amount of historical metadata needs to be obtained. Using a method similar to the method described in steps S201 to S203, those skilled in the art can filter out some historical business fields corresponding to the historical metadata.

[0077] S302: Calculate the correlation coefficient between the historical part business field and the historical remaining business field in the historical business data table;

[0078] It is understandable that in the historical operation, all the business fields that need to be combined and displayed are manually selected by technicians in this field. Now, in order to train the model, some business fields can be artificially defined as historical partial business fields, and other business fields can be defined as historical remaining business fields. The so-called historical remaining business fields refer to the business fields selected by technicians in this field for combined display of business data, except for the historical partial business fields. It can be imagined that these historical remaining business fields must have a certain degree of correlation with the historical partial business fields, and technicians in this field will consider putting them together with the historical partial business fields for combined display. Calculate the correlation coefficient between the historical partial business fields and the historical remaining business fields in the historical business data table, and sort the correlation coefficients between the historical partial business fields and each historical remaining business field from high to low or from low to high, and then find out several historical remaining business fields with the highest correlation with each historical partial business field for each historical partial business field.

[0079] It should be noted that since there are many methods for determining the correlation coefficient, this application does not limit this. In one embodiment, when determining the correlation coefficient, different business fields can be classified into metric columns or dimension columns according to whether the business field is a numeric type or a character type, and different weights are assigned to business fields according to different column names, and finally the weights are accumulated to obtain the correlation coefficient.

[0080] S303: Establishing a business field selection model according to the correlation coefficient.

[0081] It is understandable that after the model is established, when some business fields are input into the business field selection model, the model can output several highly correlated business fields.

[0082] From the above description, it can be seen that the business data combination display method provided in this application can establish a business field selection model.

[0083] See also Figure 4 , using a pre-established business field selection model to select business fields related to the part of the business fields from the remaining business fields, including:

[0084] S401: Determine the historical business data table corresponding to the business data table according to the business data table;

[0085] It is understandable that in different combination display scenarios, the business data tables selected by technicians in this field are not the same. Therefore, it is necessary to first clarify which business data tables are combined for display, and then select relevant business fields for each business data table one by one. When selecting relevant business fields, in order to obtain a better selection effect of relevant business fields, it is first necessary to determine the corresponding historical business data table based on the business data table, because the historical business data table corresponding to the business data table has the same business fields as the business data table, which is convenient for selecting relevant business fields.

[0086] S402: using a pre-established business field selection model, querying business fields related to some business fields in the historical business data table; the related business fields include a dimension area selected into the dashboard template, a metric area selected into the dashboard template, a grouping area selected into the dashboard template, and a screening area selected into the dashboard template;

[0087] It can be understood that since the business field selection model has been established in advance and the business fields in the historical business data table are also in the business data table, business fields related to some business fields can be obtained, thereby realizing the operation of querying business fields related to some business fields in the historical business data table.

[0088] S403: performing correlation aggregation calculation on the related business fields respectively to obtain correlation coefficients of the related business fields;

[0089] It is understandable that there may be multiple business fields related to some business fields queried in S402. At this time, the correlation aggregation calculation can be performed on the related business fields respectively to obtain the correlation coefficient of each related business field. This application does not limit the specific calculation method. A feasible calculation method can be found in the description in S302.

[0090] S404: Arrange the correlation coefficients in descending order to determine the first N relevant business fields with higher correlation coefficients; wherein N is a positive integer.

[0091] It is understandable that several most relevant business fields may be selected and combined with some business fields for display.

[0092] It can be seen from the above description that the business data combination display method provided in the present application can use a pre-established business field selection model to select business fields related to the partial business fields from the remaining business fields.

[0093] In one embodiment, the method described in the present application can be run on a computer system that provides an operable human-computer interaction interface for technicians in this field. Taking the metadata as a relational business data table as an example, the left side of the interface is the basic information of the metadata, including: database user name, database table name and related descriptions, and the right side of the interface is the business field and its corresponding business data. The business field includes attributes such as column name and associated metadata. According to the business field type, the business field can be divided into dimension columns and metric columns, among which character-type business fields correspond to dimension columns, and numeric-type business fields correspond to metric columns.

[0094] Based on the same inventive concept, the embodiments of the present application also provide a business data combination display device, which can be used to implement the method described in the above embodiments, as described in the following embodiments. Since the principle of solving the problem by the business data combination display device is similar to that of the business data combination display method, the implementation of the business data combination display device can refer to the implementation of the method based on software performance benchmark determination, and the repeated parts will not be repeated. As used below, the term "unit" or "module" can be a combination of software and / or hardware that implements a predetermined function. Although the system described in the following embodiments is preferably implemented in software, the implementation of hardware, or a combination of software and hardware, is also possible and conceived.

[0095] See also Figure 5 In order to utilize the business field selection model, select the business fields related to the pre-selected partial business fields, and combine the two to display business data in the dashboard template, the present application provides a business data combination display device, including:

[0096] A partial field screening unit 501 is used to screen a business data table and some business fields in the business data table from pre-selected metadata; the metadata includes a relational business data table and a business document;

[0097] A related field selection unit 502, configured to select a business field related to the part of the business fields from the remaining business fields using a pre-established business field selection model;

[0098] The combined display unit 503 is used to display the business data of the partial business fields and the selected business fields in combination according to the pre-selected dashboard template.

[0099] See also Figure 6 The partial field screening unit 501 includes:

[0100] A statement segment extraction module 601 is used to extract SQL statement segments from the business document according to a pre-established screening intention;

[0101] A data table generating module 602 is used to generate a business data table according to the relational business data table and the SQL statement segment;

[0102] The partial field screening module 603 is used to screen the partial business fields from the business data table.

[0103] See also Figure 7 , the business data combination display device further includes:

[0104] A historical partial field screening unit 701 is used to screen a historical business data table and a historical partial business field in the historical business data table from historical metadata;

[0105] A correlation calculation unit 702, configured to calculate a correlation coefficient between a historical part business field and a historical remaining business field in the historical business data table;

[0106] The selection model establishing unit 703 is used to establish a business field selection model according to the correlation coefficient.

[0107] See also Figure 8 , the relevant field selection unit 502 includes:

[0108] A historical data table determination module 801 is used to determine a corresponding historical business data table according to a business data table;

[0109] A related field query module 802 is used to query the business fields related to the part of the business fields in the historical business data table; the related business fields include the dimension area selected in the dashboard template, the metric area selected in the dashboard template, the grouping area selected in the dashboard template, and the screening area selected in the dashboard template;

[0110] The correlation calculation module 803 is used to perform correlation aggregation calculation on the related business fields respectively to obtain the correlation coefficient of each related business field;

[0111] The related field determination module 804 is used to arrange the correlation coefficients in descending order and determine the first N related business fields with higher correlation coefficients; wherein N is a positive integer.

[0112] From the hardware level, in order to utilize the business field selection model, select the business fields related to the pre-selected partial business fields, and combine the two to display business data in the dashboard template, the present application provides an embodiment of an electronic device for implementing all or part of the content in the business data combination display method, and the electronic device specifically includes the following content:

[0113] Processor, memory, communication interface and bus; wherein the processor, memory and communication interface communicate with each other through the bus; the communication interface is used to realize information transmission between the business data combination display device and related devices such as the core business system, user terminal and related database; the logic controller can be a desktop computer, a tablet computer and a mobile terminal, etc., but the present embodiment is not limited thereto. In the present embodiment, the logic controller can be implemented with reference to the embodiment of the business data combination display method and the embodiment of the business data combination display device in the embodiment, and the contents thereof are incorporated herein, and the repeated parts are not repeated.

[0114] It is understandable that the user terminal may include a smart phone, a tablet electronic device, a network set-top box, a portable computer, a desktop computer, a personal digital assistant (PDA), a vehicle-mounted device, a smart wearable device, etc. Among them, the smart wearable device may include smart glasses, a smart watch, a smart bracelet, etc.

[0115] In practical applications, part of the business data combination display method can be executed on the electronic device side as described above, or all operations can be completed in the client device. The specific selection can be based on the processing capability of the client device and the limitations of the user's usage scenario. This application does not limit this. If all operations are completed in the client device, the client device may also include a processor.

[0116] The client device may have a communication module (i.e., a communication unit) that can communicate with a remote server to achieve data transmission with the server. The server may include a server on the task scheduling center side, and other implementation scenarios may also include a server on an intermediate platform, such as a server on a third-party server platform that has a communication link with the task scheduling center server. The server may include a single computer device, or a server cluster consisting of multiple servers, or a server structure of a distributed device.

[0117] Fig. 9 FIG. 9 is a schematic block diagram of the system structure of the electronic device 9600 according to an embodiment of the present application. Fig. 9 As shown, the electronic device 9600 may include a central processor 9100 and a memory 9140; the memory 9140 is coupled to the central processor 9100. It is worth noting that Fig. 9 is exemplary; other types of structures may also be used to supplement or replace this structure to implement telecommunication functions or other functions.

[0118] In one embodiment, the business data combination display method function may be integrated into the central processing unit 9100. The central processing unit 9100 may be configured to perform the following control:

[0119] S101: Filtering a business data table and some business fields in the business data table from pre-selected metadata; the metadata includes a relational business data table and a business document;

[0120] S102: Selecting a business field related to the part of the business fields from the remaining business fields using a pre-established business field selection model;

[0121] S103: Perform a combined display of the business data of the partial business fields and the selected business fields according to the pre-selected dashboard template.

[0122] From the above description, it can be seen that the business data combination display method provided by this application can be based on modern data warehouses and online analysis technologies, and use the big data in the big data platform to train models, so that the trained model can perform intelligent recommendations on data fields, thereby accurately and efficiently identifying the business fields that users may need, and achieving the purpose of quickly displaying business data combinations.

[0123] In another embodiment, the business data combination display device can be configured separately from the central processor 9100. For example, the data composite transmission device business data combination display device can be configured as a chip connected to the central processor 9100, and the function of the business data combination display method is realized through the control of the central processor.

[0124] like Fig. 9 As shown, the electronic device 9600 may also include: a communication module 9110, an input unit 9120, an audio processor 9130, a display 9160, and a power supply 9170. It is worth noting that the electronic device 9600 does not necessarily have to include Fig. 9 In addition, the electronic device 9600 may also include Fig. 9 For components not shown, reference may be made to the prior art.

[0125] like Fig. 9 As shown, the central processing unit 9100 is sometimes also referred to as a controller or an operation control, and may include a microprocessor or other processor device and / or logic device. The central processing unit 9100 receives input and controls the operation of various components of the electronic device 9600.

[0126] The memory 9140 may be, for example, one or more of a cache, a flash memory, a hard drive, a removable medium, a volatile memory, a non-volatile memory or other suitable devices. The above-mentioned information related to the failure may be stored, and a program for executing the relevant information may also be stored. The CPU 9100 may execute the program stored in the memory 9140 to implement information storage or processing, etc.

[0127] The input unit 9120 provides input to the central processing unit 9100. The input unit 9120 is, for example, a key or a touch input device. The power supply 9170 is used to provide power to the electronic device 9600. The display 9160 is used to display display objects such as images and texts. The display may be, for example, an LCD display, but is not limited thereto.

[0128] The memory 9140 may be a solid-state memory, such as a read-only memory (ROM), a random access memory (RAM), a SIM card, etc. It may also be a memory that saves information even when the power is off, can be selectively erased, and is provided with more data, examples of which are sometimes referred to as EPROMs, etc. The memory 9140 may also be some other type of device. The memory 9140 includes a buffer memory 9141 (sometimes referred to as a buffer). The memory 9140 may include an application / function storage unit 9142, which is used to store application programs and function programs or processes for executing the operation of the electronic device 9600 through the central processor 9100.

[0129] The memory 9140 may also include a data storage unit 9143 for storing data, such as contacts, digital data, pictures, sounds, and / or any other data used by the electronic device. The driver storage unit 9144 of the memory 9140 may include various drivers for communication functions of the electronic device and / or for executing other functions of the electronic device (such as messaging applications, address book applications, etc.).

[0130] The communication module 9110 is a transmitter / receiver 9110 that sends and receives signals via an antenna 9111. The communication module (transmitter / receiver) 9110 is coupled to the central processor 9100 to provide input signals and receive output signals, which may be the same as the case of a conventional mobile communication terminal.

[0131] Based on different communication technologies, multiple communication modules 9110 may be provided in the same electronic device, such as a cellular network module, a Bluetooth module and / or a wireless LAN module. The communication module (transmitter / receiver) 9110 is also coupled to a speaker 9131 and a microphone 9132 via an audio processor 9130 to provide an audio output via the speaker 9131 and receive an audio input from the microphone 9132, thereby realizing a common telecommunication function. The audio processor 9130 may include any suitable buffer, decoder, amplifier, etc. In addition, the audio processor 9130 is also coupled to the central processor 9100, so that recording can be performed on the local machine through the microphone 9132, and the sound stored on the local machine can be played through the speaker 9131.

[0132] The embodiments of the present application also provide a computer-readable storage medium capable of implementing all steps of the method for displaying business data combination in the above embodiment, where the execution subject is a server or a client. The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, all steps of the method for displaying business data combination in the above embodiment are implemented by the execution subject being a server or a client. For example, when the processor executes the computer program, the following steps are implemented:

[0133] S101: Filtering a business data table and some business fields in the business data table from pre-selected metadata; the metadata includes a relational business data table and a business document;

[0134] S102: Selecting a business field related to the part of the business fields from the remaining business fields using a pre-established business field selection model;

[0135] S103: Perform a combined display of the business data of the partial business fields and the selected business fields according to the pre-selected dashboard template.

[0136] From the above description, it can be seen that the business data combination display method provided by this application can be based on modern data warehouses and online analysis technologies, and use the big data in the big data platform to train models, so that the trained model can perform intelligent recommendations on data fields, thereby accurately and efficiently identifying the business fields that users may need, and achieving the purpose of quickly displaying business data combinations.

[0137] It will be appreciated by those skilled in the art that embodiments of the present invention may be provided as methods, devices, or computer program products. Therefore, the present invention may take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware. Moreover, the present invention may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0138] The present invention is described with reference to flowcharts and / or block diagrams of methods, devices (apparatus), and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowchart and / or block diagram, as well as the combination of processes and / or blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0139] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0140] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0141] The present invention uses specific embodiments to illustrate the principles and implementation methods of the present invention. The description of the above embodiments is only used to help understand the method of the present invention and its core idea. At the same time, for those skilled in the art, according to the idea of ​​the present invention, there will be changes in the specific implementation methods and application scope. In summary, the content of this specification should not be understood as a limitation on the present invention.

Claims

1. A method for displaying business data combination, characterized in that: include: Filtering a business data table and some business fields in the business data table from pre-selected metadata; the metadata includes a relational business data table and a business document; Selecting a business field related to the part of the business fields from the remaining business fields using a pre-established business field selection model; Performing a combined display of business data of the partial business fields and the selected business fields according to a pre-selected dashboard template; The steps of establishing a business field selection model include: Filtering a historical business data table and some historical business fields in the historical business data table from historical metadata; Calculate the correlation coefficient between the historical part business field and the historical remaining business field in the historical business data table; Establishing a business field selection model according to the correlation coefficient; The process of selecting a business field related to the part of the business fields from the remaining business fields using a pre-established business field selection model includes: Determine the corresponding historical business data table according to the business data table; Using the business field selection model, querying the business fields related to the partial business fields in the historical business data table; the related business fields include the dimension area selected in the dashboard template, the metric area selected in the dashboard template, the grouping area selected in the dashboard template, and the screening area selected in the dashboard template; Performing correlation aggregation calculation on the related business fields respectively to obtain correlation coefficients of the related business fields; The correlation coefficients are arranged in descending order to determine the first N related business fields with higher correlation coefficients; wherein N is a positive integer.

2. The method for displaying business data combination according to claim 1, characterized in that: The step of screening the business data table and some business fields in the business data table from the pre-selected metadata includes: Extracting SQL statement segments from the business document according to a pre-established screening intention; Generate a business data table according to the relational business data table and the SQL statement segment; The part of business fields is filtered from the business data table.

3. A business data combination display device, characterized in that: include: A partial field screening unit, used to screen a business data table and some business fields in the business data table from pre-selected metadata; The metadata includes relational business data tables and business documents; A related field selection unit, used for selecting a business field related to the part of business fields from the remaining business fields by using a pre-established business field selection model; A combined display unit, used for combining and displaying the business data of the partial business fields and the selected business fields according to a pre-selected dashboard template; A historical partial field screening unit, used to screen a historical business data table and a historical partial business field in the historical business data table from historical metadata; A correlation calculation unit, used to calculate a correlation coefficient between a historical part of the business field and a historical remaining business field in the historical business data table; A selection model building unit, used to build a business field selection model according to the correlation coefficient; Wherein, the relevant field selection unit includes: A historical data table determination module is used to determine the corresponding historical business data table according to the business data table; A related field query module, used to query the business fields related to the part of the business fields in the historical business data table by using the business field selection model; the related business fields include the dimension area selected in the dashboard template, the metric area selected in the dashboard template, the grouping area selected in the dashboard template, and the screening area selected in the dashboard template; A correlation calculation module, used to perform correlation aggregation calculation on the related business fields respectively to obtain correlation coefficients of the related business fields; The related field determination module is used to arrange the correlation coefficients in descending order and determine the first N related business fields with higher correlation coefficients; wherein N is a positive integer.

4. The business data combination display device according to claim 3, characterized in that: The partial field screening unit includes: A statement segment extraction module, used to extract SQL statement segments from the business document according to a pre-established screening intention; A data table generation module, used to generate a business data table according to the relational business data table and the SQL statement segment; The partial field screening module is used to screen the partial business fields from the business data table.

5. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the program, the steps of the business data combination display method described in any one of claims 1 to 2 are implemented.

6. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the business data combination display method described in any one of claims 1 to 2 are implemented.

Images