CN112115135A - Database upgrading method, database processing method, database transmission method and device - Google Patents
Database upgrading method, database processing method, database transmission method and device Download PDFInfo
- Publication number
- CN112115135A CN112115135A CN202010814533.9A CN202010814533A CN112115135A CN 112115135 A CN112115135 A CN 112115135A CN 202010814533 A CN202010814533 A CN 202010814533A CN 112115135 A CN112115135 A CN 112115135A
- Authority
- CN
- China
- Prior art keywords
- database
- terminal
- upgrading
- target
- video network
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/60—Software deployment
- G06F8/65—Updates
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04N—PICTORIAL COMMUNICATION, e.g. TELEVISION
- H04N7/00—Television systems
- H04N7/14—Systems for two-way working
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Multimedia (AREA)
- Signal Processing (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Computer Security & Cryptography (AREA)
- Stored Programmes (AREA)
Abstract
The embodiment of the invention provides a method and a device for database upgrading, data processing and data transmission, wherein the method for database upgrading comprises the following steps: receiving database upgrading parameter information corresponding to the video networking terminal sent by the video networking server in a transparent transmission mode, wherein the database upgrading parameter information is obtained by packaging the acquired database target information corresponding to the video networking terminal by the first terminal according to a video networking protocol, and is transmitted to the video networking server by the first terminal; analyzing the database upgrading parameter information through a video networking protocol to acquire database target information; and under the condition that the local database needs to be upgraded according to the database target information, upgrading the local database according to the database target information. The embodiment of the invention can realize remote upgrade of the video network terminal database, ensure the stability of the video network terminal program, realize the unified management of the video network terminal and bring convenience to users for better experience.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a method and a device for database upgrading, data processing and data transmission.
Background
The video networking is an important milestone for network development, is a higher-level form of the Internet, is a real-time network, can realize the real-time transmission of full-network high-definition videos which cannot be realized by the Internet at present, pushes a plurality of Internet applications to high-definition video, and finally realizes no distance in the world and realizes that the distance between people in the world is only the distance of one screen.
In the video networking scene, video networking terminal users are increasing day by day, video networking services are also gradually increasing, and correspondingly, for the video networking terminal, more and more data are stored in the database. For example, the addition of contacts in videophones requires a database for videonetworking to store such information. As the amount of data stored in the database increases, the database is subjected to greater data pressure, which affects the performance of the database and the ability to undertake business. And the existing database of the video network terminal has the problems of difficult unified management, poor data compatibility and difficult function expansion based on business requirements.
Disclosure of Invention
In view of the above problems, embodiments of the present invention are provided to provide a database upgrade, data processing, data transmission method and apparatus that overcome or at least partially solve the above problems.
In a first aspect, an embodiment of the present invention provides a database upgrading method, applied to a video networking terminal, including:
receiving database upgrading parameter information corresponding to the video networking terminal, which is sent by a video networking server in a transparent transmission mode, wherein the database upgrading parameter information is obtained by a first terminal by packaging the acquired database target information corresponding to the video networking terminal according to a video networking protocol, and is transmitted to the video networking server by the first terminal in a transparent transmission mode;
analyzing the database upgrading parameter information through the video networking protocol to acquire the database target information;
and under the condition that the local database needs to be upgraded according to the database target information, upgrading the local database according to the database target information.
Optionally, the database target information includes a database target version number, a database version description, and a newly added field;
the upgrading the local database according to the database target information comprises:
detecting whether the target version number of the database is higher than the corresponding version number of the local database;
under the condition that the target version number of the database is higher than the version number corresponding to the local database, acquiring a target installation package corresponding to the target version number of the database, and upgrading the local data by adopting an upgrading function according to the local database, the newly-added field, the database version description and the target installation package;
and the video network terminal determines the related functions of the database corresponding to the target version number of the database according to the database version description, the database corresponding to the target version number of the database supports the newly added fields, the upgraded local database comprises the newly added fields, and the version number corresponding to the upgraded local database is the same as the target version number of the database.
In a second aspect, an embodiment of the present invention provides a data processing method, applied to a first terminal, including:
acquiring database target information corresponding to a video network terminal input by a target person;
packaging the database target information according to a video networking protocol to obtain database upgrading parameter information;
and transmitting the database upgrading parameter information to a video network server in a transparent transmission mode so that the video network server transmits the database upgrading parameter information to the video network terminal.
Optionally, the obtaining of the database target information corresponding to the video network terminal input by the target person includes:
displaying an application interface corresponding to a target application program installed in the first terminal;
receiving the database target information input by the target person on the application interface;
wherein the database target information comprises: the target application program and the video network server form an interaction path.
In a third aspect, an embodiment of the present invention provides a data transmission method applied to a video networking server, including:
receiving database upgrading parameter information corresponding to a video networking terminal, which is sent by a first terminal in a transparent transmission mode, wherein the database upgrading parameter information is obtained by the first terminal by packaging the acquired database target information corresponding to the video networking terminal according to a video networking protocol;
and transmitting the database upgrading parameter information to the video networking terminal, so that the video networking terminal analyzes the database upgrading parameter information according to the video networking protocol, and upgrading a local database according to the database target information acquired after analysis.
In a fourth aspect, an embodiment of the present invention provides a database upgrading apparatus, which is applied to a video networking terminal, and includes:
the first receiving module is used for receiving database upgrading parameter information corresponding to the video network terminal and sent by a video network server in a transparent transmission mode, wherein the database upgrading parameter information is obtained by packaging the acquired database target information corresponding to the video network terminal by the first terminal according to a video network protocol, and is transmitted to the video network server by the first terminal in a transparent transmission mode;
the first acquisition module is used for analyzing the database upgrading parameter information through the video networking protocol to acquire the database target information;
and the upgrading module is used for upgrading the local database according to the database target information under the condition that the local database needs to be upgraded according to the database target information.
Optionally, the database target information includes a database target version number, a database version description, and a newly added field; the upgrade module includes:
the detection submodule is used for detecting whether the target version number of the database is higher than the corresponding version number of the local database;
the upgrading submodule is used for acquiring a target installation package corresponding to the target version number of the database under the condition that the target version number of the database is higher than the version number corresponding to the local database, and upgrading the local data by adopting an upgrading function according to the local database, the newly-added field, the database version description and the target installation package;
and the video network terminal determines the related functions of the database corresponding to the target version number of the database according to the database version description, the database corresponding to the target version number of the database supports the newly added fields, the upgraded local database comprises the newly added fields, and the version number corresponding to the upgraded local database is the same as the target version number of the database.
In a fifth aspect, an embodiment of the present invention provides a data processing apparatus, applied to a first terminal, including:
the second acquisition module is used for acquiring database target information corresponding to the video network terminal input by a target person;
the third acquisition module is used for packaging the database target information according to a video networking protocol and acquiring the database upgrading parameter information;
and the sending module is used for sending the database upgrading parameter information to a video network server in a transparent transmission mode so that the video network server sends the database upgrading parameter information to the video network terminal.
Optionally, the second obtaining module includes:
the display submodule is used for displaying an application interface corresponding to a target application program installed in the first terminal;
the receiving submodule is used for receiving the database target information input by the target person on the application interface;
wherein the database target information comprises: the target application program and the video network server form an interaction path.
In a sixth aspect, an embodiment of the present invention provides a data transmission apparatus, applied to a video networking server, including:
the second receiving module is used for receiving database upgrading parameter information corresponding to the video network terminal, which is sent by the first terminal in a transparent transmission mode, wherein the database upgrading parameter information is obtained by the first terminal by packaging the acquired database target information corresponding to the video network terminal according to a video network protocol;
and the transmission module is used for transmitting the database upgrading parameter information to the video networking terminal so that the video networking terminal analyzes the database upgrading parameter information according to the video networking protocol and upgrades the local database according to the database target information acquired after analysis.
In a seventh aspect, an embodiment of the present invention provides an electronic device, including a memory, a processor, and a computer program stored on the memory and executable on the processor, where the processor implements the steps of the above database upgrading method or the above data processing method or the above data transmission method when executing the computer program.
In an eighth aspect, an embodiment of the present invention provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the steps of the above-mentioned database upgrading method or the above-mentioned data processing method or the above-mentioned data transmission method.
The embodiment of the invention has the following advantages:
the method comprises the steps of establishing a first terminal and a video networking server based on a video networking protocol, and interacting between the video networking server and a video networking terminal, so that a video networking terminal database can be upgraded remotely, the video networking terminal of a new version and an old version is compatible with stored data, video networking service requirements can be expanded, related functions can be realized, the stability of a video networking terminal program is guaranteed, convenience is brought to users for better experience, uniform processing operation is performed on the first terminal side, the video networking terminal is not required to be operated by a video networking user, and automatic upgrading of the database can be realized.
Drawings
FIG. 1 is a schematic diagram illustrating a database upgrade method according to an embodiment of the present invention;
FIG. 2 is a diagram illustrating a content comparison of databases of different versions according to an embodiment of the present invention;
FIG. 3 is a schematic diagram of a data processing method according to an embodiment of the present invention;
FIG. 4 is a diagram illustrating a data transmission method according to an embodiment of the invention;
FIG. 5 is a flowchart illustrating interaction among a first terminal, a video network server, and a video network terminal according to an embodiment of the present invention;
FIG. 6 is a schematic diagram of a database upgrading apparatus according to an embodiment of the present invention;
FIG. 7 is a schematic diagram of a data processing apparatus according to an embodiment of the present invention;
fig. 8 is a schematic diagram of a data transmission apparatus according to an embodiment of the invention.
Detailed Description
In order to make the aforementioned objects, features and advantages of the present invention comprehensible, embodiments accompanied with figures are described in further detail below.
The embodiment of the invention provides a method and a device for upgrading, processing and transmitting a database, aiming at the problems that the storage capacity of the database corresponding to a video networking terminal is increased, the data pressure born by the database is large, the performance of the database and the capability of bearing services are influenced, and the database of the existing video networking terminal is difficult to uniformly manage, has poor data compatibility and is difficult to perform function expansion based on service requirements.
The following describes a database upgrading method applied to a video network terminal according to an embodiment of the present invention, as shown in fig. 1, including:
In the database upgrading method provided by the embodiment of the invention, the video network terminal interacts with the video network server, and the video network server interacts with the first terminal. The first terminal may be a PC (Personal Computer), a mobile phone, or other devices. When the first terminal is a mobile terminal, such as a mobile phone, a tablet computer, etc., the corresponding operating System may be an android System, an iOS (iPhone operating System, apple mobile operating System), a Windows phone (microsoft mobile operating System), etc., and when the first terminal is a desktop computer or a notebook computer, the corresponding operating System may be a Windows (microsoft operating System), a MacOS (apple computer operating System), etc., so that a data format in which the first terminal acquires the database target information may not conform to a format for data transmission in the video network, and the database target information needs to be encapsulated by using a video network protocol to obtain the database upgrade parameter information, so that the database upgrade parameter information can be stably and safely transmitted in the video network. The method specifically comprises the following steps: the first terminal can acquire the database target information corresponding to the video network terminal, then packages the database target information through the video network protocol to obtain the database upgrading parameter information corresponding to the video network terminal, transmits the database upgrading parameter information to the video network server, and can realize interaction between the first terminal and the video network server based on the video network protocol. In the embodiment of the present invention, the first terminal and the video network terminal are explained by taking an example that both correspond to an android system.
The video network terminal can receive the database upgrading parameter information transmitted by the video network server after the video network server acquires the database upgrading parameter information, so that interaction between the video network terminal and the video network server is realized.
The video network terminal can be a terminal provided with video network application, a switch, a router, high-definition aurora equipment, a starting 3C terminal, a starting 2S terminal and the like. The transparent transmission can be realized between the video network server and the video network terminal, and between the video network server and the first terminal through a short connection at a push, RPC (Remote Procedure Call) or socket (socket) end. For example, the video network server may push information to the video network terminal in advance, and may transmit the information according to a push path when transmitting the database upgrade parameter information to the video network terminal; the video network server can acquire the database upgrading parameter information at the first terminal in an RPC mode. The video network server and the video network terminal can also realize transparent transmission through the video network, an autonomous server is deployed between the video network server and the video network terminal, distribution management interaction is carried out through the autonomous server, and video network transmission belongs to one type of transparent transmission.
And 102, analyzing the database upgrading parameter information through the video networking protocol to acquire the database target information.
After the video network terminal acquires the database upgrading parameter information transmitted by the video network server, the database upgrading parameter information is the information encapsulated by the video network protocol, so that the received database upgrading parameter information can be analyzed based on the video network protocol to acquire the database target information provided by the first terminal.
The first terminal adopts a video networking protocol to package the database target information, interaction between the first terminal and the video networking server can be achieved, and then database upgrading parameter information can be transmitted between the video networking server and the video networking terminal.
And 103, upgrading the local database according to the database target information under the condition that the local database needs to be upgraded according to the database target information.
The method comprises the steps that the video network terminal analyzes the upgrading parameter information of the database according to a video network protocol to obtain the target information of the database, whether the local database of the video network terminal needs to be upgraded or not can be detected according to the target information of the database, the local database can be upgraded according to the target information of the database under the condition that the local database needs to be upgraded, a database upgrading method needs to be adopted during upgrading, the local database is updated through upgrading, the fact that the local database can be compatible with data of different versions is guaranteed, the service requirements and functions of the video network are expanded, and the stability of a video network terminal program is guaranteed.
In the implementation process, remote operation can be performed through the first terminal, the database of the video network terminal is managed in a unified mode, the video network terminal is not required to be operated by a video network user, automatic upgrading of the video network terminal database can be achieved, the fact that the local database of the video network terminal can be compatible with the video network terminal storage data of new and old versions is guaranteed, video network service requirements and functions are expanded, stability of video network terminal programs is guaranteed, users can experience better conveniently, unified processing operation is performed on the first terminal side, the video network terminal is not required to be operated by the video network user, and automatic upgrading of the database can be achieved.
In an optional embodiment of the present invention, the first terminal and the video network terminal both correspond to an android system, and receive the database upgrade parameter information in a byte stream format sent by the video network server when receiving the database upgrade parameter information;
the analyzing the database upgrading parameter information through the video networking protocol to acquire the database target information comprises the following steps:
analyzing the database upgrading parameter information through the video networking protocol, acquiring the database target information in a byte stream format, and converting the database target information in the byte stream format into a JSON format;
and the video network terminal upgrades the local database according to the database target information in the JSON format.
In this embodiment, taking the example that the first terminal and the video network terminal correspond to an android system as an example, when receiving the database upgrade parameter information sent by the video network server, the video network terminal may receive the database upgrade parameter information in the byte stream format sent by the video network server. The database upgrade parameter information generated by the first terminal is in a JSON (JavaScript Object Notation) format, and the JSON format may be converted into a byte stream format before being sent to the internet of view server.
After receiving the database upgrading parameter information in the byte stream format, analyzing the database upgrading parameter information based on the video networking protocol to acquire the database target information in the byte stream format, and then converting the database target information in the byte stream format into the JSON format so that the video networking terminal can conveniently upgrade the local database according to the database target information in the JSON format.
Specifically, the video network server sends the byte stream format database upgrading parameter information to the video network terminal, and the video network terminal can analyze the byte stream format database upgrading parameter information according to the video network protocol to obtain the byte stream format database target information. Because the target information of the database is in a byte stream format, the target information can be effectively identified by C + + language. Wherein, C + + not only has the practical characteristic of efficient operation of the computer, but also aims to improve the programming quality of large-scale programs and the problem description capability of programming languages. The C + + language may correspond to a system runtime layer of the android system, and the system runtime layer may communicate Java codes and C + + codes based on JNI (Java Native Interface) to convert the database object information in the byte stream format into a JSON format recognizable by Java language. The Java language corresponds to an application program layer of the android system, and the video networking terminal performs upgrading processing on the local database at the application program layer.
In the implementation process, after the database upgrading parameter information is received and analyzed, the different layer structures of the video network terminal process the database target information acquired after analysis, so that the local database can be upgraded based on the database target information.
In an optional embodiment of the present invention, the database target information includes a database target version number, a database version description, and a newly added field;
the upgrading the local database according to the database target information comprises:
detecting whether the target version number of the database is higher than the corresponding version number of the local database;
under the condition that the target version number of the database is higher than the version number corresponding to the local database, acquiring a target installation package corresponding to the target version number of the database, and upgrading the local data by adopting an upgrading function according to the local database, the newly-added field, the database version description and the target installation package;
and the video network terminal determines the related functions of the database corresponding to the target version number of the database according to the database version description, the database corresponding to the target version number of the database supports the newly added fields, the upgraded local database comprises the newly added fields, and the version number corresponding to the upgraded local database is the same as the target version number of the database.
The database target information acquired by the first terminal may include a database target version number, a database version description, and a newly added field. It should be noted that, when the first terminal and the internet of view server send the database upgrade parameter information in a transparent transmission manner, a transparent transmission interface protocol needs to be used, the following briefly introduces the process of transmitting information through the transparent transmission interface protocol by way of table example, the following table may find that the target version number of the database is 2, 1 represents to open the transparent transmission interface, 0 represents to close the transparent transmission interface, different codes may be used to represent 1 or 0, the upgrade field (newly added field) corresponds to field number 3, the upgrade description (database version description) corresponds to field number 4, the operation code is a protocol, and is used to represent the meaning of the code, the length of the byte stream corresponding to the code is less than or equal to 1W, where 1W is the byte length defined by the technician, and 1W is 10000 byte.
After the video network terminal acquires the database target information, the video network terminal can firstly extract the database target version number from the database target information, and then compare the extracted database target version number with the version number corresponding to the local database. And under the condition that the extracted database version number is higher than the version number corresponding to the local database, determining that the local database needs to be upgraded. And under the condition that the extracted database version number is lower than or the same as the version number corresponding to the local database, determining that the local database does not need to be upgraded.
For example, after the database upgrading parameter information is analyzed according to the video networking protocol to obtain the database target information, the database target version number 5.0 in the database target information may be extracted, the database target version number 5.0 is compared with the version number 4.0 corresponding to the local database, it is determined that the database target version number 5.0 in the database target information is higher than the version number of the local database, at this time, version upgrading may be performed on the local database, and the local database is upgraded to a version the same as the database target version number.
The database target information can also comprise a database version description and a newly added field, the database version description is used for introducing related functions of the database, the newly added field is used for expanding services and is compatible with data of new and old versions, the database must be upgraded when the newly added field is added, and otherwise, the newly added field cannot be added.
When the local database is upgraded, a target installation package corresponding to the target version number of the database can be obtained and an upgrade function is called, and when the target installation package is obtained, a request can be sent to a corresponding database server for obtaining, and the request can also be sent to other video network terminals for obtaining. And under the condition of keeping the information of the local database, processing by adopting an upgrading function according to the local database, the newly added field, the database version description and the target installation package, and acquiring the upgraded local database.
And determining whether the database corresponding to the target version number of the database supports the newly added field or not according to the database version description, and simultaneously determining other related functions. The database corresponding to the target version number of the database supports the newly added field, so that the newly added field can be added while the database is upgraded, corresponding data information can be generated aiming at the newly added field after the newly added field is added, and the service is expanded by the newly added field while the version number of the local database is upgraded to the target version number of the database.
In the following, a specific example is described for the case of adding a new field to implement an extended service. For example, when the contact information is stored in the local database, the name and the number of the contact are retained, when the contact is retrieved, the name or the number can be searched, only one name can be searched, and two or more contacts can be retrieved under the condition of the same name. As shown in fig. 2, the original database includes a name field, a number field, and data information corresponding to each field, where the name field corresponds to name data information such as zhang, zhu, etc., and the number field corresponds to number data information of each contact, and after a field combining a name and a number is added, the database may include the name field, the number field, a name-number combination field, and data information corresponding to each field.
In the implementation process, whether the local database needs to be upgraded or not can be determined based on comparison of the database version, and under the condition that the local database needs to be upgraded, the version of the local database is upgraded based on the database target version number, the database version description and the newly added field in the database target information, so that updating of the local database is guaranteed, and the database of the first terminal remote control video network terminal can be upgraded due to the fact that information needs to be extracted from the database target information provided by the first terminal.
The database upgrading method provided by the embodiment of the invention can realize remote upgrading of the video network terminal database, is compatible with the stored data of the new and old video network terminals, can expand the video network service requirements and realize related functions, ensures the stability of the video network terminal program, is convenient for users to experience better, and can realize automatic upgrading of the database by carrying out unified processing operation on the first terminal side without operating the video network terminal by the video network users.
An embodiment of the present invention further provides a data processing method, applied to a first terminal, as shown in fig. 3, including:
301, obtaining the database target information corresponding to the video network terminal input by the target person.
The first terminal is a non-video network terminal, the first terminal can interact with a video network server, and the video network server interacts with the video network terminal. The first terminal can acquire database target information corresponding to a video network terminal input by a target person, wherein the target person is a related technical person, particularly an enterprise internal technical person, and the database upgrading is realized based on the internal research and development of a program. Related technical personnel input database target information corresponding to the video network terminal at the first terminal, and the video network server and the video network terminal are interacted through the interaction of the first terminal and the video network server, so that the video network terminal is remotely controlled at the first terminal to upgrade a local database according to the database target information.
And because the video network server can interact with a plurality of video network terminals, the remote upgrade of the local database corresponding to the plurality of video network terminals controlled by the first terminal can be realized. The first terminal may be a PC device, a mobile phone or other devices.
And step 302, packaging the database target information according to a video networking protocol to obtain database upgrading parameter information.
Because the first terminal can be different devices and the corresponding operating systems are different, the data format of the database target information acquired by the first terminal may not conform to the data transmission format in the video network, and the database target information needs to be encapsulated by a video network protocol to obtain the database upgrading parameter information, so that the database upgrading parameter information can be stably and safely transmitted in the video network.
The video networking Protocol may be equivalent to a Protocol converter between the video networking and the internet, for example, the internet adopts an Inter-Process Communication (IPC), and uses a Real Time Streaming Protocol (RTSP) to transmit using an H264 Streaming format, and splices database target information to be transmitted at a header of the RTSP, so as to encapsulate the database target information based on the video networking Protocol.
And 303, transmitting the database upgrading parameter information to a video network server in a transparent transmission mode so that the video network server transmits the database upgrading parameter information to the video network terminal.
After the database target information is packaged and the database upgrading parameter information is obtained, the database upgrading parameter information can be transmitted to the video network server in a transparent transmission mode, and the video network server can effectively identify the database upgrading parameter information because the database upgrading parameter information is the information packaged by adopting a video network protocol. After receiving the database upgrading parameter information, the video network server can transmit the acquired database upgrading parameter information to the video network terminal, so that the video network terminal can analyze the acquired database upgrading parameter information, upgrade a local database according to an analysis result, and realize remote upgrading of the database of the video network terminal controlled by the first terminal.
In the embodiment of the present invention, it is described by taking an example that the first terminal and the video network terminal correspond to an android system, the database upgrade parameter information generated by the first terminal is in a JSON format, and before being sent to the video network server, the JSON format may be converted into a byte stream format. The video network server transmits the database upgrading parameter information in the byte stream format to the video network terminal, the video network terminal analyzes the database upgrading parameter information based on a video network protocol to obtain the database target information in the byte stream format, and then the database target information in the byte stream format is converted into a JSON format, so that the video network terminal can conveniently upgrade the local database according to the database target information in the JSON format.
According to the implementation process, the database target information corresponding to the video network terminal is obtained, the database target information is packaged based on the video network protocol to obtain the database upgrading parameter information, the database upgrading parameter information can be stably and safely transmitted in the video network, the database upgrading parameter information is sent to the video network server, and the video network server sends the database upgrading parameter information to at least one video network terminal, so that the local database corresponding to the remote control video network terminal can be upgraded.
In an optional embodiment of the present invention, the acquiring of the database target information corresponding to the video network terminal input by the target person includes:
displaying an application interface corresponding to a target application program installed in the first terminal;
receiving the database target information input by the target person on the application interface;
wherein the database target information comprises: the target application program and the video network server form an interaction path.
When the first terminal acquires the database target information corresponding to the video network terminal input by the target person, the first terminal can display an application interface corresponding to the target application program on a display interface of the first terminal, and receive the database target version number, the database version description and the newly added fields input on the application interface by the related technical person. The following description is taken as an example:
"database _ ver": 3 "// database target version number
"update _ Field": 1",// newly added Field
"update _ content": 1",// database version description
The target application program is an executable application program on the first terminal, and an interaction path is formed between the target application program and the video network server, for example, the video network server forms the interaction path with the target application program by pushing information to the target application program, or, for example, the video network server forms the interaction path with the target application program by calling related data of the target application program.
The database version description is used for introducing relevant functions of the database, the newly added fields are used for expanding services and are compatible with data of new and old versions, the database must be upgraded when the newly added fields are added, and otherwise, the newly added fields cannot be added. According to the database version description, whether the database corresponding to the target version number of the database supports the newly added field or not can be determined, and meanwhile, other related functions can also be determined. When the database corresponding to the target version number of the database supports the newly added fields, the addition of the newly added fields can be completed while the database is upgraded.
According to the implementation process, the target information of the database is input by the target person, the target information of the database can be packaged and then sent to the video network terminal through the video network server, and the video network terminal can be controlled by the first terminal to remotely upgrade the local database conveniently.
The data processing method provided by the embodiment of the invention can perform unified processing operation on the first terminal side, realize automatic remote upgrade of the local database of the video networking terminal, make the local database of the video networking terminal compatible with the stored data of new and old versions, expand video networking service requirements and realize related functions, ensure the stability of the video networking terminal program and bring convenience to users for better experience.
An embodiment of the present invention further provides a data transmission method, which is applied to a video network server, and as shown in fig. 4, the method includes:
The data transmission method is applied to the video network server, wherein the video network server interacts with the first terminal, can interact with the video network terminal, and can interact with at least one video network terminal when interacting with the video network terminal.
The video network server can firstly receive the database upgrading parameter information corresponding to the video network terminal sent by the first terminal in a transparent transmission mode, wherein the database upgrading parameter information is information packaged by a video network protocol, and specifically comprises the following steps: the first terminal acquires the database target information corresponding to the video network terminal input by the target person, and encapsulates the database target information by adopting a video network protocol to obtain the database upgrading parameter information, so that the database upgrading parameter information can be stably and safely transmitted in the video network.
And 402, transmitting the database upgrading parameter information to the video networking terminal in a transparent mode so that the video networking terminal analyzes the database upgrading parameter information according to the video networking protocol and upgrades a local database according to the database target information acquired after analysis.
After receiving the database upgrading parameter information corresponding to the video network terminal sent by the first terminal in a transparent transmission mode, the obtained database upgrading parameter information can be sent to the video network terminal, the video network terminal analyzes the information based on a video network protocol to obtain database target information, and a local database is upgraded according to the database target information.
The database upgrading parameter information generated by the first terminal is in a JSON format, and the JSON format can be converted into a byte stream format before being sent to the video networking server. The video network server receives the database upgrading parameter information in the byte stream format and transmits the database upgrading parameter information in the byte stream format to the video network terminal, so that the video network terminal analyzes the database upgrading parameter information based on a video network protocol to obtain the database target information in the byte stream format, and then converts the database target information in the byte stream format into a JSON format, so that the video network terminal can conveniently upgrade the local database according to the database target information in the JSON format.
Wherein, the database target information comprises: the database target version number, the database version description and the newly added field are obtained by packaging the database target information based on the video networking protocol, and the video networking server can send the database target version number, the database version description and the newly added field to the video networking terminal, so that the video networking terminal can upgrade the local database according to the database target version number, the database version description, the newly added field and the information stored in the local database.
The data transmission method provided by the embodiment of the invention can receive the database upgrading parameter information transmitted by the first terminal and transmit the database upgrading parameter information to the video network terminal, so that the local database of the video network terminal is automatically and remotely upgraded, the remote upgrading of the database is controlled by processing at the first terminal side, the local database of the video network terminal is compatible with the stored data of new and old versions, the video network service requirement is expanded, the related functions are realized, the stability of the video network terminal program is ensured, and the user can better experience the data transmission method.
The following explains an interaction process of the first terminal, the video network server, and the video network terminal according to a specific example, as shown in fig. 5, including:
Step 502, the first terminal encapsulates the database target information by adopting a video networking protocol to obtain database upgrading parameter information, converts the JSON format database upgrading parameter information into a byte stream format and sends the byte stream format to a video networking server in a transparent transmission mode.
Step 503, the video network server transmits the received database upgrading parameter information in the byte stream format to the video network terminal.
And 505, the video network terminal extracts a database target version number in the database target information, and then compares the extracted database target version number with a version number corresponding to a local database.
And 506, under the condition that the extracted database version number is higher than the version number corresponding to the local database, acquiring a target installation package corresponding to the target version number of the database, extracting a newly-added field and a database version description from the target information of the database, and upgrading the local data by adopting an upgrading function according to the local database, the newly-added field, the database version description and the target installation package.
Above-mentioned implement the flow, can be through the data interaction between first terminal, video networking server and the video networking terminal, realize carrying out automatic upgrading by the local database of first terminal remote control video networking terminal, can guarantee the stability of video networking terminal program, the better experience of convenience of customers.
According to the implementation process of the database upgrading method, the data processing method and the data transmission method provided by the embodiment of the invention, the remote upgrading of the database of the video networking terminal can be realized according to the interaction of the first terminal and the video networking server based on the video networking protocol and the interaction between the video networking server and the video networking terminal based on the video networking protocol, the database is compatible with the stored data of the new and old video networking terminals, the video networking service requirements can be expanded, the related functions can be realized, the stability of the video networking terminal program is ensured, the better experience of a user is facilitated, and the video networking terminal is not required to be operated by a video networking user through the unified processing operation on the first terminal side, so that the automatic upgrading of the database can be realized.
It should be noted that, for simplicity of description, the method embodiments are described as a series of acts or combination of acts, but those skilled in the art will recognize that the present invention is not limited by the illustrated order of acts, as some steps may occur in other orders or concurrently in accordance with the embodiments of the present invention. Further, those skilled in the art will appreciate that the embodiments described in the specification are presently preferred and that no particular act is required to implement the invention.
Referring to fig. 6, a block diagram of a database upgrading apparatus according to an embodiment of the present invention is shown, and is applied to a video networking terminal, and specifically includes the following modules:
the first receiving module 601 is configured to receive database upgrade parameter information corresponding to the video networking terminal, which is sent by a video networking server in a transparent transmission manner, where the database upgrade parameter information is obtained by a first terminal by encapsulating, according to a video networking protocol, database target information corresponding to the video networking terminal, and is transmitted to the video networking server by the first terminal;
a first obtaining module 602, configured to analyze the database upgrade parameter information through the video networking protocol, and obtain the database target information;
the upgrading module 603 is configured to upgrade the local database according to the database target information under the condition that it is determined that the local database needs to be upgraded according to the database target information.
Optionally, the database target information includes a database target version number, a database version description, and a newly added field; the upgrade module 603 includes:
a detection submodule 6031, configured to detect whether the target version number of the database is higher than a version number corresponding to the local database;
an upgrade submodule 6032, configured to, when the target database version number is higher than the version number corresponding to the local database, obtain a target installation package corresponding to the target database version number, and upgrade the local data by using an upgrade function according to the local database, the newly added field, the database version description, and the target installation package;
and the video network terminal determines the related functions of the database corresponding to the target version number of the database according to the database version description, the database corresponding to the target version number of the database supports the newly added fields, the upgraded local database comprises the newly added fields, and the version number corresponding to the upgraded local database is the same as the target version number of the database.
The database upgrading device provided by the embodiment of the invention can realize remote upgrading of the video network terminal database, is compatible with the stored data of the new and old video network terminals, can expand the video network service requirements and realize related functions, ensures the stability of the video network terminal program, is convenient for users to experience better, and can realize automatic upgrading of the database by carrying out unified processing operation on the first terminal side without operating the video network terminal by the video network users.
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.
Referring to fig. 7, a block diagram of a data processing apparatus according to an embodiment of the present invention is shown, and is applied to a first terminal, and specifically includes the following modules:
a second obtaining module 701, configured to obtain database target information corresponding to the video network terminal input by a target person;
a third obtaining module 702, configured to package the database target information according to a video networking protocol, and obtain database upgrade parameter information;
the sending module 703 is configured to send the database upgrade parameter information to a video networking server in a transparent transmission manner, so that the video networking server sends the database upgrade parameter information to the video networking terminal.
Optionally, the second obtaining module 701 includes:
the display sub-module 7011 is configured to display an application interface corresponding to a target application installed in the first terminal;
the receiving sub-module 7012 is configured to receive the database target information input by the target person on the application interface;
wherein the database target information comprises: the target application program and the video network server form an interaction path.
The data processing device provided by the embodiment of the invention can perform unified processing operation on the first terminal side, realize automatic remote upgrade of the local database of the video networking terminal, make the local database of the video networking terminal compatible with the stored data of new and old versions, expand video networking service requirements and realize related functions, ensure the stability of video networking terminal programs and bring convenience to users for better experience.
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.
Referring to fig. 8, a block diagram of a data transmission apparatus according to an embodiment of the present invention is shown, and is applied to a video network server, and specifically includes the following modules:
a second receiving module 801, configured to receive database upgrade parameter information corresponding to a video networking terminal sent by a first terminal in a transparent transmission manner, where the database upgrade parameter information is obtained by the first terminal encapsulating, according to a video networking protocol, database target information corresponding to the video networking terminal;
the transmission module 802 is configured to transparently transmit the database upgrade parameter information to the video networking terminal, so that the video networking terminal analyzes the database upgrade parameter information according to the video networking protocol, and performs upgrade processing on a local database according to the database target information obtained after analysis.
The data transmission device provided by the embodiment of the invention can receive the database upgrading parameter information transmitted by the first terminal and transmit the database upgrading parameter information to the video network terminal, so that the local database of the video network terminal is automatically and remotely upgraded, the remote upgrading of the database is controlled by processing at the first terminal side, the local database of the video network terminal is compatible with the stored data of new and old versions, the video network service requirement is expanded, related functions are realized, the stability of the video network terminal program is ensured, and the user can better experience the data transmission device.
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.
An embodiment of the present invention further provides an electronic device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, where the processor implements the steps of the above database upgrading method or the above data processing method or the above data transmission method when executing the computer program.
An embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the steps of the above-mentioned database upgrading method or the above-mentioned data processing method or the above-mentioned data transmission method.
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.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, apparatus, or computer program product. Accordingly, embodiments of the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, embodiments of the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
Embodiments of the present invention are described with reference to flowchart illustrations and/or block diagrams of methods, terminal devices (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing 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 flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing 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.
While preferred embodiments of the present invention have been described, additional variations and modifications of these embodiments may occur to those skilled in the art once they learn of the basic inventive concepts. Therefore, it is intended that the appended claims be interpreted as including preferred embodiments and all such alterations and modifications as fall within the scope of the embodiments of the invention.
Finally, it should also be noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or terminal that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or terminal. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or terminal that comprises the element.
The above detailed description is given to a database upgrading method, a data processing method, a data transmission method and a data transmission device provided by the present invention, and a specific example is applied in the present document to explain the principle and the implementation of the present invention, and the description of the above embodiment is only used to help understanding the method and the core idea of the present invention; meanwhile, for a person skilled in the art, according to the idea of the present invention, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present invention.
Claims (10)
1. A database upgrading method is applied to a video networking terminal and is characterized by comprising the following steps:
receiving database upgrading parameter information corresponding to the video networking terminal, which is sent by a video networking server in a transparent transmission mode, wherein the database upgrading parameter information is obtained by a first terminal by packaging the acquired database target information corresponding to the video networking terminal according to a video networking protocol, and is transmitted to the video networking server by the first terminal in a transparent transmission mode;
analyzing the database upgrading parameter information through the video networking protocol to acquire the database target information;
and under the condition that the local database needs to be upgraded according to the database target information, upgrading the local database according to the database target information.
2. The database upgrading method according to claim 1, wherein the database target information includes a database target version number, a database version description, and an added field;
the upgrading the local database according to the database target information comprises:
detecting whether the target version number of the database is higher than the corresponding version number of the local database;
under the condition that the target version number of the database is higher than the version number corresponding to the local database, acquiring a target installation package corresponding to the target version number of the database, and upgrading the local data by adopting an upgrading function according to the local database, the newly-added field, the database version description and the target installation package;
and the video network terminal determines the related functions of the database corresponding to the target version number of the database according to the database version description, the database corresponding to the target version number of the database supports the newly added fields, the upgraded local database comprises the newly added fields, and the version number corresponding to the upgraded local database is the same as the target version number of the database.
3. A data processing method is applied to a first terminal, and is characterized by comprising the following steps:
acquiring database target information corresponding to a video network terminal input by a target person;
packaging the database target information according to a video networking protocol to obtain database upgrading parameter information;
and transmitting the database upgrading parameter information to a video network server in a transparent transmission mode so that the video network server transmits the database upgrading parameter information to the video network terminal.
4. The data processing method according to claim 3, wherein the obtaining of the database target information corresponding to the terminal of the video network input by the target person comprises:
displaying an application interface corresponding to a target application program installed in the first terminal;
receiving the database target information input by the target person on the application interface;
wherein the database target information comprises: the target application program and the video network server form an interaction path.
5. A data transmission method is applied to a video network server and is characterized by comprising the following steps:
receiving database upgrading parameter information corresponding to a video networking terminal, which is sent by a first terminal in a transparent transmission mode, wherein the database upgrading parameter information is obtained by the first terminal by packaging the acquired database target information corresponding to the video networking terminal according to a video networking protocol;
and transmitting the database upgrading parameter information to the video networking terminal, so that the video networking terminal analyzes the database upgrading parameter information according to the video networking protocol, and upgrading a local database according to the database target information acquired after analysis.
6. A database upgrading device is applied to a video networking terminal and is characterized by comprising:
the first receiving module is used for receiving database upgrading parameter information corresponding to the video network terminal and sent by a video network server in a transparent transmission mode, wherein the database upgrading parameter information is obtained by packaging the acquired database target information corresponding to the video network terminal by the first terminal according to a video network protocol, and is transmitted to the video network server by the first terminal in a transparent transmission mode;
the first acquisition module is used for analyzing the database upgrading parameter information through the video networking protocol to acquire the database target information;
and the upgrading module is used for upgrading the local database according to the database target information under the condition that the local database needs to be upgraded according to the database target information.
7. A data processing apparatus applied to a first terminal, comprising:
the second acquisition module is used for acquiring database target information corresponding to the video network terminal input by a target person;
the third acquisition module is used for packaging the database target information according to a video networking protocol and acquiring the database upgrading parameter information;
and the sending module is used for sending the database upgrading parameter information to a video network server in a transparent transmission mode so that the video network server sends the database upgrading parameter information to the video network terminal.
8. A data transmission device is applied to a video network server and is characterized by comprising:
the second receiving module is used for receiving database upgrading parameter information corresponding to the video network terminal, which is sent by the first terminal in a transparent transmission mode, wherein the database upgrading parameter information is obtained by the first terminal by packaging the acquired database target information corresponding to the video network terminal according to a video network protocol;
and the transmission module is used for transmitting the database upgrading parameter information to the video networking terminal so that the video networking terminal analyzes the database upgrading parameter information according to the video networking protocol and upgrades the local database according to the database target information acquired after analysis.
9. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the steps of the database upgrade method according to any one of claims 1 to 2 or the data processing method according to any one of claims 3 to 4 or the data transmission method according to claim 5 are implemented by the processor when executing the computer program.
10. A computer-readable storage medium, characterized in that a computer program is stored on the computer-readable storage medium, which computer program, when being executed by a processor, carries out the steps of the database upgrade method according to any one of claims 1 to 2 or the data processing method according to any one of claims 3 to 4 or the data transmission method according to claim 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010814533.9A CN112115135A (en) | 2020-08-13 | 2020-08-13 | Database upgrading method, database processing method, database transmission method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010814533.9A CN112115135A (en) | 2020-08-13 | 2020-08-13 | Database upgrading method, database processing method, database transmission method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112115135A true CN112115135A (en) | 2020-12-22 |
Family
ID=73804096
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010814533.9A Pending CN112115135A (en) | 2020-08-13 | 2020-08-13 | Database upgrading method, database processing method, database transmission method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112115135A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113055277A (en) * | 2021-03-10 | 2021-06-29 | 维沃移动通信有限公司 | Message notification method, device and storage medium |
-
2020
- 2020-08-13 CN CN202010814533.9A patent/CN112115135A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113055277A (en) * | 2021-03-10 | 2021-06-29 | 维沃移动通信有限公司 | Message notification method, device and storage medium |
| CN113055277B (en) * | 2021-03-10 | 2023-04-25 | 维沃移动通信有限公司 | Message notification method, device and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101795392B (en) | Application data-downloading method, digital television receiving terminal and system | |
| US8191099B2 (en) | Automated analysis of collected field data for error detection | |
| US9848032B2 (en) | Method and apparatus for streaming metadata between devices using JavaScript and HTML5 | |
| US20020032754A1 (en) | Method and apparatus for profiling in a distributed application environment | |
| EP2854348B1 (en) | Interface display method and system of home gateway applicable to multiple display types | |
| CN103024528A (en) | Mobile terminal and method for transmitting streaming media data on mobile terminal | |
| US20190012138A1 (en) | Method and apparatus for providing speech service | |
| CN113783831B (en) | Internet of things information processing method, device and system | |
| CN106302103B (en) | Information processing method and system and application server | |
| CN108696523B (en) | Response method and device for call service | |
| US9853925B2 (en) | Automatic transformation of messages between service versions | |
| US10582271B2 (en) | On-demand captioning and translation | |
| US20130138770A1 (en) | Apparatus and method for sharing web contents using inspector script | |
| CN107276990B (en) | Streaming media live broadcasting method and device | |
| CN112449250B (en) | Method, device, equipment and medium for downloading video resources | |
| US9641908B2 (en) | Method and system for transferring real-time audio/video stream | |
| CN112115135A (en) | Database upgrading method, database processing method, database transmission method and device | |
| CN113727184A (en) | Video playing method, device, system, storage medium and electronic equipment | |
| KR20130139675A (en) | Server-based profile generation method, management method, system thereof and apparatus therefor | |
| CN115795212A (en) | Page display method and device, electronic equipment and storage medium | |
| WO2015161582A1 (en) | Method and device for processing message of iptv | |
| WO2017092315A1 (en) | Method and device for controlling television | |
| US20170142487A1 (en) | Methods and devices for recommending videos through bluetooth technology | |
| KR102015048B1 (en) | Method for installing application and multimedia device using broadcast streaming | |
| KR102401691B1 (en) | Method and apparatus for launching application in wireless communication system |
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 |