Database Technology Integration
By ACShorten on Sep 27, 2011
One of the features of the Oracle Utilities Application Framework is the ability to integrate external pieces of technology across the architecture to augment a solution at a client site. This blog entry summarizes some of the Oracle database features and products that can be used with the Oracle Utilities Application Framework.
- Real Application Clusters - Oracle Utilities Application Framework V2.1 and above can use Oracle RAC to provide additional levels of performance and availability. In Oracle Utilities Application Framework V4.x we added native support for the Fast Connection Failover (FCF) facility (via Oracle's Notification Server (ONS)) in Oracle 11g and above.
- Real Application Testing - If you are planning a database upgrade you can use Oracle's Real Application Testing facility to capture product SQL to replay on an upgraded database to assess the impact of the upgrade.
- Data Guard/Active Data Guard/Streams/Goldengate - Oracle offers a comprehensive set of technologies that can provide high availability and business continuity solutions for the database.
- Advanced Compression - With increased volumes and history to store, the ability to use storage efficiently may become a requirement. Using Advanced Compression on the Oracle Utilities Application Framework based product can reduce your disk and memory footprint for data.
- In Memory Database Cache - Whilst Oracle ships with an effective cache (SGA) it is possible to get more out of the cache using the In Memory Database Cache option.
- Partitioning - Splitting data into more manageable chunks (partitions) can mean easier management of the data and introduce information lifecycle management into your implementation.
- Database Vault - By default DBA and database SYSDBA users have access to all application data, if this is a concern then you can use Database Vault to restrict this and similar access whilst retaining appropriate security levels for the product users.
- Transparent Data Encryption - If protecting data at the disk (and subsequently backup) level is important then Transparent Data Encryption can be implemented to provide lower levels of protection.
- Audit Vault - Whilst the Oracle Utilities Application Framework contains an audit facility it is possible to centralize the audit information across an enterprise using Audit Vault.
The features summarized above are just a subset of what is possible with the Oracle Database and Oracle Utilities Application Framework based product. Use of any of the combination of the above can be used to satisfy a range of business requirements.