链接：https://pan.baidu.com/s/1IHNOj7rvD2pDxo5ZteEJxw 

提取码：0zaw 

 

SAP Sybase IQ Components

SAP Sybase IQ includes an embedded SQL Anywhere DBMS engine. SQL Anywhere is Sybase’s 

lightweight relational database, often used on mobile devices. The SQL Anywhere layer of SAP Sybase 

IQ maintains the database catalog (metadata and stored procedures), and handles connectivity between 

client and server, query parsing and security. The SAP Sybase IQ layer incorporates patented storage 

technology and a high performance query engine.

Access to your SAP Sybase IQ database must be made through a SAP Sybase IQ server, which provides 

a communications channel for the database. A SAP Sybase IQ server starts and stops a database, 

accepts connections from applications or users running on the same machine or on other computers 

across a network. Users have connection rights to a database, not to the server. Generally, the SAP 

Sybase IQ server manages a single database.

You can combine multiple SAP Sybase IQ servers (some executing queries, and some executing data 

loads) running on multiple machines, accessing the same SAP Sybase IQ database on shared storage, in 

order to improve throughput and responsiveness to a larger number of concurrent clients. This Multiple 

Parallel Processing (MPP) based on a shared everything architecture is branded as the PlexQ™ 

Distributed Query Platform.

Figure 1 – Single SAP Sybase IQ deployment (left) can scale to PlexQ™ grid (right)

SAP Sybase IQ can scale from a single server to an MPP grid containing dozens of servers working 

together. SAP Sybase IQ with PlexQ™ technology scales out in a far more flexible manner than sharednothing approaches by separating compute resources from data storage. Queries can be processed in 

parallel on a PlexQ™grid without concern for how, or whether, data is partitioned. Furthermore, 

compute resources can be dynamically added to support more users or workloads without impacting data 

storage. Similarly, data capacity can be added without having to rebalance data stored on compute 

nodes, simplifying maintenance. Unlike shared-nothing MPP architectures, PlexQ™ dynamically 

manages query workloads across all the compute nodes in the cluster. The automatic workload 

rebalancer aggressively works to avoid contention among users for system memory and CPU resources, 

thereby providing predictable high performance and resource efficiency for a broad spectrum of 

workloads.

SAP Sybase IQ offers database drivers for web programming environments, such as PHP, Perl, Python 

and Ruby. SAP Sybase IQ is integrated with the Hadoop distributed processing environment in several 

ways: you can load data from the Hadoop File System (HDFS) into IQ for deeper analysis, perform data 

and query federation with Hadoop, and there is an API so that you can write MapReduce like functions 

that operate completely within IQ.