Shulou(Shulou.com)05/31 Report--

This article mainly explains "SAP Sybase IQ column storage is what", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "SAP Sybase IQ column storage is what" it!

Column storage makes it easier to compress because the same type of data is in one column, the compression ratio is higher, and the size of the data + index is much smaller than that of the original data.

In traditional databases, because of data pre-processing, materialized views, and row-based indexes, the data is basically inflated to 3-6 times the original data.

It's common.

IQ can add or load a column of data to a table as easily as adding a row in a traditional relational database. This flexibility is for those who work with real-time solutions.

Users who are interested in the case are attractive.

The column-based approach is easier to maintain and requires less tuning than traditional data warehouses. The attached planar modeling tool enhances this function.

IQ multithreading, MultiPlex cluster to achieve high availability. Independent read and write nodes.

IQ supports Rcubes (Relational Datacube) plane model, which has more advantages than traditional star model. Rcubes can significantly add

Speed of execution

IQ supports unlimited concurrent queries because SybaseIQ's column storage provides a fundamental performance improvement (often faster) compared to traditional methods

Hundreds of times), the performance advantage improves concurrency performance.

From an administrative point of view, column storage is almost indistinguishable from row storage, and database access is based on standard SQL (ANSI99) and supports OLAP Cubes.

Sybase IQ does not require data to be aggregated in advance for analysis, and users can analyze transaction-level data. Especially suitable for Data Mart

And impromptu inquiries. Using IQ's column storage and proprietary Bit-Wise indexes, aggregation can take place at any time. The pre-aggregation of transactions is ETL (extraction, transformation

Load) an important part of the function. For SYBASE IQ, a complete ETL layer may not be required. This approach is better than pre-aggregated data

There is more flexibility. That is, for most previous RDBMS databases (especially row storage databases) that need to be preprocessed

Actions can be implemented directly through views in SybaseIQ, thanks to its storage and query performance.

Thank you for your reading, the above is the content of "what is SAP Sybase IQ column storage". After the study of this article, I believe you have a deeper understanding of what SAP Sybase IQ column storage is, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.