• My Books
  • Who Am I

AristaDBA's Oracle Blog....

An Oracle Blog Of A Learner....

OTN Appreciation Day: In-Memory Column Store #ThanksOTN

October 11, 2016 by Leave a Comment

There are many features in the database and all of them are super useful. But on this day, I chose to go with the latest and probably the greatest feature introduced in the oracle database 12.1.0.2-In Memory Column Store.

From a long time, there has been discussions about how a database should be using column based storage to increase the performance. Traditional method of using the database is row-based mechanism. But as good it may sound to use a column based mechanism, it is not that easy to implement it because the way DML statements work, it’s better for them to use  a row-based approach. And that’s where, the superb genius developers of Oracle Corp came up with the feature- In Memory Column Store(IMCS). The IMCS allows the oracle database to do the DML’s still using the traditional row-based approach but for data selection(and that too selectively for the chosen table or tables), the data of the table is loaded into a new memory structure that’s arranges the  data of the table in a columnar format. With this feature, when one has to access really large database tables and use them in reports, which with analytical indexes can take anywhere from minutes to hours, the same work can be completed in few seconds.

Here is a video demonstrating the power of In-memory.

https://www.youtube.com/watch?v=mF-h26iKTYY

If you want to know more about the IMCS, you may want to watch this presentation,

https://www.youtube.com/watch?v=mF-h26iKTYY

And of course, last but certainly not the least, read about it from the Oracle Documentation,

http://docs.oracle.com/database/121/ADMIN/memory.htm#GUID-BFA53515-7643-41E5-A296-654AB4A9F9E7

Don’t forget to check Maria Colgan’s excellent presentations on the same topic at Oracle University’s learning stream website – http://education.oracle.com/streams

Thanks to Tim for bringing this excellent idea of saying thanks to OTN! And thank you so much OTN!!

Posted in: genernal Tagged: inmemory, introduction, otn, thanksotn
Logging In...

Profile cancel

Sign in with Twitter Sign in with Facebook
or

Not published

 

Aggregated by OraNA

AristaDBA|Google+ Page

October 2016
M T W T F S S
« Sep   Mar »
 12
3456789
10111213141516
17181920212223
24252627282930
31  

Recent Posts

  • Test Post
  • I am speaking at Mumbai, OTNYatra 2007! Come and say Hi!
  • Using HISTORY in SQL*PLUS 12.2….
  • OTN Appreciation Day: In-Memory Column Store #ThanksOTN

Tags

1z0-050 11g 12c ace advice aioug blog blog issues buffers Certification cloud dirty download em event Fun general Grid Console happynewyear ilm imu internal internals introduction library cache nic OCP OEL otn otnyathra ou packt private redo Public YUM rac rant Review sangam sociable sqlplus training twitter virtualbox virtual index wordpress

Recent Comments

  • The Oracle DBA Apps Girl on Using HISTORY in SQL*PLUS 12.2….
  • orana on VirtualBox 5.0.16 Released….
  • orana on Hello Noida-Are You Attending Oracle Cloud Day….
  • amardeep_sidhu on Non-CDB Architecture Is Officially Deprecated….
  • oraclerp on Non-CDB Architecture Is Officially Deprecated….
  • mdinh235 on Non-CDB Architecture Is Officially Deprecated….
  • anandp86 on Non-CDB Architecture Is Officially Deprecated….
  • Anju Garg on Oracle 12c, ILM Management Part-1,In-Database Archiving….

Archives

  • July 2017 (1)
  • June 2017 (1)
  • March 2017 (1)
  • October 2016 (1)
  • September 2016 (2)
  • March 2016 (3)
  • December 2015 (2)
  • January 2015 (2)
  • October 2014 (1)
  • August 2014 (1)
  • July 2014 (3)
  • June 2014 (2)
  • May 2014 (1)
  • April 2014 (3)
  • March 2014 (2)
  • February 2014 (1)
  • January 2014 (1)
  • November 2013 (1)
  • October 2013 (1)
  • September 2013 (2)
  • July 2013 (2)
  • June 2013 (4)
  • February 2013 (4)
  • January 2013 (1)
  • December 2012 (2)
  • November 2012 (3)
  • October 2012 (1)
  • September 2012 (1)
  • July 2012 (1)
  • June 2012 (2)
  • April 2012 (1)
  • March 2012 (2)
  • February 2012 (1)
  • December 2011 (3)
  • October 2011 (1)
  • September 2011 (1)
  • August 2011 (1)
  • July 2011 (2)
  • June 2011 (1)
  • April 2011 (3)
  • February 2011 (1)
  • January 2011 (1)
  • December 2010 (2)
  • October 2010 (1)
  • September 2010 (2)
  • July 2010 (4)
  • June 2010 (2)
  • May 2010 (2)
  • April 2010 (2)
  • March 2010 (4)
  • February 2010 (4)
  • January 2010 (2)
  • December 2009 (2)
  • October 2009 (2)
  • August 2009 (5)
  • July 2009 (3)
  • June 2009 (1)
  • April 2009 (2)
  • March 2009 (5)
  • February 2009 (5)

Visitor Location….

Locations of visitors to this page

Tripit….

Where I Am….

Console

  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org

Copyright © 2018 AristaDBA's Oracle Blog.....

Omega WordPress Theme by ThemeHall