Method and device for creating a service statistics table, electronic equipment and storage medium

Abstract

Embodiments of the present application provide a method and device for creating a service statistical table, electronic equipment and a storage medium, wherein the method comprises: obtaining channel information; querying the online state of an application according to the channel information; obtaining a creation signal according to the online state; obtaining a user mode in the application according to the creation signal; creating dimension table information according to the user mode in the application; and creating the service statistical table according to the dimension table information. The embodiments of the present application can improve the efficiency of creating the service statistical table, reduce the probability of errors in the service statistical table, make the service statistical effective time more accurate, reduce manpower, and reduce time cost.

Description

Technical Field

[0001] This application relates to the field of data processing technology, and more specifically, to a method, apparatus, electronic device, and storage medium for creating business statistics tables. Background Technology

[0002] For multi-business, multi-channel cooperation processes, such as when banks expand and connect with multiple merchants, it requires cooperation from various branches, front-end merchants, and operations personnel to complete business statistics. The process is complex, typically involving merchant registration, cooperation with products and application approval, development and testing environment integration, application for launch and approval, approval completion, and launch confirmation. Currently, the creation of multi-business and complex business data relies on operations personnel manually creating dimension tables. This requires checking the cooperation status of application accounts and user accounts in the platform backend to see if they are online, then checking the media parameter backend system of the open banking business layer to see if channel information has been generated for application accounts and user accounts, then searching the existing dimension tables in the platform backend for a dimension table that has not yet been created and for which the channel information does not yet exist and is available, before finally clicking to create a new dimension table. Operations personnel need to go through the above process layer by layer for each application cooperation and each product for each merchant, resulting in manual operation bottlenecks and time lags. This leads to inaccurate time for subsequent business statistics to take effect. Furthermore, modifying tables created in this way requires a lot of time and effort and is prone to operational errors. Summary of the Invention

[0003] The purpose of this application is to provide a method, apparatus, electronic device, and storage medium for creating business statistics tables, which can improve the efficiency of creating business statistics tables, reduce the probability of errors in business statistics tables, make the effective time of business statistics more accurate, reduce manpower, and reduce time costs.

[0004] In a first aspect, embodiments of this application provide a method for creating a business statistics table, the method comprising:

[0005] Obtain channel information;

[0006] The online status of the application can be queried based on the channel information.

[0007] The creation signal is obtained based on the online status;

[0008] The user mode in the application is obtained based on the creation signal;

[0009] Create dimension table information based on the user patterns described in the application;

[0010] The business statistics table is created based on the dimension table information.

[0011] In the above implementation process, the creation signal is obtained by querying the online status of the application, and the creation mode is obtained based on the creation signal, thereby creating dimension table information and business statistics tables. This can improve the efficiency of creating business statistics tables, reduce the probability of errors in business statistics tables, make the effective time of business statistics more accurate, reduce manpower, and reduce time costs.

[0012] Further, the step of obtaining the creation signal based on the online status includes:

[0013] If the online status is "online", determine whether the channel information contains dimension table data;

[0014] If so, call the trigger online interface to obtain interface information, and obtain the creation signal based on the interface information;

[0015] If not, add basic fields to the channel information.

[0016] In the above implementation process, if the online status is "online", it means that the application's backend is in use. Timely receipt of the creation signal can avoid the loss of information and data and facilitate the fastest table creation.

[0017] Further, the step of obtaining the user pattern in the application based on the creation signal includes:

[0018] The background information in the application is obtained based on the creation signal;

[0019] Extract application product information from the background information;

[0020] Select the user mode in the application based on the application product information.

[0021] In the above implementation process, timely acquisition of application background information based on the creation signal can greatly shorten the effective time for the background information to form business statistics tables, and effectively improve the timeliness of subsequent table creation.

[0022] Further, the step of selecting the user mode in the application based on the application product information includes:

[0023] If the application product information includes a successful cooperation status, the selected user mode is the asynchronous call mode;

[0024] If the application product information does not include a successful cooperation status, the selected user mode is the observer mode.

[0025] In the above implementation process, if the application product information includes a successful cooperation status, it means that the table can be created directly. If the application product information does not include a successful cooperation status, the observer pattern is selected to observe in real time, which can maintain the application's data security.

[0026] Furthermore, the step of creating the business statistics table based on the dimension table information includes:

[0027] The account data field in the dimension table information is populated to obtain the populated dimension table information;

[0028] The business statistics table is created based on the populated dimension table information.

[0029] In the above implementation process, the account data field in the dimension table information is populated so that the dimension table information contains the basic fields required for subsequent table creation, saving the time of searching for fields when creating the table.

[0030] Further, the step of creating the business statistics table based on the populated dimension table information includes:

[0031] The account data field in the populated dimension table information is approved to obtain monitoring information;

[0032] Read the business statistics fields based on the monitoring information;

[0033] The business statistics fields are populated into the dimension table information to obtain the business statistics table.

[0034] In the above implementation process, the business statistics fields are read based on the listening information and populated, so that the obtained business statistics table can be directly generated to contain business statistics data without the need for manual generation.

[0035] Furthermore, after the step of creating the business statistics table based on the dimension table information, the method further includes:

[0036] Synchronize the aforementioned business statistics tables online.

[0037] During the above implementation process, the business statistics table is synchronized online to ensure that the business statistics table can be queried in real time and to avoid business data being ignored.

[0038] Secondly, embodiments of this application also provide an apparatus for creating a business statistics table, the apparatus comprising:

[0039] The acquisition module is used to acquire channel information;

[0040] The query module is used to query the online status of the application based on the channel information;

[0041] The signal acquisition module is used to acquire a creation signal based on the online status;

[0042] A pattern acquisition module is used to obtain the user pattern in the application based on the creation signal;

[0043] A creation module is used to create dimension table information based on the user patterns in the application; it is also used to create the business statistics table based on the dimension table information.

[0044] In the above implementation process, the creation signal is obtained by querying the online status of the application, and the creation mode is obtained based on the creation signal, thereby creating dimension table information and business statistics tables. This can improve the efficiency of creating business statistics tables, reduce the probability of errors in business statistics tables, make the effective time of business statistics more accurate, reduce manpower, and reduce time costs.

[0045] Thirdly, an electronic device provided in this application includes: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the computer program to implement the steps of the method described in any of the first aspects.

[0046] Fourthly, embodiments of this application provide a computer-readable storage medium storing instructions that, when executed on a computer, cause the computer to perform the method described in any of the first aspects.

[0047] Fifthly, embodiments of this application provide a computer program product that, when run on a computer, causes the computer to perform the method described in any of the first aspects.

[0048] Other features and advantages of this disclosure will be set forth in the following description, or some features and advantages may be inferred from the description or determined without doubt, or may be learned by practicing the techniques described above.

[0049] It can be implemented in accordance with the contents of the specification. The preferred embodiments of this application are described in detail below with reference to the accompanying drawings. Attached Figure Description

[0050] To more clearly illustrate the technical solutions of the embodiments of this application, the accompanying drawings used in the embodiments of this application will be briefly introduced below. It should be understood that the following drawings only show some embodiments of this application and should not be regarded as a limitation on the range. For those skilled in the art, other related drawings can be obtained based on these drawings without creative effort.

[0051] Figure 1 A flowchart illustrating the method for creating a business statistics table provided in this application embodiment;

[0052] Figure 2 A schematic diagram illustrating the structural composition of the apparatus for creating business statistics tables provided in this application embodiment;

[0053] Figure 3 A schematic diagram of the structural composition of another business statistics table creation device provided in an embodiment of this application;

[0054] Figure 4 This is a schematic diagram of the structural composition of the electronic device provided in the embodiments of this application. Detailed Implementation

[0055] The technical solutions in the embodiments of this application will now be described with reference to the accompanying drawings.

[0056] It should be noted that similar reference numerals and letters in the following figures indicate similar items; therefore, once an item is defined in one figure, it does not need to be further defined and explained in subsequent figures. Furthermore, in the description of this application, terms such as "first," "second," etc., are used only to distinguish descriptions and should not be construed as indicating or implying relative importance.

[0057] The specific embodiments of this application will be described in further detail below with reference to the accompanying drawings and examples. The following examples are used to illustrate this application, but are not intended to limit the scope of this application.

[0058] Example 1

[0059] Figure 1 This is a flowchart illustrating the method for creating a business statistics table provided in an embodiment of this application, such as... Figure 1 As shown, the method includes:

[0060] S1, Obtain channel information;

[0061] S2, query the application's launch status based on channel information;

[0062] S3, obtain the creation signal based on the online status;

[0063] S4, obtain the user pattern in the application based on the created signal;

[0064] S5 creates dimension table information based on the user schema in the application;

[0065] S6, create a business statistics table based on dimension table information.

[0066] In the above implementation process, the creation signal is obtained by querying the online status of the application, and the creation mode is obtained based on the creation signal, thereby creating dimension table information and business statistics tables. This can improve the efficiency of creating business statistics tables, reduce the probability of errors in business statistics tables, make the effective time of business statistics more accurate, reduce manpower, and reduce time costs.

[0067] This application embodiment can be used in the process of banks expanding and connecting with merchants. Since it requires cooperation from various branches, front-end merchants and operations personnel, in order to better support the business statistics of various branches of the bank, it is necessary to complete the input and maintenance of information such as the branch to which each project belongs and the referrer UM in the system. Subsequently, the data is pushed to the data warehouse for further data processing and calculation of the branch business. At present, the channel dimension table is manually entered in the open bank back-end management system. Since it involves many processes and systems, it generally involves merchant registration, cooperation products and application approval flow, development and testing environment debugging, application for launch and approval flow, approval completion, and confirmation of launch.

[0068] Meanwhile, the current manual data entry system has many problems. For example, when relying on the head office operations staff to manually create dimension tables, it is necessary to check whether the cooperation status of the application account and user account in the platform backend has been launched, then check whether the application account and user account have generated channel information in the media parameter backend system of the open banking business layer, then search in the existing dimension tables in the platform backend for the dimension table that has not yet been created and the channel information does not yet exist in the dimension table and is available, and only then can a new dimension table be created. This results in a bottleneck of manual operation and time lag in the creation of business statistics tables.

[0069] To address the aforementioned issues, this application employs an intelligent method for automatically creating dimension tables, enabling the automatic creation of business statistics tables.

[0070] In S1, to solve the problems of manual data entry, the first problem that needs to be solved is that the platform backend needs to be able to detect in real time the channel information (channel information is included in the media parameters) of an application application application account and user account that the business layer backend has created or modified.

[0071] In S2, the online status of an application can be queried based on channel information. When it is confirmed that the application is online, the data can be sorted out in a timely manner and a table can be created.

[0072] Furthermore, S3 includes:

[0073] If the online status is "online", determine whether the channel information contains dimension table data;

[0074] If so, call the trigger launch interface to obtain interface information, and obtain the creation signal based on the interface information;

[0075] If not, add basic fields to the channel information.

[0076] In the above implementation process, if the online status is "online", it means that the application's backend is in use. Timely receipt of the creation signal can avoid the loss of information and data and facilitate the fastest table creation.

[0077] While saving data, the application platform's backend needs to query the platform to see if the application account and user account are online. If they are online and no dimension table has been created, a dimension table will be created based on the creation signal.

[0078] The trigger point for automatically creating dimension tables is when a merchant clicks "confirm launch" on the official website or other systems, and then calls the launch ESA interface of the open banking platform to trigger the launch interface. Therefore, automatically creating dimension tables requires obtaining interface information and obtaining the creation signal based on the interface information.

[0079] Furthermore, S4 includes:

[0080] Obtain background information from the application based on the created signal;

[0081] Extract application product information from the backend information;

[0082] Select the user mode in the application based on the application product information.

[0083] In the above implementation process, timely acquisition of application background information based on the creation signal can greatly shorten the effective time for the background information to form business statistics tables, and effectively improve the timeliness of subsequent table creation.

[0084] Further, the step of selecting the user mode in the application based on the application product information includes:

[0085] If the application product information includes a successful cooperation status, the selected user mode is the asynchronous call mode;

[0086] If the application product information does not include a successful collaboration status, the selected user mode is the observer mode.

[0087] In the above implementation process, if the application product information includes a successful cooperation status, it means that the table can be created directly. If the application product information does not include a successful cooperation status, the observer pattern is selected to observe in real time, which can maintain the application's data security.

[0088] To enhance user experience, this application embodiment adopts an asynchronous call mode and an observer mode. The automatic creation will only be triggered after the user's application product cooperation is successfully displayed in the extracted background information.

[0089] Furthermore, S6 includes:

[0090] Populate the account data field in the dimension table information to obtain the populated dimension table information;

[0091] Create a business statistics table based on the populated dimension table information.

[0092] In the above implementation process, the account data field in the dimension table information is populated so that the dimension table information contains the basic fields required for subsequent table creation, saving the time of searching for fields when creating the table.

[0093] In this embodiment of the application, to ensure that the data generated by automatically creating dimension table information is different from the data created manually, the creator and updater fields in the database are automatically filled with "system", while the two manually created fields are filled with the um number of the backend logged-in user.

[0094] To ensure system security and availability, the dimension table information automatically created by the system can be edited and manually modified by operations staff.

[0095] The account data fields include key information such as the referrer's account and the branch of business they belong to, which are used for business statistics of each branch and each business development personnel. However, these two fields cannot be obtained in the logic of automatically creating dimension tables. Therefore, the entry of these two fields is added to the approval process of the workflow platform triggered by the merchant clicking on the online application. After the approver enters the data and the workflow platform completes the review, it will trigger a listener and read these two fields, which will be added to the field population of the automatically created dimension table, thereby solving the business statistics problem.

[0096] The statistical issues of open banking business have been upgraded from manual data entry to automated system creation. This has enabled the linkage and data interaction of multiple parameters, including the open banking website, platform, process platform, and business layer media parameter backend system, automating complex business logic and solving the bottleneck of manpower and the lag in business data entry.

[0097] Furthermore, it effectively improves the system's availability and intelligence, providing systemic support for evaluating the operational efficiency of open banking services.

[0098] Furthermore, the steps for creating a business statistics table based on the populated dimension table information include:

[0099] Approving the account data field in the populated dimension table information yields monitoring information.

[0100] Read business statistics fields based on the monitoring information;

[0101] The business statistics fields are populated into the dimension table information to obtain the business statistics table.

[0102] In the above implementation process, the business statistics fields are read based on the listening information and populated, so that the obtained business statistics table can be directly generated to contain business statistics data without the need for manual generation.

[0103] Furthermore, after the step of creating a business statistics table based on the dimension table information, the following steps are also included:

[0104] Synchronize business statistics tables online.

[0105] During the above implementation process, the business statistics table is synchronized online to ensure that the business statistics table can be queried in real time and to avoid business data being ignored.

[0106] Example 2

[0107] In order to execute the method corresponding to Embodiment 1 above and achieve the corresponding functions and technical effects, a device for creating business statistics tables is provided below, such as... Figure 2 As shown, the device includes:

[0108] Module 1 is used to obtain channel information;

[0109] Query module 2 is used to query the online status of an application based on channel information;

