CN110377403A - A kind of processing method and processing device of database access - Google Patents

A kind of processing method and processing device of database access Download PDF

Info

Publication number
CN110377403A
CN110377403A CN201910512063.8A CN201910512063A CN110377403A CN 110377403 A CN110377403 A CN 110377403A CN 201910512063 A CN201910512063 A CN 201910512063A CN 110377403 A CN110377403 A CN 110377403A
Authority
CN
China
Prior art keywords
database
database access
access command
view networking
dispatch server
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
Application number
CN201910512063.8A
Other languages
Chinese (zh)
Inventor
李明亮
沈军
杨传坤
白强
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Visionvera Information Technology Co Ltd
Original Assignee
Visionvera Information Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Visionvera Information Technology Co Ltd filed Critical Visionvera Information Technology Co Ltd
Priority to CN201910512063.8A priority Critical patent/CN110377403A/en
Publication of CN110377403A publication Critical patent/CN110377403A/en
Pending legal-status Critical Current

Links

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/24—Querying
    • G06F16/245—Query processing
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00—Arrangements for program control, e.g. control units
    • G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/46—Multiprogramming arrangements
    • G06F9/48—Program initiating; Program switching, e.g. by interrupt
    • G06F9/4806—Task transfer initiation or dispatching
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00—Arrangements for program control, e.g. control units
    • G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/46—Multiprogramming arrangements
    • G06F9/48—Program initiating; Program switching, e.g. by interrupt
    • G06F9/4806—Task transfer initiation or dispatching
    • G06F9/4843—Task transfer initiation or dispatching by program, e.g. task dispatcher, supervisor, operating system

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Software Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Data Exchanges In Wide-Area Networks (AREA)

Abstract

The embodiment of the invention provides a kind of processing method and processing devices of database access, the method is applied to view networking, the view networking is connect with ethernet communication, wherein, include distributed data base frame system in view networking, includes view networking pipe monitoring and dispatching system, dispatch server, primary database and from database in the Ethernet；The distributed data base frame system is communicated to connect with view networking pipe monitoring and dispatching system, the dispatch server respectively, the dispatch server respectively with the primary database, described connect from database communication；The embodiment of the present invention will be assigned in two databases depending on the pressure for reading and writing database manipulation in networking pipe monitoring and dispatching system, it ensure that the write operation that will not influence in view networking service depending on the read operation in networking service, the processing speed and response speed of the upper-layer service logic of view networking pipe monitoring and dispatching system are improved, to improve the performance of view networking pipe monitoring and scheduling system indirectly.

Description

