The assignee for this patent, patent number 8645316, is
Reporters obtained the following quote from the background information supplied by the inventors: "A database is a collection of related information stored in a structured format. A database can consist of one or more tables of information that are related in some way. A table is a single store of related information. A table may consist of records, where each record is made up of a number of fields.
"A database management system (DBMS) maintains and manages the data stored in the databases. Management includes storing, deleting, retrieving and updating the data. Typically, data stored in a database includes plain values (e.g., numbers and alphanumeric strings) and complex objects, such as images, documents and spatial data. The DBMS typically is hosted by a server, which may be referred to as a 'database server,' that is accessible by a plurality of client systems (or simply referred to as 'clients') via a network.
"The database servers, which may hold the databases, may receive requests for data from the clients and retrieve the requested data from the databases and return the requested data to the clients. In order to handle a high level of requests from the clients, additional servers may be added, such as forming what is referred to as a 'server farm,' thereby bringing more computing power online. However, in order to store additional data, the databases are often partitioned or divided to accommodate the expanding load. Unfortunately, partitioning or dividing a database is time consuming and can also affect performance and accessibility. For example, partitioning a database may affect the uptime guarantees stated in the applicable service level agreements. In another example, the application (e.g., business application) residing on the client attempting to access data may also be impacted, such as the manner in the way it accesses records.
"Furthermore, in partitioning a database, the individual database tables may be distributed across several databases which increases the difficulty of managing the resources in the server farm. Additionally, each database vendor handles the partitioning of its database in differing ways. As a result, in a mixed vendor environment, the database administrator must understand each database server's unique characteristics in order to effectively scale each database.
"Hence, there is currently not an effective solution in managing server load capability in the context of a database environment to accommodate changes in the load (e.g., expanding load)."
In addition to obtaining background information on this patent, VerticalNews editors also obtained the inventor's summary information for this patent: "In one embodiment of the present invention, a computer program product embodied in a computer readable storage medium for effectively utilizing database servers comprises the programming instructions for receiving, by a middle tier system, a request to create, delete or update a record. The computer program product further comprises the programming instructions for searching, by the middle tier system, an index to determine if the record is stored in a database. Additionally, the computer program product comprises the programming instructions for creating the record in response to the record not being identified in the index. Furthermore, the computer program product comprises the programming instructions for deleting or updating the record in response to the record being identified in the index. In addition, the computer program product comprises the programming instructions for rebalancing, by the middle tier system, a load capacity of a plurality of servers holding a plurality of databases based on server load in response to creating, deleting or updating the record.
"Another form of the embodiment of the computer program product described above is in a system.
"The foregoing has outlined rather generally the features and technical advantages of one or more embodiments of the present invention in order that the detailed description of the present invention that follows may be better understood. Additional features and advantages of the present invention will be described hereinafter which may form the subject of the claims of the present invention."
For more information, see this patent: Wilensky, Howard F.. Storing Records in Databases in a Randomized Manner to Effectively Utilize Database Servers. U.S. Patent Number 8645316, filed
Keywords for this news article include:
Our reports deliver fact-based news of research and discoveries from around the world. Copyright 2014, NewsRx LLC
Most Popular Stories
- Visa, MasterCard Team Up to Focus on Payment Security
- 5 Notable Hispanic Technology Executives
- Top Hispanic Tech Companies Push for the Top
- Samsung Launches Milk Music
- Three Americans on Missing Malaysia Airlines Plane: State Department
- China Urges Malaysia Flight Emergency Response
- Russia, Crimea Discuss Referendum
- For Obama, a Last Stab at Improving Ties with Capitol Hill
- Taco Bell Rings Up Breakfast Menu
- California Establishes Center for Coffee Study