CN115905288A - General method and device for generating account checking data through data submission - Google Patents
General method and device for generating account checking data through data submission Download PDFInfo
- Publication number
- CN115905288A CN115905288A CN202211523013.8A CN202211523013A CN115905288A CN 115905288 A CN115905288 A CN 115905288A CN 202211523013 A CN202211523013 A CN 202211523013A CN 115905288 A CN115905288 A CN 115905288A
- Authority
- CN
- China
- Prior art keywords
- target
- data
- reconciliation
- generating
- batch number
- 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
- 238000007429 general method Methods 0.000 title claims abstract description 42
- 230000001360 synchronised effect Effects 0.000 claims abstract description 46
- 238000012545 processing Methods 0.000 claims abstract description 33
- 238000000034 method Methods 0.000 claims description 30
- 238000004590 computer program Methods 0.000 claims description 18
- 238000012546 transfer Methods 0.000 claims description 4
- 238000004891 communication Methods 0.000 description 4
- 238000010586 diagram Methods 0.000 description 3
- 238000007796 conventional method Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000003190 augmentative effect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application discloses a general method and a general device for generating account checking data through data reporting, and belongs to the technical field of data processing. The general method for generating account checking data by data submission comprises the following steps: synchronizing the acquired target data; generating a target business table batch number and target account checking data corresponding to the target business table batch number based on the synchronized target data; and generating a target account checking table based on the target business table batch number and the target account checking data. According to the general method for generating the reconciliation data by data submission, the target data and the target reconciliation table are synchronously acquired and generated, so that the target data and the target reconciliation table can be operated in the same system, the efficiency of processing the target reconciliation data is improved, additional program development is not needed, the generation of the target reconciliation table is simplified, and the system is convenient to maintain.
Description
Technical Field
The application belongs to the technical field of data processing, and particularly relates to a general method and a general device for generating account checking data through data reporting.
Background
With the rapid development of information technology, data sharing applications are growing explosively, and the data required to be processed is increasing. In the account checking process, account checking data can be quickly and accurately acquired and an account checking table is generated, so that the success of account checking is guaranteed. In a conventional method for generating reconciliation data, a program is required to count (count) synchronous records, record the synchronous data volume of a current batch, and then write the synchronous data volume into a reconciliation table.
Disclosure of Invention
The embodiment of the application aims to provide a general method and a device for generating account checking data by data reporting, which can solve the problem that a synchronization scheme and an account checking table generation scheme are separated in a conventional method for generating account checking data.
In a first aspect, an embodiment of the present application provides a general method for generating reconciliation data by datagram, where the method includes:
synchronizing the acquired target data;
generating a target business table batch number and target account checking data corresponding to the target business table batch number based on the synchronized target data;
and generating a target account checking table based on the target business table batch number and the target account checking data.
According to the general method for generating the reconciliation data through data submission, the target reconciliation data corresponding to the target business form batch number and the target business form batch number are generated based on the synchronized target data, and the target reconciliation table is generated based on the target business form batch number and the target reconciliation data, so that the target data acquired synchronously and the scheme for generating the target reconciliation table are unified, the target data acquired synchronously and the target reconciliation table generated synchronously can be operated in the same system, the implementation mode for generating the target reconciliation table is simplified, and the system is convenient to maintain.
In the general method for generating reconciliation data by data submission according to an embodiment of the present application, the synchronizing the obtained target data may include: and (4) incrementally synchronizing target data to the front-end processor by adopting a distributed data synchronization tool datax-web.
According to the general method for generating the reconciliation data by data submission, the data-web increment is adopted to synchronize the target data to the front-end processor, and the method is integrated with a data-web synchronization scheme of an open-source distributed data synchronization tool, so that the consistency of the target data obtained by synchronization is ensured, and the synchronization efficiency of the target data is improved.
In an embodiment of the present application, the general method for generating reconciliation data by data submission, where the generating target accounting data corresponding to a target business form batch number and a target business form batch number based on the synchronized target data includes:
configuring postSql at a front-end processor;
and processing the synchronized target data by adopting the configured postSql to generate the target business table batch number and the target account checking data.
Wherein the target business table batch number comprises at least one of a batch number and a synchronization number.
When the target business table batch number is generated, if the target account checking data in the database is not synchronized on the same day, the format of the generated target business table batch number is 8-bit date (yyyyMMdd) +00001, and if the target business table batch number is synchronized, the maximum batch number of the same day +1 is taken.
According to the general method for generating the reconciliation data by data submission, the synchronized target data is processed by adopting the postSql configured in the front-end processor, the target business table batch number and the target reconciliation data are generated, the realization of general SQL is facilitated, the unification of the target data acquired synchronously and the scheme for generating the target reconciliation table is realized, the target data acquired synchronously and the target reconciliation table generated synchronously can be operated in the same system, the efficiency of processing the target reconciliation data is improved, and the system is convenient to maintain.
In an embodiment of the present application, after generating a target reconciliation table based on a target transaction table batch number and target reconciliation data, the method includes:
determining that the field value of the batch state is '0' under the condition that the target reconciliation data corresponds to the target file;
in a case where the target reconciliation data does not correspond to the target file, it is determined that a field value of the batch status is "1".
According to the general method for generating the reconciliation data through data submission, whether the target reconciliation data uploads the corresponding target file or not is represented by setting the batch state, so that the integrity of the target reconciliation data is ensured, the rate of generating the target reconciliation table is improved, and a user can conveniently search the file.
In an embodiment of the application, in a general method for generating reconciliation data by datagram, after determining that a field value of a batch state is "0" when the target reconciliation data corresponds to the target file, the method includes:
synchronizing the target file to a front-end processor;
updating a field value of the lot status to '1'.
According to the general method for generating the reconciliation data through data submission, after the field value of the batch state is determined to be '0', the target file corresponding to the target data is synchronized to the specified directory of the front-end processor, and then the field value of the batch state is updated to be '1', so that the batch state is updated in real time, the integrity and the real-time performance of the target reconciliation data are ensured, and the rate of generating the target reconciliation table and the accuracy of the generated target reconciliation table are improved.
In an embodiment of the present application, before the synchronizing the acquired target data, a general method for generating reconciliation data by data submission includes:
and acquiring the target data from a database based on the target synchronization frequency.
The target synchronization frequency is used for representing relevant information of two adjacent synchronization time intervals in one day.
According to the general method for generating the reconciliation data through data submission, the target synchronization frequency is set when the acquired target data are synchronized, so that the manual workload is reduced, the integrity and the real-time performance of the acquired target reconciliation data are ensured, and the efficiency of synchronizing the acquired target data is improved.
In a second aspect, an embodiment of the present application provides a general-purpose apparatus for generating reconciliation data by data reporting, where the apparatus includes:
a first processing module for synchronizing the acquired target data;
the second processing module is used for generating the target business table batch number and target reconciliation data corresponding to the target business table batch number based on the synchronized target data;
a third processing module, configured to generate the target reconciliation table based on the target transaction table batch number and the target reconciliation data;
a fourth processing module, configured to determine, after the target reconciliation table is generated based on the target business table batch number and the target reconciliation data, that a field value of a batch state is "0" when the target reconciliation data corresponds to the target file;
a fifth processing module, configured to determine that a field value of the batch state is "1" when the target reconciliation data does not correspond to the target file;
a sixth processing module, configured to, when the target reconciliation data corresponds to the target file, determine that a field value of the batch state is "0", synchronize the target file corresponding to the target reconciliation data to the front-end processor, and update the field value of the batch state to "1" after the target file is synchronized to the directory specified by the front-end processor;
and the seventh processing module is used for setting the target synchronization frequency before the obtained target data is synchronized, and the shell script carries out the synchronization operation of the target data according to the target synchronization frequency.
According to the general device for generating the reconciliation data by data submission, the target reconciliation data corresponding to the target business form batch number and the target business form batch number are generated based on the synchronized target data, and the target reconciliation table is generated based on the target business form batch number and the target reconciliation data, so that the target data and the target reconciliation table are synchronously acquired, the target data and the target reconciliation table are generated, the target data and the target reconciliation table can be operated in the same system, a program is not required to be developed additionally, the implementation mode for generating the target reconciliation table is simplified, and the system is convenient to maintain.
In a third aspect, an embodiment of the present application provides an electronic device, which includes a memory, a processor, and a computer program stored on the memory and executable on the processor, where the processor, when executing the computer program, implements the general method for generating reconciliation data by datagram delivery as described in the first aspect above.
In a fourth aspect, embodiments of the present application provide a non-transitory computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the general method for generating reconciliation data in a datagram as described in the first aspect above.
In a sixth aspect, embodiments of the present application provide a computer program product, which includes a computer program, and when the computer program is executed by a processor, the computer program implements the general method for generating reconciliation data in a datagram as described in the first aspect above.
Drawings
The above and/or additional aspects and advantages of the present application will become apparent and readily appreciated from the following description of the embodiments, taken in conjunction with the accompanying drawings of which:
fig. 1 is a schematic flowchart of a general method for generating reconciliation data by data submission according to an embodiment of the present application;
fig. 2 is a second flowchart of a general method for generating reconciliation data by data submission according to an embodiment of the present application;
fig. 3 is a schematic structural diagram of a general apparatus for generating reconciliation data by data submission according to an embodiment of the present application;
fig. 4 is a schematic structural diagram of an electronic device provided in an embodiment of the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be described below clearly with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are some, but not all, embodiments of the present application. All other embodiments that can be derived by one of ordinary skill in the art from the embodiments given herein are intended to be within the scope of the present disclosure.
The terms first, second and the like in the description and in the claims of the present application are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It will be appreciated that the data so used may be interchanged under appropriate circumstances such that embodiments of the application may be practiced in sequences other than those illustrated or described herein, and that the terms "first," "second," and the like are generally used herein in a generic sense and do not limit the number of terms, e.g., the first term can be one or more than one. In addition, "and/or" in the specification and claims means at least one of connected objects, a character "/" generally means that a preceding and succeeding related objects are in an "or" relationship.
A general method for generating reconciliation data for a data submission according to an embodiment of the present application is described below with reference to fig. 1 and 2.
It should be noted that the execution subject of the general method for generating reconciliation data by datagram may be a server, or may be a general device for generating reconciliation data by datagram, or may also be a terminal of a user, including but not limited to a mobile terminal and a non-mobile terminal.
For example, the mobile terminal includes, but is not limited to, a mobile phone, a PDA smart terminal, a tablet computer, a vehicle-mounted smart terminal, and the like; non-mobile terminals include, but are not limited to, PC terminals, etc.
As shown in fig. 1, the general method for generating reconciliation data by data submission includes: step 110, step 120 and step 130.
Step 110: synchronizing the acquired target data;
in this step, the target data is data updated in the database in real time.
For example, data may be managed for an enterprise. It will be appreciated that these data are updated in real time.
It should be noted that, in the present application, the synchronization of the target data and the subsequent steps are performed in the same system.
As shown in FIG. 2, in some embodiments, synchronizing the acquired target data may include: and synchronizing the target data to the front-end processor by adopting datax-web increment.
In this embodiment, the datax-web is a distributed data synchronization tool that can synchronize target data.
Of course, in other embodiments, any other method for achieving data synchronization may also be used, and the present application is not limited thereto.
In some embodiments, prior to step 110, the method may further comprise: and acquiring target data from the database based on the target synchronization frequency.
In this embodiment, the target synchronization frequency is used to characterize the relevant information of two adjacent synchronization time intervals in a day.
The target synchronization frequency may be customized based on a user, for example, the target synchronization frequency is set to 1h or 2h, and the target synchronization frequency may be set based on actual needs, which is not limited in the present application.
For example, in the situation of fast data update, the value of the target synchronization frequency may be set to a time interval with a shorter interval to increase the synchronization frequency; for another example, in a situation where data update is slow, the target synchronization frequency may be set to a value with a longer interval, so as to reduce system power consumption.
According to the general method for generating reconciliation data through data submission, provided by the embodiment of the application, the target data are synchronized to the front-end processor by adopting the datax-web increment, and the target data are integrated with the datax-web synchronization scheme of the open-source distributed data synchronization tool, so that the consistency of the synchronized target reconciliation data is ensured, the target synchronization frequency is set when the acquired target data are synchronized, the manual workload is reduced, the integrity and the real-time performance of the acquired target reconciliation data are ensured, and the efficiency of synchronizing the acquired target data is improved.
Step 120: generating a target business table batch number and target account checking data corresponding to the target business table batch number based on the synchronized target data;
in this step, the target business table batch number refers to the number of the target data of the batch that is synchronized.
The target reconciliation data refers to the data volume of the target business table in the batch.
In the actual execution process, the synchronized target data may be processed by using SQL, C, JAVA, and the like to generate the target business table batch number and the target reconciliation data, which is not limited in this application.
Next, the implementation of step 120 is specifically described by taking SQL as an example.
With continued reference to fig. 2, in some embodiments, generating target reconciliation data corresponding to the target business table batch number and the target business table batch number based on the synchronized target data may include:
configuring postSql at a front-end processor;
and processing the synchronized target data by adopting the configured postSql to generate a target business table batch number and target account checking data.
In this embodiment, the target business table batch number may include at least one of a batch number and a number of synchronizations.
For example, the target service table batch number may include a batch number, or the target service table batch number includes a synchronization number, or the target service table batch number includes a batch number and a synchronization number, such as "(yyymmdd) +00001", where "(yyyyMMdd)" is the batch number, and "00001" is the synchronization number.
In actual implementation, the target business table batch number may be generated by the following procedure.
UPDATE@table SET Cd_batch＝(SELECTIFNULL(MAX(Cd_batch)+1,CONCAT(DATE_FORMAT(NOW(),'％Y％m％d'),'00001'))FROM ech_batch
WHERE TableName＝'@table'AND Cd_batch LIKE CONCAT(DATE_FORMAT(NOW(),'％Y％m％d'),'％'))
WHERE Cd_batch IS NULL
For example, when the target service table batch number is generated, if the target data in the database is not synchronized on the same day, the format of the generated target service table batch number is 8-bit date (yyyyMMdd) +00001, and if the target service table batch number is synchronized, the maximum batch number on the same day +1 is taken.
According to the general method for generating the reconciliation data by data submission, the synchronized target data is processed by the postSql configured in the front-end processor, the target business table batch number and the target reconciliation data are generated, additional program development is not needed, the realization of the general SQL is facilitated, the unification of the target data obtained synchronously and the scheme for generating the target reconciliation table is realized, the target data obtained synchronously and the target reconciliation table can be operated in the same system, the efficiency of processing the target reconciliation data is improved, and the system is convenient to maintain.
Step 130: generating a target account checking table based on the target business table batch number and the target account checking data;
in this step, the target reconciliation table may be a reconciliation account table.
For example, a form for checking accounts may be made for a business, and the conditions for checking accounts generally include the date the business occurred, the settlement formula, the settlement ticket number, and the amount of the occurred amount being equal. Wherein, the same occurrence amount is the basic condition of account checking.
The data type contained in the target reconciliation table can be selected by a user in a user-defined way according to needs, and the application is not limited.
In the actual execution process, the target business table batch number and the target reconciliation data can be processed by using SQL language, C language, JAVA language and the like, which is not limited in the present application.
In the following, using SQL as an example, a specific description is given to an implementation manner of generating target reconciliation data and inserting the target reconciliation data into the target reconciliation table:
INSERT INTO ech_batch(TableName,Cd_batch,Cd_count,Cd_time,Batch_Status)
SELECT t.TableName,t.Cd_batch,b.cd_count,NOW(),1FROM(
SELECT'@table'TableName,
IFNULL(MAX(Cd_batch)+1,CONCAT(DATE_FORMAT(NOW(),'％Y％m％d'),'00001'))AS Cd_batch FROM ech_batch
WHERE TableName＝'@table'
AND Cd_batch LIKE CONCAT(DATE_FORMAT(NOW(),'％Y％m％d'),'％')
)t
LEFT JOIN(
SELECT Cd_batch,COUNT(*)cd_count FROM@table
WHERE Cd_batch>＝CONCAT(DATE_FORMAT(NOW(),'％Y％m％d'),'00001')
GROUP BY Cd_batch
)b ON b.Cd_batch＝t.Cd_batch
WHERE cd_count>0
in the embodiment, the table name TableName field value uses a datax built-in variable @ table to obtain the table name of the current synchronization;
the acquisition of the value of the batch number Cd _ batch field is consistent with the implementation of generating the batch number of the target service table, and is not described herein;
counting target reconciliation data corresponding to the batch number of the target service table of the current batch synchronization by using the data volume Cd _ count field value through an SQL language;
the synchronization time cd _ time field value uses the system current time.
According to the general method for generating account-checking data through data submission, provided by the embodiment of the application, the target account-checking data corresponding to the target business form batch number and the target business form batch number are generated based on the synchronized target data, and the target account-checking form is generated based on the target business form batch number and the target account-checking data, so that the target data acquired synchronously and the target account-checking form generated synchronously can be operated in the same system without additional program development, the realization mode of generating the account-checking form is simplified, and the system is convenient to maintain.
In some embodiments, the target tie-out table may include a batch status, and after step 130, the method may further include:
under the condition that the target reconciliation data correspond to the target file, determining the field value of the batch state to be 0;
in the case where the target reconciliation data does not correspond to the target file, the field value of the batch status is determined to be "1".
In this embodiment, the batch status is used to characterize whether the target reconciliation data in the target reconciliation table corresponds to a file.
In actual implementation, the batch status may be characterized by using field values, and different field values correspond to different batch statuses.
Wherein, the field value of the batch state can be determined by the following method:
when target reconciliation data in the target reconciliation table containing target files are uploaded, the field value of the Batch state Batch _ Status is determined to be 0;
when the target reconciliation data in the target reconciliation table is detected not to contain the target file for uploading, the field value of the Batch Status Batch _ Status is determined to be '1'.
According to the general method for generating the reconciliation data through data submission, which is provided by the embodiment of the application, whether the target reconciliation data is uploaded with the corresponding target file is represented by setting the batch state, so that the integrity of the target reconciliation data is ensured, the rate of generating the target reconciliation table is improved, and the file searching by a user is facilitated.
In some embodiments, in a case that the target reconciliation data corresponds to the target file, after determining that the field value of the batch status is "0", the method may further include:
synchronizing the target file to the front-end processor;
the field value of the lot status is updated to "1".
In this embodiment, the front-end processor refers to an intermediate device used in the field.
For another example, in the actual execution process, when it is detected that the target reconciliation data in the target reconciliation table contains the target file to be uploaded, the field value of the Batch Status Batch _ Status is determined to be "0"; and then, synchronizing the target file corresponding to the target account checking data to the front-end processor, and updating the field value of the Batch state Batch _ Status to be 1 after the target file is synchronized to the specified directory of the front-end processor.
According to the general method for generating the reconciliation data through data submission, provided by the embodiment of the application, after the field value of the batch state is determined to be '0', the target file corresponding to the target data is synchronized to the specified directory of the front-end processor, and then the field value of the batch state is updated to be '1', so that the batch state is updated in real time, the integrity and the real-time performance of the target reconciliation data are ensured, and the rate of generating the target reconciliation table and the accuracy of the generated target reconciliation table are improved.
The following describes a general apparatus for generating reconciliation data by data transfer according to the present application, and the general apparatus for generating reconciliation data by data transfer described below and the general method for generating reconciliation data by data transfer described above can be referred to in correspondence with each other.
According to the general method for generating the reconciliation data by the data submission, an execution main body can be a general device for generating the reconciliation data for the data submission. The embodiment of the present application takes a general method for generating reconciliation data by data submission performed by a general-purpose device for generating reconciliation data by data submission as an example, and describes a general-purpose device for generating reconciliation data by data submission provided in the embodiment of the present application.
The embodiment of the application also provides a general device for generating the reconciliation data by data reporting.
As shown in fig. 3, the general-purpose apparatus for generating reconciliation data by datagram includes: a first processing module 310, a second processing module 320, and a third processing module 330.
In this embodiment, the first processing module 310 is configured to synchronize the acquired target data;
the second processing module 320 is configured to generate a target business table batch number and target reconciliation data corresponding to the target business table batch number based on the synchronized target data;
and the third processing module 330 is configured to generate a target reconciliation table based on the target transaction table batch number and the target reconciliation data.
According to the general device for generating reconciliation data through data submission, which is provided by the embodiment of the application, the target reconciliation data corresponding to the target business table batch number and the target business table batch number are generated based on the synchronized target data, and the target reconciliation table is generated based on the target business table batch number and the target reconciliation data, so that the target data acquired synchronously and the target reconciliation table generated synchronously can be unified, the target data acquired synchronously and the target reconciliation table generated synchronously can be operated in the same system, a program is not required to be developed additionally, the realization mode of generating the reconciliation table is simplified, and the system is convenient to maintain.
In some embodiments, the first processing module 310 may further be configured to: and synchronizing the target data to the front-end processor by adopting datax-web increment.
According to the general device for generating reconciliation data through data submission, provided by the embodiment of the application, the target data are synchronized to the front-end processor by adopting the data-web increment, and the data-web synchronization scheme is integrated with the data-web synchronization scheme of the open-source distributed data synchronization tool, so that the consistency of the target data obtained by synchronization is ensured, and the synchronization efficiency of the target data is improved.
In some embodiments, the second processing module 320 may further include:
configuring postSql at a front-end processor;
processing the synchronized target data by adopting the configured postSql to generate a target business table batch number and target account checking data;
in this embodiment, the target business table batch number includes at least one of a batch number and a number of synchronizations.
For example, the target service table batch number includes a batch number, or the target service table batch number includes a synchronization number, or the target service table batch number includes a batch number and a synchronization number, such as "(yyymmdd) +00001", where "(yyyyMMdd)" is a batch number, and "00001" is a synchronization number.
According to the general device for generating the reconciliation data by data submission, the synchronized target data is processed by adopting the postSql configured in the front-end processor, the target business table batch number and the target reconciliation data are generated, the realization of general SQL is facilitated, the unification of the synchronously acquired target data and the scheme for generating the target reconciliation table is realized, the synchronously acquired target data and the generated target reconciliation table can be operated in the same system, the efficiency for processing the target reconciliation data is improved, and the system is convenient to maintain.
In some embodiments, the third processing module 330, the target tie-out table, may include a lot status.
In this embodiment, the batch status is used to characterize whether the target reconciliation data in the target reconciliation table corresponds to a file.
In the actual implementation process, the batch status can be characterized by using field values, and different field values correspond to different batch statuses. In some embodiments, the apparatus may further include a fourth processing module, configured to determine that a field value of the batch status is "0" in a case that the destination reconciliation data corresponds to the destination file after the destination reconciliation table is generated based on the destination transaction table batch number and the destination reconciliation data.
In some embodiments, the apparatus may further include a fifth processing module configured to determine that a field value of the batch status is "1" in a case where the target reconciliation data does not correspond to the target file.
According to the general device for generating the reconciliation data through data submission, whether the target reconciliation data are uploaded with the corresponding target file is represented by setting the batch state, so that the integrity of the target reconciliation data is ensured, the rate of generating the target reconciliation table is improved, and the file searching by a user is facilitated.
In some embodiments, the apparatus may further include a sixth processing module, configured to, in a case that the target reconciliation data corresponds to the target file, after determining that a field value of the Batch Status is "0", synchronize the target file corresponding to the target reconciliation data to the front-end processor, and after the target file is synchronized to a specified directory of the front-end processor, update the field value of the Batch Status Batch _ Status to "1".
According to the general device for generating the reconciliation data through data submission, provided by the embodiment of the application, after the field value of the batch state is determined to be '0', the target file corresponding to the target data is synchronized to the specified directory of the front-end processor, and then the field value of the batch state is updated to be '1', so that the batch state is updated in real time, the integrity and the real-time performance of the target reconciliation data are ensured, and the rate of generating the target reconciliation table and the accuracy of the generated target reconciliation table are improved.
In some embodiments, the apparatus may further include a seventh processing module to set a target synchronization frequency prior to synchronizing the acquired target data.
The target synchronization frequency is used for representing the related information of two adjacent synchronization time intervals in one day.
The target synchronization frequency may be customized based on a user, for example, the target synchronization frequency is set to 1h or 2h, and the target synchronization frequency may be set based on actual needs, which is not limited in the present application.
For example, in a situation where data update is fast, the value of the target synchronization frequency may be set to a shorter interval to increase the synchronization frequency; for another example, in a situation where data update is slow, the target synchronization frequency may be set to a value with a longer interval, so as to reduce system power consumption.
According to the general device for generating the reconciliation data by data submission, provided by the embodiment of the application, the target synchronization frequency is set when the acquired target data are synchronized, so that the manual workload is reduced, the integrity and the real-time performance of the acquired target reconciliation data are ensured, and the efficiency of synchronizing the acquired target data is improved.
The general device for generating reconciliation data by data submission in the embodiment of the present application may be an electronic device, or may be a component in an electronic device, such as an integrated circuit or a chip. The electronic device may be a terminal, or may be a device other than a terminal. The electronic Device may be, for example, a Mobile phone, a tablet computer, a notebook computer, a palm top computer, a vehicle-mounted electronic Device, a Mobile Internet Device (MID), an Augmented Reality (AR)/Virtual Reality (VR) Device, a robot, a wearable Device, an ultra-Mobile personal computer (UMPC), a netbook or a Personal Digital Assistant (PDA), and the like, and may also be a server, a Network Attached Storage (Network Attached Storage, NAS), a personal computer (NAS), a Television (TV), a teller machine, a self-service machine, and the like, and the embodiments of the present application are not limited in particular.
The general device for generating the reconciliation data by data submission in the embodiment of the application may be a device with an operating system. The operating system may be an Android operating system, an IOS operating system, or other possible operating systems, which is not specifically limited in the embodiment of the present application.
The general-purpose apparatus for generating reconciliation data by data submission according to the embodiment of the present application can implement each process implemented by the method embodiments of fig. 1 to fig. 2, and is not described herein again to avoid repetition.
Fig. 4 illustrates a physical structure diagram of an electronic device, which may include, as shown in fig. 4: a processor (processor) 410, a communication Interface 420, a memory (memory) 430 and a communication bus 440, wherein the processor 410, the communication Interface 420 and the memory 430 are communicated with each other via the communication bus 440. The processor 410 may invoke logic instructions in the memory 430 to perform a general method of performing a data posting to generate reconciliation data, the method comprising: synchronizing the acquired target data; generating a target business table batch number and target account checking data corresponding to the target business table batch number based on the synchronized target data; and generating a target account checking table based on the target business table batch number and the target account checking data.
In addition, the logic instructions in the memory 430 may be implemented in the form of software functional units and stored in a computer readable storage medium when the software functional units are sold or used as independent products. Based on such understanding, the technical solution of the present application or portions thereof that substantially contribute to the prior art may be embodied in the form of a software product stored in a storage medium and including instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
In another aspect, the present application also provides a computer program product comprising a computer program stored on a non-transitory computer readable storage medium, the computer program comprising program instructions which, when executed by a computer, enable the computer to perform the general method of generating reconciliation data for a datagram provided by the methods described above, the method comprising: synchronizing the acquired target data; generating a target business table batch number and target account checking data corresponding to the target business table batch number based on the synchronized target data; and generating a target account checking table based on the target business table batch number and the target account checking data.
In yet another aspect, the present application also provides a non-transitory computer readable storage medium having stored thereon a computer program that when executed by a processor performs the general method of generating reconciliation data for a datagram provided above, the method comprising: synchronizing the acquired target data; generating a target business table batch number and target account checking data corresponding to the target business table batch number based on the synchronized target data; and generating a target account checking table based on the target business table batch number and the target account checking data.
The above-described embodiments of the apparatus are merely illustrative, and the units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment. One of ordinary skill in the art can understand and implement it without inventive effort.
Through the above description of the embodiments, those skilled in the art will clearly understand that each embodiment can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware. With this understanding in mind, the above-described technical solutions may be embodied in the form of a software product, which can be stored in a computer-readable storage medium such as ROM/RAM, magnetic disk, optical disk, etc., and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the methods described in the embodiments or some parts of the embodiments.
Finally, it should be noted that: the above embodiments are only used to illustrate the technical solutions of the present application, and not to limit the same; although the present application has been described in detail with reference to the foregoing embodiments, it should be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions in the embodiments of the present application.
Claims (10)
1. A general method for generating reconciliation data from a data report, comprising:
synchronizing the acquired target data;
generating a target business table batch number and target account checking data corresponding to the target business table batch number based on the synchronized target data;
and generating a target account checking table based on the target business table batch number and the target account checking data.
2. The method of claim 1, wherein the synchronizing the acquired target data comprises:
and synchronizing the target data to the front-end processor by adopting datax-web increment.
3. The universal method for generating reconciliation data for data reporting according to claim 1, wherein the generating target reconciliation data for a target hotlist batch number and a target hotlist batch number based on the synchronized target data comprises:
configuring postSql in a front-end processor;
processing the synchronized target data by adopting the configured postSql to generate the batch number of the target business table and the target account checking data;
wherein the target business table batch number includes at least one of a batch number and a synchronization number.
4. The generalized method of generating reconciliation data for a datagram according to any one of claims 1-3, wherein the target reconciliation table comprises a batch status, and wherein after the generating of the target reconciliation table based on the target business table batch number and the target reconciliation data, the method comprises:
determining that the field value of the batch state is '0' under the condition that the target reconciliation data corresponds to a target file;
and in the case that the target account checking data does not correspond to the target file, determining that the field value of the batch state is 1.
5. The general method for generating reconciliation data for data submission according to claim 4, wherein in case that the target reconciliation data corresponds to a target file, after determining that the field value of the batch status is "0", the method comprises:
synchronizing the target file to a front-end processor;
updating a field value of the lot status to '1'.
6. A generic method of datagram-generated reconciliation data according to any of claims 1-3, wherein prior to the synchronization of the acquired target data the method comprises:
and acquiring the target data from a database based on the target synchronization frequency.
7. A general purpose device for generating reconciliation data from a data report, comprising:
the first processing module is used for synchronizing the acquired target data;
the second processing module is used for generating a target business table batch number and target reconciliation data corresponding to the target business table batch number based on the synchronized target data;
and the third processing module is used for generating a target account checking table based on the target business table batch number and the target account checking data.
8. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor, when executing the program, implements the general method of generating reconciliation data for a data transfer according to any of claims 1 to 6.
9. A non-transitory computer-readable storage medium, on which a computer program is stored, which computer program, when being executed by a processor, carries out the general method for generating ledger data from a datagram according to any of claims 1-6.
10. A computer program product comprising a computer program, wherein the computer program, when executed by a processor, implements the general method of generating ledger data from a datagram according to any of claims 1-6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211523013.8A CN115905288B (en) | 2022-11-30 | 2022-11-30 | General method and device for generating reconciliation data by data reporting |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211523013.8A CN115905288B (en) | 2022-11-30 | 2022-11-30 | General method and device for generating reconciliation data by data reporting |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115905288A true CN115905288A (en) | 2023-04-04 |
| CN115905288B CN115905288B (en) | 2024-03-15 |
Family
ID=86483132
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211523013.8A Active CN115905288B (en) | 2022-11-30 | 2022-11-30 | General method and device for generating reconciliation data by data reporting |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115905288B (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111797166A (en) * | 2020-06-29 | 2020-10-20 | 中国工商银行股份有限公司 | Quasi-real-time resume data synchronization method and device, electronic equipment and medium |
| CN113076340A (en) * | 2021-03-22 | 2021-07-06 | 北京同邦卓益科技有限公司 | Accounting data processing method and device, electronic equipment and storage medium |
| CN113420057A (en) * | 2021-06-29 | 2021-09-21 | 未鲲(上海)科技服务有限公司 | Account checking data processing method and related device |
| CN113962789A (en) * | 2021-11-02 | 2022-01-21 | 中国银行股份有限公司 | Bank account checking method and device |
-
2022
- 2022-11-30 CN CN202211523013.8A patent/CN115905288B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111797166A (en) * | 2020-06-29 | 2020-10-20 | 中国工商银行股份有限公司 | Quasi-real-time resume data synchronization method and device, electronic equipment and medium |
| CN113076340A (en) * | 2021-03-22 | 2021-07-06 | 北京同邦卓益科技有限公司 | Accounting data processing method and device, electronic equipment and storage medium |
| CN113420057A (en) * | 2021-06-29 | 2021-09-21 | 未鲲(上海)科技服务有限公司 | Account checking data processing method and related device |
| CN113962789A (en) * | 2021-11-02 | 2022-01-21 | 中国银行股份有限公司 | Bank account checking method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115905288B (en) | 2024-03-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108536752B (en) | Data synchronization method, device and equipment | |
| CN107766575B (en) | Read-write separation database access method and device | |
| CN105493028B (en) | Data consistency and rollback for cloud analysis | |
| CN106997431B (en) | Data processing method and device | |
| CN110109981B (en) | Information display method and device for work queue, computer equipment and storage medium | |
| CN110727702A (en) | Data query method, device, terminal and computer readable storage medium | |
| CN104317957A (en) | Open platform and system for processing reports and report processing method | |
| CN112328275A (en) | Data updating method and device for nuclear power plant, terminal equipment and storage medium | |
| CN116204438A (en) | Test case generation method, automatic test method and related device | |
| CN114416485A (en) | Data processing method and device | |
| CN114398520A (en) | Data retrieval method, system, device, electronic equipment and storage medium | |
| CN112199443B (en) | Data synchronization method and device, computer equipment and storage medium | |
| CN113596107A (en) | Data synchronization method and device based on block chain | |
| CN110046172B (en) | Online computing data processing method and system | |
| CN115905288A (en) | General method and device for generating account checking data through data submission | |
| CN111046077A (en) | Data acquisition method and device, storage medium and terminal | |
| CN109189864B (en) | Method, device and equipment for determining data synchronization delay | |
| CN115757642A (en) | Data synchronization method and device based on filing log file | |
| CN116360787A (en) | Automatic generation method and device for form codes, electronic equipment and storage medium | |
| CN110609854A (en) | Method, system, electronic device and computer storage medium for field name query | |
| CN113010588A (en) | Data table processing method | |
| CN114237699B (en) | Configuration script exporting method and device and storage medium | |
| CN111563091B (en) | Method and system for batch updating MongoDB in non-round-trip mode | |
| CN113220760B (en) | Data processing method, device, server and storage medium | |
| CN108363617B (en) | Asynchronous importing method for offline list on SSR (simple sequence repeat) |
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 | ||
| PE01 | Entry into force of the registration of the contract for pledge of patent right |
Denomination of invention: General method and device for generating reconciliation data through data submission Granted publication date: 20240315 Pledgee: China Everbright Bank Limited by Share Ltd. Guangzhou branch Pledgor: GRG BANKING IT Co.,Ltd. Registration number: Y2024980019991 |
|
| PE01 | Entry into force of the registration of the contract for pledge of patent right |