CN110825907B - Processing method and system based on distributed database - Google Patents
Processing method and system based on distributed database Download PDFInfo
- Publication number
- CN110825907B CN110825907B CN201810915796.1A CN201810915796A CN110825907B CN 110825907 B CN110825907 B CN 110825907B CN 201810915796 A CN201810915796 A CN 201810915796A CN 110825907 B CN110825907 B CN 110825907B
- Authority
- CN
- China
- Prior art keywords
- database
- video
- network
- simulation
- 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.)
- Active
Links
Images
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/10—Protocols in which an application is distributed across nodes in the network
- H04L67/1097—Protocols in which an application is distributed across nodes in the network for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS]
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L69/00—Network arrangements, protocols or services independent of the application payload and not provided for in the other groups of this subclass
- H04L69/08—Protocols for interworking; Protocol conversion
Abstract
The embodiment of the invention provides a processing method and a system based on a distributed database, wherein the method comprises the following steps: a first video network device accesses the simulation database service to the video network; the second video network equipment accesses the simulation client service to the video network; the first video network equipment calls the simulation database service to receive an access request of user equipment for accessing the distributed database; the first video network device calls the simulation database service to establish a video network link in the video network with the simulation client service according to the access request; and the second video network equipment calls the simulation client service to establish a local area network link with the distributed database. The user equipment can access the distributed data through the links of the video network and the local area network, the distributed database is realized in the video network, the development efficiency of the application of the design database is effectively improved, and the access speed and accuracy of the database data are also improved.
Description
Technical Field
The invention relates to the technical field of video networking, in particular to a processing method and a processing system based on a distributed database.
Background
The video networking is a real-time network, can realize the real-time transmission of the high definition video of the whole network that the present internet can not realize, push numerous internet applications to high definition video, high definition is face-to-face.
At present, databases are widely used in products of video networking, and because most databases support TCP (Transmission Control Protocol) connection access, when a video networking client accesses the database, the video networking server obtains data from the database, packages the data according to a certain format, and sends the data to the video networking server, and the video networking client receives and analyzes the data.
The process needs to develop a special service for the request of the database to solve the access request of the data, and needs to perform specific encapsulation and forwarding on the data, so that the efficiency is low, and the problem of poor adaptability exists because of the close binding with the service.
Disclosure of Invention
In view of the above, embodiments of the present invention are proposed to provide a distributed database-based processing method and system that overcome or at least partially solve the above problems.
According to an aspect of the present invention, there is provided a processing method based on a distributed database, in which a first video network device and a second video network device are deployed in a video network, an emulated database service is configured in the first video network device, and an emulated client service is configured in the second video network device, the method including:
the first video network device accesses the simulation database service to the video network;
the second video network equipment accesses the simulation client service to the video network;
the first video networking equipment calls the simulation database service to receive an access request of user equipment for accessing the distributed database;
the first video networking equipment calls the simulation database service to establish a video networking link in the video networking according to the access request and the simulation client service;
and the second video networking equipment calls the simulation client service to establish a local area network link with the distributed database.
Optionally, the distributed database has a plurality of sub-databases therein;
the first video network device calls the simulation database service to establish a video network link in the video network with the simulation client service according to the access request, and the method comprises the following steps:
reading a sub database to be accessed from the access request;
generating a database access instruction of the video network aiming at the sub-database;
and sending the database access instruction to the simulation client service through the video network so as to establish a video network link for the sub-database in the video network.
Optionally, the second internet of things device invoking the simulation client service to establish a local area network link with the distributed database, including:
inquiring a sub database to be accessed by the user equipment;
sending a connection request to the sub-database;
receiving a connection response returned by the sub database aiming at the connection request;
sending the connection reply to the simulation database service for transmission to the user equipment.
Optionally, the method further comprises:
the first video networking equipment calls the simulation database service to receive a database operation command of user equipment for the distributed database;
the first video networking equipment calls the simulation database service to send the database operation command to the simulation client service through the video networking link;
and the second video networking equipment calls the simulation client service to send the database operation command to the distributed database through the local area network link so as to perform database operation according to the database operation command.
Optionally, the user equipment and the distributed database apply a protocol of an IP network;
the first video network device calls the simulation database service to send the database operation command to the simulation client service through the video network link, and the method comprises the following steps:
carrying out protocol conversion from an IP network to a video network on the database operation command to obtain a video network command;
sending the video networking command to the simulation client service through the video networking link;
the second video networking device calls the simulation client service to send the database operation command to the distributed database through the local area network link so as to perform database operation according to the database operation command, and the method comprises the following steps:
carrying out protocol conversion from the video networking to an IP network on the video networking command to obtain a database operation command;
and sending the database operation command to a connected sub-database through the local area network link so as to perform database operation according to the database operation command.
Optionally, the method further comprises:
the second video networking equipment calls the simulation client service to receive a database operation result sent by the distributed database through the local area network link;
the second video networking equipment calls the simulation client service to send the database operation result to the simulation database service through the video networking link;
and the first video networking equipment calls the simulation database service to send the database operation result to the user equipment.
Optionally, the user equipment and the distributed database apply a protocol of an IP network;
the second video network device calls the simulation client service to send the database operation result to the simulation database service through the video network link, and the method comprises the following steps:
carrying out protocol conversion from an IP network to a video network on the operation result of the database to obtain an operation result of the video network;
sending the video networking operation result to the simulation database service through the video networking link;
the first video networking device calls the simulation database service to send the database operation result to the user equipment, and the method comprises the following steps:
carrying out protocol conversion from the video network to an IP network on the operation result of the video network to obtain an operation result of a database;
and sending the database operation result to the user equipment for displaying.
According to another aspect of the present invention, a processing system based on a distributed database is provided, a first video network device and a second video network device are deployed in a video network, a simulation database service is configured in the first video network device, and a simulation client service is configured in the second video network device;
the first video network equipment comprises a database network access module, an access request receiving module and a video network link establishing module, and the second video network equipment comprises a client network access module and a local area network link establishing module;
the database network access module is used for accessing the simulation database service to the video network;
the client network access module is used for accessing the simulation client service to the video network;
the access request receiving module is used for calling the simulation database service to receive an access request of user equipment for accessing the distributed database;
the video networking link establishing module is used for calling the simulation database service to establish a video networking link in the video networking with the simulation client service according to the access request;
and the local area network link establishing module is used for calling the simulation client service to establish a local area network link with the distributed database.
Optionally, the distributed database has a plurality of sub-databases therein;
the video networking link establishment module comprises:
a sub-database reading sub-module, configured to read a sub-database to be accessed from the access request;
a database access instruction generation sub-module, configured to generate a database access instruction of the video network for the sub-database;
and the database access instruction sending submodule is used for sending the database access instruction to the simulation client service through the video network so as to establish video network link for the sub-database in the video network.
Optionally, the local area network link establishing module includes:
a sub-database query sub-module, configured to query a sub-database to be accessed by the user equipment;
a connection request sending submodule for sending a connection request to the sub-database;
a connection response receiving submodule, configured to receive a connection response returned by the sub-database for the connection request;
and the connection response sending submodule is used for sending the connection response to the simulation database service so as to transmit the connection response to the user equipment.
Optionally, the first video networking device further comprises:
the database operation command receiving module is used for calling the simulation database service to receive a database operation command of the user equipment for the distributed database;
the operation command video link sending module is used for calling the simulation database service to send the database operation command to the simulation client service through the video link;
the second video network device further comprises:
and the operation command local area sending module is used for calling the simulation client service to send the database operation command to the distributed database through the local area network link so as to perform database operation according to the database operation command.
Optionally, the user equipment and the distributed database apply a protocol of an IP network;
the operation command video-on-demand sending module comprises:
the first command assistant rotor module is used for carrying out protocol conversion from an IP network to a video network on the database operation command to obtain a video network command;
the first command protocol forwarding sub-module is used for sending the video networking command to the simulation client service through the video networking link;
the operation command local area sending module comprises:
the second command assistant module is used for carrying out protocol conversion from the video network to the IP network on the video network command to obtain a database operation command;
and the second command protocol forwarding sub-module is used for sending the database operation command to a connected sub-database through the local area network link so as to perform database operation according to the database operation command.
Optionally, the second video networking device further comprises:
the database operation result receiving module is used for calling the simulation client service to receive the database operation result sent by the distributed database through the local area network link;
the operation result video-networking sending module is used for calling the simulation client-side service to send the database operation result to the simulation database service through the video-networking link;
the first video networking device further comprises:
and the operation result local area sending module is used for calling the simulation database service to send the database operation result to the user equipment.
Optionally, the user equipment and the distributed database apply a protocol of an IP network;
the operation result visual-connection sending module comprises:
the first result assistant module is used for carrying out protocol conversion from the IP network to the video network on the operation result of the database to obtain an operation result of the video network;
the first result forwarding submodule is used for sending the video networking operation result to the simulation database service through the video networking link;
the operation result local area sending module comprises:
the second result assistant module is used for carrying out protocol conversion from the video network to the IP network on the video network operation result to obtain a database operation result;
and the second result is transmitted to the submodule in a cooperative mode and is used for transmitting the database operation result to the user equipment for displaying.
The embodiment of the invention has the following advantages:
in the embodiment of the invention, a first video network device accesses the simulation database service into the video network, a second video network device accesses the simulation client service into the video network, the first video network device calls the simulation database service to receive an access request of a user device for accessing the distributed database, and establishing a video network link in the video network with the simulation client service according to the access request, and the second video network device calls the simulation client service to establish a local area network link with the distributed database, so that the user equipment can access the distributed data through the video network link and the local area network link, the distributed database is realized in the video network, the development efficiency of the application of the design database is effectively improved, the access speed and the accuracy of the database data are also improved, the method can get rid of the limitation on specific services, has good adaptability and effectively reduces repeated development.
Drawings
FIG. 1 is a networking diagram of a video network, according to one embodiment of the invention;
FIG. 2 is a diagram illustrating a hardware architecture of a node server according to an embodiment of the present invention;
fig. 3 is a schematic diagram of a hardware structure of an access switch according to an embodiment of the present invention;
fig. 4 is a schematic hardware structure diagram of an ethernet protocol conversion gateway according to an embodiment of the present invention;
FIG. 5 is a flow chart of the steps of a distributed database based processing method according to one embodiment of the present invention;
FIG. 6 is a flow chart of steps in another distributed database based processing method, in accordance with one embodiment of the present invention;
fig. 7 is a block diagram of a distributed database based processing system, in accordance with one embodiment of the present 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 video networking is an important milestone for network development, is a real-time network, can realize high-definition video real-time transmission, and pushes a plurality of internet applications to high-definition video, and high-definition faces each other.
The video networking adopts a real-time high-definition video exchange technology, can integrate required services such as dozens of services of video, voice, pictures, characters, communication, data and the like on a system platform on a network platform, such as high-definition video conference, video monitoring, intelligent monitoring analysis, emergency command, digital broadcast television, delayed television, network teaching, live broadcast, VOD on demand, television mail, Personal Video Recorder (PVR), intranet (self-office) channels, intelligent video broadcast control, information distribution and the like, and realizes high-definition quality video broadcast through a television or a computer.
To better understand the embodiments of the present invention, the following description refers to the internet of view:
some of the technologies applied in the video networking are as follows:
network Technology (Network Technology)
Network technology innovation in video networking has improved over traditional Ethernet (Ethernet) to face the potentially enormous video traffic on the network. Unlike pure network Packet Switching (Packet Switching) or network Circuit Switching (Circuit Switching), the Packet Switching is adopted by the technology of the video networking to meet the Streaming requirement. The video networking technology has the advantages of flexibility, simplicity and low price of packet switching, and simultaneously has the quality and safety guarantee of circuit switching, thereby realizing the seamless connection of the whole network switching type virtual circuit and the data format.
Switching Technology (Switching Technology)
The video network adopts two advantages of asynchronism and packet switching of the Ethernet, eliminates the defects of the Ethernet on the premise of full compatibility, has end-to-end seamless connection of the whole network, is directly communicated with a user terminal, and directly bears an IP data packet. The user data does not require any format conversion across the entire network. The video networking is a higher-level form of the Ethernet, is a real-time exchange platform, can realize the real-time transmission of the whole-network large-scale high-definition video which cannot be realized by the existing Internet, and pushes a plurality of network video applications to high-definition and unification.
Server Technology (Server Technology)
The server technology on the video networking and unified video platform is different from the traditional server, the streaming media transmission of the video networking and unified video platform is established on the basis of connection orientation, the data processing capacity of the video networking and unified video platform is independent of flow and communication time, and a single network layer can contain signaling and data transmission. For voice and video services, the complexity of video networking and unified video platform streaming media processing is much simpler than that of data processing, and the efficiency is greatly improved by more than one hundred times compared with that of a traditional server.
Storage Technology (Storage Technology)
The super-high speed storage technology of the unified video platform adopts the most advanced real-time operating system in order to adapt to the media content with super-large capacity and super-large flow, the program information in the server instruction is mapped to the specific hard disk space, the media content is not passed through the server any more, and is directly sent to the user terminal instantly, and the general waiting time of the user is less than 0.2 second. The optimized sector distribution greatly reduces the mechanical motion of the magnetic head track seeking of the hard disk, the resource consumption only accounts for 20% of that of the IP internet of the same grade, but concurrent flow which is 3 times larger than that of the traditional hard disk array is generated, and the comprehensive efficiency is improved by more than 10 times.
Network Security Technology (Network Security Technology)
The structural design of the video network completely eliminates the network security problem troubling the internet structurally by the modes of independent service permission control each time, complete isolation of equipment and user data and the like, generally does not need antivirus programs and firewalls, avoids the attack of hackers and viruses, and provides a structural carefree security network for users.
Service Innovation Technology (Service Innovation Technology)
The unified video platform integrates services and transmission, and is not only automatically connected once whether a single user, a private network user or a network aggregate. The user terminal, the set-top box or the PC are directly connected to the unified video platform to obtain various multimedia video services in various forms. The unified video platform adopts a menu type configuration table mode to replace the traditional complex application programming, can realize complex application by using very few codes, and realizes infinite new service innovation.
Networking of the video network is as follows:
the video network is a centralized control network structure, and the network can be a tree network, a star network, a ring network and the like, but on the basis of the centralized control node, the whole network is controlled by the centralized control node in the network.
As shown in fig. 1, the video network is divided into an access network and a metropolitan network.
The devices of the access network part can be mainly classified into 3 types: node server, access switch, terminal (including various set-top boxes, coding boards, memories, etc.). The node server is connected to an access switch, which may be connected to a plurality of terminals and may be connected to an ethernet network.
The node server is a node which plays a centralized control function in the access network and can control the access switch and the terminal. The node server may be directly connected to the access switch or may be directly connected to the terminal.
Similarly, devices of the metropolitan network portion may also be classified into 3 types: a metropolitan area server, a node switch and a node server. The metro server is connected to a node switch, which may be connected to a plurality of node servers.
The node server is a node server of the access network part, namely the node server belongs to both the access network part and the metropolitan area network part.
The metropolitan area server is a node which plays a centralized control function in the metropolitan area network and can control a node switch and a node server. The metropolitan area server can be directly connected with the node switch or directly connected with the node server.
Therefore, the whole video network is a network structure with layered centralized control, and the network controlled by the node server and the metropolitan area server can be in various structures such as tree, star and ring.
The access network part can form a unified video platform (the part in the dotted circle), and a plurality of unified video platforms can form a video network; each unified video platform may interconnect and interwork via metropolitan and wide area video networks.
Visio networking device classification
1.1 devices in the video network of the embodiment of the present invention can be mainly classified into 3 types: servers, switches (including ethernet gateways), terminals (including various set-top boxes, code boards, memories, etc.). The video network as a whole can be divided into a metropolitan area network (or national network, global network, etc.) and an access network.
1.2 wherein the devices of the access network part can be mainly classified into 3 types: node servers, access switches (including ethernet gateways), terminals (including various set-top boxes, code boards, memories, etc.).
The specific hardware structure of each access network device is as follows:
a node server:
as shown in fig. 2, the system mainly includes a network interface module 201, a switching engine module 202, a CPU module 203, and a disk array module 204;
the network interface module 201, the CPU module 203, and the disk array module 204 all enter the switching engine module 202; the switching engine module 202 performs an operation of looking up the address table 205 on the incoming packet, thereby obtaining the direction information of the packet; and stores the packet in a queue of the corresponding packet buffer 206 based on the packet's steering information; if the queue of the packet buffer 206 is nearly full, it is discarded; the switching engine module 202 polls all packet buffer queues for forwarding if the following conditions are met: 1) the port send buffer is not full; 2) the queue packet counter is greater than zero. The disk array module 204 mainly implements control over the hard disk, including initialization, read-write, and other operations on the hard disk; the CPU module 203 is mainly responsible for protocol processing with an access switch and a terminal (not shown in the figure), configuring an address table 205 (including a downlink protocol packet address table, an uplink protocol packet address table, and a data packet address table), and configuring the disk array module 204.
The access switch:
as shown in fig. 3, the network interface module mainly includes a network interface module (a downlink network interface module 301 and an uplink network interface module 302), a switching engine module 303 and a CPU module 304;
wherein, the packet (uplink data) coming from the downlink network interface module 301 enters the packet detection module 305; the packet detection module 305 detects whether the Destination Address (DA), the Source Address (SA), the packet type, and the packet length of the packet meet the requirements, if so, allocates a corresponding stream identifier (stream-id) and enters the switching engine module 303, otherwise, discards the stream identifier; the packet (downstream data) coming from the upstream network interface module 302 enters the switching engine module 303; the data packet coming from the CPU module 204 enters the switching engine module 303; the switching engine module 303 performs an operation of looking up the address table 306 on the incoming packet, thereby obtaining the direction information of the packet; if the packet entering the switching engine module 303 is from the downstream network interface to the upstream network interface, the packet is stored in the queue of the corresponding packet buffer 307 in association with the stream-id; if the queue of the packet buffer 307 is nearly full, it is discarded; if the packet entering the switching engine module 303 is not from the downlink network interface to the uplink network interface, the data packet is stored in the queue of the corresponding packet buffer 307 according to the guiding information of the packet; if the queue of the packet buffer 307 is nearly full, it is discarded.
The switching engine module 303 polls all packet buffer queues, which in this embodiment of the invention is divided into two cases:
if the queue is from the downlink network interface to the uplink network interface, the following conditions are met for forwarding: 1) the port send buffer is not full; 2) the queued packet counter is greater than zero; 3) obtaining a token generated by a code rate control module;
if the queue is not from the downlink network interface to the uplink network interface, the following conditions are met for forwarding: 1) the port send buffer is not full; 2) the queue packet counter is greater than zero.
The rate control module 208 is configured by the CPU module 204, and generates tokens for packet buffer queues from all downlink network interfaces to the uplink network interfaces at programmable intervals to control the rate of uplink forwarding.
The CPU module 304 is mainly responsible for protocol processing with the node server, configuration of the address table 306, and configuration of the code rate control module 308.
Ethernet co-rotating gateway：
As shown in fig. 4, the apparatus mainly includes a network interface module (a downlink network interface module 401 and an uplink network interface module 402), a switching engine module 403, a CPU module 404, a packet detection module 405, a rate control module 408, an address table 406, a packet buffer 407, a MAC adding module 409, and a MAC deleting module 410.
Wherein, the data packet coming from the downlink network interface module 401 enters the packet detection module 405; the packet detection module 405 detects whether the ethernet MAC DA, the ethernet MAC SA, the ethernet length or frame type, the video network destination address DA, the video network source address SA, the video network packet type, and the packet length of the packet meet the requirements, and if so, allocates a corresponding stream identifier (stream-id); then, the MAC deletion module 410 subtracts MAC DA, MAC SA, length or frame type (2byte) and enters the corresponding receiving buffer, otherwise, discards it;
the downlink network interface module 401 detects the sending buffer of the port, and if there is a packet, obtains the ethernet MAC DA of the corresponding terminal according to the destination address DA of the packet, adds the ethernet MAC DA of the terminal, the MAC SA of the ethernet protocol gateway, and the ethernet length or frame type, and sends the packet.
The other modules in the ethernet protocol gateway function similarly to the access switch.
A terminal:
the system mainly comprises a network interface module, a service processing module and a CPU module; for example, the set-top box mainly comprises a network interface module, a video and audio coding and decoding engine module and a CPU module; the coding board mainly comprises a network interface module, a video and audio coding engine module and a CPU module; the memory mainly comprises a network interface module, a CPU module and a disk array module.
1.3 devices of the metropolitan area network part can be mainly classified into 2 types: node server, node exchanger, metropolitan area server. The node switch mainly comprises a network interface module, a switching engine module and a CPU module; the metropolitan area server mainly comprises a network interface module, a switching engine module and a CPU module.
2. Video networking packet definition
2.1 Access network packet definition
The data packet of the access network mainly comprises the following parts: destination Address (DA), Source Address (SA), reserved bytes, payload (pdu), CRC.
As shown in the following table, the data packet of the access network mainly includes the following parts:
| DA | SA | Reserved | Payload | CRC |
wherein:
the Destination Address (DA) is composed of 8 bytes (byte), the first byte represents the type of the data packet (such as various protocol packets, multicast data packets, unicast data packets, etc.), there are 256 possibilities at most, the second byte to the sixth byte are metropolitan area network addresses, and the seventh byte and the eighth byte are access network addresses;
the Source Address (SA) is also composed of 8 bytes (byte), defined as the same as the Destination Address (DA);
the reserved byte consists of 2 bytes;
the payload part has different lengths according to different types of datagrams, and is 64 bytes if the datagram is various types of protocol packets, and is 32+1024 or 1056 bytes if the datagram is a unicast packet, of course, the length is not limited to the above 2 types;
the CRC consists of 4 bytes and is calculated in accordance with the standard ethernet CRC algorithm.
2.2 packet definition for metropolitan area networks
The topology of a metropolitan area network is a graph and there may be 2, or even more than 2, connections between two devices, i.e., there may be more than 2 connections between a node switch and a node server, a node switch and a node switch, and a node switch and a node server. However, the address of the metro network device is unique, and in order to accurately describe the connection relationship between the metro network devices, parameters are introduced in the embodiment of the present invention: a label to uniquely describe a metropolitan area network device.
In this specification, the definition of the Label is similar to that of the Label of MPLS (Multi-Protocol Label Switch), and assuming that there are two connections between the device a and the device B, there are 2 labels for the packet from the device a to the device B, and 2 labels for the packet from the device B to the device a. The label is classified into an incoming label and an outgoing label, and assuming that the label (incoming label) of the packet entering the device a is 0x0000, the label (outgoing label) of the packet leaving the device a may become 0x 0001. The network access process of the metro network is a network access process under centralized control, that is, address allocation and label allocation of the metro network are both dominated by the metro server, and the node switch and the node server are both passively executed, which is different from label allocation of MPLS, and label allocation of MPLS is a result of mutual negotiation between the switch and the server.
As shown in the following table, the data packet of the metro network mainly includes the following parts:
| DA | SA | Reserved | label (R) | Payload | CRC |
Namely Destination Address (DA), Source Address (SA), Reserved byte (Reserved), tag, payload (pdu), CRC. The format of the tag may be defined by reference to the following: the tag is 32 bits with the upper 16 bits reserved and only the lower 16 bits used, and its position is between the reserved bytes and payload of the packet.
Referring to fig. 5, a flowchart of steps of a distributed database based processing method according to an embodiment of the present invention is shown, where a first video network device and a second video network device, such as a set top box, a corotation gateway, a video network server, and the like, are deployed in a video network, a simulation database service is configured in the first video network device, and a simulation client service is configured in the second video network device.
The simulation database service and the simulation client service may refer to services simulating a database and a client, such as an operation interface simulating a database and an instruction simulating a client, so that the operation of the simulation database service and the simulation client service is the same as or similar to that of a real database and a real client.
The method specifically comprises the following steps:
step 501, the first video network device accesses the simulation database service to the video network.
The first video network equipment stores a configuration file, the configuration file stores configuration information of the video network, and the simulation database is accessed to the video network according to the configuration information.
In one embodiment, the visual networking server may send a network entry instruction to the simulation database service:
after receiving the network access instruction, the simulation database service can compare the time version of the set-top box menu of the video network server with the locally stored time version, and report a network access confirmation instruction to the video network server:
step 502, the second video network device accesses the emulated client service to the video network.
The second video network device stores a configuration file, the configuration file stores configuration information of the video network, and the simulation client service is accessed to the video network according to the configuration information.
In one embodiment, the video networking server may send a network access instruction to the simulation client service, and after receiving the network access instruction, the simulation client service may compare the time version of the set-top box menu of the video networking server with the locally stored time version, and report a network access confirmation instruction to the video networking server.
Further, the distributed database includes a plurality of sub-databases, the second video network device may configure a plurality of simulation clients correspondingly, that is, the simulation clients correspond to the sub-databases one to one, each sub-database provides an access port, and each simulation client is assigned with a video network number, so that a mapping relationship between the access port and the video network number may be established.
Step 503, the first internet of things device calls the simulation database service to receive an access request of the user device for accessing the distributed database.
When accessing the distributed database, the user can log in user equipment, such as a mobile terminal, a personal computer and the like, and connect the simulation database service in the first video network equipment.
The distributed database comprises a plurality of sub-databases, and the user equipment can generate an access request aiming at a certain sub-database, configure corresponding information such as port numbers, account numbers, passwords and the like, and send the information to the first video networking equipment.
Further, the user equipment may be located in an IP (Internet Protocol, Protocol for interconnection between networks) network, the first video network device configures a network card of the IP network and a network card of the video network, and may communicate with the IP network and the video network simultaneously, and the emulation database service in the first video network device may receive an access request of the user equipment through the network card of the IP network.
Step 504, the first video networking device calls the simulation database service to establish a video networking link in the video networking with the simulation client service according to the access request.
In a first video networking device, the emulation database service establishes a video networking link with the emulation client service in the video networking according to a protocol of the video networking in response to an access request of the user device.
In an embodiment of the present invention, the distributed database has a plurality of sub-databases, and in an embodiment of the present invention, step 504 may include the following sub-steps:
and a substep S11, reading the sub database to be accessed from the access request.
Substep S12, generating a database access instruction of the video network for the sub-database.
Substep S13, sending the database access instruction to the simulation client service through the video network, so as to establish a video network link for the sub-database in the video network.
In the embodiment of the invention, the simulation database service analyzes the access request and reads the port number to identify the sub-database to be accessed by the user equipment.
For the sub-database, configuring information such as a port number, an account number, a password, and the like, and generating a database access instruction of the video network, such as 8e 01:
and sending the database access instruction to the video network, namely a video network server, and sending the database access instruction to the second video network equipment by the video network server.
The emulation client service in the second video network device receives the database access instruction and establishes a video network link in the video network for the sub-database.
And 505, the second video networking device calls the simulation client service to establish a local area network link with the distributed database.
The distributed database is positioned in the local area network, a TCP protocol can be used, the second video network equipment configures a network card of an IP network and a network card of the video network, the second video network equipment can simultaneously communicate with the IP network and the video network, and the simulation client service in the second video network equipment can be linked with the distributed database resume local area network through the network card of the IP network.
In one embodiment of the present invention, step 505 may comprise the following sub-steps:
and a substep S21, querying a sub-database to be accessed by the user equipment.
Substep S22, sending a connection request to the sub-database.
And a substep S23 of receiving a connection response returned by the sub database for the connection request.
Substep S24, sending the connection reply to the emulation database service for transmission to the user equipment.
In the embodiment of the invention, the simulation client service analyzes information such as a port number, an account number, a password and the like from the database access instruction of the simulation database service so as to identify the sub-database to be accessed by the user equipment.
The simulation client service generates a connection request, accesses an access port corresponding to the port number, and therefore accesses the sub-database to verify information such as account numbers and passwords, after the information such as the account numbers and the passwords is verified, the sub-database generates a connection response and sends the connection response to the simulation client service, the simulation client service sends the connection response to the simulation database service through a video network link, the simulation database service transmits the connection response to user equipment, and the user equipment displays the connection response to a user to prompt that the distributed database is successfully connected.
In the embodiment of the invention, a first video network device accesses the simulation database service into the video network, a second video network device accesses the simulation client service into the video network, the first video network device calls the simulation database service to receive an access request of a user device for accessing the distributed database, and establishing a video network link in the video network with the simulation client service according to the access request, and calling the simulation client service to establish a local area network link with the distributed database by the second video network device so that the user equipment can access the distributed data through the video network link and the local area network link, the distributed database is realized in the video network, the development efficiency of the application of the design database is effectively improved, the access speed and the accuracy of the database data are also improved, the method can get rid of the limitation on specific services, has good adaptability and effectively reduces repeated development.
Referring to fig. 6, a flowchart illustrating steps of another distributed database-based processing method according to an embodiment of the present invention is shown, where a first video network device and a second video network device are deployed in a video network, a simulation database service is configured in the first video network device, and a simulation client service is configured in the second video network device, and the method specifically includes the following steps:
And the user equipment loads an operation interface provided by the distributed database, and generates a database operation command when the user operates the operation interface.
Taking MySQL data as an example, the database operation command may include at least one of the following:
create database name-creating a database
use database entry database
drop database name-delete database without hint
show tables-display tables
Descriptbe table-structure of viewing table
Adding distint-removing repeated field in select
mysql in drop database-before deleting a database, a prompt is given
select version (), current _ date — show the current mysql version and current date
The database operation commands are sent to the first video network equipment through a TCP protocol, and the first video network equipment receives the database operation commands through a network card of an IP network.
In a specific implementation, the user equipment and the distributed database apply a protocol of an IP network, such as the TCP protocol.
Therefore, the simulation database service can perform protocol conversion from the IP network to the video network on the database operation command, obtain the video network command, and send the video network command to the simulation client service through the video network link.
In a specific implementation, the user equipment and the distributed database apply a protocol of an IP network, such as the TCP protocol.
Therefore, the simulation client service can perform protocol conversion from the video network to the IP network on the video network command to obtain a database operation command, and sends the database operation command to the connected sub-database through the local area network link so as to perform database operation according to the database operation command.
After the distributed database is operated, the database operation result is obtained and sent to the simulation client service in the second video network equipment through the local area network link.
In a specific implementation, the user equipment and the distributed database apply a protocol of an IP network, such as the TCP protocol.
Therefore, the simulation client service can perform protocol conversion from the IP network to the video network on the database operation result to obtain the video network operation result, and the video network operation result is sent to the simulation database service through the video network link.
In a specific implementation, the user equipment and the distributed database apply a protocol of an IP network, such as the TCP protocol.
Therefore, the simulation database service can perform protocol conversion from the video network to the IP network on the video network operation result, obtain the database operation result, and send the database operation result to the user equipment for display.
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. 7, a block diagram of a distributed database-based processing system according to an embodiment of the present invention is shown, a first video network device 710 and a second video network device 720 are deployed in a video network, an emulated database service is configured in the first video network device 710, and an emulated client service is configured in the second video network device 720;
the first video network device 710 comprises a database network access module 711, an access request receiving module 712 and a video network link establishing module 713, and the second video network device 720 comprises a client network access module 721 and a local area network link establishing module 722;
a database access module 711, configured to access the simulation database service to the internet of view;
a client network access module 721, configured to access the emulated client service to the video network;
an access request receiving module 712, configured to invoke the simulation database service to receive an access request for accessing a distributed database by a user equipment;
an internet of view link establishing module 713, configured to invoke the simulation database service to establish an internet of view link in the internet of view with the simulation client service according to the access request;
a local area network link establishing module 722, configured to invoke the simulation client service to establish a local area network link with the distributed database.
In one embodiment of the invention, the distributed database has a plurality of sub-databases therein;
the video network link establishment module 713 includes:
a sub-database reading sub-module, configured to read a sub-database to be accessed from the access request;
a database access instruction generation sub-module, configured to generate a database access instruction of the video network for the sub-database;
and the database access instruction sending submodule is used for sending the database access instruction to the simulation client service through the video network so as to establish video network link for the sub-database in the video network.
In an embodiment of the present invention, the lan link establishing module 822 includes:
a sub-database query sub-module, configured to query a sub-database to be accessed by the user equipment;
a connection request sending submodule for sending a connection request to the sub-database;
a connection response receiving submodule, configured to receive a connection response returned by the sub-database for the connection request;
and the connection response sending submodule is used for sending the connection response to the simulation database service so as to transmit the connection response to the user equipment.
In one embodiment of the present invention, the first video networking device 710 further comprises:
the database operation command receiving module is used for calling the simulation database service to receive a database operation command of the user equipment for the distributed database;
the operation command video link sending module is used for calling the simulation database service to send the database operation command to the simulation client service through the video link;
the second video networking device 720 further comprises:
and the operation command local area sending module is used for calling the simulation client service to send the database operation command to the distributed database through the local area network link so as to perform database operation according to the database operation command.
In one embodiment of the invention, the user equipment and the distributed database apply a protocol of an IP network;
the operation command video-on-demand sending module comprises:
the first command assistant rotor module is used for carrying out protocol conversion from an IP network to a video network on the database operation command to obtain a video network command;
the first command protocol forwarding sub-module is used for sending the video networking command to the simulation client service through the video networking link;
the operation command local area sending module comprises:
the second command assistant module is used for carrying out protocol conversion from the video network to the IP network on the video network command to obtain a database operation command;
and the second command protocol forwarding sub-module is used for sending the database operation command to a connected sub-database through the local area network link so as to perform database operation according to the database operation command.
In one embodiment of the present invention, the second video networking device 720 further comprises:
the database operation result receiving module is used for calling the simulation client service to receive the database operation result sent by the distributed database through the local area network link;
the operation result video link sending module is used for calling the simulation client service to send the database operation result to the simulation database service through the video link;
the first video network device 710 further comprises:
and the operation result local area sending module is used for calling the simulation database service to send the database operation result to the user equipment.
In one embodiment of the invention, the user equipment and the distributed database apply a protocol of an IP network;
the operation result visual-connection sending module comprises:
the first result assistant module is used for carrying out protocol conversion from the IP network to the video network on the operation result of the database to obtain an operation result of the video network;
the first result forwarding submodule is used for sending the video networking operation result to the simulation database service through the video networking link;
the operation result local area sending module comprises:
the second result assistant module is used for carrying out protocol conversion from the video network to the IP network on the video network operation result to obtain a database operation result;
and the second result is transmitted to the submodule in a cooperative mode and is used for transmitting the database operation result to the user equipment for displaying.
For the system 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.
In the embodiment of the invention, a first video network device accesses the simulation database service into the video network, a second video network device accesses the simulation client service into the video network, the first video network device calls the simulation database service to receive an access request of a user device for accessing the distributed database, and establishing a video network link in the video network with the simulation client service according to the access request, and the second video network device calls the simulation client service to establish a local area network link with the distributed database, so that the user equipment can access the distributed data through the video network link and the local area network link, the distributed database is realized in the video network, the development efficiency of the application of the design database is effectively improved, the access speed and the accuracy of the database data are also improved, the method can get rid of the limitation on specific services, has good adaptability and effectively reduces repeated development.
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 apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing 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 identical elements in the process, method, article, or terminal equipment comprising the element.
The above detailed description is provided for a processing method based on a distributed database and a processing system based on a distributed database, and a specific example is applied in the text 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 processing method based on a distributed database is characterized in that a first video network device and a second video network device are deployed in a video network, an emulation database service is configured in the first video network device, and an emulation client service is configured in the second video network device, and the method comprises the following steps:
the first video network device accesses the simulation database service to the video network;
the second video network equipment accesses the simulation client service to the video network;
the first video networking equipment calls the simulation database service to receive an access request of user equipment for accessing the distributed database;
the first video networking equipment calls the simulation database service to establish a video networking link in the video networking according to the access request and the simulation client service;
and the second video network equipment calls the simulation client service to establish a local area network link with the distributed database.
2. The method of claim 1, wherein the distributed database has a plurality of sub-databases therein;
the first video network device calls the simulation database service to establish a video network link in the video network with the simulation client service according to the access request, and the method comprises the following steps:
reading a sub database to be accessed from the access request;
generating a database access instruction of the video network aiming at the sub-database;
and sending the database access instruction to the simulation client service through the video network so as to establish a video network link for the sub-database in the video network.
3. The method of claim 1, wherein the second video networking device invoking the emulated client service to establish a local area network link with the distributed database comprises:
inquiring a sub database to be accessed by the user equipment;
sending a connection request to the sub-database;
receiving a connection response returned by the sub database aiming at the connection request;
sending the connection reply to the simulation database service for transmission to the user equipment.
4. The method according to any one of claims 1-3, further comprising:
the first video networking equipment calls the simulation database service to receive a database operation command of user equipment for the distributed database;
the first video networking equipment calls the simulation database service to send the database operation command to the simulation client service through the video networking link;
and the second video networking equipment calls the simulation client service to send the database operation command to the distributed database through the local area network link so as to perform database operation according to the database operation command.
5. The method of claim 4, wherein the user device is in a protocol of an IP network with the distributed database;
the first video network device calls the simulation database service to send the database operation command to the simulation client service through the video network link, and the method comprises the following steps:
carrying out protocol conversion from an IP network to a video network on the database operation command to obtain a video network command;
sending the video networking command to the simulation client service through the video networking link;
the second video networking device calls the simulation client service to send the database operation command to the distributed database through the local area network link so as to perform database operation according to the database operation command, and the method comprises the following steps:
carrying out protocol conversion from the video networking to an IP network on the video networking command to obtain a database operation command;
and sending the database operation command to a connected sub-database through the local area network link so as to perform database operation according to the database operation command.
6. The method of claim 4, further comprising:
the second video network equipment calls the simulation client side service to receive a database operation result sent by the distributed database through the local area network link;
the second video networking equipment calls the simulation client service to send the database operation result to the simulation database service through the video networking link;
and the first video networking equipment calls the simulation database service to send the database operation result to the user equipment.
7. The method of claim 6, wherein the user device is in a protocol of an IP network with the distributed database;
the second video network device calls the simulation client service to send the database operation result to the simulation database service through the video network link, and the method comprises the following steps:
carrying out protocol conversion from an IP network to a video network on the operation result of the database to obtain an operation result of the video network;
sending the video networking operation result to the simulation database service through the video networking link;
the first video networking device calls the simulation database service to send the database operation result to the user equipment, and the method comprises the following steps:
carrying out protocol conversion from the video network to an IP network on the operation result of the video network to obtain an operation result of a database;
and sending the database operation result to the user equipment for displaying.
8. A processing system based on a distributed database is characterized in that a first video network device and a second video network device are deployed in a video network, a simulation database service is configured in the first video network device, and a simulation client service is configured in the second video network device;
the first video network equipment comprises a database network access module, an access request receiving module and a video network link establishing module, and the second video network equipment comprises a client network access module and a local area network link establishing module;
the database network access module is used for accessing the simulation database service to the video network;
the client network access module is used for accessing the simulation client service to the video network;
the access request receiving module is used for calling the simulation database service to receive an access request of user equipment for accessing the distributed database;
the video networking link establishing module is used for calling the simulation database service to establish a video networking link in the video networking with the simulation client service according to the access request;
and the local area network link establishing module is used for calling the simulation client service to establish a local area network link with the distributed database.
9. The system of claim 8, wherein the distributed database has a plurality of sub-databases therein;
the video networking link establishment module comprises:
a sub-database reading sub-module, configured to read a sub-database to be accessed from the access request;
a database access instruction generation sub-module, configured to generate a database access instruction of the video network for the sub-database;
and the database access instruction sending submodule is used for sending the database access instruction to the simulation client service through the video network so as to establish video network link for the sub-database in the video network.
10. The system of claim 8, wherein the lan link establishment module comprises:
a sub-database query sub-module, configured to query a sub-database to be accessed by the user equipment;
a connection request sending submodule for sending a connection request to the sub-database;
a connection response receiving sub-module, configured to receive a connection response returned by the sub-database for the connection request;
and the connection response sending submodule is used for sending the connection response to the simulation database service so as to transmit the connection response to the user equipment.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810915796.1A CN110825907B (en) | 2018-08-13 | 2018-08-13 | Processing method and system based on distributed database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810915796.1A CN110825907B (en) | 2018-08-13 | 2018-08-13 | Processing method and system based on distributed database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110825907A CN110825907A (en) | 2020-02-21 |
| CN110825907B true CN110825907B (en) | 2022-06-21 |
Family
ID=69546781
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810915796.1A Active CN110825907B (en) | 2018-08-13 | 2018-08-13 | Processing method and system based on distributed database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110825907B (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102393793A (en) * | 2004-06-04 | 2012-03-28 | B·F·加萨比安 | Systems to enhance data entry in mobile and fixed environment |
| CN106331581A (en) * | 2015-07-06 | 2017-01-11 | 北京视联动力国际信息技术有限公司 | Method and device for communication between mobile terminal and video networking terminal |
| CN108075920A (en) * | 2016-11-14 | 2018-05-25 | 北京视联动力国际信息技术有限公司 | A kind of management method and system regarding networked terminals |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8151310B2 (en) * | 2006-10-13 | 2012-04-03 | Schlumberger Technology Corporation | Video delivery of oilfield data |
-
2018
- 2018-08-13 CN CN201810915796.1A patent/CN110825907B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102393793A (en) * | 2004-06-04 | 2012-03-28 | B·F·加萨比安 | Systems to enhance data entry in mobile and fixed environment |
| CN106331581A (en) * | 2015-07-06 | 2017-01-11 | 北京视联动力国际信息技术有限公司 | Method and device for communication between mobile terminal and video networking terminal |
| CN108075920A (en) * | 2016-11-14 | 2018-05-25 | 北京视联动力国际信息技术有限公司 | A kind of management method and system regarding networked terminals |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110825907A (en) | 2020-02-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109167960B (en) | Method and system for processing video stream data | |
| CN109040658B (en) | Conference control method and device | |
| CN109996086B (en) | Method and device for inquiring service state of video networking | |
| CN111193788A (en) | Audio and video stream load balancing method and device | |
| CN109547163B (en) | Method and device for controlling data transmission rate | |
| CN111092863B (en) | Method, client, server, device and medium for accessing internet website | |
| CN110022295B (en) | Data transmission method and video networking system | |
| CN108965226B (en) | Data acquisition method and device based on video network | |
| CN109347844B (en) | Method and device for accessing equipment to Internet | |
| CN109151519B (en) | Configuration distribution method and system based on video network | |
| CN110266577B (en) | Tunnel establishment method and video networking system | |
| CN110022353B (en) | Service sharing method and video networking system | |
| CN109640194B (en) | Method and device for acquiring terminal permission through two-dimensional code based on video network | |
| CN110336710B (en) | Terminal testing method, system and device and storage medium | |
| CN110087147B (en) | Audio and video stream transmission method and device | |
| CN109769012B (en) | Web server access method and device | |
| CN109889516B (en) | Method and device for establishing session channel | |
| CN110391922B (en) | Version prompting method and device for service platform | |
| CN110677315A (en) | Method and system for monitoring state | |
| CN110808896B (en) | Data transmission method and device, electronic equipment and storage medium | |
| CN110536148B (en) | Live broadcasting method and equipment based on video networking | |
| CN110636110B (en) | Monitoring data flow adjusting method and device | |
| CN110572367B (en) | Method, system, server, device and storage medium for modifying terminal name | |
| CN110493311B (en) | Service processing method and device | |
| CN109495709B (en) | Video network management system and method |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |