CN1937504A - Synchronization system and method - Google Patents

Abstract

A synchronous system and method, mainly used for carrying on the data transmission to the database of electronic device and server end database, the synchronous system includes: the setting module is used for setting the transmission direction; the mapping module is used for establishing an intermediate file and mapping the data of the electronic equipment database; the comparison module is used for comparing the intermediate file with the server data and determining the data to be transmitted; the updating module updates the intermediate file or the server database according to the comparison result and the transmission direction set by the setting module; the import module imports the intermediate file data into the electronic equipment database; the synchronization system and the synchronization method can transmit data to the electronic equipment database and the server database, and the data transmission processing is carried out through an intermediate file, so that the electronic equipment database is not needed to be used in the transmission process, and the electronic equipment is not needed to be started, thereby achieving the purpose of fast and efficient data transmission synchronization.

Description

Synchronization system and method

technical field

The invention relates to a data transmission synchronization technology, in particular to a synchronization system and method for data transmission between an electronic device database and server database data to achieve synchronous processing.

Background technique

Since the development of electronic products, digital and portable electronic products have developed into a major mainstream of current electronic products with many advantages such as powerful functions, simple operation and convenient portability, so that modern people can enjoy the benefits brought by electronic products in their daily lives. convenient.

Taking a digital multimedia playback device as an example, the data processing capability and storage space are limited. However, in today's modern information society, computers have become one of the most important platforms for the public to contact and process digital data. Especially in recent years, as the price of computers has gradually decreased, computers have almost become standard configurations in families and companies. Computers, with their simple and easy operation methods and low prices, allow digital information to penetrate into all walks of life, even ordinary people People who have received computer operation training can also easily manipulate such electronic devices to achieve the purpose of increasing knowledge. In addition, with the dramatic increase in the computing speed of computers and the development of multimedia processing technology, the application level of computers is no longer limited to document processing, etc., and it can effectively process multimedia data such as sound and images. Furthermore, the storage space of the computer has also greatly developed compared with the past, and can be expanded infinitely by purchasing storage media such as hard disks. Therefore, data exchange between electronic devices and computers is the current general trend and development hotspot.

Today's electronic devices store data in the form of a database, and the data processing after the electronic device is connected to the computer is only a simple data transmission process, and there is no synchronous processing of data transmission in the form of a database.

Therefore, how to solve the synchronization processing (that is, data uploading/downloading processing) of electronic device data stored in a database is a problem that needs to be solved at present.

Contents of the invention

In order to overcome the above-mentioned shortcomings of the prior art, the main purpose of the present invention is to provide a synchronization system and method, which can perform data transmission between the electronic device database and the server database data, and realize the purpose of fast and efficient data synchronization transmission.

Another object of the present invention is to provide a synchronization system and method for synchronous transmission of data between the electronic device database and the server database by using a pair of electronic device databases as image intermediate files.

To achieve the above and other objectives, the present invention provides a synchronization system and method. The synchronization system of the present invention is used for data transmission between the electronic equipment database and the server database data. The synchronization system includes: a setting module, which is used to set the transmission direction so that the electronic equipment database data is transmitted to the server database or the server The database is transmitted to the electronic device; the image module is used to image the data of the electronic device database and generate an intermediate file for storing image data; the comparison module is used to compare the intermediate file generated by the image module with the server Compare the data to determine the data that needs to be transmitted; the update module updates the intermediate file or the server database based on the comparison result of the comparison module and the transmission direction set by the setting module; and the import module, in the After updating the intermediate file, the update module imports the intermediate file data into the electronic device database.

The synchronization method of the present invention is used for data transmission between the electronic equipment database and the server database, and the synchronization method includes the following steps: (1) setting the transmission direction to transmit the electronic equipment database or the server database; (2) establish an intermediate file to image the electronic device database data; (3) compare the intermediate file with the server database data to determine the data to be transmitted; (4) judge the transmission direction set by the step (1), if If the transmission direction is to transmit the electronic device database, then skip to step (6), otherwise go to step (5); (5) transmit the server database according to the comparison result of the step (3), and end the synchronization The processing steps of the method; (6) update the intermediate file according to the comparison result of step (3); and (7) import the content of the intermediate file into the electronic device database to complete the update process of the electronic device database .

In summary, compared with the existing data transmission synchronization technology, the synchronization system and method of the present invention can perform data transmission between the electronic device database and the server database, and the data transmission process is performed through an intermediate file. There is no need to rely on the electronic device database, and the electronic device does not need to be turned on, so that the purpose of fast and efficient data transmission synchronization is achieved.

Description of drawings

FIG. 1 is a schematic block diagram of the basic framework of the synchronization system of the present invention.

2(A) to 2(C) are illustrations of the first image relationship table and the second image relationship table in the synchronization system of the present invention.

Fig. 3 is a flow chart of the operation of the synchronization method of the present invention.

Detailed ways

Example

As shown in Figure 1, it is a schematic block diagram of the basic structure of the synchronous system of the present invention. It should be noted that the synchronous system also includes other components. related components.

In this embodiment, the synchronization system 1 of the present invention is used for data transmission between the electronic device database 11 and the server database 12, and the synchronization system 1 includes: a setting module 13, an image module 14, a comparison module 15, and an update module 16 As well as the import module 17, the synchronization system 1 can be installed in the electronic device or server.

The electronic device database 11 is placed in the electronic device for storing data of the electronic device, such as audio data, video data (including picture data) and audio-video mixed data. The electronic device is, for example, a multimedia playback device (not shown here).

The server database 12 is placed on the server (not shown here) for storing data, such as audio data, video data (including picture data) and audio-video mixed data, the server is for example Personal computers, notebook computers, servers and workstations, one server can transmit data to multiple electronic devices. In addition, the server also provides an interface that can be electrically connected to the electronic device. It should be noted that the connection method between the electronic device and the server is an existing technology, and will not be described in detail here for simplification.

The setting module 13 is used to set the data transmission direction, the data transmission direction is one of the data transmission direction of the electronic equipment database 11 to the server database 12 or the data transmission of the server database 12 to the electronic equipment database 11 . In this embodiment, the setting module 13 is also used to set data transmission types and transmission processing rules, wherein the data transmission types include audio data, video data (including picture data) or audio-video mixed data; the transmission processing rules Yes, if there is data with the same name during the transmission process, the processing method includes skipping the data with the same name (default transmission rule), overwriting the data with the same name on the server side by the data on the electronic device side, or overwriting the data on the electronic device side by the data on the server side Data with the same name at the end, where the processing rule of skipping the data with the same name means that the data will not be processed.

The image module 14 is used to image the data of the electronic device database 11 by means of the transmission option set by the setting module 13, and generate an intermediate file (not shown) for storing image data, the content of the intermediate file It is exactly the same as the electronic device database 11, which is equivalent to a photo of the electronic device database, and its data format can be read and written by the electronic device and the server. Because common electronic devices will automatically turn off their power when they are electrically connected to the server for data transmission, this will cause the original database 11 to be unable to be called, and useful information cannot be correctly obtained from the database 11. In the data After the transmission is completed, the updated data cannot be written into the electronic device database 11 . Therefore, the present invention uses an intermediate file to map the content of the electronic device database 11 before the electronic device is powered off for synchronous data transmission, and saves it in the electronic device for subsequent data synchronous transmission operations. During the data synchronization transmission process, the electronic device is electrically connected to the server, and the intermediate file is read and written synchronously by the power of the server; after the read and write synchronization is completed, the electronic device is disconnected from the server After turning on the power of the electronic device, the content of the intermediate file can be imported into the database 11 of the electronic device to complete data transmission synchronization.

The comparison module 15 is used to compare the content of the intermediate file generated by the image module 14 with the server data, and determine the data that needs to be transmitted synchronously. First judge the data type that this setting module 13 is set during contrast, if this data type is audio data, then only compare audio data, if data type is video data (including picture data), then only compare video data, if data type is For mixed audio and video data, only the mixed audio and video data will be compared, and all data will be compared when the data synchronous transmission type is set to the default setting.

