CN112287658A - Business data processing method and device, electronic equipment and medium - Google Patents
Business data processing method and device, electronic equipment and medium Download PDFInfo
- Publication number
- CN112287658A CN112287658A CN202011212592.5A CN202011212592A CN112287658A CN 112287658 A CN112287658 A CN 112287658A CN 202011212592 A CN202011212592 A CN 202011212592A CN 112287658 A CN112287658 A CN 112287658A
- Authority
- CN
- China
- Prior art keywords
- data
- data table
- version number
- temporary
- version
- 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
Links
- 238000003672 processing method Methods 0.000 title abstract description 9
- 238000013479 data entry Methods 0.000 claims abstract description 169
- 238000000034 method Methods 0.000 claims abstract description 43
- 238000012545 processing Methods 0.000 claims description 20
- 230000008676 import Effects 0.000 claims description 17
- 238000004590 computer program Methods 0.000 claims description 10
- 230000008569 process Effects 0.000 abstract description 11
- 230000004048 modification Effects 0.000 description 20
- 238000012986 modification Methods 0.000 description 20
- 238000010586 diagram Methods 0.000 description 8
- 238000004891 communication Methods 0.000 description 7
- 230000006870 function Effects 0.000 description 7
- 230000008901 benefit Effects 0.000 description 5
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000012217 deletion Methods 0.000 description 3
- 230000037430 deletion Effects 0.000 description 3
- 238000011161 development Methods 0.000 description 3
- 230000008859 change Effects 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 238000009825 accumulation Methods 0.000 description 1
- 230000009471 action Effects 0.000 description 1
- 238000007792 addition Methods 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 230000001186 cumulative effect Effects 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 230000003252 repetitive effect Effects 0.000 description 1
- 230000004044 response Effects 0.000 description 1
- 230000002441 reversible effect Effects 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/197—Version control
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- General Health & Medical Sciences (AREA)
- Computational Linguistics (AREA)
- General Engineering & Computer Science (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (AREA)
- Health & Medical Sciences (AREA)
- Accounting & Taxation (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Finance (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application provides a service data processing method, a device, an electronic device and a medium, wherein the method comprises the following steps: receiving a comparison request, wherein the comparison request carries a first version number and a second version number, the first version number and the second version number are version numbers in a version number list, the version number list stores the version number which is generated after the data table updates data each time and corresponds to a new version data table, and the version number is associated with all data items of the new version data table; generating a first temporary data table based on the data entries associated with the first version number, and generating a second temporary data table based on the data entries associated with the second version number; and carrying out difference comparison on the first temporary data table and the second temporary data table. The data table with any version is stored by storing the updated data entry and associating the newly generated version number with the data entry of the data table with the new version, so that the comparison of the data tables with any two versions can be realized in the actual use process.
Description
Technical Field
The application relates to the technical field of internet finance, in particular to a business data processing method, a business data processing device, electronic equipment and a medium.
Background
With the development of the technology, in the operation process of the financial institution, the related asset package is imported into the Internet system of the financial institution for management, and the data in the asset package is displayed and edited in a webpage table mode. For example, Asset packs in Asset-backed security (ABS) scenarios, an ABS is a trusted benefit right share issued by a trusted authority representing a particular purpose trust.
The data volume of the asset pack is generally very large, and under the condition of maintaining the products corresponding to the asset pack unchanged, some data entries in the asset pack need to be replaced in time, wherein the change of the entries wastes time and labor if a worker checks the data in one stroke, and the error rate is high. It is an urgent need to free the manpower from such redundant repetitive work. The Excel comparison has the advantages of complex operation, unobvious result, no pertinence and hard appearance.
In the prior art, in order to save memory, only the data tables of the two recent versions are saved, so that only the data tables of the two recent versions can be compared, and data difference comparison cannot be performed on the data tables of any two historical versions.
Disclosure of Invention
The application aims to provide a business data processing method, a business data processing device, electronic equipment and a medium.
In a first aspect, the present application provides a method for processing service data, including:
receiving a comparison request, wherein the comparison request carries a first version number and a second version number, the first version number and the second version number are version numbers in a version number list, the version number list stores the version number, generated after each data updating, of a data table, corresponding to a new version data table, and the version number, generated after each data updating, of the data table is associated with all data entries of the new version data table;
generating a first temporary data table based on the data entry associated with the first version number, and generating a second temporary data table based on the data entry associated with the second version number; wherein each data entry has a unique identification ID;
performing difference comparison on the first temporary data table and the second temporary data table to obtain updated data of the second temporary data table compared with the first temporary data table;
and displaying the updated data according to a preset mode.
In some embodiments of the present application, the version number generated after the data table updates data each time is associated with all data entries of a new version data table, including:
determining a new data entry generated after the data table updates data, generating a sub-version number of the new data entry, and keeping the sub-version number of the data entry without data update unchanged;
and associating the version number with the respective sub-version numbers of all data entries of the new version data table.
In some embodiments of the present application, the comparing the difference between the first temporary data table and the second temporary data table to obtain updated data of the second temporary data table compared to the first temporary data table includes:
determining whether the identification IDs of the data entries in the first temporary data table and the second temporary data table are one-to-one identical,
if the data entries are the same, performing difference comparison on the data entries with the same identification ID in the first temporary data table and the second temporary data table to obtain the data entries with data update in the second temporary data table compared with the first temporary data table and the data updated in the data entries;
if the identification IDs of the data entries in the first temporary data table and the second temporary data table are not the same, determining the data entries added and/or deleted by the second temporary data table compared with the first temporary data table; and comparing the difference of the data entries with the same identification ID in the first temporary data table and the second temporary data table to obtain the data entries with data update in the second temporary data table compared with the first temporary data table and the data updated in the data entries.
In some embodiments of the present application, the performing a difference comparison on the data entries with the same ID in the first temporary data table and the second temporary data table comprises:
and performing difference comparison on data entries with the same identification ID and different sub-version numbers in the first temporary data table and the second temporary data table.
In some embodiments of the present application, the generating a sub-version number of the new data entry includes: the sub-version number of each new data entry is the same as the version number of the new version data table.
In some embodiments of the present application, the receiving a contrast request comprises:
and displaying the version numbers stored in the version number list, and determining that two version numbers selected by a user in sequence are the first version number and the second version number respectively, wherein the version number selected by the user firstly is the first version number and then is the second version number.
In some embodiments of the present application, the method further comprises:
when an import request for an asset pack is received, reading the identification ID of each data item in the asset pack, judging whether the same identification ID exists in the data table or not, and if so, updating the data item in the data table to the data item in the asset pack; and if not, inserting the data entry in the asset pack into a blank table of the data table.
In a second aspect, the present application provides a service data processing apparatus, including:
the device comprises a version number generation module, a comparison module and a comparison module, wherein the comparison request carries a first version number and a second version number, the first version number and the second version number are version numbers in a version number list, the version number list stores the version number, generated after data are updated each time, of a data table, and the version number generated after the data are updated each time of the data table is associated with all data entries of the new version data table;
a temporary data table generating module, configured to generate a first temporary data table based on the data entry associated with the first version number, and generate a second temporary data table based on the data entry associated with the second version number; wherein each data entry has a unique identification ID;
the data table comparison module is used for carrying out difference comparison on the first temporary data table and the second temporary data table to obtain updated data of the second temporary data table compared with the first temporary data table;
and the display module is used for displaying the updated data according to a preset mode.
In a third aspect, the present application provides an electronic device, comprising: one or more processors; memory for storing one or more programs which, when executed by the one or more processors, cause the one or more processors to implement the method as described above.
In a fourth aspect, the present application provides a computer-readable storage medium having stored thereon a computer program, characterized in that the program, when executed by a processor, implements the method as described above.
Compared with the prior art, after the data in the data table is updated, the updated data entry is saved, and the generated version number is associated with the data entry of the data table of the new version, namely, the data table of any version is saved, and the whole data table of all versions is not needed to be saved, so that the storage space is saved.
In the actual use process, the method and the device are simple to operate, have practical functions, and can compare data of the data tables of any two versions, so that a large amount of manual comparison and checking operations of users are omitted, and the method and the device are technical attempts in new scenes generated under large data volume. The pain point of some users can be really solved in a real scene. The impact of large data volume on manpower consumption is reduced, manpower is liberated from heavy work that fields are multiple in items and need great patience repeatedly, the related specific service scenes of work are concerned more, and the self homework is well done instead of data processing. The use constraint of manpower is relieved, and a larger development space is provided for the possibility of exertion of the manpower.
Drawings
Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the application. Also, like reference numerals are used to refer to like parts throughout the drawings. In the drawings:
FIG. 1 shows a flow diagram of one embodiment of a business data processing method according to the present application;
FIG. 2 shows a schematic structural diagram of an embodiment of a business data processing apparatus according to the present application;
FIG. 3 illustrates a schematic structural diagram of a computer system suitable for use in implementing the electronic device of an embodiment of the present application.
Detailed Description
Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.
It is to be noted that, unless otherwise specified, technical or scientific terms used herein shall have the ordinary meaning as understood by those skilled in the art to which this application belongs.
In addition, the terms "first" and "second", etc. are used to distinguish different objects, rather than to describe a particular order. Furthermore, the terms "include" and "have," as well as any variations thereof, are intended to cover non-exclusive inclusions. For example, a process, method, system, article, or apparatus that comprises a list of steps or elements is not limited to only those steps or elements listed, but may alternatively include other steps or elements not listed, or inherent to such process, method, article, or apparatus.
It should be noted that the embodiments and features of the embodiments in the present application may be combined with each other without conflict. The present application will be described in detail below with reference to the embodiments with reference to the attached drawings.
Referring to fig. 1, a flow of an embodiment of a business data processing method according to the present application is shown. The method comprises the following steps:
The data sheet is a web page sheet, is stored in an online server, can provide information sharing for a plurality of people, and can be edited by accessing the server through terminal equipment such as a computer or a mobile phone. When a user performs a write operation on data in the data table, such as deletion, modification, and addition of data, and submits a save request to the server, a new version data table is obtained, and a version number of the new version data table is generated.
The online data table opened by the user through the device terminal device is the data table of the latest version by default, that is, the web page displays the data entry associated with the latest version. One of the first version number and the second version number may be, but is not limited to, a version number of a data table opened for the current web page. For example, if the second version number is a version number of a current version data table (a data table opened by a current webpage), the first version may be a version number of a data table of a previous version of the current version; for example, if the second version number is the version number of the data table of the current version, the first version number may be the version number of any data table of the version before the data table of the current version.
The data in the plurality of cells associated with each other in the data table is one data entry, and the one data entry may be data in the plurality of cells in the same row or data in the plurality of cells in the same column. For example, the service data in the data table may be a resource package stored in a server in the financial institution, where the resource package may be arrears information purchased from the financial institution to a third-party institution, a data line in the data table corresponds to an arrear information, and each arrear information at least includes data of an arrear party name, an identification number, a contact number, an arrear type, an arrear amount, an arrear duration, and the like, and represents each item of information of each arrear. One piece of arrearage information is used as a data entry, the asset pack (namely a data table) comprises various service data, and each service data corresponds to one piece of arrearage.
For the data update in the data table, the data update may be a total data entry update or a partial data entry update, where the data entry update is that the data entry is updated when the data of at least one cell in a certain data entry is updated. If the data table is updated by partial book entries, the new version data table comprises partial old version data entries and partial new version data entries, the updated new version data entries are stored in the online server, and the association relationship between the version number (new version number) of the new version data table and all the data entries of the new version data table is stored. It will be understood that each version (each data update) of the data table has a version number, and the version number is associated with the data entry of the data table corresponding to the version number. That is, the online server stores the data entries before and after updating of each version of the data table and the association relationship between the version number of each version of the data table and the data entry of the data table, and the data entries without data update do not need to be stored repeatedly (i.e. the data entries are stored instead of the entire data table of different versions), so that the data table with any version number can be obtained.
102, generating a first temporary data table based on the data entry associated with the first version number, and generating a second temporary data table based on the data entry associated with the second version number; wherein each data entry has a unique identification ID.
The first temporary data table and the second temporary data table are generated temporarily, and after data comparison is completed, the space memory occupied by the first temporary data table and the second temporary data table can be released. The data entry can be an asset package involved in the operation process of the financial institution, and service data in the asset package, wherein each service data has a unique asset number, and the asset number is an identification ID. For example, each piece of service data may be a piece of arrearage information, each piece of arrearage information at least includes data such as an arrearage party name, an identification number, a contact telephone, an arrearage type, an arrearage amount, an arrearage duration and the like, each piece of information of each arrearage is represented, each piece of service data may be updated only by updating the identification number and the contact telephone, and other fields are not changed.
And the second temporary data table is compared with the data updated by the first temporary data table, namely the modification of the second temporary data table relative to the first version data table, wherein the modification comprises the addition of a data entry, the deletion of the data entry and the modification of a data field in the data entry. Modification tags for modified data entries may also be generated, for example, the modification tags may show addition of data entries, deletion of data entries, and modification of data fields in data entries in three tabs.
And 104, displaying the updated data according to a preset mode.
In order to make the difference comparison result easily visible to the user, i.e. to improve the readability of the result, some display rules may be set for the difference comparison result, for example, how to display the increase of the whole data entry, how to display the data modification in the data entry, and so on, so as to improve the readability of the user.
Compared with the prior art, the method and the device have the advantages that after the data of the data table is updated, the updated data entry is stored and the generated version number is associated with the data entry of the data table of the new version, namely, the data table of any version is stored, and the whole data table of all versions is not required to be stored, so that the storage space is saved.
In the actual use process, the method and the device are simple to operate, have practical functions, and can compare data of the data tables of any two versions, so that a large amount of manual comparison and checking operations of users are omitted, and the method and the device are technical attempts in new scenes generated under large data volume. The pain point of some users can be really solved in a real scene. The impact of large data volume on manpower consumption is reduced, manpower is liberated from heavy work that fields are multiple in items and need great patience repeatedly, the related specific service scenes of work are concerned more, and the self homework is well done instead of data processing. The use constraint of manpower is relieved, and a larger development space is provided for the possibility of exertion of the manpower.
Further preferably, the step 101 of generating a version number corresponding to the new version data table includes:
and accumulating and updating the version number of the data table before updating the data to generate the version number of the new version data table. That is, the version number corresponding to the new version data table is generated by performing the cumulative update processing on the version number of the data table before the data update.
In the embodiment, a generation rule of the version numbers of the data tables with different versions is limited, and the version numbers are generated by accumulation updating, so that the version numbers can intuitively reflect the sequence of the version data tables. For example, the previous data table has a version number of V1, the subsequent data table has a version number of V2, and so on.
In some variations of the embodiment of the present application, the association between the version number generated after the data table in step 101 updates data each time and all data entries of the new version data table includes:
step 101a, determining a new data entry generated after the data table updates data, generating a sub-version number of the new data entry, and keeping the sub-version number of the data entry without data update unchanged.
Each piece of data in the data table corresponds to a sub-version number, and when some data entries have data updates, new data entries (namely, data entries with data updates or newly added data entries) are obtained, and at this time, the sub-version numbers of the new data entries are also generated.
Step 101b, associating the version number with the respective sub-version numbers of all data entries of the new version data table.
In this embodiment, it is defined that the association between the version number and the data entry is the association between the version number of the new version data table and the sub-version number of the data entry having data update in the new version data table, and the association between the two version numbers (the version number of the new version data table and the sub-version number of the new data entry) is relatively simple to implement.
In some modifications of the embodiment of the present application, the comparing the difference between the first temporary data table and the second temporary data table in step 103 to obtain updated data of the second temporary data table compared with the first temporary data table includes:
step 103a, determining whether the identification IDs of the data entries in the first temporary data table and the second temporary data table are the same one by one.
Step 103b, if the data entries are the same, performing difference comparison on the data entries with the same identification ID in the first temporary data table and the second temporary data table to obtain the data entries with data update in the second temporary data table compared with the first temporary data table and the data updated in the data entries.
The identification IDs of the data entries in the first temporary data table and the second temporary data table are the same one by one, which indicates that no data entry is added or deleted in the second temporary data table compared with the first data table, so that it is only necessary to determine that the data entries with the same identification ID have been subjected to specific data modification.
Step 103c, if the identification IDs of the data entries in the first temporary data table and the second temporary data table are not one-to-one the same, determining the data entries added and/or deleted by the second temporary data table compared with the first temporary data table; and comparing the difference of the data entries with the same identification ID in the first temporary data table and the second temporary data table to obtain the data entries with data update in the second temporary data table compared with the first temporary data table and the data updated in the data entries.
The identification IDs of the data entries in the first temporary data table and the second temporary data table are not the same, which indicates that the second temporary data table is added or deleted with respect to the first temporary data table. At this time, it is determined whether there is a data entry that does not exist in the first temporary data table and the second temporary data table, for example, if there is a data entry that does not exist in the first temporary data table and there is no data entry in the second temporary data table, the second temporary data table deletes the data entry; absent from the first temporary data table and present in the second temporary data table, the second temporary data table is populated with data entries. While also determining data modifications that identify data items with the same ID.
In some modifications of the embodiment of the present application, in steps 103 and 103c, the comparing the difference between the first temporary data table and the second temporary data table of the data entries with the same identification ID includes:
and performing difference comparison on the data entries with the same identification ID and different sub-version numbers in the first temporary data table and the second temporary data table.
The sub-version number of the new data entry is the same as the version number of the new version data table, so that the data entries in the data table of each version can be easily and clearly determined to be updated. When data items with the same identification ID in the data tables of the two versions are compared, whether the sub-version numbers of the data items in the two data tables are the same or not is judged firstly, when the sub-version numbers of the data items in the two data tables are the same, the two data items do not need to be compared, and when the sub-version numbers of the data items in the two data tables are different, the two data items are compared, so that the calculation amount of data difference comparison is reduced.
In some modifications of the embodiment of the present application, the generating a sub-version number of the new data entry in step 101a includes: the sub-version number of each new data entry is the same as the version number of the new version data table. After the data in the current version data table is updated, the version number of the new version data table is generated, and the version number of the new version data table is taken as the sub-version number of the new data entry.
For example, referring to table 1, there are 4 data entries in the data table, the version number of the data table of the original version is V1, the version numbers of the following modifications are V2 to V5, respectively, on the basis of the data table with the version number of V1, the 2 nd data entry has data modification, so that the version number of V2 is generated, and a new data entry is obtained, and the sub-version number of the new data entry is V2; similarly, on the basis of the data table with the version number of V2, the 3 rd data entry has data modification, so that the version number of V3 is generated, and a new data entry is obtained, wherein the sub-version number of the new data entry is V3; similarly, on the basis of the data table with the version number of V3, the 4 th data entry has data modification, so that the version number of V4 is generated, and a new data entry is obtained, wherein the sub-version number of the new data entry is V4; similarly, on the basis of the data table with the version number of V4, the 3 rd and 4 th data entries have data modification, so that the version number of V5 is generated, and 2 new data entries are obtained, and the sub-version numbers of the two new data entries are both V5. In table 1, the data table with version number V1: the sub-version numbers of the 4 data entries are all data entries with the sub-version number of V1; in the data table with version number V2 (compare to the data table with version number V1): the 2 nd data entry is updated with the data entry with the sub-version number of V2, and other data entries are not listed.
TABLE 1
In some variations of the embodiments of the present application, the receiving a comparison request in step 101 includes: and displaying the version numbers stored in the version number list, and determining that two version numbers selected by a user in sequence are respectively a first version number and a second version number, wherein the version number selected by the user firstly is the first version number and then is the second version number.
In this embodiment, a "version number" selection key is displayed on a web page, and a data table of two versions is selected by the selection key for data comparison, where the two selected version numbers are selected as default, the former version number is selected first (first version number), and the latter version number is selected later and considered as the latter version number (second version number), and then the differences of the latter version number compared with the former version number are compared. The method is not limited to the actual chronological version of the data sheet, so that the time limitation is broken through, the method is not limited to the comparison between the later generated data sheet and the previously generated data sheet, the difference between the later and the former is completely determined by the selection of the version number, the comparison dimension is expanded, and the change of the data sheets with different versions can be checked at more visual angles. Meanwhile, the data difference between the two versions can be clearly seen through the modification marks, and data adjustment can be timely made, so that a user can only pay attention to specific data to be paid attention to, the user does not need to spend labor and effort for operating the data, own business is well made, and the professional value of the user is more reflected.
In some variations of embodiments of the present application, the method further comprises: the step of importing the asset package into the data table specifically comprises the following steps: when an import request for the asset package is received, reading the identification ID of each data entry in the asset package, judging whether the same identification ID exists in the data table or not, and if so, updating the data entry in the data table to the data entry in the asset package; and if the data does not exist, inserting the data entry in the asset pack into a blank table of the data table.
The service data in the resource package may be service data in an ABS scenario. It should be understood that the asset package is an ABS asset package provided by the original equity owner, which contains a plurality of pieces of financial asset information or asset records.
In the specific implementation, when the user terminal receives an asset package import instruction input by a manager through a human-computer interaction interface integrated on the user terminal, the asset data package corresponding to the asset package import instruction is obtained in response to the asset package import instruction.
The business data import data table comprises a blank data table for importing the business data of the asset pack, so that an original data table (a first version data table) is generated; or part of data entries in the asset pack are imported into the data table.
Further, import information is stored, the import information including time of import, amount of data, and updated data entry.
In this embodiment, the import record is formed by multiple imports, and detailed distinction and record are made for each import, the import time, the data size, data analysis with dimensions, and the like for each version. Therefore, the import time of the data table of each version can be determined according to the recorded import information, and the data state of each version can be clearly seen.
Further referring to fig. 2, as an implementation of the foregoing method, an embodiment of a service data processing apparatus is provided in the present application, where the embodiment of the service data processing apparatus corresponds to the embodiment of the service data processing method shown in fig. 1, and thus, the operations and features described above for the service data processing method in fig. 1 to 1 are also applicable to the service data processing apparatus and the modules included in the service data processing apparatus, and are not described again here.
As shown in fig. 2, the configuration service data processing apparatus may include:
a version number generation module 201, configured to receive a comparison request, where the comparison request carries a first version number and a second version number, where the first version number and the second version number are version numbers in a version number list, a version number corresponding to a new version data table generated after a data table updates data each time is stored in the version number list, and the version number generated after the data table updates data each time is associated with all data entries of the new version data table;
a temporary data table generating module 202, configured to generate a first temporary data table based on the data entry associated with the first version number, and generate a second temporary data table based on the data entry associated with the second version number; wherein each data entry has a unique identification ID;
the data table comparison module 203 is configured to perform difference comparison on the first temporary data table and the second temporary data table to obtain updated data of the second temporary data table compared with the first temporary data table;
and a display module 204, configured to display the updated data according to a predetermined manner.
FIG. 3 illustrates a schematic structural diagram of a computer system suitable for use in implementing the electronic device of an embodiment of the present application.
As shown in fig. 3, the computer system includes a Central Processing Unit (CPU)301 that can perform various appropriate actions and processes in accordance with a program stored in a Read Only Memory (ROM)302 or a program loaded from a storage section 308 into a Random Access Memory (RAM) 303. In the RAM303, various programs and data necessary for the operation of the computer system are also stored. The CPU301, ROM302, and RAM303 are connected to each other via a bus 304. An input/output (I/O) interface 305 is also connected to bus 304.
The following components are connected to the I/O interface 305: an input portion 306; an output section 307; a storage section 308 including a hard disk and the like; and a communication section 309 including a network interface card such as a LAN card, a modem, or the like. The communication section 309 performs communication processing via a network such as the internet. A drive 310 is also connected to the I/O interface 305 as needed. A removable medium 311 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 310 as necessary, so that a computer program read out therefrom is mounted into the storage section 308 as necessary.
In particular, the processes described in the embodiments of the present application may be implemented as computer programs. For example, embodiments of the present application include a computer program product comprising a computer program carried on a computer readable medium, the computer program comprising instructions for carrying out the method illustrated in the flow chart. The computer program can be downloaded and installed from a network through the communication section 309, and/or installed from the removable medium 311. The computer program performs the above-described functions defined in the method of the present application when executed by the Central Processing Unit (CPU) 301.
The present application further provides an electronic device that may be configured with one or more processors; a memory for storing one or more programs, wherein the one or more programs may include instructions for performing the operations described in the above steps 101 and 103. The one or more programs, when executed by the one or more processors, cause the one or more processors to perform the operations described in steps 101 and 103 above.
The present application also provides a computer readable medium, which may be included in an electronic device; or the device can be independently arranged and not assembled into the electronic equipment. The computer readable medium carries one or more programs which, when executed by the electronic device, cause the electronic device to: after the data table updates data, generating a version number corresponding to the new version data table, and associating the version number with all data entries of the new version data table; after a comparison instruction of data tables corresponding to a first version number and a second version number is received, determining a first temporary data table corresponding to the first version number based on a data entry associated with the first version number, determining a second temporary data table corresponding to the second version number based on a data entry associated with the second version number, and comparing data differences of the first temporary data table and the second temporary data table; and when receiving an import request of the asset pack, importing the service data of the asset pack into the data table.
It should be noted that the flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present application. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described systems, apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the several embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other ways. The above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units is only one logical division, and there may be other divisions when actually implemented, and for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection of devices or units through some communication interfaces, and may be in an electrical, mechanical or other form.
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 units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit.
The functions, if implemented in the form of software functional units and sold or used as a stand-alone product, may be stored in a computer readable storage medium. 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: various media capable of storing program codes, such as a usb disk, a removable hard disk, a Read-only memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk.
Finally, it should be noted that: the above embodiments are only used for illustrating the technical solutions of the present application, and not for limiting 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 or all of the technical features may be equivalently replaced; such modifications and substitutions do not depart from the spirit and scope of the present disclosure, and the present disclosure should be construed as being covered by the claims and the specification.
Claims (10)
1. A method for processing service data is characterized by comprising the following steps:
receiving a comparison request, wherein the comparison request carries a first version number and a second version number, the first version number and the second version number are version numbers in a version number list, the version number list stores the version number, generated after the data table updates data each time, corresponding to the new version data table, and the version number generated after the data table updates data each time is associated with all data items of the new version data table;
generating a first temporary data table based on the data entry associated with the first version number, and generating a second temporary data table based on the data entry associated with the second version number; wherein each data entry has a unique identification ID;
performing difference comparison on the first temporary data table and the second temporary data table to obtain updated data of the second temporary data table compared with the first temporary data table;
and displaying the updated data according to a preset mode.
2. The method of claim 1, wherein the version number generated after each data update of the data table is associated with all data entries of the new version data table, and comprises:
determining a new data entry generated after the data table updates data, generating a sub-version number of the new data entry, and keeping the sub-version number of the data entry without data update unchanged;
and associating the version number with the respective sub-version numbers of all data entries of the new version data table.
3. The method of claim 2, wherein the comparing the difference between the first temporary data table and the second temporary data table to obtain updated data of the second temporary data table compared to the first temporary data table comprises:
determining whether the identification IDs of the data entries in the first temporary data table and the second temporary data table are one-to-one identical,
if the data entries are the same, performing difference comparison on the data entries with the same identification ID in the first temporary data table and the second temporary data table to obtain the data entries with data update in the second temporary data table compared with the first temporary data table and the data updated in the data entries;
if the identification IDs of the data entries in the first temporary data table and the second temporary data table are not the same, determining the data entries added and/or deleted by the second temporary data table compared with the first temporary data table; and comparing the difference of the data entries with the same identification ID in the first temporary data table and the second temporary data table to obtain the data entries with data update in the second temporary data table compared with the first temporary data table and the data updated in the data entries.
4. The method of claim 3, wherein the performing the difference comparison between the first temporary data table and the second temporary data table for the data entries with the same identification ID comprises:
and performing difference comparison on data entries with the same identification ID and different sub-version numbers in the first temporary data table and the second temporary data table.
5. The method of claim 2, wherein the generating the sub-version number of the new data entry comprises: the sub-version number of each new data entry is the same as the version number of the new version data table.
6. The method of claim 1, wherein receiving a contrast request comprises:
and displaying the version numbers stored in the version number list, and determining that two version numbers selected by a user in sequence are the first version number and the second version number respectively, wherein the version number selected by the user firstly is the first version number and then is the second version number.
7. The method of claim 1, further comprising:
when an import request of a resource package is received, reading the identification ID of each data entry in the resource package, judging whether the same identification ID exists in the data table, and if so, updating the data entry in the data table to the data entry in the resource package; and if not, inserting the data entry in the asset pack into a blank table of the data table.
8. A service data processing apparatus, comprising:
the device comprises a comparison request input module, a comparison request processing module and a comparison module, wherein the comparison request carries a first version number and a second version number, the first version number and the second version number are version numbers in a version number list, the version number list stores the version number, generated after data are updated each time, of a data table, and the version number generated after the data are updated each time is associated with all data entries of the new version data table;
a temporary data table generating module, configured to generate a first temporary data table based on the data entry associated with the first version number, and generate a second temporary data table based on the data entry associated with the second version number; wherein each data entry has a unique identification ID;
the data table comparison module is used for carrying out difference comparison on the first temporary data table and the second temporary data table to obtain updated data of the second temporary data table compared with the first temporary data table;
and the display module is used for displaying the updated data according to a preset mode.
9. An electronic device, comprising:
one or more processors;
a memory for storing one or more programs,
the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the method recited in any of claims 1-7.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the method according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011212592.5A CN112287658A (en) | 2020-11-03 | 2020-11-03 | Business data processing method and device, electronic equipment and medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011212592.5A CN112287658A (en) | 2020-11-03 | 2020-11-03 | Business data processing method and device, electronic equipment and medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112287658A true CN112287658A (en) | 2021-01-29 |
Family
ID=74350672
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011212592.5A Pending CN112287658A (en) | 2020-11-03 | 2020-11-03 | Business data processing method and device, electronic equipment and medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112287658A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113688616A (en) * | 2021-10-27 | 2021-11-23 | 深圳市明源云科技有限公司 | Method, device and equipment for detecting chart report difference and storage medium |
Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JPH0683596A (en) * | 1992-04-22 | 1994-03-25 | Nec Corp | Program version management system |
| US6377960B1 (en) * | 1999-07-26 | 2002-04-23 | Microsoft Corporation | Transactional configuration store and runtime versus administration isolation with version snapshots and aging |
| US20100280991A1 (en) * | 2009-05-01 | 2010-11-04 | International Business Machines Corporation | Method and system for versioning data warehouses |
| CN104657386A (en) * | 2013-11-22 | 2015-05-27 | 南京中兴新软件有限责任公司 | Method and device for deduplication processing on version files |
| CN107016047A (en) * | 2017-02-20 | 2017-08-04 | 阿里巴巴集团控股有限公司 | Document query, document storing method and device |
| CN108694066A (en) * | 2018-05-09 | 2018-10-23 | 北京酷我科技有限公司 | A kind of method that tableView delays refresh |
| CN109710591A (en) * | 2018-12-27 | 2019-05-03 | 福建南威软件有限公司 | Metadata version automatic management method |
| CN110096429A (en) * | 2019-03-18 | 2019-08-06 | 深圳壹账通智能科技有限公司 | Test report generation method, device, equipment and storage medium |
| CN110292775A (en) * | 2019-07-01 | 2019-10-01 | 网易（杭州）网络有限公司 | Obtain the method and device of variance data |
| CN110348219A (en) * | 2019-06-13 | 2019-10-18 | 晶晨半导体(上海)股份有限公司 | Version comparison method, system, computer equipment and readable storage medium storing program for executing |
| CN110737458A (en) * | 2019-09-18 | 2020-01-31 | 平安科技（深圳）有限公司 | code updating method and related device |
| CN111008028A (en) * | 2019-11-22 | 2020-04-14 | 杭州数式网络科技有限公司 | Software upgrading method, device and storage medium |
-
2020
- 2020-11-03 CN CN202011212592.5A patent/CN112287658A/en active Pending
Patent Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JPH0683596A (en) * | 1992-04-22 | 1994-03-25 | Nec Corp | Program version management system |
| US6377960B1 (en) * | 1999-07-26 | 2002-04-23 | Microsoft Corporation | Transactional configuration store and runtime versus administration isolation with version snapshots and aging |
| US20100280991A1 (en) * | 2009-05-01 | 2010-11-04 | International Business Machines Corporation | Method and system for versioning data warehouses |
| CN104657386A (en) * | 2013-11-22 | 2015-05-27 | 南京中兴新软件有限责任公司 | Method and device for deduplication processing on version files |
| CN107016047A (en) * | 2017-02-20 | 2017-08-04 | 阿里巴巴集团控股有限公司 | Document query, document storing method and device |
| CN108694066A (en) * | 2018-05-09 | 2018-10-23 | 北京酷我科技有限公司 | A kind of method that tableView delays refresh |
| CN109710591A (en) * | 2018-12-27 | 2019-05-03 | 福建南威软件有限公司 | Metadata version automatic management method |
| CN110096429A (en) * | 2019-03-18 | 2019-08-06 | 深圳壹账通智能科技有限公司 | Test report generation method, device, equipment and storage medium |
| CN110348219A (en) * | 2019-06-13 | 2019-10-18 | 晶晨半导体(上海)股份有限公司 | Version comparison method, system, computer equipment and readable storage medium storing program for executing |
| CN110292775A (en) * | 2019-07-01 | 2019-10-01 | 网易（杭州）网络有限公司 | Obtain the method and device of variance data |
| CN110737458A (en) * | 2019-09-18 | 2020-01-31 | 平安科技（深圳）有限公司 | code updating method and related device |
| CN111008028A (en) * | 2019-11-22 | 2020-04-14 | 杭州数式网络科技有限公司 | Software upgrading method, device and storage medium |
Non-Patent Citations (3)
| Title |
|---|
| LIU, H；HUANG, LP；ZHU, YM: "HMFS: A hybrid in-memory file system with version consistency", JOURNAL OF PARALLEL & DISTRIBUTED COMPUTING, vol. 117, no. 0, 31 December 2018 (2018-12-31), pages 18 - 36 * |
| 许花;宁剑;黄昆;张勇;江长明;张哲: "基于CIM/G的图形多版本管理与展示", 电力系统自动化, no. 24, 25 December 2017 (2017-12-25), pages 170 - 175 * |
| 陈刚;王成;羌铃铃: "智能网MML命令如何兼容低版本业务", 电脑知识与技术, no. 25, 5 September 2010 (2010-09-05), pages 51 - 53 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113688616A (en) * | 2021-10-27 | 2021-11-23 | 深圳市明源云科技有限公司 | Method, device and equipment for detecting chart report difference and storage medium |
| CN113688616B (en) * | 2021-10-27 | 2022-02-25 | 深圳市明源云科技有限公司 | Method, device and equipment for detecting chart report difference and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10572685B1 (en) | Protecting sensitive data | |
| CN113704243A (en) | Data analysis method, data analysis device, computer device, and storage medium | |
| CN108363684A (en) | List creation method, device and server | |
| CN104011698A (en) | Access to supplemental data based on identifier derived from corresponding primary application data | |
| CN112287658A (en) | Business data processing method and device, electronic equipment and medium | |
| CN109271564A (en) | Declaration form querying method and equipment | |
| CN112328616A (en) | Data updating method, device and storage medium | |
| CN112035676A (en) | User operation behavior knowledge graph construction method and device | |
| CN113329117B (en) | Processing method and device for telephone record data in telephone book application | |
| CN110059081A (en) | Data output method, device and the computer equipment shown based on data | |
| CN112348403B (en) | Wind control model construction method and device and electronic equipment | |
| CN114742024A (en) | Service information processing method and device and electronic equipment | |
| CN114781368A (en) | Business requirement safety processing method and device | |
| CN112036133B (en) | File storage method and device, electronic equipment and storage medium | |
| CN114201157A (en) | Method and system for customizing target service module by low code | |
| CN114625372A (en) | Automatic component compiling method and device, computer equipment and storage medium | |
| CN113934729A (en) | Data management method based on knowledge graph, related equipment and medium | |
| CN111831698A (en) | Data auditing method, system and electronic equipment | |
| CN111221817B (en) | Service information data storage method, device, computer equipment and storage medium | |
| CN112402955B (en) | Game log recording method and system | |
| CN114553954B (en) | Information pushing method, nonvolatile storage medium and electronic equipment | |
| CN116383138A (en) | Document changing method, device, computer equipment and storage medium | |
| CN116719854A (en) | Data comparison method, device, computer equipment and storage medium | |
| CN117494676A (en) | Formula editing method and device, storage medium and electronic equipment | |
| CN116627581A (en) | Method, device, equipment and storage medium for backtracking business system page |
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 |