CN116991913A - Method and device for creating business statistics table, electronic equipment and storage medium - Google Patents

Method and device for creating business statistics table, electronic equipment and storage medium Download PDF

Info

Publication number
CN116991913A
CN116991913A CN202310679814.1A CN202310679814A CN116991913A CN 116991913 A CN116991913 A CN 116991913A CN 202310679814 A CN202310679814 A CN 202310679814A CN 116991913 A CN116991913 A CN 116991913A
Authority
CN
China
Prior art keywords
information
creating
application
obtaining
statistics table
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202310679814.1A
Other languages
Chinese (zh)
Inventor
关盼盼
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Ping An Bank Co Ltd
Original Assignee
Ping An Bank Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Ping An Bank Co Ltd filed Critical Ping An Bank Co Ltd
Priority to CN202310679814.1A priority Critical patent/CN116991913A/en
Publication of CN116991913A publication Critical patent/CN116991913A/en
Pending legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/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/24—Querying
    • G06F16/248—Presentation of query results
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/174—Form filling; Merging
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00—Handling natural language data
    • G06F40/10—Text processing
    • G06F40/166—Editing, e.g. inserting or deleting
    • G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/02—Banking, e.g. interest calculation or account maintenance

Abstract

The embodiment of the application provides a method, a device, electronic equipment and a storage medium for creating a business statistics table, wherein the method comprises the following steps: obtaining channel information; inquiring the online state of the application according to the channel information; obtaining a creation signal according to the upper line state; obtaining a user mode in the application according to the creation signal; creating dimension table information according to a user mode in the application; and creating the business statistics table according to the dimension table information. By implementing the embodiment of the application, the efficiency of creating the service statistics form can be improved, the error probability of the service statistics form is reduced, the service statistics effective time is more accurate, the manpower is reduced, and the time cost is reduced.

Description

