Pfff, it took me a while to finally post my thoughts on ODTUG this year, and now I'm reading Mike telling us all to sign up for the super-early-bird special for...
Pfff, it took me a while to finally post my thoughts on ODTUG this year, and now I'm reading Mike telling us all to sign up for the super-early-bird special for Kscope11... man, I'm getting old and slow as I'm just about to write a bunch of stuff on the 2010 show... You have to be there next year! Ok, I am biased, this 2010 show was my 8th time in succession and I think every year is better than the year before. It was quite fun to be back in DC and to watch the worldcup as...
Pfff, it took me a while to finally post my thoughts on ODTUG this year, and now I'm reading Mike telling us all to sign up for the super-early-bird special for Kscope11... man, I'm getting old...
One of the things that I did not talk about in the initial partition wise join post was the effect it has on resource allocation on the database server. When...
One of the things that I did not talk about in the initial partition wise join post was the effect it has on resource allocation on the database server. When Oracle applies a different join method - e.g. not PWJ - what you will see in SQL Monitor (in Enterprise Manager) or in an Explain Plan is a set of producers and a set of consumers. The producers scan the tables in the the join. If there are two tables the producers first scan one table, then the other. The producers thus...
One of the things that I did not talk about in the initial partition wise join post was the effect it has on resource allocation on the database server. When Oracle applies a different join method -...
Some say they are the holy grail of parallel computing and PWJ is the basis for a shared nothing system and the only join method that is available on a shared...
Some say they are the holy grail of parallel computing and PWJ is the basis for a shared nothing system and the only join method that is available on a shared nothing system (yes this is oversimplified!). The magic in Oracle is of course that is one of many ways to join data. And yes, this is the old flexibility vs. simplicity discussion all over, so I won't go there... the point is that what you must do in a shared nothing system, you can do in Oracle with the same speed and...
Some say they are the holy grail of parallel computing and PWJ is the basis for a shared nothing system and the only join method that is available on a shared nothing system (yes this...
As a follow up on one of our older posts (here) I figured I should share the presentation and content I recently delivered at RMOUG in Denver. Some of the...
As a follow up on one of our older posts (here) I figured I should share the presentation and content I recently delivered at RMOUG in Denver. Some of the information can be found in this great paper on OTN, but I wanted to also share a little bit on the practical side of really applying this... One of the goals we set out for in 11g Release 2 of the database is to make life simple and easy when using parallel processing. Automatic DOP To make this all simpler for you, we are...
As a follow up on one of our older posts (here) I figured I should share the presentation and content I recently delivered at RMOUG in Denver. Some of the information can be found in this great paper...
Data models (like Oracle's Retail Data Model and the newly released Communications Data Model) have some interesting benefits - we think. The most commonly...
Data models (like Oracle's Retail Data Model and the newly released Communications Data Model) have some interesting benefits - we think. The most commonly mentioned one is that these models offer shorter time to value for a data warehouse or BI project. But is this really the only (ok, as if that is not enough) value that comes from a data model? I would hope the answer is "NO - there is soooo much more you get from using such a model". Data Models I do think there is much...
Data models (like Oracle's Retail Data Model and the newly released Communications Data Model) have some interesting benefits - we think. The most commonly mentioned one is that these models...
Various industry verticals are seeing vast amounts of data that is stored on file systems. These vast amounts of data are typically data that contains a lot of...
Various industry verticals are seeing vast amounts of data that is stored on file systems. These vast amounts of data are typically data that contains a lot of irrelevant detail and some gems useful for further analysis or enriching other data sources. Despite storing this data outside of the database some customers do want to integrate this data with data stored in the database. The goal of such integration is to extract information that is of value to the business users....
Various industry verticals are seeing vast amounts of data that is stored on file systems. These vast amounts of data are typically data that contains a lot of irrelevant detail and some gems...
Exciting times! Well yes the performance piece here is cool and reducing cost is obviously something exciting, but the most exciting thing to happen is that...
Exciting times! Well yes the performance piece here is cool and reducing cost is obviously something exciting, but the most exciting thing to happen is that Sinterklaas is about to come and bring us cool presents... December 6th is his birthday and all Dutch folks get nice gifts from him on the evening before his birthday... boy am I glad I'm Dutch :-) Anywho, you don't want to read about Dutch folklore but about serious matters around performance and reducing cost. As part...
Exciting times! Well yes the performance piece here is cool and reducing cost is obviously something exciting, but the most exciting thing to happen is that Sinterklaas is about to come and bring us...
How best to manage security within the data warehouse is a huge subject area to cover. In previous postings on this blog I have looked at how to secure the...
How best to manage security within the data warehouse is a huge subject area to cover. In previous postings on this blog I have looked at how to secure the transmission of sensitive data over your corporate network. This helps ensure line sniffers cannot pick up useful information by simply watching the packets go round the network.Taking security to the next level is all about understanding who (or what) is accessing your data warehouse and exactly what they are doing to the...
How best to manage security within the data warehouse is a huge subject area to cover. In previous postings on this blog I have looked at how to secure the transmission of sensitive data over your...
While I was looking at the Edition-based Redefinition I was puzzled by, or thinking about the performance of large data volumes moving across the edition. So I...
While I was looking at the Edition-based Redefinition I was puzzled by, or thinking about the performance of large data volumes moving across the edition. So I started thinking about how do I get that trigger to do stuff in parallel. Turns out I was thinking upside down... or inside out is maybe better. In 11g Release 2 a new DBMS package is introduced called DBMS_PARALLEL_EXECUTE, and in the RUN_TASK procedure it allows me to actually fire a cross-edition trigger, and there...
While I was looking at the Edition-based Redefinition I was puzzled by, or thinking about the performance of large data volumes moving across the edition. So I started thinking about how do I get...