CN113535727B - Data output method and device of information system and electronic equipment - Google Patents
Data output method and device of information system and electronic equipment Download PDFInfo
- Publication number
- CN113535727B CN113535727B CN202110815814.0A CN202110815814A CN113535727B CN 113535727 B CN113535727 B CN 113535727B CN 202110815814 A CN202110815814 A CN 202110815814A CN 113535727 B CN113535727 B CN 113535727B
- Authority
- CN
- China
- Prior art keywords
- data
- item
- attribute
- version
- value
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 40
- 238000013500 data storage Methods 0.000 claims abstract description 59
- 238000010276 construction Methods 0.000 claims description 29
- 238000012217 deletion Methods 0.000 claims description 15
- 230000037430 deletion Effects 0.000 claims description 15
- 230000004048 modification Effects 0.000 claims description 10
- 238000012986 modification Methods 0.000 claims description 10
- 230000008859 change Effects 0.000 claims description 7
- 238000004590 computer program Methods 0.000 claims description 7
- 230000005540 biological transmission Effects 0.000 abstract description 21
- 238000007726 management method Methods 0.000 abstract description 20
- 238000005516 engineering process Methods 0.000 abstract description 7
- 230000008569 process Effects 0.000 description 8
- 238000012545 processing Methods 0.000 description 6
- 238000010586 diagram Methods 0.000 description 4
- 238000012546 transfer Methods 0.000 description 3
- 230000008878 coupling Effects 0.000 description 2
- 238000010168 coupling process Methods 0.000 description 2
- 238000005859 coupling reaction Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 238000003032 molecular docking Methods 0.000 description 2
- 230000006978 adaptation Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000012805 post-processing Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/219—Managing data history or versioning
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
Abstract
The invention discloses a data output method and device of an information system and electronic equipment. The data output method comprises the following steps: constructing a data storage structure of the information system, wherein the data storage structure is used for storing release data of a current version and release data of a historical version; identifying difference data of the release data of the current version relative to the release data of the historical version by adopting a data storage structure; and outputting the difference data. The invention solves the technical problems of lower efficiency and great consumption of management resources when the management information system manages the difference data in the version transmission process in the related technology.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a data output method and device of an information system, and an electronic device.
Background
In the related art, data interaction is often required between different information systems, and some information system data does not keep change logs of multiple versions or service data, at this time, when the information system performs data integration with other systems requiring version control, if the requirement is met to transfer the difference data between the current release version and the last release version, for example, what content is newly added, what content is modified, what content is deleted, and the like, the data of the last release version cannot be obtained, which cannot be achieved.
For the aforementioned version differences that cannot be transferred by the transfer system, there are three current solutions:
the first solution is: a version management library is constructed for the current information system. However, this solution requires a lot of resources to implement version management, and not only requires high investment time costs, but also requires high investment resource costs.
The second solution is: and calling a query interface of the docking system for comparison. However, this solution, which first requires a corresponding query interface in the docking system, is not satisfied in many cases, and because of the problem of the query result format, certain resources are consumed in comparison.
Third solution: and recording an operation log and summarizing difference information from the log. However, this solution requires a lot of resources to be implemented, and the final summary is likely to be wrong due to repeated modification operations of the same data.
In view of the above problems, no effective solution has been proposed at present.
Disclosure of Invention
The embodiment of the invention provides a data output method, a data output device and electronic equipment of an information system, which at least solve the technical problems of lower efficiency and consumption of a large amount of management resources when managing difference data of the information system in a version transmission process in the related technology.
According to an aspect of an embodiment of the present invention, there is provided a data output method of an information system, including: constructing a data storage structure of an information system, wherein the data storage structure is used for storing release data of a current version and release data of a historical version; identifying difference data of the release data of the current version relative to the release data of the historical version by adopting the data storage structure; and outputting the difference data.
Optionally, the step of constructing a data storage structure of the information system includes: constructing a data comparison table of the information system; constructing a first attribute item for identifying the data uniqueness of the current version in the data comparison table; constructing a second attribute item for identifying the data uniqueness of the historical version in the data comparison table; constructing a first numerical item for storing attribute values of the current version in the data comparison table; constructing a second numerical item for storing the attribute value of the historical version in the data comparison table; constructing an operation identification item for storing a comparison result in the data comparison table; and constructing the data storage structure based on the data comparison table, the first attribute item, the second attribute item, the first numerical value item, the second numerical value item and the operation identification item constructed in the data comparison table.
Optionally, the step of identifying difference data of the published data of the current version relative to the published data of the historical version using the data storage structure includes: comparing the first attribute item with the second attribute item in the data comparison table to obtain a comparison result; if the comparison result indicates that the attribute identifier exists in the first attribute item and the attribute identifier does not exist in the second attribute item, determining that the release data of the current version has new data relative to the release data of the historical version, and setting the operation identifier item as a new operation; if the comparison result indicates that the attribute identifier does not exist in the first attribute item and the attribute identifier exists in the second attribute item, determining that the release data of the current version has deletion data relative to the release data of the historical version, and setting the operation identifier item as a deletion operation.
Optionally, after comparing the first attribute item and the second attribute item in the data comparison table to obtain a comparison result, the data output method further includes: if the comparison result indicates that the attribute identifier exists in the first attribute item and the attribute identifier exists in the second attribute item, comparing whether the attribute identifier in the first attribute item is identical with the attribute identifier in the second attribute item; if the attribute identifier in the first attribute item is the same as the attribute identifier in the second attribute item, comparing whether the version value in the first numerical item is the same as the version value in the second numerical item; if the version value in the first value item is different from the version value in the second value item, determining that modification data exists in the release data of the current version relative to the release data of the historical version, and setting the operation identification item as a change operation; and if the version value in the first numerical item is the same as the version value in the second numerical item, setting the operation identification item to be an operation which is not processed.
Optionally, after outputting the difference data, the data output method further includes: updating the attribute identification of the successfully output first attribute item to the second attribute item; updating the version value in the successfully output first value item to the second value item; and updating the first attribute item and the first attribute item in the data comparison table to be empty.
According to another aspect of the embodiment of the present invention, there is also provided a data output apparatus of an information system, including: the information system comprises a construction unit, a data storage unit and a data storage unit, wherein the construction unit is used for constructing a data storage structure of the information system, and the data storage structure is used for storing release data of a current version and release data of a historical version; the identification unit is used for identifying difference data of the release data of the current version relative to the release data of the historical version by adopting the data storage structure; and the output unit is used for outputting the difference data.
Optionally, the building unit comprises: the first construction module is used for constructing a data comparison table of the information system; the second construction module is used for constructing a first attribute item for identifying the data uniqueness of the current version in the data comparison table; a third construction module, configured to construct a second attribute item for identifying data uniqueness of a historical version in the data comparison table; a fourth construction module, configured to construct a first numerical item for storing an attribute value of a current version in the data comparison table; a fifth construction module, configured to construct a second value item for storing attribute values of historical versions in the data comparison table; a sixth construction module, configured to construct an operation identifier for storing a comparison result in the data comparison table; and a seventh construction module, configured to construct the data storage structure based on the data comparison table, the first attribute item, the second attribute item, the first numerical value item, the second numerical value item, and the operation identifier item constructed in the data comparison table.
Optionally, the identifying unit includes: the first comparison module is used for comparing the first attribute item and the second attribute item in the data comparison table to obtain a comparison result; the first determining module is used for determining that the release data of the current version has newly-added data relative to the release data of the historical version when the comparison result indicates that the attribute identifier exists in the first attribute item and the attribute identifier does not exist in the second attribute item, and setting the operation identifier item as newly-added operation; and the second determining module is used for determining that the release data of the current version has deletion data relative to the release data of the historical version when the comparison result indicates that the attribute identifier does not exist in the first attribute item and the attribute identifier exists in the second attribute item, and setting the operation identifier as a deletion operation.
Optionally, the data output device further includes: the second comparison module is used for comparing the first attribute item and the second attribute item in the data comparison table to obtain a comparison result, and comparing whether the attribute identifier in the first attribute item is the same as the attribute identifier in the second attribute item or not if the comparison result indicates that the attribute identifier exists in the first attribute item and the attribute identifier exists in the second attribute item; the third comparison module is used for comparing whether the version value in the first numerical value item is the same as the version value in the second numerical value item or not in the first attribute item and the second attribute item; the first determining module is used for determining that modification data exists in the release data of the current version relative to the release data of the historical version when the version value in the first value item is different from the version value in the second value item, and setting the operation identification item as a change operation; and the first setting module is used for setting the operation identification item to be an operation which is not processed when the version value in the first numerical item is the same as the version value in the second numerical item.
Optionally, the data output device further includes: the first updating module is used for updating the attribute identification of the successfully output first attribute item to the second attribute item after outputting the difference data; the second updating module is used for updating the version value in the successfully output first value item to a second value item; and the third updating module is used for updating the first attribute item and the first attribute item in the data comparison table to be empty.
According to another aspect of the embodiment of the present invention, there is also provided an electronic device, including: a processor; and a memory for storing executable instructions of the processor; wherein the processor is configured to perform the data output method of the information system of any one of the above via execution of the executable instructions.
According to another aspect of the embodiment of the present invention, there is further provided a computer readable storage medium, where the computer readable storage medium includes a stored computer program, where when the computer program runs, the device where the computer readable storage medium is controlled to execute the data output method of the information system described in any one of the foregoing.
In the embodiment of the invention, a data storage structure of an information system is firstly constructed, the data storage structure is adopted to identify the difference data of the release data of the current version relative to the release data of the historical version, and the difference data is output. In the embodiment, the comparison of the current version and the last version of data can be realized through the constructed data storage structure, the difference data of the system version in the transmission process can be automatically identified, the data without version control can be transmitted to other systems, the transmission of redundant data is reduced, the data transmission efficiency is improved, and the technical problems that the efficiency is lower and a large amount of management resources are consumed when the management information system manages the difference data in the version transmission process in the related technology are solved.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this application, illustrate embodiments of the invention and together with the description serve to explain the invention and do not constitute a limitation on the invention. In the drawings:
FIG. 1 is a flow chart of an alternative method of data output of an information system according to an embodiment of the invention;
FIG. 2 is a schematic diagram of another alternative data output method of an information system according to an embodiment of the present invention;
fig. 3 is a schematic diagram of an alternative data output device of an information system according to an embodiment of the present invention.
Detailed Description
In order that those skilled in the art will better understand the present invention, a technical solution in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in which it is apparent that the described embodiments are only some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the present invention without making any inventive effort, shall fall within the scope of the present invention.
It should be noted that the terms "first," "second," and the like in the description and the claims of the present invention and the above figures are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments of the invention described herein may be implemented in sequences other than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
To facilitate understanding of the present application by those skilled in the art, some terms or nouns referred to in the various embodiments of the present application are explained below:
management information system: manage user data, including graph documents, PDMs, process data management, PLM, ERP, MES;
difference data: the content of the differences between the different versions of the data for each information system.
The present application can be applied to various information systems, for example, various types of management information systems: ERP, PLM, PDM, MES, etc. Compared with the prior art that a version management library or a professional query interface is required to be constructed to realize the version management data difference of the information system, the method and the device can construct release data capable of storing versions of each system, realize the comparison of the current version and the last version data, enable data without version control in the information system to transmit difference information to other systems, reduce the transmission of redundant data and improve the data transmission efficiency. The present application is described below in conjunction with the embodiments described above.
Example 1
According to an embodiment of the present invention, there is provided a data output method embodiment of an information system, it should be noted that the steps shown in the flowcharts of the drawings may be performed in a computer system such as a set of computer executable instructions, and that although a logical order is shown in the flowcharts, in some cases, the steps shown or described may be performed in an order different from that shown or described herein.
Fig. 1 is a flowchart of an alternative data output method of an information system according to an embodiment of the present invention, as shown in fig. 1, the method including the steps of:
step S102, a data storage structure of an information system is constructed, wherein the data storage structure is used for storing release data of a current version and release data of a historical version;
step S104, adopting a data storage structure to identify the difference data of the release data of the current version relative to the release data of the historical version;
step S106, outputting the difference data.
Through the steps, a data storage structure of the information system can be constructed, wherein the data storage structure is used for storing the release data of the current version and the release data of the historical version, and the data storage structure is adopted to identify the difference data of the release data of the current version relative to the release data of the historical version and output the difference data. In the embodiment, the comparison of the current version and the last version of data can be realized through the constructed data storage structure, the difference data of the system version in the transmission process can be automatically identified, the data without version control can be transmitted to other systems, the transmission of redundant data is reduced, the data transmission efficiency is improved, and the technical problems that the efficiency is lower and a large amount of management resources are consumed when the management information system manages the difference data in the version transmission process in the related technology are solved.
The embodiment of the application takes a management information system as an example, and describes the information system. Each management information system needs to update different versions along with the change of time and client demands so as to adapt to the demands of various clients, improve the utilization rate, and in the process of realizing the update of the system version, the updated current version and the updated previous version have basic data/same version data and version difference data, and in the process of transmitting, the difference data in the version transmitting process is analyzed in an important way.
Embodiments of the present application will be described below in conjunction with the foregoing implementation steps.
In step S102, a data storage structure of the information system is constructed, where the data storage structure is used to store the release data of the current version and the release data of the historical version.
The data storage structure of the information system constructed in this embodiment may store the data structures of the current version and the previous version of data at the same time.
Optionally, the step of constructing a data storage structure of the information system includes: constructing a data comparison table of the information system; constructing a first attribute item for identifying the data uniqueness of the current version in the data comparison table; constructing a second attribute item for identifying the data uniqueness of the historical version in the data comparison table; constructing a first numerical item for storing the attribute value of the current version in a data comparison table; constructing a second numerical item for storing the attribute value of the historical version in the data comparison table; constructing an operation identification item for storing a comparison result in a data comparison table; and constructing a data storage structure based on the data comparison table, the first attribute item, the second attribute item, the first numerical value item, the second numerical value item and the operation identification item constructed in the data comparison table.
In this embodiment, the first attribute term may refer to a key attribute for identifying the uniqueness of data; the second attribute term may refer to a key attribute used to identify data uniqueness; the first numerical term may refer to storing a value of a property of a last release; the second value item may refer to a value storing a certain attribute of the current release version; the operation identification item may refer to storing an operation identification obtained according to the comparison result.
By creating a data storage structure in advance, this embodiment may be named as table_high, and is used to store the current published data and the last published data, and the TABLE structure attribute of the data storage structure is shown in the following TABLE 1:
table 1 table structure attributes of data store structure
| Fields | Description of the invention |
| Old_Key | Key attributes for identifying data uniqueness |
| New_Key | Key attributes for identifying data uniqueness |
| OLD_Val | Storing the value of an attribute of the last release |
| New_Val | Storing the value of an attribute of the currently published version |
| Act_flag | Storing the operation identification obtained according to the comparison result |
Step S104, the data storage structure is adopted to identify the difference data of the release data of the current version relative to the release data of the historical version.
Optionally, the step of identifying, using the data storage structure, difference data of the published data of the current version relative to the published data of the historical version includes: comparing the first attribute item and the second attribute item in the data comparison table to obtain a comparison result; if the comparison result indicates that the attribute identifier exists in the first attribute item and the attribute identifier does not exist in the second attribute item, determining that the newly-added data exists in the release data of the current version relative to the release data of the historical version, and setting the operation identifier item as a newly-added operation; if the comparison result indicates that the attribute identifier does not exist in the first attribute item and the attribute identifier exists in the second attribute item, determining that the release data of the current version has deletion data relative to the release data of the historical version, and setting the operation identifier item as a deletion operation.
In the use process of the management information system, BOM data is taken as an example, and data in a TABLE_HISTORY TABLE during generation, first release, data transmission, release and modification, second release and data transmission are taken as an example in the following TABLE 2:
table 2 first version release
| Old_Key | New_Key | OLD_Val | New_Val | Act_flag |
| A-B | Quantity = 1 | New addition of | ||
| A-C | Quantity = 3 | New addition of |
According to the data in the current TABLE, the comparison of the New_Key and the old_Key shows that the New_Key is found but the old_Key is not found, the New data is shown to exist, the data is New, the New data is directly transmitted to a data receiver, after the transmission is successful, the TABLE_HISTORY TABLE is updated, and the NEW data is updated to the OLD data, and the result is shown in the following TABLE 3:
table 3 update OLD data
| Old_Key | New_Key | OLD_Val | New_Val | Act_flag |
| A-B | Quantity = 1 | |||
| A-C | Quantity = 3 |
Alternatively, after comparing the first attribute item and the second attribute item in the data comparison table to obtain the comparison result, the data output method further includes: if the comparison result indicates that the attribute identifier exists in the first attribute item and the attribute identifier exists in the second attribute item, comparing whether the attribute identifier in the first attribute item is identical with the attribute identifier in the second attribute item; if the attribute identifier in the first attribute item is the same as the attribute identifier in the second attribute item, comparing whether the version value in the first value item is the same as the version value in the second value item; if the version value in the first numerical value item is different from the version value in the second numerical value item, determining that modification data exists in the release data of the current version relative to the release data of the historical version, and setting the operation identification item as a change operation; if the version value in the first value item is the same as the version value in the second value item, the operation identification item is set to not process the operation.
After the retransmission is modified, assuming that a new number of A-D is 2, A-C is deleted, and a number of A-B is modified to be 10, firstly, inquiring whether a transmitted record exists in a table according to the KEY value, namely, whether the current KEY value is identical to the table type old_key or not is matched, if so, updating is carried out, if not, inserting is carried out, and the result is as shown in the following table 4:
TABLE 4 second publication
| Old_Key | New_Key | OLD_Val | New_Val | Act_flag |
| A-B | A-B | Quantity = 1 | Quantity = 10 | Modification of |
| A-C | Quantity = 3 | Deletion of | ||
| A-D | Quantity = 2 | New addition of |
From TABLE 4, if both OLDKEY and NEWKEY have values, and OLDVAL and NEWVAL are different, indicating modification (if the values are the same, indicating no processing), if OLDKEY has a value and new_key has no value, indicating deletion, if OLDKEY is empty and NEWKEY has a value indicating a NEW addition, after transfer according to the TABLE seed data, the table_histary TABLE is updated as shown in TABLE 5 below:
TABLE_HISTORY Table 5 update
| Old_Key | New_Key | OLD_Val | New_Val | Act_flag |
| A-B | Quantity = 10 | |||
| A-D | Quantity = 2 |
Step S106, outputting the difference data.
Optionally, after outputting the difference data, the data output method further includes: updating the attribute identification of the successfully output first attribute item to the second attribute item; updating the version value in the successfully output first value item to the second value item; and updating the first attribute item and the first attribute item in the data comparison table to be empty.
In this embodiment of the present application, after data output, post processing may be performed once, where processing logic updates the new_key and the new_val of the records that are successfully output to the old_key and the old_val, updates the new_key and the new_val to be empty, and waits for the next data to be issued and input.
The examples of the present application are described below in connection with alternative implementations. This embodiment will be described with reference to the above-described constructed data storage structure TABLE table_high, and the corresponding TABLE attribute.
Fig. 2 is a schematic diagram of a data output method of an alternative information system according to an embodiment of the present invention, as shown in fig. 2, after data is published, a keyword may be extracted through a data storage structure, the old_key may be queried in a TABLE of the data storage structure table_high, if the query is made, published data may be updated to new_key and new_val, if the query is not made, a record may be newly added, and the data may be written into new_key and new_val.
Then comparing the NEW_KEY with the OLD_KEY, and setting the operation as a deleting operation if the NEW_KEY is empty and the OLD_KEY is not empty; if the NEW_KEY is not empty and the OLD_KEY is empty, setting the operation as a NEW operation; if the new_key is not empty and the old_key is not empty, the new_val and the old_val need to be compared, if the new_val is the same as the old_val, the operation is set to be an unprocessed operation, if the new_val is not the same as the old_val, the operation is set to be a changing operation (updating operation), and finally, the deletion record is output according to the set operation, namely, the operation result is output, and meanwhile, the difference data needs to be output.
In the embodiment illustrated in fig. 2, a scheme capable of retaining one version of data can be provided for the management information system without version control by constructing the table_high, and the comparison between the current version and the previous version of data can be realized in the TABLE, so that the data without version control in the management information system can transmit difference information to other systems, the transmission of redundant data is reduced, and the data transmission efficiency is improved.
Embodiments of the present invention are described below in conjunction with alternative embodiments.
Example two
The present embodiment provides a data output device of an information system, where the data output device includes a plurality of implementation units, and each implementation unit corresponds to each implementation step in the first embodiment.
Fig. 3 is a schematic diagram of a data output device of an alternative information system according to an embodiment of the present invention, and as shown in fig. 3, the data output device may include: a construction unit 31, an identification unit 33, an output unit 35.
The construction unit 31 is configured to construct a data storage structure of the information system, where the data storage structure is configured to store the release data of the current version and the release data of the historical version;
an identifying unit 33, configured to identify, using a data storage structure, difference data of the release data of the current version relative to release data of the historical version;
an output unit 35 for outputting the difference data.
The above-described data output apparatus may construct a data storage structure of the information system by the construction unit 31, wherein the data storage structure is used to store the distribution data of the current version and the distribution data of the history version, the identification unit 33 identifies the difference data of the distribution data of the current version with respect to the distribution data of the history version by using the data storage structure, and the output unit 35 outputs the difference data. In the embodiment, the comparison of the current version and the last version of data can be realized through the constructed data storage structure, the difference data of the system version in the transmission process can be automatically identified, the data without version control can be transmitted to other systems, the transmission of redundant data is reduced, the data transmission efficiency is improved, and the technical problems that the efficiency is lower and a large amount of management resources are consumed when the management information system manages the difference data in the version transmission process in the related technology are solved.
Optionally, the building unit includes: the first construction module is used for constructing a data comparison table of the information system; the second construction module is used for constructing a first attribute item for identifying the data uniqueness of the current version in the data comparison table; the third construction module is used for constructing a second attribute item for identifying the data uniqueness of the historical version in the data comparison table; a fourth construction module, configured to construct a first numerical item for storing the attribute value of the current version in the data comparison table; a fifth construction module, configured to construct a second value item for storing the attribute value of the history version in the data comparison table; the sixth construction module is used for constructing an operation identification item for storing the comparison result in the data comparison table; and the seventh construction module is used for constructing a data storage structure based on the data comparison table, the first attribute item, the second attribute item, the first numerical value item, the second numerical value item and the operation identification item constructed in the data comparison table.
Optionally, the identifying unit includes: the first comparison module is used for comparing the first attribute item and the second attribute item in the data comparison table to obtain a comparison result; the first determining module is used for determining that the release data of the current version has new data relative to the release data of the historical version when the comparison result indicates that the attribute identifier exists in the first attribute item and the attribute identifier does not exist in the second attribute item, and setting the operation identifier item as a new operation; and the second determining module is used for determining that the release data of the current version has deletion data relative to the release data of the historical version when the comparison result indicates that the attribute identifier does not exist in the first attribute item and the attribute identifier exists in the second attribute item, and setting the operation identifier as a deletion operation.
Optionally, the data output device further includes: the second comparison module is used for comparing the first attribute item and the second attribute item in the data comparison table to obtain a comparison result, and comparing whether the attribute identifier in the first attribute item is the same as the attribute identifier in the second attribute item if the comparison result indicates that the attribute identifier exists in the first attribute item and the attribute identifier exists in the second attribute item; the third comparison module is used for comparing whether the version value in the first numerical value item is the same as the version value in the second numerical value item or not when the attribute identifier in the first attribute item is the same as the attribute identifier in the second attribute item; the first determining module is used for determining that modification data exists in the release data of the current version relative to the release data of the historical version if the version value in the first value item is different from the version value in the second value item, and setting the operation identification item as a change operation; and the first setting module is used for setting the operation identification item as a non-processing operation when the version value in the first numerical item is the same as the version value in the second numerical item.
Optionally, the data output device further includes: the first updating module is used for updating the attribute identification of the successfully output first attribute item to the second attribute item after outputting the difference data; the second updating module is used for updating the version value in the successfully output first value item to a second value item; and the third updating module is used for updating the first attribute item and the first attribute item in the data comparison table to be empty.
The data output device may further include a processor and a memory, where the construction unit 31, the identification unit 33, the output unit 35, and the like are stored as program units, and the processor executes the program units stored in the memory to implement the corresponding functions.
The processor includes a kernel, and the kernel fetches a corresponding program unit from the memory. The kernel can be provided with one or more than one, and the data storage structure is adopted by adjusting kernel parameters to identify the difference data of the release data of the current version relative to the release data of the historical version and output the difference data.
The memory may include volatile memory in a computer-readable medium, random Access Memory (RAM) and/or nonvolatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM), which includes at least one memory chip.
According to another aspect of the embodiment of the present invention, there is also provided an electronic device, including: a processor; and a memory for storing executable instructions of the processor; wherein the processor is configured to perform the data output method of the information system of any of the above via execution of the executable instructions.
According to another aspect of the embodiments of the present invention, there is also provided a computer readable storage medium, including a stored computer program, where the computer program when executed controls a device in which the computer readable storage medium is located to perform the data output method of the information system of any one of the above.
The present application also provides a computer program product adapted to perform, when executed on a data processing device, a program initialized with the method steps of: constructing a data storage structure of the information system, wherein the data storage structure is used for storing release data of a current version and release data of a historical version; identifying difference data of the release data of the current version relative to the release data of the historical version by adopting a data storage structure; and outputting the difference data.
The foregoing embodiment numbers of the present invention are merely for the purpose of description, and do not represent the advantages or disadvantages of the embodiments.
In the foregoing embodiments of the present invention, the descriptions of the embodiments are emphasized, and for a portion of this disclosure that is not described in detail in this embodiment, reference is made to the related descriptions of other embodiments.
In the several embodiments provided in the present application, it should be understood that the disclosed technology content may be implemented in other manners. The above-described embodiments of the apparatus are merely exemplary, and the division of the units, for example, may be a logic function division, and may be implemented in another manner, for example, a plurality of units or components may be combined or may be integrated into another system, or some features may be omitted, or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be through some interfaces, units or modules, or may be in electrical or other forms.
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 units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
In addition, each functional unit in the embodiments of the present invention may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.
The integrated units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied essentially or in part or all of the technical solution or in part in the form of a software product stored in a storage medium, including instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a removable hard disk, a magnetic disk, or an optical disk, or other various media capable of storing program codes.
The foregoing is merely a preferred embodiment of the present invention and it should be noted that modifications and adaptations to those skilled in the art may be made without departing from the principles of the present invention, which are intended to be comprehended within the scope of the present invention.
Claims (7)
1. A data output method of an information system, comprising:
constructing a data storage structure of the information system, wherein the data storage structure is used for storing release data of a current version and release data of a historical version, and the step of constructing the data storage structure of the information system comprises the following steps:
constructing a data comparison table of the information system; constructing a first attribute item for identifying the data uniqueness of the current version in the data comparison table; constructing a second attribute item for identifying the data uniqueness of the historical version in the data comparison table; constructing a first numerical item for storing attribute values of the current version in the data comparison table; constructing a second numerical item for storing the attribute value of the historical version in the data comparison table; constructing an operation identification item for storing a comparison result in the data comparison table; constructing the data storage structure based on the data comparison table, a first attribute item, a second attribute item, a first numerical value item, a second numerical value item and an operation identification item constructed in the data comparison table;
identifying, by the data storage structure, difference data of the published data of the current version relative to the published data of the historical version, including: comparing the first attribute item with the second attribute item in the data comparison table to obtain a comparison result; if the comparison result indicates that the attribute identifier exists in the first attribute item and the attribute identifier does not exist in the second attribute item, determining that the release data of the current version has new data relative to the release data of the historical version, and setting the operation identifier item as a new operation;
outputting the difference data;
updating the attribute identification of the successfully output first attribute item to the second attribute item;
updating the version value in the successfully output first value item to the second value item;
and updating the first attribute item and the first attribute item in the data comparison table to be empty.
2. The data output method according to claim 1, wherein the step of identifying difference data of the distribution data of the current version relative to the distribution data of the history version using the data storage structure, further comprises:
if the comparison result indicates that the attribute identifier does not exist in the first attribute item and the attribute identifier exists in the second attribute item, determining that the release data of the current version has deletion data relative to the release data of the historical version, and setting the operation identifier item as a deletion operation.
3. The data output method according to claim 2, wherein after comparing the first attribute item and the second attribute item in the data comparison table to obtain a comparison result, the data output method further comprises:
if the comparison result indicates that the attribute identifier exists in the first attribute item and the attribute identifier exists in the second attribute item, comparing whether the attribute identifier in the first attribute item is identical with the attribute identifier in the second attribute item;
if the attribute identifier in the first attribute item is the same as the attribute identifier in the second attribute item, comparing whether the version value in the first numerical item is the same as the version value in the second numerical item;
if the version value in the first value item is different from the version value in the second value item, determining that modification data exists in the release data of the current version relative to the release data of the historical version, and setting the operation identification item as a change operation;
and if the version value in the first numerical item is the same as the version value in the second numerical item, setting the operation identification item to be an operation which is not processed.
4. A data output device of an information system, comprising:
a construction unit for constructing a data storage structure of the information system, wherein the data storage structure is used for storing release data of a current version and release data of a historical version,
the construction unit includes: the first construction module is used for constructing a data comparison table of the information system; the second construction module is used for constructing a first attribute item for identifying the data uniqueness of the current version in the data comparison table; a third construction module, configured to construct a second attribute item for identifying data uniqueness of a historical version in the data comparison table; a fourth construction module, configured to construct a first numerical item for storing an attribute value of a current version in the data comparison table; a fifth construction module, configured to construct a second value item for storing attribute values of historical versions in the data comparison table; a sixth construction module, configured to construct an operation identifier for storing a comparison result in the data comparison table; a seventh construction module, configured to construct the data storage structure based on the data comparison table, a first attribute item, a second attribute item, a first numerical value item, a second numerical value item, and an operation identifier item constructed in the data comparison table;
the identification unit is used for identifying difference data of the release data of the current version relative to the release data of the historical version by adopting the data storage structure;
the identification unit includes: the first comparison module is used for comparing the first attribute item and the second attribute item in the data comparison table to obtain a comparison result; the first determining module is used for determining that the release data of the current version has newly-added data relative to the release data of the historical version when the comparison result indicates that the attribute identifier exists in the first attribute item and the attribute identifier does not exist in the second attribute item, and setting the operation identifier item as newly-added operation;
an output unit configured to output the difference data;
the data output device further includes: the first updating module is used for updating the attribute identification of the successfully output first attribute item to the second attribute item after outputting the difference data; the second updating module is used for updating the version value in the successfully output first value item to a second value item; and the third updating module is used for updating the first attribute item and the first attribute item in the data comparison table to be empty.
5. The data output device of claim 4, wherein the identification unit further comprises:
and the second determining module is used for determining that the release data of the current version has deletion data relative to the release data of the historical version when the comparison result indicates that the attribute identifier does not exist in the first attribute item and the attribute identifier exists in the second attribute item, and setting the operation identifier as a deletion operation.
6. An electronic device, comprising:
a processor; and
a memory for storing executable instructions of the processor;
wherein the processor is configured to perform the data output method of the information system of any one of claims 1 to 3 via execution of the executable instructions.
7. A computer readable storage medium, characterized in that the computer readable storage medium comprises a stored computer program, wherein the computer program, when run, controls a device in which the computer readable storage medium is located to perform a data output method of an information system according to any one of claims 1 to 3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110815814.0A CN113535727B (en) | 2021-07-19 | 2021-07-19 | Data output method and device of information system and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110815814.0A CN113535727B (en) | 2021-07-19 | 2021-07-19 | Data output method and device of information system and electronic equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113535727A CN113535727A (en) | 2021-10-22 |
| CN113535727B true CN113535727B (en) | 2024-04-09 |
Family
ID=78128790
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110815814.0A Active CN113535727B (en) | 2021-07-19 | 2021-07-19 | Data output method and device of information system and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113535727B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113934644B (en) * | 2021-12-16 | 2022-04-15 | 深圳市明源云链互联网科技有限公司 | Version difference comparison method and device, intelligent terminal and readable storage medium |
Citations (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP2081117A2 (en) * | 2007-10-05 | 2009-07-22 | Canon Kabushiki Kaisha | Information processing apparatus and control method thereof, and document verification apparatus and control method thereof |
| CN101499069A (en) * | 2008-02-02 | 2009-08-05 | 中兴通讯股份有限公司 | Internal memory database file updating method and apparatus |
| WO2015016807A1 (en) * | 2013-07-29 | 2015-02-05 | Hewlett-Packard Development Company, L.P. | Database analysis and validation |
| US9047334B1 (en) * | 2009-07-31 | 2015-06-02 | David R. Cheriton | Merge-update for efficient atomic memory modification in concurrent computer systems |
| JP2018063623A (en) * | 2016-10-14 | 2018-04-19 | キヤノンマーケティングジャパン株式会社 | Information analysis apparatus, control method thereof, and program |
| CN108228223A (en) * | 2017-10-26 | 2018-06-29 | 山东浪潮云服务信息科技有限公司 | Multi-type database based on domestic CPU environment unifies increment updating method |
| CN109739835A (en) * | 2018-12-29 | 2019-05-10 | 中国银联股份有限公司 | A kind of versions of data store method and device |
| CN111142903A (en) * | 2019-12-23 | 2020-05-12 | 杭州安恒信息技术股份有限公司 | Configuration file interactive updating method and device based on file comparison |
| CN111177302A (en) * | 2019-12-16 | 2020-05-19 | 金蝶软件（中国）有限公司 | Business document processing method and device, computer equipment and storage medium |
| CN111709702A (en) * | 2020-06-01 | 2020-09-25 | 昆山夏洛特智能科技有限公司 | Product full life cycle management system |
| CN112016166A (en) * | 2020-09-25 | 2020-12-01 | 中铁第六勘察设计院集团有限公司 | Differentiation comparison method for three-dimensional model of subway design |
| CN112130882A (en) * | 2020-09-29 | 2020-12-25 | 中国银行股份有限公司 | Version updating method and device |
| CN112287027A (en) * | 2020-10-29 | 2021-01-29 | 成都完美天智游科技有限公司 | Database synchronization method, device, equipment and storage medium |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2005003963A2 (en) * | 2003-07-07 | 2005-01-13 | Red Bend Ltd. | Method and system for updating versions of content stored in a storage device |
| US8078655B2 (en) * | 2008-06-04 | 2011-12-13 | Microsoft Corporation | Generation of database deltas and restoration |
-
2021
- 2021-07-19 CN CN202110815814.0A patent/CN113535727B/en active Active
Patent Citations (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP2081117A2 (en) * | 2007-10-05 | 2009-07-22 | Canon Kabushiki Kaisha | Information processing apparatus and control method thereof, and document verification apparatus and control method thereof |
| CN101499069A (en) * | 2008-02-02 | 2009-08-05 | 中兴通讯股份有限公司 | Internal memory database file updating method and apparatus |
| US9047334B1 (en) * | 2009-07-31 | 2015-06-02 | David R. Cheriton | Merge-update for efficient atomic memory modification in concurrent computer systems |
| WO2015016807A1 (en) * | 2013-07-29 | 2015-02-05 | Hewlett-Packard Development Company, L.P. | Database analysis and validation |
| JP2018063623A (en) * | 2016-10-14 | 2018-04-19 | キヤノンマーケティングジャパン株式会社 | Information analysis apparatus, control method thereof, and program |
| CN108228223A (en) * | 2017-10-26 | 2018-06-29 | 山东浪潮云服务信息科技有限公司 | Multi-type database based on domestic CPU environment unifies increment updating method |
| CN109739835A (en) * | 2018-12-29 | 2019-05-10 | 中国银联股份有限公司 | A kind of versions of data store method and device |
| CN111177302A (en) * | 2019-12-16 | 2020-05-19 | 金蝶软件（中国）有限公司 | Business document processing method and device, computer equipment and storage medium |
| CN111142903A (en) * | 2019-12-23 | 2020-05-12 | 杭州安恒信息技术股份有限公司 | Configuration file interactive updating method and device based on file comparison |
| CN111709702A (en) * | 2020-06-01 | 2020-09-25 | 昆山夏洛特智能科技有限公司 | Product full life cycle management system |
| CN112016166A (en) * | 2020-09-25 | 2020-12-01 | 中铁第六勘察设计院集团有限公司 | Differentiation comparison method for three-dimensional model of subway design |
| CN112130882A (en) * | 2020-09-29 | 2020-12-25 | 中国银行股份有限公司 | Version updating method and device |
| CN112287027A (en) * | 2020-10-29 | 2021-01-29 | 成都完美天智游科技有限公司 | Database synchronization method, device, equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113535727A (en) | 2021-10-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6910053B1 (en) | Method for data maintenance in a network of partially replicated database systems | |
| CN107515878B (en) | Data index management method and device | |
| US8280917B1 (en) | Batching content management operations to facilitate efficient database interactions | |
| CN111506559A (en) | Data storage method and device, electronic equipment and storage medium | |
| CN103577483B (en) | The method and system of date storage method and system and data access | |
| CN111858760B (en) | Data processing method and device for heterogeneous database | |
| CN102202087A (en) | Method for identifying storage equipment and system thereof | |
| CN102609488A (en) | Client, data query method of client, server and data query system | |
| CN111767327A (en) | Data warehouse component method and system with dependency relationship among data streams | |
| CN113672624A (en) | Data processing method, system and storage medium | |
| CN111008521A (en) | Method and device for generating wide table and computer storage medium | |
| CN103324713A (en) | Data processing method and device in multistage server and data processing system | |
| CN113535727B (en) | Data output method and device of information system and electronic equipment | |
| CN101046822B (en) | Centralized management of data nodes | |
| CN111460038A (en) | Quasi-real-time data synchronization method and device | |
| CN103440302B (en) | The method and system of Real Data Exchangs | |
| CN112988280A (en) | Configuration data processing method and device | |
| CN106716400A (en) | Partitioned management method and apparatus for data table | |
| US8200701B2 (en) | Handling of data in a data sharing system | |
| CN106506661A (en) | Method, server and system for dynamically returning data | |
| CN111984740B (en) | Service data table processing method, device, computer equipment and storage medium | |
| CN111090530B (en) | Distributed inter-process communication bus system | |
| CN112163024B (en) | Configuration information export and import method based on hierarchical association structure | |
| US20210141791A1 (en) | Method and system for generating a hybrid data model | |
| CN101515362A (en) | Method for transmitting data of an overall snapshot of a securities quotation order |
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 |