초록 ▼

The performance of a heterogeneous, distributed database system is optimized by supporting both block fetch operations and positioned update operations. Specifically, a data block is fetched from a target database management system (DBMS), and a positioned update instruction issued by a client is pr

The performance of a heterogeneous, distributed database system is optimized by supporting both block fetch operations and positioned update operations. Specifically, a data block is fetched from a target database management system (DBMS), and a positioned update instruction issued by a client is processed. The positioned update instruction, when executed by the target DBMS, enables the target DBMS to modify a row contained in the data block and addressed by a cursor as the cursor is perceived by the client. Also, performance of the database system is optimized by identifying database statements that reference invariant host variables, and modifying such database statements by replacing in the database statements the host variables with literal values equivalent to the host variables.

대표청구항 ▼

A method of optimizing performance of a database system wherein data associated with a client is distributed among a plurality of heterogeneous database management systems (DBMSs), comprising the steps of: (1) transparently fetching a data block of records and record identification information that

A method of optimizing performance of a database system wherein data associated with a client is distributed among a plurality of heterogeneous database management systems (DBMSs), comprising the steps of: (1) transparently fetching a data block of records and record identification information that uniquely identifies each of said records of said data block from a target database management system (DBMS) in response to a record request of said client, thereby reducing accesses to said target DBMS and thus optimizing performance of said database system, wherein said target DBMS is one of said heterogeneous DBMSs and wherein a single copy of said data block is maintained in said database system by said target DBMS; and (2) processing, in real-time, a positioned update instruction issued by said client and said record identification information, wherein said position update instruction has an associated position cursor, said positioned update instruction when executed by said target DBMS enabling said target DBMS to modify a record contained in said data block and addressed by said associated position cursor.