Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Database access agent method and system based on SSL/XML

An access proxy and data access technology, applied in the field of SSL/XML-based database access proxy methods and systems, can solve problems such as unfavorable security control, large number of database database connections, and large network traffic, achieving good flexibility and improving security. Control and improve operational efficiency

Inactive Publication Date: 2010-09-29
DATCENT TECH
View PDF1 Cites 30 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

For example: clients access the database directly (or through stored procedures), and all clients access the database, which is not conducive to security control and difficult to prevent malicious attacks by hackers
At the same time, the network traffic is very large, which is easy to form a network bottleneck
It will also cause database access bottlenecks and too many database connections, which will affect the response speed of the database and reduce system performance.
In addition, the two-tier application architecture has maintenance and expansion issues

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
  • Database access agent method and system based on SSL/XML
  • Database access agent method and system based on SSL/XML

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0021] The SSL / XML-based database access proxy method of this embodiment is performed in the following steps:

[0022] (1) Deploy the server of the middle tier on Linux, set the connection parameters between the server and the database and the related operating parameters of the server;

[0023] (2) The server retains the connection pool with the database to improve operation efficiency;

[0024] (3) Deploy a middle-level proxy, responsible for the forwarding of requests between the client and the server, and reasonably arrange request routing;

[0025] (4) The user uses the interface provided by the middle-tier client to access the business database.

[0026] The middle layer of the database uses XML to describe data, and the transmission channel supports SSL encryption.

[0027] ●Example of data request:

[0028]

[0029]

[0030] openquery

[0031]

[0032]

[0033] select*from users where

[0034] username=?

[0035]

[0036]

[0037] Zhang San

[0038]

[0039]

[0040]

[0041] ...

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 relates to a database access method and a database access system, in particular to a database access agent method and a database access agent system based on SSL / XML. An intermediate layer client is an access operation interface for providing a database record set to a final user, which supports inquiry of the database record set, local cache and navigation and updating, deleting and other operations of the database records; an intermediate layer agent is used for linking the intermediate layer client and an intermediate layer server; the intermediate layer agents can be cascaded with each other to provide a data access channel to the database intermediate layer; the intermediate layer server is used for receiving a database access request, analyzing the database operation according to the request, accessing the database and returning the result of the database operation to the intermediate layer client through the intermediate layer agent. The invention can effectively support the database access over a plurality of hosts.

Description

Technical field [0001] The invention relates to a database access method and system, in particular to a database access proxy method and system based on SSL / XML. Background technique [0002] In some current systems, due to the large number of clients, the amount of access and data transmission is relatively large. In order to solve the corresponding bottlenecks and for safety considerations, middleware is often used to form a three-tier (multi-layer) application system. [0003] The two-tier architecture has exposed some problems in practical applications. For example, clients directly (or through stored procedures) access the database, and all clients access the database, which is not conducive to security control and difficult to prevent malicious attacks by hackers. At the same time, the network traffic is very large, which easily forms a network bottleneck. It will also cause database access bottlenecks and excessive database connections, which will affect the response spee...

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
Patent Type & Authority Applications(China)
IPC IPC(8): H04L29/08G06F9/46G06F17/30
Inventor 李曙强
Owner DATCENT TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products