CN111221833A - Method, system, storage medium and computing device for detecting service data - Google Patents

Method, system, storage medium and computing device for detecting service data Download PDF

Info

Publication number
CN111221833A
CN111221833A CN201911399978.9A CN201911399978A CN111221833A CN 111221833 A CN111221833 A CN 111221833A CN 201911399978 A CN201911399978 A CN 201911399978A CN 111221833 A CN111221833 A CN 111221833A
Authority
CN
China
Prior art keywords
service
data change
data
change value
account
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
CN201911399978.9A
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.)
Beijing Absolute Health Ltd
Original Assignee
Beijing Absolute Health 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 Beijing Absolute Health Ltd filed Critical Beijing Absolute Health Ltd
Priority to CN201911399978.9A priority Critical patent/CN111221833A/en
Publication of CN111221833A publication Critical patent/CN111221833A/en
Pending legal-status Critical Current

Links

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/23—Updating
    • G06F16/2358—Change logging, detection, and notification
    • 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/23—Updating
    • G06F16/2379—Updates performed during online database operations; commit processing
    • 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/28—Databases characterised by their database models, e.g. relational or object models
    • G06F16/284—Relational databases
    • 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
    • G06Q20/00—Payment architectures, schemes or protocols
    • G06Q20/04—Payment circuits
    • G06Q20/06—Private payment circuits, e.g. involving electronic currency used among participants of a common payment scheme
    • G06Q20/065—Private payment circuits, e.g. involving electronic currency used among participants of a common payment scheme using e-cash
    • 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
    • G06Q20/00—Payment architectures, schemes or protocols
    • G06Q20/08—Payment architectures
    • G06Q20/085—Payment architectures involving remote charge determination or related payment systems
    • G06Q20/0855—Payment architectures involving remote charge determination or related payment systems involving a third party
    • 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/12—Accounting
    • G06Q40/125—Finance or payroll

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Theoretical Computer Science (AREA)
  • Accounting & Taxation (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Finance (AREA)
  • General Business, Economics & Management (AREA)
  • Strategic Management (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • Development Economics (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Technology Law (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a method, a system, a storage medium and a computing device for detecting service data, wherein the method comprises the steps of monitoring the updating operation of a plurality of service databases in a service system, acquiring data updating information generated during the updating operation of the service databases, recording data change values in the data updating information, analyzing whether the recorded data change values in a preset time range have consistency or not, and sending out an early warning message that the updating operation of the service databases is abnormal under the condition that the data change values do not have consistency. The embodiment of the invention does not need to detect the consistency of the service data by the service end of the service system and also does not need to worry about the condition of interrupting service flow caused by faults such as hot release replacement, downtime, network interruption and the like, but effectively analyzes the consistency of the change values of the service data after the service data are put into storage and are stable, thereby alarming the service data with the inconsistency problem and timely reminding maintenance personnel to calibrate the service system.

Description

Method, system, storage medium and computing device for detecting service data
Technical Field
The present invention relates to the technical field of service data detection, and in particular, to a method, a system, a storage medium, and a computing device for service data detection.
Background
In the service system, due to the diversity of the flow direction of complex service data and the frequent switching of the production, operation and maintenance environment, service interruption and service complexity of a distributed system are easily caused, and due to the non-real-time property and soft transaction characteristics of the service system, the data verification of the service system has high working cost and high error rate.
Currently, this problem is avoided in accounting systems by checking for consistency of any balance data changes at a faster time. And the asynchronous detection task is sent through the accounting change, and the data consistency before and after the accounting change is relatively accurately checked at a certain future time. However, since a lot of verification tasks are generated when changes occur frequently, and only one business index can be used as a starting node for confirming that the accounting change sends the verification tasks, much useless work and uncertainty are caused, and great pressure is generated on a business server.
Disclosure of Invention
In view of this, embodiments of the present invention provide a method, a system, a storage medium, and a computing device for detecting service data, which can achieve the purpose of effectively analyzing the consistency of service data change values and alarming service data with inconsistency.
According to an aspect of the embodiments of the present invention, a method for detecting service data is provided, including:
monitoring updating operation of a plurality of service databases in a service system;
acquiring data updating information generated by updating operation of a service database, and extracting and recording data change values from the data updating information;
analyzing whether a plurality of data change values recorded within a preset time range have consistency or not;
and if the plurality of data change values are not consistent, sending out an early warning message that the updating operation of the service database is abnormal.
Optionally, the obtaining of data update information generated by an update operation of the service database includes:
acquiring a log file generated by updating operation of a service database;
and extracting the data updating information from the acquired log file.
Optionally, extracting and recording a data change value from the data update information, including:
extracting a data change value from the data update information;
and determining the service type corresponding to the data change value, and recording the corresponding data change value into a pre-established wide table in a classified manner based on the service type.
Optionally, the business system includes an accounting system, the business type corresponding to the data change value includes an account entry business and an account exit business, and analyzing whether a plurality of data change values recorded within a preset time range have consistency includes:
acquiring a data change value corresponding to the account entry business and a data change value corresponding to the account exit business which are recorded in a preset time range from the wide table;
respectively calculating the total value of the data change value corresponding to the account-entering service and the total value of the data change value corresponding to the account-exiting service;
analyzing whether the total value of the data change value corresponding to the account-entering service and the total value of the data change value corresponding to the account-exiting service have consistency or not;
and the total value of the data change value corresponding to the account-in service and the total value of the data change value corresponding to the account-out service are consistent in the same value.
Optionally, the business system includes an accounting system, the business types corresponding to the data change values include an entry business, an exit business, and a balance business, and analyzing whether a plurality of data change values recorded within a preset time range have consistency includes:
acquiring a data change value corresponding to the account entry service, a data change value corresponding to the account exit service and a data change value corresponding to the balance service which are recorded in a preset time range from the wide table;
respectively calculating the total value of the data change value corresponding to the account entry service, the total value of the data change value corresponding to the account exit service and the total value of the data change value corresponding to the balance service;
analyzing whether the sum of the total value of the data change values corresponding to the posting business and the total value of the data change values corresponding to the balance business are consistent or not;
the sum of the total value of the data change value corresponding to the account-entering service and the total value of the data change value corresponding to the account-exiting service and the total value of the data change value corresponding to the balance service are consistent in value.
Optionally, the posting service includes at least one of a recharge service, a bonus posting, a withholding posting, and a red envelope posting.
Optionally, the check-out service includes at least one of shared deduction, refund, receipt, user flow-back, and cash-back transfer-out, where the user flow-back selects a part of the receipt for the user.
Optionally, the balance service comprises a valid order balance of the accounting system.
Optionally, the plurality of traffic databases include a database for storing information based on block chains.
According to another aspect of the embodiments of the present invention, there is also provided a system for detecting service data, including:
the monitoring module is suitable for monitoring the updating operation of a plurality of service databases in the service system;
the acquisition recording module is suitable for acquiring data updating information generated by updating operation of a service database, and extracting and recording data change values from the data updating information;
the analysis module is suitable for analyzing whether the plurality of data change values recorded in the preset time range have consistency or not;
and the early warning module is suitable for sending out an early warning message that the updating operation of the service database is abnormal if the plurality of data change values are not consistent.
Optionally, the obtaining the record module is further adapted to:
acquiring a log file generated by updating operation of a service database;
and extracting the data updating information from the acquired log file.
Optionally, the obtaining the record module is further adapted to:
extracting a data change value from the data update information;
and determining the service type corresponding to the data change value, and recording the corresponding data change value into a pre-established wide table in a classified manner based on the service type.
Optionally, the business system includes an accounting system, the business type corresponding to the data change value includes an entry business and an exit business, and the analysis module is further adapted to:
acquiring a data change value corresponding to the account entry business and a data change value corresponding to the account exit business which are recorded in a preset time range from the wide table;
respectively calculating the total value of the data change value corresponding to the account-entering service and the total value of the data change value corresponding to the account-exiting service;
analyzing whether the total value of the data change value corresponding to the account-entering service and the total value of the data change value corresponding to the account-exiting service have consistency or not;
and the total value of the data change value corresponding to the account-in service and the total value of the data change value corresponding to the account-out service are consistent in the same value.
Optionally, the service system includes an accounting system, the service type corresponding to the data change value includes an entry service, an exit service, and a balance service, and the analysis module is further adapted to:
acquiring a data change value corresponding to the account entry service, a data change value corresponding to the account exit service and a data change value corresponding to the balance service which are recorded in a preset time range from the wide table;
respectively calculating the total value of the data change value corresponding to the account entry service, the total value of the data change value corresponding to the account exit service and the total value of the data change value corresponding to the balance service;
analyzing whether the sum of the total value of the data change values corresponding to the posting business and the total value of the data change values corresponding to the balance business are consistent or not;
the sum of the total value of the data change value corresponding to the account-entering service and the total value of the data change value corresponding to the account-exiting service and the total value of the data change value corresponding to the balance service are consistent in value.
Optionally, the posting service includes at least one of a recharge service, a reward deposit posting, a withholding posting, and a red packet posting; the charge-out service comprises at least one item of shared deduction, refund, receipt, user flow-back and cash-back transfer, wherein the user flow-back is used for selecting partial receipt for the user; the balance service comprises a valid order balance of the accounting system; the plurality of traffic databases include a database for information storage based on block chains.
According to yet another aspect of the embodiments of the present invention, there is further provided a computer-readable storage medium storing computer program code, which, when run on a computing device, causes the computing device to execute the method for detecting business data according to any of the embodiments above.
According to still another aspect of the embodiments of the present invention, there is also provided a computing device including: a processor; a memory storing computer program code; the computer program code, when executed by the processor, causes the computing device to perform the method of traffic data detection of any of the embodiments.
The embodiment of the invention acquires the data updating information generated during the updating operation of the service database, records the data change values in the data updating information, analyzes whether the plurality of recorded data change values in the preset time range have consistency or not, and sends out the early warning message that the updating operation of the service database is abnormal under the condition that the plurality of recorded data change values do not have consistency. Therefore, the embodiment of the invention does not need to detect the consistency of the service data by the service end of the service system, does not need to worry about the condition that the service flow is interrupted due to faults such as hot release replacement, downtime, network interruption and the like, does not need to verify and calibrate the data consistency by releasing a timing/delay task, and can effectively alarm the service data with the inconsistency problem by analyzing the consistency of the service data change values after the service data is put into storage stably so as to prompt maintenance personnel to calibrate the service system in time.
The foregoing description is only an overview of the technical solutions of the present invention, and the embodiments of the present invention are described below in order to make the technical means of the present invention more clearly understood and to make the above and other objects, features, and advantages of the present invention more clearly understandable.
The above and other objects, advantages and features of the present invention will become more apparent to those skilled in the art from the following detailed description of specific embodiments thereof, taken in conjunction with the accompanying drawings.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description, serve to explain the principles of the invention.
The invention will be more clearly understood from the following detailed description, taken with reference to the accompanying drawings, in which:
fig. 1 is a schematic flow chart illustrating a method for detecting service data according to an embodiment of the present invention;
fig. 2 is a schematic distribution diagram of different service ends corresponding to different services according to an embodiment of the present invention;
FIG. 3 is a schematic diagram illustrating the distribution of different traffic types according to an embodiment of the present invention;
fig. 4 is a schematic structural diagram of a system for detecting service data according to an embodiment of the present invention.
Detailed Description
Various exemplary embodiments of the present invention will now be described in detail with reference to the accompanying drawings. It should be noted that: the relative arrangement of the components and steps, the numerical expressions and numerical values set forth in these embodiments do not limit the scope of the present invention unless specifically stated otherwise.
Meanwhile, it should be understood that the sizes of the respective portions shown in the drawings are not drawn in an actual proportional relationship for the convenience of description.
The following description of at least one exemplary embodiment is merely illustrative in nature and is in no way intended to limit the invention, its application, or uses.
Techniques, methods, and apparatus known to those of ordinary skill in the relevant art may not be discussed in detail but are intended to be part of the specification where appropriate.
It should be noted that: like reference numbers and letters refer to like items in the following figures, and thus, once an item is defined in one figure, further discussion thereof is not required in subsequent figures.
Embodiments of the invention are operational with numerous other general purpose or special purpose computing system environments or configurations. Examples of well known computing systems, environments, and/or configurations that may be suitable for use with the computer system/server include, but are not limited to: personal computer systems, server computer systems, thin clients, thick clients, hand-held or laptop devices, microprocessor-based systems, set-top boxes, programmable consumer electronics, networked personal computers, minicomputer systems, mainframe computer systems, distributed cloud computing environments that include any of the above, and the like.
The computer system/server may be described in the general context of computer system-executable instructions, such as program modules, being executed by a computer system. Generally, program modules may include routines, programs, objects, components, logic, data structures, etc. that perform particular tasks or implement particular abstract data types. The computer system/server may be practiced in distributed cloud computing environments where tasks are performed by remote processing devices that are linked through a communications network. In a distributed cloud computing environment, program modules may be located in both local and remote computer system storage media including memory storage devices.
To solve the above technical problem, an embodiment of the present invention provides a method for detecting service data, and fig. 1 illustrates a schematic flow chart of the method for detecting service data according to an embodiment of the present invention, and referring to fig. 1, the method may include the following steps S102 to S108.
Step S102, monitoring the updating operation of a plurality of service databases in the service system.
And step S104, acquiring data updating information generated by the updating operation of the service database, extracting a data change value from the data updating information and recording the data change value.
And step S106, analyzing whether the plurality of data change values recorded in the preset time range have consistency.
And step S108, if the plurality of data change values are not consistent, sending out an early warning message that the updating operation of the service database is abnormal.
The embodiment of the invention acquires the data updating information generated during the updating operation of the service database, records the data change values in the data updating information, analyzes whether the plurality of recorded data change values in the preset time range have consistency or not, and sends out the early warning message that the updating operation of the service database is abnormal under the condition that the plurality of recorded data change values do not have consistency. Therefore, the embodiment of the invention does not need to detect the consistency of the service data by the service end of the service system, does not need to worry about the condition that the service flow is interrupted due to faults such as hot release replacement, downtime, network interruption and the like, does not need to verify and calibrate the data consistency by releasing a timing/delay task, and can effectively alarm the service data with the inconsistency problem by analyzing the consistency of the service data change values after the service data is put into storage stably so as to prompt maintenance personnel to calibrate the service system in time.
Referring to step S102, in an embodiment of the present invention, the update operation of the business database may also be referred to as an update operation, and the update operation includes data addition, data deletion, data modification, and the like. The business system of the embodiment of the present invention may be an accounting system related to accounting processing, or may be another system, which is not specifically limited herein. In addition, the plurality of business databases may be databases for storing information based on block chains, and may be, for example, MySQL (relational database management system) databases.
Referring to step S104, in an embodiment of the present invention, generally, the service database writes the data update information related to the update operation into the log file during the update operation, so that, in order to conveniently and quickly obtain the data update information generated by the update operation of the service database, the data update information may be extracted from the obtained log file by obtaining the log file generated by the update operation of the service database. If the service database is a MySQL database, the obtained log file is a binlog log, and the binlog is a binary log, and can be used for recording records of database update contents such as incremental, deletion, modification and the like in the MySQL database (for example, modification of the write flow data on the database), and also recording data of master-slave copy of the database.
In an embodiment of the present invention, in order to analyze the consistency of a plurality of data change values in a subsequent and convenient manner, when the extracted data change values are recorded, classified recording may be performed based on the service type corresponding to the data change values. Specifically, after the data change value is extracted from the data update information, the service type corresponding to the data change value is determined, and then the corresponding data change value is recorded into the pre-established wide table in a classified manner based on the service type.
In the embodiment of the present invention, a plurality of fields, for example, historical data, creation time, current states of different service types, current change values of different service types, and the like, may be preset in the wide table, and when the data change values are recorded in the wide table in a classified manner, the data change values are recorded in the current change value fields of the corresponding service types in the wide table, so as to implement classification recording of the data change values, and make recording of the data change values more clear.
In the updating process of the service database, if the updating operation of the service database is too frequent, a situation that the relevant service data of the updating operation cannot be processed in time may occur. By creating the message queue, the update information generated by the update operation is added to the message queue after the update operation of the service database, and further, when the data update information generated by the update operation of the service database is acquired, the update information can be extracted from the message queue. The data updating information is acquired from the created message queue, so that the data updating information is not missed, the process of analyzing whether the data change values of the service database are consistent or not in the follow-up analysis and the process generated by the data updating information are not influenced mutually, and a decoupled data processing structure mode is realized.
In an embodiment of the present invention, the business system may be an accounting system, such as an accounting system of a mutual-assistance business, and one accounting system generally includes a plurality of business terminals, for example, referring to fig. 2, the plurality of business terminals of the accounting system include a user account entering business terminal, a user account exiting business terminal, a public business terminal, a withholding business terminal, and an order business terminal.
The posting service end can be responsible for user posting, such as the following single posting, recharging posting, rewarding posting, inviting red package posting and other services.
The user charge-out service end can be responsible for user charge-out, such as the services of chargeback charge-out, chargeback charge-out and the like.
The public service end may be responsible for showing the account and deducting money, for example, in the mutual-aid service, the shared deduction service is provided, and then the public service end may be responsible for showing the shared deduction result and other services.
The withholding service end can be responsible for withholding services of a third-party service provider, such as posting and the like. Such as a WeChat button, etc.
The order service terminal can be responsible for calculating the balance of the effective order and other services.
The service end corresponds to a corresponding database for storing service data generated when the service end processes services. And the corresponding database of each service end generates data updating operation in the service execution process. For example, the user account entry service end, the user account exit service end, and the order service end all correspond to order databases, and here, because the amount of service data processed by the order databases is large, two order databases may be set to share a data storage task. The user posting service end is also corresponding to a user posting database and is responsible for a small amount of partial posting services of the user posting service end. And the public service end corresponds to a public database. An effective order generated by a general accounting system includes dimensions such as entry, exit, and balance, that is, the types of services may be mainly classified into entry service, exit service, and balance service.
Referring to fig. 3, the entry service types mainly include a recharge service, an award money, a red packet invitation entry and the like of the entry service end, wherein the recharge service specifically includes a bill-placing recharge, a fee-renewing recharge, a presentation recharge, a coupon recharge and the like. In addition, the posting service type also comprises a withholding posting of a withholding service end, namely the withholding posting service of a third-party service provider, such as a WeChat withholding and a wing payment withholding. The types of the charge-out service mainly comprise refund, receipt refund, user flow refund, cash-back roll-out and the like of a user charge-out service end, wherein the user flow refund selects part of the receipt refund for the user. The charge-out service type can also comprise shared deduction of a public service end.
When related services are processed at different service ends, the data flow directions of the services are different, and if the data flow of the services flows among databases of a service system, whether the total value of the data change values corresponding to the posting service and the total value of the data change values corresponding to the posting service are balanced within a preset time range or not can be concerned, namely whether consistency exists or not. If the data of the service flows out of the database outside the database of the service system or flows from the database outside the database of the service system to the database of the service system, whether the total value of the data change values corresponding to the posting service, and the total value of the data change values corresponding to the balance service reach a balance within a preset time range, that is, whether consistency exists or not, needs to be considered. The preset time range can be generally set according to the time required for completing one accounting order, so as to ensure that the consistency of a plurality of data change values is effectively analyzed after the accounting order is completed and the business data are all stable in the database.
In conjunction with the above step S106, the following describes a process for analyzing whether the plurality of data change values recorded within the preset time range have consistency in different embodiments.
In an embodiment of the present invention, the business system is an accounting system, and the data stream of the business flows between databases of the business system. The service types corresponding to the data change values to be analyzed comprise an account-entering service and an account-exiting service. In the process of analyzing whether a plurality of data change values recorded in a preset time range have consistency, firstly, a data change value corresponding to an account entry service and a data change value corresponding to an account exit service recorded in the preset time range are obtained from a wide table. Then, the total value of the data change value corresponding to the account-in service and the total value of the data change value corresponding to the account-out service are respectively calculated. And further, whether the total value of the data change value corresponding to the account-in service and the total value of the data change value corresponding to the account-out service are consistent or not is analyzed. If the total value of the data change value corresponding to the posting service is equal in value to the total value of the data change value corresponding to the posting service, it can be known that the total value of the data change value corresponding to the posting service is consistent with the total value of the data change value corresponding to the posting service.
For example, the data change values of three services, the data change value delta corresponding to the renewal recharging service are acquired in a preset time period through a wide tableContinuously forIs +10, the data change value delta corresponding to the refund serviceRetreatTo-8, the data change value delta corresponding to the deduction service is shared uniformlyAre all made ofIs-2,. DELTA.Continuously forAnd deltaRetreat+ΔAre all made ofAre consistent and equal in value. By combining the above, the recharging and recharging service belongs to the type of the account entry service, and the shared deduction service and the refund service belong to the type of the account exit service, so that the total value of the data change value corresponding to the account entry service is consistent with the total value of the data change value corresponding to the account exit service, and thus, the plurality of data change values in the accounting system have consistency after the updating operation of the plurality of service databases.
In another embodiment of the present invention, the business system is an accounting system, and the data flow of the business flows to a database outside the business system. The service types corresponding to the data change values to be analyzed comprise an account entry service, an account exit service and a balance service. In the process of analyzing whether a plurality of data change values recorded in a preset time range have consistency, firstly, a data change value corresponding to an account entry service, a data change value corresponding to an account exit service and a data change value corresponding to a balance service, which are recorded in the preset time range, are obtained from a wide table. And then, respectively calculating the total value of the data change value corresponding to the account-in service, the total value of the data change value corresponding to the account-out service and the total value of the data change value corresponding to the balance service. And further analyzing whether the sum of the total value of the data change value corresponding to the account-entering service and the total value of the data change value corresponding to the account-exiting service and the total value of the data change value corresponding to the balance service have consistency or not. If the sum of the total value of the data change value corresponding to the posting service and the total value of the data change value corresponding to the balance service are equal in value, the sum of the total value of the data change value corresponding to the posting service and the total value of the data change value corresponding to the balance service can be known to have consistency.
For example, the data change values of three services, the data change value delta corresponding to the renewal recharging service are acquired in a preset time period through a wide tableContinuously forIs +3, the data change value delta corresponding to the refund serviceRetreatIs-8, the data change value delta corresponding to the balance serviceSurplusIs-5, and Δ is found by analysisSurplusAnd deltaContinuously for+ΔRetreatAre consistent and equal in value. By combining the above, it can be known that the renewal recharging service belongs to the type of the account entry service, the refund service belongs to the type of the account exit service, and the balance service belongs to the type of the balance service, so that the sum of the total data change value corresponding to the account entry service and the total data change value corresponding to the account exit service is consistent with the data change value corresponding to the balance service, and thus, it can be known that the plurality of data change values after the updating operation of the plurality of service databases in the accounting system have consistency.
Referring to step S108 above, in an embodiment of the present invention, when an early warning message indicating that an update operation of the service database is abnormal is sent, the early warning message may be sent to a terminal of a relevant maintenance person in a form of sending an instant messaging message or an email, so as to remind the relevant maintenance person to perform calibration of the service system.
Based on the same inventive concept, an embodiment of the present invention further provides a system for detecting service data, fig. 4 shows a schematic structural diagram of the system for detecting service data according to an embodiment of the present invention, and referring to fig. 4, the system for detecting service data includes a monitoring module 410, an obtaining and recording module 420, an analyzing module 430, and an early warning module 440. Specifically, the method comprises the following steps:
a monitoring module 410 adapted to monitor update operations of a plurality of service databases in a service system;
the obtaining and recording module 420 is adapted to obtain data update information generated by the update operation of the service database, extract and record a data change value from the data update information;
the analysis module 430 is adapted to analyze whether the plurality of data change values recorded within the preset time range have consistency;
the early warning module 440 is adapted to send out an early warning message that the update operation of the service database is abnormal if the plurality of data change values are not consistent.
In an optional embodiment of the present invention, the obtaining record module 420 is further adapted to:
acquiring a log file generated by updating operation of a service database;
and extracting data updating information from the acquired log file.
In an alternative embodiment of the present invention, the obtaining record module 420 is further adapted to extract the data change value from the data update information. And determining the service type corresponding to the data change value, and recording the corresponding data change value into a pre-established wide table in a classified manner based on the service type.
In an optional embodiment of the present invention, the business system includes an accounting system, the business type corresponding to the data change value includes an entry business and an exit business, and the analysis module 430 is further adapted to obtain the data change value corresponding to the entry business and the data change value corresponding to the exit business recorded in the preset time range from the wide table. And respectively calculating the total value of the data change value corresponding to the account-in service and the total value of the data change value corresponding to the account-out service. And analyzing whether the total value of the data change value corresponding to the account-in service and the total value of the data change value corresponding to the account-out service have consistency or not. And the total value of the data change value corresponding to the account-in service and the total value of the data change value corresponding to the account-out service are consistent in the same value.
In an optional embodiment of the present invention, the service system includes an accounting system, the service types corresponding to the data change values include an entry service, an exit service, and a balance service, and the analysis module 430 is further adapted to obtain, from the wide table, the data change value corresponding to the entry service, the data change value corresponding to the exit service, and the data change value corresponding to the balance service, which are recorded within a preset time range. And respectively calculating the total value of the data change value corresponding to the account-entering service, the total value of the data change value corresponding to the account-exiting service and the total value of the data change value corresponding to the balance service. And analyzing whether the sum of the total value of the data change value corresponding to the account-entering service and the total value of the data change value corresponding to the account-exiting service and the total value of the data change value corresponding to the balance service have consistency or not. The sum of the total value of the data change value corresponding to the account-entering service and the total value of the data change value corresponding to the account-exiting service and the total value of the data change value corresponding to the balance service are consistent in value.
In an alternative embodiment of the present invention, the posting service may include at least one of a top-up service, a bonus posting, a withholding posting, a red envelope posting, and the like. The billing service may include at least one of an equity deduction, a refund, a user retired water, a cash back roll out, and the like, wherein the user retired water selects a partial refund for the user.
In an alternative embodiment of the invention, the balance service comprises a valid order balance for the accounting system.
In an alternative embodiment of the present invention, the plurality of service databases may include a database for storing information based on block chains, for example, a MySQL database.
Based on the same inventive concept, an embodiment of the present invention further provides a computer-readable storage medium, which stores computer program codes, and when the computer program codes are run on a computing device, the computing device is caused to execute the method for detecting service data in any of the above embodiments.
Based on the same inventive concept, an embodiment of the present invention further provides a computing device, including: a processor; a memory storing computer program code; the computer program code, when executed by a processor, causes a computing device to perform the method of traffic data detection in any of the embodiments above.
In the present specification, the embodiments are described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same or similar parts in the embodiments are referred to each other. For the system embodiment, since it basically corresponds to the method embodiment, the description is relatively simple, and for the relevant points, reference may be made to the partial description of the method embodiment.
The method and system of the present invention may be implemented in a number of ways. For example, the methods and systems of the present invention may be implemented in software, hardware, firmware, or any combination of software, hardware, and firmware. The above-described order for the steps of the method is for illustrative purposes only, and the steps of the method of the present invention are not limited to the order specifically described above unless specifically indicated otherwise. Furthermore, in some embodiments, the present invention may also be embodied as a program recorded in a recording medium, the program including machine-readable instructions for implementing a method according to the present invention. Thus, the present invention also covers a recording medium storing a program for executing the method according to the present invention.
The description of the present invention has been presented for purposes of illustration and description, and is not intended to be exhaustive or limited to the invention in the form disclosed. Many modifications and variations will be apparent to practitioners skilled in this art. The embodiment was chosen and described in order to best explain the principles of the invention and the practical application, and to enable others of ordinary skill in the art to understand the invention for various embodiments with various modifications as are suited to the particular use contemplated.

Claims (14)

1. A method for detecting service data, comprising:
monitoring updating operation of a plurality of service databases in a service system;
acquiring data updating information generated by updating operation of a service database, and extracting and recording data change values from the data updating information;
analyzing whether a plurality of data change values recorded within a preset time range have consistency or not;
and if the plurality of data change values are not consistent, sending out an early warning message that the updating operation of the service database is abnormal.
2. The method of claim 1, wherein obtaining data update information generated by an update operation of a service database comprises:
acquiring a log file generated by updating operation of a service database;
and extracting the data updating information from the acquired log file.
3. The method according to claim 1 or 2, wherein extracting and recording data change values from the data update information comprises:
extracting a data change value from the data update information;
and determining the service type corresponding to the data change value, and recording the corresponding data change value into a pre-established wide table in a classified manner based on the service type.
4. The method of claim 3, wherein the business system comprises an accounting system, the business type corresponding to the data change value comprises an accounting business and an accounting business, and analyzing whether the plurality of data change values recorded within the preset time range have consistency comprises:
acquiring a data change value corresponding to the account entry business and a data change value corresponding to the account exit business which are recorded in a preset time range from the wide table;
respectively calculating the total value of the data change value corresponding to the account-entering service and the total value of the data change value corresponding to the account-exiting service;
analyzing whether the total value of the data change value corresponding to the account-entering service and the total value of the data change value corresponding to the account-exiting service have consistency or not;
and the total value of the data change value corresponding to the account-in service and the total value of the data change value corresponding to the account-out service are consistent in the same value.
5. The method of claim 3, wherein the business system comprises an accounting system, the business types corresponding to the data change values include an entry business, an exit business, and a balance business, and analyzing whether the plurality of data change values recorded within the preset time range have consistency includes:
acquiring a data change value corresponding to the account entry service, a data change value corresponding to the account exit service and a data change value corresponding to the balance service which are recorded in a preset time range from the wide table;
respectively calculating the total value of the data change value corresponding to the account entry service, the total value of the data change value corresponding to the account exit service and the total value of the data change value corresponding to the balance service;
analyzing whether the sum of the total value of the data change values corresponding to the posting business and the total value of the data change values corresponding to the balance business are consistent or not;
the sum of the total value of the data change value corresponding to the account-entering service and the total value of the data change value corresponding to the account-exiting service and the total value of the data change value corresponding to the balance service are consistent in value.
6. The method of claim 5,
the posting service comprises at least one item of recharging service, reward money posting, withholding posting and red packet posting;
and/or
The charge-out service comprises at least one item of shared deduction, refund, receipt, user flow-back and cash-back transfer, wherein the user flow-back is used for selecting partial receipt for the user;
and/or
The balance service comprises a valid order balance of the accounting system;
and/or
The plurality of traffic databases include a database for information storage based on block chains.
7. A system for traffic data detection, comprising:
the monitoring module is suitable for monitoring the updating operation of a plurality of service databases in the service system;
the acquisition recording module is suitable for acquiring data updating information generated by updating operation of a service database, and extracting and recording data change values from the data updating information;
the analysis module is suitable for analyzing whether the plurality of data change values recorded in the preset time range have consistency or not;
and the early warning module is suitable for sending out an early warning message that the updating operation of the service database is abnormal if the plurality of data change values are not consistent.
8. The system of claim 7, wherein the acquisition record module is further adapted to:
acquiring a log file generated by updating operation of a service database;
and extracting the data updating information from the acquired log file.
9. The system of claim 7 or 8, wherein the acquisition record module is further adapted to:
extracting a data change value from the data update information;
and determining the service type corresponding to the data change value, and recording the corresponding data change value into a pre-established wide table in a classified manner based on the service type.
10. The system of claim 9, wherein the business system comprises an accounting system, wherein the business type corresponding to the data change value comprises an entry business and an exit business, and wherein the analysis module is further adapted to:
acquiring a data change value corresponding to the account entry business and a data change value corresponding to the account exit business which are recorded in a preset time range from the wide table;
respectively calculating the total value of the data change value corresponding to the account-entering service and the total value of the data change value corresponding to the account-exiting service;
analyzing whether the total value of the data change value corresponding to the account-entering service and the total value of the data change value corresponding to the account-exiting service have consistency or not;
and the total value of the data change value corresponding to the account-in service and the total value of the data change value corresponding to the account-out service are consistent in the same value.
11. The system of claim 9, wherein the business system comprises an accounting system, the business types corresponding to the data change values include an entry business, an exit business, and a balance business, and the analysis module is further adapted to:
acquiring a data change value corresponding to the account entry service, a data change value corresponding to the account exit service and a data change value corresponding to the balance service which are recorded in a preset time range from the wide table;
respectively calculating the total value of the data change value corresponding to the account entry service, the total value of the data change value corresponding to the account exit service and the total value of the data change value corresponding to the balance service;
analyzing whether the sum of the total value of the data change values corresponding to the posting business and the total value of the data change values corresponding to the balance business are consistent or not;
the sum of the total value of the data change value corresponding to the account-entering service and the total value of the data change value corresponding to the account-exiting service and the total value of the data change value corresponding to the balance service are consistent in value.
12. The system of claim 11,
the posting service comprises at least one item of recharging service, reward money posting, withholding posting and red packet posting;
and/or
The charge-out service comprises at least one item of shared deduction, refund, receipt, user flow-back and cash-back transfer, wherein the user flow-back is used for selecting partial receipt for the user;
and/or
The balance service comprises a valid order balance of the accounting system;
and/or
The plurality of traffic databases include a database for information storage based on block chains.
13. A computer readable storage medium storing computer program code which, when run on a computing device, causes the computing device to perform the method of traffic data detection of any of claims 1-6.
14. A computing device, comprising: a processor; a memory storing computer program code; the computer program code, when executed by the processor, causes the computing device to perform the method of traffic data detection of any of claims 1-6.
CN201911399978.9A 2019-12-30 2019-12-30 Method, system, storage medium and computing device for detecting service data Pending CN111221833A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201911399978.9A CN111221833A (en) 2019-12-30 2019-12-30 Method, system, storage medium and computing device for detecting service data

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201911399978.9A CN111221833A (en) 2019-12-30 2019-12-30 Method, system, storage medium and computing device for detecting service data

Publications (1)

Publication Number Publication Date
CN111221833A true CN111221833A (en) 2020-06-02

Family

ID=70832762

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201911399978.9A Pending CN111221833A (en) 2019-12-30 2019-12-30 Method, system, storage medium and computing device for detecting service data

Country Status (1)

Country Link
CN (1) CN111221833A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112184306A (en) * 2020-09-26 2021-01-05 中国建设银行股份有限公司 Automatic cashback method, device, electronic equipment and computer readable storage medium
CN114244535A (en) * 2022-02-24 2022-03-25 成都易达数安科技有限公司 City-level public display system and method based on block chain technology

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101625686A (en) * 2008-07-08 2010-01-13 阿里巴巴集团控股有限公司 Method and system for monitoring data consistency between plurality of databases
CN102859549A (en) * 2010-04-02 2013-01-02 数据傅维盛有限公司 Fund Transfer Information Presentation System
CN105447707A (en) * 2014-08-26 2016-03-30 阿里巴巴集团控股有限公司 Data processing method and data processing device
CN109493201A (en) * 2018-09-18 2019-03-19 深圳壹账通智能科技有限公司 Account checking method, device, computer equipment and storage medium

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101625686A (en) * 2008-07-08 2010-01-13 阿里巴巴集团控股有限公司 Method and system for monitoring data consistency between plurality of databases
CN102859549A (en) * 2010-04-02 2013-01-02 数据傅维盛有限公司 Fund Transfer Information Presentation System
CN105447707A (en) * 2014-08-26 2016-03-30 阿里巴巴集团控股有限公司 Data processing method and data processing device
CN109493201A (en) * 2018-09-18 2019-03-19 深圳壹账通智能科技有限公司 Account checking method, device, computer equipment and storage medium

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112184306A (en) * 2020-09-26 2021-01-05 中国建设银行股份有限公司 Automatic cashback method, device, electronic equipment and computer readable storage medium
CN114244535A (en) * 2022-02-24 2022-03-25 成都易达数安科技有限公司 City-level public display system and method based on block chain technology
CN114244535B (en) * 2022-02-24 2022-05-17 成都易达数安科技有限公司 City-level public display system and method based on block chain technology

Similar Documents

Publication Publication Date Title
US8156172B2 (en) Monitoring and reporting enterprise data using a message-based data exchange
CN106548402B (en) Resource transfer monitoring method and device
JP4541364B2 (en) Statistical analysis of automatic monitoring and dynamic process metrics to reveal meaningful variations
US20130067182A1 (en) Data processing method and system
US20140108209A1 (en) Aggregate merchant monitoring
WO2019014821A1 (en) Fault early warning method for financial terminal, terminal device and storage medium
US11605014B2 (en) Systems and methods for short identifier behavioral analytics
US20210012346A1 (en) Relation-based systems and methods for fraud detection and evaluation
CN111221833A (en) Method, system, storage medium and computing device for detecting service data
US10352316B2 (en) Systems and methods for evaluating fuel pump data
WO2017092599A1 (en) Method and apparatus for detecting abnormal inventory data, and electronic device
CN109544014B (en) Anti-fraud method and device based on historical data playback
CN108111368A (en) The function test method and device of a kind of transaction system
CN108629467B (en) Sample information processing method and system
CN113961412A (en) Service monitoring processing method and device and electronic equipment
CN109658643B (en) Payment risk warning method, server and intelligent POS (point of sale)
CN105447707B (en) Data processing method and device
US7783509B1 (en) Determining that a change has occured in response to detecting a burst of activity
CN115170017A (en) Waybill processing method and device and storage medium
CN111274255B (en) Service data monitoring method and system, monitoring architecture, equipment and storage medium
CN112862119A (en) Method, device, equipment and medium for improving maintenance efficiency of self-service equipment
CN111061615A (en) Data monitoring method and device for data warehouse, server and storage medium
US8977564B2 (en) Billing account reject solution
CN115545935B (en) Block chain transaction account processing method and device, equipment and medium
CN113505158B (en) Time sequence abnormality detection method, device, equipment 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
CB02 Change of applicant information

Address after: 100102 201 / F, block C, 2 lizezhong 2nd Road, Chaoyang District, Beijing

Applicant after: Beijing Shuidi Technology Group Co.,Ltd.

Address before: Room 4103, room 101, floor 1, building 2, No. 208, Lize Zhongyuan, Chaoyang District, Beijing 100102

Applicant before: Beijing Health Home Technology Co.,Ltd.

CB02 Change of applicant information