A kind of processing method and processing device of database access
Technical field
The present invention relates to technical field of data processing, more particularly to the processing method and dress of a kind of database access It sets and a kind of computer readable storage medium.
Background technique
When regarding networked resources overabundance of data, a large amount of high concurrent reads and writes the same database, can be to the property of system It can impact.
Summary of the invention
In view of the above problems, it proposes the embodiment of the present invention and overcomes the above problem or at least partly in order to provide one kind A kind of processing method of the database access to solve the above problems, a kind of processing unit of database access and a kind of calculating Machine readable storage medium storing program for executing.
To solve the above-mentioned problems, the embodiment of the invention discloses a kind of processing method of database access, the methods It networks applied to view, the view networking is connect with ethernet communication, wherein include distributed data base frame in the view networking System includes view networking pipe monitoring and dispatching system, dispatch server, primary database and from database in the Ethernet；It is described Distributed data base frame system is communicated to connect with view networking pipe monitoring and dispatching system, the dispatch server respectively, institute State dispatch server respectively with the primary database, described connect from database communication；The described method includes:
The distributed data base frame system receives the database access that the view networking pipe monitoring and dispatching system is sent Order；Wherein, the database access command is by the triggering for receiving access database depending on networking pipe monitoring and dispatching system It is generated when operation；
The database access command is sent to the dispatch server by the distributed data base frame system；It is described Dispatch server is used to judge the type of the database access command, if the type of the database access command is write-in class The database access command is then sent to the primary database by type, if the type of the database access command is to read The database access command is then sent to described from database by type.
Further, the distributed data base frame system includes the multiple distributed subsystems for being in communication with each other connection； The database access command includes the access address of the database；
When view networking pipe monitoring and dispatching system is located at different local area networks from the dispatch server, the distribution Formula database framework system receives the sub-step of database access command sent depending on networking pipe monitoring and dispatching system
First distributed subsystem receives what the view networking pipe monitoring and dispatching system was sent by Internet protocol Database access command；
The database access command is sent to the son of the dispatch server by the distributed data base frame system Step includes:
First distributed subsystem is determining to be located at same local area network with the access address according to the access address The second distributed subsystem；
First distributed subsystem is by being sent to described second for the database access command depending on networking protocol Distributed subsystem；
The database access command is sent to the dispatch service by Internet protocol by the second distributed subsystem Device.
Further, the distributed data base frame system and the primary database, it is described be separately connected from database, The described method includes:
The distributed data base frame system receives the primary database or described is directed to the database from database The access result information that visit order returns；
The access result information is sent to the view networking pipe monitoring and scheduling by the distributed data base frame system System；The view networking pipe monitoring and dispatching system is used to show the access result information.
To solve the above-mentioned problems, the embodiment of the invention also discloses a kind of processing method of database access, the sides Method is applied to view networking, and the view networking is connect with ethernet communication, wherein includes distributed data base frame in the view networking Frame system includes view networking pipe monitoring and dispatching system, dispatch server, primary database and from database in the Ethernet；Institute Distributed data base frame system is stated to communicate to connect with view networking pipe monitoring and dispatching system, the dispatch server respectively, The dispatch server respectively with the primary database, described connect from database communication；The described method includes:
When the trigger action for receiving access database depending on networking pipe monitoring and dispatching system, database access life is generated It enables；
Described be sent to the database access command depending on networking pipe monitoring and dispatching system is led to the dispatch server Believe the distributed data base frame system of connection；The distributed data base frame system is used for the database access Order is sent to the dispatch server；The dispatch server is used to judge the type of the database access command, if institute The type of database access command is stated as write-in type, then the database access command is sent to the primary database, if The type of the database access command is to read type, then is sent to the database access command described from database.
To solve the above-mentioned problems, the embodiment of the invention discloses the processing method of the third database access, the sides Method is applied to view networking, and the view networking is connect with ethernet communication, wherein includes distributed data base frame in the view networking Frame system includes view networking pipe monitoring and dispatching system, dispatch server, primary database and from database in the Ethernet；Institute Distributed data base frame system is stated to communicate to connect with view networking pipe monitoring and dispatching system, the dispatch server respectively, The dispatch server respectively with the primary database, described connect from database communication；The described method includes:
The dispatch server receives the database access command that the distributed data base frame system is sent；Wherein, The database access command by it is described depending on networking pipe monitoring and dispatching system receive access database trigger action when generation, And it is sent to the distributed data base frame system with dispatch server communication connection；
The dispatch server judges the type of the database access command；
If the type of the database access command is write-in type, the dispatch server orders the database access Order is sent to the primary database；
If the type of the database access command is to read type, the dispatch server orders the database access Order is sent to described from database.
To solve the above-mentioned problems, based on the same inventive concept, the embodiment of the present invention is corresponding discloses a kind of database visit The processing unit asked, described device are applied to view networking, and the view networking is connect with ethernet communication, wherein the view networking In include distributed data base frame system, include view networking pipe monitoring and dispatching system, dispatch server, master in the Ethernet Database and from database；The distributed data base frame system respectively with view networking pipe monitoring and dispatching system, described Dispatch server communication connection, the dispatch server respectively with the primary database, described connect from database communication；It is described Distributed data base frame system comprises the following modules:
The first receiving module of visit order, the database access sent for receiving the view networking pipe monitoring and dispatching system Order；Wherein, the database access command is by the triggering for receiving access database depending on networking pipe monitoring and dispatching system It is generated when operation；
Database access command sending module, for the database access command to be sent to the dispatch server； The dispatch server is used to judge the type of the database access command, if the type of the database access command is to write Enter type, then the database access command is sent to the primary database, if the type of the database access command is Type is read, then is sent to the database access command described from database.
To solve the above-mentioned problems, based on the same inventive concept, correspondence of the embodiment of the present invention discloses another database The processing unit of access, described device are applied to view networking, and the view networking is connect with ethernet communication, wherein the view connection Include distributed data base frame system in net, include in the Ethernet view networking pipe monitoring and dispatching system, dispatch server, Primary database and from database；The distributed data base frame system respectively with the view network pipe monitoring and dispatching system, institute State dispatch server communication connection, the dispatch server respectively with the primary database, described connect from database communication；Institute It states and is comprised the following modules depending on networking pipe monitoring and dispatching system:
Database access command generation module when for receiving the trigger action of access database, generating database and visiting Ask order；
The first sending module of visit order, leads to for being sent to the database access command with the dispatch server Believe the distributed data base frame system of connection；The distributed data base frame system is used for the database access Order is sent to the dispatch server；The dispatch server is used to judge the type of the database access command, if institute The type of database access command is stated as write-in type, then the database access command is sent to the primary database, if The type of the database access command is to read type, then is sent to the database access command described from database.
To solve the above-mentioned problems, based on the same inventive concept, correspondence of the embodiment of the present invention discloses the third database The processing unit of access, described device are applied to view networking, and the view networking is connect with ethernet communication, wherein the view connection Include distributed data base frame system in net, include in the Ethernet view networking pipe monitoring and dispatching system, dispatch server, Primary database and from database；The distributed data base frame system respectively with the view network pipe monitoring and dispatching system, institute State dispatch server communication connection, the dispatch server respectively with the primary database, described connect from database communication；Institute Dispatch server is stated to comprise the following modules:
The second receiving module of visit order, the database access sent for receiving the distributed data base frame system Order；Wherein, the database access command is by the triggering for receiving access database depending on networking pipe monitoring and dispatching system It is generated when operation, and is sent to the distributed data base frame system with dispatch server communication connection；
Database access command judgment module, for judging the type of the database access command；
The second sending module of visit order, for judge the type of the database access command for write-in type when, The database access command is sent to the primary database；
Visit order third sending module, for judge the type of the database access command for read type when, The database access command is sent to described from database.
The embodiment of the invention also discloses a kind of devices, comprising:
One or more processors；With
One or more machine readable medias of instruction are stored thereon with, are executed when by one or more of processors When, so that described device executes the processing method of one or more database access as described in the embodiments of the present invention.
The embodiment of the invention also discloses the computer programs of a kind of computer readable storage medium, storage to handle Device executes a kind of processing method of database access as described in the embodiments of the present invention.
The embodiment of the present invention includes following advantages:
The embodiment of the present invention will be assigned to two numbers depending on the pressure for reading and writing database manipulation in networking pipe monitoring and dispatching system In library, it ensure that the write operation that will not influence in view networking service depending on the read operation in networking service, improve view networking The processing speed and response speed of the upper-layer service logic of pipe monitoring and dispatching system, to improve view connection network management monitoring indirectly Dispatch the performance of system.
Detailed description of the invention
Fig. 1 is a kind of networking schematic diagram of view networking of the invention；
Fig. 2 is a kind of hardware structural diagram of node server of the invention；
Fig. 3 is a kind of hardware structural diagram of access switch of the invention；
Fig. 4 is the hardware structural diagram that a kind of Ethernet association of the invention turns gateway；
Fig. 5 is a kind of step flow chart of the processing method embodiment one of database access of the present invention；
Fig. 6 is a kind of step flow chart of the processing method embodiment two of database access of the present invention；
Fig. 7 is a kind of step flow chart of the processing method embodiment three of database access of the present invention；
Fig. 8 is a kind of structural schematic diagram of the processing device embodiment one of database access of the present invention；
Fig. 9 is a kind of structural schematic diagram of the processing device embodiment two of database access of the present invention；
Figure 10 is a kind of structural schematic diagram of the processing device embodiment three of database access of the present invention.
Specific embodiment
In order to make the foregoing objectives, features and advantages of the present invention clearer and more comprehensible, with reference to the accompanying drawing and specific real Applying mode, the present invention is described in further detail.
It is the important milestone of network Development depending on networking, is a real-time network, can be realized HD video real-time Transmission, Push numerous Internet applications to HD video, high definition is face-to-face.
Real-time high-definition video switching technology is used depending on networking, it can be such as high in a network platform by required service Clear video conference, Intellectualized monitoring analysis, emergency command, digital broadcast television, delay TV, the Web-based instruction, shows video monitoring Field live streaming, VOD program request, TV Mail, individual character records (PVR), Intranet (manages) channel by oneself, intelligent video Broadcast Control, information publication All be incorporated into a system platform etc. services such as tens of kinds of videos, voice, picture, text, communication, data, by TV or Computer realizes that high-definition quality video plays.
Embodiment in order to enable those skilled in the art to better understand the present invention is introduced to depending on networking below:
Depending on networking, applied portion of techniques is as described below:
Network technology (Network Technology)
Traditional ethernet (Ethernet) is improved depending on the network technology innovation networked, with potential huge on network First video flow.It is exchanged different from simple network packet packet switch (Packet Switching) or lattice network (Circuit Switching) meets Streaming demand using Packet Switching depending on networking technology.Depending on skill of networking Art has flexible, the simple and low price of packet switch, is provided simultaneously with the quality and safety assurance of circuit switching, realizes the whole network friendship Change the seamless connection of formula virtual circuit and data format.
Switching technology (Switching Technology)
Two advantages of asynchronous and packet switch that Ethernet is used depending on networking eliminate Ethernet under the premise of complete compatible and lack It falls into, has the end-to-end seamless connection of the whole network, direct user terminal, directly carrying IP data packet.User data is in network-wide basis It is not required to any format conversion.It is the more advanced form of Ethernet depending on networking, is a real-time exchange platform, can be realized at present mutually The whole network large-scale high-definition realtime video transmission that networking cannot achieve pushes numerous network video applications to high Qinghua, unitizes.
Server technology (Server Technology)
It is different from traditional server, its Streaming Media depending on the server technology in networking and unified video platform Transmission be built upon it is connection-oriented on the basis of, data-handling capacity is unrelated with flow, communication time, single network layer energy Enough transmitted comprising signaling and data.For voice and video business, handled depending on networking and unified video platform Streaming Media Complexity many simpler than data processing, efficiency substantially increase hundred times or more than traditional server.
Reservoir technology (Storage Technology)
The ultrahigh speed reservoir technology of unified video platform in order to adapt to the media content of vast capacity and super-flow and Using state-of-the-art real time operating system, the programme information in server instruction is mapped to specific hard drive space, media Content is no longer pass through server, and moment is directly delivered to user terminal, and user waits typical time less than 0.2 second.It optimizes Sector distribution greatly reduces the mechanical movement of hard disc magnetic head tracking, and resource consumption only accounts for the 20% of the internet ad eundem IP, but The concurrent flow greater than 3 times of traditional disk array is generated, overall efficiency promotes 10 times or more.
Network security technology (Network Security Technology)
Depending on the structural design networked by servicing independent licence system, equipment and the modes such as user data is completely isolated every time The network security problem that puzzlement internet has thoroughly been eradicated from structure, does not need antivirus applet, firewall generally, has prevented black The attack of visitor and virus, structural carefree secure network is provided for user.
It services innovative technology (Service Innovation Technology)
Business and transmission are fused together by unified video platform, whether single user, private user or a net The sum total of network is all only primary automatic connection.User terminal, set-top box or PC are attached directly to unified video platform, obtain rich The multimedia video service of rich colorful various forms.Unified video platform is traditional to substitute with table schema using " menu type " Complicated applications programming, considerably less code, which can be used, can be realized complicated application, realize the new business innovation of " endless ".
Networking depending on networking is as described below:
It is a kind of central controlled network structure depending on networking, which can be Tree Network, Star network, ring network etc. class Type, but centralized control node is needed to control whole network in network on this basis.
As shown in Figure 1, being divided into access net and Metropolitan Area Network (MAN) two parts depending on networking.
The equipment of access mesh portions can be mainly divided into 3 classes: node server, access switch, terminal (including various machines Top box, encoding board, memory etc.).Node server is connected with access switch, and access switch can be with multiple terminal phases Even, and it can connect Ethernet.
Wherein, node server is the node that centralized control functions are played in access net, can control access switch and terminal. Node server can directly be connected with access switch, can also directly be connected with terminal.
Similar, the equipment of metropolitan area mesh portions can also be divided into 3 classes: metropolitan area server, node switch, node serve Device.Metropolitan area server is connected with node switch, and node switch can be connected with multiple node servers.
Wherein, node server is the node server for accessing mesh portions, i.e. node server had both belonged to access wet end Point, and belong to metropolitan area mesh portions.
Metropolitan area server is the node that centralized control functions are played in Metropolitan Area Network (MAN), can control node switch and node serve Device.Metropolitan area server can be directly connected to node switch, can also be directly connected to node server.
It can be seen that be entirely a kind of central controlled network structure of layering depending on networking network, and node server and metropolitan area The network controlled under server can be the various structures such as tree-shaped, star-like, cyclic annular.
Visually claim, access mesh portions can form unified video platform (part in virtual coil), and multiple unified videos are flat Platform can form view networking；Each unified video platform can be interconnected by metropolitan area and wide area depending on networking.
Classify depending on networked devices
1.1 embodiment of the present invention can be mainly divided into 3 classes: server depending on the equipment in networking, interchanger (including ether Net association turns gateway), terminal (including various set-top boxes, encoding board, memory etc.).Metropolitan Area Network (MAN) can be divided on the whole depending on networking (or national net, World Wide Web etc.) and access net.
1.2 equipment for wherein accessing mesh portions can be mainly divided into 3 classes: node server, access switch (including ether Net association turns gateway), terminal (including various set-top boxes, encoding board, memory etc.).
The specific hardware structure of each access network equipment are as follows:
Node server:
As shown in Fig. 2, mainly including Network Interface Module 201, switching engine module 202, CPU module 203, disk array Module 204；
Wherein, Network Interface Module 201, the Bao Jun that CPU module 203, disk array module 204 are come in enter switching engine Module 202；Switching engine module 202 look into the operation of address table 205 to the packet come in, to obtain the navigation information of packet； And the packet is stored according to the navigation information of packet the queue of corresponding pack buffer 206；If the queue of pack buffer 206 is close It is full, then it abandons；All pack buffer queues of 202 poll of switching engine module, are forwarded: 1) end if meeting the following conditions It is less than that mouth sends caching；2) the queue package counting facility is greater than zero.Disk array module 204 mainly realizes the control to hard disk, packet Include the operation such as initialization, read-write to hard disk；CPU module 203 be mainly responsible for access switch, terminal (not shown) it Between protocol processes, to address table 205 (including descending protocol packet address table, uplink protocol package address table, data packet addressed table) Configuration, and, the configuration to disk array module 204.
Access switch:
As shown in figure 3, mainly including Network Interface Module (downstream network interface module 301, uplink network interface module 302), switching engine module 303 and CPU module 304；
Wherein, the packet (upstream data) that downstream network interface module 301 is come in enters packet detection module 305；Packet detection mould Whether mesh way address (DA), source address (SA), type of data packet and the packet length of the detection packet of block 305 meet the requirements, if met, It then distributes corresponding flow identifier (stream-id), and enters switching engine module 303, otherwise abandon；Uplink network interface mould The packet (downlink data) that block 302 is come in enters switching engine module 303；The data packet that CPU module 304 is come in enters switching engine Module 303；Switching engine module 303 look into the operation of address table 306 to the packet come in, to obtain the navigation information of packet； If the packet into switching engine module 303 is that downstream network interface is gone toward uplink network interface, in conjunction with flow identifier (stream-id) packet is stored in the queue of corresponding pack buffer 307；If the queue of the pack buffer 307 is close full, It abandons；If the packet into switching engine module 303 is not that downstream network interface is gone toward uplink network interface, according to packet Navigation information is stored in the data packet queue of corresponding pack buffer 307；If the queue of the pack buffer 307 is close full, Then abandon.
All pack buffer queues of 303 poll of switching engine module, may include two kinds of situations:
If the queue is that downstream network interface is gone toward uplink network interface, meets the following conditions and be forwarded: 1) It is less than that the port sends caching；2) the queue package counting facility is greater than zero；3) token that rate control module generates is obtained；
If the queue is not that downstream network interface is gone toward uplink network interface, meets the following conditions and is forwarded: 1) it is less than to send caching for the port；2) the queue package counting facility is greater than zero.
Rate control module 308 is configured by CPU module 304, to all downlink networks in programmable interval Interface generates token toward the pack buffer queue that uplink network interface is gone, to control the code rate of forwarded upstream.
CPU module 304 is mainly responsible for the protocol processes between node server, the configuration to address table 306, and, Configuration to rate control module 308.
Ethernet association turns gateway:
As shown in figure 4, mainly including Network Interface Module (downstream network interface module 401, uplink network interface module 402), switching engine module 403, CPU module 404, packet detection module 405, rate control module 408, address table 406, Bao Huan Storage 407 and MAC adding module 409, MAC removing module 410.
Wherein, the data packet that downstream network interface module 401 is come in enters packet detection module 405；Packet detection module 405 is examined Ethernet mac DA, ethernet mac SA, Ethernet length or frame type, the view networking mesh way address of measured data packet DA, whether meet the requirements depending on networking source address SA, depending on networking data Packet type and packet length, corresponding stream is distributed if meeting Identifier (stream-id)；Then, MAC DA, MAC SA, length or frame type are subtracted by MAC removing module 410 (2byte), and enter corresponding receive and cache, otherwise abandon；
Downstream network interface module 401 detects the transmission caching of the port, according to the view of packet networking mesh if there is Bao Ze Address D A knows the ethernet mac DA of corresponding terminal, adds the ethernet mac DA of terminal, Ethernet assists the MAC for turning gateway SA, Ethernet length or frame type, and send.
The function that Ethernet association turns other modules in gateway is similar with access switch.
Terminal:
It mainly include Network Interface Module, Service Processing Module and CPU module；For example, set-top box mainly connects including network Mouth mold block, video/audio encoding and decoding engine modules, CPU module；Encoding board mainly includes Network Interface Module, video encoding engine Module, CPU module；Memory mainly includes Network Interface Module, CPU module and disk array module.
The equipment of 1.3 metropolitan area mesh portions can be mainly divided into 2 classes: node server, node switch, metropolitan area server. Wherein, node switch mainly includes Network Interface Module, switching engine module and CPU module；Metropolitan area server mainly includes Network Interface Module, switching engine module and CPU module are constituted.
2, networking data package definition is regarded
2.1 access network data package definitions
Access net data packet mainly include following sections: destination address (DA), source address (SA), reserve bytes, payload(PDU)、CRC。
As shown in the table, the data packet for accessing net mainly includes following sections:
DA SA Reserved Payload CRC
Wherein:
Destination address (DA) is made of 8 bytes (byte), and first character section indicates type (such as the various associations of data packet Discuss packet, multicast packet, unicast packet etc.), be up to 256 kinds of possibility, the second byte to the 6th byte is metropolitan area net address, Seven, the 8th bytes are access net address；
Source address (SA) is also to be made of 8 bytes (byte), is defined identical as destination address (DA)；
Reserve bytes are made of 2 bytes；
The part payload has different length according to the type of different datagrams, is if it is various protocol packages 64 bytes are 32+1024=1056 bytes if it is single group unicast packets words, are not restricted to above 2 kinds certainly；
CRC is made of 4 bytes, and calculation method follows the Ethernet CRC algorithm of standard.
2.2 Metropolitan Area Network (MAN) packet definitions
The topology of Metropolitan Area Network (MAN) is pattern, may there is 2 kinds, connection even of more than two kinds, i.e. node switching between two equipment It can all can exceed that 2 kinds between machine and node server, node switch and node switch, node switch and node server Connection.But the metropolitan area net address of metropolitan area network equipment is uniquely, to close to accurately describe the connection between metropolitan area network equipment System, introduces parameter in embodiments of the present invention: label, uniquely to describe a metropolitan area network equipment.
(Multi-Protocol Label Switch, multiprotocol label are handed over by the definition of label and MPLS in this specification Change) label definition it is similar, it is assumed that between equipment A and equipment B there are two connection, then data packet from equipment A to equipment B just There are 2 labels, data packet also there are 2 labels from equipment B to equipment A.Label is divided into label, outgoing label, it is assumed that data packet enters The label (entering label) of equipment A is 0x0000, and the label (outgoing label) when this data packet leaves equipment A may reform into 0x0001.The networking process of Metropolitan Area Network (MAN) is to enter network process under centralized control, also means that address distribution, the label of Metropolitan Area Network (MAN) Distribution be all to be dominated by metropolitan area server, node switch, node server be all passively execute, this point with The label distribution of MPLS is different, and the distribution of the label of MPLS is the result that interchanger, server are negotiated mutually.
As shown in the table, the data packet of Metropolitan Area Network (MAN) mainly includes following sections:
DA SA Reserved Label Payload CRC
That is destination address (DA), source address (SA), reserve bytes (Reserved), label, payload (PDU), CRC.Its In, the format of label, which can refer to, such as gives a definition: label is 32bit, wherein high 16bit retains, only with low 16bit, its position Set is between the reserve bytes and payload of data packet.
A kind of number of the present invention is shown with reference to Fig. 5 for the above-mentioned characteristic and technical problem of the invention of view networking According to the step flow chart of the processing method embodiment one of library access, the method can be applied to view networking, view networking and Ethernet communication connection, wherein include distributed data base frame system in the view networking, include view connection in the Ethernet Network management monitoring dispatches system, dispatch server, primary database and from database；The distributed data base frame system respectively with View networking pipe monitoring and dispatching system, dispatch server communication connection, the dispatch server respectively with the main number According to library, it is described from database communication connect；The method can specifically include following steps:
Step S501: the distributed data base frame system receives the number that the view networking pipe monitoring and dispatching system is sent According to library visit order；Wherein, the database access command receives access data depending on networking pipe monitoring and dispatching system by described It is generated when the trigger action in library；
It regards networking pipe monitoring and dispatching system full name and dispatches system for view networking monitoring network management, it is responsible to being accessed in system Millions monitoring resource information be managed scheduling etc. operation.It include view connection NM server depending on networking pipe monitoring and dispatching system Join NMS user end with view, the processing and forwarding of data are used for depending on connection NM server, regards connection NMS user end and provided as user Depending on the access interface for pipe monitoring and dispatching system of networking, for carrying out interface alternation with user.
In various embodiments of the present invention, it is effective in view networking to can be user for the trigger action of above-mentioned access database Family end, which is shown, to be inputted in the interface of database or modifies data, or checks the data in database；It is also possible to view networking pipe Server receives the message of the monitoring change in resources sended over depending on networking monitoring access server in real time, and in real time more New database.Mentioned herein also referred to as assisting depending on networking monitoring access server turns server, can be to the snowy bright engineering of access Or the monitoring resource (monitoring camera data collected) of public security bureau's system carries out protocol conversion, and accesses in view networking.
Depending on the corresponding received trigger action in connection NMS user end, corresponding database access command, database are generated Visit order can be realized by structured query language SQL statement.Database access command includes the field to database access Type (type that field type here can be regarded as SQL statement), trigger action is different, and the field type of access is different.Than Such as trigger action is to delete (delete), update (update) operation, also be will include in the field type of corresponding access It deletes (delete) or updates words such as (update)；Trigger action is the operation such as selection (select), corresponding access Also the words such as selection (select) be will include in field type.Later, database generated can be visited depending on connection NMS user end Ask that order is sent to view connection NM server by agreements such as http or https.
Then database access command is sent to the distributed data base frame system again depending on connection NM server, with This completes data of the database access command between distributed data base frame system and view networking pipe monitoring and dispatching system Transmission.
Step S502: the database access command is sent to the scheduling and taken by the distributed data base frame system Business device；The dispatch server is used to judge the type of the database access command, if the class of the database access command Type is write-in type, then the database access command is sent to the primary database, if the database access command Type is to read type, then is sent to the database access command described from database.
The view networking pipe monitoring and dispatching system of the embodiment of the present invention is run based on IP/TCP network protocol, is located at internet In；Proxy server mysql-proxy server can be used in dispatch server, is also based on the operation of IP/TCP network protocol, In internet.It is likely located in the same local area network depending on networking pipe monitoring and dispatching system and dispatch server, it is also possible to no In the same local area network.When view networking pipe monitoring and dispatching system is located at different local area networks from the dispatch server When, it is the correct forwarding of accessing data base order, the embodiment of the present invention joins distributed data base frame system as view Network management monitoring dispatches the connection bridge between system and dispatch server, and the forwarding of data how is realized for different local area networks , specific implementation method is elaborated below.
The distributed data base frame system includes multiple distributed subsystems；The distributed data of the embodiment of the present invention Library frame system is the general designation of multiple distributed subsystems, and the database access command transmitted includes the access of the database Address；So, the database that the distributed data base frame system receives that the view networking pipe monitoring and dispatching system is sent is visited Ask that the sub-step of order can specifically include:
Sub-step 1: first distributed subsystem receives view networking pipe monitoring and scheduling system by Internet protocol The database access command that system is sent；
The database access command is sent to the son of the dispatch server by the distributed data base frame system Step can specifically include:
Sub-step 2: first distributed subsystem is determining to be located at together with the access address according to the access address Second distributed subsystem of one local area network；
Sub-step 3: the database access command by being sent to by first distributed subsystem depending on networking protocol Second distributed subsystem；
The database access command is sent to described by 4: the second distributed subsystem of sub-step by Internet protocol Dispatch server.
Distributed data base frame system mentioned by the embodiment of the present invention have IP/TCP agreement and view networking protocol it Between conversion function, so the first distributed subsystem and the second distributed subsystem also have view networking and internet in lead to The function of letter, the first distributed subsystem and the second distributed subsystem here can regard the combination of software and hardware as, and hardware includes Two network interface cards, one is view networking network interface card, another is IP network card；Software IP/TCP agreement and view networking protocol simultaneously, can be into The conversion of row agreement.Above-mentioned first distributed subsystem and view networking pipe monitoring and dispatching system are located in same local area network, and second Distributed subsystem and dispatch server are located in the same local area network, and the first distributed subsystem passes through Internet protocol first The database access command that the view networking pipe monitoring and dispatching system is sent is received, then by regarding networking protocol for the data Library visit order is sent to second distributed subsystem.
It is located at the second layer in network protocol layer depending on networking protocol, is to support ultra-large, high bandwidth, real time communication Network and a whole set of the complete network communication protocol system designed, can be independently of establishing between different terminals except IP agreement Addressing and communication, realize " with having quality assurance " Real Time Communication Network system, be a kind of extensive with IP agreement " sane level " High bandwidth real-time exchange network communication technology.Communication path depending on networking is in link layer, and without internet, non-view networking is used Family can not access, the security risk that can avoid existing internet communication transmission existing to the utmost.So utilizing view networking Characteristic access database, can greatly improve the safety in data base read-write and access process.It is by one depending on networking It is formed depending on main Core server of networking, 254 view networkings from Core server, view networked terminals and other auxiliary systems.Depending on connection Net must connect the main Core server of view networking from Core server, and the view that networks networking can just network with other views from core Server communication carries out business.
So the realization step of above-mentioned sub-step 3 may include:
The database access command is sent to the networking of the first view from Core server by first distributed subsystem； Described first is used to for the database access command being sent to the main kernel service of the view networking from Core server depending on networking Device；The view networks main Core server for according to the access address, determination to be connect with second distributed subsystem The second view networking be sent to the second view networking from kernel service from Core server, and by the database access command Device；Described second is used to for the database access command being sent to the described second distributed subsystem from Core server depending on networking System.
Then sub-step 4 is executed, after dispatch server receives the database access command, is begun to the data The type of library visit order is judged.When specifically judging, pass through field type (the field class here to database access Type can be regarded as the type of SQL statement) judgement to realize, if SQL statement include delete (delete), update (update) etc. to The word of database write-in judges the type of the database access command for write-in, then by the database access command point It is assigned in primary database.Conversely, if SQL statement includes selecting the word to data base querying such as (select), described in judgement Database access command is to read type, then distributes the database access command to from database.
To sum up, the embodiment of the present invention elaborates the processing side of database access from the angle of distributed data base frame system Method will be assigned in two databases depending on the pressure for reading and writing database manipulation in networking pipe monitoring and dispatching system, ensure that view Read operation in networking service will not influence the write operation in view networking service, improve the upper of view networking pipe monitoring and dispatching system The processing speed and response speed of layer service logic, to improve the performance of view networking pipe monitoring and scheduling system indirectly；Meanwhile The embodiment of the present invention is using distributed data base frame system as between view networking pipe monitoring and dispatching system and dispatch server Transmission architecture, the database of Different LANs is remotely accessed, can greatly promote read-write data procedures in safety Property.
The database access command of different field type is distributed to primary database or after database, of the invention excellent Select in embodiment, the primary database and it is described from database be connected with each other, which comprises
The distributed data base frame system receives the data synchronization request sent from database；Wherein, described Data synchronization request is generated from database when data synchronizing function is opened by described；
The data synchronization request is sent to the primary database by the distributed data base frame system；
The distributed data base frame system receives the primary database when data synchronizing function is opened, for described The data more new information that data synchronization request returns；
The data more new information is sent to described from database by the distributed data base frame system.
Through the above steps, achievable primary database and the real-time synchronization from database guarantee two to the embodiment of the present invention The consistency of data in database, so that when user is read to database, database (this hair for being checked For from database in bright embodiment) in data be all newest.And using distributed data base frame system as master data Library and from the data synchronous transfer path between database, enables primary database to pass through depending on networking and carry out between database Master-slave synchronisation function, data synchronization are more safe and reliable.It further illustrates, it is described to synchronize function in turn-on data from database After energy, data synchronization request periodically can be sent to the primary database, request data is synchronous.Data synchronization request can pass through capture Tool dump protocol realization.
The distributed data base frame system and the primary database, it is described be separately connected from database, work as database After visit order is sent completely, which comprises
The distributed data base frame system receives the primary database or described is directed to the database from database The access result information that visit order returns；
The access result information is sent to the view networking pipe monitoring and scheduling by the distributed data base frame system System；The view networking pipe monitoring and dispatching system is used to show the access result information.
The embodiment of the present invention is shown after database access command is sent completely, for the access of database access command As a result step is shown.Access result information directly can return to view networking pipe monitoring and scheduling by distributed data base frame system System, transmission process is safe and reliable, primary database or separately responds from database, and speed is faster.
With reference to Fig. 6, a kind of step flow chart of the processing method embodiment two of database access of the present invention is shown, it is described Method can be applied to view networking, and the view networking is connect with ethernet communication, wherein include distributed number in the view networking It include view networking pipe monitoring and dispatching system, dispatch server, primary database and from data according to library frame system, in the Ethernet Library；The distributed data base frame system is communicated with described depending on networking pipe monitoring and dispatching system, the dispatch server respectively Connection, the dispatch server respectively with the primary database, described connect from database communication；The method specifically can wrap Include following steps:
Step S601: when the trigger action for receiving access database depending on networking pipe monitoring and dispatching system, number is generated According to library visit order；
Step S602: described to be sent to the database access command and the scheduling depending on networking pipe monitoring and dispatching system The distributed data base frame system of server communication connection；The distributed data base frame system is used for the number The dispatch server is sent to according to library visit order；The dispatch server is used to judge the class of the database access command The database access command is sent to the main number if the type of the database access command is write-in type by type According to library, if the type of the database access command is to read type, by the database access command be sent to it is described from Database.
To sum up, the embodiment of the present invention elaborates the processing side of database access from the angle depending on pipe monitoring and dispatching system of networking Method, implements step and principle is explained and through the embodiment of the present invention, ensure that view not described here any more referring to embodiment one Read operation in networking service will not influence the write operation in view networking service, improve the upper of view networking pipe monitoring and dispatching system The processing speed and response speed of layer service logic, to improve the performance of view networking pipe monitoring and scheduling system indirectly.
With reference to Fig. 7, a kind of step flow chart of the processing method embodiment three of database access of the present invention is shown, it is described Method can be applied to view networking, and the view networking is connect with ethernet communication, wherein include distributed number in the view networking It include view networking pipe monitoring and dispatching system, dispatch server, primary database and from data according to library frame system, in the Ethernet Library；The distributed data base frame system is communicated with described depending on networking pipe monitoring and dispatching system, the dispatch server respectively Connection, the dispatch server respectively with the primary database, described connect from database communication；The method specifically can wrap Include following steps:
Step S701: the dispatch server receives the database access life that the distributed data base frame system is sent It enables；Wherein, the database access command is grasped by the triggering for receiving access database depending on networking pipe monitoring and dispatching system Make Shi Shengcheng, and is sent to the distributed data base frame system with dispatch server communication connection；
Step S702: the dispatch server judges the type of the database access command；
Step S703: if the type of the database access command is write-in type, the dispatch server is by the number The primary database is sent to according to library visit order；
Step S704: if the type of the database access command is to read type, the dispatch server is by the number It is sent to according to library visit order described from database.
To sum up, the embodiment of the present invention elaborates the processing method of database access from the angle of dispatch server, specific real Existing step and principle are explained referring to embodiment one, not described here any more, through the embodiment of the present invention, ensure that in view networking service Read operation will not influence view networking service in write operation, improve view networking pipe monitoring and dispatching system upper-layer service logic Processing speed and response speed, thus improve indirectly view networking pipe monitoring and scheduling system performance.
It should be noted that for simple description, therefore, it is stated as a series of action groups for embodiment of the method It closes, but those skilled in the art should understand that, embodiment of that present invention are not limited by the describe sequence of actions, because according to According to the embodiment of the present invention, some steps may be performed in other sequences or simultaneously.Secondly, those skilled in the art also should Know, the embodiments described in the specification are all preferred embodiments, and the related movement not necessarily present invention is implemented Necessary to example.
With reference to Fig. 8, based on the same inventive concept, the method for the corresponding embodiment of the present invention one shows a kind of number of the present invention According to the structural schematic diagram of the processing device embodiment one of library access, described device is applied to view networking, the view networking and ether Network Communication connection, wherein include distributed data base frame system in the view networking, include view networking pipe in the Ethernet Monitoring and dispatching system, dispatch server, primary database and from database；The distributed data base frame system respectively with it is described Depending on networking pipe monitoring and dispatching system, the dispatch server communication connection, the dispatch server respectively with the primary database, It is described to be connected from database communication；The distributed data base frame system can specifically include with lower module:
The first receiving module of visit order 801, the database sent for receiving the view networking pipe monitoring and dispatching system Visit order；Wherein, the database access command receives access database depending on networking pipe monitoring and dispatching system by described It is generated when trigger action；
Database access command sending module 802, for the database access command to be sent to the dispatch service Device；The dispatch server is used to judge the type of the database access command, if the type of the database access command For type is written, then the database access command is sent to the primary database, if the class of the database access command Type is to read type, then is sent to the database access command described from database.
With reference to Fig. 9, based on the same inventive concept, the method for the corresponding embodiment of the present invention two shows a kind of number of the present invention According to the structural schematic diagram of the processing device embodiment two of library access, described device is applied to view networking, the view networking and ether Network Communication connection, wherein include distributed data base frame system in the view networking, include view networking pipe in the Ethernet Monitoring and dispatching system, dispatch server, primary database and from database；The distributed data base frame system respectively with it is described Depending on networking pipe monitoring and dispatching system, the dispatch server communication connection, the dispatch server respectively with the primary database, It is described to be connected from database communication；It is described to be comprised the following modules depending on networking pipe monitoring and dispatching system:
Database access command generation module 901 generates database when for receiving the trigger action of access database Visit order；
The first sending module of visit order 902, for the database access command to be sent to and the dispatch service The distributed data base frame system of device communication connection；The distributed data base frame system is used for the database Visit order is sent to the dispatch server；The dispatch server is used to judge the type of the database access command, If the type of the database access command is write-in type, the database access command is sent to the master data The database access command is sent to described from number by library if the type of the database access command is to read type According to library.
With reference to Figure 10, based on the same inventive concept, the method for the corresponding embodiment of the present invention three shows a kind of number of the present invention According to the structural schematic diagram of the processing device embodiment three of library access, described device is applied to view networking, the view networking and ether Network Communication connection, wherein include distributed data base frame system in the view networking, include view networking pipe in the Ethernet Monitoring and dispatching system, dispatch server, primary database and from database；The distributed data base frame system respectively with it is described Depending on networking pipe monitoring and dispatching system, the dispatch server communication connection, the dispatch server respectively with the primary database, It is described to be connected from database communication；The dispatch server can specifically include with lower module:
The second receiving module of visit order 1001, the database sent for receiving the distributed data base frame system Visit order；Wherein, the database access command receives access database depending on networking pipe monitoring and dispatching system by described It is generated when trigger action, and is sent to the distributed data base frame system with dispatch server communication connection；
Database access command judgment module 1002, for judging the type of the database access command；
The second sending module of visit order 1003, for judging the type of the database access command for write-in type When, the database access command is sent to the primary database；
Visit order third sending module 1004, for judging the type of the database access command for reading type When, the database access command is sent to described from database.
For a kind of processing device embodiment of database access, due to the processing side of itself and a kind of database access Method embodiment is substantially similar, so being described relatively simple, related place is implemented referring to a kind of processing method of database access The part explanation of example.
The embodiment of the invention also provides a kind of devices, comprising:
One or more processors；With
One or more machine readable medias of instruction are stored thereon with, are executed when by one or more of processors When, so that described device executes a kind of processing method of one or more database access as described in the embodiments of the present invention.
The embodiment of the invention also provides the computer programs of a kind of computer readable storage medium, storage to handle Device executes a kind of processing method of database access as described in the embodiments of the present invention.
All the embodiments in this specification are described in a progressive manner, the highlights of each of the examples are with The difference of other embodiments, the same or similar parts between the embodiments can be referred to each other.
It should be understood by those skilled in the art that, the embodiment of the embodiment of the present invention can provide as method, apparatus or calculate Machine program product.Therefore, the embodiment of the present invention can be used complete hardware embodiment, complete software embodiment or combine software and The form of the embodiment of hardware aspect.Moreover, the embodiment of the present invention can be used one or more wherein include computer can With in the computer-usable storage medium (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.) of program code The form of the computer program product of implementation.
The embodiment of the present invention be referring to according to the method for the embodiment of the present invention, terminal device (system) and computer program The flowchart and/or the block diagram of product describes.It should be understood that flowchart and/or the block diagram can be realized by computer program instructions In each flow and/or block and flowchart and/or the block diagram in process and/or box combination.It can provide these Computer program instructions are set to general purpose computer, special purpose computer, Embedded Processor or other programmable data processing terminals Standby processor is to generate a machine, so that being held by the processor of computer or other programmable data processing terminal devices Capable instruction generates for realizing in one or more flows of the flowchart and/or one or more blocks of the block diagram The device of specified function.
These computer program instructions, which may also be stored in, is able to guide computer or other programmable data processing terminal devices In computer-readable memory operate in a specific manner, so that instruction stored in the computer readable memory generates packet The manufacture of command device is included, which realizes in one side of one or more flows of the flowchart and/or block diagram The function of being specified in frame or multiple boxes.
These computer program instructions can also be loaded into computer or other programmable data processing terminal devices, so that Series of operation steps are executed on computer or other programmable terminal equipments to generate computer implemented processing, thus The instruction executed on computer or other programmable terminal equipments is provided for realizing in one or more flows of the flowchart And/or in one or more blocks of the block diagram specify function the step of.
Although the preferred embodiment of the embodiment of the present invention has been described, once a person skilled in the art knows bases This creative concept, then additional changes and modifications can be made to these embodiments.So the following claims are intended to be interpreted as Including preferred embodiment and fall into all change and modification of range of embodiment of the invention.
Finally, it is to be noted that, herein, relational terms such as first and second and the like be used merely to by One entity or operation are distinguished with another entity or operation, without necessarily requiring or implying these entities or operation Between there are any actual relationship or orders.Moreover, the terms "include", "comprise" or its any other variant meaning Covering non-exclusive inclusion, so that process, method, article or terminal device including a series of elements not only wrap Those elements are included, but also including other elements that are not explicitly listed, or further includes for this process, method, article Or the element that terminal device is intrinsic.In the absence of more restrictions, being wanted by what sentence "including a ..." limited Element, it is not excluded that there is also other identical elements in process, method, article or the terminal device for including the element.
Above to a kind of processing method of database access provided by the present invention, a kind of processing unit of database access It is described in detail with a kind of computer readable storage medium, specific case used herein is to the principle of the present invention and reality The mode of applying is expounded, and the above description of the embodiment is only used to help understand the method for the present invention and its core ideas；Together When, for those of ordinary skill in the art, according to the thought of the present invention, have in specific embodiments and applications Change place, in conclusion the contents of this specification are not to be construed as limiting the invention.

