ORACLE DATABASE In-MEMORY

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 virtually any existing Oracle Database compatible application is as easy as flipping a switch--no application changes are required. It is fully integrated with Oracle Database's scale-up, scale-out, storage tiering, availability and security technologies making it the most industrial-strength offering in the industry. Oracle Database In-Memory accelerate database performance by orders of magnitude for analytics, data warehousing, and reporting while also speeding up online transaction processing (OLTP). Allow any existing Oracle Database-compatible application to automatically and transparently take advantage of columnar in-memory processing, without additional programming or application changes. With Oracle Database In-Memory is possible fast ad-hoc analytics without the need to pre-create indexes, completely transparent to existing applications, faster mixed workload OLTP, no database size limit, industrial strength availability and security and robustness and maturity of Oracle Database 12c. Oracle Database In-Memory’s ability to easily perform real-time data analysis together with real-time transaction processing enables organizations to become Real-Time Enterprises: Enterprises that quickly make data-driven decisions, respond instantly to customer demands, and continuously optimize all key business processes to maximize profitability. The most important content of the book is as follows: ORACLE DATA BASE IN-MEMORY. ESSENTIAL CARACTERISTICS ORACLE DATABASE 12C IN-MEMORY ARCHITECTURE HANA AND ORACLE DATABASE 12C ORACLE DATABASE IN-MEMORY OPTION ROW FORMAT VS. COLUMN FORMAT THE IN-MEMORY COLUMN STORE POPULATING THE IN-MEMORY COLUMN STORE RESTRICTIONS IN-MEMORY COMPRESSION IN-MEMORY SCANS IN-MEMORY JOINS IN-MEMORY AGGREGATION DML AND THE IN-MEMORY COLUMN STORE PARTITION EXCHANGE LOADS TRANSACTION PROCESSING THE IN-MEMORY COLUMN STORE ON RAC IN-MEMORY FAULT TOLERANCE THE IN-MEMORY COLUMN STORE IN A MULTITENANT ENVIRONMENT CONTROLLING THE USE OF ORACLE DATABASE IN-MEMORY OPTIMIZER HINTS IN-MEMORY SCAN IN-MEMORY JOINS IN-MEMORY AGGREGATION MONITORING AND MANAGING ORACLE DATABASE IN-MEMORY IN-MEMORY COLUMN STORE. EXAMPLES MANAGING TABLES MANAGING COLUMNS MANAGING MATERIALIZED VIEWS MANAGING TABLESPACES VIEWS WORKING WITH ORACLE DATABASE IN-MEMORY SOFTWARE ORACLE DATABASE IN-MEMORY. EXAMPLES ORACLE DATABASE SOFTWARE INTRODUCTION AND INSTALLATION