Oracle Database In-Memory (DBIM)

Let's first understand why DBIM is revolutionized...

Generally Organization keeps different database for Reporting and Application Transaction because of the performance issues so whenever any transactions happen to the Application Transaction database it will immediately replicate to report database which help to get up date data while fetching report from the reporting database.

Business don't want to access same database for reporting and transaction because of the performance impact on single DB as mixed workload can slow the database and  that's why they prefer to keep separate database for both activity which gives overhead of h/w & s/w management, required more resources to handle both environment and ultimately it will  increase TCO at the end of day.

To overcome from this situation Oracle comes with DBIM (Database In Memory) which keeps frequently accessed data in memory to get faster response and decrease the response time by eliminating disk IO. It will store Database in storage only but it will store most accessible data in memory which gives faster response compare to read from disk. We can also influence object which we want to keep in memory.

Oracle Database In-Memory transparently accelerates analytics by orders of magnitude while simultaneously speeding up mixed-workload OLTP. With Oracle Database In-Memory, users get immediate answers to business questions that previously took hours. Using Database In-Memory, businesses can instantaneously run analytics and reports that previously took hours or days. Businesses benefit from better decisions made in real-time, resulting in lower costs, improved productivity, and increased competitiveness

Oracle Database In-Memory delivers leading-edge in-memory performance without the need to restrict functionality, or accept compromises, complexity and risk. Deploying Oracle Database In-Memory with any existing Oracle Database compatible application is as easy as flipping a switch - no application changes are required. Oracle Database In-Memory is fully integrated with the Oracle Database’s renowned scale-up, scale-out, storage tiering, availability, and security technologies making it the most industrial-strength offering on the market. 

The ability to easily perform real-time data analysis together with real-time transaction processing on all existing applications enables organizations to transform into Real-Time Enterprises that quickly make data-driven decisions, respond instantly to customer demands, and continuously optimize all key processes. 

Key Features of DBIM
  • New In-Memory Column Format accelerates Analytics by orders of magnitude 
  • Dual-format architecture combines the best of column and row formats 
  • Many In-Memory optimizations, including In-Memory storage indexes, In-Memory compression, SIMD vector processing 
  • Scale-up on the world’s largest SMPs with 1000s of CPU threads 
  • Scale-Out on RAC clusters with in-memory fault tolerance, and the ability to isolate analytics from OLTP on different servers 
  • Maximum Availability Architecture 
  • 100% compatible with existing applications which support Oracle 12c  
  • High performance transactions in combination with column formats is a unique feature of Oracle Database In-Memory
Key Benefits of DBIM
  • Dramatically faster Data Warehouses, Analytics, Business Intelligence, Dashboards, Reports 
  • Fast ad-hoc analytics without the need to pre-create indexes 
  • Faster mixed workload OLTP 
  • Concurrent analytics and OLTP 
  • No database size limit 
  • Transparently blends memory, flash, and disk to achieve highest performance and lowest cost 
  • Industrial strength availability and security 
  • Robustness and maturity of Oracle Database 12c 
  • Easy implementation and management 
You can also refer Oracle website to get DBIM whitepapers which will help you to know more about DBIM

         Oracle DBIM Datasheet                           Oracle DBIM Whitepaper

                                                Why Exadata?

No comments:

Post a Comment