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

This article introduces the relevant knowledge of "what are the functional features of SAP Sybase IQ". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

SAP Sybase IQ features:

Mass storage (PB level)

High compression ratio (5mm / 100x)

Extremely fast loading (Load:34T/h)

High performance query

Rich interface

Linear expansion (cluster)

Column calculation

Very simple operation and maintenance

SAP Sybase IQ application scenarios:

Self-help analysis

Distributed data Mart

Data warehouse

Report query (DSS)

Super Speed Load-"World record holder"

L load in parallel column, up to 34.3TB per hour

L supports multiple ways of ETL data integration

Created for ad hoc analysis: high-performance query engine + rich indexes

L-column storage, Nbit patented technology to improve compression ratio

L different data types provide up to 10 different best indexes

L column calculation, the performance is improved by 10 times and 100 times.

90% reduction in lI/O and more data caching

The operation and maintenance is simple, and the architecture is scalable.

L adapts to a large number of queries, and concurrency increases linearly with nodes.

L support the amount of data from TB to PB, big data analysis sharp tool

L simple operation and maintenance, less support and maintenance cost

L support MPP architecture deployment

Rich computing service consumption interface

L program interface JDBC, ODBC, RESTFUL, etc.

L self-help analysis of Tableau and Lumira

L report analysis: BO

This is the end of the content of "what are the functional features of SAP Sybase IQ"? thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.