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,...
Continuing on with this theme of securing your data warehouse…The next stage, having secured the transmission of all data be accessed via SQL net, is to make...
Continuing on with this theme of securing your data warehouse…The next stage, having secured the transmission of all data be accessed via SQL net, is to make sure that all tools and applications, or as many as possible, use these encrypted network transmission processes. Lets look at some of these tools in more detail:SQLDeveloperThis requires the use of SQLDeveloper 1.5 or later. There are a number of ways to configure database connections in SQLDeveloper and SQLDeveloper...
Continuing on with this theme of securing your data warehouse…The next stage, having secured the transmission of all data be accessed via SQL net, is to make sure that all tools and applications, or...
Does anyone take data security within their warehouse seriously? This is not a trick or facetious question because, according to news posting on the web a few...
Does anyone take data security within their warehouse seriously? This is not a trick or facetious question because, according to news posting on the web a few weeks ago most of the major systems, including the data warehouse, of a well-known Telco company were hacked. This made me wonder: how secure are most data warehouses?In general, when analysts and consultants take about data security the emphasis, or perceived emphasis, seems to be on the operational systems especially...
Does anyone take data security within their warehouse seriously? This is not a trick or facetious question because, according to news posting on the web a few weeks ago most of the major...
Just for being complete and to update people on a minor detail, here is a quick example of a data pump driven External Table.SQL> CREATE TABLE EMP_50 2...
Just for being complete and to update people on a minor detail, here is a quick example of a data pump driven External Table.SQL> CREATE TABLE EMP_50 2 ORGANIZATION EXTERNAL 3 ( TYPE oracle_datapump 4 DEFAULT DIRECTORY dmp_dir 5 LOCATION (‘emp_50.dmp')) 6 ) 7 AS SELECT * FROM EMPLOYEES WHERE DEPARTMENT_ID = 50 8 ;Table CreatedSQL> SELECT COUNT(1) FROM EMP_50; COUNT(1) ---------- 45There are a couple of things here. First of all, you can happily use the wildcards in the select...
Just for being complete and to update people on a minor detail, here is a quick example of a data pump driven External Table.SQL> CREATE TABLE EMP_50 2 ORGANIZATION EXTERNAL 3 ( TYPE oracle_datapump 4...
After writing the post on the ETL part I was talking to folks over here and we discussed some other interesting aspects of using time windows and "AS OF" query...
After writing the post on the ETL part I was talking to folks over here and we discussed some other interesting aspects of using time windows and "AS OF" query patterns with ETL like scenarios.The scenario goes a little like this. You have a reporting environment on top of the data warehouse (daah, obviously) and want to make sure data that comes in and is loaded only gets published after it is checked within the context of the entire system.That means you need to do your...
After writing the post on the ETL part I was talking to folks over here and we discussed some other interesting aspects of using time windows and "AS OF" query patterns with ETL like...
It is time to tune in to Kevin Closson's next deep dive into the Exadata secret sauce. He will be doing part III of his deep dive series via IOUG. Here are the...
It is time to tune in to Kevin Closson's next deep dive into the Exadata secret sauce. He will be doing part III of his deep dive series via IOUG. Here are the details:IOUG EXADATA SIG Webinar on May 19, 12:00PM - 1:00 PM CDT Title: Oracle Exadata Storage Server Technical Deep Dive: Part IIITopic: The "Division of Work" - Quantifying the "Heavy Lifting" Done By the Storage Grid CPUsThis is the third webinar in the series of the Oracle Exadata Storage Server Technical Deep...
It is time to tune in to Kevin Closson's next deep dive into the Exadata secret sauce. He will be doing part III of his deep dive series via IOUG. Here are the details:IOUG EXADATA SIG Webinar on May...
First of all, this is not a recall notice for your data warehouse...! This is one of those cool features that come with Oracle 11g that I think is usable in a...
First of all, this is not a recall notice for your data warehouse...! This is one of those cool features that come with Oracle 11g that I think is usable in a different context (e.g. Data Warehousing).The first thing I dreamed up here, and I'm sure others have thought about this, is the usage of flashback features in ETL. Every ETL system that I know has a construct built in to remove "incorrect" data. Incorrect here is simply a load that did for some reason more harm than...
First of all, this is not a recall notice for your data warehouse...! This is one of those cool features that come with Oracle 11g that I think is usable in a different context (e.g....
