11g data warehousing

internal training video for Data Warehousing and Business Intelligence
March 13, 2007

Willie Hardie
George Lumpkin
Hermann Beyer

Goal is to provide a single comprehensive platform for DW (data warehouse) and BI (business intelligence). Embed data quality and integration.

New features for 11g

  • manageability
    • partition enhancement
    • tuning
    • optimizers
    • parallel query
    • ASM updates
    • data compression
  • VLDB
  • Performance with cache
  • Data loading
  • New SQL commands
  • OLAP
  • Data mining

Result cache – caches results of queries, query blocks, or function calls. This cache is shared across statements and sessions on server. Significant speed up for read-only and read-mostly data.

Information appliance initiative – preconfigured data warehouse solutions from HP, IBM, Sun, and Dell.

OLAP – make OLAP a standard feature of every data warehouse. Allow any SQL application to leverage OLAP performance. Excellent query performance for ad-hoc queries. Optimized incremental refresh and aggregation. New feature is cube organized materialized views. Fast incremental update and aggregation. Transparent access by SQL based applications. Works with range of tools (OBIEE, BO, Cognos, Hyperion, MicroStrategy).

Data Mining – simplified development and deployment of models. Supermodels, general linear models, multivariate linear regression, logistic regression

355 thoughts on “11g data warehousing”

  1. I and my buddies were actually examining the nice things located on the blog and then unexpectedly got an awful feeling I never thanked the site owner for those techniques. All of the boys are actually as a consequence happy to see all of them and already have extremely been having fun with them. Thank you for truly being simply considerate as well as for going for such high-quality themes millions of individuals are really wanting to be informed on. Our own honest apologies for not expressing appreciation to you earlier.

  2. I simply desired to say thanks all over again. I do not know what I would’ve worked on without the actual information shown by you on such a topic. It actually was a real scary setting in my view, nevertheless noticing a expert style you dealt with it made me to leap with delight. I’m thankful for this support and thus sincerely hope you really know what a powerful job you are always carrying out teaching most people all through your website. I am sure you’ve never come across all of us.

  3. I simply wished to say thanks all over again. I do not know the things that I might have followed in the absence of the entire concepts discussed by you relating to this subject. It had become a fearsome situation in my circumstances, nevertheless being able to see a new specialized approach you solved it made me to jump for delight. Now i’m happy for the support and then expect you know what an amazing job your are undertaking educating the others all through your site. Most probably you have never encountered any of us.

  4. I must show my appreciation to this writer for rescuing me from such a issue. After surfing around through the world-wide-web and meeting tricks which were not powerful, I assumed my entire life was over. Being alive without the answers to the issues you have resolved by way of your main report is a serious case, as well as the kind which might have adversely damaged my career if I hadn’t discovered your web blog. Your primary skills and kindness in taking care of the whole thing was precious. I’m not sure what I would’ve done if I hadn’t come across such a thing like this. I can also at this point relish my future. Thanks so much for this skilled and result oriented guide. I won’t think twice to recommend the blog to any person who will need guide about this issue.

  5. I wish to get across my gratitude for your kind-heartedness supporting those individuals that should have guidance on this particular study. Your special commitment to passing the solution up and down became amazingly important and have surely empowered somebody just like me to reach their goals. This useful publication entails so much a person like me and even further to my office colleagues. Thank you; from everyone of us.

  6. I intended to send you this little bit of word just to thank you once again about the stunning things you have featured at this time. It was pretty generous with people like you to convey unhampered just what a few individuals might have made available for an electronic book to help with making some money on their own, most notably considering the fact that you could possibly have tried it if you ever considered necessary. Those good tips also served as the fantastic way to realize that many people have the identical keenness the same as mine to know more and more when considering this issue. Certainly there are numerous more pleasant instances ahead for many who looked at your site.

  7. I am just commenting to make you be aware of of the cool discovery my wife’s daughter undergone checking your blog. She mastered a wide variety of things, including how it is like to possess an awesome helping style to have other folks completely fully grasp specific extremely tough matters. You actually did more than visitors’ expected results. Thank you for imparting these great, trusted, informative and even easy thoughts on that topic to Evelyn.

  8. Thanks for every one of your hard work on this blog. Debby take interest in going through investigation and it’s obvious why. We all know all relating to the powerful means you produce insightful guidelines through your web blog and as well attract contribution from some other people on this topic while our own daughter is without a doubt becoming educated a lot of things. Have fun with the remaining portion of the year. You’re performing a very good job.

  9. I actually wanted to construct a simple remark to be able to thank you for some of the awesome solutions you are giving out at this site. My long internet research has now been recognized with professional suggestions to exchange with my friends. I ‘d mention that most of us website visitors actually are truly lucky to exist in a really good place with very many lovely individuals with good principles. I feel extremely grateful to have encountered the web pages and look forward to some more enjoyable times reading here. Thanks a lot once again for everything.

  10. I intended to compose you that little remark just to give many thanks the moment again considering the lovely secrets you have contributed in this case. It’s simply unbelievably open-handed with people like you to give easily what exactly numerous people might have offered for an e-book in making some profit on their own, primarily seeing that you might have tried it in the event you decided. Those guidelines also worked like a fantastic way to know that the rest have the same passion much like my own to find out a good deal more with regard to this issue. I’m sure there are lots of more enjoyable situations in the future for people who read through your blog post.

  11. I want to show my appreciation to you just for rescuing me from such a difficulty. Right after researching through the search engines and seeing opinions that were not powerful, I thought my life was over. Living devoid of the approaches to the problems you’ve fixed all through your entire article content is a critical case, as well as the ones which may have badly affected my entire career if I hadn’t encountered the website. Your talents and kindness in touching all areas was priceless. I don’t know what I would’ve done if I had not encountered such a solution like this. I can at this moment relish my future. Thanks a lot very much for the reliable and amazing guide. I will not think twice to recommend the sites to any individual who needs counselling on this subject.

Leave a Reply

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