Method and system for realizing unified processing of multiple database data through middleware

Abstract

The invention relates to the technical field of databases, and discloses a method and system for achieving unified processing on multiple databases through middleware. The method includes the following steps: mapping each data list in the databases into an XML file; sending data requests of a user to the middleware through application software, conducting analysis after the middleware receives the data requests of the application software of a client terminal, and generating corresponding SQL statements according to contents of the data requests; displaying data through a unified client terminal access interface API, conducting data binding on HTML files on a front end page after a presentation layer receives the data, conducting data binding on nodes in the HTML files and obtained XML nodes, and accordingly conducting data display. The invention further discloses a system for achieving unified processing on the multiple databases through the middleware. The corresponding SQL statements are automatically generated according to the data requests, excessively-tight binding and excessively-tight limiting between an application layer and the databases are avoided, and rapid transplantation and rapid management on the multiple databases are accordingly achieved.

Description

technical field [0001] The invention belongs to the field of information system development and database technology, and in particular relates to a method and system for realizing unified processing of various database data through middleware. Background technique [0002] Database refers to a collection of data stored together in a certain way, can be shared by multiple users with as little redundancy as possible, and it is independent of the application program. Databases in the prior art include ORACLE, DB2, SQLServer, Sybase, Informix, MySQL, VF, Access and the like. [0003] In the prior art, the application software uses a specific database as the center of the data layer processing, and the database access interface and syntax are all performed on the standard SQL, which leads to too much communication between the access of the application layer and the specific database. Due to tight binding and constraints, there is no method for unified processing of data in multi...

AI Technical Summary

Problems solved by technology

[0005] The purpose of the present invention is to solve the technical problems in the prior art that the client program is too closely bound to the database, which leads to the difficulty in developing the client program and the limited selection of user databases. The method of the present invention avoids the problem that the client program and the database are bound too tightly

Images