CN110740291A - synchronization method and device based on video networking monitoring data - Google Patents
synchronization method and device based on video networking monitoring dataDownload PDFInfo
- Publication number
- CN110740291A CN110740291ACN201810805965.6ACN201810805965ACN110740291ACN 110740291 ACN110740291 ACN 110740291ACN 201810805965 ACN201810805965 ACN 201810805965ACN 110740291 ACN110740291 ACN 110740291A
- Authority
- CN
- China
- Prior art keywords
- monitoring data
- database
- video networking
- maintenance platform
- video
- 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
- 238000012544monitoring processMethods0.000titleclaimsabstractdescription114
- 230000006855networkingEffects0.000titleclaimsabstractdescription111
- 238000000034methodMethods0.000titleclaimsabstractdescription38
- 238000012423maintenanceMethods0.000claimsabstractdescription72
- 238000013507mappingMethods0.000claimsabstractdescription54
- 230000001360synchronised effectEffects0.000claimsabstractdescription26
- 230000008859changeEffects0.000claimsdescription7
- 238000010586diagramMethods0.000description16
- 238000004590computer programMethods0.000description9
- 230000008569processEffects0.000description9
- 238000012545processingMethods0.000description5
- 238000003860storageMethods0.000description5
- 230000006870functionEffects0.000description4
- 230000001960triggered effectEffects0.000description4
- 230000005540biological transmissionEffects0.000description2
- 230000000694effectsEffects0.000description2
- 230000002085persistent effectEffects0.000description2
- 230000001568sexual effectEffects0.000description2
- 238000004458analytical methodMethods0.000description1
- 238000004891communicationMethods0.000description1
- 230000003111delayed effectEffects0.000description1
- 238000011161developmentMethods0.000description1
- 238000009826distributionMethods0.000description1
- 238000005516engineering processMethods0.000description1
- 230000000977initiatory effectEffects0.000description1
- 238000004519manufacturing processMethods0.000description1
- 238000012986modificationMethods0.000description1
- 230000004048modificationEffects0.000description1
- 230000003287optical effectEffects0.000description1
- 230000000750progressive effectEffects0.000description1
Images
Classifications
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04N—PICTORIAL COMMUNICATION, e.g. TELEVISION
- H04N7/00—Television systems
- H04N7/18—Closed-circuit television [CCTV] systems, i.e. systems in which the video signal is not broadcast
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04N—PICTORIAL COMMUNICATION, e.g. TELEVISION
- H04N21/00—Selective content distribution, e.g. interactive television or video on demand [VOD]
- H04N21/40—Client devices specifically adapted for the reception of or interaction with content, e.g. set-top-box [STB]; Operations thereof
- H04N21/41—Structure of client; Structure of client peripherals
- H04N21/4104—Peripherals receiving signals from specially adapted client devices
- H04N21/4122—Peripherals receiving signals from specially adapted client devices additional display device, e.g. video projector
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04N—PICTORIAL COMMUNICATION, e.g. TELEVISION
- H04N21/00—Selective content distribution, e.g. interactive television or video on demand [VOD]
- H04N21/40—Client devices specifically adapted for the reception of or interaction with content, e.g. set-top-box [STB]; Operations thereof
- H04N21/43—Processing of content or additional data, e.g. demultiplexing additional data from a digital video stream; Elementary client operations, e.g. monitoring of home network or synchronising decoder's clock; Client middleware
- H04N21/4302—Content synchronisation processes, e.g. decoder synchronisation
- H04N21/4307—Synchronising the rendering of multiple content streams or additional data on devices, e.g. synchronisation of audio on a mobile phone with the video output on the TV screen
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04N—PICTORIAL COMMUNICATION, e.g. TELEVISION
- H04N7/00—Television systems
- H04N7/14—Systems for two-way working
- H04N7/15—Conference systems
Landscapes
- Engineering & Computer Science (AREA)
- Multimedia (AREA)
- Signal Processing (AREA)
- Two-Way Televisions, Distribution Of Moving Picture Or The Like (AREA)
Abstract
Description
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 receivingmodule 21, a determiningmodule 22, abackup module 23, and a synchronization module 24, where,
a receivingmodule 21, configured to receive a synchronization request sent by a web client on an operation and maintenance platform of a video networking application, where the synchronization request includes: ip address, database name, table name and latest change time of the database;
a determiningmodule 22, configured to determine, based on an internet of view protocol, monitoring data in a database of the internet of view platform to be synchronized according to the synchronization request;
thebackup module 23 is configured to backup the monitoring data into an entity class of the operation and maintenance platform of the video networking application;
thebackup module 23 is specifically configured to backup the monitoring data to the physical class of the operation and maintenance platform of the video networking application through the API interface.
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 abuilding module 31, a schematic structural diagram of which is shown in fig. 3, wherein,
the establishingmodule 31 is configured to establish mapping tables on the operation and maintenance platform of the video networking application in advance, where the mapping tables are used to convert different fields in the database of each platform of the video networking application into fields in the database of the operation and maintenance platform of the video networking application.
Optionally, in another embodiment, based on the above embodiments, the determiningmodule 22 includes aquery module 41, asecond query module 42 and a determiningsubmodule 43, whose schematic structural diagram is shown in fig. 4, wherein,
, aquery module 41, configured to query, based on an internet of things protocol, a database of a corresponding internet of things platform through mybatis according to the synchronization request;
thesecond query module 42 is configured to query the monitoring data in the monitoring table of the database through an SQL statement;
a determiningsubmodule 43, configured to determine the monitoring data in the monitoring table to be synchronized.
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, aweb client 51 of the video networking application operation and maintenance platform, aSpringMVC server 52, a video networking application operation and maintenance platform database B53, anentity class 54 of the video networking application operation and maintenance platform, and a video networking platform database a55, wherein,
in this embodiment, 1) mapping tables are previously established on theSpringMVC server 52 of the operation and maintenance platform of the video networking application, and the mapping tables are used for unifying fields of the tables in the database (such as database B) of the operation and maintenance platform of the video networking application and the database (such as database a) of each platform of the video networking application.
2) Theweb client 51 of the operation and maintenance platform of the video networking application initiates the synchronization request, it should be noted that the synchronization request may be initiated by theweb client 51 triggered by the user, or may be initiated by theweb client 51 triggered by the system at regular time, and a specific initiation manner thereof is not limited in this embodiment.
3) After theweb client 51 triggers synchronization, theSpringMVC server 52 receives the synchronization request, theSpringMVC server 52 acquires data in databases of the respective platforms (i.e., database a of the video networking platform) through a backend interface based on the video networking protocol, that is, the SpringMVC server controls the database a of the video networking platform to directly send the data to theentity class 54 of the video networking application operation and maintenance platform through an API interface, and then the SpringMVC server maps the data in theentity class 54 to a table in the video networking application operation and maintenance platform database B through the established mapping table.
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.
Claims (10)
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.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810805965.6ACN110740291A (en) | 2018-07-20 | 2018-07-20 | synchronization method and device based on video networking monitoring data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810805965.6ACN110740291A (en) | 2018-07-20 | 2018-07-20 | synchronization method and device based on video networking monitoring data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110740291Atrue CN110740291A (en) | 2020-01-31 |
Family
ID=69234868
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810805965.6APendingCN110740291A (en) | 2018-07-20 | 2018-07-20 | synchronization method and device based on video networking monitoring data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110740291A (en) |
Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1664816A (en)* | 2005-03-11 | 2005-09-07 | 谢永强 | Method for realizing transplantation between information websites of different platforms |
| CN102571720A (en)* | 2010-12-27 | 2012-07-11 | 中国移动通信集团辽宁有限公司 | Method and device for processing heterogeneous information contents |
| CN103440273A (en)* | 2013-08-06 | 2013-12-11 | 北京航空航天大学 | Data cross-platform migration method and device |
| CN103677846A (en)* | 2013-12-25 | 2014-03-26 | 拉卡拉支付有限公司 | SQLite database development kit and development method thereof |
| CN104657396A (en)* | 2013-11-25 | 2015-05-27 | 腾讯科技（深圳）有限公司 | Data migration method and device |
| CN106294713A (en)* | 2016-08-09 | 2017-01-04 | 深圳中兴网信科技有限公司 | The method of data synchronization resolved based on Incremental Log and data synchronization unit |
| CN106570135A (en)* | 2016-10-27 | 2017-04-19 | 深圳市中科长海科技股份有限公司 | Data synchronization method and device for databases |
| US20170132302A1 (en)* | 2015-11-09 | 2017-05-11 | Sap Se | Integrating co-deployed databases for data analytics |
| CN106874388A (en)* | 2017-01-11 | 2017-06-20 | 中科院微电子研究所昆山分所 | A kind of heterogeneous system data cascade operation method for auto constructing based on relevant database |
| CN106960048A (en)* | 2017-03-30 | 2017-07-18 | 张伟 | A kind of database based on Java and entity class Automatic Mapping Algorithms |
| CN107908785A (en)* | 2017-12-11 | 2018-04-13 | 广州圣亚科技有限公司 | Incorporeity class based on SSM frames realizes data page |
| CN108121564A (en)* | 2017-12-22 | 2018-06-05 | 武汉楚鼎信息技术有限公司 | A kind of json data Fast synchronization and the method and system device of control |
- 2018
- 2018-07-20CNCN201810805965.6Apatent/CN110740291A/enactivePending
Patent Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1664816A (en)* | 2005-03-11 | 2005-09-07 | 谢永强 | Method for realizing transplantation between information websites of different platforms |
| CN102571720A (en)* | 2010-12-27 | 2012-07-11 | 中国移动通信集团辽宁有限公司 | Method and device for processing heterogeneous information contents |
| CN103440273A (en)* | 2013-08-06 | 2013-12-11 | 北京航空航天大学 | Data cross-platform migration method and device |
| CN104657396A (en)* | 2013-11-25 | 2015-05-27 | 腾讯科技（深圳）有限公司 | Data migration method and device |
| CN103677846A (en)* | 2013-12-25 | 2014-03-26 | 拉卡拉支付有限公司 | SQLite database development kit and development method thereof |
| US20170132302A1 (en)* | 2015-11-09 | 2017-05-11 | Sap Se | Integrating co-deployed databases for data analytics |
| CN106294713A (en)* | 2016-08-09 | 2017-01-04 | 深圳中兴网信科技有限公司 | The method of data synchronization resolved based on Incremental Log and data synchronization unit |
| CN106570135A (en)* | 2016-10-27 | 2017-04-19 | 深圳市中科长海科技股份有限公司 | Data synchronization method and device for databases |
| CN106874388A (en)* | 2017-01-11 | 2017-06-20 | 中科院微电子研究所昆山分所 | A kind of heterogeneous system data cascade operation method for auto constructing based on relevant database |
| CN106960048A (en)* | 2017-03-30 | 2017-07-18 | 张伟 | A kind of database based on Java and entity class Automatic Mapping Algorithms |
| CN107908785A (en)* | 2017-12-11 | 2018-04-13 | 广州圣亚科技有限公司 | Incorporeity class based on SSM frames realizes data page |
| CN108121564A (en)* | 2017-12-22 | 2018-06-05 | 武汉楚鼎信息技术有限公司 | A kind of json data Fast synchronization and the method and system device of control |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109284334A (en) | Real-time database synchronization method and device, electronic equipment and storage medium | |
| CN108989189B (en) | Message pushing method based on enterprise WeChat | |
| CN109542865A (en) | Distributed cluster system configuration file synchronous method, device, system and medium | |
| KR101685215B1 (en) | Automatic discovery of alternate mailboxes | |
| CN103164525B (en) | WEB application dissemination method and device | |
| US8019894B2 (en) | System, method and engine for playing SMIL based multimedia contents | |
| CN103297803B (en) | Data update system based on Set Top Box and method | |
| CN109462640B (en) | A metadata synchronization method, data terminal, interactive system and medium | |
| CN101753558B (en) | Balancing method of distributed MRCP server load balancing system | |
| CN101217533B (en) | A synchronous big head portrait method and cluster server and terminal for the method | |
| CN108076081B (en) | Method, device and system for synchronizing service data | |
| CN105100158A (en) | Message pushing and obtaining methods and apparatuses | |
| CN102970600A (en) | Cloud-computing-based high-definition video playing system and method | |
| CN103634695A (en) | Method and system for receiving Google GCM push message by smart television | |
| CN114385090B (en) | Data automatic processing method and device based on object storage site synchronization mechanism | |
| CN101159910A (en) | Synchronous present state method and cluster server and terminal for implementing the method | |
| CN112257061B (en) | Webpage content processing method and device | |
| CN110740291A (en) | synchronization method and device based on video networking monitoring data | |
| CN101610225A (en) | Synchronous processing method, system and device | |
| CN103475948A (en) | P2P live video based intelligent resource matching system | |
| CN103379155A (en) | Method and system for distributing contents and content management system | |
| CN115297093B (en) | Edge device data access method, related device and computer program product | |
| CN110753071B (en) | Information acquisition method and device | |
| CN115002507A (en) | Video data updating method, device, equipment and readable storage medium | |
| CN105187929A (en) | Method for realizing global response message on set-top box |
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:20200131 | |
| RJ01 | Rejection of invention patent application after publication |