The update module 16 is used to update the intermediate file or the server database 12 by using the comparison result of the comparison module 15 and the data transmission direction set by the setting module 13 . If the data transmission direction that this setting module 13 is provided with is that this electronic equipment database 11 data is sent to this server database 12 (being data upload), then this server database 12 is updated by this intermediate file, can finish synchronous update; Otherwise, update the intermediate file through the server database 12 (that is, download data). In synchronous updating, if there is data with the same name, the setting module 13 is used to set transmission processing rules to process the data with the same name. The processing rules include skipping the data with the same name, overwriting the data with the same name on the server side by the data on the electronic device side, or overwriting the data with the same name on the data side on the electronic device side by the data on the server side, where skipping the data with the same name means that it will not be processed renew.

The import module 17 is used to import the intermediate file data into the electronic device, wherein if the update module 16 updates the intermediate file, the import module 17 will update the intermediate file after the update module 16 completes the update. When the electronic device is restarted, the intermediate file data is imported into the electronic device database 11 to complete the synchronous update.

Please refer to FIG. 2(A) to FIG. 2(C). In this embodiment, the electronic device also has a first image relationship table for recording data sent to the server. The first image relationship table is used to record information such as data identification code, data name, and data modification time. In this embodiment, the electronic equipment identification code (machineid) of the electronic device with the first image relationship table is 1001, wherein the The electronic equipment identification code is provided by the electronic equipment itself, and then as shown in Figure 2(A), taking the first column 110 as an example, the data identification code is 7, the corresponding data modification time is 100001, and the data name is \my location\ 1.mp3; then, as shown in Figure 2 (B), this table is the first image relationship table stored in another electronic device, wherein the electronic device identification code is 1001, as shown in the first image relationship table The data location of the column 113 is consistent with that of Fig. 2 (A), so it will not be described in detail here; then, the server database 12 also stores a second image relationship table, which is used to record the data sent to the electronic device, the first The second mapping table is used to record the identification code of the server, the identification code of the electronic equipment (machine id), the data name of the transmitted data, the data modification time and the identification code of the data identification, as shown in Figure 2 (C), with the first column 111 For example, the server identification code is 1, the electronic equipment identification code is 1000, the corresponding data name is C:\1.mp3, the data modification time is 100001, and the data identification code is 7. After each data transmission process is completed, the data modification time will be recorded in the first image relationship table and the second image relationship table. If a new data transmission process is performed again, a new one will be selected according to whether the modification date matches. Data items are transmitted to achieve data processing synchronization and improve processing efficiency. In addition, in this embodiment, the synchronization system 1 is implemented by operating a script (script) and a command line (command line).

As shown in FIG. 3 , it is an operation flowchart of the synchronization method of the present invention.

At first carry out step S1, setting transmission direction is that data is sent to this electronic equipment database 11 (being the synchronous processing of data download) or data is sent to this server database 12 (being the synchronous processing of data upload); In this embodiment In this step S1, the transmission type is also set to be audio data, video data or audio-video mixed data, and the transmission processing rule is set to be data with the same name during the transmission process, and the processing method includes skipping the data with the same name, by The data on the electronic device side overwrites the data with the same name on the server side or the data on the server side overwrites the data on the electronic device side with the same name, and then proceed to step S2.

In the step S2, the intermediate file is created, and the data of the electronic device database 11 is imaged. After mapping, the content of the intermediate file is exactly the same as the corresponding data of the electronic device database 11, and then proceeds to step S3.

In the step S3, the intermediate file is compared with the data content of the server database 12, and the data to be transmitted is determined for subsequent data transmission processing (ie, synchronous processing of data upload or download), and then proceeds to step S4.

In the step S4, judge the data transmission direction set in the step S2, if the data transmission direction is to transmit the data to the server database 12, then go directly to the step S5; otherwise, skip to the step S6.

In the step S5, based on the comparison result in the step S3, uploading data to the server database 12 is performed through the intermediate file, and the process steps are ended.

In the step S6, the intermediate file is updated through the server database 12 according to the comparison result of the step S3.

In this step S7, after restarting the electronic device, the electronic device database 11 is updated through the intermediate file, and the process steps are completed.

In this embodiment, the synchronization method can be performed by means of script (script) and command line (commandline).

