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

Access drive and data access method of proxy database

A data access and database technology, applied in the access-driven field of proxy databases, can solve the problems of complex and difficult use of terminal software without GUI programs and databases, achieve safe and rapid data access, facilitate cross-service data integration and remote debugging and maintenance Effect

Inactive Publication Date: 2014-01-01
雷虹
View PDF2 Cites 23 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, B / S-based network software systems have many restrictions on data access, and are used in remote data maintenance where high security is required
Considering the security factor, generally, when exchanging data between servers, the database cannot be accessed directly through its own terminal software on the external network. If access is required, it needs to enter its internal network environment (such as remote desktop, etc.). The difficulty is relatively high, and at the same time, the terminal software of many databases is relatively complicated to use, and there is even no good GUI program to use

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
  • Access drive and data access method of proxy database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0028] An access driver of a proxy database, the proxy database access driver includes: a JDBC standard driver class, a database connection class, a database execution class, a database record set, and a service class that provides data proxy services and can be accessed using a URL.

[0029] A proxy database data access method based on this driver design implements a proxy database driver that conforms to the JDBC driver standard. It uses URL input and output streams to read and write to achieve data access. The process of this method is as follows figure 1 shown, proceed as follows:

[0030] (1) Deploy the proxy database access driver in the remote WEB application, set the access user and password, and form the server for proxy database access;

[0031] (2) Set the database configuration of the local WEB application as the parameters driven by the proxy database access, including: the type of remote database, the service address port of the remote application, the security a...

Embodiment 2

[0040] An access driver of a proxy database, the proxy database access driver includes: a JDBC standard driver class, a database connection class, a database execution class, a database record set, and a service class that provides data proxy services and can be accessed using a URL.

[0041] A proxy database data access method based on this driver design implements a proxy database driver that conforms to the JDBC driver standard. It uses URL input and output streams to read and write to achieve data access. The process of this method is as follows figure 1 shown, proceed as follows:

[0042] (1) Deploy the proxy database access driver in the remote WEB application, set the access user and password, and form the server for proxy database access;

[0043] (2) Set the database configuration of the local WEB application as the parameters driven by the proxy database access, including: the type of remote database, the service address port of the remote application, the security a...

Embodiment 3

[0052] An access driver of a proxy database, the proxy database access driver includes: a JDBC standard driver class, a database connection class, a database execution class, a database record set, and a service class that provides data proxy services and can be accessed using a URL.

[0053] A proxy database data access method based on this driver design implements a proxy database driver that conforms to the JDBC driver standard. It uses URL input and output streams to read and write to achieve data access. The process of this method is as follows figure 1 shown, proceed as follows:

[0054] (1) Deploy the proxy database access driver in the remote WEB application, set the access user and password, and form the server for proxy database access;

[0055] (2) Set the database configuration of the local WEB application as the parameters driven by the proxy database access, including: the type of remote database, the service address port of the remote application, the security a...

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 belongs to the technical field of software development, and particular discloses an access drive and a data access method of a proxy database. The data access method includes that a web application with a proxy component is deployed in a web service which can be directly connected with a database service, wherein the web application includes an actual JDBC (java database connectivity) database drive capable of accessing a connected database; safety authorization information accessed by the proxy database is configured in a configuration file corresponding to the web application, and a server side accessed by the proxy database is formed after releasing; only parameters of a corresponding proxy database access drive need to be configured in a local web application to access an actual database data through connection to the server side accessed by the proxy database in case of incapability of directly connecting to the actual database, all database operations such as adding, deleting and correcting can be performed, and complete proxy of an actual database JDBC drive can be realized. The access drive can access data safely and rapidly in a B / S (browser / server) mode, and convenience is brought to completion of cross-service data integration and remote debugging and maintaining.

Description

technical field [0001] The invention belongs to the technical field of software development, and in particular relates to an access driver of a proxy database and a data access method thereof. Background technique [0002] The B / S structure (Browser / Server, browser / server mode) is a network structure mode after the rise of the WEB, and the WEB browser is the most important application software for the client. This mode unifies the client, concentrates the core part of system function realization on the server, and simplifies the development, maintenance and use of the system. Just install a browser (Browser) on the client computer, such as Netscape Navigator or Internet Explorer, and install Oracle, Sybase, Informix or SQL Server and other databases on the server. The browser interacts with the database through the Web Server. [0003] The biggest advantage of B / S is that it can be operated anywhere without installing any special software. It can be used as long as there i...

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/30
CPCG06F16/90335
Inventor 雷虹
Owner 雷虹
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