News Column

Patent Application Titled "Data Expanse Viewer for Database Systems" Published Online

June 17, 2014



By a News Reporter-Staff News Editor at Information Technology Newsweekly -- According to news reporting originating from Washington, D.C., by VerticalNews journalists, a patent application by the inventors Rieschl, Michael (Roseville, MN); Merten, James (Roseville, MN); Trautman, Matthew (Roseville, MN); Loberg, John (Roseville, MN), filed on November 29, 2012, was made available online on June 5, 2014.

The assignee for this patent application is Unisys Corporation.

Reporters obtained the following quote from the background information supplied by the inventors: "Database management systems traditionally provide for managing data in a particular database, and managing access to that data by many different user programs. These users programs are written in a high level language, such as C, C++, Java, or some other analogous language. The user program typically performs a call of the database management system when a database operation is to be performed.

"When a database management system receives the request, it typically handles that request as depicted in FIG. 1. As illustrated in that FIG., a system 100 includes a plurality of user applications 102a-n, from one or more of which a query statement can be is received by a database management system 104. If the database management system 104 is a relational database management system the query statement can be, for example, a SQL statement. The database management system 104 analyzes the query statement to determine if there are any errors in the statement itself. Assuming that there are no errors, the database management system 104 will transmit a call to an operating system 106 hosting that system (shown as CREAT$IOGATE), requesting access to the database file 108. The operating system 106 will then assign the database file to the database management system 104. The database management system 104 then caches at least portions of the database file using subsequent system calls (e.g., UDS$IOW). This requested data is modified by the database management system 104, and control is returned to the user program for continued execution.

"This arrangement has drawbacks. For example, this arrangement requires caching of data in the database management system 104, which requires the database management system to manage data control using locks and test & set operations on the underlying data file. Beyond this cache control requirement, the database management system 104 is required to address various portions of the database file 108 as required to access data managed by the database. This can become problematic when database files increase in size to the extent that the database file has a size greater than the addressable range of the database management system. In such situations, the database management system 104 traditionally would be limited such that each database file could only be of a limited size, or at the very least the user application 102 would be limited to addressing a particular range of addresses. As data sizes continue to increase, this limitation in the database management system will only become an increasingly problematic issue.

"For these and other reasons, improvements are desirable."

In addition to obtaining background information on this patent application, VerticalNews editors also obtained the inventors' summary information for this patent application: "In accordance with the following disclosure, the above and other issues are addressed by the following:

"In a first aspect, a method of obtaining access to a database file managed by an operating system in a computing system is disclosed. The method includes transmitting a call to an operating system from a database management system, the call requesting access to a database file. The method also includes receiving an address from the operating system at the database management system. The address represents a general address of the database file managed by the operating system. The method further includes transmitting a call to the operating system from the database management system, which includes an address and a size of a view of the database file to be created. The method also includes receiving an address of the view of the database file from the operating system.

"In a second aspect, a method of providing access to a database file by an operating system in a computing system is disclosed. The method includes receiving a call from a database management system, thereby requesting access to a database file. The method also includes transmitting an address to the database management system representing a general address of the database file managed by the operating system. The method further includes receiving a call from the database management system including an address and a size of a view of the database file to be created. The method includes generating a view of the database file based on the call, and transmitting an address of the view of the database file from the operating system.

"In a third aspect, a system includes a computing system including a processor and memory. The system also includes an operating system and a database management system. The operating system is maintained in the memory and configured to manage a file system maintained in the memory, the file system maintaining a database file having a file size. The database management system is hosted by the operating system, and supports an address range that is smaller than the file size. The operating system is configured to, in response to a call requesting access to the database file, transmit a general address of the database file to the database management system, and in response to a call requesting a view of the database file, transmit an address of the view of the database file.

BRIEF DESCRIPTION OF THE DRAWINGS

"FIG. 1 is a schematic view of a prior art arrangement of a computing system including a database management system;

"FIG. 2 is a schematic view illustrating a user application interface to a database management system, as can be used to implement aspects of the present disclosure;

"FIG. 3 is a schematic view of a computing system including a database management system and operating system cooperating to provide a data expanse viewer to the database management system, according to a possible embodiment of the present application;

"FIG. 4 is a logical diagram of address ranges of a database file using the data expanse viewer of FIG. 3;

"FIG. 5 is a flowchart of an example method of managing access to data for a database management system, according to an example embodiment;

"FIG. 6 is a state diagram illustrating operation of the computing system of FIG. 3, according to an example embodiment; and

"FIG. 7 is a schematic block diagram of an electronic computing device with which aspects of the present disclosure can be implemented."

For more information, see this patent application: Rieschl, Michael; Merten, James; Trautman, Matthew; Loberg, John. Data Expanse Viewer for Database Systems. Filed November 29, 2012 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=695&p=14&f=G&l=50&d=PG01&S1=20140529.PD.&OS=PD/20140529&RS=PD/20140529

Keywords for this news article include: Unisys Corporation, Information Technology, Information and Data Management.

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