Oracle in Memory Configuration
Journal: International Journal of Trend in Scientific Research and Development (Vol.5, No. 1)Publication Date: 2021-01-21
Authors : Vijay Kumar Tiwari;
Page : 1465-1465
Keywords : -;
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
Other Latest Articles
- Descriptive Study to Assess the Knowledge and Attitude on HIV AIDS among Students
- Deprivation in Socio Economic Status of Scheduled Castes and Scheduled Tribes in West Bengal A Geographical Investigation
- Forecasting the Number of Unemployment in Bali Province using the Support Vector Machine Method
- Effects of Cognitive Training on Gait Parameter while Talking During Walking among Stroke Survivors
- Effect of Articulated Anterior Floor Reaction Orthosis on Gait Efficiency Stride and Characteristic in Diplegic Children with Crouch Gait
Last modified: 2021-01-22 18:48:19