Fast direct output during sort merge

Details Fast direct output during sort merge Fast direct output during sort merge

G - Physics

06

F

354/115

G06F 17/30 (2006.01) G06F 7/24 (2006.01) G06F 12/00 (2006.01)

Patent

CA 1290456

AT9-88-011 ABSTRACT OF THE DISCLOSURE In a relational database system, a method is utilized that increases the performance of the sort operation. An optimizer routine in the relational database manager analyzes 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 optimizer 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. The system and method of this invention 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.

589118

Affiliated with

Also associated with

Rating

Fast direct output during sort merge does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Fast direct output during sort merge, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Fast direct output during sort merge will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFCA-PAI-O-1287757