Oracle Exalytics In-Memory Machine

The Oracle corporation announced in March, 2012 the beginning of sales of Oracle Exalytics In-Memory Machine — the high-performance optimized hardware and software system implementing the concept of the business analysis in RAM.

Appointment

The complete solution is designed to provide the high performance of the analytical systems and applications on performance management of the enterprise (EPM). At the same time Oracle announced receipt in sale of the new version of Oracle Business Intelligence Foundation Suite offering 87 expansions and improvements including new opportunities of visualization, contextual interactivity, performance improvement and scalabilities, optimization for Oracle Exalytics and simplification in use and management for end users, developers and administrators.

According to developers, the organizations can use Oracle Exalytics as for the customized analytical applications and the ready systems on performance management of the enterprise, and for own developments in this area. The optimized hardware and software system allows clients to complement functionality of dashboards and reporting systems with scenarios of modeling, planning and forecasting which are executed in a unified environment.

Description

Oracle Exalytics is designed as the optimized hardware and software system including the platform for the business analysis Oracle BI Foundation Suite and the relational DBMS with data processing in RAM of Oracle TimesTen In-Memory Database for Exalytics optimized for analytical tasks. Such architecture allows Oracle Exalytics to provide the high performance and scalability at the simplified deployment and low total cost of ownership, emphasized in Oracle.

The HSS is constructed based on the Oracle Sun Fire server with the Intel Xeon processor E7-4800 (40 main cores) and 1 TB RAM, with interfaces 40 Gb/s InfiniBand and 10 Gb/s Ethernet and the integrated module Integrated Lights Out Management. Oracle BI Foundation as the Oracle Exalytics component includes an extensive set of new opportunities Oracle Business Intelligence Enterprise Edition and Oracle Essbase for parallel processing and analytics in RAM. These opportunities allow to make visual real-time analysis with response time less than a second, developers claim.

Oracle TimesTen In-Memory Database for Exalytics is the new version of relational DBMS with data processing in the RAM which is specially intended for the solution of analytical tasks. New support of the aggregating OLAP requests, the built-in analytic functions and pokolonochny data compression allow Oracle TimesTen In-Memory Database for Exalytics to provide almost instant response to requests to big data sets, says Oracle.

Oracle Exalytics also offers the innovative technology "heuristic adaptive caching of data in RAM" (heuristic adaptive in-memory caching) which in the automatic mode on the basis of statistics of requests defines what data it is the best of all to store in RAM for increase in overall performance. Unlike other hardware-software solutions or tools working with RAM, Oracle Exalytics does not limit the application to access only to data which are placed in RAM, but also allows to use at the same time and any other databases, information storages and an OLAP sources.

As show internal tests and testing of Oracle Exalytics by clients, by preparation of relational OLAP- / ROLAP reports and use of dashboards performance increases by 10-100 times, and at multidimensional OLAP -/MOLAP-modeling — by 79 times. "High-speed performance, is unconditional — one of real advantages of Oracle Exalytics In-Memory Machine. The complex will issue us analytical reports about 35-70 times faster" — John Anker of Meller (John Anker Moeller), the senior vice president of Nykredit financial company reported.

Oracle delivers more than 80 preconfigured analytical applications and applications for performance management of the enterprise which can work at Oracle Exalytics without any additional settings or changes, including: all horizontal and industry Oracle BI Applications analytical applications, including among other Oracle Financial Analytics, Oracle Human Resources Analytics, Oracle Sales Analytics and Oracle Procurement and Spend Analytics; Hyperion Planning Oracle application for the integrated business planning, budgeting and forecasting.

The platform of a business intelligence Oracle BI Foundation Suite offers the built-in support for the mobile devices iPad and iPhone. Being a part of the complete solution Oracle Exalytics, the operational mobile analysis allows to support thousands of at the same time working users to whom expanded means of interactive visualization of analytical results are provided, noted in Oracle.

Besides, Oracle Exalytics is the open solution held for use in heterogeneous IT environments. Oracle Exalytics can provide access and analyze the data placed in any relational databases — both Oracle, and other suppliers and also the multidimensional OLAP servers or other data sources, including IBM DB2, IBM Netezza, Microsoft SQL Server and Analysis Services, SAP Business Information Warehouse (BW), Sybase Adaptive Server Enterprise (ASE) and Teradata Warehouse in any combination.

Oracle Exalytics is integrated with Oracle Exadata Database Machine using interface 40 Gb/s InfiniBand and a number of program expansions. It allows to provide high performance at request processing and interactive visualization with response time less than a second for work with huge data sets, concluded in corporations.

2012: New version of software of analytics

The Oracle corporation announced in October, 2012 release of the new version of the analytical software optimized for Oracle Exalytics In-Memory Machine — a high-performance hardware and software system for the data analysis in RAM providing the high performance of applications for the business analysis and performance management of the enterprises.

