CN1928873A - System and method for database access for implementing load sharing - Google Patents
System and method for database access for implementing load sharing Download PDFInfo
- Publication number
- CN1928873A CN1928873A CN 200610139791 CN200610139791A CN1928873A CN 1928873 A CN1928873 A CN 1928873A CN 200610139791 CN200610139791 CN 200610139791 CN 200610139791 A CN200610139791 A CN 200610139791A CN 1928873 A CN1928873 A CN 1928873A
- Authority
- CN
- China
- Prior art keywords
- data
- request
- major control
- agent
- query
- 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.)
- Granted
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The disclosed loading-share method for database access comprises: once receiving access request, the database agent decides the request type; for data request, the agent accesses the assist database to execute operation and respond result, end; for data update, the agent accesses the master database to update data. This invention can improve system performance without additional cost.
Description
Technical field
The present invention relates to database technical field, particularly a kind of data bank access method and system that realizes load sharing.
Background technology
Typical commercial telecommunication product has adopted cluster mode, to improve availability.Relating to the relevant solution of trooping of database also needs highly available.
Informix is a kind of large-scale data base management system (DBMS), has advanced technology, performance and reliability, uses very extensively in the various application in the world, comprises important industry or fields such as government, banking and insurance business, post and telecommunications, manufacturing and retail.Database server as Informix also will adopt High-availability Data Replication (HDR, High Availability Data Replication) pattern that high availability is provided.In the HDR solution, database server as the major control data storehouse with the main mode operation of using, another as secondary server with read-only mode operation.HDR can copy to the operation of carrying out on the auxiliary data base on the major control data storehouse.
Usually, agent data will be connected to the major control data storehouse, and carry out database manipulation.The agent data of operation will use data of database operating language (DML) to inquire about, and as insertion, deletion and selection etc., and these inquiries will be forwarded on the major control data storehouse.
At present, in telecommunications application or any other product of reaching the standard grade, system carries out two types operation.One type operation relates to be checked data, generates statistics and prepare a report according to statistical study on available data.The operation of another kind of type relates to be upgraded current data, new data is inserted database or deletes from database etc.
Referring to Fig. 1, it is the data base management system (DBMS) structural representation of existing employing HDR solution.Directly be connected between agent data 110 and the major control data storehouse 120, be connected between major control data storehouse 120 and the auxiliary data base 130.The agent data 110 that relates to the data continuation will use the database storing user's data.Can connect at least one application on the agent data 110, usually, agent data 110 will continue executable operations on database, to revise current data, to add new data, deletion available data or data query.And above-mentioned all operations is carried out by major control data storehouse 120, and under HDR mode, the operation that it is all of major control data storehouse copies on the auxiliary data base.
This shows,, will inevitably cause the bottleneck of server performance on the major control data storehouse because all operations are all carried out, solve bottleneck problem, the capacity that just needs to increase server to be improving its performance, and needs extra cost like this, causes the cost rising.
Summary of the invention
In view of this, the object of the present invention is to provide a kind of data bank access method and system that realizes load sharing,, and do not need the ancillary cost cost with the problem of settlement server bottleneck.
For achieving the above object, technical scheme of the present invention comprises:
A kind of data bank access method of realizing load sharing comprises:
After a, agent data receive the database access request, judge this request of access type, if the data query request, if execution in step b then is Data Update request, then execution in step c;
B, agent data visit auxiliary data base are carried out query manipulation by auxiliary data base, return Query Result information to agent data, finish;
The Data Update operation is carried out by the major control data storehouse in c, agent data visit major control data storehouse.
The major control data storehouse also comprises: return execution result information to agent data after carrying out Data Update.
Under the HDR pattern, the major control data storehouse further comprises: all operations is copied on the auxiliary data base after carrying out Data Update.
Agent data receives the data query request, comprise indication major control data storehouse in this request and carry out the information of query manipulation, afterwards, further comprise: agent data visit major control data storehouse, carry out query manipulation by the major control data storehouse, return Query Result information to agent data.
The described judgement of step a is to judge according to the sign in the database access request.
Described Data Update request comprises data interpolation request, data deletion request and data modification request;
Described renewal operation comprises: data interpolation, data deletion and data modification.
Described data query request comprises data query request, data statistics request, data analysis request;
Described query manipulation comprises inquiry, statistics, analyzes.
A kind of Database Systems that realize load sharing comprise: agent data, major control data storehouse and auxiliary data base, wherein,
Described agent data is used for sending the more operation requests of new data to the major control data storehouse, sends the operation requests of data query to auxiliary data base;
Described major control data storehouse is used for according to the Data Update request that receives, and carries out and upgrades operation;
Described auxiliary data base is used for carrying out query manipulation according to the data query request that receives, and returns execution result information to agent data.
Described major control data storehouse is further used for returning execution result information to agent data, under the HDR pattern, all operations is copied on the auxiliary data base.
Described agent data is further used for the operation requests to major control data storehouse transmission data query;
Described major control data storehouse is further used for carrying out query manipulation according to the data query request that receives, and returns execution result information to agent data.
Key of the present invention is after agent data receives the database access request, to judge this request of access type, if the data query request, then agent data visit auxiliary data base is carried out query manipulation by auxiliary data base, and return Query Result information to agent data, finish; If the Data Update request, then the Data Update operation is carried out by the major control data storehouse in agent data visit major control data storehouse.Use the present invention, make auxiliary data base share load on the major control data storehouse, thereby do not needing additionally to increase under the condition of cost, solve bottleneck problem, thereby promoted system performance.
Have again, in existing the application, when the major control data storehouse is comparatively idle,, can carry out operations such as statistical report form,, can avoid like this influencing calling out and wait the application of operation the major control data storehouse as ticket statistics, traffic volume measurement etc. are arranged usually as 2:00 AM.And used after the present invention, because auxiliary data base can be carried out operations such as inquiry, statistics, therefore, operation such as statistical report form also can as about 7 of evenings, generate from auxiliary data base in peak period, like this, can make the user time of wanting of what is the need in office obtain statistical data analysis.
For the application of inquiry class, other that do not influence the major control data storehouse are used, as therefore the graphical interfaces that is used for video data will, be equivalent to increase the number of users of major control data storehouse service to the not influence of major control data storehouse performance.
Have again, use,,, can as required, determine whether this inquiry is inquired about on auxiliary data base by using (promptly professional) as functions such as service level configuration information, call screenings as the inquiry of a lot of data at carrier class.Like this, also be equivalent to promote the performance in major control data storehouse.
Description of drawings
Fig. 1 is the data base management system (DBMS) structural representation of existing employing HDR solution.
Fig. 2 is a database access schematic flow sheet of realizing load sharing according to an embodiment of the invention;
Fig. 3 is the data base management system (DBMS) structural representation that adopts the HDR solution according to an embodiment of the invention.
Embodiment
Thinking of the present invention is: make auxiliary data base share load on the major control data storehouse, thereby solve bottleneck problem not needing additionally to increase under the condition of cost.
Below in conjunction with drawings and the specific embodiments, the present invention is described in further details.
Fig. 2 is a database access schematic flow sheet of realizing load sharing according to an embodiment of the invention.
After step 201, agent data receive the database access request of self-application, judge the type of this request of access according to the sign in the database access request, if the data query request, then execution in step 202, if the Data Update request, then execution in step 203.
Above-mentioned data query request comprises data query request, data statistics request, data analysis request etc.; Above-mentioned Data Update request comprises data interpolation request, data deletion request and data modification request etc.
Step 202, the intrasystem auxiliary data base of agent data accessing database is carried out query manipulation by auxiliary data base, and returns Query Result information to agent data, finishes.
Above-mentioned query manipulation comprises operations such as inquiry, statistics, analysis.
Step 203, the renewal data manipulation is carried out by the major control data storehouse in the intrasystem major control data of agent data accessing database storehouse.Under the HDR pattern, after new data is carried out more in the major control data storehouse, also need all operations is copied on the auxiliary data base, so that make system can realize the function that the data calamity is equipped with, guarantee high availability.
Certainly, after new data is carried out more in the major control data storehouse, can also return execution result information to agent data.
Above-mentioned renewal operation comprises: data interpolation, data deletion and data modification.
In addition, after agent data receives the data query request,, can also serve in the intrasystem major control data of accessing database storehouse according to the information of indication major control data storehouse execution query manipulation in this request, carry out query manipulation by the major control data storehouse, and return Query Result information to agent data.For example, using is that business can specify specific query manipulation still to use the major control data storehouse, and in card number service, the operation of inquiry card number remaining sum just can be specified and must be obtained by the major control data storehouse by business.Reason is that the data in major control data storehouse may exist of short duration (second level) to postpone when backuping to auxiliary data base.
Have again, use,,, can as required, determine whether this inquiry is inquired about on auxiliary data base by using (promptly professional) as functions such as service level configuration information, call screenings as the inquiry of a lot of data at carrier class.Like this, also be equivalent to promote the performance in major control data storehouse.
The invention also discloses a kind of Database Systems that realize load sharing, comprising: agent data 310, major control data storehouse 320 and auxiliary data base 330, wherein,
Agent data 310 is used for sending the more operation requests of new data to the major control data storehouse, sends the operation requests of data query to auxiliary data base.Certainly, on agent data 310, also having at least one application is that business is attached thereto.
Above-mentioned Data Update request comprises data interpolation request, data deletion request and data modification request; Above-mentioned data query request comprises data query request, data statistics request, data analysis request etc.
Major control data storehouse 320 is used for carrying out and upgrading operation according to the Data Update request that receives, and under the HDR pattern, all operations is copied on the auxiliary data base.The renewal operation that carry out in the major control data storehouse comprises: data interpolation, data deletion and data modification etc.
Have, major control data storehouse 320 can also be used for returning execution result information to agent data again.
Auxiliary data base 330 is used for carrying out query manipulation according to the data query request that receives, and returns execution result information to agent data.The query manipulation that auxiliary data base is carried out comprises inquiry, statistics, analysis etc.
Have, above-mentioned agent data can also be used for sending to the major control data storehouse operation requests of data query again; At this moment, the major control data storehouse also is used for carrying out query manipulation according to the data query request that receives, and returns execution result information to agent data.
The method of the invention and system are not limited to HDR, informix.Can be applied to any database that the two-shipper type is provided.As the data of Informix duplicate in addition enterprise duplicate (ER, EnterpriseReplication) etc.
The above is preferred embodiment of the present invention only, is not to be used to limit protection scope of the present invention.Several any modifications of being done within the spirit and principles in the present invention, be equal to replacement, improvement etc., all be included in protection scope of the present invention.
Claims (10)
1, a kind of data bank access method of realizing load sharing is characterized in that, comprising:
After a, agent data receive the database access request, judge this request of access type, if the data query request, if execution in step b then is Data Update request, then execution in step c;
B, agent data visit auxiliary data base are carried out query manipulation by auxiliary data base, return Query Result information to agent data, finish;
The Data Update operation is carried out by the major control data storehouse in c, agent data visit major control data storehouse.
2, method according to claim 1 is characterized in that, the major control data storehouse further comprises: return execution result information to agent data after carrying out Data Update.
3, method according to claim 1 and 2 is characterized in that, under High-availability Data Replication HDR pattern, the major control data storehouse further comprises: all operations is copied on the auxiliary data base after carrying out Data Update.
4, method according to claim 3, it is characterized in that, agent data receives the data query request, comprise indication major control data storehouse in this request and carry out the information of query manipulation, afterwards, further comprise: agent data visit major control data storehouse, carry out query manipulation by the major control data storehouse, return Query Result information to agent data.
5, method according to claim 1 is characterized in that, the described judgement of step a is to judge according to the sign in the database access request.
6, method according to claim 1 is characterized in that,
Described Data Update request comprises data interpolation request, data deletion request and data modification request;
Described renewal operation comprises: data interpolation, data deletion and data modification.
7, method according to claim 1 is characterized in that,
Described data query request comprises data query request, data statistics request, data analysis request;
Described query manipulation comprises inquiry, statistics, analyzes.
8, a kind of Database Systems that realize load sharing is characterized in that, comprising: agent data, major control data storehouse and auxiliary data base, wherein,
Described agent data is used for sending the more operation requests of new data to the major control data storehouse, sends the operation requests of data query to auxiliary data base;
Described major control data storehouse is used for according to the Data Update request that receives, and carries out and upgrades operation;
Described auxiliary data base is used for carrying out query manipulation according to the data query request that receives, and returns execution result information to agent data.
9, system according to claim 8 is characterized in that, described major control data storehouse is further used for returning execution result information to agent data, under the HDR pattern, all operations is copied on the auxiliary data base.
10, according to Claim 8 or 9 described systems, it is characterized in that,
Described agent data is further used for the operation requests to major control data storehouse transmission data query;
Described major control data storehouse is further used for carrying out query manipulation according to the data query request that receives, and returns execution result information to agent data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2006101397911A CN100403315C (en) | 2006-09-25 | 2006-09-25 | System and method for database access for implementing load sharing |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2006101397911A CN100403315C (en) | 2006-09-25 | 2006-09-25 | System and method for database access for implementing load sharing |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN1928873A true CN1928873A (en) | 2007-03-14 |
| CN100403315C CN100403315C (en) | 2008-07-16 |
Family
ID=37858836
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNB2006101397911A Expired - Fee Related CN100403315C (en) | 2006-09-25 | 2006-09-25 | System and method for database access for implementing load sharing |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN100403315C (en) |
Cited By (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101815094A (en) * | 2010-03-18 | 2010-08-25 | 中兴通讯股份有限公司 | Method, device and system for realizing data shared access |
| CN102402596A (en) * | 2011-11-07 | 2012-04-04 | 北京搜狗科技发展有限公司 | Reading and writing method and system of master slave separation database |
| CN101739435B (en) * | 2008-11-07 | 2012-05-09 | 中国移动通信集团公司 | Database access method and control device |
| CN102881050A (en) * | 2012-09-19 | 2013-01-16 | 中国联合网络通信集团有限公司 | Ticket processing method and system |
| CN103491155A (en) * | 2013-09-17 | 2014-01-01 | 北京思特奇信息技术股份有限公司 | Cloud computing method and system for achieving mobile computing and obtaining mobile data |
| CN103970807A (en) * | 2013-02-06 | 2014-08-06 | 阿里巴巴集团控股有限公司 | Method and system for managing database connection |
| CN104050297A (en) * | 2014-07-03 | 2014-09-17 | 中国工商银行股份有限公司 | Inquiry transaction distribution method and device |
| CN104166738A (en) * | 2014-09-04 | 2014-11-26 | 北京国双科技有限公司 | Database query processing method and device |
| CN106021375A (en) * | 2016-05-11 | 2016-10-12 | 深圳市永兴元科技有限公司 | Database access method and database agent node |
| CN106407351A (en) * | 2016-09-05 | 2017-02-15 | 乐视控股（北京）有限公司 | Data processing method and device applied to database |
| CN106850759A (en) * | 2016-12-31 | 2017-06-13 | 广州勤加缘科技实业有限公司 | MySQL database clustering methods and its processing system |
| CN106897303A (en) * | 2015-12-18 | 2017-06-27 | 北京国双科技有限公司 | Data query method and device |
| CN107705089A (en) * | 2017-09-26 | 2018-02-16 | 泰康保险集团股份有限公司 | Method for processing business, device and equipment |
| CN108509450A (en) * | 2017-02-27 | 2018-09-07 | 北京京东尚科信息技术有限公司 | For handling the newer method and apparatus of database high concurrent |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140358918A1 (en) * | 2012-01-27 | 2014-12-04 | Telefonaktiebolaget L M Ericsson (Publ) | Method and Apparatus for Handling Data-Related Requests |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| SE501433C2 (en) * | 1993-06-23 | 1995-02-13 | Ellemtel Utvecklings Ab | Ways to obtain data access in a primary memory-based database |
| CA2399401A1 (en) * | 2000-02-11 | 2001-08-16 | Acta Technology, Inc. | High availability database system using live/load database copies |
| US20020129145A1 (en) * | 2001-03-06 | 2002-09-12 | Accelerate Software Inc. | Method and system for real-time querying, retrieval and integration of data from database over a computer network |
| WO2005055084A1 (en) * | 2003-12-01 | 2005-06-16 | Thomson Licensing | Device and method for controlling access to information in a database, and associated products and methods |
-
2006
- 2006-09-25 CN CNB2006101397911A patent/CN100403315C/en not_active Expired - Fee Related
Cited By (21)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101739435B (en) * | 2008-11-07 | 2012-05-09 | 中国移动通信集团公司 | Database access method and control device |
| CN101815094A (en) * | 2010-03-18 | 2010-08-25 | 中兴通讯股份有限公司 | Method, device and system for realizing data shared access |
| CN102402596B (en) * | 2011-11-07 | 2016-01-20 | 北京搜狗科技发展有限公司 | A kind of reading/writing method of master slave separation database and system |
| CN102402596A (en) * | 2011-11-07 | 2012-04-04 | 北京搜狗科技发展有限公司 | Reading and writing method and system of master slave separation database |
| CN102881050A (en) * | 2012-09-19 | 2013-01-16 | 中国联合网络通信集团有限公司 | Ticket processing method and system |
| CN102881050B (en) * | 2012-09-19 | 2015-02-25 | 中国联合网络通信集团有限公司 | Ticket processing method and system |
| CN103970807A (en) * | 2013-02-06 | 2014-08-06 | 阿里巴巴集团控股有限公司 | Method and system for managing database connection |
| CN103970807B (en) * | 2013-02-06 | 2017-04-19 | 阿里巴巴集团控股有限公司 | Method and system for managing database connection |
| CN103491155A (en) * | 2013-09-17 | 2014-01-01 | 北京思特奇信息技术股份有限公司 | Cloud computing method and system for achieving mobile computing and obtaining mobile data |
| CN104050297A (en) * | 2014-07-03 | 2014-09-17 | 中国工商银行股份有限公司 | Inquiry transaction distribution method and device |
| CN104166738A (en) * | 2014-09-04 | 2014-11-26 | 北京国双科技有限公司 | Database query processing method and device |
| CN106897303A (en) * | 2015-12-18 | 2017-06-27 | 北京国双科技有限公司 | Data query method and device |
| CN106897303B (en) * | 2015-12-18 | 2020-09-15 | 北京国双科技有限公司 | Data query method and device |
| CN106021375A (en) * | 2016-05-11 | 2016-10-12 | 深圳市永兴元科技有限公司 | Database access method and database agent node |
| CN106021375B (en) * | 2016-05-11 | 2019-11-26 | 深圳市永兴元科技股份有限公司 | Data bank access method and database broker node |
| CN106407351A (en) * | 2016-09-05 | 2017-02-15 | 乐视控股（北京）有限公司 | Data processing method and device applied to database |
| CN106850759A (en) * | 2016-12-31 | 2017-06-13 | 广州勤加缘科技实业有限公司 | MySQL database clustering methods and its processing system |
| CN108509450A (en) * | 2017-02-27 | 2018-09-07 | 北京京东尚科信息技术有限公司 | For handling the newer method and apparatus of database high concurrent |
| CN108509450B (en) * | 2017-02-27 | 2022-04-12 | 北京京东尚科信息技术有限公司 | Method and device for processing high-concurrency update of database |
| CN107705089A (en) * | 2017-09-26 | 2018-02-16 | 泰康保险集团股份有限公司 | Method for processing business, device and equipment |
| CN107705089B (en) * | 2017-09-26 | 2021-06-15 | 泰康保险集团股份有限公司 | Service processing method, device and equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN100403315C (en) | 2008-07-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN1928873A (en) | System and method for database access for implementing load sharing | |
| CN1132109C (en) | System and method for efficient caching in a distributed file system | |
| CN1892664A (en) | Method and system for controlling access to resources | |
| CN1272721C (en) | Electronic document management method and program | |
| CN1716248A (en) | Concurrent transactions and page synchronization | |
| CN101079763A (en) | A remote configuration and management system and method of servers | |
| CN1516831A (en) | Wordload management of stateful program entities | |
| CN101063973A (en) | Method and system for the aggregation of data in multiple processing environments | |
| CN1848849A (en) | Method and device for replicating modifications of a directory | |
| CN1904885A (en) | Database adapter | |
| CN1494017A (en) | Holder selector used in global network service structure and its selection method | |
| CN101048767A (en) | Dynamic resource allocation | |
| CN1959676A (en) | Apparatus and method for materialized query table journaling in a computer database system | |
| CN1841320A (en) | Method and system for managing dynamic configuration data | |
| CN1717686A (en) | Automatic data consolidation | |
| US7188111B2 (en) | System and method for connectivity to structured query language database | |
| CN1808389A (en) | Autonomous locking method based on shared memory for account background memory database | |
| CN1869933A (en) | Computer processing system for implementing data update and data updating method | |
| CN1555532A (en) | Temporary directory management | |
| CN1265288C (en) | Multi-level security profile refresh method and system | |
| CN1940929A (en) | LDAP to SQL database proxy system and method | |
| CN1633080A (en) | Method for implementing log in network management system | |
| CN1351299A (en) | Method and device for accessing database | |
| CN1946035A (en) | Method for managing net element data configuration and net element | |
| CN1610350A (en) | Business transmitting method based on soft exchange network |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| C17 | Cessation of patent right | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20080716 Termination date: 20120925 |