CN110941621A - Method and device for synchronizing databases between internal network and external network - Google Patents
Method and device for synchronizing databases between internal network and external network Download PDFInfo
- Publication number
- CN110941621A CN110941621A CN201811113963.7A CN201811113963A CN110941621A CN 110941621 A CN110941621 A CN 110941621A CN 201811113963 A CN201811113963 A CN 201811113963A CN 110941621 A CN110941621 A CN 110941621A
- Authority
- CN
- China
- Prior art keywords
- database
- execution information
- script file
- updating operation
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The invention discloses a method and a device for synchronizing databases between an internal network and an external network, which relate to the field of data processing, can improve the efficiency and the accuracy of synchronizing data of the internal network and the external network, and also can ensure the consistency of the data in the internal network system and the external network system in time, and the main technical scheme of the invention is as follows: when detecting that the application program accesses the database, identifying an updating operation performed on the database; writing database execution information corresponding to the updating operation into a specified script file, wherein the database execution information refers to execution information for executing one updating operation on the intranet database; and under the isolated network environment, transmitting the specified script file to the extranet server so that the extranet server executes updating operation on the extranet database according to one or more database execution information written in the specified script file, and synchronizing the data of the intranet database and the extranet database. The invention is applied to the synchronization of data in an internal network system and an external network system.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a method and a device for synchronizing a database between an internal network and an external network.
Background
In judicial business, a part of business systems are deployed in a court private network (namely, an intranet network environment) for court professional practitioners such as judges and bookkeeping staff to use, a part of business systems are deployed on the internet (namely, an extranet network environment) for parties, lawyers and social public to use, and the court private network and the internet are physically isolated so as to protect the court private network from being invaded by illegal users and create a pure and safe intranet network environment, but data in the intranet system and the extranet system are still required to be synchronized, so that a reliable data synchronization mechanism is required to ensure that data in the intranet system and the extranet system are kept consistent.
At present, the existing method for synchronizing data in both intranet and extranet systems is that a database administrator regularly exports updated data in intranet and extranet databases, and then imports the data into the other system, and the operation is required to be performed at night when the extranet system is not used by people or the number of users is small. However, such a method for synchronizing intranet and extranet data by using manpower not only consumes labor cost, has low efficiency, is easy to miss or repeat data, but also is not timely synchronized, so that the situation that the related information of the intranet and extranet legal cases is inconsistent often occurs, which will cause misleading to the understanding of the legal cases by the user.
Disclosure of Invention
In view of this, the present invention provides a method and an apparatus for synchronizing a database between an internal network and an external network, and mainly aims to optimize the data synchronization process of the internal network system and the external network system, so as to improve the efficiency and accuracy of synchronizing the data of the internal network system and the external network system, and also ensure the timeliness of synchronizing the data, and timely ensure the consistency of the data in the internal network system and the external network system.
In order to solve the above problems, the present invention mainly provides the following technical solutions:
in one aspect, the present invention provides a method for synchronizing databases between an internal network and an external network, the method comprising:
when detecting that an application program accesses a database, identifying an updating operation performed on the database;
writing database execution information corresponding to the updating operation into a specified script file, wherein the database execution information refers to execution information for executing one updating operation on the intranet database;
and transmitting the specified script file to an external network server under an isolated network environment, so that the external network server executes updating operation on a database of an external network according to one or more database execution information written in the specified script file, and performs data synchronization on the database of the internal network and the database of the external network.
Optionally, the writing the database execution information corresponding to the update operation into a specified script file includes:
acquiring basic information of a database which is subjected to updating operation and corresponds to one updating operation, a script file for executing the updating operation and time for executing the updating operation;
packaging the basic information of the database on which the updating operation is executed, the script file for executing the updating operation and the time for executing the updating operation as the database execution information corresponding to the updating operation;
sending the encapsulated database execution information to a common message queue;
reading the database execution information from the common message queue using a data derivation program;
and writing the read database execution information into a specified script file.
Optionally, the sending the encapsulated database execution information to a common message queue includes:
sequencing the execution information of the databases according to the sequence of the time for executing the updating operation;
according to the sorting, sequentially writing the database execution information into a common message queue;
judging whether the number of the database execution information written in the public message queue reaches a preset threshold value or not;
and if so, stopping writing the database execution information into the public message queue.
Optionally, the reading, by the data derivation program, the database execution information from the common message queue includes:
when the number of the data export programs is one, consuming the database execution information written in the public message queue by using the data export programs according to a preset time period; or
When the data derivation program is plural, the database execution information written in the common message queue is consumed in parallel using a plurality of the data derivation programs.
Optionally, the identifying an update operation performed on the database includes:
intercepting an operation performed on a database on an ORM mapping layer when it is detected that an application program accesses the database;
searching the intercepted operation performed on the database for an updating operation performed on the database.
Optionally, the transmitting the specified script file to an extranet server includes:
and transmitting the specified script file to an extranet server through a unidirectional isolation optical gate.
In order to achieve the above object, according to another aspect of the present invention, there is provided a storage medium including a stored program, wherein when the program runs, a device on which the storage medium is located is controlled to execute the method for synchronizing the database between the intranet and the extranet.
In order to achieve the above object, according to another aspect of the present invention, there is provided a processor for executing a program, wherein the program executes the method for synchronizing the databases between the intranet and the extranet.
On the other hand, the invention also provides a device for synchronizing the database between the internal network and the external network, which comprises:
the device comprises an identification unit, a storage unit and a control unit, wherein the identification unit is used for identifying the updating operation executed on the database when detecting that the application program accesses the database;
a writing unit, configured to write database execution information corresponding to the update operation identified by the identification unit into a specified script file, where the database execution information is execution information for executing an update operation on a database in an intranet;
and the transmission unit is used for transmitting the specified script file to an external network server under an isolated network environment so that the external network server can execute updating operation on the database of the external network according to one or more database execution information written in the specified script file and perform data synchronization on the database of the internal network and the database of the external network.
Optionally, the writing unit includes:
the acquisition module is used for acquiring the basic information of the database which is subjected to the updating operation and corresponds to the updating operation, the script file for executing the updating operation and the time for executing the updating operation;
a packaging module, configured to package, as database execution information corresponding to the one-time update operation, the basic information of the database on which the update operation is executed, the script file for executing the update operation, and the time for executing the update operation, which are acquired by the acquisition module;
the sending module is used for sending the database execution information packaged by the packaging module to a public message queue;
a reading module for reading the database execution information from a common message queue using a data derivation program;
and the writing module is used for writing the read database execution information into a specified script file.
Optionally, the encapsulation module includes:
the sequencing submodule is used for sequencing the database execution information according to the sequence of the time for executing the updating operation;
the writing sub-module is used for sequentially writing the database execution information into a common message queue according to the sequencing of the sequencing sub-module;
the judging submodule is used for judging whether the number of the database execution information written in the public message queue reaches a preset threshold value or not;
and the stopping sub-module stops writing the database execution information into the public message queue when the judging sub-module judges that the number of the database execution information written into the public message queue reaches a preset threshold value.
Optionally, the reading module includes:
the first consumption submodule is used for consuming the database execution information written in the public message queue by using the data derivation program according to a preset time period when the number of the data derivation programs is one; or
And the second consumption submodule is used for consuming the database execution information written in the common message queue in parallel by using a plurality of data derivation programs when the number of the data derivation programs is multiple.
Optionally, the identification unit includes:
the system comprises an interception module, a database processing module and a management module, wherein the interception module is used for intercepting operation executed on the database on an ORM mapping layer when detecting that an application program accesses the database;
the searching module is used for searching the updating operation executed on the database in the operation executed on the database intercepted by the intercepting module.
Optionally, the transmission unit is further configured to transmit the specified script file to an extranet server through a unidirectional isolation optical gate.
By the technical scheme, the technical scheme provided by the invention at least has the following advantages:
the invention provides a method and a device for synchronizing databases between an internal network and an external network, which are characterized in that updating operation executed on the databases in the internal network is identified, database execution information corresponding to the updating operation is written into a specified script file, further, relevant information of the updating operation executed on the databases in the internal network is summarized, and the specified script file is transmitted to an external network server, so that the external network server can play back the script file corresponding to the updating operation executed on the internal network in the external network according to the database execution information written in the specified script file, namely, the corresponding updating operation is executed on the databases in the external network system according to the database execution information, and further, the databases in the internal network system and the databases in the external network system are subjected to data synchronization. Compared with the prior art, the method solves the problems of low efficiency, low accuracy and untimely data synchronization caused by a method for synchronizing the data of the internal network and the external network by manpower in the prior art. The invention automatically completes the synchronization of the data in the internal network system and the external network system by using a machine, replaces the manual execution of the data synchronization operation process, further has high efficiency and high accuracy of data synchronization, and does not need to execute the data synchronization operation only when the internal network system and the external network system are not used by people or the number of users is small at night, further can shorten the synchronization period, ensure the timeliness of data synchronization and timely ensure the consistency of the data in the internal network system and the external network system.
The foregoing description is only an overview of the technical solutions of the present invention, and the embodiments of the present invention are described below in order to make the technical means of the present invention more clearly understood and to make the above and other objects, features, and advantages of the present invention more clearly understandable.
Drawings
Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the invention. Also, like reference numerals are used to refer to like parts throughout the drawings. In the drawings:
FIG. 1 is a flowchart of a method for synchronizing databases between an internal network and an external network according to an embodiment of the present invention;
FIG. 2 is a flow chart of another method for synchronizing databases between intranets and intranets according to an embodiment of the present invention;
fig. 3 is a flowchart of a method for synchronizing data in an intranet system and an extranet system according to an embodiment of the present invention;
FIG. 4 is a block diagram illustrating an apparatus for synchronizing databases between an intranet and an extranet according to an embodiment of the present invention;
fig. 5 is a block diagram illustrating another apparatus for synchronizing a database between an intranet and an intranet according to an embodiment of the present invention.
Detailed Description
Exemplary embodiments of the present invention will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the invention are shown in the drawings, it should be understood that the invention can be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the invention to those skilled in the art.
The embodiment of the invention provides a method for synchronizing databases between an internal network and an external network, which is characterized in that as shown in figure 1, the method identifies the updating operation executed on the databases in the internal network, writes the database execution information corresponding to the updating operation into a specified script file, and further summarizes the relevant information of the updating operation executed on the databases in the internal network, so that an external network server can execute the updating operation on the corresponding databases in an external network system according to the data execution information, and the embodiment of the invention provides the following specific steps:
101. when it is detected that an application accesses a database, an update operation performed on the database is identified.
The application program refers to a software program used in an intranet network environment, such as an application program used in a court private network.
In this embodiment of the present invention, the database refers to a relational database, and the update operation performed on the database may include: add, modify, delete, etc., which change the data currently stored in the database when an update operation is performed on the database.
For the embodiment of the invention, in an intranet network environment, when an application program accesses a database, the operation such as query, sorting, modification, deletion and the like can be executed on the database, and when the relevant operation on the database is detected, the updating operation executed on the database is identified, so that the modification of the data stored in the database in the intranet is further determined in the following.
102. And writing the database execution information corresponding to the updating operation into the specified script file.
The database execution information refers to execution information for executing one-time updating operation on the intranet database, and according to the database execution information, which database is to be updated in the intranet and what content related to the executed updating operation is can be known.
For the embodiment of the present invention, under an intranet network environment, a plurality of application programs may be applied, and one application program may also access a plurality of different databases according to service requirements, and accordingly, the database execution information is used to record which application program executes which update operation on which database when an update operation occurs, that is, an execution subject, an execution object, and contents of the execution operation corresponding to an update operation may be known according to the database execution information.
In the embodiment of the present invention, by writing the database execution information corresponding to the update operation into the designated script file, and further when the update operation performed on the database is identified, the database execution information corresponding to each update operation can be stored into the designated script file, and accordingly, the designated script file corresponds to a carrier carrying the database execution information, so as to transmit a plurality of database execution information to the external network through one designated script file, and the script files corresponding to a plurality of update operations performed on the internal network can be played back respectively according to the plurality of database execution information in the external network environment, that is, according to each database execution information, the corresponding update operations can be performed on a plurality of databases corresponding to the internal network environment, and accordingly, according to one designated file, the plurality of update operations performed on the databases occurring in the internal network environment can be played back in the external network environment, therefore, the process of data synchronization between the database of the internal network system and the database of the external network system is accelerated.
For example, for case a, after a decision of the first trial, the second trial people court examines the fact of the first trial, the application of law, the request of the party or the reason for the complaint according to the complaint of the complainer, and makes an adjudication or a decision that: the judgment of the original judgment is true without errors, but the applicable law has errors, or the criminal is improper, and the judgment should be conducted. For the above situation, the court private network should record the result of the secondary audit decision in time, and accordingly, update the database of the intranet system, in the embodiment of the present invention, the update operation is recognized, the database execution information corresponding to the update operation is recorded, and the database execution information is written into the specified script file. When the specified script file is transmitted to the extranet, it is known which application program executed which kind of related update operation to which database according to the database execution information under the extranet environment, and the above-mentioned example is continued, that is, it is known that the secondary inspection judgment result of the case a should be added under the extranet environment, and accordingly, the data of the intranet and the extranet are synchronized.
103. And under the isolated network environment, transmitting the specified script file to the extranet server so that the extranet server executes updating operation on the extranet database according to one or more database execution information written in the specified script file, and synchronizing the data of the intranet database and the extranet database.
In the embodiment of the present invention, the extranet server generally refers to a server applied in an extranet network environment. The isolated network environment means that an internal network and an external network are physically isolated.
In the embodiment of the invention, a server can be designated to receive the designated script file transmitted by the intranet under the extranet network environment, and the extranet server can know which application program executes which related updating operation on which database under the intranet network environment according to the database execution information written in the designated script file, further determine the corresponding database on the extranet system, and execute the corresponding updating operation on the corresponding database, so as to synchronize the data of the intranet database and the data of the extranet database.
The embodiment of the invention provides a method for synchronizing a database between an internal network and an external network, which is characterized in that the updating operation executed on the database in the internal network is identified, the database execution information corresponding to the updating operation is written into a specified script file, then the related information of the updating operation executed on the database in the internal network is summarized, and the specified script file is transmitted to an external network server, so that the external network server can play back the script file corresponding to the updating operation executed on the internal network in the external network according to the database execution information written in the specified script file, namely, the corresponding updating operation is executed on the database in the external network system according to the database execution information, and further, the database of the internal network system and the database of the external network system are subjected to data synchronization. Compared with the prior art, the method solves the problems of low efficiency, low accuracy and untimely data synchronization caused by a method for synchronizing the data of the internal network and the external network by manpower in the prior art. The embodiment of the invention automatically completes the synchronization of the data in the internal network system and the external network system by using a machine, replaces the manual data synchronization operation process, further has high data synchronization efficiency and high accuracy, and does not need to perform the data synchronization operation only when the internal network system and the external network system are not used by people or the number of users is less at night, further can shorten the synchronization period, ensures the timeliness of the data synchronization, and timely ensures that the data in the internal network system and the external network system are kept consistent.
In order to describe the above embodiments in more detail, an embodiment of the present invention further provides another method for synchronizing a database between an internal network and an external network, where as shown in fig. 2, the method sends the obtained database execution information to a common message queue to write the database execution information into a specified script file in batch, and when the specified script file is transmitted to the external network, the script file corresponding to the update operation executed in the internal network can be restored in batch, and the following specific steps are provided in the embodiment of the present invention:
201. when it is detected that an application accesses a database, an update operation performed on the database is identified.
The application program refers to a software program used in an intranet network environment, such as an application program used in a court private network.
In this embodiment of the present invention, the database refers to a relational database, and the update operation performed on the database may include: add, modify, delete, etc., which change the data currently stored in the database when an update operation is performed on the database.
In the embodiment of the present invention, the application program is usually developed by using Object Relational Mapping (ORM), and all operations performed on the database pass through an ORM mapping layer, so that all operations performed on the database need to be captured only by intercepting the ORM mapping layer.
For example, taking the MyBatis framework as an example, MyBatis provides an interceptor which allows a user to implement its logic at some time without having to move the inherent logic of MyBatis, so that an interceptor can be added to intercept all update operations without changing the existing framework, so as to extract the update operations performed on the database. This ensures the stability of the existing frame and also achieves our results. At present, many mainstream ORM frameworks provide functions of an interceptor for users to expand, for example, an object relationship mapping framework (Hibernate framework) of an open source code provides an org.
For the embodiment of the invention, when the application program is detected to access the database, the operations executed on the database are intercepted on the ORM mapping layer, and the updating operations executed on the database are searched in the intercepted operations executed on the database.
202. And acquiring basic information of the database which is subjected to the updating operation and corresponds to the updating operation, a script file for executing the updating operation and the time for executing the updating operation.
The basic information of the database may include: database connection url, database name, executive user, etc.
In the embodiment of the present invention, when an update operation is identified, which database the object of the update operation is based on the basic information of the database on which the update operation is performed may be known, the relevant content of the update operation may be known according to the script file for performing the update operation, and the time at which the update operation is performed may be known according to the time for performing the update operation.
203. And packaging the basic information of the database on which the updating operation is executed, the script file for executing the updating operation and the time for executing the updating operation as the database execution information corresponding to one updating operation.
The database execution information refers to execution information for executing one updating operation on the intranet database.
For the embodiment of the present invention, the basic information of the database on which the update operation is performed, the script file for performing the update operation, and the time for performing the update operation are encapsulated to obtain the database execution information corresponding to one update operation, so that the execution object (which database is subjected to the update operation), the related content for performing the update operation, and the time for performing the update operation corresponding to the current update operation can be determined according to one database execution information.
204. And sending the encapsulated database execution information to a common message queue.
For the embodiment of the invention, the RabbitMQ can be used as a public message queue, the database execution information corresponding to all updating operations executed on the database is sent to the RabbitMQ cluster, the message queue ensures the sequence of the messages, and simultaneously, the omission or repeated addition of the database execution information is avoided, the public message queue is used for temporarily storing the data and waiting for the consumption of a data export program. An example of code is as follows:
specifically, the step of sending the encapsulated database execution information to the common message queue may include the following steps:
firstly, sequencing the execution information of the databases according to the sequence of the time for executing the updating operation; secondly, sequentially writing the database execution information into a common message queue according to the sorting; thirdly, judging whether the number of the database execution information written in the public message queue reaches a preset threshold value; and fourthly, if so, stopping writing the database execution information into the common message queue.
205. The database execution information is read from the common message queue using a data derivation program.
And the database execution information messages in the common message queue are read out by the data export program at regular intervals and are written into the specified script file. It should be noted that, after it is detected that the database execution information is successfully written into the designated script file, the database execution information that is successfully written is deleted from the common message queue, so that the number of the database execution information stored in the common message queue is smaller than a preset threshold, and further, the newly identified database execution information of the update operation can be added to the common message queue.
It should be noted that the number of the data exporting programs may be one or more, and when the number of the data exporting programs is one, the database execution information written in the common message queue is consumed by the data exporting programs according to a preset time period. Or when the number of the data export programs is multiple, the database execution information written in the public message queue is consumed in parallel by using the multiple data export programs, so that the consumption speed of the database execution information in the public message queue can be accelerated, and a storage space is reserved to add the database execution information corresponding to the newly identified update operation in time.
206. And writing the read database execution information into a specified script file.
By the above-described method of writing database execution information to a specified script file by continuously reading database execution information from a common message queue using a data export program, the number of database execution information written into the specified script file can be continuously increased. It should be noted that, in essence, one piece of database execution information corresponds to one update operation executed on the database, so that the greater the number of pieces of database execution information written in by the specified script file, the greater the number of subsequent update operations played back according to the specified script file in the extranet network environment, and further, the batch playback update operation on the extranet according to one specified script file can be realized, thereby improving the efficiency of synchronizing data in the intranet system and the extranet system.
It should be noted that, for the embodiment of the present invention, the database execution information corresponding to each update operation is written into the specified script file through the common message queue and the data export program, and omission or repeated writing of the database execution information is avoided, so that when the script file corresponding to the update operation in the intranet network environment is played back according to the specified script file in the extranet network environment, the omission or repeated playback situation is avoided, and the accuracy of synchronizing the data in the intranet system and the extranet system is further ensured.
207. And under the isolated network environment, transmitting the specified script file to the extranet server so that the extranet server executes updating operation on the extranet database according to one or more database execution information written in the specified script file, and synchronizing the data of the intranet database and the extranet database.
In the embodiment of the invention, the specified script file can be transmitted to the extranet server through the unidirectional isolation optical gate. The optical gate, FGAP for short, is a unidirectional isolation software and hardware system developed on the basis of a security isolation GAP (GAP) and based on light unidirectionality. The unidirectional isolation optical gate consists of three parts: the intranet unit, outer net unit, the one-way transmission unit of beam split, wherein, intranet unit and intranet link to each other, and outer net unit links to each other with the outer net, and the one-way transmission unit of beam split is only and safe data transmission passageway between the intranet and the outer net.
In the embodiment of the invention, a server can be designated to receive the designated script file transmitted by the intranet under the extranet network environment, and the extranet server can know which application program executes which related updating operation on which database under the intranet network environment according to the database execution information written in the designated script file, further determine the corresponding database on the extranet system, and execute the corresponding updating operation on the corresponding database, so as to synchronize the data of the intranet database and the data of the extranet database.
Further, the embodiment of the present invention further provides a flowchart of a method for synchronizing data in an intranet system and an extranet system, as shown in fig. 3, step 201 and step 207 transmit the specified script file to the extranet server, which is not described herein again. In addition, under the environment of the extranet network, the data import program reads the specified script file synchronized from the intranet, according to the database execution information written in the specified script, the basic information of the database which is executed with the updating operation under the environment of the intranet network, the script file which is executed with the updating operation and the time for executing the updating operation are obtained, and then according to the basic information (such as database url, database name and the like) of the database, the script file which is written in the specified script file and corresponds to the updating operation of the plurality of database execution information is played back according to the sequence of the time for executing the updating operation in the database execution information, so that the data synchronization from the intranet to the extranet is completed. Further, similarly, the principle of data synchronization from the intranet to the extranet according to the embodiment of the present invention may also be adopted to synchronize the update operation of the database in the extranet to the intranet, and the specified script file is transmitted from the extranet to the intranet server by using another unidirectional isolation optical gate, thereby completing the data synchronization from the extranet to the intranet.
In order to achieve the above object, according to another aspect of the present invention, an embodiment of the present invention further provides a storage medium, where the storage medium includes a stored program, and when the program runs, a device in which the storage medium is located is controlled to execute the method for synchronizing the database between the internal network and the external network.
In order to achieve the above object, according to another aspect of the present invention, an embodiment of the present invention further provides a processor, where the processor is configured to execute a program, where the program executes the method for synchronizing the databases between the internal network and the external network.
Further, as an implementation of the methods shown in fig. 1, fig. 2, and fig. 3, an embodiment of the present invention provides an apparatus for synchronizing a database between an internal network and an external network. The embodiment of the apparatus corresponds to the embodiment of the method, and for convenience of reading, details in the embodiment of the apparatus are not repeated one by one, but it should be clear that the apparatus in the embodiment can correspondingly implement all the contents in the embodiment of the method. The device is applied to data synchronization of database clusters of an internal network and an external network, and specifically as shown in fig. 4, the device includes:
an identifying unit 41 configured to identify an update operation performed on a database when it is detected that an application accesses the database;
a writing unit 42, configured to write database execution information corresponding to the update operation identified by the identifying unit 41 into a specified script file, where the database execution information is execution information for executing one update operation on a database in an intranet;
a transmission unit 43, configured to transmit the specified script file to an extranet server in an isolated network environment, so that the extranet server performs an update operation on a database of an extranet according to one or more database execution information written in the specified script file, and performs data synchronization on the database of the intranet and the database of the extranet.
Further, as shown in fig. 5, the writing unit 42 includes:
an obtaining module 421, configured to obtain basic information of a database on which an update operation is performed, a script file for performing the update operation, and time for performing the update operation, where the basic information corresponds to the update operation;
a packaging module 422, configured to package, as database execution information corresponding to the one-time update operation, the basic information of the database on which the update operation is executed, the script file for executing the update operation, and the time for executing the update operation, which are acquired by the acquiring module 421;
a sending module 423, configured to send the database execution information encapsulated by the encapsulating module 422 to a common message queue;
a reading module 424, configured to read the database execution information from the common message queue using a data derivation program;
a writing module 425, configured to write the read database execution information into a specified script file.
Further, as shown in fig. 5, the encapsulation module 422 includes:
the sorting submodule 4221 is configured to sort the plurality of database execution information according to the sequence of the time for executing the update operation;
a writing submodule 4222, configured to write the plurality of database execution information into a common message queue in sequence according to the sorting by the sorting submodule 4221;
a determining submodule 4223, configured to determine whether the number of the database execution information written in the common message queue reaches a preset threshold;
a stopping submodule 4224, configured to stop writing the database execution information into the common message queue when the determining submodule 4223 determines that the number of the database execution information written into the common message queue reaches a preset threshold.
Further, as shown in fig. 5, the reading module 424 includes:
a first consuming submodule 4241, configured to consume, when the number of the data export programs is one, the database execution information written in the common message queue by using the data export program according to a preset time period; or
A second consuming submodule 4242, configured to consume, in parallel, the database execution information written in the common message queue by using a plurality of the data derivation programs when the data derivation programs are plural.
Further, as shown in fig. 5, the identifying unit 41 includes:
an interception module 411, configured to intercept, on the ORM mapping layer, an operation performed on the database when it is detected that the application accesses the database;
a searching module 412, configured to search the operations intercepted by the intercepting module 411 for the update operation performed on the database.
Further, as shown in fig. 5, the transmission unit 43 is further configured to transmit the specified script file to an extranet server through a unidirectional isolation optical gate.
In summary, the present invention provides a method and an apparatus for synchronizing a database between an intranet and an extranet, wherein database execution information of update operations executed on the database identified by the intranet is written into a designated script file through processing of a common message queue and a data export program, so that the database execution information is written into the designated script file in batch, and omission or repeated writing is avoided The accuracy is high, and the data synchronization operation is not needed to be executed only when the internal and external network systems are not used by people or the number of users is small at night, so that the synchronization period can be shortened, the timeliness of data synchronization is ensured, and the consistency of data in the internal and external network systems is ensured in time.
The device for synchronizing the database between the internal network and the external network comprises a processor and a memory, wherein the identification unit, the writing unit, the transmission unit and the like are stored in the memory as program units, and the processor executes the program units stored in the memory to realize corresponding functions.
The processor comprises a kernel, and the kernel calls the corresponding program unit from the memory. The kernel can be set to be one or more than one, and the data synchronization process of the internal network system and the external network system is optimized by adjusting the kernel parameters, so that the efficiency and the accuracy of synchronizing the data of the internal network system and the external network system are improved, the timeliness of synchronizing the data is also ensured, and the consistency of the data in the internal network system and the external network system is ensured in time.
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.
An embodiment of the present invention provides a storage medium having a program stored thereon, where the program, when executed by a processor, implements the method for synchronizing databases between intranets and intranets.
The embodiment of the invention provides a processor, which is used for running a program, wherein the method for executing the internal and external internetwork synchronous database is executed when the program runs.
The embodiment of the invention provides equipment, which comprises a processor, a memory and a program which is stored on the memory and can run on the processor, wherein the processor executes the program and realizes the following steps:
a method of synchronizing databases between an intranet and an extranet, the method comprising: when detecting that an application program accesses a database, identifying an updating operation performed on the database; writing database execution information corresponding to the updating operation into a specified script file, wherein the database execution information refers to execution information for executing one updating operation on the intranet database; and transmitting the specified script file to an external network server under an isolated network environment, so that the external network server executes updating operation on a database of an external network according to one or more database execution information written in the specified script file, and performs data synchronization on the database of the internal network and the database of the external network.
Further, the writing of the database execution information corresponding to the update operation into a specified script file includes: acquiring basic information of a database which is subjected to updating operation and corresponds to one updating operation, a script file for executing the updating operation and time for executing the updating operation; packaging the basic information of the database on which the updating operation is executed, the script file for executing the updating operation and the time for executing the updating operation as the database execution information corresponding to the updating operation; sending the encapsulated database execution information to a common message queue; reading the database execution information from the common message queue using a data derivation program; and writing the read database execution information into a specified script file.
Further, the sending the encapsulated database execution information to a common message queue includes: sequencing the execution information of the databases according to the sequence of the time for executing the updating operation; according to the sorting, sequentially writing the database execution information into a common message queue; judging whether the number of the database execution information written in the public message queue reaches a preset threshold value or not; and if so, stopping writing the database execution information into the public message queue.
Further, the reading the database execution information from the common message queue by the data derivation program includes: when the number of the data export programs is one, consuming the database execution information written in the public message queue by using the data export programs according to a preset time period; or, when the data derivation program is plural, the database execution information written in the common message queue is consumed in parallel by using the plural data derivation programs.
Further, the identifying an update operation performed on the database includes: intercepting an operation performed on a database on an ORM mapping layer when it is detected that an application program accesses the database; searching the intercepted operation performed on the database for an updating operation performed on the database.
Further, the transmitting the specified script file to an extranet server includes: and transmitting the specified script file to an extranet server through a unidirectional isolation optical gate.
The device herein may be a server, a PC, a PAD, a mobile phone, etc.
The present application further provides a computer program product adapted to perform program code for initializing the following method steps when executed on a data processing device: when detecting that an application program accesses a database, identifying an updating operation performed on the database; writing database execution information corresponding to the updating operation into a specified script file, wherein the database execution information refers to execution information for executing one updating operation on the intranet database; and transmitting the specified script file to an external network server under an isolated network environment, so that the external network server executes updating operation on a database of an external network according to one or more database execution information written in the specified script file, and performs data synchronization on the database of the internal network and the database of the external network.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In a typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include forms of volatile memory in a computer readable medium, Random Access Memory (RAM) and/or non-volatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). The memory is an example of a computer-readable medium.
Computer-readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), Static Random Access Memory (SRAM), Dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), Read Only Memory (ROM), Electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), Digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device. As defined herein, a computer readable medium does not include a transitory computer readable medium such as a modulated data signal and a carrier wave.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in the process, method, article, or apparatus that comprises the element.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The above are merely examples of the present application and are not intended to limit the present application. Various modifications and changes may occur to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.
Claims (10)
1. A method for synchronizing databases between an intranet and an extranet, the method comprising:
when detecting that an application program accesses a database, identifying an updating operation performed on the database;
writing database execution information corresponding to the updating operation into a specified script file, wherein the database execution information refers to execution information for executing one updating operation on the intranet database;
and transmitting the specified script file to an external network server under an isolated network environment, so that the external network server executes updating operation on a database of an external network according to one or more database execution information written in the specified script file, and performs data synchronization on the database of the internal network and the database of the external network.
2. The method according to claim 1, wherein writing the database execution information corresponding to the update operation into a specified script file comprises:
acquiring basic information of a database which is subjected to updating operation and corresponds to one updating operation, a script file for executing the updating operation and time for executing the updating operation;
packaging the basic information of the database on which the updating operation is executed, the script file for executing the updating operation and the time for executing the updating operation as the database execution information corresponding to the updating operation;
sending the encapsulated database execution information to a common message queue;
reading the database execution information from the common message queue using a data derivation program;
and writing the read database execution information into a specified script file.
3. The method of claim 2, wherein sending the encapsulated database execution information to a common message queue comprises:
sequencing the execution information of the databases according to the sequence of the time for executing the updating operation;
according to the sorting, sequentially writing the database execution information into a common message queue;
judging whether the number of the database execution information written in the public message queue reaches a preset threshold value or not;
and if so, stopping writing the database execution information into the public message queue.
4. The method of claim 2, wherein reading the database execution information from a common message queue using a data derivation program comprises:
when the number of the data export programs is one, consuming the database execution information written in the public message queue by using the data export programs according to a preset time period; or
When the data derivation program is plural, the database execution information written in the common message queue is consumed in parallel using a plurality of the data derivation programs.
5. The method of any of claims 1 to 4, wherein the identifying an update operation performed on the database comprises:
intercepting an operation performed on a database on an ORM mapping layer when it is detected that an application program accesses the database;
searching the intercepted operation performed on the database for an updating operation performed on the database.
6. The method according to any one of claims 1 to 4, wherein the transmitting the specified script file to an extranet server comprises:
and transmitting the specified script file to an extranet server through a unidirectional isolation optical gate.
7. An apparatus for synchronizing databases between an intranet and an extranet, the apparatus comprising:
the device comprises an identification unit, a storage unit and a control unit, wherein the identification unit is used for identifying the updating operation executed on the database when detecting that the application program accesses the database;
a writing unit, configured to write database execution information corresponding to the update operation identified by the identification unit into a specified script file, where the database execution information is execution information for executing an update operation on a database in an intranet;
and the transmission unit is used for transmitting the specified script file to an external network server under an isolated network environment so that the external network server can execute updating operation on the database of the external network according to one or more database execution information written in the specified script file and perform data synchronization on the database of the internal network and the database of the external network.
8. The apparatus of claim 7, wherein the write unit comprises:
the acquisition module is used for acquiring the basic information of the database which is subjected to the updating operation and corresponds to the updating operation, the script file for executing the updating operation and the time for executing the updating operation;
a packaging module, configured to package, as database execution information corresponding to the one-time update operation, the basic information of the database on which the update operation is executed, the script file for executing the update operation, and the time for executing the update operation, which are acquired by the acquisition module;
the sending module is used for sending the database execution information packaged by the packaging module to a public message queue;
a reading module for reading the database execution information from a common message queue using a data derivation program;
and the writing module is used for writing the read database execution information into a specified script file.
9. A storage medium comprising a stored program, wherein the apparatus on which the storage medium is located is controlled to perform the method of synchronizing the databases between the internal and external networks according to any one of claims 1 to 6 when the program is executed.
10. A processor, characterized in that the processor is configured to run a program, wherein the program when running performs the method of inter-Intranet synchronized database according to any one of claims 1-6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811113963.7A CN110941621A (en) | 2018-09-25 | 2018-09-25 | Method and device for synchronizing databases between internal network and external network |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811113963.7A CN110941621A (en) | 2018-09-25 | 2018-09-25 | Method and device for synchronizing databases between internal network and external network |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110941621A true CN110941621A (en) | 2020-03-31 |
Family
ID=69904864
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811113963.7A Pending CN110941621A (en) | 2018-09-25 | 2018-09-25 | Method and device for synchronizing databases between internal network and external network |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110941621A (en) |
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111541718A (en) * | 2020-05-15 | 2020-08-14 | 国家电网有限公司 | Internal and external network interaction method and system of power terminal and data transmission method |
| CN111641650A (en) * | 2020-05-29 | 2020-09-08 | 中京天裕科技（北京）有限公司 | Industrial data unidirectional import system and method |
| CN111711615A (en) * | 2020-05-29 | 2020-09-25 | 成都金隼智安科技有限公司 | Knowledge base information synchronization system and method for edge security computing node |
| CN111858749A (en) * | 2020-06-15 | 2020-10-30 | 武汉旷视金智科技有限公司 | Bottom library synchronization method, device and electronic system |
| CN111865969A (en) * | 2020-07-17 | 2020-10-30 | 江苏润易联信息技术有限公司 | Secure transmission method and system suitable for financial information |
| CN111885209A (en) * | 2020-08-07 | 2020-11-03 | 北京明略软件系统有限公司 | Message queue synchronization method, device and system based on one-way optical gate |
| CN112583918A (en) * | 2020-12-11 | 2021-03-30 | 广州润普网络科技有限公司 | Intranet and extranet document interaction system, method and storage medium |
| CN112632159A (en) * | 2020-12-01 | 2021-04-09 | 腾讯科技（深圳）有限公司 | Database access control method and device, electronic equipment and storage medium |
| CN113239005A (en) * | 2021-06-02 | 2021-08-10 | 上海许继电气有限公司 | I, IV area data synchronization method and device for power monitoring system |
| CN113342845A (en) * | 2021-06-23 | 2021-09-03 | 乐刷科技有限公司 | Data synchronization method, computer device and readable storage medium |
| CN113965387A (en) * | 2021-10-25 | 2022-01-21 | 杭州安恒信息技术股份有限公司 | Data synchronization method, system, readable storage medium and computer equipment |
| CN114124431A (en) * | 2021-09-13 | 2022-03-01 | 许昌许继软件技术有限公司 | Real-time automatic file synchronization method and system for isolation device |
| CN114389853A (en) * | 2021-12-21 | 2022-04-22 | 航天信息股份有限公司 | Data processing method and device |
| CN114911872A (en) * | 2022-07-18 | 2022-08-16 | 北京智芯微电子科技有限公司 | Intranet and extranet data synchronization method, device and system, extranet server and storage medium |
| CN116645067A (en) * | 2023-07-19 | 2023-08-25 | 江西微博科技有限公司 | Service integration model and service integration method based on transaction knowledge |
| CN117407338A (en) * | 2023-12-15 | 2024-01-16 | 北京壁仞科技开发有限公司 | System, method and computing device for data transmission synchronization |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101635704A (en) * | 2008-07-24 | 2010-01-27 | 北京盖特佳信息安全技术股份有限公司 | Application security exchange platform based on trusted technology |
| CN104699760A (en) * | 2015-02-11 | 2015-06-10 | 安徽继远电网技术有限责任公司 | Data synchronization method used for heterogeneous system and based on safety isolation |
| US20150293764A1 (en) * | 2014-04-10 | 2015-10-15 | Omprakash VISVANATHAN | Method and system to compose and execute business rules |
| CN106250543A (en) * | 2016-08-10 | 2016-12-21 | 深圳市彬讯科技有限公司 | A kind of automation data inquiry synchronous storage method |
| CN106294741A (en) * | 2016-08-10 | 2017-01-04 | 深圳市彬讯科技有限公司 | A kind of automation data inquiry synchronizes storage system |
| CN106294075A (en) * | 2016-08-17 | 2017-01-04 | 浪潮软件股份有限公司 | A kind of SQL is monitored method, Apparatus and system |
| CN107395768A (en) * | 2017-09-05 | 2017-11-24 | 上海焕兴网络科技有限公司 | Two-shipper adaptive load balancing method for file security transmission |
| CN108306847A (en) * | 2017-01-13 | 2018-07-20 | 北京国双科技有限公司 | Communication system and method |
-
2018
- 2018-09-25 CN CN201811113963.7A patent/CN110941621A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101635704A (en) * | 2008-07-24 | 2010-01-27 | 北京盖特佳信息安全技术股份有限公司 | Application security exchange platform based on trusted technology |
| US20150293764A1 (en) * | 2014-04-10 | 2015-10-15 | Omprakash VISVANATHAN | Method and system to compose and execute business rules |
| CN104699760A (en) * | 2015-02-11 | 2015-06-10 | 安徽继远电网技术有限责任公司 | Data synchronization method used for heterogeneous system and based on safety isolation |
| CN106250543A (en) * | 2016-08-10 | 2016-12-21 | 深圳市彬讯科技有限公司 | A kind of automation data inquiry synchronous storage method |
| CN106294741A (en) * | 2016-08-10 | 2017-01-04 | 深圳市彬讯科技有限公司 | A kind of automation data inquiry synchronizes storage system |
| CN106294075A (en) * | 2016-08-17 | 2017-01-04 | 浪潮软件股份有限公司 | A kind of SQL is monitored method, Apparatus and system |
| CN108306847A (en) * | 2017-01-13 | 2018-07-20 | 北京国双科技有限公司 | Communication system and method |
| CN107395768A (en) * | 2017-09-05 | 2017-11-24 | 上海焕兴网络科技有限公司 | Two-shipper adaptive load balancing method for file security transmission |
Cited By (25)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111541718B (en) * | 2020-05-15 | 2022-02-08 | 国家电网有限公司 | Internal and external network interaction method and system of power terminal and data transmission method |
| CN111541718A (en) * | 2020-05-15 | 2020-08-14 | 国家电网有限公司 | Internal and external network interaction method and system of power terminal and data transmission method |
| CN111641650A (en) * | 2020-05-29 | 2020-09-08 | 中京天裕科技（北京）有限公司 | Industrial data unidirectional import system and method |
| CN111711615A (en) * | 2020-05-29 | 2020-09-25 | 成都金隼智安科技有限公司 | Knowledge base information synchronization system and method for edge security computing node |
| CN111711615B (en) * | 2020-05-29 | 2022-07-26 | 成都金隼智安科技有限公司 | Knowledge base information synchronization system and method for edge security computing node |
| CN111858749A (en) * | 2020-06-15 | 2020-10-30 | 武汉旷视金智科技有限公司 | Bottom library synchronization method, device and electronic system |
| CN111858749B (en) * | 2020-06-15 | 2024-09-17 | 武汉旷视金智科技有限公司 | Bottom library synchronization method, device and electronic system |
| CN111865969A (en) * | 2020-07-17 | 2020-10-30 | 江苏润易联信息技术有限公司 | Secure transmission method and system suitable for financial information |
| CN111885209A (en) * | 2020-08-07 | 2020-11-03 | 北京明略软件系统有限公司 | Message queue synchronization method, device and system based on one-way optical gate |
| CN111885209B (en) * | 2020-08-07 | 2023-08-29 | 北京明略软件系统有限公司 | Method, device and system for synchronizing message queues based on unidirectional optical gate |
| CN112632159A (en) * | 2020-12-01 | 2021-04-09 | 腾讯科技（深圳）有限公司 | Database access control method and device, electronic equipment and storage medium |
| CN112632159B (en) * | 2020-12-01 | 2021-09-28 | 腾讯科技（深圳）有限公司 | Database access control method and device, electronic equipment and storage medium |
| CN112583918A (en) * | 2020-12-11 | 2021-03-30 | 广州润普网络科技有限公司 | Intranet and extranet document interaction system, method and storage medium |
| CN112583918B (en) * | 2020-12-11 | 2022-11-18 | 广州润普网络科技有限公司 | Intranet and extranet document interaction system, method and storage medium |
| CN113239005A (en) * | 2021-06-02 | 2021-08-10 | 上海许继电气有限公司 | I, IV area data synchronization method and device for power monitoring system |
| CN113342845A (en) * | 2021-06-23 | 2021-09-03 | 乐刷科技有限公司 | Data synchronization method, computer device and readable storage medium |
| CN113342845B (en) * | 2021-06-23 | 2024-02-20 | 乐刷科技有限公司 | Data synchronization method, computer device and readable storage medium |
| CN114124431A (en) * | 2021-09-13 | 2022-03-01 | 许昌许继软件技术有限公司 | Real-time automatic file synchronization method and system for isolation device |
| CN113965387A (en) * | 2021-10-25 | 2022-01-21 | 杭州安恒信息技术股份有限公司 | Data synchronization method, system, readable storage medium and computer equipment |
| CN114389853A (en) * | 2021-12-21 | 2022-04-22 | 航天信息股份有限公司 | Data processing method and device |
| CN114911872A (en) * | 2022-07-18 | 2022-08-16 | 北京智芯微电子科技有限公司 | Intranet and extranet data synchronization method, device and system, extranet server and storage medium |
| CN116645067A (en) * | 2023-07-19 | 2023-08-25 | 江西微博科技有限公司 | Service integration model and service integration method based on transaction knowledge |
| CN116645067B (en) * | 2023-07-19 | 2023-10-10 | 江西微博科技有限公司 | Service integration model and service integration method based on transaction knowledge |
| CN117407338A (en) * | 2023-12-15 | 2024-01-16 | 北京壁仞科技开发有限公司 | System, method and computing device for data transmission synchronization |
| CN117407338B (en) * | 2023-12-15 | 2024-03-19 | 北京壁仞科技开发有限公司 | System, method and computing device for data transmission synchronization |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110941621A (en) | Method and device for synchronizing databases between internal network and external network | |
| CN109460349B (en) | Test case generation method and device based on log | |
| CN109997126B (en) | Event driven extraction, transformation, and loading (ETL) processing | |
| US10042931B2 (en) | Data query method and apparatus | |
| US11704490B2 (en) | Log sourcetype inference model training for a data intake and query system | |
| CN106980669B (en) | Data storage and acquisition method and device | |
| RU2705429C1 (en) | Method and device for distributed processing of stream data | |
| US8938430B2 (en) | Intelligent data archiving | |
| US20200218699A1 (en) | Systems and computer implemented methods for semantic data compression | |
| WO2008151016A2 (en) | Transporting table valued parameter over tabular data stream protocol | |
| CN106970920A (en) | A kind of method and apparatus for database data migration | |
| CN104036029A (en) | Big data consistency comparison method and system | |
| US20210232603A1 (en) | Capturing data lake changes | |
| US11474715B2 (en) | Storage system configuration change tracking for root cause/troubleshooting | |
| CN106021566A (en) | Method, device and system for improving concurrent processing capacity of single database | |
| CN112597348A (en) | Method and device for optimizing big data storage | |
| WO2022252322A1 (en) | Method for synchronizing memory database and relational database of feature tag-based power grid monitoring system | |
| US11841827B2 (en) | Facilitating generation of data model summaries | |
| CN116933247A (en) | Industrial big data sandbox system and industrial big data system | |
| CN109308310B (en) | Subsystem data interconnection processing method for asset management platform | |
| CN111078905A (en) | Data processing method, device, medium and equipment | |
| CN116028469A (en) | Data security link tracking method and device | |
| US9626371B2 (en) | Attribute selectable file operation | |
| KR20160145250A (en) | Shuffle Embedded Distributed Storage System Supporting Virtual Merge and Method Thereof | |
| CN110851305B (en) | Backup storage method and device for science and technology project files |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200331 |
|
| RJ01 | Rejection of invention patent application after publication |