CN102006282A - Centralized control method for database access in client/server mode - Google Patents
Centralized control method for database access in client/server mode Download PDFInfo
- Publication number
- CN102006282A CN102006282A CN2010105198345A CN201010519834A CN102006282A CN 102006282 A CN102006282 A CN 102006282A CN 2010105198345 A CN2010105198345 A CN 2010105198345A CN 201010519834 A CN201010519834 A CN 201010519834A CN 102006282 A CN102006282 A CN 102006282A
- Authority
- CN
- China
- Prior art keywords
- database
- client
- access
- access control
- control service
- 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
Images
Abstract
The invention provides a centralized control method for database access in a client/server mode, which is characterized in that the devices for realizing the method comprise a database server, and the database server is provided with a database access control server and a database, wherein the database access control server is equipped with a client message queue containing client identifiers, access priorities, client states and wait times, and accesses to the database regularly through judging corresponding client identifiers and client states included in the client message queue, thereby realizing the centralized control of database access and preventing the occurrence of the phenomenon that a plurality of clients accesses the database simultaneously. Under the condition of not increasing the overhead for server hardware, the method of the invention can be used for solving the problem that the processing speed of the server is slow when a plurality of clients accesses to the database simultaneously without affecting original service processes.
Description
[technical field]
The present invention relates to a kind of computer application system technical field, relate in particular to the database access centralized control method under a kind of customer end/server mode.
[background technology]
In general, owing to there are a plurality of users in database, to store data,, which user can login, inquire about, upgrade or delete which data to and to control by the access of database controlling organization.Below, be referred to as access of database database being carried out data entry, inquiry, renewal or deletion.Traditional access control method to database, the general following manner of using, promptly the authentication information that combines by user ID that the user is provided database and password etc. is compared with the authentication information of logining in advance in the database access controlling organization, determine to want the user of accessing database, secondly, for fixed user,, determine whether its visit to each data is licensed according to having set the access control list (AccessContr01 List) that to visit which data.Here it is by method that existing many databases adopted, SQL92 is as the language standard who is used for database is conducted interviews, regulation is by using grant statement and revoke statement, in access control list, increase or the deletion access authority information, to authorize or to cancel the access rights of user data.
The Chinese invention patent publication number is the 1701315th, open day for disclosing a kind of database access control method, control device and agent processes server unit among the 2005.11.23, the database access control device is according to the user ID of user's set, generates access key and it is stored.And the database access control device sends to user's set with this access key with the address of agent processes server unit.User's set sends access key to the agent processes server unit when proposing the database access request, the agent processes server unit sends access key to the database access control device when proposing the database processing request.The database access control device is when receiving the database processing request, whether store in the access control apparatus of judgment data storehouse and the identical access key of access key that receives from this agent processes server unit, only under the situation that this access key exists, just database is conducted interviews.
POS in the present KTV place adopts the two-tier system pattern of " client/server " more, and the client POS is come the synchronous service data by the timer access server database.In the business process, there is a strong possibility a plurality of client POSs accessing database simultaneously occurs, in this case, to consume the server ample resources, if server performance is not good words, the processing speed of server is fast inadequately, can cause the client reaction slack-off, the user can't accept.And above method database server of inapplicable KTV all.
[summary of the invention]
The technical problem to be solved in the present invention, be to provide the method for the database access centralized control under a kind of customer end/server mode, under the situation that does not increase the server hardware expense, can settlement server in a plurality of clients slow problem of processing speed during accessing database simultaneously, do not influence original operation flow simultaneously.
The present invention is achieved in that the database access centralized control method under a kind of customer end/server mode, comprises database service, it is characterized in that: may further comprise the steps:
Step 10, described database server are equipped with database access control service and database, and described database access control service is provided with a client-side information formation and an asynchronous controlled quentity controlled variable that includes client identification, access privileges, state of living in, stand-by period;
Step 20, when a client-access database, client sends the accessing database solicited message by communications protocol to described database access control service;
The solicited message that described database access control service is received in step 30, described database access control service is added in the described client-side information formation, and the state information of living in of client is set to wait state;
Step 40, the described client-side information formation of database access control service traversal, and statistics is in the client terminal quantity of Access status, judge and be in the client terminal quantity of Access status less than described asynchronous controlled quentity controlled variable? be, then database access control service will notify the client that is in wait state to carry out database access by access privileges order and client application from high to low in proper order, and the state information of living in of client is set to Access status, at this moment, database access control service is added up to visiting the time that database finishes its client-access database, and wait for the signal that its client feedback accessing database finishes, otherwise be in the client continuation maintenance wait state of wait state;
Step 50, whether judge the described time that comes out greater than the stand-by period in the described client-side information formation, not, then database access control service is deleted the corresponding client client information from the client-side information formation; The Access status that is its client-side information of then database access control service is set to timeout mode, and waits for when signal that client finishes described accessing database is passed back, with its clients corresponding information deletion;
When step 60, database access control service receives the signal that accessing database solicited message that client sends or accessing database finish, continue step 40.
The present invention has following advantage: the present invention comes the timer access database by judging residing state of clients corresponding and the sign in the client-side information formation, thereby fulfillment database visit centralized control has prevented a plurality of clients accessing database simultaneously.The present invention under the situation that does not increase the server hardware expense, can settlement server in a plurality of clients slow problem of processing speed during accessing database simultaneously, do not influence original operation flow simultaneously.
[description of drawings]
Fig. 1 is the inventive method schematic flow sheet.
Fig. 2 is a network topology structural representation of the present invention.
[embodiment]
The present invention is further illustrated in conjunction with the embodiments below with reference to Fig. 1, Fig. 2.
As shown in Figure 1, the database access centralized control method under a kind of customer end/server mode comprises database service, and its step is as follows:
Step 10, described database server are equipped with database access control service and database, and described database access control service is provided with a client-side information formation (being called for short IOC) and an asynchronous controlled quentity controlled variable (being called for short SCNT) that includes client identification, access privileges, state of living in, stand-by period;
Step 20, when a client-access database, client sends accessing database solicited message (being called for short DBQ) by communications protocol (as udp protocol etc.) to described database access control service, and described accessing database solicited message comprises client identification, access privileges, state of living in, stand-by period;
Step 30, the information (DBQ) of asking that described database access control service is received are added in the described client-side information formation, and the state information of living in of client is set to wait state;
Step 40, the described client-side information formation of database access control service traversal, and statistics is in the client terminal quantity of Access status, judge and be in the client terminal quantity of Access status less than described asynchronous controlled quentity controlled variable? be, then database access control service will notify the client that is in wait state to carry out database access by access privileges order and client application order (being queue sequence) from high to low, and the state information of living in of client is set to Access status, at this moment, database access control service is added up to visiting the time that database finishes its client-access database, and wait for the signal (being called for short FIN) that its client feedback accessing database finishes, otherwise be in the client continuation maintenance wait state of wait state;
Step 50, whether judge the described stand-by period that comes out greater than the stand-by period in the described client-side information formation, not, then database access control service is deleted the corresponding client client information from the client-side information formation; The Access status that is its client-side information of then database access control service is set to timeout mode, the client terminal quantity of overtime state is not counted in the client terminal quantity that is in Access status, whether the quantity that so just can effectively judge the client that is in Access status is less than asynchronous quantities of vacancy, and wait for when signal that client finishes described accessing database is passed back, its clients corresponding information deletion;
Whether step 60, judgment data storehouse access control service receive the accessing database solicited message of client transmission or the signal that accessing database finishes, and are then to continue step 40.
Wherein database is conducted interviews is behind the signal (ACK) of receiving the beginning accessing database to client, and the beginning accessing database after visit finishes, sends signal that accessing database finishes to database access control service.
As shown in Figure 2, for network topology structural representation of the present invention, comprise client, database server.Database access control service and database wherein are installed in the database server, and described database access control service is provided with a client-side information formation (IOC).
Here be noted that each information implication of client-side information formation, client identification: each client is different from the unique identification of other clients, such as the IP address.Access privileges: the priority level of record client-access database is divided into 5 grades: highest, senior, common, rudimentary, lowermost level, the priority access database that grade is high.Access status: be divided into " wait ", " visit ", " overtime " three kinds of states.Stand-by period: from certain client-access database, the time that its client-access database finishes is waited in database access control service.Asynchronous controlled quentity controlled variable (SCNT): be to allow the client quantity of accessing database simultaneously.
In a word, the present invention comes the timing controlled accessing database by judging residing state of corresponding client and the sign in the client-side information formation, thereby fulfillment database visit centralized control has prevented a plurality of clients accessing database simultaneously.
The above only is preferred embodiment of the present invention, and all equalizations of being done according to the present patent application claim change and modify, and all should belong to covering scope of the present invention.
Claims (3)
1. the database access centralized control method under the customer end/server mode comprises database service, it is characterized in that: may further comprise the steps:
Step 10, described database server are equipped with database access control service and database, and described database access control service is provided with a client-side information formation and an asynchronous controlled quentity controlled variable that includes client identification, access privileges, state of living in, stand-by period;
Step 20, when a client-access database, client sends the accessing database solicited message by communications protocol to described database access control service;
The solicited message that described database access control service is received in step 30, described database access control service is added in the described client-side information formation, and the state information of living in of client is set to wait state;
Step 40, the described client-side information formation of database access control service traversal, and statistics is in the client terminal quantity of Access status, judge and be in the client terminal quantity of Access status less than described asynchronous controlled quentity controlled variable? be, then database access control service will notify the client that is in wait state to carry out database access by access privileges order and client application from high to low in proper order, and the state information of living in of client is set to Access status, at this moment, database access control service is added up to visiting the time that database finishes its client-access database, and wait for the signal that its client feedback accessing database finishes, otherwise be in the client continuation maintenance wait state of wait state;
Step 50, whether judge the described time that comes out greater than the stand-by period in the described client-side information formation, not, then database access control service is deleted the corresponding client client information from the client-side information formation; The Access status that is its client-side information of then database access control service is set to timeout mode, and waits for when signal that client finishes described accessing database is passed back, with its clients corresponding information deletion;
When step 60, database access control service receives the signal that accessing database solicited message that client sends or accessing database finish, continue step 40.
2. the database access centralized control method under the customer end/server mode according to claim 1 is characterized in that: described accessing database solicited message comprises client identification, access privileges, state of living in, stand-by period.
3. the database access centralized control method under the customer end/server mode according to claim 1, it is characterized in that: in the described step 40 client to database conduct interviews be receive the beginning accessing database signal after, the beginning accessing database, after visit finished, the signal that the transmission accessing database finishes was to database access control service.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN2010105198345A CN102006282A (en) | 2010-10-26 | 2010-10-26 | Centralized control method for database access in client/server mode |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN2010105198345A CN102006282A (en) | 2010-10-26 | 2010-10-26 | Centralized control method for database access in client/server mode |
Publications (1)
Publication Number | Publication Date |
---|---|
CN102006282A true CN102006282A (en) | 2011-04-06 |
Family
ID=43813353
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN2010105198345A Pending CN102006282A (en) | 2010-10-26 | 2010-10-26 | Centralized control method for database access in client/server mode |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN102006282A (en) |
Cited By (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104052677A (en) * | 2013-03-14 | 2014-09-17 | 阿里巴巴集团控股有限公司 | Soft load balancing method and apparatus of single data source |
CN105786806A (en) * | 2014-12-15 | 2016-07-20 | 钟叶青 | Synchronizing system for database conversion and method for same |
CN106371873A (en) * | 2016-08-31 | 2017-02-01 | 苏州蓝海彤翔系统科技有限公司 | Application starting request processing method and system and server |
CN106850835A (en) * | 2017-03-01 | 2017-06-13 | 北京索瑞特医学技术有限公司 | Data processing method and device |
CN107688607A (en) * | 2017-07-26 | 2018-02-13 | 努比亚技术有限公司 | The method and mobile terminal of a kind of database access, computer-readable recording medium |
CN109510850A (en) * | 2017-09-14 | 2019-03-22 | 广州市动景计算机科技有限公司 | The processing method of browse request, apparatus and system |
CN110046144A (en) * | 2019-03-25 | 2019-07-23 | 阿里巴巴集团控股有限公司 | Access the method, device and equipment of database |
CN116208680A (en) * | 2023-05-04 | 2023-06-02 | 成都三合力通科技有限公司 | Server access management system and method |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5249290A (en) * | 1991-02-22 | 1993-09-28 | At&T Bell Laboratories | Method of and apparatus for operating a client/server computer network |
JP2001312424A (en) * | 2000-04-28 | 2001-11-09 | Fujitsu Ltd | Database system and transaction control method |
CN1819594A (en) * | 2005-02-09 | 2006-08-16 | 株式会社日立制作所 | Congestion controller and method for controlling congestion of network |
CN1932875A (en) * | 2006-10-09 | 2007-03-21 | 杭州东信金融技术服务有限公司 | Prepositional system based on finance industry |
CN1987864A (en) * | 2006-12-31 | 2007-06-27 | 中国建设银行股份有限公司 | Method and system for access data base |
-
2010
- 2010-10-26 CN CN2010105198345A patent/CN102006282A/en active Pending
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5249290A (en) * | 1991-02-22 | 1993-09-28 | At&T Bell Laboratories | Method of and apparatus for operating a client/server computer network |
JP2001312424A (en) * | 2000-04-28 | 2001-11-09 | Fujitsu Ltd | Database system and transaction control method |
CN1819594A (en) * | 2005-02-09 | 2006-08-16 | 株式会社日立制作所 | Congestion controller and method for controlling congestion of network |
CN1932875A (en) * | 2006-10-09 | 2007-03-21 | 杭州东信金融技术服务有限公司 | Prepositional system based on finance industry |
CN1987864A (en) * | 2006-12-31 | 2007-06-27 | 中国建设银行股份有限公司 | Method and system for access data base |
Cited By (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104052677A (en) * | 2013-03-14 | 2014-09-17 | 阿里巴巴集团控股有限公司 | Soft load balancing method and apparatus of single data source |
CN104052677B (en) * | 2013-03-14 | 2018-04-10 | 阿里巴巴集团控股有限公司 | The soft load-balancing method and device of data mapping |
CN105786806A (en) * | 2014-12-15 | 2016-07-20 | 钟叶青 | Synchronizing system for database conversion and method for same |
CN105786806B (en) * | 2014-12-15 | 2018-12-04 | 钟叶青 | The synchronization system and its method of database conversion |
CN106371873A (en) * | 2016-08-31 | 2017-02-01 | 苏州蓝海彤翔系统科技有限公司 | Application starting request processing method and system and server |
CN106850835A (en) * | 2017-03-01 | 2017-06-13 | 北京索瑞特医学技术有限公司 | Data processing method and device |
CN106850835B (en) * | 2017-03-01 | 2020-07-17 | 北京索瑞特医学技术有限公司 | Data processing method and device |
CN107688607A (en) * | 2017-07-26 | 2018-02-13 | 努比亚技术有限公司 | The method and mobile terminal of a kind of database access, computer-readable recording medium |
CN109510850A (en) * | 2017-09-14 | 2019-03-22 | 广州市动景计算机科技有限公司 | The processing method of browse request, apparatus and system |
CN110046144A (en) * | 2019-03-25 | 2019-07-23 | 阿里巴巴集团控股有限公司 | Access the method, device and equipment of database |
CN116208680A (en) * | 2023-05-04 | 2023-06-02 | 成都三合力通科技有限公司 | Server access management system and method |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN102006282A (en) | Centralized control method for database access in client/server mode | |
EP2733909B1 (en) | Terminal control method and device, and terminal | |
US8463627B1 (en) | Systems and methods for queuing requests and providing queue status | |
EP1703699B1 (en) | Systems, method and session manager for web-based applications | |
AU2012207471B2 (en) | Systems and methods for group bandwidth management in a communication systems network | |
JP3415456B2 (en) | Network system, command use authority control method, and storage medium storing control program | |
WO2016026330A1 (en) | License sharing method and apparatus | |
CN101217368A (en) | A network logging on system and the corresponding configuration method and methods for logging on the application system | |
CN103404103A (en) | System and method for combining an access control system with a traffic management system | |
CN101771723A (en) | Data synchronization method | |
CN101459836B (en) | Service processing method and system for content distributing network of interactive network television | |
CN109862565A (en) | A kind of WLAN unaware control method, system and readable storage medium storing program for executing | |
EP1690189B1 (en) | On demand session provisioning of ip flows | |
CN101707618B (en) | Authentication control method, device, system and authentication server | |
CN105847277A (en) | Service account share management method and system used for third party application | |
CN103139100A (en) | Business handling method and business handling system | |
CN102017546B (en) | Discontinuous access management method using waiting ticket for resource allocation control, waiting ticket management method, and resource allocation control method | |
CN101635719B (en) | Method and system for dynamically adjusting internet user access priority | |
CN103428260A (en) | System and method for allocating server to terminal and efficiently delivering messages to the terminal | |
KR101653685B1 (en) | Computer-excutable method for managing api | |
RU2427035C2 (en) | Method and device for controlling number of devices installed in authorised domain | |
US20220394079A1 (en) | Implementing a Queuing System In a Distributed Network | |
CN109194759B (en) | Network access method and system for degrading at front end | |
CN117155606A (en) | Webpage login state maintaining method and system | |
CN102868723A (en) | Control console and management method of management zero terminal machine and desktop virtual machine |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C12 | Rejection of a patent application after its publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20110406 |