News Column

Researchers Submit Patent Application, "Management of Database Allocation during Reorganization", for Approval

September 2, 2014



By a News Reporter-Staff News Editor at Information Technology Newsweekly -- From Washington, D.C., VerticalNews journalists report that a patent application by the inventors Konik, Rafal P. (Oronoco, MN); Mittelstadt, Roger A. (Byron, MN); Muras, Brian R. (Rochester, MN); Theuer, Mark W. (Rochester, MN), filed on February 11, 2013, was made available online on August 21, 2014.

The patent's assignee is International Business Machines Corporation.

News editors obtained the following quote from the background information supplied by the inventors: "Databases are used to store information for numerous types of applications. Examples include various industrial, commercial, technical, scientific, and educational applications. Database management systems (DBMSs) are a typical mechanism for accessing data stored in a database. DBMSs may use a model in which data is first stored and indexed in a memory before subsequent querying, accessing, or analysis. Databases may contain large amounts of data, which may create performance issues when a user queries the database for specific information. Organization and formatting of the data and the index may affect the system performance, reliability, power usage, durability, and user experience."

As a supplement to the background information on this patent application, VerticalNews correspondents also obtained the inventors' summary information for this patent application: "In one embodiment, a method is provided for reorganizing a database. The method may monitor the database to determine whether the database reorganization is required. The method may also include determining the database reorganization is required. The method may further include determining a first and second amount of space to add to the database for additional entries of a category of data according to a first and second predictive sizing calculation. The method may further include the selecting of either the first or second amount of space to add to the database for additional entries of the category of data during the reorganization. The method may further include performing the reorganization of the database including allocating the selected amount of space to add to the database for additional entries in the database of the category of data by using the computer system operatively coupled to the storage device.

"In another embodiment, a computer-readable storage media is provided for reorganizing a database. The computer-readable storage media may provide for monitoring the database to determine whether the database reorganization is required. The method may also include determining the database reorganization is required. The method may further include determining a first and second amount of space to add to the database for additional entries of a category of data according to a first and second predictive sizing calculation. The method may further include the selecting of either the first or second amount of space to add to the database for additional entries of the category of data during the reorganization. The method may further include performing the reorganization of the database including allocating the selected amount of space to add to the database for additional entries in the database of the category of data by using the computer system operatively coupled to the storage device.

BRIEF DESCRIPTION OF THE DRAWINGS

"Embodiments are illustrated by way of example, and not by way of limitation, in the figures of the accompanying drawings in which like reference numerals refer to similar elements or steps.

"FIG. 1 depicts a high-level block diagram of an example system for implementing an embodiment of the invention.

"FIG. 2 depicts a block diagram of an example database management system, according to an embodiment of the invention.

"FIG. 3A is a flowchart illustrating a method 300 that uses an adaptive allocation for creating allocated spaces for future data entries in a database during reorganization, according to an embodiment of the invention.

"FIG. 3B is a detailed illustration of a first predictive sizing calculation that may be found in block 320 of FIG. 3A, according to an embodiment of the invention.

"FIG. 3C is a detailed illustration of a second predictive sizing calculation that may be found in block 320 of FIG. 3A, according to an embodiment of the invention

"FIG. 4 is a block diagram of a first reorganization of the database, according to an embodiment of the invention."

For additional information on this patent application, see: Konik, Rafal P.; Mittelstadt, Roger A.; Muras, Brian R.; Theuer, Mark W. Management of Database Allocation during Reorganization. Filed February 11, 2013 and posted August 21, 2014. Patent URL: http://appft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.html&r=686&p=14&f=G&l=50&d=PG01&S1=20140814.PD.&OS=PD/20140814&RS=PD/20140814

Keywords for this news article include: Information Technology, Information and Data Management, International Business Machines Corporation.

Our reports deliver fact-based news of research and discoveries from around the world. Copyright 2014, NewsRx LLC


For more stories covering the world of technology, please see HispanicBusiness' Tech Channel



Source: Information Technology Newsweekly


Story Tools






HispanicBusiness.com Facebook Linkedin Twitter RSS Feed Email Alerts & Newsletters