The Sybase IQ main characteristic includes:

    ·Uses the patent the bitwise index technology, realizes the high value bitmap index, can to relate according to does fast dynamic gathers the computation as well as according to the scope search;

    ·Uses uniquely according to the row memory way, effectively reduces floppy disk I/O, eliminates the table scanning, sharpens the inquiry response ability; the unusual data compression ability, may cause the data only to occupy the traditional database scale 30%;

    ·There is no indexing technology, did not guarantee in the table each row all has at least been indexed, user's speed of response wants other products to be quicker than 10 to 100 times. Simultaneously provides to the user 9 kind of different types indices, the user may act according to each row data type, the operation type carries on the choice; The high speed data index increase ability, after causes the data to go into storage can defer to the index retrieval immediately, enhanced the system overall efficiency; The data mass increase does not affect other inquiries, statistical and the analysis serviceability;

    ·The data mass increase performance the data quantity does not increase along with the table in drops;;

    ·Sybase IQ the Multiplex technology may satisfy the super data warehouse (VLDW) the data growth, may seamlessly expand from a small machine to the previous hundred small machines, and guarantees many machine overall performance basically presenting growth;

    ·Supports the ER model as well as the multi-dimensional models;

    ·Standard open connection support for widespread popular inquiry tools.