more on HP-Oracle Exadata Storage

It appears that there is more than hype with the HP-Oracle Exadata Storage solution. I like the architecture and way that it splits out queries between boxes. A good source of more information can be found at Kevin Closson’s blog. Kevin is an Oracle Employee and is a performance architect. He goes into some good detail about the operations.

What impressed me the most about this device is that is currently is focused on data warehouse solutions. It looks for select statements and farms these requests to the storage node. Since the storage node understands the table structure and query formatting, it only returns the relevant data. Instead of returning a 1G table and doing the where select on the database machine, the select…where is done on the storage node and the relevant columns and rows are returned. This means that things like returning a current billing statement for a specific cell phone will return the current bill and not all of the historical data. Partitioning does this but it does not reduce the number of columns returned. If you have a lot of data associated with a user in different columns, you can reduce the amount transferred from the storage by returning only the relevant information from the tables and not the entire row.

Interesting stuff. If we only had a few telco companies where I work…..

The huge benefit that I see from this device is that the statements that are shipped across to the storage node is warehouse centric. I can foresee this working with spatial data and being applied to seismic reservoir systems. I can see this working with materialized views for manufacturing. The only thing that needs to change is the engine on the database that farms out the request to the storage component. This has huge long term potential where large data sets are used. Many of the complex models that are currently designed to reduce this complexity can be expanded and simplified. The storage node can be customized to understand this format and pre-process the requests. If we follow this to the extreme, you might be able to embed some of the stored procedures for things like velocity correction of seismic data and have the storage node process this data and present the corrected trace instead of the raw trace. You can also do thing like image recognition or enhancement in the storage component and not at the higher levels. More complex stuff that currently requires parallel processing can be forced down into the storage and not to parallel processes. Agreed, the product is not here yet but I can see it going in that direction. Since Oracle typically provides open APIs to most of its products, I can see new ventures springing up based on this technology and specific solutions being created for specific industries.

Post Views: 1,255

