Oracle in Memory Configuration

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

Remedial Instruction in Language Disfluencies in the Non-Psycho-Expert Lens

"This qualitative case study discovered and explored the plights of languages teachers conducting remedial instruction in language disfluencies, the way teachers conduct remedial instruction in language disfluencies in t...

Accountability Performance of Public Elementary School Principals in the Division of Northern Samar, Philippines

This study focused on the accountability performance of public elementary school principals in the division of Northern Samar, Philippines based on the “Code of Conduct and Ethical Standards for Public Officials and Empl...

Path Planning Algorithms for Unmanned Aerial Vehicles

"In this paper, the shortest path for Unmanned Aerial Vehicles UAVs is calculated with two dimensional 2D path planning algorithms in the environment including obstacles and thus the robots could perform their tasks as s...

Development of Diagnostic System for Brain MRI Scanning Based on Robust Information Clustering

Brain problem has led to the death of many people in our society. The causes of brain problem are hard drugs, taking Indian hem, accidents and not having a good identifying machine that could scan and identify this probl...

Philosophy of Numerical Symbolism in World’s Cultures

Understanding symbolic consciousness as a specific way of knowing reality, the semantic center of which is a symbol, suggests the possibility of representing global meanings in a symbolic form. In the absence of sufficie...

Download PDF file
  • EP ID EP692404
  • DOI -
  • Views 134
  • Downloads 0

How To Cite

Vijay Kumar Tiwari (2020). Oracle in Memory Configuration. International Journal of Trend in Scientific Research and Development, 5(1), -. https://europub.co.uk/articles/-A-692404