Unisys Corporation

Suprio Pal

P J Landresse

Vikki Mei-Whey Lai

Linh Ly

The present invention is a method for facilitating the use of deferred column retrieval in order to improve row retrieval and query performance of OLE DB objects. The method enables OLE DB applications to access columns present in index structures without accessing the base table, enables optimization and faster running queries, as well as detecting various data access patterns, which could facilitate usage of the index for data retrieval.

Method for using deferred column retrieval to improve row retrieval and query performance of OLE DB applications

A method and system is provided that enables OLE DB (Object Linking and Embedded Database) applications to access embedded table-structured relationships in hierarchical databases as Normalized relational tables.

Method for exposing hierarchical table structures and relationships to OLE DB applications

Methods for facilitating updating of data in a database by a data-access system in communication with the database and a client application. The methods include initiating updating transactions by the data-access system based on requests from the client application for obtaining a portion of the database using a predetermined obtaining protocol; generating transaction identifiers with identifier values in the data-access system upon the initiating of each updating transaction; assigning a transaction identifier or a predetermined transaction identifier to each obtained portion; modifying at least one of the obtained portions of the database based on instructions received from the client application; and forwarding said modified portions to the database based on the transaction identifier assigned to each modified portion. In this way, the overall efficiency of the data-access system in processing of the client updating requests can be advantageously increased.

Methods and system for facilitating updating of data in a database by a data access system

In a computer-based information system where a client application accesses data in a network data modeled database via a data-access system utilizing bookmarks, methods are disclosed for allowing the data-access system to access logical-relationship data and metadata in a network data modeled database, and to present the accessed logical-relationship data and metadata to the client application in a format recognized by the client application. Other methods are disclosed for allowing a client application to access a table referenced by a network data modeled database via a data-access system utilizing bookmarks, and to modifying a logical relationship link to the accessed referenced table. In this way, a client application can directly access and modify logical relationship data stored in the network data modeled database via a data-access system utilizing bookmarks.

Methods and system for accessing logical relationship data in a database from a data-access system utilizing bookmarks

In a computer-based information system where verification of transmitted data is performed, a method is disclosed for verifying validity of transmission data based on a numerical identifier for the transmission data. The method includes generating a first number based on the transmission data and obtaining a numerical identifier for the transmission data. The method further includes generating a second number from the first number and the numerical identifier, and verifying the validity of the transmission data based on the second number. In this way, based on the numerical identifier included in the transmission data, it can be verified if a recipient of the transmission data is the intended recipient and/or if the transmission data is validly attempting to access a data structure.

System and method for verifying validity of transmission data based on a numerical identifier for the data

The method of the present invention is useful in a computer system including a server accessing a database and connected to a magnetic tape drive and operates to expedite the retrieval of audit files on tape while performing a database recovery. The program executes a method for locating a group of audit files of a database that is backed-up on magnetic tape media. The method includes the steps of creating a Tapeset for the group of audit files, initializing a disk directory file which holds positional information of the Tapeset, and locating each of the audit files within the group of audit files using the positional information contained in the disk directory file.

Growing community of inventors

Corona, CA, United States of America

Suprio Pal