IP Library Granted Patent US 9,201,943
Granted Patent B2
US 9,201,943 · App. 13/587,075 · Granted Dec 1, 2015

Systems for performing an external (disk-based) sort of a large data file which take advantage of “presorted” data already present in the input

View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 9,201,943
App. No.
13/587,075
Granted
Dec 1, 2015
Kind
B2
Abstract

Systems and programs for improving the efficiency of a sorting process in a computer system are disclosed. Data is provided in an input file external to the central processing unit of the computer system. In one embodiment, the implemented process involves investigating the contents of the input file in order to identify presorted portions thereof; incorporating the identified presorted portions of the input file into a second file external to the central processing unit, performing this step by rearranging directory information, without physically transferring the presorted portions from the input file. In sort processes involving both a string generation phase and a merge phase, the techniques described may be used in either or both phases, as well as in any output phase. Rearranging directory information rather than physically transferring data provides for greater efficiency in disk I/O.

Claims (16)

1. A system for ordering data, comprising:

(a) a central processing unit;

(b) memory accessible to the central processing unit;

(c) at least one external storage device whose contents are made accessible to processes running on the central processing unit through a directory structure of a file system;

(d) processing logic to investigate the contents of an input file stored in the at least one data storage device and to identify presorted portions thereof; and

(e) processing logic to incorporate the identified presorted portions of the input file into a second file in the at least one data storage device, by rearranging information in the directory structure so as to incorporate in the second file the presorted portions of the input file without physically relocating the presorted portions in the at least one data storage device.

2. The system of claim 1 , wherein the second file is regarded as a sortwork file in a sort merge process.

3. The new system of claim 1 , wherein the file system is NTSF.

4. The new system of claim 1 , wherein the directory structure comprises:

a plurality of pointers, the plurality of pointers corresponding to a plurality of blocks, the plurality of blocks constituting the second file.

5. The system of claim 4 , wherein rearranging information in the directory structure comprises:

updating the plurality of pointers.

6. A computer program product having a computer readable storage medium bearing thereon a non-transitory recording of instructions for performing, on a processor, a process for ordering data provided in an input file stored in at least one external data storage device made accessible through a directory structure of a file system to processes running on the processor, comprising:

(a) instructions for investigating the contents of the input file in order to identify presorted portions thereof; and

(b) instructions for incorporating the identified presorted portions of the input file into a second file in the at least one data storage device, by rearranging information in the directory structure so as to incorporate in the second file the presorted portions of the input file without physically relocating the presorted portions in the at least one data storage device.

7. The computer program product of claim 6 , wherein said second file is regarded as a sortwork file in a sort merge process.

Assignments (22)
FIRST LIEN GRANT OF SECURITY INTEREST IN PATENTS Recorded Jul 17, 2025
From: PRECISELY SOFTWARE INCORPORATED; VISIONS SOLUTIONS, INC.; PITNEY BOWES SOFTWARE INC.
To: JPMORGAN CHASE BANK, N.A., AS COLLATERAL AGENT
Reel/Frame 072019/0370 →
SECOND LIEN GRANT OF SECURITY INTEREST IN PATENTS Recorded Jul 17, 2025
From: PRECISELY SOFTWARE INCORPORATED; VISIONS SOLUTIONS, INC.; PITNEY BOWES SOFTWARE INC.
To: BARCLAYS BANK PLC, AS COLLATERAL AGENT
Reel/Frame 072019/0382 →
CHANGE OF NAME Recorded Mar 11, 2022
From: SYNCSORT INCORPORATED
To: PRECISELY SOFTWARE INCORPORATED
Reel/Frame 059362/0381 →
SECOND LIEN RELEASE OF SECURITY INTEREST IN PATENTS Recorded Apr 26, 2021
From: GOLUB CAPITAL MARKETS LLC, AS COLLATERAL AGENT
To: VISION SOLUTIONS, INC.; PRECISELY SOFTWARE INCORPORATED (F/K/A SYNCSORT INCORPORATED); PITNEY BOWES SOFTWARE INC.
Reel/Frame 056107/0233 →
FIRST LIEN RELEASE OF SECURITY INTEREST IN PATENTS Recorded Apr 26, 2021
From: JEFFERIES FINANCE LLC, AS COLLATERAL AGENT
To: VISION SOLUTIONS, INC.; PRECISELY SOFTWARE INCORPORATED (F/K/A SYNCSORT INCORPORATED); PITNEY BOWES SOFTWARE INC.
Reel/Frame 056038/0001 →
CORRECTIVE ASSIGNMENT TO CORRECT THE PROPERTY NUMBERS SECTION. PATENT NUMBERS 10003946 AND 10119825 WERE INCORRECTLY DESIGNATED AS APPLICATION NUMBERS. PREVIOUSLY RECORDED ON REEL 052323 FRAME 0254. ASSIGNOR(S) HEREBY CONFIRMS THE ASSIGNMENT OF SECURITY INTEREST IN PATENTS. Recorded Apr 14, 2021
From: BANK OF AMERICA, N.A., AS EXISTING AGENT
To: JEFFERIES FINANCE LLC, AS SUCCESSOR AGENT
Reel/Frame 056304/0891 →
CORRECTIVE ASSIGNMENT TO CORRECT THE PROPERTY NUMBERS SECTION. PATENT NUMBERS 10003946 AND 10119825 WERE INCORRECTLY DESIGNATED AS APPLICATION NUMBERS. PREVIOUSLY RECORDED ON REEL 052323 FRAME 0304. ASSIGNOR(S) HEREBY CONFIRMS THE ASSIGNMENT OF SECURITY INTEREST IN PATENTS. Recorded Apr 14, 2021
From: BANK OF AMERICA, N.A., AS EXISTING AGENT
To: GOLUB CAPITAL MARKETS LLC, AS SUCCESSOR AGENT
Reel/Frame 056305/0117 →
ASSIGNMENT OF SECURITY INTEREST IN PATENTS Recorded Apr 6, 2020
From: BANK OF AMERICA, N.A., AS EXISTING AGENT
To: JEFFERIES FINANCE LLC, AS SUCCESSOR AGENT
Reel/Frame 052323/0254 →
ASSIGNMENT OF SECURITY INTEREST IN PATENTS Recorded Apr 6, 2020
From: BANK OF AMERICA, N.A., AS EXISTING AGENT
To: GOLUB CAPITAL MARKETS LLC, AS SUCCESSOR AGENT
Reel/Frame 052323/0304 →
RELEASE OF SECURITY INTEREST Recorded Aug 18, 2017
From: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH, AS COLLATERAL AGENT
To: SYNCSORT INCORPORATED
Reel/Frame 043604/0779 →
SECURITY INTEREST Recorded Aug 18, 2017
From: SYNCSORT INCORPORATED
To: BANK OF AMERICA, N.A. AS COLLATERAL AGENT
Reel/Frame 043334/0678 →
SECURITY INTEREST Recorded Aug 18, 2017
From: SYNCSORT INCORPORATED
To: BANK OF AMERICA, N.A. AS COLLATERAL AGENT
Reel/Frame 043334/0659 →
RELEASE OF SECURITY INTEREST Recorded Aug 18, 2017
From: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH, AS COLLATERAL AGENT
To: SYNCSORT INCORPORATED
Reel/Frame 043333/0557 →
RELEASE OF SECURITY INTEREST IN PATENTS AT REEL/FRAME NO. 37055/0702 Recorded Dec 23, 2016
From: GOLUB CAPITAL MARKETS LLC, FORMERLY KNOWN AS GCI CAPITAL MARKETS LLC
To: SYNCSORT INCORPORATED
Reel/Frame 041187/0479 →
FIRST LIEN PATENT SECURITY AGREEMENT Recorded Dec 23, 2016
From: SYNCSORT INCORPORATED
To: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH, AS COLLATERAL AGENT
Reel/Frame 041187/0177 →
SECOND LIEN PATENT SECURITY AGREEMENT Recorded Dec 23, 2016
From: SYNCSORT INCORPORATED
To: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH, AS COLLATERAL AGENT
Reel/Frame 041187/0186 →
RELEASE OF SECURITY INTEREST IN PATENTS AT REEL/FRAME NO. 32401/0656 Recorded Dec 23, 2016
From: GOLUB CAPITAL MARKETS LLC, FORMERLY KNOWN AS GCI CAPITAL MARKETS LLC
To: SYNCSORT INCORPORATED
Reel/Frame 041187/0484 →
RELEASE OF SECURITY INTEREST IN PATENTS AT REEL/FRAME NO. 37146/0655 Recorded Dec 23, 2016
From: NB PRIVATE DEBT FUND LP
To: SYNCSORT INCORPORATED
Reel/Frame 041187/0491 →
SECOND LIEN PATENT SECURITY AGREEMENT Recorded Nov 19, 2015
From: SYNCSORT INCORPORATED
To: NB PRIVATE DEBT FUND LP, AS ADMINISTRATIVE AGENT
Reel/Frame 037146/0655 →
SECURITY INTEREST Recorded Nov 17, 2015
From: SYNCSORT INCORPORATED
To: GCI CAPITAL MARKETS LLC, AS ADMINISTRATIVE AGENT
Reel/Frame 037055/0702 →
SECURITY AGREEMENT Recorded Mar 7, 2014
From: SYNCSORT INCORPORATED
To: GCI CAPITAL MARKETS LLC, AS ADMINISTRATIVE AGENT
Reel/Frame 032401/0656 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Feb 24, 2014
From: LIU, PETER
To: SYNCSORT INCORPORATED
Reel/Frame 032280/0724 →