Claims (10)

1. a kind of processing method of database access, which is characterized in that the method is applied to view networking, view networking and with Too Network Communication connects, wherein includes distributed data base frame system in the view networking, includes view networking in the Ethernet Pipe monitoring and dispatching system, dispatch server, primary database and from database；The distributed data base frame system respectively with institute State view networking pipe monitoring and dispatching system, the dispatch server communication connection, the dispatch server respectively with the master data Library, it is described from database communication connect；The described method includes:
The distributed data base frame system receives the database access command that the view networking pipe monitoring and dispatching system is sent； Wherein, when the database access command is by the trigger action for receiving access database depending on networking pipe monitoring and dispatching system It generates；
The database access command is sent to the dispatch server by the distributed data base frame system；The scheduling Server is used to judge the type of the database access command, if the type of the database access command is write-in type, The database access command is then sent to the primary database, if the type of the database access command is to read class The database access command is then sent to described from database by type.
2. the method according to claim 1, wherein the distributed data base frame system includes being in communication with each other Multiple distributed subsystems of connection；The database access command includes the access address of the database；
When view networking pipe monitoring and dispatching system is located at different local area networks from the dispatch server, the distribution number Include: according to the sub-step that library frame system receives the database access command sent depending on networking pipe monitoring and dispatching system
First distributed subsystem receives the data that the view networking pipe monitoring and dispatching system is sent by Internet protocol Library visit order；
The database access command is sent to the sub-step of the dispatch server by the distributed data base frame system Include:
First distributed subsystem is determining to be located at the of same local area network with the access address according to the access address Two distributed subsystems；
First distributed subsystem is by being sent to second distribution for the database access command depending on networking protocol Subsystem；
The database access command is sent to the dispatch server by Internet protocol by the second distributed subsystem.
3. the method according to claim 1, wherein the distributed data base frame system and the master data Library described is separately connected from database, which comprises
The distributed data base frame system receives the primary database or described is directed to the database access from database Order the access result information returned；
The access result information is sent to the view networking pipe monitoring and dispatching system by the distributed data base frame system； The view networking pipe monitoring and dispatching system is used to show the access result information.
4. a kind of processing method of database access, which is characterized in that the method is applied to view networking, view networking and with Too Network Communication connects, wherein includes distributed data base frame system in the view networking, includes view networking in the Ethernet Pipe monitoring and dispatching system, dispatch server, primary database and from database；The distributed data base frame system respectively with institute State view networking pipe monitoring and dispatching system, the dispatch server communication connection, the dispatch server respectively with the master data Library, it is described from database communication connect；The described method includes:
When the trigger action for receiving access database depending on networking pipe monitoring and dispatching system, database access command is generated；
It is described to be sent to the database access command and the dispatch server communication link depending on networking pipe monitoring and dispatching system The distributed data base frame system connect；The distributed data base frame system is used for the database access command It is sent to the dispatch server；The dispatch server is used to judge the type of the database access command, if the number Type according to library visit order is write-in type, then the database access command is sent to the primary database, if described The type of database access command is to read type, then is sent to the database access command described from database.
5. a kind of processing method of database access, which is characterized in that the method is applied to view networking, view networking and with Too Network Communication connects, wherein includes distributed data base frame system in the view networking, includes view networking in the Ethernet Pipe monitoring and dispatching system, dispatch server, primary database and from database；The distributed data base frame system respectively with institute State view networking pipe monitoring and dispatching system, the dispatch server communication connection, the dispatch server respectively with the master data Library, it is described from database communication connect；The described method includes:
The dispatch server receives the database access command that the distributed data base frame system is sent；Wherein, described Database access command is by generation when the trigger action for receiving access database depending on networking pipe monitoring and dispatching system, concurrently It send to the distributed data base frame system communicated to connect with the dispatch server；
The dispatch server judges the type of the database access command；
If the type of the database access command is write-in type, the dispatch server sends out the database access command It send to the primary database；
If the type of the database access command is to read type, the dispatch server sends out the database access command It send to described from database.
6. a kind of processing unit of database access, which is characterized in that described device is applied to view networking, view networking and with Too Network Communication connects, wherein includes distributed data base frame system in the view networking, includes view networking in the Ethernet Pipe monitoring and dispatching system, dispatch server, primary database and from database；The distributed data base frame system respectively with institute State view networking pipe monitoring and dispatching system, the dispatch server communication connection, the dispatch server respectively with the master data Library, it is described from database communication connect；The distributed data base frame system comprises the following modules:
The first receiving module of visit order, the database access life sent for receiving the view networking pipe monitoring and dispatching system It enables；Wherein, the database access command is grasped by the triggering for receiving access database depending on networking pipe monitoring and dispatching system Make Shi Shengcheng；
Database access command sending module, for the database access command to be sent to the dispatch server；It is described Dispatch server is used to judge the type of the database access command, if the type of the database access command is write-in class The database access command is then sent to the primary database by type, if the type of the database access command is to read The database access command is then sent to described from database by type.
7. a kind of processing unit of database access, which is characterized in that described device is applied to view networking, view networking and with Too Network Communication connects, wherein includes distributed data base frame system in the view networking, includes view networking in the Ethernet Pipe monitoring and dispatching system, dispatch server, primary database and from database；The distributed data base frame system respectively with institute State view networking pipe monitoring and dispatching system, the dispatch server communication connection, the dispatch server respectively with the master data Library, it is described from database communication connect；It is described to be comprised the following modules depending on networking pipe monitoring and dispatching system:
Database access command generation module when for receiving the trigger action of access database, generates database access life It enables；
The first sending module of visit order, for the database access command to be sent to and the dispatch server communication link The distributed data base frame system connect；The distributed data base frame system is used for the database access command It is sent to the dispatch server；The dispatch server is used to judge the type of the database access command, if the number Type according to library visit order is write-in type, then the database access command is sent to the primary database, if described The type of database access command is to read type, then is sent to the database access command described from database.
8. a kind of processing unit of database access, which is characterized in that described device is applied to view networking, view networking and with Too Network Communication connects, wherein includes distributed data base frame system in the view networking, includes view networking in the Ethernet Pipe monitoring and dispatching system, dispatch server, primary database and from database；The distributed data base frame system respectively with institute State view networking pipe monitoring and dispatching system, the dispatch server communication connection, the dispatch server respectively with the master data Library, it is described from database communication connect；The dispatch server comprises the following modules:
The second receiving module of visit order, the database access life sent for receiving the distributed data base frame system It enables；Wherein, the database access command is grasped by the triggering for receiving access database depending on networking pipe monitoring and dispatching system Make Shi Shengcheng, and is sent to the distributed data base frame system with dispatch server communication connection；
Database access command judgment module, for judging the type of the database access command；
The second sending module of visit order, for judge the type of the database access command for write-in type when, by institute It states database access command and is sent to the primary database；
Visit order third sending module, for judge the type of the database access command for read type when, by institute State database access command be sent to it is described from database.
9. a kind of device characterized by comprising
One or more processors；With
One or more machine readable medias of instruction are stored thereon with, when being executed by one or more of processors, are made Obtain the processing method for one or more database access that described device is executed as described in claim 1 to 5.
10. a kind of computer readable storage medium, which is characterized in that its computer program stored executes processor as weighed Benefit requires the processing method of 1 to 5 described in any item database access.
CN201910512063.8A 2019-06-13 2019-06-13 A kind of processing method and processing device of database access Pending CN110377403A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201910512063.8A CN110377403A (en) 2019-06-13 2019-06-13 A kind of processing method and processing device of database access

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201910512063.8A CN110377403A (en) 2019-06-13 2019-06-13 A kind of processing method and processing device of database access