[0110] Signal acquisition module 3 is used to obtain the creation signal based on the online status;

[0111] Pattern acquisition module 4 is used to obtain the user pattern in the application based on the creation signal;

[0112] Module 5 is used to create dimension table information based on user patterns in the application; it is also used to create business statistics tables based on dimension table information.

[0113] In the above implementation process, the creation signal is obtained by querying the online status of the application, and the creation mode is obtained based on the creation signal, thereby creating dimension table information and business statistics tables. This can improve the efficiency of creating business statistics tables, reduce the probability of errors in business statistics tables, make the effective time of business statistics more accurate, reduce manpower, and reduce time costs.

[0114] Furthermore, the signal acquisition module 3 includes:

[0115] If the online status is "online", determine whether the channel information contains dimension table data;

[0116] If so, call the trigger launch interface to obtain interface information, and obtain the creation signal based on the interface information;

[0117] If not, add basic fields to the channel information.

[0118] In the above implementation process, if the online status is "online", it means that the application's backend is in use. Timely receipt of the creation signal can avoid the loss of information and data and facilitate the fastest table creation.

[0119] Furthermore, the pattern acquisition module 4 includes:

[0120] Obtain background information from the application based on the created signal;

[0121] Extract application product information from the backend information;

[0122] Select the user mode in the application based on the application product information.

[0123] In the above implementation process, timely acquisition of application background information based on the creation signal can greatly shorten the effective time for the background information to form business statistics tables, and effectively improve the timeliness of subsequent table creation.

[0124] Further, the step of selecting the user mode in the application based on the application product information includes:

[0125] If the application product information includes a successful cooperation status, the selected user mode is the asynchronous call mode;

[0126] If the application product information does not include a successful collaboration status, the selected user mode is the observer mode.

[0127] In the above implementation process, if the application product information includes a successful cooperation status, it means that the table can be created directly. If the application product information does not include a successful cooperation status, the observer pattern is selected to observe in real time, which can maintain the application's data security.

[0128] Furthermore, the creation of module 5 includes:

[0129] Populate the account data field in the dimension table information to obtain the populated dimension table information;

[0130] Create a business statistics table based on the populated dimension table information.

[0131] In the above implementation process, the account data field in the dimension table information is populated so that the dimension table information contains the basic fields required for subsequent table creation, saving the time of searching for fields when creating the table.

[0132] Furthermore, the steps for creating a business statistics table based on the populated dimension table information include:

[0133] Approving the account data field in the populated dimension table information yields monitoring information.

[0134] Read business statistics fields based on the monitoring information;

[0135] The business statistics fields are populated into the dimension table information to obtain the business statistics table.

[0136] In the above implementation process, the business statistics fields are read based on the listening information and populated, so that the obtained business statistics table can be directly generated to contain business statistics data without the need for manual generation.

[0137] Furthermore, such as Figure 3 As shown, the device also includes a synchronization module 6, used for:

[0138] Synchronize business statistics tables online.

[0139] During the above implementation process, the business statistics table is synchronized online to ensure that the business statistics table can be queried in real time and to avoid business data being ignored.

[0140] The apparatus for creating the aforementioned business statistics table can implement the method of Embodiment 1. The options in Embodiment 1 also apply to this embodiment, and will not be detailed here.

[0141] The remaining contents of this embodiment can be referred to the contents of Embodiment 1 above, and will not be repeated in this embodiment.

[0142] Example 3

[0143] This application provides an electronic device, including a memory and a processor. The memory stores a computer program, and the processor runs the computer program to enable the electronic device to execute the business statistics table creation method of Embodiment 1.

[0144] Alternatively, the aforementioned electronic device may be a server.

[0145] Please see Figure 4 , Figure 4 This is a schematic diagram illustrating the structural composition of an electronic device provided in an embodiment of this application. The electronic device may include a processor 41, a communication interface 42, a memory 43, and at least one communication bus 44. The communication bus 44 is used to enable direct communication between these components. In this embodiment, the communication interface 42 is used for signaling or data communication with other node devices. The processor 41 may be an integrated circuit chip with signal processing capabilities.

[0146] The processor 41 described above can be a general-purpose processor, including a central processing unit (CPU), a network processor (NP), etc.; it can also be a digital signal processor (DSP), an application-specific integrated circuit (ASIC), an off-the-shelf programmable gate array (FPGA), or other programmable logic devices, discrete gate or transistor logic devices, or discrete hardware components. It can implement or execute the methods, steps, and logic block diagrams disclosed in the embodiments of this application. The general-purpose processor can be a microprocessor, or the processor 41 can be any conventional processor.

[0147] The memory 43 may be, but is not limited to, random access memory (RAM), read-only memory (ROM), programmable read-only memory (PROM), erasable programmable read-only memory (EPROM), electrically erasable programmable read-only memory (EEPROM), etc. The memory 43 stores computer-readable instructions. When these computer-readable instructions are executed by the processor 41, the device can perform the aforementioned operations. Figure 1 The various steps involved in the method implementation examples.

[0148] Optionally, the electronic device may also include a storage controller and an input / output unit. The memory 43, storage controller, processor 41, peripheral interface, and input / output unit are electrically connected directly or indirectly to each other to achieve data transmission or interaction. For example, these components can be electrically connected to each other via a communication bus 44. The processor 41 is used to execute executable modules stored in the memory 43, such as software function modules or computer programs included in the device.

[0149] Input / output units are used to enable users to create tasks and set optional start periods or preset execution times for those tasks, facilitating user-server interaction. Input / output units can be, but are not limited to, a mouse and keyboard.

[0150] Understandable. Figure 4 The structure shown is for illustrative purposes only; the electronic device may also include components that are more advanced than those shown. Figure 4 The more or fewer components shown, or having the same Figure 4 The different configurations shown. Figure 4 The components shown can be implemented using hardware, software, or a combination thereof.

[0151] In addition, this application also provides a computer-readable storage medium storing a computer program that, when executed by a processor, implements the method for creating a business statistics table as described in Embodiment 1.

[0152] This application also provides a computer program product that, when run on a computer, causes the computer to perform the method described in the method embodiment.

[0153] In the several embodiments provided in this application, it should be understood that the disclosed apparatus and methods can also be implemented in other ways. The apparatus embodiments described above are merely illustrative; for example, the flowcharts and block diagrams in the accompanying drawings illustrate the architecture, functionality, and operation of possible implementations of apparatus, methods, and computer program products according to various embodiments of this application. In this regard, each block in a flowchart or block diagram may represent a module, segment, or portion of code containing one or more executable instructions for implementing a specified logical function. It should also be noted that in some alternative implementations, the functions marked in the blocks may occur in a different order than those marked in the drawings. For example, two consecutive blocks may actually be executed substantially in parallel, and they may sometimes be executed in reverse order, depending on the functions involved. It should also be noted that each block in a block diagram and / or flowchart, and combinations of blocks in block diagrams and / or flowcharts, can be implemented using dedicated hardware-based apparatus that performs the specified function or action, or using a combination of dedicated hardware and computer instructions.

[0154] In addition, the functional modules in the various embodiments of this application can be integrated together to form an independent part, or each module can exist independently, or two or more modules can be integrated to form an independent part.

[0155] If the aforementioned functions are implemented as software functional modules and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of this application, in essence, or the part that contributes to the prior art, or a portion of the technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute all or part of the steps of the methods described in the various embodiments of this application. The aforementioned storage medium includes various media capable of storing program code, such as USB flash drives, external hard drives, ROM, RAM, magnetic disks, or optical disks.