New opportunities of Oracle Exalytics are allowed customers to have quicker dostupk business information and more effectively to use it in the course of different analytical activity, from search and a research of data to the visual and mobile analysis, corporate planning and preparation of reports. It, in turn, allows to gain knowledge necessary for the accelerated acceptance of optimal solutions, says Oracle.

2013: Oracle Exalytics In-Memory Machine X3-4

On August 16, 2013 the Oracle corporation announced innovation - Oracle Exalytics In-Memory Machine X3-4.

A new system differs in the updated software and the upgraded hardware.

Structure of a HSS

The Exalytics X3-4 complex contains 2 TB RAM, 2.4 TB flash memory and 5.4 TB disk memories.

The new version of Oracle Exalytics X3-4 provides the profound analysis - for the analysis of large volumes of data support of bigger volume of the data aggregated at the different levels in RAM is implemented. Unlimited amount of data is available to users of Exalytics, located not only in RAM as the software of Oracle Business Intelligence automatically and is transparent manages requests taking into account information which is stored in RAM of Exalytics and all other data sources, such as corporate data warehouses or Hadoop. Using Oracle Business Intelligence Foundation Suite as basic software of Oracle Exalytics, the companies can analyze crucial data, take from them the valuable information necessary for business optimization.

Fast memory

The flash memory in a new product helps to accelerate calculations, restructuring, loading and export for applications of planning, the analysis "that-if" also modeling of scenarios using multidimensional DBMS Oracle Essbase. Increase in amount of memory provides performance improvement due to reduction to 25 times of load time and up to 9 times — time of calculations at simultaneous operation with numerous cubes [[Essbase. In turn, the increased memory for support allows to carry out works of numerous cubes more runtime forecasts due to faster calculations, providing business users with valuable knowledge for acceptance of more reasoned decisions promoting achievement of strategic objectives.

Support of mobile solutions

Oracle Exalytics X3-4 supports work with the mobile solution Oracle BI Mobile HD, not trebutn additional development, making changes in a program code. Performance and scalability of Oracle Exalytics is suitable for large mobile deployments.

The integrated additions

In the new version of Oracle Exalytics X3-4 also predyntegrirovana numerous improvements in software. Oracle Exalytics is developed as the complete solution from one supplier including a software platform of Oracle for the business analysis and the databases working in RAM which are configured for the hardware systems designed, constructed and supported by Oracle. Such optimized hardware and software system allows to reduce total cost of ownership and to simplify an IT enterprise architecture.

Structure of the Oracle Exalytics X3-4 platform:

• Oracle Business Intelligence Foundation Suite
• Oracle Endeca Information Discovery
• Oracle Essbase
• Oracle TimesTen In-Memory Database.

Solutions are integrated and certified for work on a hardware platform of Oracle Exalytics.

• Business Intelligence Foundation Suite 11.1.1.7 contains more than 200 improvements according to all platform and a set of functionality only for Oracle Exalytics. Among advantages to clients of Exalytics there are fast recommendations about "hot data" from the database and the ample opportunities of the package reporting using Oracle BI Publisher allowing to generate hundreds of thousands of personalized reports and documents.

• Oracle Essbase - the Oracle Business Intelligence Foundation Suite component, offers additional opportunities thanks to fast a flash memory and to the increased amount of RAM. Clients will be able to perform enterprise-wide planning, to reduce planning cycles and to deliver the corresponding business information to all functional divisions.

• Endeca Information Discovery 3.0 helps to investigate quickly information in new data sources, including unstructured content in social media, on websites and in content management systems, text data from documents, e-mail messages and many other things. Comparing these data with the structured information in data warehouses and corporate applications, users will be able to use more precisely information from unstructured sources that, as a result, will promote acceptance of more weighed business solutions.

• Hyperion Enterprise Performance Management (EPM) System Release 11.1.2.3 is the newest version of a complex of business applications of Oracle for planning, reportings and closings of financial periods. Thanks to optimization of the user opportunities, new features and integration this new version allows the companies to perform planning for profitable growth and to report with confidence in reliability and relevance of data.

• Oracle Hyperion Profitability and Cost Management is certified for work on Oracle Exalytics In-Memory Machine and predkonfigurirovano for preparation of the multidimensional reporting now. In this version direct integration of Oracle Business Intelligence Enterprise Edition at Oracle Exalytics with Hyperion Financial Management for providing is also implemented it is information capacious complex analytics on the consolidated financial results, told in Oracle.

Oracle Exalytics In-Memory Machine T5-8

On October 3, 2013 the Oracle corporation announced the optimized hardware and software system Oracle Exalytics In-Memory Machine T5-8.

Description

Oracle Exalytics In-Memory Machine T5-8 is the platform of the Oracle Engineered Systems family on the basis of the Oracle SPARC T5-8 server about 4 TB RAM provides the highest performance of applications for the business analysis (BI) and performance management of the enterprise (EPM).

The improved computing opportunities and storage system allows Oracle Exalytics T5-8 to execute large-scale consolidation of servers and business applications, supporting work of tens of thousands of users.

The Oracle Exalytics T5-8 complex is created especially for consolidation of a set of analytical business applications on one platform and ensuring the highest performance of the analysis in RAM. The HSS of Oracle Exalytics T5-8 includes the 8-processor SPARC T5-8 server running Oracle Solaris.

Oracle Exalytics T5-8 server

The server of a complex is equipped:

• 4 TB RAM with capacity 1 TB per second,
• flash memory with a capacity of 3.2 TB,
• disk subsystem with a capacity of 7.2 TB,
• 128 main cores and 1024 processor flows.

A system provides unprecedented levels of parallelism on one analytical server. The hardware and software system supports transactions of input-output with capacity of 256 GB per second, using high-speed network connections 10G, InfiniBand and interfaces for interactions with the storage devices Oracle ZFS Storage Appliance, including with ZS3 Series which is recently provided by the world record holder of performance, or network of storage Pillar Axiom SAN.

The new hardware and software system offers:

• Oracle Exalytics T5-8 provides unsurpassed efficiency of processor processing, supporting more than 8 thousand users Oracle BI counting on each SPARC T5 processor. Executing workloads according to the business analysis and financial planning, the Oracle ExalyticsT5-8 complex is capable to support freely 25 thousand users BI of-applications and 2 thousand users of applications for planning at the same time

• the Oracle Exalytics T5-8 platform offers previously tested virtualization configurations optimized for consolidation of workloads of Oracle Business Analytics. Besides, the built-in ZFS file system supports creation of instant pictures of ZFS for fast backup and data recovery. Oracle Enterprise Manager offers a full range of management tools the Oracle Exalytics complex.

• thanking a flash memory with a capacity of 3.2 TB of Oracle Exalytics T5-8 allows the organizations to receive more dynamic forecasts, accelerating calculations and to receive answers to urgent questions in real time

• Oracle Exalytics T5-8 includes the integrated platform for the business analysis of Oracle Business Intelligence Foundation Suite which offers the most extensive range of analytical opportunities, including means of formation of corporate statements, dashboards, ad-hoc data analysis, the multidimensional OLAP analysis, score cards and the predictive analysis. Users of Oracle Exalytics can get access to any data, without being limited only to those which are placed in RAM as the software of Oracle Business Intelligence automatically and is transparent manages requests to them both in RAM of Oracle Exalytics, and in any other sources, such as data warehouses and Hadoop.

• Oracle Exalytics T5-8 smoothly works with Oracle Business Intelligence Mobile, the leading solution of Oracle for the mobile analysis, without requiring additional development.

• The HSS gives an opportunity of reduction of total cost of ownership due to large-scale consolidation of applications and servers, helping to use more effectively resources for accomplishment of workloads. Oracle Exalytics is well integrated with other optimized hardware and software systems of Oracle, including Oracle Exadata, Oracle SuperCluster, Oracle Exalogic Elastic Cloud and Oracle Big Data Appliance.

The hardware and software system Oracle Exalytics T5-8 will be available along with the hardware Oracle Exalytics X3-4 configurations, a bit later.

2014: Oracle Exalytics In-Memory Machine X4-4

On October 13, 2014 the Oracle corporation provided the optimized hardware and software system for data analysis in RAM of Exalytics In-Memory Machine X4-4.

Oracle Exalytics In-Memory Machine X4-4

The HSS provides the highest performance of applications for the business analysis and performance management of the enterprise. The new version includes the upgraded hardware platform based on four Intel Xeon processors E7-8895 v2 made by Intel company especially for Oracle Engineered Systems. These processors are capable to redistribute dynamically resources - the frequency and quantity of cores - when using the software of Oracle for the maximum fall forward of accomplishment of analytical data processing which require the high speed of one-stream processing and high degrees of parallelism.

Oracle Exalytics In-Memory Machine X4-4 supports up to 3 TB RAM, has a flash memory with a capacity of 4.8 TB and a disk subsystem with a capacity of 7.2 TB that increases efficiency of this complex on all characteristics.

Exalytics In-Memory Machine X4-4 is the solution including the updated hardware, the platform for the business analysis and the software for the analysis in RAM, which predintegrirovana for decrease in total cost of ownership at performance improvement.

The Exalytics X4-4 complex is held for use opportunities of report generation, data analysis. It supports new versions of products for the business analysis and performance management of Oracle Endeca Information Discovery, Oracle Business Intelligence Foundation Suite, Oracle Business Intelligence Applications, Oracle Real-Time Decisions, Oracle TimesTen In-Memory Database and Oracle Hyperion Enterprise Performance Management, providing fast obtaining economic effect.