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...
By now you probably heard the news of the Oracle Database 11g Release 2. It is available and comes with a number of very interesting features for data...
By now you probably heard the news of the Oracle Database 11g Release 2. It is available and comes with a number of very interesting features for data warehousing.Obviously now you want to try this, so here is the download site for the software (OTN License required of course). The data warehouse collateral can be found on OTN as well, so here is the link for that.I would recommend everyone to first and foremost read the update on what the Oracle Database offers for data...
By now you probably heard the news of the Oracle Database 11g Release 2. It is available and comes with a number of very interesting features for data warehousing.Obviously now you want to try this,...
Got this comment on the blog from Satish. Satish is proposing (or forced) to create backup tables instead of using partitioning. I'm not sure you want to go...
Got this comment on the blog from Satish. Satish is proposing (or forced) to create backup tables instead of using partitioning. I'm not sure you want to go there.If you do, I think you will need to create views to show the data as a single entity, this means that you need to change the application to read from the views rather than from the original tables (or rename the tables first, then create views with the original names). You then want to compress the backup tables. So...
Got this comment on the blog from Satish. Satish is proposing (or forced) to create backup tables instead of using partitioning. I'm not sure you want to go there.If you do, I think you will need...
Got a little busy there with all the comments on the Netezza posting, but now we're back into some of the outstanding topics. This post is the next one on...
Got a little busy there with all the comments on the Netezza posting, but now we're back into some of the outstanding topics. This post is the next one on discussing some of the ODTUG session questions (see this post).One of the questions was about the use of partitioning and whether it is made obsolete by Exadata off-loading...In other words, should you look at one, the other or both? The answer is that you will want both, and there are a variety of reasons for that.First of...
Got a little busy there with all the comments on the Netezza posting, but now we're back into some of the outstanding topics. This post is the next one on discussing some of the ODTUG...
This is your chance to learn from the experts in development. Maria is going to do a webcast in the BIWA TechCast series on the optimizer. August 5, 9am Pacific...
This is your chance to learn from the experts in development. Maria is going to do a webcast in the BIWA TechCast series on the optimizer. August 5, 9am Pacific Time.Since its introduction in Oracle7, people have been fascinated and intimidated by the cost-based optimizer and the statistics it relies on. While the Optimizer becomes more and more transparent and requires less and less attention, still a lot of people feel 'left out' and consider whatever happens inside the...
This is your chance to learn from the experts in development. Maria is going to do a webcast in the BIWA TechCast series on the optimizer. August 5, 9am Pacific Time.Since its introduction in Oracle7,...
