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....
I figured, since we proclaim data warehousing such a broad area to venture out and look at some of the data mining functionality in the database. Now I'm only...
I figured, since we proclaim data warehousing such a broad area to venture out and look at some of the data mining functionality in the database. Now I'm only scratching the surface of that wonderful world here, but I figured it is worthwhile.We used a couple of things here, one is OWB (Oracle Warehouse Builder) the other is the data mining option in Oracle Database 11g.Supermodels; you are kidding right?Well actually we are not and that is of course why you are reading this....
I figured, since we proclaim data warehousing such a broad area to venture out and look at some of the data mining functionality in the database. Now I'm only scratching the surface of that...
I was thinking back to the Warehouse Builder days and the pivot and unpivot operators we built into the tool. Wanted to check out the SQL commands in 11g and...
I was thinking back to the Warehouse Builder days and the pivot and unpivot operators we built into the tool. Wanted to check out the SQL commands in 11g and see how that works, so I dug around in the documentation.First thing I noticed is that we use EXTRACT in the pivot example, and I somehow missed the fact that we have that as syntax in Oracle. I haven't figured out when we introduced that (if anyone has the answer let me know)...Anyways, and in no means to be complete...
I was thinking back to the Warehouse Builder days and the pivot and unpivot operators we built into the tool. Wanted to check out the SQL commands in 11g and see how that works, so I dug around in...
I'm not sure everyone is aware of the fact that you can use external tables these days to work with data pump export files. You can read in data using an...
I'm not sure everyone is aware of the fact that you can use external tables these days to work with data pump export files. You can read in data using an external table, or you can unload data. For more information on this one read the actual syntax here.Very recently, that is as in 11.1.0.7 of the RDBMS we also added something called pre-processing to the external table syntax. Here is a small syntax example in "pseudo code":CREATE TABLE sales_external(…)ORGANIZATION...
I'm not sure everyone is aware of the fact that you can use external tables these days to work with data pump export files. You can read in data using an external table, or you can unload data. For...
