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.
