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...
Or, how can I use 11gR2 to update my operational data warehouse with real time data loads and still patch the schema to deal with errors or with upgrades due to...
Or, how can I use 11gR2 to update my operational data warehouse with real time data loads and still patch the schema to deal with errors or with upgrades due to changing business demands. The Theory In a time when the data warehouse was refreshed weekly (wow, that often?) fixing the schema or the data was a piece of cake. The data was static, the users were querying (you hoped) away and you could tinker with the schema without really making a mess of it all. Take the DW down...
Or, how can I use 11gR2 to update my operational data warehouse with real time data loads and still patch the schema to deal with errors or with upgrades due to changing business demands. The Theory...
The Map-Reduce model has become a popular way for programmers to describe and implement parallel programs. These custom map-reduce programs are often used to...
The Map-Reduce model has become a popular way for programmers to describe and implement parallel programs. These custom map-reduce programs are often used to process a large data set in parallel. This post shows how to implement Map-Reduce Programs within the Oracle database using Parallel Pipelined Table Functions and parallel operations. The Theory Pipelined Table Functions were introduced in Oracle 9i as a way of embedding procedural logic within a data flow. At a logical...
The Map-Reduce model has become a popular way for programmers to describe and implement parallel programs. These custom map-reduce programs are often used to process a large data set in parallel. This...
As promised, the next entry in our 11gR2 explorations is In-Memory Parallel Execution. If you are going to Oracle OpenWorld next month make sure you check out...
As promised, the next entry in our 11gR2 explorations is In-Memory Parallel Execution. If you are going to Oracle OpenWorld next month make sure you check out the following session: Tuesday, October 13 2009 5:30PM, Moscone South Room 308Session S311420 Extreme Performance with Oracle Database 11g and In-Memory Parallel Execution.In this session you will get more details and insight from the folks who actually built this functionality! A must see if this is of any interest, so...
As promised, the next entry in our 11gR2 explorations is In-Memory Parallel Execution. If you are going to Oracle OpenWorld next month make sure you check out the following session: Tuesday, October...
What are we announcing, well... you just have a look over here:http://www.oracle.com/features/larry-ellison-webcast.htmlLarry Ellison will be introducing a very...
What are we announcing, well... you just have a look over here:http://www.oracle.com/features/larry-ellison-webcast.htmlLarry Ellison will be introducing a very cool new offering into the market. The webcast is tomorrow (Tuesday) September 15 at 1pm Pacific Time.Tune in, or come back after the session and read all about it here...
What are we announcing, well... you just have a look over here:http://www.oracle.com/features/larry-ellison-webcast.htmlLarry Ellison will be introducing a very cool new offering into the market. The...