Publications (1)

Publication Number Publication Date
CN110377403A true CN110377403A (en) 2019-10-25

Family

ID=68250286

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201910512063.8A Pending CN110377403A (en) 2019-06-13 2019-06-13 A kind of processing method and processing device of database access

Country Status (1)

Country Link
CN (1) CN110377403A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111580993A (en) * 2020-05-11 2020-08-25 广州虎牙信息科技有限公司 Data processing method and device, electronic equipment and storage medium

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101119414A (en) * 2007-09-19 2008-02-06 华为技术有限公司 Method and system to access database
CN102033912A (en) * 2010-11-25 2011-04-27 北京北纬点易信息技术有限公司 Distributed-type database access method and system
US20170017692A1 (en) * 2015-07-13 2017-01-19 Paypal, Inc. Read/write split database query routing
CN106649865A (en) * 2016-12-31 2017-05-10 深圳市优必选科技有限公司 Distributed server system and data processing method
CN108038157A (en) * 2017-12-05 2018-05-15 北京星河星云信息技术有限公司 Master-slave database reading/writing method, system, storage device and server
CN109861983A (en) * 2018-12-29 2019-06-07 视联动力信息技术股份有限公司 Information processing method and device

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101119414A (en) * 2007-09-19 2008-02-06 华为技术有限公司 Method and system to access database
CN102033912A (en) * 2010-11-25 2011-04-27 北京北纬点易信息技术有限公司 Distributed-type database access method and system
US20170017692A1 (en) * 2015-07-13 2017-01-19 Paypal, Inc. Read/write split database query routing
CN106649865A (en) * 2016-12-31 2017-05-10 深圳市优必选科技有限公司 Distributed server system and data processing method
CN108038157A (en) * 2017-12-05 2018-05-15 北京星河星云信息技术有限公司 Master-slave database reading/writing method, system, storage device and server
CN109861983A (en) * 2018-12-29 2019-06-07 视联动力信息技术股份有限公司 Information processing method and device

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
华竹轩: "支持海量数据的分布式数据库架构设计与验证", 《河南科学》 *
胡遵华: "一种基于云的SaaS分布式多租户数据库研究", 《计算机应用与软件》 *

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111580993A (en) * 2020-05-11 2020-08-25 广州虎牙信息科技有限公司 Data processing method and device, electronic equipment and storage medium
CN111580993B (en) * 2020-05-11 2024-05-17 广州虎牙信息科技有限公司 Data processing method and device, electronic equipment and storage medium

