Invention Grant
US08645316B2 Storing records in databases in a randomized manner to effectively utilize database servers
失效
以随机方式存储数据库中的记录,以有效利用数据库服务器
- Patent Title: Storing records in databases in a randomized manner to effectively utilize database servers
- Patent Title (中): 以随机方式存储数据库中的记录,以有效利用数据库服务器
-
Application No.: US13210864Application Date: 2011-08-16
-
Publication No.: US08645316B2Publication Date: 2014-02-04
- Inventor: Howard F. Wilensky
- Applicant: Howard F. Wilensky
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Winstead, P.C.
- Agent Robert A. Voigt, Jr.
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A system and computer program product for effectively utilizing database servers. A middle tier system, interfacing between clients and a database system, receives requests to create, delete or update a record from a client. An index is used by the middle tier system to determine if a record previously exists, and if so, its current record location. In this manner, the middle tier system keeps track of the locations of the records stored in the databases. By keeping track of the data load, the middle tier system identifies the most available resource to store the records. When a record is to be created, deleted or updated, the middle tier system rebalances the load capability of the database servers by distributing the data across the databases in a randomized manner based on the server load. In this manner, changes to the server load are more effectively managed.
Public/Granted literature
- US20130046729A1 STORING RECORDS IN DATABASES IN A RANDOMIZED MANNER TO EFFECTIVELY UTILIZE DATABASE SERVERS Public/Granted day:2013-02-21
Information query