By Monica Kumar-Oracle on Aug 11, 2015
Oracle recently announced that Oracle Database 12c and Oracle Database In-Memory were now certified and supported by SAP for use with SAP Solutions. Our ongoing collaboration with SAP ensures the latest Oracle Database technology is always available to our joint customers.
The common need for instant analytics is pervasive, whether it’s a business running SAP applications with SAP BusinessObjects or an individual user searching for available tee times or hotel rooms. When we press the <ENTER> or <Search> key, we expect information instantly. With Oracle Database In-Memory, both IT and their end users can access analytics instantly. Below are two use cases illustrating how customers benefit from the speed and ease of adoption of Oracle Database In-Memory
Engineered for Ease of Adoption:
Oracle Database In-Memory is designed with ease of adoption in mind. No application changes or migration of data is required.
Swiss insurance leader, Die Mobiliar, chose the Oracle Database to be the strategic database after a series of mergers and acquisition. Important in the database decision were the impressive performance improvements that Oracle Database In-Memory offered to existing applications and the fact that no changes or fine-tuning were required to achieve these performance benefits. For example, one report that was running in 200 to 300 seconds now runs in just 1 second. The enabler for this is Oracle Database In-Memory’s unique dual-format architecture that allows for fast analytics together with high-performance OLTP. Data is processed at a rate of billions of rows per second rather than millions and allows analytics to run directly in OLTP databases to help provide reports in seconds rather than the traditional days or week’s manual efforts. Read more about Die Mobiliar use of Oracle Database In-Memory.
Designed for Speed & Cost Savings:
Shanghai Customs is a government agency for the General Administration of Customs in China. It oversees the surveillance and control of imports and exports through the Shanghai Free Trade Zone (SHFTZ). Shanghai Customs experienced rapid growth in SHFTZ’s customs activities due to the significant increase in re-export and off-shore trade and the expansion of customs duties and business rules. In response, they have used Oracle Database 12c, Oracle Database In-Memory, and Oracle TimesTen In-Memory Database to build a new customs-surveillance and control-information platform that ensures efficient logistics operations and supports future trade growth.
Oracle Database In-Memory’s dual-format architecture enables customers to automatically route OLTP transactions to the traditional row format and OLAP queries to Oracle’s new in-memory column format, expanding memory capacity and improving query performance. This approach helps to eliminate the need to copy analytical data out of the OLTP environment into a data warehouse thereby reducing system complexity and storage costs.
Oracle Times-Ten In-Memory Database further adds to speed and cost savings. By storing transactional and analytical data in Oracle Database 12c and managing this data with Oracle Database In-Memory and Oracle Times-Ten In-Memory Database in the application tier, customers can gain microsecond response times to accelerate data processing and achieve microseconds response times. Read more to see how Shanghai Customs Processes Clearance 43x Faster, Improves Declaration-Services Efficiency and Reduces Costs with Oracle In-Memory Database.
Stay tuned for more examples of customer use cases for Database In-Memory.