Oracle Database
Need more information on this product?
Contact us on +33 (0)1 56 20 24 20 or via our online form
If you’re not currently a customer, you can apply for an account.
Relational database management system providing a full range of tools that encompass all areas of data processing and storage. Editions are built using a common code base, enabling database applications to scale without the need to change code.
Oracle Database is a relational database management system providing a full range of tools that encompass all areas of data processing and storage. This product provides the foundation for IT to successfully deliver more information with higher quality of service, reduce the risk of change within IT and make more efficient use of their IT budgets.
By deploying Oracle Database their data management foundation, organisations can utilise the database to: reduce server costs, reduce storage requirements, improve mission critical systems performance, increase DBA productivity, eliminate idle redundancy in the data centre, simplify their overall IT software portfolio, cluster and consolidate enterprise application databases onto fast, reliable and scalable private clouds, accelerate performance by compressing data onto low-cost storage partitions, cecurely protect information and enable compliance.
Oracle Database is available in the following editions:
- Express Edition
Is an entry-level, small-footprint database based on the Oracle Database 11g Release 2 code base. It is free to develop, deploy and distribute; fast to download; and simple to administer.
- Standard Edition
Is a full-featured database for servers with up to four sockets. It includes Oracle Real Application Clusters for higher availability, provides enterprise-class performance and security, is simple to manage and can easily scale as demand increases.
- Standard Edition One
Is a full-featured database for servers with up to two sockets. It provides enterprise-class performance and security, is simple to manage and can easily scale as demand increases.
- Enterprise Edition
Delivers scalability, security and reliability on a choice of clustered or single-servers running Windows, Linux and UNIX. It provides comprehensive features to easily manage the most demanding transaction processing, business intelligence and content management applications.
All editions are built using the same common code base, which means users database applications can easily scale from small, single-processor servers to clusters of multi-processor servers without changing a line of code.
Oracle Database – Features
Feature |
Editions |
|||
| High Availablity | Express Edition | Standard Edition One | Standard Edition | Enterprise Edition |
|---|---|---|---|---|
| Oracle Active Data Guard Provides secure, efficient, easy-to-use and application-transparent solution for long-term storage of historical data. |
Option | |||
| Data Guard | Yes | |||
| Transaction Guard | Yes | |||
| Cross-Platform Recovery | Yes | |||
| Cross-Platform Backup | Yes | |||
| Fail Safe Configure, verify Windows clusters and automatically fail over fast and accurately through high availability software integrated with Microsoft Cluster Server. |
Yes | Yes | Yes | |
| Flashback Query Recover older versions of data without complex, time-consuming operations. |
Yes | Yes | Yes | Yes |
| Flashback Table, Database and Transaction Query Diagnose and undo errors to reduce recovery time. |
Yes | |||
| Oracle Secure Backup Secure, high performance tape backup management for the Oracle Database and heterogenous file systems reducing the cost and complexity of networked data protection. |
Oracle Secure Backup is its own product that works with each database edition | |||
| Server Managed Backup and Recovery Simplify, automate, and improve backup and recovery performance with Oracle Recovery Manager (RMAN). |
Yes | Yes | Yes | |
| Scalability | Express Edition | Standard Edition One | Standard Edition | Enterprise Edition |
| Oracle Real Application Clusters Run any packaged or custom application unchanged across multiple connected, or “clustered,” servers. |
Yes | Option | ||
| Oracle Real Application Clusters One Node -Oracle RAC One Node is the one-node version of Oracle RAC which enables customers to standardise on a single deployment model for all their database needs. |
Option | |||
| Adaptive Execution Plans | Yes | |||
| Integrated Clusterware Built-in clustering services to protect any Oracle application or any other kind of application within a cluster. |
Yes | Yes | Yes | |
| Automatic Workload Management Route service connection requests to appropriate server with lowest load; on failure, automatically reallocate surviving servers to services. |
Yes | Yes | ||
| Java, PL/SQL Native Compilation Write stored procedures deployed in the database in both Java and PL/SQL. |
PL/SQL only | Yes | Yes | Yes |
| Oracle In-Memory Database Cache Increases responsiveness and throughput by caching frequently used data in memory. |
Option | |||
| Security | Express Edition | Standard Edition One | Standard Edition | Enterprise Edition |
| Data Masking | Requires Oracle Data Masking Pack | |||
| Real Application Security | Yes | |||
| Oracle Database Vault Restricts super-user and privileged-user access across applications and data. |
Option | |||
| Oracle Audit Vault and Database Firewall Automates the collection and analysis of audit data from multiple systems, turning audit data into a key security resource. |
Oracle Audit Vault is its own product that works with each database edition | |||
| Oracle Advanced Security Address privacy and compliance requirements. |
Option | |||
| Oracle Label Security Provides out-of-the-box row-level security. Compare user security clearances with data classification labels attached to data rows. Read More |
Option | |||
| Secure Application Roles Enable roles only after a user passes any number of security checks. |
Yes | |||
| Oracle Virtual Private Database Enforce data security and privacy with customisable, policy-based access control down to the row level. |
Yes | |||
| Fine-Grained Auditing Allows highly focused auditing with almost no ‘background noise’. |
Yes | |||
| Proxy Authentication Detects and authenticates users connecting through a middle-tier application. |
Yes | Yes | Yes | |
| Data Encryption Toolkit Protect vital data by providing an extra layer of protection for data on storage media. |
Yes | Yes | Yes | Yes |
| Application Development | Express Edition | Standard Edition One | Standard Edition | Enterprise Edition |
| Oracle Oracle Flashback Data Archive | Yes | Yes | Yes | |
| SQL Pattern Matching | Yes | Yes | Yes | |
| Temporal Database | Yes | Yes | Yes | |
| Oracle SQL Developer | Yes | Yes | Yes | Yes |
| Oracle Application Express Develop and deploy fast, secure applications with a rapid web application development |
Yes | Yes | Yes | Yes |
| Java Support Grid-enable databases through Web Services |
Yes | Yes | Yes | |
| Comprehensive XML Support Store and retrieve XML natively with support for the W3C XML data model; use standard access methods for navigating and querying XML. |
Yes | Yes | Yes | Yes |
| PL/SQL and Java Server Pages Utilise a server-side Java and stored procedural language; secure, portable and seamless with SQL. |
PL/SQL only | Yes | Yes | Yes |
| Comprehensive Microsoft .Net Support, OLE DB, ODBC Support multiple Windows data access methods. |
Yes | Yes | Yes | Yes |
| Manageability | Express Edition | Standard Edition One | Standard Edition | Enterprise Edition |
| Oracle Real Application Testing Reduces risk and costs of adopting new technologies, whether it’s operating systems, servers, or software. |
Option | |||
| Oracle Enterprise Manager Manage and monitor all applications and systems based on the Oracle stack via a single, integrated console. |
Yes | Yes | Yes | |
| Automatic Memory Management Automate management of shared memory used by an Oracle Database instance. |
Yes | Yes | Yes | Yes |
| Oracle Automatic Storage Management Consistent storage management interface across all server and storage platforms. |
Yes | Yes | Yes | |
| Automatic Undo Management Monitor configuration of all Oracle systems for parameter settings, security set-up, storage and file space conditions. |
Yes | Yes | Yes | Yes |
| Data Warehousing | Express Edition | Standard Edition One | Standard Edition | Enterprise Edition |
| Oracle Advanced Compression Compresses all types of data, including structured and unstructured data, to help you use resources more efficiently and lower storage costs. |
Option | |||
| Oracle OLAP Use built-in analytical workspaces for Online Analytical Processing (OLAP). |
Option | |||
| Oracle Partitioning Enables large tables and indexes to be split into smaller, more manageable components, without requiring changes to underlying applications. |
Option | |||
| Oracle Advanced Analytics | Option | |||
| Transportable Tablespaces, Including Cross-Platform Transport a set of tablespaces from one database to another, or from one database to itself. |
Yes | |||
| Star Query Optimisation Join a fact table and a number of dimension tables. |
PL/SQL only | Yes | Yes | Yes |
| Information Lifecycle Management Understand how data evolves, determine how it grows, monitor how its usage changes and decide how long it should be kept. |
Yes | |||
| Summary Management – Materialised View Query Rewrite Automatically recognising materialised view usage to satisfy requests. |
Yes | |||
| Integration | Express Edition | Standard Edition One | Standard Edition | Enterprise Edition |
| Basic Replication | Yes | Yes | Yes | |
| Distributed Queries/Transactions Query or update data on two or more distinct nodes of a distributed database. |
Yes | Yes | Yes | Yes |
Unstructured Data Management |
Express Edition | Standard Edition One | Standard Edition | Enterprise Edition |
| Oracle Spatial and Graph Support for sophisticated GIS deployments. |
Option | |||
| XML DB High-performance, native XML storage and retrieval technology. |
Yes | Yes | Yes | Yes |
| Multimedia Develop, deploy, and manage traditional, Web, and wireless applications that include rich media in the most-popular formats. |
Yes | Yes | Yes | |
| Text Build text query applications and document classification applications. |
Yes | Yes | Yes | Yes |
| Locator Manage geospatial data to leverage the business value of location. |
Yes | Yes | Yes | Yes |
| Oracle Secure Enterprise Search Internet-like search experience to users searching secure content inside the enterprise while protecting sensitive data from unauthorised users. |
Oracle Secure Enterprise Search is its own product that works with each database edition | |||
Oracle Database – System Requirements
| Key System Requirement | Express Edition | Standard Edition One | Standard Edition | Enterprise Edition |
|---|---|---|---|---|
| Maximum | 1CPU | 2 Sockets | 4 Sockets | No limit |
| RAM | 1 GB | OS Max | OS Max | OS Max |
| Database size | 11 GB | No limit | No limit | No limit |
| Windows | Yes | Yes | Yes | Yes |
| Linux | Yes | Yes | Yes | Yes |
| Unix | Yes | Yes | Yes | |
| 64 Bit Support | Yes | Yes | Yes |
