Can compressed QD data be browsed?
Yes, a user can browse the data in a compressed database. Browsing only decompresses the parts of the data that are actively being reviewed. Any tool that supports SQL can be used to browse the data. • What are the variables that determine the compression ratio (QD vs. native RDBMS) other than the elimination of white space? The amount of compression that QD is able to achieve is based on the data content of each column in the database. Specifically, the actual data type, the range of values, and the number of unique values will determine the compression technique QD will use, especially for numeric and date fields. For non-numeric fields, the structure and cardinality of the column will be the primary factors that determine the amount of compression. For example, a telephone number is usually stored as a character field. However, it has a specific structure (nnn-nnn-nnnn) and is a mix of character and numeric sub-fields. The separation characters and the values of each sub-field can b
