-
公开(公告)号：DE69131543D1
公开(公告)日：1999-09-30
申请号：DE69131543
申请日：1991-03-20
Applicant: IBM
Inventor： ADAIR JOHN GARY , COYLE DANIEL JEROME , GRAFE ROBERT JOSEPH , LINDSAY BRUCE GILBERT , RAINSCH ROGER ALAN , RESCH ROBERT PETER , SELINGER PATRICIA GRIFFITHS
Abstract: The invention relates to a system including a first database management system for managing a database (40) including data having a first data format and a second database management system for managing a database (50) including data having a second data format. The invention is a method for converting data transmitted between the first and second database management systems, the method including the steps of sending from the first to the second database management system a command containing data in a data format native to the first database management system; and at the second database management system, converting the data in the command into a data format native to the second database management system.
-
公开(公告)号：DE69131543T2
公开(公告)日：2000-03-30
申请号：DE69131543
申请日：1991-03-20
Applicant: IBM
Inventor： ADAIR JOHN GARY , COYLE DANIEL JEROME , GRAFE ROBERT JOSEPH , LINDSAY BRUCE GILBERT , RAINSCH ROGER ALAN , RESCH ROBERT PETER , SELINGER PATRICIA GRIFFITHS
Abstract: The invention relates to a system including a first database management system for managing a database (40) including data having a first data format and a second database management system for managing a database (50) including data having a second data format. The invention is a method for converting data transmitted between the first and second database management systems, the method including the steps of sending from the first to the second database management system a command containing data in a data format native to the first database management system; and at the second database management system, converting the data in the command into a data format native to the second database management system.
-
公开(公告)号：DE68927743T2
公开(公告)日：1997-08-14
申请号：DE68927743
申请日：1989-03-16
Applicant: IBM
Inventor： CHANG PHILIP YEN-TAN , COYLE DANIEL JEROME , MALKEMUS TIMOTHY RAY , RODRIGUEZ REBECCA ANN , WELTI PHILIP JOHN
Abstract: In a relational database system, a method is used that increases the performance of the sort operation. An optimiser routine in the relational database manager analyses a user's complete query to determine whether the final sorted results can be used directly by the user as sorting occurs. If the sort results can be used, the sort results are sent to Relational Data Services in the relational database manager for output to the user. Depending upon the determination made by the optimiser routine, one of two output modes for the final sorted sequence string of data are selected by the relational database manager. In disk output mode, the last pass of the final sorted sequence string is written to disk. In fast direct output mode, the records of data are sent to the user as the final sorted sequence string is being merged during the last pass. Such an arrangement reduces the total sort time by eliminating the overhead of writing to disk during the fast direct output mode. Also, the response time, or availability for each record is reduced since each record is retrieved or sent to the Relational Data Services immediately after it has been sorted into the final sort order instead of completing the entire sort first, and then writing to disk.
-
公开(公告)号：DE68927743D1
公开(公告)日：1997-03-20
申请号：DE68927743
申请日：1989-03-16
Applicant: IBM
Inventor： CHANG PHILIP YEN-TAN , COYLE DANIEL JEROME , MALKEMUS TIMOTHY RAY , RODRIGUEZ REBECCA ANN , WELTI PHILIP JOHN
Abstract: In a relational database system, a method is used that increases the performance of the sort operation. An optimiser routine in the relational database manager analyses a user's complete query to determine whether the final sorted results can be used directly by the user as sorting occurs. If the sort results can be used, the sort results are sent to Relational Data Services in the relational database manager for output to the user. Depending upon the determination made by the optimiser routine, one of two output modes for the final sorted sequence string of data are selected by the relational database manager. In disk output mode, the last pass of the final sorted sequence string is written to disk. In fast direct output mode, the records of data are sent to the user as the final sorted sequence string is being merged during the last pass. Such an arrangement reduces the total sort time by eliminating the overhead of writing to disk during the fast direct output mode. Also, the response time, or availability for each record is reduced since each record is retrieved or sent to the Relational Data Services immediately after it has been sorted into the final sort order instead of completing the entire sort first, and then writing to disk.
-
-
-
Search Results
4
records
(took 0.018 seconds)
