CN103838719A - Design method for database connection middleware - Google Patents
Design method for database connection middleware Download PDFInfo
- Publication number
- CN103838719A CN103838719A CN201210468889.7A CN201210468889A CN103838719A CN 103838719 A CN103838719 A CN 103838719A CN 201210468889 A CN201210468889 A CN 201210468889A CN 103838719 A CN103838719 A CN 103838719A
- Authority
- CN
- China
- Prior art keywords
- database
- connection
- middleware
- client
- database connection
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
A design method for database connection middleware is an important aspect of conducting the performance optimization to a loose coupling distributed information system, and research on the database connection middleware is conducted. The design method enables customs to share the database connection, effectively improves the access of users to the database, optimizes the network transfer performance, and supports the connections of databases of multi-kind relationships.
Description
Technical field
The method for designing that the present invention relates to a kind of Database Connection Middleware mainly relates to the data storage technology in computer realm.
Background technology
In some application of loosely-coupled distributed information system, on network, there will be a large number of users to access the situation of a database server simultaneously, and this service connection of each user meeting maintenance within a period of time, thereby limit available linking number.
Summary of the invention
Retrieve and there is no to find the application materials about this system aspects by national patent.
The present invention uses database connection management process independently that the service of connection management is provided, client is not direct and database server connects, but connect by database connection management process, various database manipulations also complete by this database connection management process, in fact between Client application and database server, increase again exactly one deck middleware, namely so-called database middleware.
Many clients share same database and connect, and this connected mode can make multiple clients share a database to connect, and greatly alleviate customer quantity and are subject to database user number and limit the problem causing.Database middleware, with Buffer Pool mode managed database, has alleviated expense when foundation is connected with turn-off data storehouse.The part relevant with RDBMS interface is limited in database connection management, makes to support that heterogeneous database is convenient.
This database connection scheme adopts named data storehouse connects in middleware environments mode, define available database connects (logic connection), and (RDBMS, DATABASE, USER, PASSWORD) specified in each connection.In the time using these to connect, only need to use the name connecting and other inner details are no longer provided.This mode contributes to reduce the dependence of user program to specific environment, in the time that RDBMS adjusts, can avoid unnecessary modification of program by the definition of revising middleware environments.
Make multiple users can share the physical connection to a database, parameter (the RDBMS adopting while just requiring these users to be connected with database, DATABASE, USER, PASSWORD) consistent, the database that only has connection on all four two databases connections of parameter (logic connection) can share a physics connects.
The connection name that database middleware externally provides, is all to define in the environment of himself, rather than the true name of associated databases.These names are called the logical database name of database middleware.Database middleware need to be managed these logical data bases.In database middleware, the name of each logical data base is unique, and corresponding to certain physical database.Each logical data base comprises one group of definition information, comprise: physical data base name, database connect user name, database connects user password etc., can realize the access control function of logical data base, define calling party, the password of logical data base, in the time that client computer creates connection, check access control, avoid unauthorized access.
It is all that logic connects that the database that the client of database middleware creates connects, and these physical connections that are mapped to database middleware and database while being connected to practical operation database get on, and connect operating database practically by these.The method that this multiple client shares physical database connection is:
(1) it is identical in logic that the database that can share the user of physical connection is connected to, that is to say, be connected in same database and go with same database user, only have the identical connection could phase trans-substitution and do not produce problem in logic.Database middleware externally provides logical data base service, and as long as being connected to the user in same logical data base, its database connected mode is exactly identical, also just can share physical connection.
(2) affairs are externally base units of service of database.The client physical connection of must perfecting monopoly in single affairs, now can not share physical connection with other users.In the time that affairs finish, if there is no movable SQL statement, this client has not had special state resource in this physical connection.Client under this state can share physical connection each other.Based on the feature of issued transaction, the management of database physical connection is just carried out at beginning, the termination phase of affairs.In the time that affairs start, need to distribute physical database to connect; In the time of service termination, release physical database connects.The logical database name that client provides by database middleware connects, in the time that client sends SQL request on this logic connects, DBCM is that this logic connects the available physical connection (not having qualified physical connection if current with regard to newly-built) of distributing correspondence, communicates by letter with database server by the physical connection of distributing.Idle management thread, regularly at running background, checks the use state of physical connection, if certain physical connection is not used (overtime) for a long time, disconnects with releasing resource.
The prototype of the database middleware designing by the present invention has completed following function:
(1) effectively improve the access performance of multi-user to database;
(2) transmission of minimizing network information;
(3) optimized network transmission performance;
(4) support and being connected of multiple relational database;
(5) both support similar stateless and be once connected, and also supported application to have the connection of state and continuation.
Claims (3)
1. the method for designing of a Database Connection Middleware is characterized in that using the interface of JDBC middleware.
2. use Stream Socket technology; Transmission control protocol Transmission Control Protocol provides a kind of reliable end to end communication passage; Server application is intercepted particular port, waits for the connection request from client.In the time that a connection request arrives, between client and server, set up special a connection, they just communicate by letter in this connection.In connection procedure, client is assigned with a local port number, and a socket is tied to this port.Client is by socket writing information and read out mode and the server communication from the information of server from socket.
3. the method for designing of a Database Connection Middleware is used multithreading.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210468889.7A CN103838719A (en) | 2012-11-20 | 2012-11-20 | Design method for database connection middleware |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210468889.7A CN103838719A (en) | 2012-11-20 | 2012-11-20 | Design method for database connection middleware |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103838719A true CN103838719A (en) | 2014-06-04 |
Family
ID=50802235
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210468889.7A Pending CN103838719A (en) | 2012-11-20 | 2012-11-20 | Design method for database connection middleware |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103838719A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105373563A (en) * | 2014-08-28 | 2016-03-02 | 北京奇虎科技有限公司 | Database switching method and apparatus |
| CN108259417A (en) * | 2016-12-28 | 2018-07-06 | 华为技术有限公司 | A kind of method for processing business, apparatus and system |
| CN110135146A (en) * | 2019-04-29 | 2019-08-16 | 武汉中锐源信息技术开发有限公司 | A kind of data base authority management method and system |
-
2012
- 2012-11-20 CN CN201210468889.7A patent/CN103838719A/en active Pending
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105373563A (en) * | 2014-08-28 | 2016-03-02 | 北京奇虎科技有限公司 | Database switching method and apparatus |
| CN108259417A (en) * | 2016-12-28 | 2018-07-06 | 华为技术有限公司 | A kind of method for processing business, apparatus and system |
| CN108259417B (en) * | 2016-12-28 | 2020-07-24 | 华为技术有限公司 | Service processing method, device and system |
| CN110135146A (en) * | 2019-04-29 | 2019-08-16 | 武汉中锐源信息技术开发有限公司 | A kind of data base authority management method and system |
| CN110135146B (en) * | 2019-04-29 | 2021-04-02 | 武汉中锐源信息技术开发有限公司 | Database authority management method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| AU2017218964B2 (en) | Cloud-based distributed persistence and cache data model | |
| CN102567495B (en) | Mass information storage system and implementation method | |
| EP3365805B1 (en) | Ability to group multiple container databases as a single container database cluster | |
| CN106503163B (en) | Global configuration multi-tenant dynamic data source system based on SaaS application | |
| CN101256650B (en) | Method and system for extracting enterprise data based on service entity | |
| CN100481086C (en) | Space data clustered storage system and data searching method | |
| CN104639654A (en) | Integrated access system and integrated access method for mass electricity information acquisition terminals | |
| US7925002B2 (en) | Administering multiple target ACD systems | |
| CN103605727A (en) | Connection pool based efficient multiuser database access optimization method and framework | |
| KR100671506B1 (en) | A mobile middleware and a method for processing business logic using it | |
| CN102917006B (en) | A kind of unified control and management method and device realizing computational resource and object permission | |
| CN102110099A (en) | Heterogeneous database middleware access technique based on endowment insurance warning system | |
| CN103838781A (en) | Database access method and system | |
| CN102063502A (en) | Method for realizing synchronization of data in heterogeneous database | |
| CN102323947A (en) | Generation method of pre-join table on ring-shaped schema database | |
| CN103455540A (en) | System and method of generating in-memory models from data warehouse models | |
| CN109241054A (en) | A kind of multimodal data library system, implementation method and server | |
| CN104850509A (en) | Method and system for operating bank business data memory cache | |
| CN105808776A (en) | Data management system and method of distributed database | |
| CN102004634A (en) | Hierarchical business management system | |
| CN105930417B (en) | A kind of big data ETL interactive process platform based on cloud computing | |
| CN102314480A (en) | Distributed data storage method specific to mass data | |
| CN103838719A (en) | Design method for database connection middleware | |
| CN103336782A (en) | Relational distributed database system | |
| CN103064964B (en) | A kind of method of attachment supporting the database of distributed transaction |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20140604 |