Oracle Database 11g for Data Warehousing
Oracle Database 11g offers flexibility of choice to streamline all your business decision making by consolidating quality information in a highly secure and reliable data warehouse that's completely integrated with your operation business processes.
Key Features:
Fast data warehouse design with Oracle Warehouse Builder
Oracle Warehouse Builder provides a complete environment for the design, population and management of data warehouses. Oracle Warehouse Builder includes design capabilities for database applications (including data warehouses) that utilize the unique features of Oracle Database 11g such as star schemas and OLAP cubes. It also provides a visual design tool to design the Extract Transfer and Load (ETL) process and ensure quality of data loaded into your data warehouse; generating the code needed to implement
Fast data warehouse deployment with wide choice of configurations
Oracle offers customers a choice of single and clustered server configurations on Windows, Linux and Unix platforms. In addition, The Oracle Optimized Warehouse Initiative offers pre-configured data warehousing solutions that combine Oracle Database, with the industry's leading computer manufacturers (including IBM, HP, Sun and Dell/EMC). This means customers have a complete choice in configurations from design/build in house, to manufacturers recommended systems to complete out-of-the-box solution.
Unmatched performance, scalability, and reliability with Oracle Partitioning and Oracle Real Application Clusters
Oracle participates in publicly audited benchmarks against IBM and Microsoft (NCR Teradata withdrew all results and doesn't participate any more). Oracle consistently re-raises the data warehousing performance standard in tpcH and SAP/BW benchmark categories at all sizes of data warehouse (from 100gb to 30tb). All the benchmark results are achieved with Oracle Partitioning, which, transparently to all applications, divides large tables into smaller, easier manageable chunks. With Oracle Real Application Clusters, you add high availability and low-cost scalability based on low-cost servers to your data warehouse.
Highest level of data security and access control with 19 independent database security evaluations
Data warehouses may contain Personally Identifiable Information (PII), where certain parts of the data set may not be displayed to the employee analyzing these data sets (or used by the application performing the analysis). Oracle has addressed this requirement with the Label Security product. But even more important than security features or products is the security build into the code of the Oracle database itself. 19 successful, independent security evaluations give you peace of mind that your customer's most private data doesn't get into the wrong hands.
Most efficient data warehouse management with single management interface and self tuning and self diagnosing features
An Oracle Data Warehouse shares all the automated and self-managing features of Oracle Database 11g including automated storage management, automated memory management and improved statistics collection. In addition data warehouses built using Oracle Database 11g can take full advantage of new features such as query caches and OLAP-organized materialized views, and new advisors such as data recovery and partition advisors. Oracle Enterprise Manager enables administrators to manage their entire Oracle infrastructure from disks to very large databases and applications from a single console.
Broadest range of business intelligence capabilities inside the data warehouse - ETL, OLAP, and Data Mining
Oracle offers an end-to-end business intelligence solution with Oracle Data Warehouse at its core. This simplifies the planning, installation and maintenance of your business intelligence solution: Components are pre-integrated, optimized to work with each other, and open to integrate with your third-party tools. Furthermore, it benefits from the performance, scalability, availability and security that Oracle Databases are renowned for.
If you are looking to develop a new Data Warehouse, consolidate your existing Data Marts and DW's into a single DW instance, drive improved performance and manageability with Oracle RAC, OLAP, Diagnostics & Tuning - then please contact UKOCN today at partners@ukocn.com. We will be pleased to discuss your Data Warehouse requirements and introduce you to a UKOCN Partner suited to meet your business needs.
About UKOCN
UKOCN is your primary resource for informative, up-to-date Oracle community news, updates, Partners innovations and more within the UK. Join today to get total access to the most relevant information to you - white papers, press releases, presentations, data sheets, special offers, training, events, jobs and more.
About Oracle
Oracle (NASDAQ: ORCL) is the world's largest business software company. For more information about Oracle, please visit http://www.oracle.com