Method and device for creating business statistics table, electronic equipment and storage medium
Technical Field
The present application relates to the field of data processing technologies, and in particular, to a method and apparatus for creating a service statistics table, an electronic device, and a storage medium.
Background
For multi-service and multi-channel cooperation processes, for example, when banks expand and dock with multiple merchants, the banks need to finish service statistics by cooperation of multiple parties such as each branch, foreground merchant and operator, the needed processes are more, generally, the merchants register, cooperate products and apply for approval flows, develop and test environment joint debugging, apply for online and approve flows, approve completion and confirm online, so that when the creation of the current multi-service and complex services depends on the manual new establishment of a maintenance table by operators, the check of whether the cooperation states of an application account and a user account in the back end of a platform are online or not is needed, the check of whether the application account and the user account generate channel information is needed in a back end system of media parameters of an open bank service layer, the search of the existing maintenance table in the back end of the platform is not temporarily established and the channel information is temporarily not available in the maintenance table, and finally only a maintenance table can be clicked, but also the confirmation of the above-mentioned processes need to be carried out for each product of each application cooperation of each merchant, so that the manual operation and time lag exists, the subsequent statistics is needed, the establishment of the operation is not be carried out, and the time is very accurate, and the operation is very poor, and the time is easy to take place, and the operation is easy.
Disclosure of Invention
The embodiment of the application aims to provide a method, a device, electronic equipment and a storage medium for creating a business statistics table, which can improve the efficiency of creating the business statistics table, reduce the error probability of the business statistics table, enable the business statistics to take effect more accurately, reduce manpower and reduce time cost.
In a first aspect, an embodiment of the present application provides a method for creating a service statistics table, where the method includes:
obtaining channel information;
inquiring the online state of the application according to the channel information;
obtaining a creation signal according to the upper line state;
obtaining a user mode in the application according to the creation signal;
creating dimension table information according to a user mode in the application;
and creating the business statistics table according to the dimension table information.
In the implementation process, the creation signal is obtained after the upper line of the application is queried, and the creation mode is obtained according to the creation signal, so that the maintenance table information and the service statistics table are created, the efficiency of creating the service statistics table can be improved, the error probability of the service statistics table is reduced, the service statistics effective time is more accurate, the manpower is reduced, and the time cost is reduced.
Further, the step of obtaining the creation signal according to the upload state includes:
if the online status is online, judging whether the channel information contains dimension table data or not;
if yes, calling and triggering an online interface to obtain interface information, and obtaining the creation signal according to the interface information;
if not, adding a basic field in the channel information.
In the implementation process, if the online state is online, the background of the application is in the use process, and the creation signal is timely obtained, so that the loss of information and data can be avoided, and the creation of the table can be initiated at the highest speed conveniently.
Further, the step of obtaining the user mode in the application according to the creation signal includes:
obtaining background information in the application according to the creation signal;
extracting application product information in the background information;
and selecting the user mode in the application according to the application product information.
In the implementation process, the background information of the application is timely obtained according to the creation signal, so that the effective time of forming the business statistics form by the background information is greatly shortened, and the timeliness of the subsequent creation form can be effectively improved.
Further, the step of selecting the user mode in the application according to the application product information includes:
if the application product information contains a cooperation success state, the selected user mode is an asynchronous call mode;
and if the application product information does not contain the cooperation success state, the selected user mode is an observer mode.
In the implementation process, if the application product information contains the cooperation success state, the creation of the table can be directly performed, and if the application product information does not contain the cooperation success state, the observer mode is selected for real-time observation, so that the data security of the application can be maintained.
Further, the step of creating the service statistics table according to the dimension table information includes:
filling account data fields in the dimension table information to obtain the filled dimension table information;
and creating the business statistics table according to the filled dimension table information.
In the implementation process, account data fields in the dimension table information are filled, so that the dimension table information contains basic fields required for subsequently creating the table, and the time for searching the fields in the created table is saved.
Further, the step of creating the service statistics table according to the filled dimension table information includes:
examining and approving the account data field in the filled dimension table information to obtain monitoring information;
reading a service statistics field according to the monitoring information;
and filling the service statistics field into the dimension table information to obtain the service statistics table.
In the implementation process, the service statistics field is read according to the monitoring information, and the service statistics field is filled, so that the obtained service statistics table can directly generate the service statistics data without manual generation.
Further, after the step of creating the service statistics table according to the dimension table information, the method further includes:
and carrying out on-line synchronization on the service statistics table.
In the implementation process, the service statistics form is subjected to on-line synchronization, so that the service statistics form can be queried in real time, and service data is prevented from being ignored.
In a second aspect, an embodiment of the present application further provides a device for creating a service statistics table, where the device includes:
the acquisition module is used for acquiring channel information;
the query module is used for querying the online state of the application according to the channel information;
the signal obtaining module is used for obtaining a creation signal according to the upper line state;
a mode obtaining module, configured to obtain a user mode in the application according to the creation signal;
the creation module is used for creating the dimension table information according to the user mode in the application; and the service statistics table is also established according to the dimension table information.
In the implementation process, the creation signal is obtained after the upper line of the application is queried, and the creation mode is obtained according to the creation signal, so that the maintenance table information and the service statistics table are created, the efficiency of creating the service statistics table can be improved, the error probability of the service statistics table is reduced, the service statistics effective time is more accurate, the manpower is reduced, and the time cost is reduced.
In a third aspect, an electronic device provided in an embodiment of the present application includes: a memory, a processor and a computer program stored in the memory and executable on the processor, the processor implementing the steps of the method according to any one of the first aspects when the computer program is executed.
In a fourth aspect, an embodiment of the present application provides a computer readable storage medium, where instructions are stored, when the instructions are executed on a computer, to cause the computer to perform the method according to any one of the first aspects.
In a fifth aspect, embodiments of the present application provide a computer program product, which when run on a computer causes the computer to perform the method according to any of the first aspects.
Additional features and advantages of the disclosure will be set forth in the description which follows, or in part will be obvious from the description, or may be learned by practice of the techniques of the disclosure.
And can be implemented in accordance with the teachings of the specification, the following detailed description of the preferred embodiments of the application, taken in conjunction with the accompanying drawings.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings that are needed in the embodiments of the present application will be briefly described below, it should be understood that the following drawings only illustrate some embodiments of the present application and should not be construed as limiting the scope values, and other related drawings can be obtained according to the drawings without inventive effort for a person skilled in the art.
Fig. 1 is a flow chart of a method for creating a service statistics table according to an embodiment of the present application;
fig. 2 is a schematic structural diagram of a device for creating a service statistics table according to an embodiment of the present application;
fig. 3 is a schematic structural diagram of another device for creating a service statistics table according to an embodiment of the present application;
fig. 4 is a schematic structural diagram of an electronic device according to an embodiment of the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be described below with reference to the accompanying drawings in the embodiments of the present application.
It should be noted that: like reference numerals and letters denote like items in the following figures, and thus once an item is defined in one figure, no further definition or explanation thereof is necessary in the following figures. Meanwhile, in the description of the present application, the terms "first", "second", and the like are used only to distinguish the description, and are not to be construed as indicating or implying relative importance.
The following describes in further detail the embodiments of the present application with reference to the drawings and examples. The following examples are illustrative of the application and are not intended to limit the scope of the application.
Example 1
Fig. 1 is a flow chart of a method for creating a service statistics table according to an embodiment of the present application, as shown in fig. 1, where the method includes:
s1, obtaining channel information;
s2, inquiring the online state of the application according to the channel information;
s3, obtaining a creation signal according to the up state;
s4, obtaining a user mode in the application according to the creation signal;
s5, creating dimension table information according to a user mode in the application;
s6, creating a business statistics table according to the dimension table information.
In the implementation process, the creation signal is obtained after the upper line of the application is queried, and the creation mode is obtained according to the creation signal, so that the maintenance table information and the service statistics table are created, the efficiency of creating the service statistics table can be improved, the error probability of the service statistics table is reduced, the service statistics effective time is more accurate, the manpower is reduced, and the time cost is reduced.
The embodiment of the application can be used in the expansion and butt joint process of banks and merchants, and in order to better support statistics of each branch business of the banks, the information of attribution branches, recommenders UM and the like of each project is required to be input and maintained in the system, and then the information is pushed to a data warehouse to further process data so as to calculate the branch business, and the mode of manually inputting channel maintenance forms in a background management system of an open bank is adopted at present.
Meanwhile, the existing manual entry form has many problems, for example, when a general operator manually builds a maintenance form, whether the cooperation state of an application account and a user account in the back end of a platform is online needs to be checked, whether channel information is generated by the application account and the user account in a media parameter back end system of an open bank business layer is checked, the existing maintenance form at the back end of the platform is searched for, the maintenance form is not created temporarily, the channel information is not exist and is available in the maintenance form temporarily, and finally, a newly-built maintenance form can be clicked, so that the creation of the business statistics form has a manual operation bottleneck and time hysteresis.
In order to solve the problems, the embodiment of the application applies an intelligent mode of automatically creating the dimension table, so that the business statistics table can be automatically created.
In S1, in order to solve the problem existing in manual entry, the first problem to be solved is that the platform back end needs to perceive in real time that a certain application cooperation product application account number and channel information of the user account number (the channel information is included in the media parameters) have been created or modified by the service layer back end.
In S2, the online state of the application is queried according to the channel information, and when the application is determined to be in the online state, the data can be combed in time, and a table is created.
Further, S3 includes:
if the online state is online, judging whether the channel information contains the dimension table data;
if yes, calling to trigger an online interface to obtain interface information, and obtaining a creation signal according to the interface information;
if not, adding a basic field in the channel information.
In the implementation process, if the online state is online, the background of the application is in the use process, and the creation signal is timely obtained, so that the loss of information and data can be avoided, and the creation of the table can be initiated at the highest speed conveniently.
The background of the application platform needs to go to the platform to inquire whether the application account number and the user account number are online or not while storing the data, and if the application account number and the user account number are online and the dimension table is not created, a piece of dimension table information is created according to the creation signal at the moment.
When the merchant clicks to confirm the online or other systems, the online ESA interface of the open bank platform is called in an ESA interface calling mode to trigger the online interface, so that the automatic creation of the dimension form needs to obtain interface information and a creation signal is obtained according to the interface information.
Further, S4 includes:
obtaining background information in the application according to the creation signal;
extracting application product information in the background information;
and selecting a user mode in the application according to the application product information.
In the implementation process, the background information of the application is timely obtained according to the creation signal, so that the effective time of forming the business statistics form by the background information is greatly shortened, and the timeliness of the subsequent creation form can be effectively improved.
Further, the step of selecting the user mode in the application according to the application product information includes:
if the application product information contains a cooperation success state, the selected user mode is an asynchronous call mode;
if the application product information does not contain the cooperation success state, the selected user mode is an observer mode.
In the implementation process, if the application product information contains the cooperation success state, the creation of the table can be directly performed, and if the application product information does not contain the cooperation success state, the observer mode is selected for real-time observation, so that the data security of the application can be maintained.
In order to improve user experience, the embodiment of the application adopts an asynchronous call mode and an observer mode, and the product information in the extracted background information displays that the application product of the user is successfully cooperated and then triggers automatic creation.
Further, S6 includes:
filling account data fields in the dimension table information to obtain filled dimension table information;
and creating a business statistics table according to the filled dimension table information.
In the implementation process, account data fields in the dimension table information are filled, so that the dimension table information contains basic fields required for subsequently creating the table, and the time for searching the fields in the created table is saved.
In order to ensure that data generated by automatically creating the dimension table information is distinguished from manually created data, fields of a creator and an updater are automatically filled into a system in a database, and the manually created fields are respectively filled with um numbers of a user logging in at the rear end of reading.
To ensure the security and availability of the system, the automatically created dimension table information of the system subsequently supports editing and manual modification of operation.
The account data field comprises an account number of a key information recommender and a belonging branch field, which are used for making business statistics of each branch and each business expansion person, but the two fields cannot be obtained in logic of automatically creating a maintenance table, so that the input links of the two fields are put in a process platform approval link triggered by clicking an online application by a merchant to add the input of the two fields, and after the approval person inputs, the process platform is inspected, the monitoring is triggered, the two fields are read, and the process platform is supplemented into field filling of automatically creating the maintenance table, thereby solving the business statistics problem.
The open banking business statistical problem is improved from manual input to automatic system creation, the linkage and data interaction of a plurality of parameters such as an open banking official network, a platform, a flow platform, a business layer media parameter back-end system and the like are completed, the business complex logic is automated, and the human bottleneck and the hysteresis of business data input are solved.
And the availability and the intellectualization of the system are effectively improved, and the system support function is played for the operation efficiency inspection of the open banking business.
Further, the step of creating a business statistics table according to the filled dimension table information comprises the following steps:
examining and approving account data fields in the filled dimension table information to obtain monitoring information;
reading a service statistics field according to the monitoring information;
and filling the service statistics field into the dimension table information to obtain a service statistics table.
In the implementation process, the service statistics field is read according to the monitoring information, and the service statistics field is filled, so that the obtained service statistics table can directly generate the service statistics data without manual generation.
Further, after the step of creating the service statistics table according to the dimension table information, the method further comprises:
and carrying out on-line synchronization on the business statistics table.
In the implementation process, the service statistics form is subjected to on-line synchronization, so that the service statistics form can be queried in real time, and service data is prevented from being ignored.
Example two
In order to execute a corresponding method of the above embodiment to achieve the corresponding functions and technical effects, a device for creating a service statistics table is provided below, as shown in fig. 2, where the device includes:
the acquisition module 1 is used for acquiring channel information;
the query module 2 is used for querying the online state of the application according to the channel information;
a signal obtaining module 3, configured to obtain a creation signal according to the upper line status;
a mode obtaining module 4 for obtaining a user mode in the application according to the creation signal;
a creating module 5, configured to create the dimension table information according to the user mode in the application; and is also used for creating a business statistics table according to the dimension table information.
In the implementation process, the creation signal is obtained after the upper line of the application is queried, and the creation mode is obtained according to the creation signal, so that the maintenance table information and the service statistics table are created, the efficiency of creating the service statistics table can be improved, the error probability of the service statistics table is reduced, the service statistics effective time is more accurate, the manpower is reduced, and the time cost is reduced.
Further, the signal obtaining module 3 includes:
if the online state is online, judging whether the channel information contains the dimension table data;
if yes, calling to trigger an online interface to obtain interface information, and obtaining a creation signal according to the interface information;
if not, adding a basic field in the channel information.
In the implementation process, if the online state is online, the background of the application is in the use process, and the creation signal is timely obtained, so that the loss of information and data can be avoided, and the creation of the table can be initiated at the highest speed conveniently.
Further, the mode obtaining module 4 includes:
obtaining background information in the application according to the creation signal;
extracting application product information in the background information;
and selecting a user mode in the application according to the application product information.
In the implementation process, the background information of the application is timely obtained according to the creation signal, so that the effective time of forming the business statistics form by the background information is greatly shortened, and the timeliness of the subsequent creation form can be effectively improved.
Further, the step of selecting the user mode in the application according to the application product information includes:
if the application product information contains a cooperation success state, the selected user mode is an asynchronous call mode;
if the application product information does not contain the cooperation success state, the selected user mode is an observer mode.
In the implementation process, if the application product information contains the cooperation success state, the creation of the table can be directly performed, and if the application product information does not contain the cooperation success state, the observer mode is selected for real-time observation, so that the data security of the application can be maintained.
Further, the creation module 5 includes:
filling account data fields in the dimension table information to obtain filled dimension table information;
and creating a business statistics table according to the filled dimension table information.
In the implementation process, account data fields in the dimension table information are filled, so that the dimension table information contains basic fields required for subsequently creating the table, and the time for searching the fields in the created table is saved.
Further, the step of creating a business statistics table according to the filled dimension table information comprises the following steps:
examining and approving account data fields in the filled dimension table information to obtain monitoring information;
reading a service statistics field according to the monitoring information;
and filling the service statistics field into the dimension table information to obtain a service statistics table.
In the implementation process, the service statistics field is read according to the monitoring information, and the service statistics field is filled, so that the obtained service statistics table can directly generate the service statistics data without manual generation.
Further, as shown in fig. 3, the apparatus further comprises a synchronization module 6 for:
and carrying out on-line synchronization on the business statistics table.
In the implementation process, the service statistics form is subjected to on-line synchronization, so that the service statistics form can be queried in real time, and service data is prevented from being ignored.
The above-described creation apparatus of the traffic statistics table may implement the method of the above-described first embodiment. The options in the first embodiment described above also apply to this embodiment, and are not described in detail here.
The rest of the embodiments of the present application may refer to the content of the first embodiment, and in this embodiment, no further description is given.
Example III
The embodiment of the application provides an electronic device, which comprises a memory and a processor, wherein the memory is used for storing a computer program, and the processor runs the computer program to enable the electronic device to execute the method for creating the business statistics table in the first embodiment.
Alternatively, the electronic device may be a server.
Referring to fig. 4, fig. 4 is a schematic structural diagram of an electronic device according to an embodiment of the present application. The electronic device may include a processor 41, a communication interface 42, a memory 43, and at least one communication bus 44. Wherein the communication bus 44 is used to enable direct connection communication of these components. The communication interface 42 of the device in the embodiment of the present application is used for performing signaling or data communication with other node devices. The processor 41 may be an integrated circuit chip with signal processing capabilities.
The processor 41 may be a general-purpose processor including a central processing unit (Central Processing Unit, CPU), a network processor (Network Processor, NP), etc.; but may also be a Digital Signal Processor (DSP), application Specific Integrated Circuit (ASIC), an off-the-shelf programmable gate array (FPGA) or other programmable logic device, discrete gate or transistor logic device, discrete hardware components. The disclosed methods, steps, and logic blocks in the embodiments of the present application may be implemented or performed. The general purpose processor may be a microprocessor or the processor 41 may be any conventional processor or the like.
The Memory 43 may be, but is not limited to, random access Memory (Random Access Memory, RAM), read Only Memory (ROM), programmable Read Only Memory (Programmable Read-Only Memory, PROM), erasable Read Only Memory (Erasable Programmable Read-Only Memory, EPROM), electrically erasable Read Only Memory (Electric Erasable Programmable Read-Only Memory, EEPROM), etc. The memory 43 has stored therein computer readable instructions which, when executed by the processor 41, enable the apparatus to perform the steps described above in relation to the embodiment of the method of fig. 1.
Optionally, the electronic device may further include a storage controller, an input-output unit. The memory 43, the memory controller, the processor 41, the peripheral interface, and the input/output unit are electrically connected directly or indirectly to each other to realize data transmission or interaction. For example, the components may be electrically coupled to each other via one or more communication buses 44. The processor 41 is arranged to execute executable modules stored in the memory 43, such as software functional modules or computer programs comprised by the device.
The input-output unit is used for providing the user with the creation task and creating the starting selectable period or the preset execution time for the task so as to realize the interaction between the user and the server. The input/output unit may be, but is not limited to, a mouse, a keyboard, and the like.
It will be appreciated that the configuration shown in fig. 4 is merely illustrative, and that the electronic device may also include more or fewer components than shown in fig. 4, or have a different configuration than shown in fig. 4. The components shown in fig. 4 may be implemented in hardware, software, or a combination thereof.
In addition, the embodiment of the present application further provides a computer readable storage medium storing a computer program, where the computer program when executed by a processor implements the method for creating a service statistics table according to the first embodiment.
The present application also provides a computer program product which, when run on a computer, causes the computer to perform the method described in the method embodiments.
In the several embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other manners. The apparatus embodiments described above are merely illustrative, for example, of the flowcharts and block diagrams in the figures that illustrate the architecture, functionality, and operation of possible implementations of apparatus, methods and computer program products according to various embodiments of the present application. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based devices which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
In addition, functional modules in the embodiments of the present application may be integrated together to form a single part, or each module may exist alone, or two or more modules may be integrated to form a single part.
The functions, if implemented in the form of software functional modules and sold or used as a stand-alone product, may be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application may be embodied essentially or in a part contributing to the prior art or in a part of the technical solution, in the form of a software product stored in a storage medium, comprising several instructions for causing a computer device (which may be a personal computer, a server, a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: a usb disk, a removable hard disk, a ROM, a RAM, a magnetic disk, or an optical disk, etc.
The above description is only an example of the present application and is not intended to limit the scope of the present application, and various modifications and variations will be apparent to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the protection scope of the present application. It should be noted that: like reference numerals and letters denote like items in the following figures, and thus once an item is defined in one figure, no further definition or explanation thereof is necessary in the following figures.
The above description is merely illustrative of the present application, but the scope of the present application is not limited thereto, and any person skilled in the art can easily think about variations or substitutions within the scope of the present application, and the application is intended to be covered by the scope of the present application. Therefore, the protection scope of the present application shall be defined by the protection scope of the claims.
It is noted that relational terms such as first and second, and the like are used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Moreover, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.

Claims (10)

1. A method for creating a business statistics table, the method comprising:
obtaining channel information;
inquiring the online state of the application according to the channel information;
obtaining a creation signal according to the upper line state;
obtaining a user mode in the application according to the creation signal;
creating dimension table information according to a user mode in the application;
and creating the business statistics table according to the dimension table information.
2. The method for creating a traffic statistics table according to claim 1, wherein the step of obtaining a creation signal according to the upload state comprises:
if the online status is online, judging whether the channel information contains dimension table data or not;
if yes, calling and triggering an online interface to obtain interface information, and obtaining the creation signal according to the interface information;
if not, adding a basic field in the channel information.
3. The method for creating a traffic statistics table according to claim 1, wherein the step of obtaining the user pattern in the application from the creation signal comprises:
obtaining background information in the application according to the creation signal;
extracting application product information in the background information;
and selecting the user mode in the application according to the application product information.
4. A method of creating a business statistics form according to claim 3 wherein said step of selecting said user mode in said application based on said application product information comprises:
if the application product information contains a cooperation success state, the selected user mode is an asynchronous call mode;
and if the application product information does not contain the cooperation success state, the selected user mode is an observer mode.
5. The method of creating a business statistics table according to claim 1, wherein the step of creating the business statistics table from the dimension table information comprises:
filling account data fields in the dimension table information to obtain the filled dimension table information;
and creating the business statistics table according to the filled dimension table information.
6. The method of creating a business statistics table according to claim 4, wherein the step of creating the business statistics table from the populated dimension table information comprises:
examining and approving the account data field in the filled dimension table information to obtain monitoring information;
reading a service statistics field according to the monitoring information;
and filling the service statistics field into the dimension table information to obtain the service statistics table.
7. The method of creating a business statistics table according to claim 1, further comprising, after the step of creating the business statistics table from the dimension table information:
and carrying out on-line synchronization on the service statistics table.
8. A business statistics table creation apparatus, the apparatus comprising:
the acquisition module is used for acquiring channel information;
the query module is used for querying the online state of the application according to the channel information;
the signal obtaining module is used for obtaining a creation signal according to the upper line state;
a mode obtaining module, configured to obtain a user mode in the application according to the creation signal;
the creation module is used for creating the dimension table information according to the user mode in the application; and the service statistics table is also established according to the dimension table information.
9. An electronic device comprising a memory for storing a computer program and a processor that runs the computer program to cause the electronic device to perform the method of creating a traffic statistics table according to any one of claims 1 to 7.
10. A storage medium storing a computer program which, when executed by a processor, implements the method of creating a traffic statistics table according to any one of claims 1 to 7.
CN202310679814.1A 2023-06-08 2023-06-08 Method and device for creating business statistics table, electronic equipment and storage medium Pending CN116991913A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310679814.1A CN116991913A (en) 2023-06-08 2023-06-08 Method and device for creating business statistics table, electronic equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310679814.1A CN116991913A (en) 2023-06-08 2023-06-08 Method and device for creating business statistics table, electronic equipment and storage medium

Publications (1)

Publication Number Publication Date
CN116991913A true CN116991913A (en) 2023-11-03

Family

ID=88520244

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310679814.1A Pending CN116991913A (en) 2023-06-08 2023-06-08 Method and device for creating business statistics table, electronic equipment and storage medium

Country Status (1)

Country Link
CN (1) CN116991913A (en)

Similar Documents

Publication Publication Date Title
CN105160038B (en) Data analysis method and system based on audit database
CN106951369B (en) Management method and device for joint debugging test
WO2020073727A1 (en) Risk forecast method, device, computer apparatus, and storage medium
CN105405221A (en) Method and device for automated test
CN105868956A (en) Data processing method and device
CN116992148B (en) Intelligent matching method and system for interactive resources of meta space platform
CN108549672A (en) A kind of intelligent data analysis method and system
CN112445787A (en) Data auditing method and system based on real-time service
CN116991913A (en) Method and device for creating business statistics table, electronic equipment and storage medium
CN115827051A (en) Software integration management system, method and server
CN105405220A (en) Method and device for automated test
CN114186024A (en) Recommendation method and device
CN112507725B (en) Static publishing method, device, equipment and storage medium of financial information
CN114153860A (en) Business data management method and device, electronic equipment and storage medium
Kamil et al. Design of location-based waste collecting on enviro andalas waste bank
CN110597899A (en) Project expense management method and system
CN113408912B (en) Audit system for television station and electronic equipment
CN114611712B (en) Prediction method based on heterogeneous federated learning, model generation method and device
CN113360306B (en) Real-time fault detection method for airborne information system
CN115964409A (en) Management method, device, equipment and storage medium for system access data
CN116226105A (en) Data management method and device, electronic equipment and computer storage medium
CN113553237A (en) Emergency processing method and device for abnormal scene
CN117493403A (en) Decision stream verification method, device, equipment and storage medium
CN111160761A (en) Software development quality control method
CN117635072A (en) Quality inspection and evaluation form filling evaluation method, system and storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination