CN113535727A - Data output method and data output device of information system and electronic equipment - Google Patents
Data output method and data output device of information system and electronic equipment Download PDFInfo
- Publication number
- CN113535727A CN113535727A CN202110815814.0A CN202110815814A CN113535727A CN 113535727 A CN113535727 A CN 113535727A CN 202110815814 A CN202110815814 A CN 202110815814A CN 113535727 A CN113535727 A CN 113535727A
- Authority
- CN
- China
- Prior art keywords
- data
- item
- attribute
- version
- release
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 39
- 238000013500 data storage Methods 0.000 claims abstract description 58
- 238000010276 construction Methods 0.000 claims description 26
- 238000012217 deletion Methods 0.000 claims description 13
- 230000037430 deletion Effects 0.000 claims description 13
- 238000012545 processing Methods 0.000 claims description 13
- 230000004048 modification Effects 0.000 claims description 9
- 238000012986 modification Methods 0.000 claims description 9
- 230000008859 change Effects 0.000 claims description 7
- 238000004590 computer program Methods 0.000 claims description 7
- 238000007726 management method Methods 0.000 abstract description 19
- 230000005540 biological transmission Effects 0.000 abstract description 18
- 238000005516 engineering process Methods 0.000 abstract description 7
- 238000010586 diagram Methods 0.000 description 4
- 230000008569 process Effects 0.000 description 4
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000004891 communication Methods 0.000 description 2
- 238000005034 decoration Methods 0.000 description 2
- 238000003032 molecular docking Methods 0.000 description 2
- 238000013523 data management Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 238000003780 insertion Methods 0.000 description 1
- 230000037431 insertion Effects 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
- 230000000717 retained effect Effects 0.000 description 1
- 238000012384 transportation and delivery Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a data output method and a data output 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 low efficiency and large consumption of management resources when the 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 a data output apparatus for 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 do not leave change logs of multiple versions or service data, and at this time, when the information system performs data integration with other systems requiring version control, if a requirement is met to transmit difference data between a current release version and a last release version, such as what content is newly added, what content is modified, what content is deleted, and the like, the difference data cannot be realized because data of the last release version cannot be acquired.
For the aforementioned version differences that cannot be delivered by the delivery system, there are three current solutions:
the first solution is as follows: a version management library is constructed for the current information system. However, this solution requires a large amount of resources to implement version management, and thus not only the time cost but also the resource cost required to be invested are high.
The second solution is as follows: and calling an inquiry interface of the docking system for comparison. However, in this solution, the docking system needs to have a corresponding query interface, which is often not satisfied, and because of the problem of the format of the query result, comparison also needs to consume a certain amount of resources.
The third solution is: and recording an operation log and summarizing difference information from the log. However, this solution requires a lot of resources to implement, and it is likely that the final summarization will be error due to repeated modification operations of the same data.
In view of the above problems, no effective solution has been proposed.
Disclosure of Invention
The embodiment of the invention provides a data output method, a data output device and electronic equipment of an information system, and aims to at least solve the technical problems of low efficiency and consumption of a large amount of management resources when differential data of the information system in a version transmission process are managed 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 an information system comprises: constructing a data comparison table of an information system; constructing a first attribute item for identifying the uniqueness of the data of the current version in the data comparison table; constructing a second attribute item for identifying the uniqueness of the data of the historical version in the data comparison table; constructing a first numerical item for storing the attribute value of the current version in the data comparison table; constructing a second numerical item for storing the attribute values 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 item, the second numerical item and the operation identification item which are constructed in the data comparison table.
Optionally, with the data storage structure, the step of identifying difference data of the release data of the current version relative to the release data of the historical version 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 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 newly added operation; and 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 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 the same as the attribute identifier in the second attribute item; if the attribute identification in the first attribute item is the same as the attribute identification in the second attribute item, comparing whether the version numerical value in the first numerical item is the same as the version numerical value in the second numerical item; if the version numerical value in the first numerical item is different from the version numerical value in the second numerical item, determining that the release data of the current version has modification data relative to the release data of the historical version, and setting the operation identification item as a change operation; and if the version numerical value in the first numerical item is the same as the version numerical value in the second numerical item, setting the operation identification item as a non-processing operation.
Optionally, after outputting the difference data, the data output method further includes: updating the attribute identification of the first attribute item which is successfully output to the second attribute item; updating the version numerical value in the first numerical value item which is successfully output to a second numerical value item; and updating the first attribute item and the first attribute item in the data comparison table to be null.
According to another aspect of the embodiments of the present invention, there is also provided a data output apparatus of an information system, including: the system comprises a construction unit, a storage unit and a processing unit, wherein the construction unit is used for constructing a data storage structure of an 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 the 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; an output unit for outputting the difference data.
Optionally, the construction 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 uniqueness of the data of the current version in the data comparison table; the third building module is used for building a second attribute item for identifying the data uniqueness of the historical version in the data comparison table; the fourth construction module is used for constructing a first numerical item for storing the attribute value of the current version in the data comparison table; the fifth construction module is used for constructing a second numerical value item used for storing the attribute value of the historical version in the data comparison table; the sixth construction module is used for constructing an operation identification item for storing a comparison result in the data comparison table; and the seventh construction module is used for 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 which are constructed in the data comparison table.
Optionally, the identification unit includes: the first comparison module is used for comparing the first attribute item with the second attribute item in the data comparison table to obtain a comparison result; a first determining module, configured to determine that new added data exists in the release data of the current version 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 set the operation identifier item as an new 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 identification does not exist in the first attribute item and the attribute identification exists in the second attribute item, and setting the operation identification item as deletion operation.
Optionally, the data output apparatus further includes: a second comparison module, configured to compare, after a comparison result is obtained by comparing the first attribute item and the second attribute item in the data comparison table, if the comparison result indicates that an attribute identifier exists in the first attribute item and an attribute identifier exists in the second attribute item, compare whether the attribute identifier in the first attribute item is the same as the attribute identifier in the second attribute item; the third comparison module is used for comparing whether the version numerical value in the first numerical value item is the same as the version numerical value in the second numerical value item when the attribute identification in the first attribute item is the same as the attribute identification in the second attribute item; the first determining module is used for determining that the release data of the current version has modification data relative to the release data of the historical version if the version numerical value in the first numerical item is different from the version numerical value in the second numerical 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 numerical value in the first numerical item is the same as the version numerical value in the second numerical item.
Optionally, the data output apparatus further includes: the first updating module is used for updating the attribute identification of the first attribute item which is successfully output to the second attribute item after the difference data is output; the second updating module is used for updating the version numerical value in the first numerical value item which is successfully output to the second numerical 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 null.
According to another aspect of the embodiments 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 any one of the above described data output methods of the information system 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, where the computer-readable storage medium includes a stored computer program, and when the computer program runs, the apparatus where the computer-readable storage medium is located is controlled to execute the data output method of the information system according to any one of the above.
In the embodiment of the invention, a data storage structure of an information system is firstly constructed, the data storage structure is adopted, the difference data of the release data of the current version relative to the release data of the historical version is identified, and the difference data is output. In the embodiment, the comparison between the current version and the previous version 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, and the data transmission efficiency is improved, so that the technical problems that the efficiency is low and a large amount of management resources are consumed when the difference data of the information management system in the version transmission process in the related technology is managed 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 embodiment(s) of the invention and together with the description serve to explain the invention without limiting the invention. In the drawings:
FIG. 1 is a flow chart of an alternative method of data output from an information system in accordance with an embodiment of the present invention;
FIG. 2 is a schematic diagram of an alternative data output method for 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 to make the technical solutions of the present invention better understood, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that the terms "first," "second," and the like in the description and claims of the present invention and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are capable of operation in sequences other than those illustrated or 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 embodiments of the present application are explained below:
a management information system: managing user data, including graphic documents, PDM, process data management, PLM, ERP, MES;
difference data: the content of the differences between the different versions of 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 needs to be constructed to realize the version management data difference of the information system, the method and the system can construct release data capable of storing each system version, realize the comparison between the current version and the previous version, 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 will be described with reference to the above embodiments.
Example one
In accordance with an embodiment of the present invention, there is provided an information system data output method embodiment, it should be noted that the steps illustrated in the flowchart of the accompanying drawings may be performed in a computer system such as a set of computer executable instructions, and that while a logical order is illustrated in the flowchart, in some cases the steps illustrated or described may be performed in an order different than that 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 includes the following steps:
step S102, constructing a data storage structure of the information system, wherein the data storage structure is used for storing the release data of the current version and the release data of the 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, the data storage structure is adopted for identifying 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 between the current version and the previous version 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, and the data transmission efficiency is improved, so that the technical problems that the efficiency is low and a large amount of management resources are consumed when the difference data of the information management system in the version transmission process in the related technology is managed are solved.
The embodiments of the present application describe an information system by taking a management information system as an example. Different versions of each management information system need to be updated along with the time lapse and the change of customer requirements so as to adapt to the requirements of various customers and improve the utilization rate.
The following describes embodiments of the present application in conjunction with the above-described implementation steps.
Step S102, a data storage structure of the information system is 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.
The data storage structure of the information system constructed in this embodiment can store the data structures of the current version and the previous version at the same time.
Optionally, the step of constructing a data storage structure of the information system includes: constructing a data comparison table of an information system; constructing a first attribute item for identifying the uniqueness of the data of the current version in the data comparison table; constructing a second attribute item for identifying the uniqueness of the data of the historical version in the data comparison table; constructing a first numerical item for storing the attribute value of the current version in the data comparison table; constructing a second numerical item for storing the attribute values of the historical versions 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 which are constructed in the data comparison table.
In this embodiment, the first attribute item may refer to a key attribute for identifying data uniqueness; the second attribute item can refer to a key attribute used for identifying the uniqueness of the data; the first numerical item may refer to a value storing some attribute of the last release version; the second numerical item may refer to a value storing some attribute of the current release version; the operation identifier item may be an operation identifier obtained by storing the comparison result.
By creating a data storage structure in advance, this embodiment may be named TABLE _ store, and is intended to store the current release data and the previous release data, and the TABLE structure attribute of the data storage structure is as shown in TABLE 1 below:
TABLE 1 Table Structure Attribute for data storage structures
| Field(s) | Description of the invention |
| Old_Key | Key attributes to identify data uniqueness |
| New_Key | Key attributes to identify data uniqueness |
| OLD_Val | Storing the value of an attribute of a last release version |
| New_Val | Storing the value of an attribute of a current release version |
| Act_flag | Storing the operation identifier obtained from the comparison result |
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.
Optionally, the step of identifying, by using a data storage structure, difference data of the release data of the current version with respect to the release data of the historical version 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 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 newly added operation; and 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 deletion operation.
In the use process of the management information system, the BOM data is taken as an example, and the data in the TABLE _ store TABLE when the BOM data is generated, published for the first time, transferred, unpublished and modified, published for the second time, and transferred is as illustrated in the following TABLE 2:
table 2 first release
| Old_Key | New_Key | OLD_Val | New_Val | Act_flag |
| A-B | The number is 1 | Adding new | ||
| A-C | The number is 3 | Adding new |
According to the data in the current TABLE, through the comparison of the New _ Key and the Old _ Key, the New _ Key is found but no Old _ Key exists, the New data exists, the data is New, the New data is directly transmitted to a data receiver, after the New data is successfully transmitted, the TABLE _ HISTORY TABLE is updated, the NEW data is updated to the OLD data, and the result is as follows in the following TABLE 3:
table 3 updating OLD data
| Old_Key | New_Key | OLD_Val | New_Val | Act_flag |
| A-B | The number is 1 | |||
| A-C | The number is 3 |
Optionally, 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 the same as the attribute identifier in the second attribute item; if the attribute identification in the first attribute item is the same as the attribute identification in the second attribute item, comparing whether the version numerical value in the first numerical item is the same as the version numerical value in the second numerical item; if the version numerical value in the first numerical item is different from the version numerical value in the second numerical item, determining that the release data of the current version has modification data relative to the release data of the historical version, and setting the operation identification item as change operation; and if the version numerical value in the first numerical item is the same as the version numerical value in the second numerical item, setting the operation identification item as the non-processing operation.
After the reissue is modified, assuming that an additional A-D number is 2, the A-C is deleted, and the A-B number is 10, at this time, it is first required to query whether there is a passing record in the table according to the KEY value, i.e. whether the current KEY value is matched with the table seed Old _ KEY, if the current KEY value is the same as the table seed Old _ KEY, the update is performed, if the current KEY value is different from the table seed Old _ KEY, the insertion is performed, and the result is as the following table 4:
TABLE 4 second issue
| Old_Key | New_Key | OLD_Val | New_Val | Act_flag |
| A-B | A-B | The number is 1 | The number is 10 | Modifying |
| A-C | The number is 3 | Deleting | ||
| A-D | The number is 2 | Adding new |
From TABLE 4 by contrast, if both OLDKEY and NEWKEY have values and OLDVAL and NEWVAL are not the same, 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 addition, after passing according to the TABLE seed data, updating the TABLE _ historey TABLE as in TABLE 5 below:
TABLE 5 update TABLE _ HISTORY TABLE
| Old_Key | New_Key | OLD_Val | New_Val | Act_flag |
| A-B | The number is 10 | |||
| A-D | The number is 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 first attribute item which is successfully output to the second attribute item; updating the version numerical value in the first numerical value item which is successfully output to a second numerical value item; and updating the first attribute item and the first attribute item in the data comparison table to be null.
In the embodiment of the application, after data output, post-processing may be performed once, and the processing logic updates NEW _ KEY and NEW _ VAL of records that are successfully output to OLD _ KEY and OLD _ VAL, and updates NEW _ KEY and NEW _ VAL to null, and waits for next data issue input.
The examples of the present application are described below in conjunction with another alternative embodiment. The present embodiment is described in conjunction with the data storage structure TABLE _ store constructed as described above, and the corresponding TABLE attributes.
Fig. 2 is a schematic diagram of another alternative data output method of an 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 is queried in a TABLE _ store TABLE of the data storage structure, if the result is found, the published data is updated to NEW _ KEY and NEW _ VAL, and if the result is not found, records are newly added, and data is written into NEW _ KEY and NEW _ VAL.
Then, comparing the NEW _ KEY with the OLD _ KEY, and if the NEW _ KEY is empty and the OLD _ KEY is not empty, setting the operation as a deleting operation; if the NEW _ KEY is not empty and the OLD _ KEY is empty, setting the operation as a NEW adding 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 setting operation is a non-processing operation, if the NEW _ VAL is different from the OLD _ VAL, the setting operation is a changing operation (updating operation), and finally, the adding and deleting record is output according to the set operation, namely, the operation result is output, and meanwhile, the difference data also needs to be output.
The embodiment illustrated in fig. 2 may provide a scheme that data of one version may be retained for a management information system without version control by constructing TABLE _ store, and may implement comparison between a current version and previous version data in a TABLE _ store TABLE, so that data without version control in the management information system may transmit difference information to other systems, thereby reducing transmission of redundant data and improving efficiency of data transmission.
Embodiments of the invention are described below in conjunction with another alternative embodiment.
Example two
The present embodiment provides a data output device of an information system, which includes a plurality of implementation units, each implementation unit corresponding to a respective implementation step in the first embodiment.
Fig. 3 is a schematic diagram of an alternative data output device of an 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, a recognition unit 33, and 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 used to store the release data of the current version and the release data of the historical version;
an identifying unit 33 configured to identify, with a data storage structure, difference data of the release data of the current version with respect to the release data of the historical version;
an output unit 35 for outputting the difference data.
The data output apparatus may be configured by the configuration unit 31 to configure a data storage structure of the information system, wherein the data storage structure is configured to store the release data of the current version and the release data of the historical version, the identification unit 33 identifies difference data of the release data of the current version relative to the release data of the historical version using the data storage structure, and the output unit 35 outputs the difference data. In the embodiment, the comparison between the current version and the previous version 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, and the data transmission efficiency is improved, so that the technical problems that the efficiency is low and a large amount of management resources are consumed when the difference data of the information management system in the version transmission process in the related technology is managed 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 uniqueness of the data of the current version in the data comparison table; the third building module is used for building a second attribute item for identifying the data uniqueness of the historical version in the data comparison table; the fourth construction module is used for constructing a first numerical item for storing the attribute value of the current version in the data comparison table; the fifth construction module is used for constructing a second numerical value item used for storing the attribute value of the historical version in the data comparison table; the sixth construction module is used for constructing an operation identification item for storing a 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 item, the second numerical item and the operation identification item which are constructed in the data comparison table.
Optionally, 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 newly added data exists in the release data of the current version relative to the release data of the historical version when the comparison result indicates that the attribute identification exists in the first attribute item and the attribute identification does not exist in the second attribute item, and setting the operation identification 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 identification does not exist in the first attribute item and the attribute identification exists in the second attribute item, and setting the operation identification item as deletion operation.
Optionally, the data output device further comprises: the second comparison module is used for comparing the first attribute item with 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 numerical value in the first numerical value item is the same as the version numerical value in the second numerical value item when the attribute identification in the first attribute item is the same as the attribute identification in the second attribute item; the first determining module is used for determining that the release data of the current version has modification data relative to the release data of the historical version if the version numerical value in the first numerical item is different from the version numerical value in the second numerical 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 the non-processing operation when the version numerical value in the first numerical item is the same as the version numerical value in the second numerical item.
Optionally, the data output device further comprises: the first updating module is used for updating the attribute identification of the first attribute item which is successfully output to the second attribute item after outputting the difference data; the second updating module is used for updating the version numerical value in the first numerical value item which is successfully output to the second numerical 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 null.
The data output device may further include a processor and a memory, the building unit 31, the identifying unit 33, the output unit 35, and the like are stored in the memory as program units, and the processor executes the program units stored in the memory to implement corresponding functions.
The processor comprises a kernel, and the kernel calls a corresponding program unit from the memory. The kernel can be set to be one or more, a data storage structure is adopted by adjusting kernel parameters, the difference data of the current version of the release data relative to the historical version of the release data is identified, and the difference data is output.
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), and the memory includes at least one memory chip.
According to another aspect of the embodiments of the present invention, there is also provided an electronic device, including: a processor; and a memory for storing executable instructions for 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 embodiments of the present invention, there is also provided a computer-readable storage medium, which includes a stored computer program, wherein when the computer program runs, the apparatus on which the computer-readable storage medium is located is controlled to execute the data output method of the information system according to any one of the above.
The present application further provides a computer program product adapted to perform a program for initializing the following method steps when executed on a data processing device: 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 above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
In the above embodiments of the present invention, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.
In the embodiments provided in the present application, it should be understood that the disclosed technology can be implemented in other ways. The above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units may be a logical division, and in actual implementation, there may be another division, for example, multiple 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 through some interfaces, units or modules, and may be in an electrical 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 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 invention 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 integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit 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 invention may be embodied in the form of a software product, which is stored in a storage medium and includes 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 invention. And the aforementioned storage medium includes: a U-disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic or optical disk, and other various media capable of storing program codes.
The foregoing is only a preferred embodiment of the present invention, and it should be noted that, for those skilled in the art, various modifications and decorations can be made without departing from the principle of the present invention, and these modifications and decorations should also be regarded as the protection scope of the present invention.
Claims (10)
1. A data output method of an information system, comprising:
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.
2. The data output method of claim 1, wherein the step of constructing a data storage structure of an information system comprises:
constructing a data comparison table of an information system;
constructing a first attribute item for identifying the uniqueness of the data of the current version in the data comparison table;
constructing a second attribute item for identifying the uniqueness of the data of the historical version in the data comparison table;
constructing a first numerical item for storing the attribute value of the current version in the data comparison table;
constructing a second numerical item for storing the attribute values 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 item, the second numerical item and the operation identification item which are constructed in the data comparison table.
3. The data output method according to claim 2, wherein the step of identifying, using the data storage structure, difference data of the current version of the distributed data with respect to the historical version of the distributed data 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 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 newly added operation;
and 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 deletion operation.
4. The data output method according to claim 3, 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 the same as the attribute identifier in the second attribute item;
if the attribute identification in the first attribute item is the same as the attribute identification in the second attribute item, comparing whether the version numerical value in the first numerical item is the same as the version numerical value in the second numerical item;
if the version numerical value in the first numerical item is different from the version numerical value in the second numerical item, determining that the release data of the current version has modification data relative to the release data of the historical version, and setting the operation identification item as a change operation;
and if the version numerical value in the first numerical item is the same as the version numerical value in the second numerical item, setting the operation identification item as a non-processing operation.
5. The data output method according to claim 2, wherein after outputting the difference data, the data output method further comprises:
updating the attribute identification of the first attribute item which is successfully output to the second attribute item;
updating the version numerical value in the first numerical value item which is successfully output to a second numerical value item;
and updating the first attribute item and the first attribute item in the data comparison table to be null.
6. A data output apparatus of an information system, comprising:
the system comprises a construction unit, a storage unit and a processing unit, wherein the construction unit is used for constructing a data storage structure of an 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 the 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;
an output unit for outputting the difference data.
7. The data output apparatus according to claim 6, wherein 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 uniqueness of the data of the current version in the data comparison table;
the third building module is used for building a second attribute item for identifying the data uniqueness of the historical version in the data comparison table;
the fourth construction module is used for constructing a first numerical item for storing the attribute value of the current version in the data comparison table;
the fifth construction module is used for constructing a second numerical value item used for storing the attribute value of the historical version in the data comparison table;
the sixth construction module is used for constructing an operation identification item for storing a comparison result in the data comparison table;
and the seventh construction module is used for 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 which are constructed in the data comparison table.
8. The data output apparatus according to claim 7, wherein the identification unit includes:
the first comparison module is used for comparing the first attribute item with the second attribute item in the data comparison table to obtain a comparison result;
a first determining module, configured to determine that new added data exists in the release data of the current version 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 set the operation identifier item as an new 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 identification does not exist in the first attribute item and the attribute identification exists in the second attribute item, and setting the operation identification item as deletion operation.
9. 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 5 via execution of the executable instructions.
10. A computer-readable storage medium, characterized in that the computer-readable storage medium comprises a stored computer program, wherein when the computer program runs, the computer-readable storage medium controls an apparatus to execute the data output method of the information system according to any one of claims 1 to 5.
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 true CN113535727A (en) | 2021-10-22 |
| CN113535727B 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) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113934644A (en) * | 2021-12-16 | 2022-01-14 | 深圳市明源云链互联网科技有限公司 | Version difference comparison method and device, intelligent terminal and readable storage medium |
Citations (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050027758A1 (en) * | 2003-07-07 | 2005-02-03 | Evyatar Meller | Method and system for updating versions of content stored in a storage device |
| 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 |
| US20090307277A1 (en) * | 2008-06-04 | 2009-12-10 | Microsoft Corporation | Generation of database deltas and restoration |
| 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 |
-
2021
- 2021-07-19 CN CN202110815814.0A patent/CN113535727B/en active Active
Patent Citations (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050027758A1 (en) * | 2003-07-07 | 2005-02-03 | Evyatar Meller | Method and system for updating versions of content stored in a storage device |
| 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 |
| US20090307277A1 (en) * | 2008-06-04 | 2009-12-10 | Microsoft Corporation | Generation of database deltas and restoration |
| 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 |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113934644A (en) * | 2021-12-16 | 2022-01-14 | 深圳市明源云链互联网科技有限公司 | Version difference comparison method and device, intelligent terminal and readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113535727B (en) | 2024-04-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP4760491B2 (en) | Event processing system, event processing method, event processing apparatus, and event processing program | |
| US8095561B2 (en) | Extensible framework for data import and export | |
| EP3049968B1 (en) | Master schema shared across multiple tenants with dynamic update | |
| CN112395293B (en) | Database and table dividing method, database and table dividing device, database and table dividing equipment and storage medium | |
| CN104573093B (en) | A kind of method and apparatus for managing file directory | |
| CN101777057A (en) | Methods and systems for storing customer fields for multiple tenants in multi-tenant database system | |
| CN111506559A (en) | Data storage method and device, electronic equipment and storage medium | |
| CN102436473A (en) | Menu management device and menu management method | |
| CN103577483B (en) | The method and system of date storage method and system and data access | |
| CN112416972A (en) | Real-time data stream processing method, device, equipment and readable storage medium | |
| CN105138532A (en) | Method, device and system for processing service data | |
| KR20120135665A (en) | Method for constructing database based on warehouse and database system therof | |
| CN113535727A (en) | Data output method and data output device of information system and electronic equipment | |
| CN112988280B (en) | Configuration data processing method and device | |
| CN110989891A (en) | Component deployment method in chart editor, chart editor and related equipment | |
| CN109634585B (en) | Method for adaptively displaying and updating server data based on form | |
| US10185757B2 (en) | Non-uniform multi-row text file loading | |
| CN112364021B (en) | Service data processing method, device and storage medium | |
| CN113760902A (en) | Data splitting method, device, equipment, medium and program product | |
| CN110362540B (en) | Data storage and visitor number acquisition method and device | |
| CN108268604A (en) | BOM tables data transfer device, system | |
| CN109840078B (en) | Method and device for collaboratively editing hierarchical metadata | |
| CN115130959B (en) | Method, system, terminal and storage medium for generating spare part BOM | |
| CN111124883A (en) | Test case library introduction method, system and equipment based on tree form | |
| CN112204527A (en) | Method and system for processing engineering data in a multi-engineering system environment |
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 |