Database middleware system

Abstract

The invention relates to a database middleware system which is connected with an external database. The database middleware system comprises a data processing communication component, a database processing component and an information management component, wherein the data processing communication component provides an application program interface for an external application program component soas to load a middleware system, and dispatches and manages the database middleware system to communicate with the external application pogram component through the msip protocol, thereby realizing communication between the external application program component and the external database; the database processing component comprises a shared database linking module and a database operation monitor module, and is used for detecting whether the link between the database middleware system and the external database is valid, and the shared database linking module communicates with the external database; and the information management component comprises a serve manager module, and is used for setting different processing priorities for different tasks, coordinating with the data processing communication component and the database processing component, and dynamically dispatching the tasks according to the set processing priorities and the relationship between the tasks and the positioned network environments.

Description

technical field [0001] The invention relates to the communication field, in particular to a database middleware used in the communication industry. Background technique [0002] At present, commercial databases such as Oracle, SQL Server, MySQL, etc. are all developed using c and c++, so the interface it provides is basically c API (application programming interface), so the previous databases used embedded c or c++, etc., which brings difficulties to the development system. Later, with the development of data technology, manufacturers of database management systems began to provide APIs in different languages ​​for different languages. The individual database management systems are not compatible. This brings great problems to software development, transplantation and expansion, which violates the idea of ​​software engineering. [0003] Based on the above background, database middleware technology emerges as the times require. The most typical one is Microsoft's databa...

AI Technical Summary

Problems solved by technology

[0002] At present, commercial databases such as Oracle, SQL Server, MySQL, etc. are all developed using c and c++, so the interface it provides is basically c API (application programming interface), so the previous databases used embedded c or c++, etc., which brings difficulties to the development system

Later, with the development of data technology, manufacturers of database management systems began to provide APIs in different languages ​​for different languages. Various database management systems are not compatible

There are different shortcomings in these technologies. For example, a CGI program cannot be shared by multiple client requests. Whenever a client request is received, even if there is an instance of the CGI program in motion, an identical instance must be restarted, i.e. Create a concurrent process. The more concurrent requests, the more concurrent processes are created, which takes up a lot of memory and limits the memory resources used by the application itself, and creating a process for each request will consume a lot of time. Multiple databases are required In the connected multi-user application, the use of CGI to connect to the database will inevitably increase the waiting time for users to connect to the database with the increase of users, which will reduce the performance of the system and eventually lead to the collapse of the system

For another example, the APIs are not compatible with each other, they can only run on specific servers and operating systems, due to the use of dynamic link libraries, once the code quality is poor, it is easier to cause the server system to crash, and the program design It will be more complicated, because they are too coupled with the specific database, the development and application flexibility is poor for different databases, and it depends on the specific platform and the corresponding database version, making it poor in portability, which leads to a longer development cycle Large, the reliability is difficult to guarantee

Images