Database Reference
In-Depth Information
from text using advanced text analytics; score data mining models in real
time; process financial markets data; and much more. Because the Streams
toolkits can dramatically accelerate your time to analysis with Streams, we
cover the Database, Big Data, Advanced Text Analytics, and Data Mining
Toolkits in more detail here. There are many more toolkits available as part of
the product, such as the Timeseries, GeoSpatial, Financial Markets, Messag-
ing, CEP, Internet, IBM PureData System high speed adapters, DB2 parallel
adapter, and DataStage toolkits. There are also toolkits freely downloadable
from the
Streams Exchange
on developerWorks (
http://tinyurl.com/7sc6p8m)
such as the OpenCV toolkit for image processing and the HTTP connectivity
toolkit.
The Database Toolkit: Operators for Relational Databases
The Database Toolkit enables a stream to read from or write to an ODBC
database or read from a SolidDB database. Moreover, it provides high-
performance parallel operators to write to DB2 or IBM PureData System
databases. This toolkit enables a stream to query an external database to add
data or to verify data in the stream for further analysis. This Streams toolkit
includes the following operators, among others:
•
ODBCAppend
Inserts data from a stream into a table using SQL
INSERT
statements
•
ODBCSource
Reads data from a table and puts each row into the
stream as a tuple
•
DB2PartitionedAppend
Inserts data into a specific DB2 partition,
and can be used in parallel for high-performance loading
•
NetezzaLoad
Inserts data into an IBM PureData System for
Analytics (Netezza) using its high-speed loader
•
SolidDBEnrich
Reads data from a SolidDB table and adds that
information to tuples in the stream
The Big Data Toolkit:
Operators for Integration with BigInsights
The Big Data toolkit has operators for connecting to the Hadoop Distributed
File System (HDFS). This toolkit is essential for applications where Streams
and BigInsights work together. It enables high-speed parallel writing to the
HDFS for the fastest possible data exchange. This Streams toolkit includes
the operators shown in the following list, among others.
