Connectivity - Oracle Access

Empowering Oracle Database Applications with StorHouse - page 2

Figure 1 depicts an Oracle query that joins customer information in an Oracle database with transaction data (for example, purchase information, clickstream data, or telephone call detail records) managed by StorHouse.

Figure 1: Application View

How Oracle Accesses StorHouse

Oracle/StorHouse connectivity requires Oracle 8i, release 2 (or higher) and FileTek's ODBC driver software. When Oracle parses a query, it passes StorHouse components, including predicates, directly to a StorHouse database. If a query involves data that resides only in StorHouse tables, StorHouse processes the query and returns the result set back to Oracle. Join processing for StorHouse tables occurs on StorHouse. When a query requires a join between tables on StorHouse and tables in an Oracle database, Oracle breaks the query into sub-queries and pushes them and their associated predicates to StorHouse where they are processed. StorHouse returns the result set to Oracle, which completes the join with Oracle tables.

Summary

It is rarely practical to manage all enterprise-wide detail data in a single Oracle database. Yet companies and Government agencies frequently require these important details for critical decision-making, customer care initiatives, regulatory compliance, and vendor management. Together, Oracle and StorHouse enable these processes by managing business details efficiently on StorHouse and retaining easy access to them through an Oracle application.