307 thoughts on “more on HP-Oracle Exadata Storage”

  65. I definitely wanted to compose a remark so as to say thanks to you for the fantastic guides you are placing on this website. My considerable internet investigation has at the end been compensated with incredibly good knowledge to write about with my neighbours. I ‘d express that we readers are unquestionably lucky to live in a great website with very many outstanding professionals with great concepts. I feel very much fortunate to have used your entire weblog and look forward to tons of more enjoyable minutes reading here. Thanks a lot once again for everything.

    Reply

  66. Thank you a lot for providing individuals with such a splendid opportunity to read articles and blog posts from this site. It’s always so excellent and also jam-packed with amusement for me and my office friends to visit your web site nearly thrice every week to read the new stuff you have got. And definitely, we are usually fulfilled considering the good tricks served by you. Selected 4 areas in this article are easily the most efficient I have ever had.

    Reply

  74. I wish to get across my admiration for your generosity for visitors who need help with this important content. Your very own dedication to passing the solution all around had become extraordinarily valuable and has truly enabled individuals just like me to reach their targets. Your amazing important advice can mean a whole lot to me and still more to my peers. Best wishes; from everyone of us.

    Reply

  75. I have to voice my admiration for your kind-heartedness supporting men who really want assistance with this one field. Your very own dedication to getting the solution all over came to be exceedingly productive and has constantly enabled girls much like me to reach their targets. Your new important suggestions means this much to me and far more to my office colleagues. Thank you; from all of us.

    Reply

  87. I want to get across my love for your kind-heartedness in support of men who actually need help with this important question. Your real dedication to passing the message all through had been certainly important and has enabled somebody like me to achieve their goals. Your invaluable useful information denotes a whole lot to me and extremely more to my fellow workers. Thank you; from everyone of us.

    Reply

  88. I am only writing to make you be aware of of the nice discovery my wife’s daughter went through viewing yuor web blog. She even learned several details, including how it is like to possess an awesome giving spirit to let the rest smoothly completely grasp specified complex things. You really exceeded our own desires. Many thanks for showing such invaluable, trustworthy, explanatory and unique tips on this topic to Gloria.

    Reply

  89. Thank you a lot for giving everyone remarkably pleasant opportunity to discover important secrets from this blog. It is often very amazing and stuffed with a lot of fun for me and my office mates to visit your blog on the least thrice in one week to read the latest stuff you have got. And definitely, I’m so always impressed with your dazzling principles you serve. Certain 4 ideas on this page are in reality the simplest I have ever had.

    Reply

  95. Thanks for all your efforts on this web site. My daughter really loves participating in investigation and it’s really obvious why. We notice all about the dynamic method you convey priceless guidelines via the blog and as well strongly encourage response from people on this subject matter so our favorite daughter is learning a whole lot. Have fun with the remaining portion of the new year. You are always carrying out a brilliant job.

    Reply

  96. My husband and i were fulfilled that Chris managed to finish up his preliminary research via the ideas he was given while using the web page. It’s not at all simplistic to simply continually be handing out strategies which many people could have been trying to sell. And we also see we need the writer to thank for this. All the explanations you’ve made, the straightforward website menu, the friendships you help to promote – it’s everything awesome, and it is leading our son in addition to our family recognize that the content is fun, which is certainly particularly vital. Thanks for the whole thing!

    Reply

  97. I have to get across my appreciation for your kind-heartedness giving support to those people who absolutely need help with the theme. Your personal commitment to getting the message up and down appears to be certainly beneficial and have regularly enabled women just like me to realize their targets. The warm and friendly advice implies this much a person like me and further more to my mates. Best wishes; from everyone of us.

    Reply

  98. I have to show my appreciation to you for rescuing me from this particular crisis. Just after researching throughout the internet and finding notions which were not productive, I believed my life was well over. Existing without the presence of approaches to the problems you have resolved as a result of this guideline is a serious case, as well as the ones that could have badly damaged my entire career if I had not encountered your blog post. Your good ability and kindness in handling all the pieces was valuable. I am not sure what I would have done if I hadn’t encountered such a point like this. It’s possible to at this point relish my future. Thanks so much for this specialized and effective guide. I won’t hesitate to propose your web site to anybody who would like guide on this issue.

    Reply

  107. Thanks for all of your efforts on this site. Ellie delights in making time for internet research and it’s really simple to grasp why. Many of us learn all concerning the lively medium you render advantageous tricks by means of your web blog and as well as foster participation from some other people on this subject matter while our own child is truly starting to learn a lot. Take advantage of the remaining portion of the new year. You have been carrying out a stunning job.

    Reply

  113. I happen to be writing to let you understand of the perfect experience my friend’s child experienced studying your web page. She discovered a wide variety of details, with the inclusion of how it is like to have an amazing teaching nature to make most people just completely grasp certain grueling issues. You truly surpassed our desires. I appreciate you for offering those great, trustworthy, explanatory not to mention unique guidance on the topic to Lizeth.

    Reply

  114. I intended to write you this very small note just to thank you so much again just for the precious suggestions you’ve discussed on this website. It is wonderfully generous of you to make freely all that most of us could have offered for an ebook to earn some dough for their own end, most notably considering that you might have done it in the event you desired. These points also acted to become easy way to recognize that some people have the same interest like my own to see much more with respect to this matter. I am sure there are some more fun times in the future for people who browse through your website.

    Reply

  121. I am glad for commenting to make you understand what a notable discovery my wife’s daughter gained checking your site. She came to find lots of pieces, most notably what it’s like to have an incredible helping style to get the rest without problems know specified grueling issues. You really exceeded our own desires. I appreciate you for imparting those insightful, safe, informative not to mention easy thoughts on your topic to Emily.

    Reply

  122. Thank you for all your valuable labor on this blog. Kim takes pleasure in engaging in internet research and it is obvious why. A lot of people notice all about the lively mode you render helpful suggestions via the website and even invigorate participation from other people about this subject matter then our favorite child is being taught a lot of things. Have fun with the remaining portion of the year. You are carrying out a superb job.

    Reply

  123. I have to express some appreciation to this writer for bailing me out of this particular incident. After surfing around throughout the the web and finding opinions which were not powerful, I assumed my entire life was well over. Living devoid of the solutions to the problems you’ve solved through the site is a critical case, as well as the ones which could have negatively affected my career if I had not encountered the blog. Your own personal expertise and kindness in playing with everything was important. I don’t know what I would’ve done if I hadn’t come upon such a point like this. It’s possible to at this time look forward to my future. Thanks a lot very much for the expert and amazing help. I will not think twice to endorse your web site to anybody who needs direction on this subject.

    Reply

  131. Thanks for all your valuable labor on this web page. My mother enjoys managing internet research and it is obvious why. We learn all of the compelling medium you render very helpful things on the web blog and in addition boost response from other people about this concept then our favorite daughter is without a doubt starting to learn so much. Enjoy the rest of the year. Your doing a glorious job.

    Reply

  132. Thank you for each of your labor on this blog. My mom really likes going through research and it is simple to grasp why. All of us notice all of the dynamic tactic you deliver valuable guidance by means of the web blog and boost contribution from other ones about this theme so our favorite daughter has been studying a lot. Have fun with the rest of the year. You are always conducting a first class job.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *