News Column

Researchers Submit Patent Application, "Database Row Access Control", for Approval

June 17, 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 25, 2013, was made available online on June 5, 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 are typically configured to separate the process of storing data from accessing, manipulating, or using data stored in a database. More specifically, DBMSs use a model in which data is first stored and indexed in a memory before subsequent querying and analysis. Databases may contain large amounts of data, which may create performance issues when a user queries the database for specific information. In most cases, there may be groups of users accessing the database that can only access limited pieces of data. Controlling user access, however, may create performance issues when a user queries the database."

As a supplement to the background information on this patent application, VerticalNews correspondents also obtained the inventors' summary information for this patent application: "Embodiments of the disclosure provide a method, system, and computer program product for processing a database query. The method, system, and computer program process a query using an access control bit mapping (ACBM) structure.

"One embodiment is directed to a computer-implemented method to create an ACBM structure for a database table. The ACBM structure may include a relative record number (RRN) bit map. The RRN bit map may describe the access rights for a parameter. The computer-implemented method may determine one or more statistics describing the RRN bit map. The method may additionally provide for updating the ACBM structure. The ACBM structure may be used to process a database query.

"Another embodiment is directed to a system including an ACBM structure corresponding to a database table. The system may include a database management system. The system may be configured to create an ACBM structure for a database table in a memory. The ACBM structure may include a relative record number (RRN) bit map describing access rights for a parameter. The system may be configured to determine one or more statistics describing the RRN bit map. The system may provide for updating the ACBM structure. The system may also provide for using the ACBM structure when processing a database query.

"Yet another embodiment is directed to a computer program product.

BRIEF DESCRIPTION OF THE DRAWINGS

"FIG. 1 illustrates a computer system configured to execute a database application, according to some embodiments.

"FIG. 2 illustrates a database management system (DBMS) that may be configured to include an access control bit mapping structure (ACBM), according to some embodiments.

"FIG. 3 illustrates a method to create an ACBM structure, according to some embodiments.

"FIG. 4 illustrates a sample access control listing (ACL) with example data, according to some embodiments.

"FIG. 5 illustrates a sample database table with example data, according to some embodiments.

"FIG. 6 illustrates a sample ACBM structure with example data, according to some embodiments.

"FIG. 7 illustrates a method to modify an ACBM structure upon modification to a corresponding database table, according to some embodiments.

"FIG. 8 illustrates a method to modify an ACBM structure upon modification to an ACL, according to some embodiments.

"FIG. 9 illustrates a method to process a database query, according to some embodiments.

"Like reference numbers and designations in the various drawings indicate like elements."

For additional information on this patent application, see: Konik, Rafal P.; Mittelstadt, Roger A.; Muras, Brian R.; Theuer, Mark W. Database Row Access Control. Filed February 25, 2013 and posted June 5, 2014. Patent URL: http://appft.uspto.gov/netacgi/nph-Parser?Sect1=PTO2&Sect2=HITOFF&u=%2Fnetahtml%2FPTO%2Fsearch-adv.html&r=767&p=16&f=G&l=50&d=PG01&S1=20140529.PD.&OS=PD/20140529&RS=PD/20140529

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