Method for updating data of database in batch mode based on communication protocol

A batch update and communication protocol technology, applied in the field of database applications, can solve problems such as database pressure, prolonged data update process time, unfavorable real-time synchronization of database server and client data, and achieve the effect of alleviating pressure and reducing the number of interactions

Active Publication Date: 2012-06-27
北京人大金仓信息技术股份有限公司
View PDF5 Cites 14 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, in the process of updating a batch of data, the client will interact with the server many times, which will inevitably bring pressure to the data

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method for updating data of database in batch mode based on communication protocol
  • Method for updating data of database in batch mode based on communication protocol
  • Method for updating data of database in batch mode based on communication protocol

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0022] In one embodiment of the present invention, the SSL (Secure Sockets Layer, Secure Sockets Layer) protocol established between the client and the database server is used for data transmission. The SSL protocol is located between the TCP / IP protocol and various application layer protocols, providing security support for data communication. The SSL protocol can be divided into two layers: SSL Record Protocol (SSL Record Protocol), which is built on a reliable transmission protocol such as TCP, provides support for basic functions such as data encapsulation, compression, and encryption for high-level protocols. SSL Handshake Protocol (SSL Handshake Protocol), based on the SSL record protocol, is used for identity authentication, negotiation of encryption algorithms, and exchange of encryption keys before the actual data transmission begins. In other embodiments of the present invention, other secure communication protocols such as Secure Hypertext Transfer Protocol (S-HTTP)...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses a method for updating data of a database in batch mode based on communication protocols, which includes the following steps: step S1, security socket layer (SSL) connection is built between a client and a server; step S2, the client is communicated with the database server in interactive mode to complete batch updating of the data; and step S3, the SSL connection between the client and the database server is broken. In the step S2, a PreparedStatement object is stated through preprocessing of structured query language (SQL) statement and used for enabling the generated SQL statement to be preserved in the server in the process of execution of the SQL statement at the first time, and then sends required data to the SQL statement continually. The method adopts a once-transmission batch updating mode to all data, and facilitates pressure remission of the database server caused by batch updating of the data at the client.

Description

technical field [0001] The invention relates to a method for updating database data in batches, in particular to a method for performing data transmission based on a communication protocol to realize batch updating of database data, and belongs to the technical field of database applications. Background technique [0002] At present, in various specific database application environments, clients often need to update data in database servers in large quantities. In the prior art, the client generally adopts a data update method of transmitting a single data record to the server in different batches. Every time a batch of data is updated between the client / server, multiple interactive connections with the server are required. This data update method obviously cannot meet the requirements of batch update of massive database data. [0003] In the paper "Realization of Remote Heterogeneous Database Data Synchronization" published by Jiang Yi and Liu Qihong (published in "Comput...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F17/30H04L29/06
Inventor 董亚辉白芸刘淼李健
Owner 北京人大金仓信息技术股份有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap