Streaming database connector

Summary. A streaming database connector is an advanced database access technology that supports a high-performance, direct interface between remote-server data and the analytic functionality of Statistica products. This technology accesses large databases using a one-step process that does not require creating local copies of the data. Streaming DB connectors significantly increase the performance of Statistica and are particularly well suited for large data mining and exploratory data analysis tasks

The source of streaming database connector performance gains. These performance gains are a result of not having to import the data into a local copy, as well as Statistica's asynchronous and distributed-processing architecture. Specifically, a streaming database connector uses the processing resources (multiple CPUs) of the database servers to execute the query, extract the requested data records, and send them to the Statistica workstation. Finally, Statistica simultaneously processes these records as they arrive.

For more information, see also Streaming Database Connector Technology (Technical Overview) and Database Streaming FAQs.