Java data base connectivity (JDBC)-based data distributed processing method

Abstract

The invention relates to a Java data base connectivity (JDBC)-based data distributed processing method, which comprises the following steps of: 1) setting a virtual database JDBC driver packet file in a client or a Web application program, establishing a virtual database connection, and sending a structured query language (SQL) calling request to a virtual database according to the JDBC specifications; 2) setting parameters in the virtual database, establishing a connection between a JDBC driver layer and each entity database, and caching and / or storing the data in a plurality of databases of a distributed system; and 3) receiving the data SQL calling request by a data distributed processor of the virtual database, and performing statement analysis and distribution, so that distributed processing of the data is realized. According to the method, the data processing capacity of the original program can be improved only by adding the virtual database driver packet into a class loading path of the original application program and simply configuring the virtual database; and the method is strong in expansibility, the data storage capacity can be improved in a vertical expansion mode, and the concurrent processing capacity can also be improved in a transverse expansion mode.

Description

technical field [0001] The invention relates to data processing, in particular to a JDBC-based data distributed processing method, which belongs to the field of data storage and retrieval. Background technique [0002] When the scale of data processed by the application system continues to increase, there are generally two ways to meet the storage and processing requirements of these massive data. One is to use minicomputers and mainframes with higher performance, and the other is to use ordinary machines. of clusters. Because the cluster has an outstanding cost performance, it has largely replaced the mainframe, and the application on the Web server and application server is a good example. JDBC (Java Data Base Connectivity, java database connection) is a Java API for executing SQL statements, which can provide unified access to various relational databases. It consists of a set of classes and interfaces written in the Java language. JDBC provides a baseline against which...

AI Technical Summary

Problems solved by technology

The obvious defect of these technologies is that in order to realize the characteristics of the cluster, the database engine must be extended, so the application program needs to use some additional APIs. API (Application Programming Interface, application programming interface) is some predefined functions, the purpose is to provide The ability for a developer to access a set of routines based on a piece of software or hardware without having access to the source code, or understanding the details of the inner workings

and it's difficult for different implementations of these different technologies to work with each other

Images