Connectivity - Oracle Access

Empowering Oracle Database Applications with StorHouse

Download a PDF version of this data sheet.

Oracle applications can transparently access terabytes-to-petabytes of enterprise-wide detail data managed by FileTek's StorHouse® data and access management system. StorHouse technology uniquely combines relational database management software with system management software that automatically administers a virtual hierarchy of diverse storage devices, including RAID, SATA RAID, Massive Arrays of Idle Disks (MAID), and erasable and WORM tape. StorHouse is the only storage management system capable of providing direct, row-level access to relational data on removable media such as tape. Oracle users can enjoy the benefits of StorHouse scalability, availability, accessibility, manageability, and cost-effectiveness while protecting their current investments in Oracle applications.

Why Use StorHouse?

Customer Relationship Management (CRM), eBusiness, Enterprise Resource Planning (ERP) and Data Warehousing initiatives put increasing demands on database technologies, including the requirement to manage and access massive amounts of information in a timely fashion. Analysts project that demand for information will rise over 100% per year for the next several years, with eBusinesses experiencing a 400% growth. In addition, complex queries and rapidly growing transaction volumes require new and more efficient querying methods. Together, Oracle and StorHouse offer an approach that leverages their respective strengths and eliminates the need to either aggregate detail data or offload it to tape archives that are practically inaccessible.

How Oracle and StorHouse Integrate

FileTek's database extension solution for Oracle enables users to access StorHouse tables directly from Oracle applications. StorHouse tables are simply defined as database links to Oracle using standard Oracle database administration and ODBC tools. Administrators can build views of StorHouse tables and use table synonyms. These views and synonyms shield users from needing to know where database tables actually reside. Oracle stored procedures, functions, and triggers are also supported.