|
How Fast Do You Want to Sort Today?
Challenges:
The native Unix sort command is functionally limited
and does not perform well (scale) as input volumes increase. Operating system sort verbs cannot:
• sort the largest files efficiently
• handle many data types
• filter, reformat or otherwise transform
• replace legacy sort functions or tools
• meet DW sort, aggregation or join needs
Nevertheless, you're familiar with Unix sort syntax, and may have an
investment in jobs or scripts uing /bin/sort commands. You could use a more
robust sort engine under the hood on Unix, or the same functionality on
Windows.
Solutions:
CoSort packages for
Unix, Linux and Windows include a faster, more robust drop-in replacement
for the Unix /bin/sort program. You can use the same Unix sort syntax (but
with the CoSort engine) on the command line, or in batch jobs, to reorder
huge files in parallel. The CoSort engine outperforms the Unix system sort
by several orders of magnitude and scales linearly in volume.
Once satisfied with the improved sort performance, most CoSort package users
move beyond this functionality and onto another CoSort interface - the Sort
Control Language (SortCL) tool.
CoSort's SortCL program allows you to combine sorting operations with simultaneous
data:
• Transformation (scrub, sort, join, group, etc.)
• Conversion (data types, record layouts, files)
• Protection (field-level encryption, de-ID, etc.)
• Reporting(custom detail, delta and summaries)
plus legacy sort and data migrations, Oracle unloading, ETL tool
collaboration, and some of the related solutions outlined throughout
this site like data validation and scrubbing, pattern matching, complex transforms, etc.
See also:
Solutions > Sort Migration
Solutions > Data Transformation > Sort/Merge
Products > CoSort
Products > CoSort > Sort Plugins
Products > CoSort > SortCL |
1-800-333-SORT
1-321-777-8889
|