{'fraction_non_alphanumeric': 0.017214397496087636, 'fraction_numerical': 0.00782472613458529, 'mean_word_length': 5.213592233009709, 'pattern_counts': {'":': 0, '<': 0, '<?xml version=': 0, '>': 0, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
Hardware Assisted Sorting in IBM's DB2 DBMS

For over 20 years, researchers have experimented with hardware innovations to make RDBMS processing more efficient. Efforts to build database machines with special hardware may be contrasted with the introduction of assists for accelerating database processing in general purpose processors. Four CPU intensive DBMS functions are identified in this paper, and all four have been successfully offloaded to assists on processors by IBM’s DB2 DBMS. One such assist, the sort assist, is examined in detail. Offset Value Codes as implemented by this assist and its exploitation in DB2 are described.