Similar Documents

Publication Publication Date Title
CN108075920B (en) A kind of management method and system regarding networked terminals
CN110198345A (en) A kind of data request method, system and device and storage medium
CN110392126A (en) A kind of communication means and device
CN109561073A (en) A kind of transparent transmission system and method based on view networking
CN110381030A (en) A kind of processing method and processing device of synchronization request
CN110225083A (en) Data push method and device based on view networking
CN108234178A (en) A kind of method and apparatus for being managed collectively menu file
CN110224988A (en) A kind of processing method of image data, system and device and storage medium
CN110362628A (en) A kind of synchronous method and device cascading file
CN108206927A (en) A kind of meeting synchronous method and device
CN110048903A (en) A kind of association turns gateway status monitoring method and device
CN110213334A (en) A kind of transmission method and device of shared file
CN109151061A (en) A kind of date storage method and device
CN109347930A (en) A kind of task processing method and device
CN110287248A (en) A kind of data read-write method and system
CN110336710A (en) A kind of test method of terminal, system and device and storage medium
CN110166363A (en) A kind of multicast link monitoring method and device
CN110445837A (en) High concurrent group system and building method, high concurrent request processing method and device
CN109889759A (en) A kind of exchange method and system regarding networked video meeting
CN110377403A (en) A kind of processing method and processing device of database access
CN109257629A (en) A kind of data transmission system
CN110266590A (en) A kind of multicast address processing method and processing device
CN110365967A (en) A kind of test method and device
CN110535683A (en) A kind of report method and device of end message
CN110311804A (en) A kind of methods of exhibiting and device regarding networked node

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20191025