CN112035557A - Transaction log report display method and device - Google Patents
Transaction log report display method and device Download PDFInfo
- Publication number
- CN112035557A CN112035557A CN202010908008.3A CN202010908008A CN112035557A CN 112035557 A CN112035557 A CN 112035557A CN 202010908008 A CN202010908008 A CN 202010908008A CN 112035557 A CN112035557 A CN 112035557A
- Authority
- CN
- China
- Prior art keywords
- transaction log
- report
- database
- transaction
- log
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 65
- 238000003860 storage Methods 0.000 claims description 30
- 238000012545 processing Methods 0.000 claims description 28
- 238000005192 partition Methods 0.000 claims description 17
- 230000008676 import Effects 0.000 claims description 16
- 238000004590 computer program Methods 0.000 claims description 13
- 238000000638 solvent extraction Methods 0.000 claims 4
- 230000006870 function Effects 0.000 description 23
- 238000004891 communication Methods 0.000 description 14
- 238000010586 diagram Methods 0.000 description 12
- 230000008569 process Effects 0.000 description 10
- 239000000872 buffer Substances 0.000 description 4
- 238000012423 maintenance Methods 0.000 description 3
- 230000014759 maintenance of location Effects 0.000 description 3
- 238000012544 monitoring process Methods 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 238000009795 derivation Methods 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 230000002776 aggregation Effects 0.000 description 1
- 238000004220 aggregation Methods 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 230000001413 cellular effect Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000011521 glass Substances 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 230000004044 response Effects 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
- 230000003442 weekly effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/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
- 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
Abstract
The application provides a transaction log report form display method and a device, wherein the method comprises the following steps: importing a first transaction log report in a log collection database into a report database; and outputting and displaying a first transaction log report which is imported into the report database, wherein the log collection database is provided with a plurality of transaction log reports for storing transaction log information. The method and the device can improve the efficiency of displaying the transaction log report on the basis of ensuring the reliability of storing a large amount of transaction log information.
Description
Technical Field
The application relates to the technical field of data processing, in particular to a transaction log report form display method and device.
Background
At present, a production environment log collection database is used for storing transaction original logs, data processing intermediate logic, report data and the like, and used CPU read-write nodes account for 30%, read-only nodes account for 60%, and storage space accounts for 5.4 TB. Due to data pressure, the service query speed of the log report is extremely low, part of monthly reports and annual reports are difficult to derive, and the data center is difficult to display various log reports.
A large amount of and inefficient operations such as log report import, processing, query, and the like are all performed in the log collection database, which puts a great strain on single points of the log collection database.
Disclosure of Invention
Aiming at the problems in the prior art, the application provides a transaction log report display method and device, which can improve the efficiency of transaction log report display on the basis of ensuring the reliability of storing a large amount of transaction log information.
In order to solve the technical problem, the present application provides the following technical solutions:
in a first aspect, the present application provides a method for displaying a transaction log report, including:
importing a first transaction log report in a log collection database into a report database;
and outputting and displaying a first transaction log report which is imported into the report database, wherein the log collection database is provided with a plurality of transaction log reports for storing transaction log information.
Further, the log collection database stores the transaction log information in a partition mode according to preset partition rules.
Further, the transaction log report form display method further comprises the following steps: based on the partition of the log collection database, regularly importing a second transaction log report in the log collection database into the report database; processing the second transaction log report imported into the report database, and outputting and displaying the processed second transaction log report; and the import frequency corresponding to the first transaction log report is greater than that corresponding to the second transaction log report.
Further, the transaction log report form display method further comprises the following steps: receiving a transaction log query request; and determining the transaction log information corresponding to the transaction log query request from the report database according to the transaction log query request.
Further, the transaction log report form display method further comprises the following steps: receiving a reservation batch downloading request sent by a target user; exporting third transaction log reports in the log collection database in batches at a reservation time point corresponding to the reservation batch downloading request; and sending download viewing prompt information corresponding to the third transaction log report to the target user.
Further, the transaction log report form display method further comprises the following steps: and setting an index for inquiring the transaction log information in the report database.
In a second aspect, the present application provides a transaction log report display device, including:
the first import module is used for importing the first transaction log report in the log collection database into the report database;
and the first display module is used for outputting and displaying a first transaction log report which is imported into the report database, wherein the log collection database is provided with a plurality of transaction log reports for storing transaction log information.
Further, the log collection database stores the transaction log information in a partition mode according to preset partition rules.
Further, the transaction log report form display device further comprises: the second import module is used for importing a second transaction log report form in the log collection database into the report database at regular time based on the partition of the log collection database; the second display module is used for processing and then outputting and displaying a second transaction log report which is imported into the report database; and the import frequency corresponding to the first transaction log report is greater than that corresponding to the second transaction log report.
In a third aspect, the present application provides an electronic device, including a memory, a processor, and a computer program stored on the memory and executable on the processor, wherein the processor implements the transaction log report display method when executing the program.
In a fourth aspect, the present application provides a computer-readable storage medium having stored thereon computer instructions, which when executed, implement the transaction log report display method.
According to the technical scheme, the application provides a transaction log report form display method and device. Wherein, the method comprises the following steps: importing a first transaction log report in a log collection database into a report database; outputting and displaying a first transaction log report which is imported into the report database, wherein the log collection database is provided with a plurality of transaction log reports for storing transaction log information, and the efficiency of displaying the transaction log reports can be improved on the basis of ensuring the reliability of storing a large amount of transaction log information; the query efficiency can be improved, and the reliability and efficiency of transaction log information monitoring are improved; specifically, the operation and maintenance safety can be improved: the log collection database is separated from the report database, so that even if the report database is down due to large query and display data volume and the like, the collection of the transaction logs in the log collection database is not influenced, the online database is not influenced, the influence on the online transaction process caused by the query of the surface transaction logs and the like can be realized, and the reliability of the transaction process can be improved; the system storage utilization rate can be improved: for the query requirement with high real-time requirement, indexes do not need to be established for all data; separate database single point pressure: query pressure and collection pressure can be separated, and further the method can be expanded into a multi-level log cache architecture so as to reduce the interaction between the query and collection.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present application, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a schematic flow chart illustrating a transaction log report displaying method according to an embodiment of the present disclosure;
FIG. 2 is a flowchart illustrating steps 300 and 400 of a transaction log report display method according to an embodiment of the present application;
FIG. 3 is a flowchart illustrating steps 500 and 600 of a transaction log report display method according to an embodiment of the present application;
FIG. 4 is a schematic structural diagram of a transaction log report display apparatus in an embodiment of the present application;
FIG. 5 is a logic diagram of an exemplary transaction log report display method according to the present application;
fig. 6 is a schematic block diagram of a system configuration of an electronic device according to an embodiment of the present application.
Detailed Description
In order to make those skilled in the art better understand the technical solutions in the present specification, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
The transaction log information, as the original transaction record, needs to satisfy two requirements: the method can not only keep for a long time, but also realize various calculations, provide statistical reports and the like. However, the longer the storage time is, the larger the data size is, the slower the query speed is, and if the query of various reports is to be realized, a large number of indexes need to be applied, which occupies a large amount of CPU and storage resources; in the process of displaying a processed report in real time after collecting a large amount of transaction logs, the problem of overlarge single-point pressure on a log collection database exists, log storage, report processing and query are in the log collection database, and a large amount of indexes established by supporting real-time query of the report not only occupy storage space, but also influence the normal operation of an online database; in order to reduce data pressure, part of logs in the log collection database only usually store results filtered according to business requirements, and accuracy of displaying a data center log report is affected. Based on the method, the method starts from changing the existing transaction log report display mode, and the collected original transaction log information can be kept in the log collection database in daily partitions; the transaction log information with large real-time query quantity is regularly exported to a report database for processing and displaying, and the limited delay time can be similar to real time; periodically exporting the transaction log information with low real-time requirement to a report database according to the subareas for processing and displaying; and (4) leading out the expired historical data from the original transaction log library by using a reserved batch function, and informing a reservation person to download and view the data. The log collection database does not need a large amount of indexes, the utilization rate of storage space is high, the index is used in the report database to improve the query efficiency, and short-term data volume is not large, so that less storage resources are occupied. The method and the device can realize the collection of the transaction log information and the real-time processing and visual display of the transaction log information, can achieve the storage of a large amount of transaction log information, and can achieve the quick display of a real-time transaction log report.
In order to improve the efficiency of displaying the transaction log report on the basis of ensuring the reliability of storing a large amount of transaction log information, the embodiment of the application provides a transaction log report display device, which may be a server or a client device, where the client device 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, an intelligent wearable device, and the like. Wherein, intelligence wearing equipment can include intelligent glasses, intelligent wrist-watch and intelligent bracelet etc..
In practical applications, the part for performing the transaction log report presentation may be executed on the server side as described in the above, or all the operations may be completed in the client device. The selection may be specifically performed according to the processing capability of the client device, the limitation of the user usage scenario, and the like. This is not a limitation of the present application. The client device may further include a processor if all operations are performed in the client device.
The client device may have a communication module (i.e., a communication unit), and may be communicatively connected to a remote server to implement data transmission with the server. The server may include a server on the task scheduling center side, and in other implementation scenarios, the server may also include a server on an intermediate platform, for example, a server on a third-party server platform that is communicatively linked to the task scheduling center server. The server may include a single computer device, or may include a server cluster formed by a plurality of servers, or a server structure of a distributed apparatus.
The server and the client device may communicate using any suitable network protocol, including network protocols not yet developed at the filing date of this application. The network protocol may include, for example, a TCP/IP protocol, a UDP/IP protocol, an HTTP protocol, an HTTPS protocol, or the like. Of course, the network Protocol may also include, for example, an RPC Protocol (Remote Procedure Call Protocol), a REST Protocol (Representational State Transfer Protocol), and the like used above the above Protocol.
The following examples are intended to illustrate the details.
In order to improve the efficiency of displaying the transaction log report on the basis of ensuring the reliability of storing a large amount of transaction log information, the embodiment provides a method for displaying the transaction log report, in which the execution subject is a transaction log report display device, the transaction log report display device includes but is not limited to a server, and as shown in fig. 1, the method specifically includes the following contents:
step 100: and importing the first transaction log report in the log collection database into a report database.
Specifically, the first transaction log report can be imported into a report database in real time or at regular time; the log collection database and the report database can be SQL Server databases and are arranged in different servers; the first transaction log report can be imported into a report database by means of SQL Server operation and/or Windows planning task and the like; the transaction log report can be a data table in a log collection database, and a first transaction log report can be preset from each transaction log report according to actual needs. The first transaction log report may be a transaction log report with a high query frequency requirement, such as a foreign exchange transaction log report and a fund transaction log report.
Step 200: and outputting and displaying a first transaction log report which is imported into the report database, wherein the log collection database is provided with a plurality of transaction log reports for storing transaction log information.
Specifically, the first transaction log report can be output and displayed in real time or at regular time; the first transaction log report can be processed and then output and displayed by using an SQL function, and the SQL function can be an aggregation function, an encryption function and the like, so that the efficiency and the safety of displaying the transaction log report are improved. The transaction log information may include: transaction time, account, transaction type, transaction amount, etc.
For example, referring to fig. 5, transaction log information collected in real time may be extracted from an online database, log collection is performed, the log collection is imported into a transaction log report of the log collection database, and a part of the transaction log report is imported into a report database in real time in a manner of database operation, scheduling task, reserved batch, processing platform, and the like, so as to perform report display and file download; by outputting and displaying the transaction log report, the efficiency and the accuracy of monitoring the transaction log information can be improved.
In order to facilitate management and maintenance of the log collection database and reduce response time of subsequent transaction log information derivation, the log collection database stores the transaction log information in a partitioned manner according to preset partition rules. The partition rule may be to store the transaction log information in partitions by storage date.
In order to reduce the pressure of data export of the log collection database and realize classification export of the transaction log report, in an embodiment of the present application, referring to fig. 2, the transaction log report display method further includes:
step 300: and based on the partition of the log collection database, regularly importing a second transaction log report in the log collection database into the report database.
The second transaction log report may be a transaction log report with a low query frequency requirement, such as a foreign exchange transaction weekly report and a fund transaction monthly report.
Step 400: processing the second transaction log report imported into the report database, and outputting and displaying the processed second transaction log report; and the import frequency corresponding to the first transaction log report is greater than that corresponding to the second transaction log report.
Specifically, the import frequency is the frequency of importing the transaction log report into a report database; the method can determine a first transaction log report and a second transaction log report from each transaction log report according to the real-time requirement of actual data, and preset that the query frequency corresponding to the first transaction log report is greater than that corresponding to the second transaction log report so as to realize transaction log information with higher real-time performance, wherein the retention time in a log collection database is short and the operation is frequently conducted by deriving times; the transaction log information with low real-time performance can be exported according to the partition.
In order to improve efficiency and reliability of the transaction log information query, in an embodiment of the present application, referring to fig. 3, the method for displaying the transaction log report further includes:
step 500: a transaction log query request is received.
Step 600: and determining the transaction log information corresponding to the transaction log query request from the report database according to the transaction log query request.
Specifically, compared with the log collection database, the report database has small data volume, and the transaction log is inquired in the report database, so that the efficiency and the reliability of inquiring the transaction log information can be improved. The index used for inquiring the transaction log information can be arranged in the report database, so that the problem that the index is arranged in the log collection database and occupies a large amount of storage space is avoided; and furthermore, the efficiency of displaying and inquiring the transaction log report can be improved, and the index occupies less storage resources due to small data volume in the report database. In addition, even if the report database is down due to large query and display data volume and the like, the storage of the transaction logs in the log collection database is not influenced, and the online database is not influenced.
In order to reduce the storage pressure of the report database and further improve the user experience, in an embodiment of the present application, the transaction log report display method further includes:
step 700: and receiving a reserved batch downloading request sent by a target user.
Step 800: and exporting the third transaction log report forms in the log collection database in batches at the reservation time point corresponding to the reservation batch downloading request.
Step 900: and sending download viewing prompt information corresponding to the third transaction log report to the target user.
Specifically, the third transaction log report may be a second transaction log report and/or a transaction log report to which the expired historical transaction log information belongs, and the reservation batch download request may include a reservation time point. The reserved time point is used for determining the time for exporting the third transaction log report, and can be set according to actual needs, which is not limited in the present application.
In terms of software, in order to improve the efficiency of displaying the transaction log report on the basis of ensuring the reliability of storing a large amount of transaction log information, the present application provides an embodiment of a transaction log report displaying apparatus for implementing all or part of the contents in the transaction log report displaying method, which is shown in fig. 4, and the transaction log report displaying apparatus specifically includes the following contents:
the first import module 10 is configured to import the first transaction log report in the log collection database into the report database.
The first display module 20 is configured to output and display a first transaction log report which is imported into the report database, where the log collection database is provided with a plurality of transaction log reports for storing transaction log information.
Specifically, the log collection database stores the transaction log information in a partitioned manner according to preset partition rules.
In an embodiment of the present application, the transaction log report display device further includes:
and the second import module is used for importing a second transaction log report form in the log collection database into the report database at regular time based on the partition of the log collection database.
The second display module is used for processing and then outputting and displaying a second transaction log report which is imported into the report database; and the import frequency corresponding to the first transaction log report is greater than that corresponding to the second transaction log report.
The embodiment of the transaction log report display apparatus provided in this specification can be specifically used for executing the processing flow of the embodiment of the transaction log report display method, and the functions of the embodiment are not described herein again, and reference can be made to the detailed description of the embodiment of the transaction log report display method.
In order to further explain the present solution, the present application provides a specific application example of a transaction log report display device, and in the specific application example, the device includes:
and the transaction log storage module is used for exporting the transaction log information from the online database to the log collection database for storage. In the process of collection, no index influences the collection efficiency.
The transaction log export module is used for being realized in various ways, is not limited to SQL Server operation, Windows planning task and the like, and can process data requiring high real-time property while exporting the data to a report database; the transaction log information collected through the SQL Server operation function can be stored in different banks according to the retention time.
The report processing and displaying module is used for treating data differently according to real-time requirements, the real-time requirements are high, the processing frequency is high, the real-time requirements are low, the processing frequency is low, and the overdue data is realized through a reserved batch function.
The reservation batch module is used for reserving batch tasks which start in real time or at fixed time in an interface for non-real-time reports (monthly reports, annual reports and the like) with less access amount and larger data amount, automatically starting a batch program when a background arrives, generating report files and downloading links after long-time batch running after data is exported from a log collection database, and informing a reservation person to download the files. The function can ensure that the report database does not need to store excessive data on one hand, and can also improve the user experience of the report on the other hand.
Specifically, a second-order derivative job needs to be designed, incomplete unordered logs cannot be exported to a report database in the log collection process, and the reliability of transaction log information in a third transaction log report is improved. The data requirements are arranged according to requirements, and for data with high real-time requirements, short retention time and frequent derivation operation can be designed; for data with low real-time requirement, the data can be exported according to data partitions, and the exporting efficiency and flexibility are improved. The real-time higher process data operation may be performed at the time of data export, with other operations placed after data import. And adding corresponding indexes in the report database according to requirements so as to optimize query efficiency.
According to the transaction log report display device provided by the application example, the data flow of the transaction log report processing is changed into a single direction, the report processing program can exist independently of an online transaction path, and the report processing can be carried out even outside online time (6:00-20: 00). For transaction log reports with large data volume and low query and display frequency, such as half-year tables and chronology, the method can be realized through a batch reservation function; the purposes of storing a large number of transaction logs and quickly displaying a real-time transaction report are achieved by caching and processing recent data.
According to the description, the transaction log report display method and the device provided by the application can improve the efficiency of transaction log report display on the basis of ensuring the reliability of storage of a large amount of transaction log information; the query efficiency can be improved, and the reliability and efficiency of transaction log information monitoring are improved; specifically, the operation and maintenance safety can be improved: the log collection database is separated from the report database, so that even if the report database is down due to large query and display data volume and the like, the collection of the transaction logs in the log collection database is not influenced, the online database is not influenced, the influence on the online transaction process caused by the query of the surface transaction logs and the like can be realized, and the reliability of the transaction process can be improved; the system storage utilization rate can be improved: for the query requirement with high real-time requirement, indexes do not need to be established for all data; separate database single point pressure: query pressure and collection pressure can be separated, and further the method can be expanded into a multi-level log cache architecture so as to reduce the interaction between the query and collection.
In terms of hardware, in order to improve efficiency of displaying a transaction log report on the basis of ensuring reliability of storing a large amount of transaction log information, the present application provides an embodiment of an electronic device for implementing all or part of contents in the method for displaying a transaction log report, where the electronic device specifically includes the following contents:
a processor (processor), a memory (memory), a communication Interface (Communications Interface), and a bus; the processor, the memory and the communication interface complete mutual communication through the bus; the communication interface is used for realizing information transmission between the transaction log report display device, the user terminal and other related equipment; the electronic device may be a desktop computer, a tablet computer, a mobile terminal, and the like, but the embodiment is not limited thereto. In this embodiment, the electronic device may be implemented by referring to the embodiment for implementing the method for displaying the transaction log report and the embodiment for implementing the device for displaying the transaction log report in the embodiments, and the contents thereof are incorporated herein, and repeated details are not repeated.
Fig. 6 is a schematic block diagram of a system configuration of an electronic device 9600 according to an embodiment of the present application. As shown in fig. 6, the electronic device 9600 can include a central processor 9100 and a memory 9140; the memory 9140 is coupled to the central processor 9100. Notably, this FIG. 6 is exemplary; other types of structures may also be used in addition to or in place of the structure to implement telecommunications or other functions.
In one or more embodiments of the present application, the transaction log report presentation function can be integrated into the central processor 9100. The central processor 9100 may be configured to control as follows:
step 100: and importing the first transaction log report in the log collection database into a report database.
Step 200: and outputting and displaying a first transaction log report which is imported into the report database, wherein the log collection database is provided with a plurality of transaction log reports for storing transaction log information.
As can be seen from the above description, the electronic device provided in the embodiment of the present application can improve the efficiency of displaying the transaction log report on the basis of ensuring the reliability of storing a large amount of transaction log information.
In another embodiment, the transaction log report display device may be configured separately from the central processor 9100, for example, the transaction log report display device may be configured as a chip connected to the central processor 9100, and the transaction log report display function is realized under the control of the central processor.
As shown in fig. 6, the electronic device 9600 may further include: a communication module 9110, an input unit 9120, an audio processor 9130, a display 9160, and a power supply 9170. It is noted that the electronic device 9600 also does not necessarily include all of the components shown in fig. 6; further, the electronic device 9600 may further include components not shown in fig. 6, which may be referred to in the art.
As shown in fig. 6, a central processor 9100, sometimes referred to as a controller or operational control, can include a microprocessor or other processor device and/or logic device, which central processor 9100 receives input and controls the operation of the various components of the electronic device 9600.
The memory 9140 can be, for example, one or more of a buffer, a flash memory, a hard drive, a removable media, a volatile memory, a non-volatile memory, or other suitable device. The information relating to the failure may be stored, and a program for executing the information may be stored. And the central processing unit 9100 can execute the program stored in the memory 9140 to realize information storage or processing, or the like.
The input unit 9120 provides input to the central processor 9100. The input unit 9120 is, for example, a key or a touch input device. Power supply 9170 is used to provide power to electronic device 9600. The display 9160 is used for displaying display objects such as images and characters. The display may be, for example, an LCD display, but is not limited thereto.
The memory 9140 can be a solid state memory, e.g., Read Only Memory (ROM), Random Access Memory (RAM), a SIM card, or the like. There may also be a memory that holds information even when power is off, can be selectively erased, and is provided with more data, an example of which is sometimes called an EPROM or the like. The memory 9140 could also be some other type of device. Memory 9140 includes a buffer memory 9141 (sometimes referred to as a buffer). The memory 9140 may include an application/function storage portion 9142, the application/function storage portion 9142 being used for storing application programs and function programs or for executing a flow of operations of the electronic device 9600 by the central processor 9100.
The memory 9140 can also include a data store 9143, the data store 9143 being used to store data, such as contacts, digital data, pictures, sounds, and/or any other data used by an electronic device. The driver storage portion 9144 of the memory 9140 may include various drivers for the electronic device for communication functions and/or for performing other functions of the electronic device (e.g., messaging applications, contact book applications, etc.).
The communication module 9110 is a transmitter/receiver 9110 that transmits 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 in the case of a conventional mobile communication terminal.
Based on different communication technologies, a plurality of communication modules 9110, such as a cellular network module, a bluetooth module, and/or a wireless local area network module, may be provided in the same electronic device. The communication module (transmitter/receiver) 9110 is also coupled to a speaker 9131 and a microphone 9132 via an audio processor 9130 to provide audio output via the speaker 9131 and receive audio input from the microphone 9132, thereby implementing ordinary telecommunications functions. The audio processor 9130 may include any suitable buffers, decoders, amplifiers and so forth. In addition, the audio processor 9130 is also coupled to the central processor 9100, thereby enabling recording locally through the microphone 9132 and enabling locally stored sounds to be played through the speaker 9131.
As can be seen from the above description, the electronic device provided in the embodiment of the present application can improve the efficiency of displaying the transaction log report on the basis of ensuring the reliability of storing a large amount of transaction log information.
An embodiment of the present application further provides a computer-readable storage medium capable of implementing all steps in the transaction log report display method in the foregoing embodiment, where the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the computer program implements all steps of the transaction log report display method in the foregoing embodiment, for example, when the processor executes the computer program, the processor implements the following steps:
step 100: and importing the first transaction log report in the log collection database into a report database.
Step 200: and outputting and displaying a first transaction log report which is imported into the report database, wherein the log collection database is provided with a plurality of transaction log reports for storing transaction log information.
As can be seen from the above description, the computer-readable storage medium provided in the embodiment of the present application can improve the efficiency of displaying the transaction log report on the basis of ensuring the reliability of storing a large amount of transaction log information.
In the present application, each embodiment of the method is described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from the other embodiments. Reference is made to the description of the method embodiments.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The principle and the implementation mode of the present application are explained by applying specific embodiments in the present application, and the description of the above embodiments is only used to help understanding the method and the core idea of the present application; meanwhile, for a person skilled in the art, according to the idea of the present application, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present application.
Claims (11)
1. A transaction log report form display method is characterized by comprising the following steps:
importing a first transaction log report in a log collection database into a report database;
and outputting and displaying a first transaction log report which is imported into the report database, wherein the log collection database is provided with a plurality of transaction log reports for storing transaction log information.
2. The transaction log report presentation method of claim 1,
and the log collection database stores the transaction log information in a partitioning mode according to preset partitioning rules.
3. The transaction log report presentation method of claim 2, further comprising:
based on the partition of the log collection database, regularly importing a second transaction log report in the log collection database into the report database;
processing the second transaction log report imported into the report database, and outputting and displaying the processed second transaction log report;
and the import frequency corresponding to the first transaction log report is greater than that corresponding to the second transaction log report.
4. The transaction log report presentation method of claim 1, further comprising:
receiving a transaction log query request;
and determining the transaction log information corresponding to the transaction log query request from the report database according to the transaction log query request.
5. The transaction log report presentation method of claim 1, further comprising:
receiving a reservation batch downloading request sent by a target user;
exporting third transaction log reports in the log collection database in batches at a reservation time point corresponding to the reservation batch downloading request;
and sending download viewing prompt information corresponding to the third transaction log report to the target user.
6. The transaction log report presentation method of claim 1, further comprising:
and setting an index for inquiring the transaction log information in the report database.
7. A transaction log report form display device is characterized by comprising:
the first import module is used for importing the first transaction log report in the log collection database into the report database;
and the first display module is used for outputting and displaying a first transaction log report which is imported into the report database, wherein the log collection database is provided with a plurality of transaction log reports for storing transaction log information.
8. The transaction log report presentation device of claim 7,
and the log collection database stores the transaction log information in a partitioning mode according to preset partitioning rules.
9. The transaction log report presentation device of claim 8, further comprising:
the second import module is used for importing a second transaction log report form in the log collection database into the report database at regular time based on the partition of the log collection database;
the second display module is used for processing and then outputting and displaying a second transaction log report which is imported into the report database;
and the import frequency corresponding to the first transaction log report is greater than that corresponding to the second transaction log report.
10. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the transaction log report presentation method according to any one of claims 1 to 6 when executing the program.
11. A computer-readable storage medium having stored thereon computer instructions, wherein the instructions, when executed, implement the transaction log report presentation method of any of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010908008.3A CN112035557B (en) | 2020-09-02 | 2020-09-02 | Transaction log report display method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010908008.3A CN112035557B (en) | 2020-09-02 | 2020-09-02 | Transaction log report display method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112035557A true CN112035557A (en) | 2020-12-04 |
| CN112035557B CN112035557B (en) | 2024-04-16 |
Family
ID=73590996
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010908008.3A Active CN112035557B (en) | 2020-09-02 | 2020-09-02 | Transaction log report display method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112035557B (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140330866A1 (en) * | 2013-05-03 | 2014-11-06 | Mapquest, Inc. | Systems and methods for parsing search queries |
| US20170286463A1 (en) * | 2016-03-31 | 2017-10-05 | Ca, Inc. | Mainframe index database to supplement a system catalog |
| CN110134723A (en) * | 2019-05-22 | 2019-08-16 | 网易（杭州）网络有限公司 | A kind of method and database of storing data |
| CN110399375A (en) * | 2019-07-24 | 2019-11-01 | 南京云白信息科技有限公司 | A kind of tables of data index creation method and device |
| CN111183450A (en) * | 2019-09-12 | 2020-05-19 | 阿里巴巴集团控股有限公司 | Log structure storage system |
| CN111382182A (en) * | 2020-03-19 | 2020-07-07 | 中国联合网络通信集团有限公司 | Data processing method and device, electronic equipment and storage medium |
-
2020
- 2020-09-02 CN CN202010908008.3A patent/CN112035557B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140330866A1 (en) * | 2013-05-03 | 2014-11-06 | Mapquest, Inc. | Systems and methods for parsing search queries |
| US20170286463A1 (en) * | 2016-03-31 | 2017-10-05 | Ca, Inc. | Mainframe index database to supplement a system catalog |
| CN110134723A (en) * | 2019-05-22 | 2019-08-16 | 网易（杭州）网络有限公司 | A kind of method and database of storing data |
| CN110399375A (en) * | 2019-07-24 | 2019-11-01 | 南京云白信息科技有限公司 | A kind of tables of data index creation method and device |
| CN111183450A (en) * | 2019-09-12 | 2020-05-19 | 阿里巴巴集团控股有限公司 | Log structure storage system |
| CN111382182A (en) * | 2020-03-19 | 2020-07-07 | 中国联合网络通信集团有限公司 | Data processing method and device, electronic equipment and storage medium |
Non-Patent Citations (1)
| Title |
|---|
| 徐冰: "面向海量异构历史数据查询的索引管理系统", 《中国优秀硕士学位论文全文数据库 信息科技辑》, no. 03 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112035557B (en) | 2024-04-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111031058A (en) | Websocket-based distributed server cluster interaction method and device | |
| CN111782470B (en) | Distributed container log data processing method and device | |
| CN111369247A (en) | Cross-bank transaction data processing method and device | |
| CN111353892A (en) | Transaction risk monitoring method and device | |
| CN111047430A (en) | Accounting information processing method and device | |
| CN113055479A (en) | Self-adaptive processing method, device and system for distributed service cluster load | |
| CN113435989A (en) | Financial data processing method and device | |
| CN110908875A (en) | Inspection method and device based on operation terminal | |
| CN106022874A (en) | Order data processing method, order system, and flow charging system | |
| CN113032233A (en) | Distributed service cluster runtime parameter adaptive processing method, device and system | |
| CN114257532B (en) | Method and device for detecting state of server | |
| CN113485952A (en) | Data batch transmission method and device | |
| CN112035557B (en) | Transaction log report display method and device | |
| CN113918436A (en) | Log processing method and device | |
| CN115099930A (en) | Financial business data processing method and device | |
| CN113434423A (en) | Interface test method and device | |
| CN113672488A (en) | Log text processing method and device | |
| CN112905358A (en) | Software distribution method, device and system of distributed system | |
| CN111767118A (en) | Container storage space processing method and device based on distributed file system | |
| CN111161047A (en) | Bank business data processing and inquiring method and device | |
| CN114036123A (en) | Query record quantity determining method and device | |
| CN112734545B (en) | Block chain data sharing method, device and system | |
| CN112396511A (en) | Distributed wind control variable data processing method, device and system | |
| CN113094270B (en) | Project automatic verification method and device | |
| CN113760683B (en) | Log acquisition method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |