Oracle in Memory Configuration
Journal Title: International Journal of Trend in Scientific Research and Development - Year 2020, Vol 5, Issue 1
Abstract
Oracle Database In Memory provides a unique dual format design that enables tables to be instantaneously represented in memory using traditional row format and a new in memory column format. The Oracle SQL Optimizer by design routes analytic queries to the column format and OLTP queries to the row format, transparently delivering best of both worlds performance. Oracle Database automatically maintains full transactional uniformity between the row and the column formats, just as it maintains uniformity between tables and indexes today. The new column format is a pure in memory format and is not persistent on disk, so there are no additional storage costs or storage synchronization issues. Vijay Kumar Tiwari "Oracle in Memory Configuration" Published in International Journal of Trend in Scientific Research and Development (ijtsrd), ISSN: 2456-6470, Volume-5 | Issue-1 , December 2020, URL: https://www.ijtsrd.com/papers/ijtsrd38275.pdf Paper URL : https://www.ijtsrd.com/computer-science/database/38275/oracle-in-memory-configuration/vijay-kumar-tiwari
Authors and Affiliations
Vijay Kumar Tiwari
Keywords
Related Articles
- EP ID EP692404
- DOI -
- Views 129
- Downloads 0
Factors Affecting Awareness of Mental Health among Adults of Selected Area of Dehradun, Uttarakhand
Background Mental health awareness delivers a wide range of knowledge and encompasses recognition and help seeking behaviour. Mental health services should be assess at ground level to monitor its delivery. Different mea...
Microspheres and Kinds
Background The concept of targeted drug delivery is meant for attempting to concentrate the drug within the tissues of interest while reducing the relative concentration of the medication within the remaining tissues.Now...
The Role of Science Education in Secondary Schools in Curbing Covid 19 Pandemic
Science Education equips individuals with skills, knowledge and ability to handle societal challenges such as Corona virus pandemic. The role of education to ensure effective community engagement for curbing COVID 19 imp...
Modelling and Simulation of Grid-Connected Solar-Hydro based Hybrid Power System
In this paper DC linked, grid connected solar/hydro hybrid system is modelled and simulated. A control scheme is developed for solar and hydro system for variable solar irradiance and variable load. Synchronous generator...
Green Plastics: Poly-lactic Acid Synthesis from Waste Tamarind Seed Powder & its Applications
In the era of sustainable development there is a necessity to produce biodegradable polymers to minimize the soil pollution. With the need of the hour Green plastic is the polymeric material formulated for specific appli...