Simplify your path to better
    utilization and results.

    Arbutus - the best interface between
    your data and meaningful answers.

    Arbutus gives you powerful audit analytics that will
    uncover results.

    Commands Used to Perform Benchmark Tests

    Here are the commands used to perform benchmark tests comparing Arbutus version 5.5 desktop and server products with the competitor’s latest version 10 desktop product. Where the commands differ, we’ve shown them as:

    ARBUTUS COMMANDS IN BLACK

    COMPETITOR’S V10 COMMANDS INDENTED IN BLUE

    IN TESTS WHERE THE COMMANDS ARE IDENTICAL, THEY ARE ONLY SHOWN IN BLACK


    Commands in Arbutus vs. Competitor’s V10 Desktop

    IMPORT XML TO importxml RECORD_LENGTH 105 FIELDS Tp ASCII 1 1, Date DATETIME 2 10 PIC ‘mm/dd/yyyy’, Co PRINT 12 2 0, Br PRINT 14 2 0, Dp PRINT 16 2 0, GL PRINT 18 3 0, Batch PRINT 21 5 0, Amount PRINT 26 11 2, abs PRINT 37 10 2 END “smallxml.txt” “importxml.FIL” RECORDS 0>

    IMPORT XML TO importxml “F:\Project\importxml.fil” FROM “smallxml.txt” FIELD “Tp” C AT 1 DEC 0 WID 1 PIC “” AS “” RULE “/RECORDS/RECORD/Tp/text()” FIELD “Date” D AT 2 DEC 0 WID 10 PIC “YYYY-MM-DD” AS “” RULE “/RECORDS/RECORD/Date/text()” FIELD “Co” C AT 12 DEC 0 WID 2 PIC “” AS “” RULE “/RECORDS/RECORD/Co/text()” FIELD “Br” C AT 14 DEC 0 WID 2 PIC “” AS “” RULE “/RECORDS/RECORD/Br/text()” FIELD “Dp” C AT 16 DEC 0 WID 2 PIC “” AS “” RULE “/RECORDS/RECORD/Dp/text()” FIELD “GL” N AT 18 DEC 0 WID 3 PIC “” AS “” RULE “/RECORDS/RECORD/GL/text()” FIELD “Batch” C AT 21 DEC 0 WID 5 PIC “” AS “” RULE “/RECORDS/RECORD/Batch/text()” FIELD “Amount” N AT 26 DEC 2 WID 11 PIC “” AS “” RULE “/RECORDS/RECORD/Amount/text()” FIELD “abs” N AT 37 DEC 2 WID 10 PIC “” AS “” RULE “/RECORDS/RECORD/abs/text()”

    IMPORT DELIMITED TO importcsv RECORD_LENGTH 120 FIELDS Tp ASCII 1 1, Date ASCII 2 10, Co ASCII 12 2, Br ASCII 14 2, Dp ASCII 16 2, GL ASCII 18 3, Batch ASCII 21 5, Amount PRINT 26 11 2, abs PRINT 37 10 2 END “F:\Project\smallcsv.csv” 1 44 34

    IMPORT DELIMITED TO importcsv “importcsv.fil” FROM “smallcsv.csv” 0 SEPARATOR “,” QUALIFIER ‘”‘ CONSECUTIVE STARTLINE 1 KEEPTITLE FIELD “Tp” C AT 1 DEC 0 WID 2 PIC “” AS “” FIELD “Date” C AT 3 DEC 0 WID 10 PIC “” AS “” FIELD “Co” C AT 13 DEC 0 WID 2 PIC “” AS “” FIELD “Br” C AT 15 DEC 0 WID 2 PIC “” AS “” FIELD “Dp” C AT 17 DEC 0 WID 2 PIC “” AS “” FIELD “GL” C AT 19 DEC 0 WID 3 PIC “” AS “” FIELD “Batch” C AT 22 DEC 0 WID 5 PIC “” AS “” FIELD “Amount” N AT 27 DEC 2 WID 11 PIC “” AS “” FIELD “abs” N AT 38 DEC 2 WID 10 PIC “” AS “”

    IMPORT EXCEL TO excel_import FILE “data.xlsx” TABLE “`Import_Test` A” SERVER “LOCAL” SOURCE “Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)” FLAT “excel_import.fil” FIELDS A.”Type”,A.”Date1″,A.”Co”,A.”Br”,A.”Dp”,A.”GL”,A.”Batch”,A.”Amount”,A.”abs” END

    IMPORT EXCEL TO excel_import “F:\Project\ excel_import.fil” FROM “data.xlsx” TABLE “Import_Test” KEEPTITLE FIELD “Type” C WID 1 AS “” FIELD “Date1” D WID 19 PIC “YYYY-MM-DD” AS “” FIELD “Co” C WID 2 AS “” FIELD “Br” C WID 2 AS “” FIELD “Dp” C WID 2 AS “” FIELD “GL” N WID 3 DEC 0 AS “” FIELD “Batch” N WID 5 DEC 0 AS “” FIELD “Amount” N WID 11 DEC 2 AS “” FIELD “abs” N WID 10 DEC 2 AS “”

    EXPORT ALL XML TO “result”

    EXPORT ALL DELIMITED TO “result” SEPARATOR “,” QUALIFIER ‘”‘

    EXPORT ALL XLSX TO “result”

    DUPLICATES ON city state addr NEAR 1 TO “result”

    FUZZYDUP ON city+state+addr OTHER addr LEVDISTANCE 1 DIFFPCT 50 RESULTSIZE 50 TO “result”

    DUPLICATES ON addr NEAR 1 TO “result”

    FUZZYDUP ON addr OTHER addr LEVDISTANCE 1 DIFFPCT 50 RESULTSIZE 10 TO “result”

    JOIN PKEY batch SKEY batch FIELDS batch amount WITH amount TO “result” PRESORT SECSORT

    EXTRACT RECORD TO “result” IF datetime>=`20130603 080000` AND datetime <=`20130603 170000`

    EXTRACT RECORD TO “result” IF amount>1000000

    INDEX ON amount TO “result”

    SORT ON batch TO “result

    CLASSIFY ON Batch ACCUMULATE Amount

    STRATIFY ON amount ACCUMULATE amount INTERVAL 20 MIN -9000000 MAX 9000000

    SAMPLE ON Amount INTERVAL 1000000000 RECORD TO “result”

    TOTAL amount

    STATISTICS ON datetime NUMBER 5

    STATISTICS ON amount NUMBER 5

    SUMMARIZE ON Batch ACCUMULATE Amount OTHER GL PRESORT TO “result”