Abstract: Techniques for implementing a multi-wire protocol and multi-dialect database engine are described. A database engine exposes multiple interfaces in the form of ports that support different database wire protocols. The database engine supports multiple query dialects that can be passed over any one of the supported wire protocols. The database engine can support multiple different query dialects within a single database session.

Abstract: In a method of Local Peer to Peer Direct Connection in NAT and overlay network. A request is received from a first peer at a relay gateway to establish a direct connection with a second peer. The first peer and the second peer are located behind a NAT firewall. An authentication request is relayed from the first peer at the relay gateway. The authentication request is forwarded from the relay gateway to the second peer. Upon performing authentication at the second peer, an authentication response is received at the relay gateway. The authentication response is received from the relay gateway at the first peer. An internal route propagation is performed from the second peer to the first peer via the relay gateway. A Local Peer to Peer Direct Connection is established between the first peer and the second peer for packet flow through the direct connection.

Abstract: In a method of Local Peer to Peer Direct Connection in NAT and overlay network. A request is received from a first peer at a relay gateway to establish a direct connection with a second peer. The first peer and the second peer are located behind a NAT firewall. An authentication request is relayed from the first peer at the relay gateway. The authentication request is forwarded from the relay gateway to the second peer. Upon performing authentication at the second peer, an authentication response is received at the relay gateway. The authentication response is received from the relay gateway at the first peer. An internal route propagation is performed from the second peer to the first peer via the relay gateway. A Local Peer to Peer Direct Connection is established between the first peer and the second peer for packet flow through the direct connection.

Abstract: A server identifies a group of patches. The server pushes data indicating the group of patches to each of a group of targets in such a way so that each target recognizes the patches as grouped together. At each target, the received patches are then applied to the target application as a group. As a result, target application downtime is minimized, and the target application need only be brought offline once for the entire group of patches. The patches may be applied to a target application as a single transaction. The server may determine dependencies that are required for a patch. For each target of the patch, the server identifies which of these dependencies should be installed or updated. For each target that lacks the required dependencies, the server further sends, along with the patch data, data and/or instructions that cause the target to install or update the requisite dependencies.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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.