synchronization method and device based on video networking monitoring data
阅读说明：本技术 一种基于视联网监控数据的同步方法及装置 (synchronization method and device based on video networking monitoring data ) 是由 曹淑云 王睿智 亓娜 王艳辉 于 2018-07-20 设计创作，主要内容包括：本发明实施例提供一种基于视联网监控数据的同步方法及装置,所述方法包括：接收视联网应用运维平台上的web客户端发送的同步请求其中,所述同步请求包括数据库的ip地址、数据库名、表名以及最新更改时间；基于视联网协议根据所述同步请求确定要同步的视联网平台的数据库中的监控数据；将所述监控数据备份到所述视联网应用运维平台的实体类中；通过映射表将所述实体类中的监控数据同步到视联网应用运维平台的数据库中。本发明实施例实现了将不同平台的不同数据通过视联网协议同步到一个数据库中进行管理,不但提高了数据传输的速度,缩短了传输时长,还提高了数据传输的效率以及用户的满意度。(The embodiment of the invention provides synchronization methods and devices based on video networking monitoring data, wherein the method comprises the steps of receiving a synchronization request sent by a web client on a video networking application operation and maintenance platform, determining monitoring data in a database of the video networking platform to be synchronized according to the synchronization request based on a video networking protocol, backing up the monitoring data into an entity class of the video networking application operation and maintenance platform, and synchronizing the monitoring data in the entity class into the database of the video networking application operation and maintenance platform through a mapping table.)
1, synchronization method based on video network monitoring data, which comprises:
receiving a synchronization request sent by a web client on an operation and maintenance platform of an application of the video networking, wherein the synchronization request comprises an ip address of a database, a database name, a table name and latest change time;
determining monitoring data in a database of the video networking platform to be synchronized according to the synchronization request based on a video networking protocol;
backing up the monitoring data to an entity class of the video networking application operation and maintenance platform;
and synchronizing the monitoring data in the entity class to a database of the operation and maintenance platform of the video network application through a mapping table.
2. The method of claim 1, further comprising:
mapping tables are established on the operation and maintenance platform of the video network application in advance, and the mapping tables are used for converting different fields in the database of each platform of the video network into fields in the database of the operation and maintenance platform of the video network application.
3. The method of claim 1 or 2, wherein determining, based on the video networking protocol, that the monitoring data in the database of the video networking platform is to be synchronized according to the synchronization request comprises:
inquiring a database of a corresponding video networking platform through mybatis according to the synchronization request based on a video networking protocol;
querying monitoring data in a monitoring table of the database through a Structured Query Language (SQL) statement;
and determining the monitoring data to be synchronized according to the monitoring data in the monitoring table.
4. The method according to claim 1 or 2, wherein the backing up the monitoring data into the entity class of the operation and maintenance platform of the video networking application comprises:
and backing up the monitoring data to an entity class of the video networking application operation and maintenance platform through an API (application programming interface).
5. The method according to claim 1 or 2, wherein the synchronizing the monitoring data in the entity class to the database of the operation and maintenance platform of the video networking application through the mapping table comprises:
according to the mapping table, mapping between the monitoring data in the entity class and a database of the video networking application operation and maintenance platform is established through mybatis;
and according to the mapping, monitoring data in the entity class are inserted into a database of the operation and maintenance platform of the video network application in batches, so that synchronization is completed.
6, A synchronizer based on video network monitoring data, which is characterized by comprising:
the receiving module is used for receiving a synchronization request sent by a web client on a video networking application operation and maintenance platform, wherein the synchronization request comprises: ip address, database name, table name and latest change time of the database;
the determining module is used for determining monitoring data in a database of the video networking platform to be synchronized according to the synchronization request based on a video networking protocol;
the backup module is used for backing up the monitoring data to an entity class of the video networking application operation and maintenance platform;
and the synchronization module is used for synchronizing the monitoring data in the entity class to a database of the operation and maintenance platform of the video network application through a mapping table.
7. The apparatus of claim 6, further comprising:
the establishing module is used for establishing mapping tables on the operation and maintenance platform of the video networking application in advance, and the mapping tables are used for converting different fields in databases of various platforms of the video networking application into fields in the databases of the operation and maintenance platform of the video networking application.
8. The apparatus of claim 6 or 7, wherein the determining module comprises:
the query module is used for querying a database of a corresponding video networking platform through mybatis according to the synchronization request based on a video networking protocol;
the second query module is used for querying the monitoring data in the monitoring table of the database through SQL statements;
and the determining submodule is used for determining the monitoring data to be synchronized from the monitoring data in the monitoring table.
9. The apparatus according to claim 6 or 7, wherein the backup module is specifically configured to backup the monitoring data into the physical class of the operation and maintenance platform of the video networking application through an API interface.
10. The apparatus of claim 6 or 7, wherein the synchronization module comprises:
the mapping establishing module is used for establishing mapping between the monitoring data in the entity class and a database of the video networking application operation and maintenance platform through mybatis according to a mapping table;
and the synchronization sub-module is used for inserting monitoring data in the entity class into the database of the operation and maintenance platform of the video network application in batches or in times according to the mapping established by the mapping establishing module to complete synchronization.
Technical Field
The invention relates to the technical field of video networking, in particular to synchronization methods and devices based on video networking monitoring data.
Background
The internet of view is real-time networks, can realize the real-time transmission of the high-definition video of the whole network that the internet can not realize at present, push a plurality of internet applications to high-definition video, high-definition face-to-face, finally realize no distance in the world, and realize that the distance between people in the world is only screens.
However, in the prior art, data of each platform of the video network is synchronized through the internet, that is, data in a database of the video network platform is positioned and synchronized through an ip address of the database, and data synchronization of a cross server needs to be performed by querying the data in the video network platform first and then inserting the data into a local database to achieve synchronization.
Based on this, how to implement synchronous management on data of each platform of the video network is a technical problem to be solved at present.
Disclosure of Invention
The technical problem to be solved by the embodiment of the invention is to provide synchronization methods based on video network monitoring data, so as to solve the technical problems that in the prior art, because fields in database tables of various platforms of the video network are not unified , the data synchronization time is long, and the user satisfaction is reduced.
Correspondingly, the embodiment of the invention also provides synchronization devices based on the video network monitoring data, which are used for ensuring the realization and application of the method.
In order to solve the problems, the invention is realized by the following technical scheme:
an th aspect provides a method for synchronizing video networking-based monitoring data, comprising:
receiving a synchronization request sent by a web client on an operation and maintenance platform of an application of the video networking, wherein the synchronization request comprises an ip address of a database, a database name, a table name and latest change time;
determining monitoring data in a database of the video networking platform to be synchronized according to the synchronization request based on a video networking protocol;
backing up the monitoring data to an entity class of the video networking application operation and maintenance platform;
and synchronizing the monitoring data in the entity class to a database of the operation and maintenance platform of the video network application through a mapping table.
Optionally, the method further includes:
mapping tables are established on the operation and maintenance platform of the video network application in advance, and the mapping tables are used for converting different fields in the database of each platform of the video network into fields in the database of the operation and maintenance platform of the video network application.
Optionally, the determining, based on the video networking protocol, to synchronize the monitoring data in the database of the video networking platform according to the synchronization request includes:
inquiring a database of a corresponding video networking platform through mybatis according to the synchronization request based on a video networking protocol;
querying monitoring data in a monitoring table of the database through a Structured Query Language (SQL) statement;
and determining the monitoring data to be synchronized according to the monitoring data in the monitoring table.
Optionally, the backing up the monitoring data to the entity class of the operation and maintenance platform of the video networking application includes:
and backing up the monitoring data to an entity class of the video networking application operation and maintenance platform through an API (application programming interface).
Optionally, the synchronizing the monitoring data in the entity class to the database of the operation and maintenance platform of the video networking application through the mapping table includes:
according to the mapping table, mapping between the monitoring data in the entity class and a database of the video networking application operation and maintenance platform is established through mybatis;
and according to the mapping, monitoring data in the entity class are inserted into a database of the operation and maintenance platform of the video network application in batches, so that synchronization is completed.
A second aspect provides a synchronization apparatus based on video networking monitoring data, comprising:
the receiving module is used for receiving a synchronization request sent by a web client on a video networking application operation and maintenance platform, wherein the synchronization request comprises: ip address, database name, table name and latest change time of the database;
the determining module is used for determining monitoring data in a database of the video networking platform to be synchronized according to the synchronization request based on a video networking protocol;
the backup module is used for backing up the monitoring data to an entity class of the video networking application operation and maintenance platform;
and the synchronization module is used for synchronizing the monitoring data in the entity class to a database of the operation and maintenance platform of the video network application through a mapping table.
Optionally, the method further includes:
the establishing module is used for establishing mapping tables on the operation and maintenance platform of the video networking application in advance, and the mapping tables are used for converting different fields in databases of various platforms of the video networking application into fields in the databases of the operation and maintenance platform of the video networking application.
Optionally, the determining module includes:
the query module is used for querying a database of a corresponding video networking platform through mybatis according to the synchronization request based on a video networking protocol;
the second query module is used for querying the monitoring data in the monitoring table of the database through SQL statements;
and the determining submodule is used for determining the monitoring data to be synchronized from the monitoring data in the monitoring table.
Optionally, the backup module is specifically configured to backup the monitoring data to the entity class of the operation and maintenance platform of the video networking application through the API interface.
Optionally, the synchronization module includes:
the mapping establishing module is used for establishing mapping between the monitoring data in the entity class and a database of the video networking application operation and maintenance platform through mybatis according to a mapping table;
and the synchronization sub-module is used for inserting monitoring data in the entity class into the database of the operation and maintenance platform of the video network application in batches or in times according to the mapping established by the mapping establishing module to complete synchronization.
Compared with the prior art, the embodiment of the invention has the following advantages:
in the embodiment of the invention, when a synchronization request sent by a web client is received, monitoring data in a database needing to be synchronized is determined based on a video networking protocol, then the monitoring data is backed up to an entity class, and finally the monitoring data is mapped to the database of the video networking application operation and maintenance platform through a mapping table.
It is to be understood that both the foregoing -general description and the following detailed description are exemplary and explanatory only and are not restrictive of the application.
Drawings
Fig. 1 is a flowchart of a synchronization method for kinds of video networking monitoring data according to an embodiment of the present invention;
FIG. 2 is a schematic structural diagram of a synchronization apparatus for kinds of video networking monitoring data provided by an embodiment of the present invention;
FIG. 3 is another schematic diagram of a synchronization apparatus for kinds of video networking monitoring data according to an embodiment of the present invention;
FIG. 4 is another schematic diagram of a synchronization apparatus for kinds of video networking monitoring data according to an embodiment of the present invention;
fig. 5 is a schematic structural diagram of application examples provided by the embodiment of the present invention.
Detailed Description
In order to make the aforementioned objects, features and advantages of the present invention comprehensible, a more detailed description is provided below in conjunction with the accompanying drawings and the detailed description.
The video networking is an important milestone for network development, is real-time networks, can realize high-definition video real-time transmission, and pushes a plurality of internet applications to high-definition video and high-definition face-to-face.
The video networking adopts a real-time high-definition video exchange technology, can integrate required services such as dozens of video, voice, pictures, characters, communication, data and the like on the network platforms, such as high-definition video conferences, video monitoring, intelligent monitoring analysis, emergency command, digital television broadcasting, delayed television, network teaching, live broadcasting, VOD on demand, television mails, Personal Video Recorder (PVR), intranet (self-made) channels, intelligent video broadcasting control, information distribution and the like, into the system platforms, and realizes high-definition quality video broadcasting through a television or a computer.
To better understand the embodiments of the present invention, the following description refers to the internet of view:
referring to the drawings, fig. 1 is a flow chart of a synchronization method of kinds of video network monitoring data according to the invention, the method includes:
step 101: receiving a synchronization request sent by a web client on an operation and maintenance platform of an application of the video networking, wherein the synchronization request comprises an ip address of a database, a database name, a table name and latest change time;
in this step, a user sends a synchronization request to a SpringMVC server (i.e., a server installed with SpringMVC, which is referred to as a SpringMVC server herein) through a web (web) client on the operation and maintenance platform of the video networking application, and it should be noted that the synchronization request in this embodiment may be triggered by the user or triggered by the system at regular time. And the SpringMVC server receives a synchronization request sent by a web client on the operation and maintenance platform of the video networking application. Wherein the synchronization request may include: the ip address, the database name, the table name, and the latest change time of the database may also include other parameters adaptively as needed, which is not limited in this embodiment.
Wherein, SpringMVC is a frame name in java, which belongs to mature frames in java, and in many projects, SpringMVC is used as a project overall frame.
Step 102: determining a database of the video networking platform to be synchronized according to the synchronization request;
in the step, after receiving the synchronization request, the SpringMVC server determines the monitoring data in the database of the video networking platform to be synchronized through the backend interface of the SpringMVC server based on the video networking protocol, wherein determination modes are as follows:
1) the SpringMVC server queries a database of a corresponding video networking platform by utilizing mybatis according to the synchronous request through a rear-end interface based on a video networking protocol;
MyBatis is excellent persistent layer frames supporting common SQL query, storing processes and high-level mapping, namely, myBatis java-based persistent layer frames which encapsulate jdbc inside, and developers only need to pay attention to SQL sentences, but do not need to spend effort on processing complicated processes such as loading drivers, creating connections, creating states and the like.
2) Querying monitoring data in a monitoring table of the database through an SQL statement;
the monitoring data in the monitoring table of the database is queried by the server of SpringMVC through the SQL statement, and the query mode through the SQL statement is well known to those skilled in the art and will not be described herein.
3) And determining the monitoring data to be synchronized according to the monitoring data in the monitoring table.
In this embodiment, mybatis may connect to a corresponding database server according to an ip address of a database carried in the synchronization request, then Query monitoring data in a monitoring table of the required database through a Structured Query Language (SQL) statement, and determine the monitoring data to be synchronized from the monitoring data in the monitoring table.
Step 103: backing up the monitoring data to an entity class of the video networking application operation and maintenance platform;
for example, tables A exist in the database, and the tables A have a plurality of fields, so that the java entity class also establishes entity classes of the tables A and establishes a plurality of attributes, and each attribute corresponds to a field in the table.
In the step, the SpringMVC server controls the database server to backup the monitoring data to an entity class of the video networking application operation and maintenance platform through an API (application programming interface). That is to say, the SpringMVC server initiates a data request to the database server of the video networking platform through the backend interface based on the video networking protocol, and the database server directly sends the monitoring data to the entity class of the video networking application operation and maintenance platform through the API interface when receiving the data request.
Step 104: and synchronizing the monitoring data in the entity class to a database of the operation and maintenance platform of the video network application through a mapping table.
In this step, synchronization methods include:
the SpringMVC server firstly establishes mapping between the monitoring data in the entity class and a database of the video networking application operation and maintenance platform through mybatis according to a mapping table, and then inserts monitoring data in the entity class into the database of the video networking application operation and maintenance platform for times or in batches according to the mapping to complete synchronization.
In the synchronization process, the SpringMVC server can synchronize the monitoring data into the database of the operation and maintenance platform of the video networking application in batches in a thread and message queue mode because the data volume of times of synchronization may exceed million.
In the embodiment of the invention, when a synchronization request sent by a web client is received, monitoring data in a database needing to be synchronized is determined based on a video networking protocol, then the monitoring data is backed up to an entity class, and finally the monitoring data is mapped to the database of the video networking application operation and maintenance platform through a mapping table.
Optionally, in another embodiment, based on the above embodiment, the method may further include building mapping tables on the operation and maintenance platform of the internet of view application in advance, where the mapping tables are used to convert different fields in the database of each platform of the internet of view into fields in the database of the operation and maintenance platform of the internet of view application.
For example, fields 1 in the platform A of the video network are names, and fields tname in the platform B of the video network are different, but the content (meaning of expression) represented by the fields is , while fields in the platform B of the video network application are names, the field tname in the platform B of the video network application is converted into the name by the mapping table, so that the video network application operation platform can recognize and successfully insert the data in the field into the database of the video network application operation platform.
It should be noted that, for simplicity of description, the method embodiments are described as series combinations of actions, but those skilled in the art should understand that the present invention is not limited by the order of the actions described, because some steps may occur in other orders or concurrently according to the embodiments of the present invention.
Referring to fig. 2, a schematic structural diagram of synchronization apparatuses based on video networking monitoring data according to an embodiment of the present invention may specifically include a receiving
a receiving
a determining
the
the
The synchronization module 24 is configured to synchronize the monitoring data in the entity class to a database of the operation and maintenance platform of the video network application through a mapping table;
optionally, in another embodiment, based on the above embodiment, the synchronization module 24 includes a mapping setup module and a synchronization submodule (not shown), wherein,
the mapping establishing module is used for establishing mapping between the monitoring data in the entity class and a database of the video networking application operation and maintenance platform through mybatis according to a mapping table;
and the synchronization sub-module is used for inserting monitoring data in the entity class into the database of the operation and maintenance platform of the video network application in batches or in times according to the mapping established by the mapping establishing module to complete synchronization.
Optionally, in another embodiment, based on the above embodiment, the apparatus may further include a
the establishing
Optionally, in another embodiment, based on the above embodiments, the determining
, a
the
a determining
In the embodiment of the invention, when a synchronization request sent by a web client is received, monitoring data in a database needing to be synchronized is determined based on a video networking protocol, then the monitoring data is backed up to an entity class, and finally the monitoring data is mapped to the database of the video networking application operation and maintenance platform through a mapping table.
Optionally, the apparatus may be integrated in a SpringMVC server, or may be deployed independently, and this embodiment is not limited to this.
For the device embodiment, since it is basically similar to the method embodiment, the description is simple, and for the relevant points, refer to the partial description of the method embodiment.
The embodiments in the present specification are described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments are referred to each other.
Referring to fig. 5, a schematic structural diagram of application examples provided by the embodiment of the present invention includes, as shown in the figure, a
in this embodiment, 1) mapping tables are previously established on the
2) The
3) After the
4) And finally, synchronizing the mapped data to the operation and maintenance platform database of the video networking application by the SpringMVC server.
5) In the process of synchronization, times of sexual synchronization or batch synchronization can be performed, that is, times of sexual synchronization can be adopted for a small amount of data to be synchronized, and if the amount of data to be synchronized may exceed millions, the data needs to be batch synchronized by using threads and message queues.
6) The video network application operation and maintenance platform provides a query interface for facilitating query through the query interface and then displaying in the early web page.
Preferably, the embodiment of the present invention further provides kinds of network devices, which include a processor, a memory, and a computer program stored in the memory and capable of running on the processor, where the computer program, when executed by the processor, implements each process of the above synchronization method embodiment based on video networking monitoring data, and can achieve the same technical effect, and in order to avoid repetition, details are not described here again.
The embodiment of the present invention further provides computer-readable storage media, where a computer program is stored on the computer-readable storage media, and when the computer program is executed by a processor, the computer program implements each process of the synchronization method embodiment based on video network monitoring data, and can achieve the same technical effect, and is not described herein again to avoid repetition.
Furthermore, the present invention may take the form of a computer program product embodied on or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) having computer-usable program code embodied therein.
It is to be understood that each flow and/or block in 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 which can be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing terminal to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing terminal, create means for implementing the functions specified in the flow diagram 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 terminal 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 terminal to cause a series of operational steps to be performed on the computer or other programmable terminal to produce a computer implemented process such that the instructions which execute on the computer or other programmable terminal provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
Having thus described the preferred embodiments of the present invention, additional variations and modifications of these embodiments may occur to those skilled in the art from the basic inventive concepts .
Finally, it should also be noted that, in this document, relational terms such as , second, and the like are only used to distinguish entities or operations from another entities or operations, without necessarily requiring or implying any actual relationship or order between such entities or operations, furthermore, the terms "comprise", "include", or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or terminal that comprises the family of elements does not include only those elements but also other elements not expressly listed or inherent to such process, method, article, or terminal.
The synchronization methods based on the video networking monitoring data and synchronization apparatuses based on the video networking monitoring data provided by the present invention are described in detail above, and specific examples are applied herein to describe the principle and the implementation of the present invention, and the description of the above embodiments is only used to help understanding the method and the core idea of the present invention, meanwhile, for ordinary skilled in the art, there are changes in the specific implementation and the application scope according to the idea of the present invention, and in summary, the content of the present description should not be construed as a limitation to the present invention.
- 上一篇：一种医用注射器针头装配设备
- 下一篇：一种视联网的数据处理方法和装置