 |
|
|
SyncSort is the high-performance commercial sort and data manipulation utility for the UNIX, Windows, and Linux operating systems. SyncSort supports a wide variety of record types and data formats, provides record filtering, reformatting and summarization for file and data conversion, generates reports, and minimizes sorting time for large volumes of data.
SyncSort reduces sort execution times while improving overall system throughput. Proprietary sorting algorithms, I/O optimization, parallel processing, and dynamic environmental monitoring techniques result in significantly reduced CPU time, elapsed time, and disk I/O activity.
SyncSort performs a sort, merge, copy, or join application:
- A sort application reads records from the source, reorders them according to the specified sort keys, and writes them to the target.
- A merge application reads presorted records from one or more source files, merges them according to the specified merge keys, and writes them to a single target file.
- A copy application reads records from the source and writes them to the target without changing the order of the records.
- A join application reads records from two sources, joins each record from one source with zero or more records from the other source according to the specified join type and join key, and writes the new joined records to the target.
- Conditional filtering includes or omits records
on the basis of comparisons between field contents and constants
or on the basis of the file from which the records come.
- Bulk filtering includes or omits specified
numbers of records.
- Edits, inserts, and removes fields within records.
- Reformats differently based on selection criteria.
- Assigns values to fields based on selection criteria and converts data in fields from one format to another.
- Aggregates records with duplicate sort keys into a single record, counting records and totaling numeric fields.
SyncSort processes the following formats:
- Sequential files
- Indexed files
- Records passed from/to standard input/output
- Records passed from/to an invoking program
- Fixed length
- Delimited text
- Variable length
- Fortran unformatted
- Micro Focus variable
- Micro Focus line sequential
- Character
- Edited numeric
- Date/Time
- Packed decimal
- Signed integer
- Unsigned integer
- Floating point
- Bit
- Unsigned decimal
- Leading separate sign decimal
- Trailing separate sign decimal
- Leading embedded sign decimal (Micro Focus format and alternative format)
- Trailing embedded sign decimal (Micro Focus format and alternative format)
- Standard (ASCII, EBCDIC, folded ASCII, folded EBCDIC, Multinational)
- Locale defined
- User defined (one-for-one, one-for-two, two-for-one, and two-for-two replacements)
SyncSort can be invoked from the graphical interface, from the command prompt through the command syncsort, from Micro Focus COBOL programs through the SORT and MERGE verbs, from Software AG NATURAL SORT statements, from SAS applications through the sort procedure, from the IBM DB2 LOAD utility, and from program calls in any system-supported language through the sync_ subroutines or via an ActiveX control.
SyncSort can be easily integrated with most data warehouse staging tools to improve sort and aggregation performance.
SyncSort is distributed on CD or downloaded via the web, and installs in less than five minutes.
To request a free Proof-of-Concept, more information, or to order SyncSort, please contact us.
|
|
|
