STATISTICA Query

STATISTICA Query is used to easily access data from a wide variety of databases (including many large system databases such as Oracle, Microsoft SQL Server, Sybase, etc.) using Microsoft's OLE DB conventions. OLE DB is a powerful database technology that provides universal data integration over an enterprise's network, from mainframe to desktop, regardless of the data type. OLE DB offers a more generalized and more efficient strategy for data access than the older ODBC conventions because it allows access to more types of data and is based on the Component Object Model (COM).

STATISTICA Query supports multiple database tables; specific records (rows of tables) can be selected by entering SQL statements, which STATISTICA Query automatically builds for you as you select the components of the query via a simple graphical interface and/or intuitive menu options and dialogs. Therefore, an extensive knowledge of SQL is not necessary in order for you to create advanced and powerful queries of data in a quick and straightforward manner. Multiple queries based on one or many different databases can also be created to return data to an individual spreadsheet, and you can maintain connections to multiple external databases simultaneously.

In-Place Processing of Data on Remote Servers

The query facilities, when offered as part of the enterprise versions of STATISTICA, are additionally enhanced by options to process data from remote servers, i.e., "in place" without having to import them and create a local datafile, or (see IDP). This technology is useful for processing extremely large datafiles where it can produce significant performance gains and enable you to process datafiles that exceed the storage capacity of the local device.