In a word, the synchronization system and method of the present invention can perform data synchronization transmission processing on the data of the electronic equipment database 11 and the server database 12, and the synchronization transmission processing is performed through an intermediate file, and the electronic equipment database does not need to be used in the synchronization process, and The electronic device does not need to be turned on, so as to achieve the purpose of fast and efficient synchronous data transmission.

Claims (18)

1. A synchronous system, for carrying out data transmission to electronic equipment database and server database, it is characterized in that, this synchronous system comprises: The setting module is used to set the transmission direction as the electronic device database data is transmitted to the server database or the server database is transmitted to the electronic device; An imaging module, configured to image the data in the electronic device database, and generate an intermediate file for storing the image data; The comparison module is used to compare the intermediate file generated by the image module with the server data, and determine the data to be transmitted; The update module updates the intermediate file or the server database based on the comparison result of the comparison module and the transmission direction set by the setting module; and An import module, after the update module updates the intermediate file, imports the intermediate file data into the electronic device database. 2. The synchronization system according to claim 1, wherein the setting module is further configured to set the type of the transmission data as one of audio data, video data or audio-video mixed data combination group. 3. The synchronization system according to claim 1, wherein when the comparison module compares the data of the electronic device end and the server end with the same name, the setting module also provides transmission processing rules for the user to set, the The transmission processing rule is one of skipping the data with the same name, overwriting the data with the same name at the server side by the data at the electronic device side, or overwriting the data with the same name at the data side at the electronic device side by the data at the server side. 4. The synchronization system according to claim 1, wherein the electronic device is a multimedia playback device. 5. The synchronization system according to claim 1, wherein the electronic device database further stores a first image relationship table for recording data sent to the server. 6 . The synchronization system according to claim 5 , wherein the first mapping relationship table is used to record one of a data identification code, a modification time, and a transmission data information composition group in the electronic device. 7. The synchronization system according to claim 1, wherein the server database further stores a second mapping table for recording data sent to the electronic device. 8. The synchronization system according to claim 7, wherein the second mapping table is used to record the identification code of the server, the identification code of the electronic device, the transmitted data information, the data modification time or the identification of the data in the electronic device code to form one of the groups. 9. The synchronization system according to claim 1, wherein the server database can transmit data to a plurality of electronic device databases. 10. A synchronization method for data transmission between an electronic device database and a server database, characterized in that the synchronization method comprises the following steps: (1) Setting the transmission direction is to transmit the electronic device database or the server database; (2) Establish an intermediate file to image the electronic equipment database data; (3) comparing the intermediate file with the server database data to determine the data to be transmitted; (4) Judging the transmission direction set by the step (1), if the transmission direction is to transmit the electronic equipment database, then skip to step (6), otherwise proceed to step (5); (5) According to the comparison result of the step (3), the server database is transmitted, and the processing steps of the synchronization method are terminated; (6) Update the intermediate file based on the comparison result of the step (3); and (7) Import the content of the intermediate file into the electronic device database. 11. The synchronization method according to claim 10, characterized in that, the step (1) also includes setting the type of data transmission, and the data type includes audio data, video data or audio-video mixed data forming a group . 12. The synchronization method according to claim 10, wherein the step (1) also includes setting transmission processing rules, and when the comparison result of the step (3) is that the data of the electronic device end and the service end have the same name, then A transmission processing rule is provided, and the transmission processing rule is one of skipping the data with the same name, overwriting the data with the same name on the server side by the data on the electronic device side, or overwriting the data with the same name on the data side on the electronic device side by the data on the server side. 13. The synchronization method according to claim 10, wherein the electronic device is a multimedia playback device. 14. The synchronization method according to claim 10, wherein the electronic device database further stores a first mapping relational table for recording data sent to the server. 15. The synchronization method according to claim 14, wherein the first mapping relationship table is used to record one of a data identification code, a modification time, or a data information composition group in the electronic device. 16. The synchronization method according to claim 10, wherein the server database further stores a second mapping relationship table for recording data transmitted to the electronic device. 17. The synchronization method according to claim 16, wherein the second mapping table is used to record the identification code of the server, the identification code of the electronic device, the transmitted data information, the modification time of the data or the identification of the data in the electronic device One of the groups of codes. 18. The synchronization method according to claim 10, wherein the server database can transmit data to a plurality of electronic device databases.

Images