[0156] The above description is merely an embodiment of this application and is not intended to limit the scope of protection of this application. Various modifications and variations can be made to this application by those skilled in the art. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of this application should be included within the scope of protection of this application. It should be noted that similar reference numerals and letters in the following figures indicate similar items; therefore, once an item is defined in one figure, it does not need to be further defined and explained in subsequent figures.

[0157] The above description is merely a specific embodiment of this application, but the scope of protection of this application is not limited thereto. Any variations or substitutions that can be easily conceived by those skilled in the art within the scope of the technology disclosed in this application should be included within the scope of protection of this application. Therefore, the scope of protection of this application should be determined by the scope of protection of the claims.

[0158] It should be noted that, in this document, relational terms such as "first" and "second" are used only to distinguish one entity or operation from another, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Furthermore, the terms "comprising," "including," or any other variations thereof are intended to cover non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such a process, method, article, or apparatus. Without further limitations, an element defined by the phrase "comprising one..." does not exclude the presence of other identical elements in the process, method, article, or apparatus that includes said element.

Claims

1. A method for creating a business statistics table, characterized in that, The method includes: Obtain channel information; The online status of the application can be queried based on the channel information. The creation signal is obtained based on the online status; The user mode in the application is obtained based on the creation signal; Create dimension table information based on the user patterns described in the application; Create the business statistics table based on the dimension table information; The step of obtaining the creation signal based on the online status includes: If the online status is "online", determine whether the channel information contains dimension table data; If so, call the trigger online interface to obtain interface information, and obtain the creation signal based on the interface information; If not, add basic fields to the channel information; The step of obtaining the user mode in the application based on the creation signal includes: The background information in the application is obtained based on the creation signal; Extract application product information from the background information; Select the user mode in the application based on the application product information; The step of selecting the user mode in the application based on the application product information includes: If the application product information includes a successful cooperation status, the selected user mode is the asynchronous call mode; If the application product information does not include a successful cooperation status, the selected user mode is the observer mode.

2. The method for creating a business statistics table according to claim 1, characterized in that, The step of creating the business statistics table based on the dimension table information includes: The account data field in the dimension table information is populated to obtain the populated dimension table information; The business statistics table is created based on the populated dimension table information.

3. The method for creating a business statistics table according to claim 2, characterized in that, The step of creating the business statistics table based on the populated dimension table information includes: The account data field in the populated dimension table information is approved to obtain monitoring information; Read the business statistics fields based on the monitoring information; The business statistics fields are populated into the dimension table information to obtain the business statistics table.

4. The method for creating a business statistics table according to claim 3, characterized in that, Following the step of creating the business statistics table based on the dimension table information, the method further includes: Synchronize the aforementioned business statistics tables online.

5. A device for creating business statistics tables, characterized in that, The device includes: The acquisition module is used to acquire channel information; The query module is used to query the online status of the application based on the channel information; The signal acquisition module is used to acquire a creation signal based on the online status; A pattern acquisition module is used to obtain the user pattern in the application based on the creation signal; A creation module is used to create dimension table information based on the user patterns in the application; it is also used to create the business statistics table based on the dimension table information. The signal acquisition module is also used for: If the online status is "online", determine whether the channel information contains dimension table data; If so, call the trigger online interface to obtain interface information, and obtain the creation signal based on the interface information; If not, add basic fields to the channel information; The pattern acquisition module is also used for: The background information in the application is obtained based on the creation signal; Extract application product information from the background information; Select the user mode in the application based on the application product information; If the application product information includes a successful cooperation status, the selected user mode is the asynchronous call mode; If the application product information does not include a successful cooperation status, the selected user mode is the observer mode.

6. An electronic device, characterized in that, The device includes a memory and a processor, the memory being used to store a computer program, and the processor running the computer program to cause the electronic device to perform the method for creating a business statistics table according to any one of claims 1 to 4.

7. A storage medium, characterized in that, It stores a computer program that, when executed by a processor, implements the method for creating a business statistics table as described in any one of claims 1 to 4.

Images